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.