AI Agents & Workflows
Designing practical AI agents, automated pipelines (Power Automate, Make, n8n, Python), and schema-validated LLM workflows that remove repetitive operational work.
Business Intelligence Consultant & First-Class Honours graduate exploring the intersection of enterprise data architecture, practical Business AI Automation, and building a life in tech.
By day I architect cross-border data warehouses across Southern Africa. Beyond that, I build modular Python pipelines on Kaggle, design Business AI Automations, and prepare tutorials for YouTube.
Designing practical AI agents, automated pipelines (Power Automate, Make, n8n, Python), and schema-validated LLM workflows that remove repetitive operational work.
Architecting 1.7B+ row SQL Server & Azure warehouses while sharpening exploratory data forensics and modular scikit-learn pipeline design on Kaggle.
Documenting life in Gaborone, continuous craft after graduating First-Class Honours (6 distinctions), Notion systems, and building a creator studio from scratch.
Click through the 4 engineering stages I use across banking, micro-lending, and modern AI workflows to turn fragmented data into trusted decisions.
Capturing high-frequency transactional records from core banking, micro-lending, ERP, and spreadsheet environments across Botswana, South Africa, and Zambia without impacting source performance.
Azure SQL
MariaDB
Oracle DB
Flat CSV / Excel
Standardizing schemas, resolving currency and date anomalies, and running modular transformation steps—combining enterprise SSIS & Azure Data Factory orchestration with Kaggle-honed Python preprocessing.
SSIS Packages
Azure Data Factory
Power Automate
Python • scikit-learn
Modeling fact and dimension tables at billion-row scale so leadership queries resolve in seconds rather than timing out, while providing structured single-source-of-truth context for AI agents.
28 SSAS Cubes
Google BigQuery
Governance Registers
SharePoint Lists
Delivering KPI scorecards in Power BI and SSRS, corporate Risk Registers in Power Apps, and connecting clean warehouse triggers to n8n / LLM triage agents with strict human-in-the-loop audit logs.
Power BI & DAX
SSRS Paginated
Power Apps
Looker Studio
n8n / LLM Agents
Beyond enterprise SQL warehouses, Kaggle is my open-source engineering gym—training fast exploratory forensics, leakage-free scikit-learn pipeline composition, and predictive modeling that feeds directly into real-world scorecards and AI systems.
Before fitting a baseline model on Kaggle, I profile cardinality, null patterns, target imbalance, and temporal leaks—the exact discipline that later helped me reconstruct 115M+ missing historical contracts in SQL Server.
Whether modeling credit repayment risk or food delivery order velocity, engineered ratios (utilization, rolling 30-day cadence, peer-group deviations) give interpretable lift across both linear models and gradient boosting.
Instead of mutating global DataFrames across 40 notebook cells, every imputer, scaler, encoder, and feature generator sits inside one reproducible Pipeline validated inside Stratified K-Fold CV.
When stakeholders need transparent micro-lending scorecarding or AI agents need calibrated anomaly alerts, Kaggle-tested logic translates cleanly into SQL Server views and deterministic LLM routing thresholds.
How practicing exploratory forensics and composable scikit-learn pipelines on Kaggle directly sharpens my enterprise SQL scorecards and AI automation architecture.
Read Article →Most companies try to bolt AI agents onto messy spreadsheets. Here is how combining solid ETL fundamentals with Make, n8n, and Power Automate creates reliable automation.
Read Article →A technical breakdown of recovering overwritten contract history across Botswana, South Africa, and Zambia using specialized snapshot tables and SSAS Tabular models.
Read Article →Why I'm transitioning from pure consultancy to sharing what I build—inspired by creators like Nate Herk—covering AI workflows, tech career lessons, and daily life.
Read Article →Engineered 30+ automated SSIS ETL pipelines and 28 SSAS Tabular Cubes, optimizing 1.7B+ records across 47 compressed tables for operations across Botswana, South Africa, and Zambia.
Delivered custom BI solutions, DAX semantic modeling, data quality frameworks, 3-page executive KPI dashboards, and rapid SQL dataset analyses for international clients.
Developed database tables and automated ETL processes using SQL Server Full Stack (SSIS, SSAS, SSMS) and Python, achieving 100% on-time delivery for paginated stakeholder reports.
Awarded First-Class Honours (1:1) with all six distinctions, alongside Google Data Analytics and Notion Certified (Essentials, Workflows, Advanced) credentials.
Parsed 115M+ flattened audit logs and automated 30+ SSIS pipelines across Botswana, South Africa, and Zambia with country-level Row-Level Security.
Read Case Study →Replaced vulnerable paper field logs with a serverless Google Apps Script, BigQuery, and Looker Studio pipeline syncing in under 60 seconds.
Read Case Study →Audited fragmented Excel metrics and unified Finance, Sales, and Marketing KPIs inside a documented, Git-ready Power BI Semantic Model.
Open Interactive Lab →