Application Data Enhancement

Key Impacts

90%

Data de-duplication

80%

Improved customer classification & Campaigning process

Use Case:

• Client has approached to solve the duplication of customer
  data coming from different source systems. Perform deduplication & retain golden record

Solution:

• Defined a process of data extraction from different ERP, CRM systems.
• Developed ETL process for data extraction, transformation and load
• Defined different match and merge rules to perform data deduplication
• Developed the process the remove duplication from customer related contacts and electronic information
• Defined a process to group customers under an account family.
• Implication of rules to identify orphan customers that can’t be grouped under an account family