Skip to content
All cases

Designing a mortgage retention workflow

My role
Independent Product DesignerProduct design from definition to pilot; later also responsible for product management and delivery.
Period
Dec 2024 → Dec 2025contract, United States, remote
Scope
Product · UX/UI · design system · PM · admin · marketingproduct definition, prototyping, user-facing application, admin environment, market-facing pages
Product
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
Kickoff7 months
To an MVP in production

Workflow improvements were measured by the bank during a three-month pilot.

The retention dashboard on a laptop: recapture offers with the number of eligible borrowers and total equity, a choropleth of customers by state, a loan product breakdown and a payoff trend chart.

The client and product are anonymised. Interfaces are reconstructed in English with synthetic data; photographs are illustrative.

An office desk early in the morning: two dark monitors, a headset beside the keyboard, a thick stack of printed paper and a cup, with low sun raking across the surface.

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.

  1. 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.

    ActionsUpload pass through fileRun historyDownload XLSXSend emailRun historyChoose one to switchRun #120July 30, 202408:30 a.m.Run #119July 29, 202408:30 a.m.Run #118July 29, 202408:30 a.m.Run #117July 18, 202408:30 a.m.Run #116July 14, 202408:30 a.m.

    The rates the whole book is scored against

    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%
    1What the figures are standing on
  2. Portfolio Recapture

    Run of 14 May 2024 · 350,000 borrowers in portfolio

    ChartTable

    Offers

    Available Offers for Recapture

    Exclude signalsSignals
    Use as FilterCash Out RefinanceTotal Equity volumeBorrowers Eligible$47.4B160,622
    Use as FilterHELOANTotal Equity volumeBorrowers Eligible$18.2B139,337
    Use as FilterRate and Term RefinanceTotal Loan volumeBorrowers Eligible$438M7,771

    Loan Product Overview

    Breakdown of Loan Products

    USDA19%Other16%FHA 30y15%Conv 15y14%VA 30y14%Jumbo 15y11%Jumbo 30yConv 30yHELOC0%

    Customers by State

    Regional Distribution of Customers

    California108,50031.0%
    Texas56,00016.0%
    Florida45,50013.0%
    New York31,5009.0%
    Illinois24,5007.0%
    Pennsylvania17,5005.0%
    Ohio14,0004.0%
    Georgia12,2503.5%
    North Carolina10,5003.0%
    Michigan8,7502.5%
    Arizona7,0002.0%
    Washington5,2501.5%
    Colorado4,2001.2%
    Nevada3,5001.0%
    Oregon1,0500.3%
    CATXFLNYILPAOHGANCMIAZWACONVOR
    2The portfolio, re-priced
  3. Portfolio Recapture

    Run of 14 May 2024 · 350,000 borrowers in portfolio

    ChartTable

    Customers

    Eligible Borrowers in this Run

    Filters

    Offers applied to this list

    Cash Out160,622
    HELOAN139,337
    Rate & Term7,771
    Hide contacted< than 3 daysCustomizeExport
    IDFirst NameLast NameMailing AddressCityStateCodeNumberTypeOutreach
    123MitchellHawkins360 view8558 Green Rd.WorcesterMANP7 0LT(505) 555-0142Cash Out05/07/24View
    134AngelEdwards360 view775 Rolling Green Rd.ProvidenceRIBB4 7PF(480) 555-0119HELOAN05/07/24View
    145ColleenFox360 view2118 Thornridge Cir.Rapid CitySDKT12 2SX(907) 555-0163Cash OutSelect offer
    156ArthurLane360 view3605 Parker Rd.KnoxvilleTNAL5 2TR(684) 555-0128Rate & Term05/07/24View
    167EstherRichards360 view1901 Ash Dr.TampaFLCM7 5EY(205) 555-0175Cash Out04/19/24View
    178MarvinBoyd360 view2715 Ash Dr.BoiseIDSE9 1AA(316) 555-0104HELOAN05/21/24View
    189DianneRussell360 view4140 Parker Rd.MesaAZGU2 7XH(702) 555-0198Cash OutSelect offer
    190RonaldPena360 view1901 Thornridge Cir.AkronOHDN4 6QT(319) 555-0187Cash Out05/02/24View
    201JaneCooper360 view6391 Elgin St.FresnoCALS9 3RB(629) 555-0133Rate & Term04/22/24View
    212DevonMiles360 view3517 W. Gray St.PlanoTXPR3 9BQ(214) 555-0156HELOAN05/12/24View
    223KristinWatson360 view2464 Royal Ln.BuffaloNYHD8 4LN(716) 555-0171Cash Out05/18/24View
    234GuyHawkins360 view8080 Railroad St.AuroraCOTS1 6PW(303) 555-0110Rate & TermSelect offer
    245BessieNguyen360 view2715 Ash Dr.SavannahGAWF2 9DE(912) 555-0129Cash Out05/09/24View
    256WadeWarren360 view1901 Thornridge Cir.CharlotteNCOL3 7RS(704) 555-0164HELOAN05/15/24View
    267CourtneyHenry360 view4517 Washington Ave.DetroitMICV1 2AB(313) 555-0147Cash Out05/20/24View
    278LeslieAlexander360 view3891 Ranchview Dr.PhoenixAZSK9 4GH(602) 555-0182Rate & Term04/28/24View
    3The same list, borrower by borrower
  4. AI HelperYou can ask me questions
    or ask to perform simple actions
    What is HELOANWhat is a volume for NCA PurchaseAsk AI a question or make a requestSource of informationGeneralClient-specific
    4Asking the portfolio a question

The whole of it

Designing the decision loop

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

  1. Portfolio + additional data + current rates
  2. Decision engine
  3. Eligibility and score
  4. Opportunity
  5. Borrowers
  6. A specific offer
  7. Email / SMS
  8. Advisor follow-up

Product 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.

From source file to usable data

  1. Bring the source in
  2. Translate somebody else's schema into ours
  3. Check the data before it enters the calculation
File input/ File: Report 231File uploaded2Columns mapped3Preview import

Please preview your data

IDFirst NameLast NameMailing AddressCityStateEmailNumberLoan ProductUPB ProductCurrent Rate
112MitchellHawkins8558 Green Rd.WorcesterMAm.hawkins@yaho…(505) 555-…ConventionalUSP1.10
123AngelEdwards775 Rolling Green…ProvidenceRIa.edwards@gmai…(480) 555-…FHAPOD1.12
134ColleenFox2118 Thornridge C…Rapid CitySDc.fox@outlook.c…(907) 555-…ConventionalUSP1.13
145ArthurLane3605 Parker Rd.KnoxvilleTNa.lane@yahoo.co…(684) 555-…FHAPOD1.11
156EstherRichards1901 Ash Dr.TampaFLe.richards@gmai…(205) 555-…ConventionalPOD1.15
167MarvinBoyd2715 Ash Dr.San AntonioTXm.boyd@yahoo.co…(210) 555-…HELOCPOD1.12
178DianneRussell4140 Parker Rd.MesaAZd.russell@gmail…(602) 555-…HELOCUSP1.11
189RonaldPena1901 Thornridge C…AkronOHr.pena@outlook.…(330) 555-…HELOCUPB1.15
190JaneCooper6391 Elgin St.FresnoCAj.cooper@yahoo.…(559) 555-…ConventionalUPB1.16
211DevonMiles3517 W. Gray St.PlanoTXd.miles@gmail.c…(214) 555-…FHAUPB1.17
223KristinWatson2464 Royal Ln.BuffaloNYk.watson@yahoo.…(716) 555-…HELOCUPB1.18
234GuyHawkins8080 Railroad St.AuroraCOg.hawkins@gmail…(303) 555-…ConventionalUSP1.13
Check if the table has been created asyou expected before importingImport
The two steps before it: the file, and the mapping

File input

Manage active files or upload new one

Port fileUpload new port fileDelete port file
File nameReport23.csvUploaded07/30/202409:41 a.m.Rows525Columns25Most recent calculation07/30/202409:41 a.m.
Pass through fileUpload new pass through fileDelete pass through file
File nameReport23tail.csvUploaded07/30/202409:41 a.m.Rows525Columns25
Rates file
Upload rates file
File input/ File: Report 231File Uploaded2Map columns3Preview import

Now you need to map data

Map columnsAttributes to be assignedColumns from fileMap from previousData Preview from file
First NameFirst nameMitchell, Angel, Colleen
Last NameLast NameHawkins, Edwards, Fox
Mailing AddressMailing Address8558 Green Rd., 3605 Parker Rd., 7529 E. Pecan St.
CityCityWorcester, Providence, Rapid City
StateStateMA, RI, SD
EmailEmailm.hawkins@yahoo.com, a.edwards@gmail.com, c.fox@outlook.com
NumberNumber(505) 555-0142, (480) 555-0119, (907) 555-0163
Loan ProductLoan ProductConventional, FHA, HELOC
UPB ProductUPB ProductUSP, POD, UPB
Current RateCurrent Rate6.875, 6.300, 7.100
Monthly PaymentMonthly Payment2,140, 1,875, 3,260
Payment DatePayment Date08/15/2024, 08/20/2024, 08/28/2024
Next

Daily work

Turn a prediction into a working day

Advisors started with a prioritised set of opportunities rather than preparing a list from the full customer base each morning.

A desk covered with printed spreadsheets, rows of figures too small to read, several lines struck through with a yellow highlighter, a pen resting on top and a hand lifting one sheet.

Start with the opportunity, not the customer table

Portfolio Recapture

Run of 14 May 2024 · 350,000 borrowers in portfolio

ChartTable

Offers

Available Offers for Recapture

Exclude signalsSignals
Use as FilterCash Out RefinanceTotal Equity volumeBorrowers Eligible$47.4B160,622
Use as FilterHELOANTotal Equity volumeBorrowers Eligible$18.2B139,337
Use as FilterRate and Term RefinanceTotal Loan volumeBorrowers Eligible$438M7,771

Loan Product Overview

Breakdown of Loan Products

USDA19%Other16%FHA 30y15%Conv 15y14%VA 30y14%Jumbo 15y11%Jumbo 30yConv 30yHELOC0%

Customers by State

Regional Distribution of Customers

California108,50031.0%
Texas56,00016.0%
Florida45,50013.0%
New York31,5009.0%
Illinois24,5007.0%
Pennsylvania17,5005.0%
Ohio14,0004.0%
Georgia12,2503.5%
North Carolina10,5003.0%
Michigan8,7502.5%
Arizona7,0002.0%
Washington5,2501.5%
Colorado4,2001.2%
Nevada3,5001.0%
Oregon1,0500.3%
CATXFLNYILPAOHGANCMIAZWACONVOR

From internal campaigns to real decisions

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
IDFirst NameMailing AddressPayoff dateCodeOutreach

Portfolio Recapture

Run of 14 May 2024 · 350,000 borrowers in portfolio

ChartTable

Customers

Eligible Borrowers in this Run

Filters

Offers applied to this list

Cash Out160,622
HELOAN139,337
Rate & Term7,771
Hide contacted< than 3 daysCustomizeExport
IDFirst NameLast NameMailing AddressCityStateCodeNumberTypeOutreach
123MitchellHawkins360 view8558 Green Rd.WorcesterMANP7 0LT(505) 555-0142Cash Out05/07/24View
134AngelEdwards360 view775 Rolling Green Rd.ProvidenceRIBB4 7PF(480) 555-0119HELOAN05/07/24View
145ColleenFox360 view2118 Thornridge Cir.Rapid CitySDKT12 2SX(907) 555-0163Cash OutSelect offer
156ArthurLane360 view3605 Parker Rd.KnoxvilleTNAL5 2TR(684) 555-0128Rate & Term05/07/24View
167EstherRichards360 view1901 Ash Dr.TampaFLCM7 5EY(205) 555-0175Cash Out04/19/24View
178MarvinBoyd360 view2715 Ash Dr.BoiseIDSE9 1AA(316) 555-0104HELOAN05/21/24View
189DianneRussell360 view4140 Parker Rd.MesaAZGU2 7XH(702) 555-0198Cash OutSelect offer
190RonaldPena360 view1901 Thornridge Cir.AkronOHDN4 6QT(319) 555-0187Cash Out05/02/24View
201JaneCooper360 view6391 Elgin St.FresnoCALS9 3RB(629) 555-0133Rate & Term04/22/24View
212DevonMiles360 view3517 W. Gray St.PlanoTXPR3 9BQ(214) 555-0156HELOAN05/12/24View
223KristinWatson360 view2464 Royal Ln.BuffaloNYHD8 4LN(716) 555-0171Cash Out05/18/24View
234GuyHawkins360 view8080 Railroad St.AuroraCOTS1 6PW(303) 555-0110Rate & TermSelect offer
245BessieNguyen360 view2715 Ash Dr.SavannahGAWF2 9DE(912) 555-0129Cash Out05/09/24View
256WadeWarren360 view1901 Thornridge Cir.CharlotteNCOL3 7RS(704) 555-0164HELOAN05/15/24View
267CourtneyHenry360 view4517 Washington Ave.DetroitMICV1 2AB(313) 555-0147Cash Out05/20/24View
278LeslieAlexander360 view3891 Ranchview Dr.PhoenixAZSK9 4GH(602) 555-0182Rate & Term04/28/24View

Freshness

Make freshness part of the decision

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.

ActionsUpload pass through fileRun historyDownload XLSXSend emailRun historyChoose one to switchRun #120July 30, 202408:30 a.m.Run #119July 29, 202408:30 a.m.Run #118July 29, 202408:30 a.m.Run #117July 18, 202408:30 a.m.Run #116July 14, 202408:30 a.m.

The rates the whole book is scored against

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%
  1. Rates update
  2. Source changes
  3. Stale run
  4. Recalculate or keep working

A 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 actions
What 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.

Loans15 800Unique customers5 981Consolidation rate20%Conventional1,2648%FHA2,84418%HELOC1,1067%Jumbo3,31821%USDA3,63423%VA3,63423%

Existing against new, by state

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.

Existing customersNew customersTexas7,5911,240Idaho6,9301,510Georgia4,823980Oregon4,106690Kentucky3,5401,120Florida3,147860Maine2,480520Nevada2,065410

Explaining the product was part of designing it

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.

Bring customer data together: the fields a lender already holds, drawn into one place.
Combine data
Enrich it: several sources converging, with the product's own panels around the edge.
Find opportunities
Act on it: the signal picked out of the enriched record.
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.

An ordinary residential street at dusk: modest houses along the pavement, a few windows lit warm from inside, bare trees and parked cars under a deep blue sky.

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.
Next caseUrsa SchoolAn online Serbian language school. I designed the website, booking and learning journeys, and connected them with CRM workflows and automated communication.Read the case studyThe school's site on a laptop in a library: “Serbian language school”, a results guarantee, a free-lesson button and the Ursa Major constellation across the screen.

Open to Senior Product Designer roles

Based in Porto, Portugal, with authorisation to work here. Get in touch about a Senior Product Designer role or to discuss my work in more detail.