During a one year span, I worked with the DBA staff of a national mortgage servicing corporation. The project was to build an “Operational Datamart” from an existing data warehouse. The datamart used a star/cube schema, and used SQL Server Analysis Server to aggregate data cubes.
On top of the architecture, Ben personally built around 70 reports using Microsoft SQL Server Reporting Services (SSRS) for distribution to third party investors and for internal management groups.
External reports were praised by Citigroup as being “far superior to reports that we received from other third party servicers.”