CRO risk data, CECL, analytics and reporting for a US-based bank

  • Scalable automated solution

  • One centralised data warehouse

  • Automated reporting


CLIENT
  • US-based bank
  • Key challenges were
    • Business operations managed in silos
    • Multiple data definitions and frequent data transformation requests
    • Multiple systems to manage data
    • Fast-paced regulatory changes and business demands
OUR APPROACH
  • Deployed a team of experienced subject matter experts to support data mapping validation and verification, data mapping and lineage documentation in line with Current Expected Credit Loss (CECL) requirements
  • Transformed and standardised data points into common data format
  • Validated sourced risk data for completeness (including risk factors) and integrity
  • Suggested precise data taxonomy and maintained data dictionary
  • Defined and developed data staging and a central data warehouse structure to assist in enterprise data aggregation to support diverse data integration, enterprise data governance and metadata management
  • Automated risk data aggregation and control to reduce errors
  • Enabled the generation of accurate, comprehensive and clear reports for effective decision making, using PowerBI and PowerApps
IMPACT DELIVERED
  • Acuity Knowledge Partners assisted in ETL and/or data design while reviewing and ratifying the overall process.
    • Accelerated data streamlining and availability to support data mapping validation, documentation, risk data aggregation/transformation with documentation, in line with CECL requirements
    • Reduced manual error and anomalies by automating data sourcing and validation
    • Improved turnaround on report generation and publishing
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

API-based access to analyst credit research model data for advanced analytics and visualisation for top-tier European asset manager
What we are proud of

Lead generation

Customer screening

Risk data, application management and reporting for a consortium of 20 development banks
What we are proud of

Lead generation

Customer screening

Centralised risk data warehouse including APIs for a bulge bracket investment bank
What we are proud of

Lead generation

Customer screening

Enterprise Application Development And Data Management Streamlining For a US Pension Advisory Firm
What we are proud of

Lead generation

Customer screening