16 enterprise data warehouse and analytics projects across banking, insurance, telecoms, retail, logistics, mining, and the public sector.
Led the full migration of a Telecoms company on-premises SQL Server DW to Microsoft Azure Synapse Dedicated SQL Pool. Scope included infrastructure assessment, Synapse provisioning, data migration via ADF and PolyBase, T-SQL stored procedure refactoring for cloud compatibility, Columnstore index optimisation, workload management, row-level security, and Azure DevOps CI/CD setup. Decommissioned the on-premises SQL Server 2016 cluster within 6 months.
Built a trade finance DW consolidating letters of credit, guarantees, documentary collections, and SWIFT messaging for Standard Bank's CIB division. Dimensional models aligned to BASEL III and SARB requirements. Automated reconciliation between trade finance systems and GL, with daily regulatory extract generation. Deployed via Azure DevOps CI/CD with automated regression testing for all stored procedures.
Redesigned a major banks retail banking DW, migrating from a legacy Oracle-based warehouse to Azure Synapse Analytics using Data Vault 2.0. Implemented Hub-Satellite-Link models covering customer, account, transaction, and product domains. CDC from Temenos T24 and card systems via ADF. Gold-layer semantic model serving 300+ branch manager Power BI dashboards.
Consolidated data from SanlamAllianz, Sanlam Invest, Glacier, and MiWay into a single enterprise DW on Azure Synapse. Designed cross-entity conformed dimensions (customer, advisor, product, date) and a Hub-and-Spoke Gold architecture enabling group-level reporting. Implemented RLS ensuring subsidiary data segregation while enabling group consolidation views. Decommissioned 9 legacy reporting databases.
Designed a dedicated actuarial and finance DW consolidating policy, premium, claims, and reinsurance data from legacy mainframe and AS/400 systems. Gold-layer tables supporting IFRS 17 liability reporting, embedded value calculations, and Prudential Authority regulatory submissions. Columnstore indexes and materialised aggregations processing 10M+ policy records within SLA.
End-to-end medallion architecture DW on Azure Synapse Dedicated SQL Pool covering Device Insurance domains: Claims, Policies, Policyholders, and Premiums. Complex JSON extraction via OPENJSON/CROSS APPLY for nested policy data. BIGINT key resolution for 16-digit contract numbers. SAST timezone normalisation. Full BI consume layer with Power BI semantic models and paginated reports. 23.5M+ insurance records processed.
Bronze/Silver/Gold stored procedure pipelines for Botswana insurance data migrated from AWS S3 to ADLS Gen2 via ADF. Pro-Forma Bordereau tables for Life and Non-Life Claims. Death claim reconciliation project linking Credit Life death claims to Device Insurance policy terminations, surfacing Audit'26 Finding 3 discrepancies and producing regulatory-ready reconciliation reports.
Centralised retail analytics DW consolidating POS, inventory, supplier, and loyalty data across 2,800+ stores. Star-schema dimensional model with conformed dimensions for product, store, date, and customer. High-volume ELT processing 50M+ daily transactions into Azure Synapse. Margin analysis, basket analysis, and stock optimisation via Power BI embedded analytics.
Greenfield enterprise DW for one of Southern Africa's largest logistics operators. Consolidated TMS, WMS, and ERP data into Azure Synapse Dedicated SQL Pool. Bronze/Silver/Gold pipelines via ADF, dimensional models for shipment, fleet, route, and financial domains. Power BI dashboards across 14 business units. 200+ daily active operational users.
Municipal DW integrating billing, rates, water, electricity, and service complaint data across 7 departments. Medallion architecture on Azure Synapse with a citizen 360 Gold layer. GIS-integrated Power BI dashboards enabling ward-level service delivery monitoring. Revenue leakage identification dashboard for the CFO and City Manager's office.
Operational DW for Southern African mining operations integrating production, safety, equipment maintenance (SAP PM), and ore grade data. Time-series fact tables for shift-level production metrics. Dimension models for mine, shaft, crew, and equipment. Predictive maintenance dashboards and production variance reports across 5 PGM mines.
End-to-end financial DW supporting CrediApp's loan book, collections, and client performance analytics. Medallion architecture covering loan origination, repayment schedules, DebiCheck collections (QuinnPay), and default classification. QuinnPay, Capitec Business Bank, and NCR compliance reporting in a unified Gold-layer analytical store. AccountANT dashboards for real-time P&L, cash flow, and client ledger views.
ADF pipeline migrating structured insurance data from Amazon S3 (af-south-1) to Azure ADLS Gen2, with Parquet schema mapping, column name sanitisation, and automated Bronze-layer registration. IAM-based credential management and parameterised pipeline triggers. Zero data loss cross-cloud transfer with schema drift detection.
Developed a paginated stored procedure extracting 23.5M rows in 10,000-row chunks using ROW_NUMBER() temp-table pattern to overcome ORDER BY constraints in Azure Synapse Dedicated SQL Pool. Workload management groups prevent resource contention during large batch loads alongside concurrent BI queries.
Spatial ML model predicting GBV hotspots across South African townships, integrating census, social, and incident data. GeoPandas feature engineering, XGBoost with spatial CV, SHAP explainability for community transparency, and interactive choropleth visualisation. Aligns to UN SDG 5 and 11.
We're actively taking on new data warehouse projects. Let's discuss your requirements.
Start the Conversation →