Using Data Migration to De-Clutter Data

Our client is a Fortune 500 company that provides flow equipment products, systems and services to worldwide oil, gas and process industries. The client’s needs arised base…

Our client is a Fortune 500 company that provides flow equipment products, systems and services to worldwide oil, gas and process industries. The client’s needs arised based on an acquisition, where the company being acquired was halfway through their ERP implementation. For this client, we developed a two-degree solution. First, it was important to build a solution around the acquired company’s ERP and then position the client for success in future migrations.

Client Challenge

  • The Client needed a multi-faceted team of experts familiar with multiple ERP systems, such as Oracle and SAP. Simultaneous to their SAP implementation, they needed data maintenance expertise in Oracle to assure a smooth migration
  • The migration needed to take place on a very aggressive deadline; leaving minimal time for the time required to analyse data from the Oracle system as well as integrating the data to an SAP system

Enroute Solution

  • Stabilized the acquired company’s ERP, and then cleansed and migrated data from the acquired company to the client.
  • Successfully analyzed and extracted from the Oracle GL, AP, AR, SO, PO, PIR, WIP, INV, BOM and MM modules
  • Created a data cleansing process that made specific rules for every module to eliminate unwanted data and abide by the limited timeline. The cleansing process required validations from every key user of the organization to ensure that no useful data was left behind
  • Standardized templates for future migration inclusive of mapping templates into SAP for an easy, replicable process

Business Impact

  • Dynamic data extraction, with user feedback on every cutover assuring a flawless extracting process through all modules being loaded via one-click process
  • Newly reengineered processes translated from legacy system rules and company financial and management processes.
  • Substantially less cluttered data environment for streamline SAP processes

Alejandro del Palacio
February 24, 2015