Built a data warehouse created from a federated data model from the databases of non-integrated information systems supporting actuarial, financial, and operational departments which were not previously integrated. The system was constructed with Microsoft’s BI Suite (SIS, SSAS, and Excel). Employing the Kimball methodology, ad hoc reporting was provided by Microsoft Analysis and Reporting Services with customized MDX queries and KPI’s.