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 solutions
- Generate and distribute management reports in accurate and timely manner
- Analyse current and past trends in key performance indicators including all areas of planning, Scheduling, actuals
- Monitor performance indicators, highlighting trends and analysing causes of unexpected variance
- Proactively 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 tools
- Quarterly and Monthly Presentations
- Analyse complex schedule & planning information and reports to provide accurate and timely recommendations to management for decision making purposes
- Study 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 & water tight gap to goal analysis both for cockpit & cabin
- Presenting information through reports and visualization
- Translate business needs to technical specifications
- Develop solutions on various reporting objects like SQL/Power BI/MS Access as per requirement
- Creation of intelligent/smart dashboards in Power BI platform, data mining, handling large data sets
- Collaborate with teams to integrate systems
