Industry:

Industrial Manufacturing

Digital Transformation and Sunset Legacy Applications

Client Overview

Client is a multinational conglomerate incorporated in New York City and headquartered in Boston and is a market leader in the Power, Renewable Energy, Aviation and Healthcare industries. 

Their business segments include - aviation, healthcare, power, renewable energy, digital industry, additive manufacturing and venture capital and finance.

Project Scope

Client’s Oracle EBS ERP system was at the end of its life cycle, which was a risk to business continuity since critical Business Processes were controlled within the ERP. Client decided to re-implement its Oracle EBS application and engaged ChainSys as its data migration partner utilizing the ChainSys dataZap for data migration and reconciliation. The Oracle EBS R12 re-implementation consisted of over sixty five data migration objects covering three primary tracks - Finance; Project & Services and Supply Chain Management. Complexity was added due to the need to accomplish data migration in a short duration with multiple back-to-back test cycles. 

Data migration had to work in tandem with application re-design and process re-engineering.

Business Situation

Client had a challenging environment with numerous custom processes in-place and wanted to simplify its business and IT landscape during the Oracle EBS re-implementation. As part of this endeavor, Client was focused on the reduction of customization/CEMLI and global process re-design while following Corporate Mandates on Enterprise Standards, CoA, etc.

Technical Solution

ChainSys deployed DataZap to help solve business & technical shortcomings. Data was directly extracted from the Oracle EBS source system with pre-configured templates. All data transformations were accomplished within the tool and pre-validations were done against the target EBS R12 instance prior to loading data into the target system. 

Migration Challenges were:

  • Complex/Conditional Extraction Logics
  • Complicated transformation criteria, which were revised during each test cycle
  • Huge data volume  of items masters 
  • Ensuring Validation of Migration - anomaly identification on the Data Migration
  • Global Multiple Go-Lives: Phased-out Approach
  • Tight Cut-over Time

Solutions

ChainSys deployed dataZap for data migration and reconciliation for the Oracle EBS re-implementation. Solution highlights are as follows:

  • Consolidated  multiple objects into a single global instance
  • Chain-Sys Platform leveraged with pre-configured adaptors to extract, cleanse, transform, pre-validate & load data
  • Effective reconciliation with dashboards provisioned for data owners

Data Reconciliation and validations using dataZense

  • More than seventy  dashboards for reconciliation
  • Checksum Count / Summary Level
  • Drill-down Record Level / Field level

The transformation process built within the tool was key to success as it helped roll-out test cycles in quick succession. The transformation business rules were perfected in each test cycle based on the re-engineering. The reconciliation dashboards helped the users to verify and sign-off.

Illustrations
No items found.
Benefits
  • Repeatability / Reliability with using pre-built templates and configurations.
  • Easy “Delta Migration” with auto Change Data Capture Capability
  • Catered to dynamic business changes with Quick Test Fires.
  • Faster deployment with Pre-built validations. The live dashboards were utilized for critical Data Validation, Audits & Signoff. Final Production Data Conversion & Accuracy was in excess of 99.99%.

Products & 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.

No items found.