Case Study:

South African Reserve Bank

Project description

ERSD B Forma & C Forms Digital and Analytics Solution

Classification

High Priority Tier One Project

Project Duration

October 2018 – March 2024

Country

South Africa

The Challenge

The South African Reserve Bank’s Economic Statistics and Research Department (ERSD) relied on manual, time-consuming processes to capture and process critical financial industry forms (B Forms and C Forms). These forms feed directly into the calculation of national inflation indexes and assessments of country-wide financial stability - data that informs South Africa’s monetary policy and macroeconomic decision-making.

Key challenges included:

Highly sensitive financial data requiring stringent regulatory compliance
Complex, dual-project workflows running simultaneously under Tier One priority
Need for near real-time insights instead of weeks-long manual aggregation
Requirement for a robust, scalable, and future-proof analytics platform

Our Solution

Digital Knowledge, through Senior Solution Architect, Data Architect and Data Engineer Robert Dobson, delivered a complete turnkey Business Intelligence and Custom Development solution using an Agile delivery framework.

Transformed weeks of manual data processing into near real-time insights
Enabled SARB’s statistics department to calculate inflation indexes and assess national financial stability with greater speed, accuracy, and confidence
Delivered an agile, robust, high-performance reporting platform supporting current and future requirements
Provided a powerful combination of self-service analytics, strategic dashboards, and custom operational reporting
Significantly reduced human error and improved data integrity for macroeconomic policy decisions

The solution was designed for both on-premise stability and regulatory-grade security while enabling daily analysis and near real-time reporting.

Premium Solutions

Results & Business Impact

Transformed weeks of manual data processing into near real-time insights
Enabled SARB’s statistics department to calculate inflation indexes and assess national financial stability with greater speed, accuracy, and confidence
Delivered an agile, robust, high-performance reporting platform supporting current and future requirements
Provided a powerful combination of self-service analytics, strategic dashboards, and custom operational reporting
Significantly reduced human error and improved data integrity for macroeconomic policy decisions

Key Solutions

Technologies We Used

Microsoft Development Stack

Microsoft Stack: SQL Server, .NET Core, ASP, C#, JavaScript

Oracle Business Intelligence Stack

Oracle Stack: Oracle DB, Oracle PL/SQL, Oracle ODI, OBIEE

Custom Financial Engineering

Custom development of Financial Calculation Engine

Data Modelling & ETL Architecture

Star Schema Data Modelling, ETL Automation, Operational Data Store & Data Marts

Next Steps

Ready to transform your data into policy-shaping insights?

Testimonial

Client Quote

"Robert Dobson has played a key role as Senior Solution/Data Architect/Data Engineer in the BI solution implemented at SARB. He is highly skilled and competent in the Business Intelligence/Data Modelling/Data Warehousing and Analytics domain. He has shown commitment and dedication to the success of the project. He has strong communication skills and interacts very well with Business Users in understanding their requirements. I highly recommend Robert Dobson and the role he played in Architecting, Designing and Implementing the BI solution for SARB.”"