Client is an engineering and construction firm, providing legendary client service and smart and fully-integrated provider of technology, engineering and construction solutions to the water, environment, transportation, energy and facilities. Its proprietary technologies, integrated expertise and comprehensive solutions deliver certainty, innovation and added value to global projects around the world.
Client implemented Oracle ERP and engaged ChainSys as its data migration and master data quality (DQM) partner utilizing the Chainsys Data Zap and DataZen offering.
As part of the Oracle EBS 12.2.x deployment, Client needed data migration from legacy systems for ~75 objects that were primarily loaded to the following tracks – Finance, Projects, 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 stay clean process after implementation. This was accomplished through the tool that offered automation capability for extraction, and master data cleansing, enrichment and deduping.
Client’s CRM system and multiple legacy ERP systems enter and maintain customer data independently. This process created a lot of duplicate customers and customer accounts in various systems and created a very difficult situation to consolidate and report proper spend and income analysis. Data quality is also another concern between various systems.
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 data deduping and data cleansing. Master data was enriched using D&B data services before migrating to target EBS 12.2.x. This expedited stay clean solution implementation post go live.
ChainSys deployed its dataZap (appMIGRATE) and dataZen (AppMDM) product for building a solution to integrate SFDC Application to Oracle ERP through dataZen (appMDM). The data was cleaned prior to the migration using the ChainSys dataZen (appMDM).
The key to success was the ability to “GET CLEAN AND STAY CLEAN”. Cleansing data from multiple source systems as per client’s needs and the build proper master data governance using workflows.
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.