Risk Reporting Platform
Strategic Risk and Regulatory Reporting Platform
The engagement encompassed the delivery of a single consolidated strategic platform at a Tier 1 global bank to handle Risk and Regulatory Reporting, MI reporting and other external stakeholder reporting commitments.
Background
Post the global financial crisis, the bank had undergone massive scrutiny for their Risk management and regulatory reporting practices. To satisfy Regulators and other Stakeholders, the bank had undertaken a strategic transformation of their Risk reporting platform.
- Legacy reporting platform had different physical instances of daily / weekly / monthly reporting.
- Legacy reporting tool was on out-dated technology.
- Legacy reporting process had many manual steps and dependencies for final report productions and submissions to regulators.
- Legacy platform had many data quality and reference data issues leading to data adjustments and corrections.
Approach
- Designed single consolidated platform for daily / weekly / monthly reporting.
- Defined industry standard conceptual data model and data warehouse.
- Gap analysis on data sourcing and processing mechanism to reduce data quality impact.
- Analysed Retail and Wholesale data requirements for complete coverage of Exposures and Limits for Risk Reporting.
- Replaced ALL regulatory reporting, including IFRS, Basel II, inflight Basel III, COREP, FINREP and other MI reporting such as Intra-Group Reporting, Large Exposure Reporting, etc. Analysed Country Risk reporting framework.
- Gap analysis of current data feeds against data requirements..
- Defined revised Target Operating Model for risk reporting.
- Service level agreements with source data providers.
- Operational level agreement with data consumers.
Solution
- Single and common data warehouse for all Risk reporting.
- ETL solution for Exposure v/s Limit reporting.
- ETL solution for Collateral management and Risk Mitigation.
- Country Risk Transfer and Reporting framework.
- OBIEE based risk reporting for all Regulatory Reporting, COREP, Capital and other stakeholder reporting.
- Enhanced reporting for day to day analysis for business community.
- Automated data capture and control framework for reducing manual processes and data adjustments requirements.
Benefits
- Supported Bank’s license to operate. Improved Regulatory confidence with the Financial Services Authority (FSA).
- Improved timing of reporting, accuracy and completeness.
- Reduced reconciliation and data input effort and improved process workflow.
- Reduced infrastructure maintenance and support cost due to single platform for different reporting.
For more information about how we can help you please contact us
Krishan Gopal
Principal Consultant
Credit and Market Risk
Recent Case Studies
Extensibility & Scalability of Data Warehousing
In order to minimize bad debt volumes, this…Read more
End to End Data Warehouse Testing (FDSF)
The PRA initiated an industry-wide programme called FDSF…Read more
Delivery that counts
Our track record for end to end delivery speaks for itself. In our short history, we have delivered some of the most complex business and IT change across some of the worlds largest organisations. Our people are happy and so are our clients. If you would like to know more about a career in ACS please click here.