Complex Master Data Problem Solved for an Oracle Cloud Digital Transformation Project

Client Overview

Client is a premier, fully-integrated provider of technology, engineering and construction solutions to the energy industry. Its proprietary technologies, integrated expertise and comprehensive solutions deliver certainty, innovation and added value to energy projects around the world. Client operates in multiple geographies - North Central and South America, Europe; Africa, Russia & Caspian; Middle East & North Africa; and Asia Pacific.

Client implemented Oracle Cloud ERP and engaged ChainSys as its data migration partner utilizing the ChainSys dataZap offering.

Project Scope

As part of the Oracle Cloud deployment, Client needed data migration from legacy systems for ~35 objects that were primarily loaded to the following tracks - Procurement, Inventory & Payable Systems. The key challenge was around multiple source systems and existence of duplicate and incorrect master data as well as the need for GL code transformation. This was accomplished through the tool that offered automation capability for extraction, and master data cleansing, enrichment and deduping.

Business Situation

Client’s legacy systems offered exceptional challenges since the data had to be cleansed as well as transformed prior to migration to Oracle Cloud ERP. Also, getting a view of the data transformation requirements was the key to success, which was enabled by putting functional teams in-place that had knowledge in both the legacy and Oracle target application. Master data like customer, supplier and chart of accounts are from multiple source systems. Master data cleansing before oracle cloud implementation and stay clean after Oracle Cloud implementation.

Technical Situation

ChainSys deployed appMDM (part of the offering from dataZen). All master data objects were directly extracted from multiple legacy systems via templates into a data hub. The extracted master data was cleansed using appMDM with built-in automation for deduping, cleansing and enrichment. This expedited the Oracle Cloud rollout by assuring availability of accurate master data prior to migration to the Oracle Cloud.

Solutions

ChainSys deployed its dataZen (appMDM) product for cleansing, enrichment of all master data from multiple Legacy systems to Oracle Cloud ERP.

Customer and Supplier master data cleansing - Dedup from 6 different source systems.
Customer and Supplier data enrichment using D&B and USPS data services.
Chart of accounts dedup and consolidation from 6 different systems.

Automated data extraction process from legacy applications
Automated transformation rules using global cross reference value sets
Automated chart of accounts stay clean process will identify missing cross references between legacy and oracle cloud in user friendly screens.
Template based data extraction from Oracle cloud.

‍

Benefits

Source data validation & cleansing - very critical prior to data conversions
Transformations & mappings between source & Oracle
Global implementation of all master data objects before regional roll-outs
Clear Visibility into the state of the Master Data
Global chart of accounts mapping between all source systems to Oracle cloud.
Chart of accounts stay clean process and automated mapping between Oracle cloud to Legacy finance systems will help to transfer transaction data.

The key to success was the ability to clean and enrich master data before implementation, stay clean of master data across all systems.

Products and Services Used

dataZap - Pre-Configured Templates & Migration Engine to Extract, Transform, Pre-Validate, Load, Reconcile & Report.

dataZen - To 'Get Clean' and 'Stay Clean', and Introduce Master Data Governance.