End-to-end risk data warehousing support and CECL report automation for US-based top investment bank

  • 90%

    Automated solution for data sourcing, and processing & addressing manual errors and anomalies

  • 95%

    Automated report generation and publishing

  • Provisioning

    data platform for all other application integration

CLIENT CHALLENGES

  • Extensive expertise in risk reporting, modelling and solutions has made Acuity Knowledge Partners the top choice among chief risk officers (CROs) and their teams
  • Acuity boasts a team with both domain and technical expertise, equipped with advanced analytical and technical skills
  • Acuity’s prior experience in developing a solution and process that addressed regulatory requirements by effectively managing the client’s scattered data made us well suited for the project

OUR APPROACH

  • Acuity deployed a team of six experienced subject matter experts to provide support in data mapping validation and verification, data mapping and lineage documentation as per CECL requirements, out-of-process transformation and adjustments and their documentation. In addition, the team assisted in ETL and/or data design while reviewing and ratifying the overall process
  • Supported ETL design and development for all out-of-turn adjustments currently performed manually to data elements/attributes
  • Built an approval form using Microsoft PowerApps for the approval of model data
  • Functions supported:
    • Development: Data loading and data aggregation to generate refined data for CECL validation; Validation-process set-up; Documentation
    • Support: Ongoing CECL maintenance and support; Documentation and data support for external audits; Documentation
    • Governance: Data Quality rules to detect and notify data issues

IMPACT DELIVERED

  • The team studied the existing data and key attributes thoroughly and classified them by complexity, materiality and business/regulatory considerations. The results were used for setting up the validation process and smoothened the development and testing of the solution
  • Helped define the process for CECL data validation and handled communications with CECL validators
  • Provided highly qualified and experienced personnel at a fraction of the cost
Download as PDF
Thank you for sharing your details

Your file will start downloading automatically

If it does not download within 1 minute,

Share this on

What we have done

Sophisticated quantitative modelling for capital structure analysis
What we are proud of

>50%

reduction in annual cost

5X

increase in client hedging pitches

Read more
Risk profiling and hedging strategy using derivatives
What we are proud of

2X

increase in client analysis

50%

lower costs vs direct hires

Read more
Model enhancement support for US-based asset manager
What we are proud of

55+

models covered across multiple asset classes

12+

FTEs specialising in multiple disciplines

Read more
Investment risk analytics and reporting support for global asset manager
What we are proud of

>50%

reduction in annual cost

150+

funds covered, producing daily risk metrics and dashboards

Read more
End-to-end MRM support to US-based top investment bank
What we are proud of

2x

model coverage for MRM

60%

lower costs vs direct hires

Read more
See All Case Studies