Back to Projects

Data Modernization Initiative

Led a comprehensive, enterprise-wide data modernization program, expanding from an initial data migration project to a full-scale transformation of legacy systems. Developed and executed a strategic 2-year product roadmap while serving dual roles as Product Manager for the data engineering team and Program Manager for the initiative.

As both Product & Program Manager, I oversaw the complete data ecosystem transformation, led migration from legacy data warehouse (MSSQL) to centralized enterprise data warehouse (Snowflake), conducted thorough source data ingestion pattern discovery, and restructured project scope based on findings to achieve more comprehensive modernization.

A key focus of this initiative was aligning with the future business needs of the Rides business (taxi, public transport) at Booking.com. As teams scaled, data needs were also changing and increasing, requiring a forward-thinking approach to data architecture. This involved continuously identifying core business use cases—both current and future—to ensure our work would be future-proof while maintaining business continuity without disrupting existing systems.

Strategic Approach

Divided the initiative into five parallel workstreams to ensure focused delivery:

Event Tracking Restructuring

Complete redesign of behavioral event tracking systems to improve data quality and accessibility.

Ingestion Pattern Modernization

Updated methods for consuming data from relational transactional product databases for improved efficiency.

Reporting Revamp

Comprehensive optimization of reporting and dashboards in collaboration with analysts to enhance data visualization.

Stream Consolidation

Deprecation and centralization of outdated and underutilized data streams to reduce complexity and maintenance costs.

Historical Data Migration

Systematic transfer of historical data from legacy DWH to centralized enterprise DWH (Snowflake) ensuring data continuity.

Program Management Methodology

2-Year Phased Approach

  • •Year 1: Focus on modernizing ingestion patterns to centralized enterprise DWH
  • •Year 2: Complete modernization of data/table architectures on Snowflake

Strategic Implementation

  • •Defined strategic project goals with measurable quarterly milestones
  • •Developed consensus-based approaches for each workstream
  • •Created multi-level timelines (strategic and task-level)

Governance & Alignment

  • •Implemented regular cadence of workstream meetings
  • •Ensured compliance through collaboration with data governance and legal teams
  • •Aligned with technical principals to develop holistic architectural vision
  • •Established clear communication channels with stakeholders

Business Alignment & Continuity

  • •Identified and prioritized core business use cases to deliver maximum value from day one
  • •Conducted regular workshops with business stakeholders to understand evolving data needs
  • •Implemented parallel systems during transition to ensure zero business disruption
  • •Created comprehensive testing frameworks to validate data consistency across systems

Technologies & Skills

Snowflake

Enterprise Data Warehouse

MSSQL

Legacy Data Warehouse

Program Management

Strategic planning & execution

Stakeholder Management

Cross-functional collaboration

Outcomes & Status

Current Progress

Program currently in progress with all milestones and timelines being successfully met.

45% Complete

Key Achievements

  • •Established foundation for future-proof data architecture
  • •Improved data accessibility, quality, and governance across the organization
  • •Enabled advanced analytics capabilities through modern data platform
  • •Successfully aligned multiple teams toward common modernization goals
  • •Maintained 100% business continuity throughout the transformation process
  • •Designed scalable architecture to support Rides business growth and evolving data needs