Risk Analysis and Capital Reporting Application to automate the data collection process, calculation, production and submission of routine regulatory reports
Background
- Comply with the FINMA regulatory requirement to report enterprise-wide quarterly stress losses for comparison with other risk measures impacting the firm’s capital adequacy
- Leverage the above requirement to better understand how the firm’s capital position changes under stress
- Improve ERM stress testing operationally and increase the value add to management
Objective
- Develop a reporting platform to automate the process of data collection, calculation, production and submission of FINMA quarterly reports
- Design a method to provide commentary to risk metrics at various levels of the business hierarchy
- Provide customised reporting with flexibility of drill down, dynamic aggregation and grouping
CRISIL's solution
Solution Development
- Developed end-to-end reporting automation platform/user interface
- Developed the Client Server Architecture
- Detailed the designing using patterns and frameworks such as MVC and Tableau
- Worked with a combination of RDBMS/Oracle and Stored procedures
- Used linear and non-linear calculations rule-based engine
Project Management
- Engaged with diverse function business users for detailed functionalities, gap analysis, data dictionaries and specification docs
- Created a functional architecture of the platform
- Led the requirements management for the platform
- Ensured the quality and successful delivery of the platform
- Ensured a smooth transition of end users to the platform
Client impact
- Comply with FINMA regulatory requirements
- Improve the understanding of the firm’s capital position under stress
- Improve stress testing operationally
- Improve controls and transparency, and reduce restatements to the regulators
- Allow users to adapt reporting to the needs of the regulator on a quarterly basis
- Significantly reduce the time and resources to produce the quarterly reports
- Increase value adds to senior management
Questions