Revenue Management Analyst

GURWINDER SINGH

*** ****** ****** 347-***-****

LINDEN, NJ 07036 adgv4h@r.postjobfree.com

Work Experience

American Airlines - Ancillary & Distribution Development Analyst 12/2019-06/2020

• Conduct A/B Testing on ancillary products to generate incremental revenue during challenging times of Covid-19. Led to the changes in American Airlines upgrade product (LFBU) pricing to stimulate passenger upsell take rate into First/Business Class cabin.

• Demonstrating proficiency in data mining using SQL and SAS programs, exporting to Tableau, and creating Dashboard which assist revenue organization in tracking performance metrics. Saves 10 hours of ad-hoc analysis weekly across 7 peers to quickly identify issues and gather complex data and present to leadership monthly.

• Tracking Yr/Yr trends generating $3B through ancillary products in 2019 and implementing strategies to increase market share by 5-8% and substantially increasing GTM speed.

• Continuous improvement to upgrade and seat products collaborating with Stakeholders with meaningful insight to maximize revenue, creating new revenue stream by introducing Airline Miles as a form of payment for ancillary product purchases.

American Airlines – Revenue Management Analyst 07/2016-12/2019

• Owned $350M market portfolio and took calculated risks to test market boundaries to drive a 3% revenue gain.

• Coordinated cross-functionally with sales and externally with tourism partners at ski destinations to leverage discounts and maximizing revenue and recommending a cost benefit analysis for a 15% discount to be revenue optimal.

• Led analysts in domestic premium cabin management in the 4th quarter of 2019, our revenue strategies increased premium paid seats occupancy by 11% Yr/Yr, resulting in an increase of $6 million in the premium cabin.

• Achieved forecast enhancements monitoring market demand trends, reviewing competitor pricing framework to understand best practice framework to maximize revenue.

• Using Pivot tables and VLOOKUP preparing KPI reports to correct forecast inaccuracies monitoring past and future demand forecast and making decisions based on market management experience. Project Management

• Data analysis on using SQL and T100 (DOT database) to set expectations for new market Fairbanks, Alaska and relaying customer behavior trends using flown history to forecast revenue potential to stakeholders in Network Planning and Pricing.

• Key market profile manager for Hawaii spokes, coordinated domestic yield and pricing systems. Handled the analysis and strategy of Southwest entry in Hawaii.

• Project lead in managing NCAA Tournament in San Antonio in 2018, identified peak traffic patterns and optimized revenue by controlling inventory for higher yielding traffic. Provided weekly updates to network planning, domestic pricing, and airport management on yield and occupancy on aircraft. Project resulted in an additional $1.5 Million in Yr/Yr revenue.

• In charge of the Toronto Film Festival 2018 strategy, using historical flown performance devised a proposal, final recommendations included aircraft swap generating $440,000 of additional revenue due to larger premium capacity. Leadership Experience

• Creating best practices and training the department on a business process for upper cabin management, effective prioritization of the ROI with meaningful interactions.

• Teaching the importance attributes such as length of haul, product and schedule play in customer behavior and providing the best overall service as a route might demand.

• Mentoring co-workers on problem solving scenarios pertaining to revenue management. How to take calculated risks and driving positive revenue performance.

• Created and performed new hire trainings to new members of the department. Education

Embry-Riddle Aeronautical University Daytona Beach, FL Bachelor of Science in Aviation Business Administration Graduation Date- 05/2016 Languages

• English - Punjabi - Hindi

Skills

• Tableau • SAS Studio • Project Management • Microsoft Office

• SQL • Research and Development • Team Coordination • Feasibility Studies

Contact this candidate