Calsoft was engaged to design and develop a Kimball-style data warehouse.
The engagement primarily involved:
Data sourcing and staging
Operational data store design and development
Dimensional modeling and data mart design
ETL design and development using SSIS and SQL Server
Benefits:
Reliable single source of truth for the Default Servicing team
Improved loan recovery rates
Improved predictability from the borrowers’ perspective via objective, data-driven decision-making