2–3 hrs
daily, per specialist — removed
Mortgage GL reconciliation
A reconciliation specialist spent two to three hours every day
cross-referencing three disconnected systems — Power BI, the loan
origination system, and the A&B ledger — to classify and route GL
discrepancies across more than a hundred open cases. None of it was
written down anywhere.
Getting it out of one person’s head was the actual work: structured
interviews and live training sessions, turned into engineering
requirements, then into a production pipeline in Python, SQL and
PySpark with statistical matching over thousands of transaction records.
The data-fetching layer underneath is deliberately LOS-agnostic, with
automatic system detection, so the same automation runs identically
across Encompass, MeridianLink and Blue Sage. That was not
future-proofing for its own sake — an LOS migration was already in
flight, and a rewrite mid-migration was the thing to avoid.
Python · SQL · PySpark · Power BI · Encompass · MeridianLink · Blue Sage
$18.2M
UPB live at first deployment
Ginnie Mae pool delivery
SettleDesk went to production for Ginnie Mae pool delivery and was live
on its first deployment: 4 pools, 47 loans, $18.2M UPB, with 74 pending
final certifications.
Underneath it, PoolPath merges ULDD XML loan exports from three
different LOS platforms into valid Ginnie Mae PDD XML for SFPDM
submission, correcting schema errors automatically instead of bouncing
the file back to a person. A separate parser reads settlement and
commitment dates out of unstructured warehouse-bank correspondence and
populates the post-closing intake pipeline from it.
Claude API · ULDD / PDD · MISMO · XML schema validation · GNMA SFPDM
18 → 9 min
pull-request check time
Enterprise CI/CD platform, security stage
I own the security stage of a five-stage CI/CD platform at a regulated
mortgage lender — CodeQL, secret scanning and dependency review
running in parallel, which halved pull-request check time from 18
minutes to 9.
The gates are built to prevent rather than report: secret scanning with
push protection, a CRITICAL-severity CVE that fails the build, and
required-reviewer branch protection. Azure infrastructure is Bicep —
Container Apps, Key Vault, Container Registry, user-assigned managed
identity — authenticated through OIDC federated credentials with no
stored secrets, deploying incremental-only to protect brownfield
resources.
The pipeline holds zero write access to IAM. Humans provision identities
and secrets by hand, because a regulated lender will not allow
self-service permissions, and the least-privilege model had to be
designed around that constraint rather than argued with. Any engineering
team onboards to the whole platform by copying three files and raising
one pull request — same day, against an estimated two to three weeks.
GitHub Actions · CodeQL · Azure · Bicep · OIDC · DevSecOps