About the client
Implementation of an analytical tool supporting marketing campaigns
The challenge
The implementation of an analytical tool supporting marketing campaigns
What we did
- Implementation of a complete ETL process for QuickStart! marketing data warehouse in Turkey, United Arab Emirates and Oman
- Rework of a global customer deduplication mechanism
- Privileges scheme re-work
- Data anonymization tool implementation
- Implementation of rule-based data quality assurance
- Database tuning
Effects
- Single Customer View implemented
- Direct marketing campaign management tools made available
- Generation of leads for Call Centers under control
- Global, standarized reporting made available
- New reporting platform created to exchange cooperation actuals between AIG and HSBC
- New analytical opportunities created thanks to data anonymization
