Risk Database : Improvements for risk management steering

FOCUS ON: Case studies,

The client is a public financial institution that implements the policy defined by the French Government. It works to fight poverty and promote sustainable development.

THE CHALLENGE

Due to an increase in regulatory requirements and growing expectations of senior management, the institution faced a significant increase in the demand for different risk and finance metrics and analysis. This meant that the organisation’s existing risk database was out of date and no longer fit for purpose, especially with regards to its ability to provide an adequate level of risk analysis. The institution acquired the services of Avantage Reply to support with addressing these shortcomings.

APPROACH AND SOLUTION

The project started with an in-depth gap analysis to determine the areas of improvements needed. From this analysis, key priorities were defined and an action plan was developed around the following key building blocks:

Definition of a new database/data model for the missing risk measures
Functional requirements specifications to develop or enrich the calculation process of these different risk measures
Design and implementation of the improved database
Design and implementation of a risk management tool to calculate large exposures under the COREP production process
Dedicated work related to exposures limits monitoring

RESULTS AND BENEFITS

By the end of the project, the institution had an enhanced risk and finance database which allowed it to optimize, streamline and automate the production of risk reporting and analysis. The new database was able to be used to produce an internal risk dashboard with significantly improved data quality and accuracy.

RELATED CONTENTS

Case Study

IRRBB – Support the transition of the IRRBB metrics computation tool and reconciliation exercise between both outcomes regarding EVE (Economics Value of Equity) and NII (Net Interest Income).

The Client, a huge international bank, request the support of Avantage Reply to further understand and quantify the differences arising between both of their IRRBB metrics calculators. The first, is a hand-made tool provided by the headquarter and the second is a well-known risk software solution used locally. Avantage Reply helps isolating and assessing each of the differences, and in case of materiality, set processes in order to compute overlays. Avantage Reply further helps to add and validate missing products. Validations cover parametrization of the tool, alinement of IRRBB inputs (margin and reference rate) and models (non-maturing products, prepayment, caps, floors,..)

Case Study

IFRS 9 Control Framework

The customer is a retail belgian bank focusing on mortgage loans and consumer credit. Following the implementation of the IFRS 9 ECL calculator, the need arised to implement a control framework to ensure timely and quality calculation and bookings, and integration in the accounting and reporting platforms. Avantage Reply helped the client bridge the distance between different departments to identify the right responsibilities at the right moment in the process to increase its reliability.