Case Study |

Delivering Data Mart for LCR and FR 2052a (5G) Reporting


The Company

A multinational financial services holding company operating in over 50 countries (Investment Banking, Retail Banking, Private Banking).

The Challenge

After the 2007 Inter-banking crisis, the G20 launched an overhaul of banking regulation, known as Basel III. In addition to changes in capital requirements, Basel III contains entirely new liquidity requirements: the Net Stable Funding Ratio (NSFR) and the Liquidity Coverage Ratio (LCR). Also, on November 1st, 2013, the Federal Reserve Bank (FRB) released the 5G proposal, a new approach for quantitative funding and liquidity monitoring and supervision.

The Goal 

Create a new Fed Data Mart that would serve as the integrated database for LCR and 5G reports providing a) automated data collection, b) ability to generate 5G report on T+2 basis with as little manual intervention as possible and c) use of 5G database for LCR generation.

Project Phases

An Agile approach was used to deliver the required automated IT solution. Project team formation was a first step before Project scoping and BRD. Data Acquisition was next with data sources identification for the required Trades, Balances, and Reference Datasets. We followed up with Data harmonization scope and approach. A full inventory of data attributes was created for all source feeds. Attributes required for 5G report were also identified. The Functional specifications were created to cover enrichments and calculations after which we started the design of the Process flows, Logical data model, Enrichment logic details, Manual uploads details, Data feed specifications and layouts. We finally drove the project through the usual delivery processes from Build, UAT, Go-live and business adoption.


Challenges faced throughout the project can be broken down into following categories:

  • Defining Roles and Responsibilities: Treasury, Financial Accounting, Reg Reporting, and Finance were all involved at the start of the project. Project ownership and steering processes had to be clarified and agreed upon.
  • Project scope and requirements: The Fed requirements changed often during the course of the project. This required specific attention to avoid discrepancies in the deliverables and confusion among project team members.
  • Testing approach: The extensive scope led to several iterations to all settle on a test methodology. Our systematic approach led to an agreement with all involved parties.


The automated 5G solution now collects quantitative information on selected assets, liabilities, funding activities, and contingent liabilities on a consolidated basis and by material entity subsidiary. It enables the bank to submit the consolidated data in compliance with the Fed requirements.

The 5G solution provides the foundational components required to feed the LCR calculation. LCR enables the bank to better monitor its liquidity risk profile and will improve the bank’s ability to absorb shocks arising from financial and economic stress.