• about reply
Avantage Reply Logo
Menu
  • About Us
    About Us
    • About Us
    • History
    • Our Approach
    • Values
    • Alumni
    • Strategic Partners
    • Media Contacts
    • Contact Us
  • Our Capabilities
    Our Capabilities
    • Our Capabilities
    • Risk
    • Insurance
    • Finance
    • Conduct & Compliance
    • Technology
  • Newsroom
    Newsroom
    • Newsroom
    • News
    • Events
    • Press Articles
    • Blog
    • Academy
  • Publications
    Publications
    • Publications
    • Briefing Notes
    • Case Studies
    • CRO Insights Journals
    • Infographics
    • White Papers & Practical Guides
  • Career
    Career
    • Career
    • BELGIUM
    • FRANCE
    • ITALY
    • LUXEMBOURG
    • NETHERLANDS
    • UK
  • about Reply
Avantage Reply Logo

Search

Focus On

Case Study

Finance & Risk referential

FOCUS ON: Case studies,

SUMMARY

Avantage Reply supported a large European bank in (re)writing operational and regulatory Risk reports by respecting the principles for effective data aggregation and reporting with regards to BCBS 239 guidelines.

Avantage Reply converted Shadow IT into target reports production processes leveraging Data governance, but has also defined and automated final report quality controls using the Dataiku tool.

CUSTOMER GOALS

The bank wished to optimize the current production process and to get the production of a fully managed report through the deployment of a new tool like Dataiku and the usage of a component like Finance & Risk referential.

The goal was to obtain reports natively reconciled on the basis of Finance & Risk referential which has led to a reduction of time dedicated to analyzing and solving discrepancies between Risk and Finance reports.

CHALLENGES

One of the main difficulties was to estimate with accuracy the amount of data non-present in the current Datamart, and this was in order to build up the Finance & Risk referential in the best possible way.

Regarding compliance, issue as non-compliance BCBS 239 principles could lead to penalties. Regulatory instances could also decide to increase RWA (by applying a multiplying factor to ensure conservatism margins), or in extreme cases, decide to apply a change of RWA methodology calculation. Thus, compliance with these guidelines for effective data aggregation and reporting was crucial.

SOLUTION

The project was conducted in a two-phase approach due to the difficulty of estimating with accuracy the number of data non-present in the current Datamart. The first phase, about reports technical analysis, has been dedicated to studying reports, contributing and feeding reporting tools, to determine which indicators should be added to the existing Datamart and written technical specifications. The second phase was about the reports’ development and more specifically about the integration of missing data into the Datamart. This working method allowed us to create aggregate indicators to facilitate Risk and Finance data usage and then to write the report by using Dataiku tool.

Furthermore, because this project follows BCBS 239 guidelines, a glossary was put in place to ensure data provided in reports was consistent with regulators expectations or internal data usages.

RELATED CONTENTS

Case Study

Supporting daily ALM activity and reporting

Avantage Reply assisted a Finance department of a well-known private bank in daily activity and reporting production of the Assets and Liabilities Management team. The key tasks were assist the team in the improvement and preparation of the Internal Liquidity Adequacy Assessment Process (ILAAP), advise on the regulatory requirements and contribute to the implementation of local.

Case Study

Testing of liquidity regulatory reporting in light of the new BO system

Avantage Reply assisted a Finance department of a well-known private bank in the connectivity test phase within back office tool migration. The project covered a wide range of activities such as conducting multiple User Acceptance Tests (UAT) with on-shore teams, verify the impact of the change on regulatory reporting.

Case Study

Finance reporting support

Avantage Reply assisted a Finance department of a well-known private bank in daily and monthly reporting production related to liquidity. The key tasks were: produce and certify various regulatory reports, such as LCR, AMT, NSFR incl. contributions to group consolidated reports; produce and certify integral liquidity reports based on inputs from various business line.

 ​
 
 ​
 
Reply ©​​ 2023 - Company Information -
 Privacy Cookie Settings​
  • Abou​t Reply​​
  • Investors​​​
  • Newsroom
  • Follow Reply on
  • ​
​
  • ​About Avantage ​​Reply
  • Privacy & Cookies Policy
  • Information (Client)​
  • Information (Supplier)
  • Information (Candidate)