Showcase: Data Migration from SCEPTRE to AMOS at ElAl
The SCEPTRE system is a piece of ancient database technology still used today by airlines to manage their aircraft airworthiness and maintenance data. Mainly still present with airlines in the United States, it posts a huge cost in order to maintain its infrastructure (IBM mainframe from the late ‘80s) and build add-on application to enable modern day digitalization initiatives such as mobile devices, e-signature or predictive maintenance. In today’s crisis and recovery of airlines lower the costs of digital infrastructure and at the same time continue with digitalization is of paramount importance for long term stability of airlines. However, if your backbone is built on SCEPTRE how to get the critical set of aircraft airworthiness & maintenance data out of this system in a controlled way without grounding your fleet? Read about how EXSYN tackled this challenge in our case-study (see below). It might also help you in some of your upcoming aircraft return deliveries!
About El Al
EL AL is the flag carrier of Israel and is a prestigious international carrier with a fleet of 45 aircraft and with 42 destinations in Eu-rope, Asia, Africa and North America .
Challenges
EL was using the legacy MRO soft-ware system (SCEPTRE) and many satellite applications to support MRO business processes. Imple-mentation of a new fully integrated MRO software system (AMOS). SCEPTRE system uses hierarchical data structures and COBALT copy-books to capture data. Limited air-line knowledge on SCEPTRE data structure and AMOS functionality. Requirement to migrate full fleet data in a secure and high-quality manner due to CAA surveillance.
Solution
Migration of the ELAL full fleet away from SCEPTRE into AMOS without risking accuracy and integrity of overall air-craft airworthiness data within the given project timelines. Additionally advise fleet management in best practice to setup their data in the new system.
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 SCEPTRE and COBALT copybooks
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 verifica-tion 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 go live 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 ELAL fleet adhering to strict data quality standards and enrichment of data by using EXSYN’s air-craft 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).
“The service and commitment EXSYN has provided throughout our data migration project has enabled the successful go-live of our new MRO software system AMOS.” (El Al AMOS Imple-mentation Project Team)
Click on below picture to view the full showcase document:
