Delivering end-to-end data migration, cleansing, and reconciliation across 60+ entities to enable a seamless SAP S/4HANA transformation.

About the customer

The customer operates the Philippines' largest chain of retail stores for local and international brands. It is a subsidiary of a diversified group with business portfolio covering real estate development, banking, finance and investments.

It is a significant player in home furnishings, fashion and food retail. It manages over 60 stores and malls strategically located in key cities throughout the country and carries a wide range of apparel, accessories, houseware, general merchandise and (lifestyle products),

Its Specialty Retail businesses includes several prestigious local and global retail brands. The company owns over 830 Supermarkets, Hypermarkets and food retail stores. The company also operates leading local and global retail chains with more than 1,300 outlets, covering food, household appliances, DIY, furniture, apparel, footwear, pharmaceuticals / cosmetics, fashion and lifestyle

Pain Points

Following were the key challenges and objectives of the project:

• Migrate Legacy Oracle Data to new S4HANA system covering:
• Extraction, Harmonization, Transformation and Cleansing of all Master and relevant Reference data
• All Finance and Business Partners (Customer and Vendors) data to S4HANA
• Cover data pertaining to more than 63 group companies
• Help Business with Data Cleansing and Enrichment activities

Customer Benefits

Emisha worked with the customer to deliver the following:

• Initial Assessment of Legacy Data to understand the size, scale and readiness from technical and business perspective for migration
• Identify and implement business relevance criteria to help identify data not relevant for migration thereby reducing the volume of data to be cleansed and enriched
• Provide easy to use front end for business to cleanse and enrich data as required
• Extraction, Transformation and Creation of load ready files as per the templates provided by the Sl
• Provisioning of relevant and updated data for key loads covering Integration, User Acceptance, Final Cutover and Go-Live
• Doing post load Reconciliation and remediation as needed
• The whole process was made Repeatable, Scalable and Accurate