Before6 hevery morning, stitching reports by hand
01 · The challengeEvery morning started with a spreadsheet.
Analysts exported data from three systems, cleaned it by hand and emailed reports before standup. Numbers disagreed between teams, and by noon they were already stale.
Approach1source of truth, streamed from the loan system
02 · What we builtOne stream, every view.
We streamed loan events into a warehouse on AWS, modelled them once, and built a fast web app on top with role-based views for risk, collections and leadership. Weekly demos kept every decision visible.
AWSKinesisdbtReactPostgreSQL
AfterLivenumbers every team trusts, all day
03 · What changedThe morning export is gone.
Teams open the dashboard instead of their inbox. Leadership reviews the same numbers risk uses, and new reports take days instead of weeks.