Skip to main content
HB
Hiram BarskyProduct Designer + AI
All work

Case Study

Investor Loan Platform

Replacing Excel as the system of record for multi-million-dollar loan deals, without anyone losing the workflow they already had.

  • Enterprise
  • FinTech
  • Workflow Design
Role
Lead UX Designer
The deals grid and the orderbook, with the audit trail sitting next to the record instead of in an admin tool nobody opens.

01

Millions of Dollars, Run Out of a Spreadsheet

A bank was running its loan operations in Excel. Deals worth millions of dollars, no audit trail, no validation, and no way to tell who changed what.

Three teams had already tried to replace it and failed. I spent a while figuring out why before I designed anything, and the answer was the same every time: they all tried to improve parts of the job the loan officers never asked to have improved.

02

Research and Ideation

I started by mapping the whole loan lifecycle on a whiteboard, from application through to audit, so I could see where the spreadsheet was actually holding things together and where it was quietly failing.

Then I sketched the order builder rough and fast, because the thing I needed to test was the sequence, not the styling. Once the steps held up, I wrote the flow down as four moves: pick a deal, choose Cashless Roll or Book-builder, add an order or attest to one, update the grid. That is the version loan officers recognized as their own job, and it is the one that got adopted.

Mapping the lifecycle first, so I knew what Excel was really doing for them.
Low-fi on purpose. I was testing the sequence of steps, not the look.
The four steps, written down. Officers read this and said yes, that is what I do.
The same four moves, before and after. Excel on the left could already do all of it — just with nothing stopping you getting it wrong.

03

What I Built

Validation runs inline as you type, so a malformed entry gets caught where it happens instead of at submit. You never see it when the entry is fine.

I replaced filter panels with predictive search. Loan officers do not think in filters, they think in name fragments and deal codes, and they want the deal on screen in two keystrokes. That is a Bloomberg habit and it was the right one to design for here.

The order builder walks you forward: pick the lender first, then the terms open up. It looks restrictive in a screenshot. In practice it stops people building an order against nothing.

The audit trail sits right next to the record instead of in some admin tool nobody opens. That single decision is why compliance ended up arguing for the platform rather than against it.

Predictive search in place of filter panels. Loan officers think in name fragments and deal codes, and want the deal on screen in two keystrokes.

04

What I Got Wrong First

My first version copied too much of Excel's structure. I was trying to keep the change small, and I ended up with something that was worse than the spreadsheet at being a spreadsheet and worse than the platform at being a platform.

I also built dashboards too early. Nobody starts their day on a dashboard. They open a specific deal, because a specific deal is what someone is asking them about.

The landing page below is the version that made that obvious. Every deal in the book as a card, twenty-two thousand of them, sorted by borrower. It is a perfectly reasonable screen and it answers a question nobody was asking. What replaced it is the list further down this page, with predictive search on top, because the real first move of the day is finding one deal by name.

22,934 deals as cards. The count in the corner is the tell: a screen that opens on everything is a screen that has not decided what you came for.

05

The Design System

One institutional blue that only ever means "you can act here", and three status colours that only ever mean deal state. Everything sits on a 4px grid, in Inter, chosen because it holds up at the small sizes a dense loan table forces on you.

Nothing else gets colour. In a product where the numbers are eight figures, decoration reads as a bug.

The token set the platform actually runs on. Primary Blue is the only colour an action ever uses; the three status colours are reserved for deal state and nothing else.

06

Where It Landed

They adopted it. Three teams tried before me and none of them got there.

My Deals. The screen loan officers recognised as their own job, which is why this attempt got adopted and three before it didn't.
Utilisation, total limit and available credit per borrower. These are the numbers the spreadsheet was holding with no validation behind them.
The thinking behind itYou Don't Replace Excel by Being Better Than ExcelA bank was running multi-million-dollar loan deals in spreadsheets. The software that replaces that has to lose to Excel on flexibility and win on…Read the post

Want something like this built?

I design and ship products end to end. Tell me what you're working on, or grab a time and we'll talk it through.