Archi Agarwal

Assistant Manager – Data Analytics & Business Intelligence

IndiGo Airlines

Apr 2022 - Present

Developed and deployed 12+ enterprise Power BI dashboards used by Operations, Resource Planning and Leadership teams, enabling data-driven decisions and reducing manual reporting effort by 70%. Designed complex SQL queries and automated data pipelines supporting reporting across 20+ operational datasets, improving data availability and processing efficiency by 30%. Performed KPI analysis, forecasting, trend analysis, and operational performance assessment to support strategic planning and resource allocation decisions. Developed analytics solutions supporting 200+ airport locations and 2,000+ daily operational movements across large-scale operational datasets. Developed a resource optimization framework covering 200+ airport stations, analyzing rolling 90-day flight schedules to forecast peak equipment requirements and support resource planning decisions. Partnered with cross-functional stakeholders to translate business requirements into analytics solutions and actionable performance insights. Automated recurring business reports using Excel VBA and macro/s, saving 100+ analyst hours annually. Designed and maintained flight disruption reporting frameworks and executive dashboards, improving incident visibility and reporting efficiency by 80%. Performed network planning and operational analytics to support schedule optimization, seasonal planning, and competitive benchmarking. Mentored and trained new analysts on reporting processes, data validation practices, SQL querying and dashboard usage.