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

  • Scalable automated solution

  • One centralised data warehouse

  • Automated reporting


CLIENT CHALLENGES
  • 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 as per requirements of the Current Expected Credit Losses (CECL) standard
  • Captured/collected information from multiple sources within the organisation, automating the data sourcing where possible
  • Transformed and standardised data points into a common data format
  • Validated sourced risk data for completeness (including risk factors) and integrity
  • Suggested precise data taxonomy and maintained a data dictionary
  • Defined and developed data staging and a central data warehouse structure to assist in data aggregation to support diverse data integration, data governance and metadata management
  • Automated data aggregation and control to reduce errors
  • Generated 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 supporting CECL data requirements and data mapping validation, documentation, and aggregation/transformation with documentation
  • Reduced manual errors and anomalies as a result of automated 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

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

>50%

savings in staffing costs

25%

increase in outreach

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

>50%

savings in staffing costs

25%

increase in outreach