Context
Delinquent accounts are expensive twice over: the revenue is at risk, and the recovery work is manual. The team could see the total but not the shape of it.
Problem
Work out which accounts were drifting and why, without waiting on a data team that had its own queue.
Role
I ran the credit optimisation and demand management projects and built the account analysis myself in Excel.
Process
Built executive dashboards in Looker, Looker Studio and Tableau so the position was visible without anyone re-running the numbers, then automated the KPI reporting workflows that had been done by hand.
Outcome
Delinquent accounts fell 10% over six months. Data retrieval time dropped 30% and manual tracking activity fell 40%.
