Epiphany

Project

Description: Data warehouse and customer profiling of marketing campaigns.

Key topics:

• Management of marketing campaigns, analyzing and defining the needs of the Customer creating a complete plan for the campaign. Maintaining the data warehouse for the needs of the CRM system for the company’s head office.
• Cleansing, de-duplication, data update.
• Design and development of dashboards, KPIs and reports on the effectiveness of the campaign and the efficiency of the warehouse.
• Migration of Customer’s system to an external data center, while maintaining all system and business dependencies.

Business goals:

• Efficient and accurate profiling of a group of target customers, increasing the effectiveness of marketing campaigns.
• Improvement of the quality of the collected data, while ensuring high availability of the campaign system.
• Implementation of the new features of CRM, among others increasing the number of transaction filters and streamlining the Customer’s business processes.

Range (solutions):

• The current base of the collected records has over 10 million entries, of which about 3 million are actively used.

Challenges:

• Preparation of the new system along with complete documentation from scratch , based on the existing, undocumented infrastructure.
• Defining new business processes and the resulting roles.
• Maintaining data warehouse with a size of more than 1 TB, containing about 10 million customer records and hundreds of millions of events in line with the Kimball’s approach. The data warehouse contains several times more data than company databases in other countries, as well as databases of the competition.
• Multifold shortening the daily processing of more than 1GB of data within the ETL process.
• Migration of the whole system to newer versions of software and more modern equipment.

Evaluation of results:

• In recognition of the competence and commitment the Customer took the decision that all technical activities in the project will be implemented only by the Polish team.