Showcase: Database merger AMOS to AMOS at Lufthansa Technik Maintenance International
Aircraft Line maintenance companies, more often than not, operate in different countries under different entities, different management and different regulatory approvals. As a result these line maintenance companies end up with multiple MRO software systems being used to manage their day-to-day aircraft maintenance processes. Lufthansa Technik Maintenance International (LTMI) recognized the inefficiency this brings in pooling of resources, process standardization and software license costs. Together with EXSYN, LTMI embarked on a journey to merge their different AMOS systems into a single system to be used by all stations and entities of LTMI worldwide. In this use-case we highlight how we approached the consolidation and merging of MRO data such as parts definitions, inventory, tooling, licenses & qualifications, maintenance planning, work package preparation, finance controlling and shift plans. For LTMI this resulted in significant cost savings on software license costs and the ability to seamlessly exchange tooling, parts and certifying staff between different stations.
About Lufthansa Technik
The Lufthansa Technik Group consists of 32 companies with more than 25,500 employees, providing aircraft maintenance and MRO services worldwide. Lufthansa Technik Brussels, Lufthansa Technik Milan and LTMI all belonging to the Lufthansa Technik group decided to merge their independent AMOS systems into a single multi-entity AMOS system in order to obtain operational efficiencies and cost reductions.
Challenges
Independent business processes at each entity requiring to be aligned.
Master data definitions being differently setup and managed across the different entities and their existing AMOS systems.
Retaining component labels and barcodes for individual warehouses once migrated into a merged environment.
Different stable releases in use per entity.
Solution
Migration of each entities AMOS data into a common platform for alignment, transformation and cleansing by the NEXUS ETL engine and EXSYN expertise without risking accuracy and integrity of overall aircraft maintenance data.
EXSYN performed the following activities:
Workshop with business users to perform full data mapping between current AMOS systems and to-be AMOS merged environment and business processes
Activation of the NEXUS ETL infrastructure, including required plugins
Baseline data load to gauge state-of-play of all data
Iterative process for scripting of required Extraction-Transformation-Loading scripts
Automated verification in NEXUS to ensure data integrity and quality towards new standards
Creation of required output formats/routines based on selected AMOS release
4 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 go live AMOS support
Benefits
Higher Performance and Productivity
EXSYN’s data migration tool NEXUS 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
Based on EXSYN’s automated data transformation and processing logics, migration of each entities data into the new data standard without the need for manual intervention.
Time and Cost Savings
Based on EXSYN’s proven framework and years of experience timely and controlled data migration process and eventually go live of the new AMOS merged system at Lufthansa Technik.
Simplifying aircraft data standardization
Based on EXSYN’s ETL approach, managing complex data issues between part definitions, vendor definitions, part requirements or maintenance program task card setups easily. With an easy iterative execution, users can see how their data will look like based on decisions and assumptions made. Adjustments are easily made and data can be reloaded for a renewed assessment by key-users.
Click on below picture to view the full showcase document:
