Home / Case Studies / Structured Finance — Reporting Modernization
Loan-portfolio analytics for a modernized loan-servicing platform
Case Study · Banking, Financial Services & Insurance

A legacy loan servicing platform, modernized without rip-and-replace.

Modern, governed reporting bridged onto a 30-year-old AS400 servicing core, without ripping it out.

Sector
Structured Finance
CRE loan servicing
Engagement
SOW → Managed Services
Discovery, then ongoing operations
Timeline
12 months · multi-phase
In-flight
Scope
Reporting modernization
AS400 → Azure · McCracken STRATEGY
Result
Legacy core preserved
Bridge architecture, no rip-and-replace
— The Challenge

Modern reporting on a legacy core.

A commercial-real-estate structured-finance firm ran servicing on McCracken STRATEGY (IBM AS400). Stable and audit-grade, but its reporting lived in hand-built Excel extracts.

  • The need: modern, governed reporting without ripping out the system of record.
  • The constraint: they'd been pitched multi-year, multi-million 'replace everything' programs, and rightly passed.
  • The bar: preserve the audit trail and regulator comfort; add a modern layer on top.
— Our Approach

A bridge architecture, delivered in phases.

  • Lead with a diagnostic, not a pitch.

    Opening weeks spent mapping every report and its real consumers before proposing anything.

  • Design a bridge, not a replacement.

    Kept STRATEGY on AS400 as the system of record; added a daily extract into a modern Azure layer.

  • Medallion architecture for governance.

    Bronze / Silver / Gold layering, raw to business-ready, with governance from day one.

  • Security in the data layer.

    Role-based access via Azure AD, row-level security in Power BI, audit logging at every layer.

  • Own the cross-vendor seams.

    The hard part isn't the tech. It's the seams between us, the Azure partner, and the servicing-software vendor. We owned them.

— The Outcome

What the engagement delivered.

10wk
Discovery to validated future-state architecture
Phase 1 SOW completed on schedule and on budget
100%
Legacy core preserved
McCracken STRATEGY retained as system of record
1
Single point of accountability
Across the client, MSP, and software vendor
~10x
Cost vs. rip-and-replace alternative
Order-of-magnitude saving versus full transformation programs the client was previously pitched
Everyone else pitched a multi-year replacement. Thunderhawk started by understanding what we actually had, then built a modern reporting layer on top of it — audit trail intact, no rip-and-replace.
Chief Information Officer Commercial Real Estate Structured-Finance Firm

Have a similar problem?

If you're sitting on a stable legacy core and a frustrated business user base, and the rip-and-replace pitches don't add up, let's talk about the bridge architecture path.