About Me & Interactive CV

Data engineering roots. An obsession with AI automation.

I'm Sandile D. Mfazi, a Business Intelligence Consultant based in Gaborone, Botswana, and a First-Class Honours graduate in Business Intelligence & Data Analytics (1:1 with all six distinctions).

By day, I engineer enterprise data warehouses, automated ETL pipelines, and semantic models across Botswana, South Africa, and Zambia—handling 1.7B+ records across the Microsoft Data Stack. Outside of enterprise BI, I'm building practical Business AI Automation workflows and preparing to launch a YouTube channel sharing AI systems, tech tutorials, and personal reflections.

Why This Personal Hub Exists

I used to position this site purely as an independent B2B consultancy storefront. Now, I'm turning it into my personal home on the internet—where my engineering portfolio, AI automation writing, upcoming YouTube channel, and career journey live side by side.

Read the AI Blog YouTube Roadmap Get in Touch
Sandile Desmond Mfazi
Based in Gaborone, Botswana BI Consultant • First-Class Honours • Future YouTuber
Experience & Education

Interactive Career Timeline

Filter my background by professional experience or academic foundation, and expand individual entries for project breakdowns.

Botswana • South Africa • Zambia • Remote

Junior Business Intelligence Consultant

UGT — Analytics Training & Consulting • Gaborone, Botswana
March 2025 – Present
  • Engineered 30+ automated ETL pipelines using SSIS to extract and standardize data from operational systems into a centralized SQL Server environment, alongside 28 SSAS Tabular Cubes for automated analytics.
  • Optimized data processing for 1.7B+ records across 47 compressed tables; automated nightly ETL/OLAP processing for operations across 3 countries (Botswana, South Africa, and Zambia).
  • Executed delegated technical tasks, managed ad-hoc data requests, and spearheaded the modernization of internal analytics training materials for pending HRDC accreditations.
  • Enterprise Data Warehousing: Supported the end-to-end implementation of a regional data warehouse for a large-scale enterprise client, consolidating heterogeneous data from Botswana, South Africa, and Zambia.
  • Risk & Compliance Systems: Co-managed a comprehensive corporate Risk Register for a multinational financial services group leveraging the Microsoft Power Platform.
  • Micro-Lending Analytics: Contributed to the development of a micro-lending scorecarding process, ensuring scoring logic is executed directly in SQL database views for optimized system performance.
SQL Server SSIS / SSAS / SSRS Power Platform T-SQL & DAX

Power BI Expert & Data Analysis Consultant

Upwork — Verified Online Freelancer • Remote
April 2024 & Aug – Nov 2024
  • Power BI Expert / BI Analyst (Aug–Nov 2024): Provided comprehensive BI solutions using advanced data modeling and DAX to translate complex datasets into actionable stakeholder insights.
  • Implemented data quality frameworks to ensure high-fidelity deliverables across multiple client industries and built 3-page interactive dashboards for company-wide KPIs and customer behavior analytics.
  • Data Analysis Consultant (April 2024): Analyzed large-scale CSV datasets in the food delivery sector using advanced SQL to answer strategic operational questions within hours under a tight deadline.
Power BI DAX Advanced SQL Data Quality

Business Intelligence Attachment

First National Bank of Botswana Limited (FNBB) • Gaborone, Botswana
February 2023 – August 2023
  • Developed and optimized database tables and automated ETL processes using the SQL Server Full Stack (SSIS, SSAS, SSMS) and Python.
  • Designed visually compelling paginated reports to increase self-servicing capabilities for business stakeholders.
  • Achieved 100% on-time delivery across all assigned BI requests.
SSIS / SSAS / SSMS Python Paginated Reports Banking BI

BSc (Hons) Business Intelligence and Data Analytics

Botswana Accountancy College / University of Sunderland • Gaborone, Botswana
Graduated 2024
  • Award: 1:1 (First Class Honours) with all six distinctions.
  • Focused on enterprise data warehousing, dimensional modeling, statistical analytics, database systems, and business decision intelligence.
First Class Honours (1:1) 6 Distinctions Dimensional Modeling
Capabilities

Technical Stack & Automation Toolkit

A blend of battle-tested enterprise Microsoft data engineering tools, modern cloud warehouses, and the AI automation platforms I build with today.

01. AI & Workflow Automation

Connecting LLMs, APIs, and business tools to replace repetitive manual work with reliable automated agents and workflows.

Power Automate Make n8n AI Agents & Prompt Workflows Python Scripting Notion Workflows

02. Microsoft Data Stack & BI

End-to-end extraction, warehouse modeling, tabular cubes, and executive reporting layers.

SQL Server (T-SQL) SSIS SSAS Tabular SSRS Power BI & DAX Power Apps Star / Snowflake Schema

03. Cloud & Databases

Cloud ingestion, serverless analytics portals, and relational/analytical database platforms.

Azure Data Factory Azure SQL Google BigQuery Looker Studio MariaDB Oracle Tableau

04. Core Competencies & Leadership

Ensuring technical systems stay governed, well-documented, and maintainable for the teams who own them.

Data Governance Data Quality Monitoring Technical Documentation Mentorship Brand Strategy Project Handover Git / GitHub
Credentials & Community

Certifications & Recognitions

2024 • Coursera

Google Data Analytics Professional Certificate

Structured analytics foundations, SQL querying, data cleaning, and stakeholder visualization.

Verified • Notion

Notion Certified (All 3 Badges)

Certified across Notion Essentials, Workflows, and Advanced Workspace Architecture.

Community • Kaggle

Kaggle Contributor

Predictive analytics experiments, exploratory modeling, and modular Python pipeline design.

Freelance • Upwork

Verified Upwork Freelancer

Delivering Power BI dashboards, DAX modeling, and SQL data analysis to global clients.