Syed Omair Jaffri
Dublin,CA
Summary
Specializing in automated data solutions and KPI development, enhancing operational performance in aviation and utilities. Developed SQL-based data validation and built dashboards that improved reporting efficiency and operational visibility, driving significant improvements in decision-making and resource utilization.
Overview
6
6
years of professional experience
Work History
Senior Data Analyst
Southwest Airlines
03.2023 - Current
- Partnered with data engineers to automate ETL workflows (dbt, Python, SQL), reducing manual reporting time by 40+ hours/month.
- Built Tableau and Looker dashboards to monitor crew scheduling efficiency and flight resource utilization, improving operational visibility by 30%.
- Conducted data integrity checks across Snowflake and Oracle, ensuring reliable performance metrics for executive reports.
- Developed KPI frameworks for passenger flow, cost, and time-on-ground analytics to facilitate data-driven optimization across routes.
- Collaborated with IT and business units to integrate energy-consumption and infrastructure reliability data into AWS dashboards, enhancing analytical insights.
Data Analyst
ADP
08.2021 - 02.2022
- Designed and deployed automated workforce performance dashboards using Excel VBA and Tableau, driving 20% improvement in reporting efficiency.
- Developed SQL-based data validation scripts, ensuring accurate payroll and HR metrics for executive distribution.
- Collaborated with compliance teams to align reporting on energy consumption and environmental metrics for HR facility operations.
- Led stakeholder workshops to translate data insights into actionable policy updates for cost optimization and workforce planning.
Data Analyst
Optum Global Solutions
01.2020 - 07.2021
- Analyzed claim cost trends using SQL and Excel Power Query to uncover performance improvement opportunities.
- Designed and maintained daily data pipelines for healthcare operations data, improving reporting accuracy and turnaround time by 25%.
- Collaborated with cross-functional teams to automate report generation, saving 15+ analyst hours weekly.
- Created executive dashboards to track energy, resource utilization, and operational efficiency across business units.
Education
Master of Science - Information Technology Management
Indiana Wesleyan University
Marion, IN08-2024
Skills
- SQL queries
- Data visualization
- Tableau dashboards
- Data warehousing
- Data quality
- Data validation
- ETL automation
- Data modeling
- Data mining
- Microsoft Visio
- Git
Timeline
Senior Data Analyst
Southwest Airlines
03.2023 - Current
Data Analyst
ADP
08.2021 - 02.2022
Data Analyst
Optum Global Solutions
01.2020 - 07.2021
Master of Science - Information Technology Management
Indiana Wesleyan University