Legislative and Compliance Reporting
To compile and report on various risk,
solvency, capital, profitability and liquidity metrics as mandated by the Bermuda Monetary Authority.
The biggest challenge in this case was to compile the data required and consistently format it so
that each time the BMA mandate needed to be met, the process could be repeated and could be
trusted to be accurate.
Extend the client's existing Data Warehouse to include any additional data required by the BMA
and then set up Reporting Services reports to produce the required information.
Implement a User Acceptance Testing program for the client so that the users could easily verify
that the reported data reconciled to any other system in which it was used.
- Integration Services packages to bring additional BMA data in to the Data Warehouse.
- Analysis Services cubes to allow slicing and dicing of data across different dimensions
- Reporting Services reporting pack over the cubes to produce the BMA reports.