Clean up data upstream of a CRM
How to aggregate data from different sources and prepare them for insertion into a CRM?
An internationally active company that has used multiple CRMs so far wants to unify its customer information so that it no longer uses just one saleforce CRM. The different data formats require cleaning and standardization in line with the new CRM.
The mission is to clean up and standardize the information in the new format. Where applicable, a status will indicate whether the information requires human verification. All the data will be returned in a CSV file.
Classification of surnames and first names
Separation of first and last names and gender recognition via first name
Address standardization and control
Assignment of missing data and restitution based on the standard S42
Standardization and control of phone numbers
Allocation of prefixes by country and standardization of values
Checking the validity of emails
Checking the validity of addresses and updating the newsletter database
Return on investment
Successful suite of complex operations
Very short lead times
Preservation of an essential asset: the customer database