1 / 28

New York 2000 Jacques Cherrier

PNR database at AC Implementation overview and its usefulness for Network Management. New York 2000 Jacques Cherrier. The presentation. Update on AC’s PNR DB implementation Platform Delivered functionality Sharing experiences Contribution to Network management

sezja
Download Presentation

New York 2000 Jacques Cherrier

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PNR database at AC Implementation overview and its usefulness for Network Management New York 2000 Jacques Cherrier

  2. The presentation • Update on AC’s PNR DB implementation • Platform • Delivered functionality • Sharing experiences • Contribution to Network management • Current and potential usage

  3. PNR data base • One of the required step in AC’s migration towards OD Control • First business driver: support OD yield management • Became a foundation block for all other Network Management processes

  4. Choices • Transactional type architecture versus batch process • Bookings and cancellations passed in real-time to an off-line YM process • Capture all PNR data and distribute to requiring processes and systems • In-house development versus purchase

  5. Complex Problem • PNR data parsing • Limited prior expertise (Group bookings...) • Data base structure and architecture • Flight segments in OD • Technically robust • Could expand

  6. ACUMA - Speedwing • AC acquired Sales View • Speedwing developed the PNR data parser • Live and history part of the PNR • Most data elements translated into a formatted text file • Data base developed by ACUMA • Oracle • Business Object as the query driver

  7. Sales View basic features • Nightly capture of PNR changes • Include advance and departed bookings • All relevant data elements • Segment data • Passenger related items • Point Of sales, GDS…

  8. AC & ACUMA added the OD perspective to SV • Capture the passenger flow by Origin and Destination trips (MIDT type rules) • not just individual flight segments • Capitalize on the information available due to the introduction of OD control in RES • economic data (OD fare and bid prices) • married segments in OD...

  9. OD YYZ-LAX Also added the ODIF data base • Summary data base by flight, OD... • Provides view trough time (DCP’s)

  10. RES RS13 Nightly update DCS ODIF ORACLE PNR data Base Architecture Sales View

  11. Data stored • Sales View: • All currently active PNR’s up to start of RES window • All departed PNR’s for 3 months in the past • ODIF • Advance booking up to start of RES window • 3 years of history

  12. This is an example of selected objects and conditions

  13. Roll-out • Production data currently available • To be deployed in May • Phase 1: • Canned queries provided • Super user accessing the DB

  14. Sharing Experiences

  15. Important Aspects • Structure the data partitioning and indexes according to your environment • Speed of loading versus data retrieval • Design with the ability to archive • Validate the PNR capture with other sources

  16. Current MI Flight Segment data RES 1% of PNR’s rejected 2% lower load Comparison PNR file Sales View Advance Booking Data Capture

  17. PNR : Key to Network Management

  18. Scheduling Pricing PNR Financial Reporting Yield Mgt. System Perspective

  19. Yield ManagementOD forecasting • Improve leg forecasts • “Simple” OD forecasts aggregated at the leg level • Fits within the current Leg Based OD heuristic • Within the Network Optimization framework • OD forecasting from booking data and market share calculation e.g. AC should carry 10% of the market size on a new OD

  20. Yield ManagementExamples of short-term potential • Improve no-show calculation (in progress) • Focusing on the probability that a PNR will travel • Summarizing the results at the leg level • Retrieving valuable data (in progress) e.g. Booking profile by OD-class for simulation

  21. Booking profile by OD-class for simulation

  22. Schedule Optimization • Replace the current itinerary based ticket data by the OD PNR feed (developed) • more data elements (GDS…) • more exact for calibration • corrective measure versus the MIDT data • more timely (no revenue accounting cycle) • Adjustment of the schedule by matching OD advance booking versus forecast

  23. Pricing • Tracking • Velocity of booking from pricing initiatives • Volume by POS • Feed to pricing DSS • Action/re-action according advance bookings • Forecast by OD/fare basis

  24. Financial Reporting • OD based profitability (in development) • Timely load out by OD itinerary for network based profitability • Match against revenue and cost • Budgeting process (in development) • Advance booking merged with OD fares can provide status on the budget plan

  25. Pricing Scheduling PNR Financial Reporting Yield Mgt. The Organization Sales Marketing

  26. Integrated Network Management(Organizational structure and processes) • PNR is key to crucial MI • Product Planning • Market size • Flow pattern through hub ... • Sales force effectiveness • POS importance • Revenue forecasting • Track channel of distribution...

  27. “Gold in these PNR’s” Louis Busuttil

More Related