A two-year data transformation, built without a map
2023 – present
The problem
The company's back-end eligibility system was overhauled with no data contracts, documentation, or requirements passed downstream. Reporting ran off fragmented spreadsheets, no two teams defined key metrics the same way, and the executive team had no trusted, shared view of the business to steer by.
What I did
I program-managed a company-wide transformation end to end — reverse-engineering how the application generated and changed data, then redesigning the warehouse around the new identity-management model. I established governance and metric definitions, built a governed analytics layer for non-technical stakeholders, and acted as the internal consultant translating between engineering and every business function. Along the way I re-architected pipelines for incremental processing and rewrote inefficient queries.
The outcome
Leadership now runs retention, growth, and resource decisions off a single source of truth. The platform scaled to support a doubling of enterprise clients while monthly pipeline costs dropped by half — and any data anomaly can now be traced from an executive dashboard back to its source event.