Apoorva Singh

● Customer Experience Analytics: Analyzed ETD notification impact on NPS to drive a CEO-prioritized initiative—improving NPS for delayed flights from negative to positive.
●Operational Performance Insights: Delivered analytical insights to the Houston Airport network team, identifying patterns in irregular ops and recommending hub-level optimizations using python, SQL and Powerpoint
●Delay Analysis: Investigated SNA–SFO morning delays (EDCT), recommending schedule shifts to improve on-time performance metrics.
●FAA Impact Study: Quantified how EWR FAA staffing shortfalls led to a 0.8-point system-wide decline in on-time performance.
● Crisis Strategy Assessment: Evaluated re-accommodation and cancellation decisions during IAD/EWR winter storms, providing data-backed suggestions to reduce disruption.
●Cost Savings via Fuel Analysis: Revived python and SQL based report and optimized United Express fuel tankering strategy, enabling over $1M in fuel savings.
●Report Automation: Migrated a high-priority daily ops report (used 365 days/year) from Excel/Python to Power BI + Power Automate, reducing processing time from 90 to 10 minutes.
●Dashboard Development: Built a historical ops dashboard in Power BI to provide quick access to multi-year data and trend analytics.
●Root Cause Evaluation: Assessed and improved a delay attribution algorithm; two of the team’s enhancement suggestions were implemented by the Chicago Ops team.
●Data Reliability Engineering: Developed a resilient data layer using Python and SQL, ensuring dashboard continuity during data outages.
● Fleet Strategy Analysis: Conducted deep-dive analysis of B767 widebody performance; recommended flying adjustments that increased reliability and reduce cancellations and delays.
● Deep Dive Analysis : Delivered multiple analysis on areas like Technical Operations, Vendor Operations Reliability, Key performance metrics and Mitigation strategy analysis during irregular operations for actionable insights presented to corporate and station leaders.

●Executive Reporting: Owned and automated a high-visibility performance deck using Think-cell, reducing preparation time by 75% and enabling weekly benchmarking against competitors.
● ETA Prediction Improvement: Utilized SWIM and FlightAware data with Teradata to evaluate and enhance ETA accuracy for inbound flights.
●Report Automation:Created and revamped 15+ cross-functional reports using Python, SQL, and Excel

• Contingency Modeling: Maintained 95%+ forecast accuracy during disruptions by analyzing data real-time and applying contingency
• Model Optimization: Streamlined Excel-based forecasting models, improving speed and reducing file size by 50%.
• Nominated for impact award as analyst in United Wonder Wings
• Customer Experience Analytics: Analyzed ETD notification impact on NPS to drive a CEO-prioritized initiative-improving NPS for delayed flights from negative to positive.

• Tool Development: Co-led launch of a Python-based Unified Planning Portal, reducing manual dependency and enhancing forecast accuracy.
• Deep Dive Analysis: Delivered multiple analysis on areas like Technical Operations, Vendor Operations Reliability, Key performance metrics and Mitigation strategy analysis during irregular operations for actionable.
• Root Cause Evaluation: Assessed and improved a delay attribution algorithm; two of the team's enhancement suggestions were implemented by the Chicago Ops team.
• Fleet Strategy Analysis: Conducted deep-dive analysis of B767 widebody performance; recommended flying adjustments that increased reliability and reduce cancellations and delays.
• Data Reliability Engineering: Developed a resilient data layer using Python and SQL, ensuring dashboard.
• Forecasting: Developed 90-day daily charge and shipment forecasts for 8000+ fulfillment nodes using historical trend analysis.