01 — BIOMARIN← ALL PROJECTS

END-TO-END BIOTECHSUPPLY CHAIN INTELLIGENCE

DATA ANALYTICS INTERN · GLOBAL EXTERNAL MANUFACTURING · 2606 — PRESENT

Visibility that arrives in time to change the outcome, not to explain it.

The metric that was about to be published was measuring the wrong thing. Establishing that took a record that reproduces, definitions that agree, and a route to the people who could act on it.

SCOPE
SAP · QMS8 commercial products, end to end
TOOLS
Databricks · Fabric · SQLPower BI · Power Automate · Genie
SHIPPED
Supply chain control towerAI-queryable data product
01 / 03

BUILD THE FOUNDATION

External manufacturing had no governed view of its own shipments; the one in circulation belonged to another function and rested on a hand-maintained spreadsheet. I modelled the full lifecycle of a stock transfer against a pinned, tested snapshot, so any figure reproduces on demand rather than being re-argued.

  • BATCH-KEY ENTITY RESOLUTION
  • PINNED REPRODUCIBLE SNAPSHOT
  • REGRESSION-TESTED PIPELINE
02 / 03

DRAW THE CONNECTIONS

A transaction records that material moved, never why it arrived late. That sat in a separate quality system, in vocabulary that did not survive the crossing: one code spanning two events, one metric carrying conflicting specifications. I set contracts and named owners; nothing compounds until the words agree.

  • METRIC & DATA CONTRACTS
  • CROSS-SYSTEM CAUSE MAPPING
  • DEFINITION OWNERSHIP
03 / 03

DRIVE THE DECISION

Answering why a shipment slipped took days across two functions, against lead times where a late catch cannot be recovered. It now resolves against one governed record: leadership reads exception and cost, planning reads what to chase, and the same tables answer a direct question without an analyst.

  • TIERED EXECUTIVE REPORTING
  • EXCEPTION MANAGEMENT
  • GOVERNED SELF-SERVE