Building a Enterprise Data Warehouse for Fraud and Statutory Reporting in the Banking Sector


Just one more Comprehensive Enterprise Data Warehouse implementation done by DataSimplified. Data Analysis, Data Integration and Presentation is our playground

Enterprise Data Warehouse

Our Bread and Butter.

The customer had a need for a Single Centralised Universal Ledger to report across the entire banks internal banking core systems and their 19 alliance partners.

By building a USL (Universal Sub Ledger) solution for the bank that takes care of the different Banking entities relationships, and building up a hierarchy with the data, we were able to deliver a fully functional Enterprise data warehouse with full recon of data, as well as Suspense account management, and statutory regulated reporting in 6 months.

AML reporting use to take 3 resources working non-stop to deliver the Anti Money laundering reporting to the regulators, but with the new system this was an automated process that ran on the data in the Enterprise data warehouse and immediately made the bank compliant with regulation at a reduced expense. Allowing the freed-up resources to be better allocated for other key rolls.

Key Features:

AML Reporting

  • 3 resources working fulltime on reporting for 12 months
  • 810 Hours of effort saved per year

Operational Reporting (Daily Checks:)

  • 2 resources fulltime allocated to measure data processes, prepare queries and finding data
  • 540 hours of effort saver per year

Support of original System versus EDW solution

  • Solution is self-maintained and autocorrects late or missing data when received.
  • Original legacy system had maintenance costs of R1,68 million per year, this is now being done be a single resource for a portion of his daily effort.

Other reporting included:

  • SACRRA reporting
    • SACRRA requires all financial institutions to report information on their customers’ credit and risk profiles to credit bureaus on a regular basis.
  • BOPCARD Reporting
    • BOPCARD reporting on details of the cardholder’s identity, transaction history, and other relevant data.
  • IT3b Reporting
    • The IT3b report is a summary of all tax-related transactions for the financial year, including interest, dividends, and capital gains, earned by an individual.

Technologies used:

  • CloverDX
  • Microsoft SQL server
  • Power BI
  • Microsoft SQL Server Cube and Analytical services


Using the best in class Software Development frameworks, World class ETL and Data Integration platforms, and Reporting solutions, we can build Solutions for our customers that cover their requirements and allow them to grow their business.


Development and design of data warehousing and reporting solutions, with focus on Data Quality and Complex ETL (Extract Transform Load) processes.

Software Development

Development Services – C#.Net, SQLServer, AbInitio, CloverDX

System Integration

System Integration services to connect business applications


Simplified Server Hosting, Email Hosting, Website Hosting


Database Implementation, Design and Maintenance Services

Custom Development

Custom Development of Products and Solutions in ASP.NET ZERO


Internationally acclaimed Online HRIS Solution to Simplify HR management


Google Advertising, Digital Marketing, Design and Social Media Services


087 378 1154


082 498 3254


8:00am – 5:00pm