Business AI Automation
Automated Risk, Compliance & Operations Workflows
The Problem: Operational and compliance teams were spending hours manually tracking corporate risk updates, routing approvals over email, and summarizing status changes across departments.
The System: Engineered automated workflow pipelines combining Microsoft Power Platform, Python scripting, and structured LLM prompts to classify updates, validate schemas, and sync governance registers automatically.
Key Automation Outcomes:
- Structured Workflow Orchestration: Replaced fragmented email threads with automated Power Automate & Make/n8n pipelines featuring human-in-the-loop approvals.
- AI Triage & Summarization: Used schema-bounded LLM steps to categorize incoming operational notes and draft concise executive summaries.
- SQL & Audit Logging: Persisted every automated decision into relational tracking tables for full auditability across multinational teams.
Enterprise Data Architecture
Recovered 115M Records & Automated Multinational Enterprise Reporting
The Challenge: A legacy transactional database overwrote historical states, destroying critical policy lifecycles. Disparate systems across Botswana, South Africa, and Zambia caused reporting bottlenecks and conflicting KPIs.
The Solution: Architected a fully automated, end-to-end Microsoft BI pipeline establishing a singular, verifiable source of truth for over 200 million operational records.
Architectural Outcomes:
- History Reconstruction: Parsed 115+ million raw audit logs to mathematically rebuild lost historical contract snapshots via specialized SQL environments.
- Data Centralization: Consolidated 21.4 million contracts and 39.1 million transactions into a single automated data warehouse.
- Semantic Modeling: Deployed SSAS Tabular Models to handle complex DAX measures, Pula FX conversions, and multi-tier arrears bucket migrations.
- Data Governance: Enforced Row-Level Security (RLS) across Botswana, South Africa, and Zambia via an SSRS Native-Mode web portal.
Read Deep Dive Analysis
Cloud Data Infrastructure
Real-Time Cloud Data Portal for Livestock Logistics
The Challenge: Field operations relied entirely on vulnerable paper records, causing multi-day reporting latency, data corruption, and a lack of real-time visibility into farm logistics.
The Solution: Engineered a zero-maintenance, serverless cloud database application to digitize data collection directly from the field to the executive dashboard.
Architectural Outcomes:
- Front-End Ingestion: Developed custom, mobile-responsive data entry interfaces utilizing Google Apps Script for field operators.
- Backend Cloud Storage: Engineered automated pipelines to push sanitized, validated form data directly into structured Google BigQuery tables.
- Real-Time Visualization: Connected the BigQuery warehouse directly to Looker Studio to deliver live operational metrics to stakeholders.
- Business Impact: Achieved a 100% elimination of paper-based tracking, reducing data latency from 72+ hours to sub-60-second cloud synchronization.
Read Deep Dive Analysis
Interactive Data Lab
Analytics Engineering & Governance: Governed Power BI Semantic Layer
The Focus: Auditing fragmented Excel spreadsheets, moving business logic upstream into versioned SQL views, and deploying a documented Power BI Semantic Model with an Architectural Decision Record (ADR).
Open Interactive Lab
