Projects
A medallion architecture (Bronze, Silver, Gold) on Databricks with Delta Lake, serving as the single source of truth for Afreximbank's analytical workloads. Unity Catalog provides central governance, role-based access and lineage tracking.
Production ETL/ELT pipelines that extract data from the Oracle Finacle core banking system and the Calypso treasury system into PostgreSQL and Delta Lake. Change Data Capture keeps treasury and cash-management analytics in near-real-time sync. Deployments run through GitHub CI/CD.
An MDM solution that consolidates counterparty data from four enterprise systems (CRM, Finacle core banking, Calypso treasury and ERP) into a single golden record for the institution.
Automated data quality pipelines on Databricks that measure completeness, consistency, accuracy and timeliness across data domains, combined with ML-based validation, fraud detection models, business-rule checks and alerting.
An automated Databricks ETL pipeline for infrastructure datasets from six countries in mixed formats (.csv, .xlsx, .gpkg, .tiff), with a rule-based data quality framework, YAML configuration and integration into the CPP toolkit's web interface.
Reproducible R scripts and R Markdown reports analysing MHPSS data across eight West African countries, plus impact evaluations on migration in Guinea, The Gambia, Nigeria and Senegal.
Survey data architecture for the MEAC disarmament and reintegration research project in Nigeria, Colombia, Iraq and the Lake Chad Basin: SurveyCTO data collection with automated quality checks, analysis in R and STATA, and Power BI dashboards.