Nicole Lopes Email & Phone Number

Houston, Tx, Us

Houston, Texas, United States

• Developed, enhanced, and maintained ETL processes for data incorporation from over 20 data sources into relational SQL Server database using C#, Python, and SQL stored procedures• Incorporated Azure Machine Learning Services to run proprietary models and return data to web application and relational database• Enhanced data warehouse architecture to accommodate data from new sources and models• Contributed and managed ELT data flow pipeline to acquire and store large data files and transform data points into usable and accessible format for analysis

Houston, Texas, United States

• Wrote APIs for internally used web app to access and display data• Uploaded and ingested data using AWS S3 buckets to acquire processed data from 3rd party vendors• Developed web application to ingest, process, and display real-time data from 3 different data sources across MLB, MiLB, and amateur games

Charlotte, North Carolina, United States

• Developed Python scripts to scrape data from multiple social media platforms, the US census, and profressional team websites using various APIs• Reformatted and summarized scraped data for incorporation into the existing data model• Analyzed information gathered from Python scripts against company brand database to help identify potential endorsement deals• Assisted in adjusting, building, and normalizing new company database• Used Natural Language Processing (NLP) techniques to analyze contact database and assign departments, hierarchies, and key contacts

Hawaiian Islands

• Worked with high school student athletes to improve various aspects of their game• Taught different course management and mental game strategies• Helped less experienced players learn the rules and basics of the game, while also learning to love and appreciate golf• Led varsity girls team to a win in their first tournament and a top 4 ranking in each of the tournaments played

• Improved efficiency of workforce environment by establishing a model based on people and time to calculate ramp staffing needs• Forecasted incoming cargo quantity for upcoming year• Collected and statistically analyzed incoming baggage data to determine baggage staffing needs

Carlsbad, California

• Cultivated metrics to analyze player skill level• Developed a ball-fitting algorithm based on metrics and individual preferences and incorporated algorithm into MATAB GUI• Organized and analyzed statistical information within player database to find patterns and correlations between different metrics

Honolulu, Hi

• Modeled and statistically analyzed operating procedures within Daniel K. Inouye International Airport (HNL)• Supervised initialization of a new system and calculated work limits to check processes to ensure compliance with airport regulations

Hawaiian Islands

• Inventoried hardware assets – laptops, monitors, servers, etc. – for the Hawaii State Teacher’s Association over five islands• Supervised disposal of fully depreciated equipment

Bachelor Of Science - Bs, Mechanical Engineering - Propulsion

Activities and Societies: Varsity Golf Team, Society of Women Engineers, Women in Aviation

High School Diploma