Listed on the Fortune 500, this US based organization offers a wide range of financial products & services. Headquartered in Florida, and with a global strength of about 50000, this organization has continued to drive growth for firms around the world innovating the customer experience around financial services.
The scope of the project included the following:
The modules in scope included:
Client was utilizing manual setup deployment in its Oracle EBS environment. This resulted in a very complicated deployment strategy for new entity rollouts, new OU provisioning etc. The manual process was not only tedious but also resulted in errors. This caused severe delays to overall project schedules. Client decided to automate the Oracle Setup deployments thereby improving the quality and accelerating the implementation timelines. Along with setups, the migration of related master & transactional data was also part of the scope.
ChainSys deployed dataZap for the migration of Setup, Master and Transactional data from legacy systems to Oracle ERP to do the following activities. dataZap’s templates automated extraction, validation, cleansing, profiling, preload and post load reconciliations. Client’s legacy systems offered exceptional challenges since the data had to be cleansed as well as transformed into the Oracle (API/Interface) format prior to migration to Oracle ERP.
The process was facilitated by dashboards that gave business the ability to compare Setups between Source and Target instances. Also, BR-100 reports were automatically generated through the platform, which provided pre-validation of Setup migration which helped the business to review and sign-off.
ChainSys deployed dataZap to migrate data from Legacy to Oracle ERP. The data was cleansed prior to the migration using the ChainSys dataZAP. The project implementation was done in 8 months. The timeline was achieved by using the dataZap’s preconfigured templates, which covered the Transformation, Mapping, Data Quality, Pre-validation, Extraction, Error handling and Data Loaders using standard API and Interfaces. The templates, along with the DQM engine ensured that the data migrated was clean & compatible.
Prior to each conversion cycle, the pre load validation report was provided to the client to review. After enrichment and transformation, the pre load validations were carried out with transformed data. After the users approval data was loaded in Oracle and a post reconciliation report was shared with the business along with the data loaded in Oracle for verification. Data were successfully migrated through testing in iterative rounds/sprints, in compliance with client’s data validation and compliance needs.
DataZap leveraged the BR100 report for all the Setups (for all modules), which reduced 80% of manual work. Automated setup migration reduced 75% efforts on the overall project timelines.
Activities such as performance, scheduled executions, failed jobs were monitored with notifications, emails and dashboards.
Below was the solution implemented for this Data Migration.
dataZap: Pre-configured templates to extract, transform, validate, cleanse and load data into Oracle ERP
