01/ Business Analysis
Returns Process Optimization — Real-Time SKU Visibility
Outcome
49.9% of return volume traced to 3 SKUs, worth £22,520 in refund value — with a fix that cuts detection time from ~7 days to same-day
Store staff logged returns and issued refunds with no mechanism to flag when a product was generating a disproportionate share of returns — the pattern surfaced only in a manual weekly batch review, by which point it had often been running for weeks.

- JiraBacklog and user stories for both case studies
- ConfluenceRequirements documentation, FR/NFR, stakeholder maps
- BPMNAs-Is/To-Be process mapping
- SQLExploratory analysis before writing any requirement
- ExcelLive formulas, pivot-style summaries, charts

