I own the data layer behind how a Fortune 500 sees its contracted revenue
The problem
Market access reporting is where a pharmaceutical manufacturer finds out what it is actually being paid. Every chargeback a wholesaler claims, every rebate owed to a health plan, every gross-to-net deduction that separates list price from real revenue - it all surfaces through this reporting. Five brands, 33+ production dashboards, and the commercial teams who negotiate contracts read them as fact. The backend was spread across dozens of warehouse views, and nothing automatically confirmed that a nightly load had landed correctly. A wrong number would not announce itself. It would simply sit on a dashboard until someone priced a decision on it.
What I did
I took ownership of that backend layer and treated it as infrastructure rather than reporting. I rebuilt the fragile logic onto governed base tables so the numbers have one defensible source, re-engineered the chargeback and gross-to-net views against the warehouse fact layer instead of brittle staging tables, and wrote automated post-refresh quality control that inspects every load and raises a flag before a single dashboard is opened.