Successful Datamart Design & Implementation for Midsize Bank

Midsize bank

Client Challenge: 

A bank client engaged Oakleaf Group in response to having been identified as a Large Institution Supervision Coordinating Committee (“LISCC”) Firm.  The bank needed assistance designing and implementing a data aggregation datamart containing CCAR Stress test results. The datamart’s purpose was to aggregate, reconcile, transform and consolidate stress testing results across business lines and categorize results into reporting (FR Y14) asset categories. The datamart fed downstream systems which submittd regulatory reports.  

Oakleaf Approach: 

Over the span of approximately 7 months Oakleaf’s 7-person team designed and developed a consolidated CCAR results aggregation capability, and aided in operating the aggregation facility during the annual year-end execution cycle.  To assist the bank with their needs, Oakleaf provided business and data requirements analysis as well as asset taxonomy analysis to support mapping and de-duplication. We designed, implemented and tested CCAR results aggregation in the datamart. Finally, we provided operational support to our client for stress testing execution.  This collective approach ensured the success of the project and exceeded the client’s expectations and needs. This factored into the client’s decision to re-engage Oakleaf for further development of a complete end-to-end CCAR and PPNR execution capability.

Result: 
  • Sourced multiple books of business from systems of record.
  • Ensured data readiness for use as actuals and as model inputs for stress projections.
  • Developed mapping from internal asset categorization to Y14 line items; ensured no duplication in assets reported.
  • Business Overlays incorporated into end-to-end process.
  • Execution times reduced by 60%-80%; provided more time to review and analyze results during execution.
  • Utility served as foundation for expanded end-to-end execution; addition of model execution in subsequent years.