Data Warehouse Transformation Across 28 Countries

Client Context

A telecommunications company operating in 28 countries, facing data fragmentation and compliance risks due to aging infrastructure.

Problem Statement

The existing data warehouse infrastructure was a burning platform. There were 7 physical data warehouses with servers up to 12 years old shared by the 28 countries in which the company operates. The business faced problems such as:​

  • No real-time data​
  • Non-standardized data​
  • Complex data processing ​
  • Poor quality data​
  • Limited consolidation​
  • Non-GDPR compliance
Program Objectives

The objective of the Data Transformation program was to address the problem statement by delivering layers 1 to 3 displayed in the diagram below and serve as a foundation for layer 4.​

Breakdown of the program objectives
Khadhill’s Role

Serving as Program Manager, Khadhill led the end-to-end execution of a multi-stream transformation program. Our responsibilities included:

  • Establishing the governance structure to oversee all workstreams
  • Coordinating cross-functional teams across 28 countries
  • Managing vendor collaboration and internal dependencies
  • Executing a robust communication strategy to engage global stakeholders
  • Delivering against a detailed programme roadmap and milestone schedule
Breakdown of responsibilities as the Program Manager
Governance Structure
Diagram showing the program governance structure
Scope and Deliverables
Breakdown of the 4 Streams/Projects in the program
Program Roadmap
Program gantt chart showing the milestones for each project in the program
Communication Strategy
Breakdown of the communication strategy used for the program
Program Challenges
Four major issues/blockers experienced in the program
Program Outcomes
Breakdown of the the main program outcomes