Showcase: Data Migration from SAP to AMOS at Iberia

About Iberia

Iberia is the flag carrier of Spain and is the main carrier in the Europe - Latin American market. It operates a fleet of 136 aircraft and flies to more than 90 destinations. Iberia, together with British Airways, Vueling Airlines, and Aer Lingus is part of the International Airlines Group (I.A.G) .

Challenges

• Implementation of a new fully integrated MRO software system (AMOS).

• The heavily customized SAP system resulted in the fact of having a  complicated data and database structure.

• Limited knowledge on SAP data structure and AMOS functionality. Requirement to migrate full fleet data in a relatively short time fame.

Solution

Migration of the Iberia fleet from SAP to AMOS by using   TITAN ETL and EXSYN expertise without risking accuracy and integrity of overall aircraft airworthiness data within the strict project timelines.

 EXSYN performed the following:

· Workshop with business users to perform full data mapping between current system landscape and to-be MRO software and business processes

· Activation of the TITAN ETL infrastructure, including required plugins for SAP

· Baseline data load to gauge state-of-play of all data

· Iterative process for scripting of required Extraction-Transformation-Loading scripts

· Automated verification in TITAN to ensure data integrity and quality

· Creation of required output formats/routines based on new MRO software system

· Minimal 3 full data loads, including end-user verification according defined verification templates from EXSYN

· Final User Acceptance and Sign-off

· Cut-over

· Loading of historic data post go-live which is not deemed required for cut-over

· Post golive support

 Benefits

Higher Performance and Productivity

EXSYN’s data migration tool TITAN can handle large data volume from multiple sources and guarantee a repetitive process providing enhanced performance with almost 60 percent reduction in Average Handling Time. 

Higher Data Quality

Migration of the full Iberia fleet adhering to strict data quality standards and enrichment of data by using EXSYN’s aircraft data warehouse.

Time and Cost Savings

Based on proven framework and years of experience timely and controlled data migration process and eventually go-live of the new MRO software system (AMOS). 

Increased Employee Satisfaction

By managing the complex issues between engineering, maintenance, logistics, planning and IT departments, between key-users and system integration, Iberia  employees could devote their time on relevant daily business tasks.

 Click on below picture to view the full showcase document: