Divisional Data Warehouse for a Top US Mortgage Lender

The project involved the design and development of a Kimball-style data warehouse. Tasks included data sourcing and staging, operational data store design and development, dimensional modeling and data mart design, and ETL design and development using SSIS and SQL Server.

Benefits

  1. Reliable single source of truth for the Default Servicing team
  2. Improved loan recovery rates
  3. Improved predictability from the borrowers’ perspective via objective, data-driven decision-making