Fintech Analytics Dashboard

Reporting ran as nightly batch jobs, so advisors started every morning with data that was already twelve hours old. Any ad-hoc question became a ticket for the data team.

The goal: live numbers, sub-second filtering across millions of rows, and an interface advisors would choose over their spreadsheets.

Discovery started with the twenty questions advisors asked most. The schema and materialised views were designed around those questions before any UI work.

Next.js Server Components stream the heavy aggregates, a Node.js worker pushes deltas over WebSockets and Prisma keeps the data layer typed. Claude Code sub-agents drafted and verified migrations while I focused on query performance.