Migrated 30+ legacy data warehouses into a unified lakehouse, cutting query latency 8x and reporting costs 40%.
Energy major lakehouse — overview
Client
Fortune 500 Energy Major (confidential)
Location
Houston, TX
Timeline
1 Jun 2022 — 30 May 2024
Industry
Oil & Gas
A two-year program to retire 30+ legacy data warehouses across upstream and downstream business units, replacing them with a single Databricks lakehouse and dbt-driven semantic layer. Outcomes measured by the client: 8x query latency improvement, 40% reduction in reporting cost, and a unified KPI surface across business units.
Gallery
Execution timeline
Live progress tracking with photographic documentation from each construction phase.
Phase 01
Inventory of 30+ source warehouses, lineage mapping, and target lakehouse blueprint.
Phase 02
Lakehouse foundation on Azure, governed Delta zones, and CDC ingestion from source systems.
Phase 03
Modelled 200+ business entities in dbt with tested KPI definitions.
Phase 04
Phased BU-by-BU cutover with parallel runs and finance sign-off on every KPI.
Phase 05
Decommissioned legacy warehouses and tuned the platform for 8x query latency.
Related work
Streaming ML platform scoring 2 million card transactions/minute with sub-100ms latency.
Forecasting + assortment optimization platform increased gross margin by 3.1% across 1,400 stores.
Eliminated error-prone in-memory reporting by migrating to a Snowflake data warehouse — error turnaround dropped from days to hours, and end users noticed immediately.
Tell us your business question, your data estate, and the timeline. We respond within one business day with a written hypothesis and a delivery plan.
USA
+1 804-262-6995
India
+91 9963497700
corporate@vitanagroup.com
