summary
Multi-layered data migration involving multiple source systems
A leading airline undertook a large data migration project involving various MRO systems such as Maxi Merlin (WIZARD), Trax and Maintenix. The project also required aircraft part transfers between legacy MRO systems and Maintenix.
The Challenge
Project required a deep understanding of the hierarchy of aircraft and sub-assemblies
Relevant subject matter expertise included topics such as ATA chapter breakdown, tracked component breakdown, batch and serialized parts that were specific to fleet operations, as well as part numbers and applicability.
HOW WE HELPED
Comprehensive requirements gathering combined with flawless execution
PTR Global initially developed comprehensive requirements documentation incl. a formal BRD, source-to-target mappings, data models, data validation docs, etc. Key definitions for aircraft maintenance and support included maintenance programs, blocks, reference documentation, component and aircraft requirements, job cards, and task links.
Post-data extraction, we established loadable templates such as parts inventory, aircraft configuration, positions for components, etc. to migrate aircrafts into the target system. Data synchronizing was critical because the data was dynamic and transitioning aircraft would be operational. This required multiple data sources in both MRO systems to be synchronized for up to one week. Data included flight logs, part changes, task completions and defects.
Finally, we developed extract-transform-load (ETL) processes to load data from MRO systems to the enterprise data warehouse for analytical reporting. Validation and cleansing of legacy data was accomplished through automated techniques.
impact
Project accomplished on-time and within budget
This mission critical project was accomplished on-time and under budget, meeting all client requirements. PTR Global has continued to serve this client on multiple engagements over many years and remains a valued professional services partner.
Related Case Studies
Return to Work Solutions for IT Contractors
summaryClient seeking to migrate from a mostly remote work environment to a hybrid modelAfter two years of pandemic-related remote work, a large financial institution is seeking to migrate both its
200+ RPO Hires in Sr. IT Positions
summaryCustomer was struggling to ramp up its internal IT organizationA large media firm needed to significantly grow its internal technology group. Their internal efforts to date, coupled with various search
Digital Transformation in the Healthcare Industry
One of the oldest and largest independent physicians associations had an opportunity to simplify and automate key member services to lower costs and improve revenue. The credentialing process, a core product offering, entailed recurring background checks and credentials verification for each physician member.
Connect with
a solutions expert
