Data Analyst
Name: Jeffrey Gemmell
Location: Greater Seattle Area
Degree: BA (2024)
Phone: 253.861.0395
Email: jeffrey.gemmell@outlook.com
Skills
Data Analysis & Visualization
Python: ETL, Automation, Report building
Tableau/Power Bi Dashboard Development
SQL, Teradata
Experience
Data Analyst - Delta Airlines 2021 - Present- Built analytical tool using Python for forecasting staffing and equipment needs during inclement weather and irregular operations.
- Created scorecards and dashboards that are used systemwide to improve operational performance using Tableau.
- Automated reports using Python which saved more than 40 hours of work hours per month.
- Mentored team on transitioning from SAS to using Python and Tableau.
- Created an internal website for analytics documentation and resources for stakeholders to easily find the data that they need.
- Created a tool used throughout Delta for accessing employee rosters.
- Develop, implement, and maintain Tableau dashboards
- Used Python to create ETL pipelines, automations and reports
- Ground flight operations
- Baggage and cargo logistics
Education
William Woods University 2022 - 2024
Fulton, Missouri
Bachelor of Business Administration - Management Information Systems
Eastern Gateway Community College 2020 - 2022
Steubenville, Ohio
Associate's Degree - Business and Software Development
DASHBOARDS
Airline Price Trends and MBR- Analysis by year of the most expensive domestic flight routes by fare, price per mile and price per passenger flown on the route.
- Average prices compared between the carriers.
- Price trends between 1996 and 2021 including price gap of the least expensive and most expensive fares.
- Price map by origin city.
- Mishandled Bag Rates (MBR) by carrier between 2019 and 2021 using the most current KPI calculation of mishandled bags per 1000 bags emplaned.
- Data sourced from Consumer Airfare Report October 2022, create by the U.S. Department of Transportation.
- Employee scorecard that uses industry standard metrics for tracking performance.
- Employee performance directly effects the ability for flights to depart on time.
- Flight delay data sourced from the Bureau of Transportation Statistics
- Employee, bag count, and cargo weight data generated using Python.
CODE
Flight Data Creator- This project was created to generate then merge employee, bag and cargo data with the airport delay data to be used in the Airline Employee Scorecard.
- Raw delay data is used from the Bureau of Transportation Statistics, while all of the employee data is generated in the program itself including names, employee numbers, regular days off and shift times.