JOB DESCRIPTION
- Position : Senior Executive–Resource Planning and Analytics
- Reporting To : Manager – OCC
- Company : IndiGo
4. Location : ISC-Gurgaon
5. Purpose : Support crew planning & manpower planning teams with daily / weekly / monthly analysis for constructive roster through pre-assignment, published & actual analysis, ownership of standby planning & utilization, maintain robust short term planning variances, own and manage reporting on various KPIs
Work on Automation / SQL / Power BI dashboard / MIS / Analytics (incl. Stats) to improve OCC function
Responsibilities :
Designing, developing and maintaining business intelligence solutionsGenerate and distribute management reports in accurate and timely mannerAnalyse current and past trends in key performance indicators including all areas of planning, Scheduling, actualsMonitor performance indicators, highlighting trends and analysing causes of unexpected varianceProactively bringing issues and problems to the attention of the team; generating, proposing and implementing innovative solutions as resolutions to any problems and issues.Oversee and manage the continued development of Budgeting, KPI Forecasting, Operating Plan and Modelling toolsQuarterly and Monthly PresentationsAnalyse complex schedule & planning information and reports to provide accurate and timely recommendations to management for decision making purposesStudy and analyse information about alternative courses of action to determine which plan will offer the best outcomes to cost, efficiency and feasibility to business.Define data requirements, gather & validate information, apply judgment & statistical tests.Close tracking of planned vs. actual & watertight gap to goal analysis both for cockpit & cabinPresenting information through reports and visualizationTranslate business needs to technical specificationsDevelop solutions on various reporting objects like SQL / Power BI / MS Access as per requirementCreation of intelligent / smart dashboards in Power BI platform, data mining, handling large data setsCollaborate with teams to integrate systemsLI-6ERecruit