Case study 


Operational Risk Reporting System for
Banking Institution

bg consulting pagexcf.jpg
The Challenge
  • Automating manual tasks

The Solution
  • In-depth statistical and industry practice analysis

  • Enhancement of the reporting system macros

  • Front-end changes related to the reporting control panel

  • visual improvements in the report templates

  • and more

The Impact
  • Flawless automated reports

  • No need for manual error checks

  • Reduced time and costs

  • Extensive documentation

  • Ongoing maintenance services

Read full Case Study
Challenge.png

The Challenge

Our client is a  banking institution in the middle east with a significant focus on the corporate and financial institutions sectors, as well as having growing retail, and private bank customer base.

The Operational Risk department approached Senacea to deliver a range of services related to the Operational Risk Reporting system of the institution. 

 

The initial consultation call led to an in-depth statistical and industry practice analysis (including Basel capital requirements) concerning the choice of Monte Carlo modelling elements, Operational VaR modelling (value at risk), and model accuracy testing among other features, which enabled generating automated reports, eliminating errors and saving hours of manual work.

The Solution

Solution.png

Senacea began by evaluating existing files for opportunities to automate, error-proof and standardise their use and created a bespoke solution that will be managed in-house and enable future expansion. The process of the spreadsheet system design involved:

Validation of the VBA & SQL code (10 000+ lines), Excel-based templates & computational logic behind the report calculations

In-depth statistical and industry practice analysis  (including Basel capital requirements) concerning the choice of Monte Carlo modelling elements (choice of variables modelled, simulation distribution formula, sample size, significance level choice), Operational VaR modelling (value at risk), model accuracy testing (Kolmogoroff Smirnoff test)

Enhancement of the reporting system macros - adding new computational mechanisms to macros, preventing errors, allowing for troubleshooting incomplete data uploads and spotting missing data

Front-end changes related to the reporting control panel (report parameter selection mechanism, visual side of the menus)

A range of visual improvements in the report templates

Optimisation of the MS Access database including assurance of data correctness, removing potential duplicates and highlighting data formatting issues

Revision and recreation of the data uploading systems

Documentation of the report generation steps, macros, templates, reporting file, statistical concepts used & Monte Carlo simulation assumptions

Benefits.png

The Project Impact

With the new Operational Risk Reporting system, the company now benefits from:

Flawless automated reports

No need for manual error checks

Reduced time and costs

Increase your efficiency & profitability with our industry-leading VBA Consulting Services.

Empower your team by removing repetitive work, standardising document production and leveraging VBA macros to intelligently automate work

Automation.png