• 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

Risk and treasury processes automation

FOCUS ON: Case studies,

SUMMARY

Following recommendations from Banque Centrale du Luxembourg (BCL) as well as the findings raised by its internal auditor, the bank wished to automate several operational and regulatory processes conducted by the Risk and Treasury departments.

CUSTOMER GOALS

The project was split across the needs of the relevant departments while covering the subsidiary and branch operations:

1. Risk’s requirements for the tool:

a. Perform liquidity and funding gap calculation

b. Calculate the LCR and NSFR ratios using the EBA templates

c. Review the current IRRBB process and revise it to be compliant with the latest regulatory requirements

d. Build the IRRBB calculation tool (EVE and NII) in line with the best market practices

e. Conduct liquidity stress testing (including its impact on LCR and NSFR)

f. Output “management ready” reports to be shared with relevant stakeholders

2. Treasury’s requirements for the tool:

a. Record and calculate the daily cash flows

b. Calculate LCR and NSFR ratios as well as being able to simulate the impact of specific trades on such ratios

CHALLENGES

When the team began the review and understanding phases of the project they quickly realized that the current processes (i.e. LCR, NSFR and IRRBB) were lacking proper documentation and in some cases had to be revised and formalized before any automation could take place. Nevertheless, the team had to manage the two activities in parallel in order to progress. Lastly, the occasional lack of resource availability pushed the final deadline several times.

SOLUTION

Avantage Reply provided a team of experts with expertise in coding, liquidity risks, interest rate risk and prudential reporting. As part of the project, the team conducted the following:

  • Process review and understanding
  • Regulatory compliance assessment of the current processes (i.e. LCR, NSFR and IRRBB)
  • Process improvement and formalisation
  • Process automation via VBA code (incl. tool development, testing and training of the users)

Final deliverables consisted of the following:

  1. For Risk – tool(s) covering liquidity-relevant processes (i.e. LCR, NSFR, Liquidity mismatch and stress testing) and IRRBB
  2. For Treasury – a Cash Flow tool plus LCR and NSFR calculation and forecasting
  3. Tool documentation explaining the methodology used as well as user instructions
  4. Training sessions with relevant users in order to explain and train them on the usage of the tool

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)