SURAJ K B

Dashboard: Airline Pricing Analytics

• Designed a Tableau dashboard to identify trends in flight load factors, compare against competition, track year-over year bookings and revenue to help airline price their seats optimally.
• Helped generate 13-15% average monthly incremental revenue from Caribbean Airlines, Gulf Airways and Virgin Australia by reducing 75% of their manual pricing efforts.
• Developed data engineering pipelines for automation and daily updating of the dashboard using BigQuery and PySpark.

Price-Demand Elasticity Calibration

• Consulted Jet Blue Airlines, Aegean Airlines and Sky Express Airlines on their daily pricing challenges to shape a price sensitivity Machine Learning model.
• Deduced a price vs demand curve using SciPy curve fit logistic regression function in Python using 1-year historic data to identify passengers' upsell opportunities and willingness to pay trends and hosted it in AWS SageMaker.
• Generated the airlines a 5-7% incremental revenue for their Peak season (Nov-Jan months).

Airline Ancillary Bundling and Pricing

• Consulted Etihad Airways and Gulf Airlines to help incentivize seats along with ancillaries (food, beverages, extra leg-room) to boost revenues by 2-4%.
• Leveraged the Price-Elasticity model to make personalized ancillary bundle offers (food & extra leg-room, or cabin upgrades, etc.) to particularly price-sensitive passengers to help upsell and boost revenues.
• Increased loyalty passengers by 9-10% along with a boost in revenue.

Market Intelligence Tool

• Collated GDS pricing and network data for 400+ airlines across various regions hosted on multiple hosting systems like Sabre, Amadeus and Travelport.
• Developed ETL pipelines using PySpark for transforming this rich, complex data into simpler format that is fed into a downstream application for the end-user.
• Leveraged this tool to help 20+ airlines make informed pricing decisions by interactively displaying their capacity, market shares, competitors and passenger demand.

Product Consulting and Trainings

• Consulted airlines to understand their current pricing and revenue strategies and suggest best practices along with a 5-year forward looking revenue plan.
• Implemented Sabre's Pricing and Revenue Management product suite (Fares Optimizer & Revenue Optimizer) to 5+ airlines.
• Provided on-site consultation and training to nearly 50+ pricing and demand analysts for 15-30 days per airline.