Mortgage retention decisioningfor US banks and mortgage teams
~1 hour
Daily manual preparation removed per advisor
Before adoption→~30% more
Clients handled per advisor, daily
Kickoff→7 months
To an MVP in production
Workflow improvements were measured by the bank during a three-month pilot.
The client and product are anonymised. Interfaces are reconstructed in English with synthetic data; photographs are illustrative.
·Where it began
From a decision engine to a working product
The client had built a decision engine that identified mortgage retention opportunities from bank data.
I joined to design the product around it: data setup, result review, offers and borrower outreach. The decision model itself was outside my scope.
I worked with the client as a domain expert, developed the user flows and built an interactive prototype. He used it with prospective customers to gather feedback before development.
I then brought four engineers onto the project and took on product management alongside design. We delivered an MVP in around seven months, followed by a three-month pilot at a US bank.
A day in the product, in four screens
Each screen is shown in full further down; these link to where.
Advisors previously assembled their worklist across internal systems and spreadsheets.
The product connected data preparation, prioritised opportunities and outreach in one workflow.
With the product
Portfolio + additional data + current rates→
Decision engine→
Eligibility and score→
Opportunity→
Borrowers→
A specific offer→
Email / SMS→
Advisor follow-up
1Product model
Defining the workflow
I worked with the client to map who would use the product, what data they had and which decisions needed human input.
The first design went through four iterations before we tested the interactive prototype with prospective customers.
YesNoNoNoFailsNoYesYes
Credentials arrive by email
Signs in
First visit?
Onboarding: tooltips and a walkthrough video
Home
Asks for a reset
Reset email arrives
Uploaded before?
Sees the upload panel
Uploads a CSV
Validation
Mapped this file before?
Maps the columns by hand
Mapping reused from the last import
Sends the file for calculation
Past uploads listed beside the panel
Opens the calculated file
Filters, downloads, reads it as charts
Also from homeTrend chartsAccount detailsGuides and videos
Three inputs, three different lifecycles
Portfolio and supporting data belonged mainly to setup. Interest rates changed more frequently, so I separated their update flow from the initial import and mapping process.
Early versions used generic campaign names. We changed the structure to familiar mortgage opportunities, such as Cash Out and Rate & Term Refinance. Each showed the eligible audience and financial volume before the user opened individual borrower records.
Finding somebody to contact was only half the job
Advisors could filter borrowers, inspect records and exclude people contacted recently. They could then prepare offers, send email or SMS, or export a selected group for follow-up in the bank’s existing systems.
Hide contacted< than 3 daysCustomizeFilterExportLTVAll<80%80-90%>90%UPBAll<50k50k-100k>100kLoan TenureAll<5 years5-10 years>10 yearsState4 selectedEquity213 selectedUPBUSPClear all filters
A good opportunity stops being good when the rate behind it changes.
Rates could change several times a day. I made source timestamps visible and added a warning when input data had changed since the last calculation.
Users could recalculate or continue with the existing result, with its status visible. Previous runs remained available with the source-data version used for each calculation.
Is this still true?
Every figure in the product is the output of two files and one calculation
Sources, and the one that moved
A number that is quietly out of date is worse than one that is missing. The rates arrived after the last calculation, so the card says so in words and offers the recalculation rather than leaving two timestamps to be compared.
Port file uploadedInfo07/30/202409:41 a.m.
Rates uploadedUpdate08/15/202409:41 a.m.You need to recalculate with new rates
The way back
A recalculation replaces the numbers somebody may have worked from all morning, so every run before it stays reachable. The second item in the menu is what opens the list beside it.
Uploaded 07/30/2024 at 09:41 a.m. as ratesnew.csv. Every offer on every other screen is computed against this table, which is why its upload time is the one that made the run above stale.
LoanPurposeLoan ProductLoanTypeTermInterest Rate
Refinance30-Year FixedConventional306.875%
Refinance15-Year FixedConventional156.300%
RefinanceFHA 30-Year FixedFHA306.600%
RefinanceVA 30-Year FixedVA306.550%
RefinanceJumbo 30-Year FixedJumbo307.100%
RefinanceUSDAUSDA306.500%
Refinance5/1 ARMARM56.450%
Purchase30-Year FixedConventional306.950%
PurchaseFHA 30-Year FixedFHA306.700%
Rates update→
Source changes→
Stale run→
Recalculate or keep working
4A second interface
An optional assistant for less common queries
We added an AI assistant for queries that did not fit the main interface.
Queries such as finding a custom borrower group or checking when rates were last updated. Routine tasks remained available through the conventional interface.
Adoption varied: some managers preferred the existing controls. The assistant remained an alternative way to use the product.
AI HelperYou can ask me questions or ask to perform simple actionsWhat is HELOANWhat is a volume for NCA PurchaseAsk AI a question or make a requestSource of informationGeneralClient-specific
What is HELOAN
A HELOAN, or Home Equity Loan, is a type of loan where a homeowner borrows against the equity they have built up in their property. Here’s a breakdown of what it is and how it works:Key Features:1. Equity-Based. The loan is based on the difference between the current market value of your home and the outstanding balance of your mortgage. For example: home value $300,000, mortgage balance $200,000, equity $100,000 — the borrowing limit then depends on lender policies.2. Lump-Sum Payment. The loan amount is typically disbursed as a single lump sum.3. Fixed Terms. Unlike a HELOC, which often carries a variable rate, a HELOAN usually has a fixed one, over a set term of 5, 10 or 15 years.4. Secured Loan. Since the loan is secured by the home, the lender may foreclose on it if payments are missed.
Where to find portfolio recapture table
Instructions1. Go to page “Portfolio”2. Click the “Table” option in the upper tab barDirect linkPortfolio recapture table
When did i upload rates last time
Today at 11:34 pm.
Show 8 CLT with Jumbo 15
Here are 8 clients with product Jumbo 15-Year FixedIDFirst NameLast Name123MitchellHawkins134AngelEdwards145ColleenFox156ArthurLane167EstherRichards178MarvinBoyd189DianneRussell190RonaldPenaSee full data about clients with Jumbo 15-Year Fixed
Ask AI a question or make a request
What is HELOAN
A HELOAN, or Home Equity Loan, is a type of loan where a homeowner borrows against the equity they have built up in their property. Here’s a breakdown of what it is and how it works:Key Features:1. Equity-Based. The loan is based on the difference between the current market value of your home and the outstanding balance of your mortgage. For example: home value $300,000, mortgage balance $200,000, equity $100,000 — the borrowing limit then depends on lender policies.2. Lump-Sum Payment. The loan amount is typically disbursed as a single lump sum.3. Fixed Terms. Unlike a HELOC, which often carries a variable rate, a HELOAN usually has a fixed one, over a set term of 5, 10 or 15 years.4. Secured Loan. Since the loan is secured by the home, the lender may foreclose on it if payments are missed.
Where to find portfolio recapture table
Instructions1. Go to page “Portfolio”2. Click the “Table” option in the upper tab barDirect linkPortfolio recapture table
When did i upload rates last time
Today at 11:34 pm.
Show 8 CLT with Jumbo 15
Here are 8 clients with product Jumbo 15-Year FixedIDFirst NameLast Name123MitchellHawkins134AngelEdwards145ColleenFox156ArthurLane167EstherRichards178MarvinBoyd189DianneRussell190RonaldPenaSee full data about clients with Jumbo 15-Year Fixed
Ask AI a question or make a request
·The rest of the work
Beyond the core product
The same work also had to be explained, sold and built by a team.
Signal now, trend over time
Managers could also review portfolio trends by geography, loan product, customer type and campaign activity.
Over time
The blocks that make this a period rather than a single run
Campaigns over time, and the control that sets the window
The one thing that separates this screen from the single-run view: a period. Four campaign types stacked, so the shape of the whole and the mix inside it are read in one pass.
ListedDate
WeekMonth6 MonthYear
01020304050607080910111213141516171819202122232425262728293031NCA Home ListedTrigger LeadsPort Home ListedPort Purchase
What the book is made of
Three figures and the mix behind them. The ring is the composition; the tiles are what a reader repeats afterwards.
The full screen answers this with a map carrying a pie on every state. In numbers it takes a fifth of the room and says the thing that matters: this is a retention product, and existing customers lead everywhere.
I designed marketing pages alongside the product to explain the workflow to prospective customers: combine data, identify opportunities and take action. The client used these pages and the prototype during market conversations.
Combine data
Find opportunities
Take action
·Where it landed
From prototype to a bank pilot
We delivered the MVP in around seven months.
During a three-month pilot, the bank reported around one hour less manual preparation per advisor each day and approximately 30% more clients handled daily. Around 100 advisors were using the product after the pilot.
My work covered the user-facing product, admin environment, design system and marketing pages, alongside product management during development.
·In hindsight
What I would improve in a similar project
Three things I would do differently on a similar project.
Observe advisors directly earlier, alongside the client's domain input.
Define workflow analytics before the first production release.
Measure assistant usage separately to understand when it helps more than the conventional interface.