Client Description

American Airlines Group Inc. operates an airline that provides scheduled passenger, freight, and mail service throughout North America, the Caribbean, Latin America, Europe, and the Pacific. The Company also provides connecting service throughout the United States, Canada, and the Caribbean.

American Airlines Group (AAG) is one of the largest airlines in the world. After merging with US Airways in late 2013, the combined airline company, together with its third-party regional carriers including Air Wisconsin, Chautauqua, ExpressJet, Mesa, Republic, and SkyWest operates nearly 6,700 daily flights to roughly 350 destinations in more than 50 countries. American and US Airways operate 930 mainline jets, and regional subsidiaries and third-party regional carriers operate nearly 600 regional jets. AAG extends its geographic reach through code-sharing arrangements and is part of the oneworld Alliance.

Following the truism that you have to spend money to make money, AMR ordered 460 single-aisle jets — 200 Boeing 737s and 260 Airbus A320s for delivery between 2013 and 2022; it is the largest aircraft order in history. The new aircraft are designed for fuel efficiency and should save in operating costs.

AAG has primary hubs in Charlotte (North Carolina), Chicago, Dallas/Fort Worth, Los Angeles, Miami, New York, Philadelphia, Phoenix, and Washington, DC. It provides international service to Australia, Canada, Europe, the Middle East, New Zealand, Central and South America, and Asia.

Challenge

American Airlines needed to migrate their legacy mainframe Marketing Information Revenue System (MIRS) to a more modern and robust platform.  The conversion process had numerous challenges with legacy code that was no longer supported and AA lacked internal resources with knowledge of the code base.  The complete conversion had to be completed within a two year window due to licensing and compliance issues.

Solution

The iOLAP Data Management Architects worked alongside with American Airlines and Teradata Corporation complete the conversion.  iOLAP was responsible for the Legacy code translation into technical design documents for the Teradata team.  iOLAP architects designed and automated the data integration process to populate a new MIRS EDW.

Benefits

The new process enabled American Airlines to perform advanced analytics, sunset their software that was out of compliance and to track data lineage.

  • Completed Date: November 06, 17
  • Tools: IBM InfoSphere DataStage | Teradata
  • Categories: Analytics, Big Data, Strategy
  • Tags: Logistics, Transportation