Challenge: 

Producing an Institution-to-Institution Credit Exposure Report, to fill a data gap identified by the Financial Stability Board. 

Context and Solutions: 

Delv initially built a matrix to clarify the requirements, which encompassed over two thousand items, and identify possible data sources, solutions, and gaps.   A prototype was then built in SQL that was used iteratively, in an Agile manner, to model the various report components for rapid data validation by SMEs. In parallel, a major challenge was remediating gaps in data coverage given a lack of automated data feeds from many CCPs and carrying brokers.  A third stream involved enhancing an existing reporting tool to allow various departments to populate data that could not be sourced automatically.. 

Results: 

The prototype solution delivered by Delv successfully automated 99% of the report items, and the client was able to meet the regulatory reporting deadline, thus contributing to the FSB’s ability to understand the exposures of global financial institutions to each other.  Delv’s prototype and documentation was then used by the client to deliver a productionized solution.