
Timeline
Skills
AirlinesMisProject planningTeam managementBusiness strategyAnalysisRevenue analysisPerformance managementAnalystStatisticianAbout me
Specialties: Statistical analysis, Management Information System, Project Management (EIS), IATA certified in Route Forecasting & Development; IATA certified (Airline Business Management); IATA certified in Lean Six Sigma in Aviation; Querying, Managing and Administering Databases using SQL Server
Education

D.b.r.ambedkar university, agra
2001 - 2003Masters of statistics statistics, mathematics
R.b.s. degree college, agra
2000 - 2001Bachelor's degree mathematics and statisticsActivities and Societies: Basketball, Korfball
Experience

Spicejet limited
Nov 2005 - Mar 2023Former Profile:Creation of model of installing Service Quality System.Internal Opinion Measurement: Creation of measurement forms, evaluation process,individual staff performance and management reports.Airport Performance: Data collection and measurement of daily airport departure andarrival statistics and individual performance;Monthly Audits: Conduct audits on the monthly basis at Spicejet's operational stationsbased on different parameters;Analysis vis-à-vis standards, and individual delay arrival anddepartures;Service Quality Control: Developing Mean Charts, R-Charts based on the above tools;Project & Analysis of new Spicejet's operating International AirportEIS & Analysis on Q400 aircraft inductionCorporate PresentationsCurrent Profile:Analysing and creating monthly DGCA Traffic Reports to be published on DGCA official website.Working on various Management Report structures and development.Monthly, Quarterly & Annually ‘Management Dashboard’ of company’s KPIs for Higher Management review.Working on Navitaire Software to prepare the day to day booking revenue and operational reports.Management Information System: Daily MIS | Morning Glance report Overall, Boeing and DHC-8-Q400 separately analyzing revenue and traffic data.Collection and analyzing of all operational matrices of the competitive airlines;Monitoring daily On Time Performance of every individual station;Route-wise Analysis, Route profitability;Daily forward sales analysis reports (based on Sector; Flights)Analyzing daily on forward booking curve and forecasting.Problem child analysis reports (based on Sector; Flights)Weekly sales and revenue management analysis dashboardMonthly operational analysis reports (on Aircraft; Operating Stations; Rotational; Sector; Flights)MIS on Incentive payout; Setting the Targets & Reconciliation based on the actual data.Day-to-Day booking, forward loads, revenue etc. data crunching from Operational Data Store (ODS) and analyzing. Show less
General Manager - MIS, Revenue Management, Commercial
Oct 2021 - Mar 2023Deputy General Manager - MIS
Apr 2018 - Mar 2023Senior Manager-MIS, Revenue Management, Commercial
Nov 2005 - Mar 2023Deputy General Manager - MIS
Nov 2005 - Mar 2023

Akasa air
Mar 2023 - nowGeneral Manager - Operations Excellence
Jun 2023 - nowGeneral Manager
Mar 2023 - nowGeneral Manager
Mar 2023 - Mar 2023General Manager
Mar 2023 - Mar 2023
Licenses & Certifications

Querying, managing and administrating databases using sql server
.webp)
Iata certified, lean - six sigma in aviation
International air transport association (iata)Jun 2017.webp)
Iata certified in route forecasting and development
International air transport association (iata)Jun 2019
Pursuing post graduation program in data science
UpesJul 2021.webp)
Iata certified in airline business management
International air transport association (iata)
Languages
- enEnglish
- hiHindi
Recommendations

Juan sebastián aceves medina, cfa
Director | Team Leader – Structured & Corporate Finance | CFA Charterholder | Credit Risk & Debt Str...Mexico City Metropolitan Area
Teresa lewis
Bookkeeper AccountantCam, England, United Kingdom
Rakesh singh
Procurement Manager at FFS RefinersDurban Metropolitan Area
Shobha khokhar
Team Mentor || Basware || Customer ServicesChandigarh, India
Jozef barniak
Professional Negotiator & Performance Leadership Trainer | Co-Founder of Explore Discomfort | Execut...Bratislava, Slovakia
Henrique nunes
Director de Obra at Grupo CasaisLisboa, Lisbon, Portugal
Giovanni fabris
Assistente Amministrativo e Digital Project ManagerVenice, Veneto, Italy
Oliver cottam
Senior Financial Account Manager at Aon GuernseyGuernsey
Aron sabavat
IBM Integration Bus developer, Senior Software Engineer, Middleware, IIB Websphere developer at Tech...Hyderabad, Telangana, India
Madelyn guerra
Student at Loyola University New OrleansNew Orleans, Louisiana, United States
...