Case Studies

Case Studies

Notes on data engineering, community impact, architecture decisions, and building things that last.

2026-08-27
Building Beyond Code: Community Development Through the IGonics Foundation
4 min read

Building Beyond Code: Community Development Through the IGonics Foundation

Technology is only as valuable as the lives it improves. Through the IGonics Foundation, we channel our passion for community development, mentorship and youth engagement into initiatives that create lasting impact across Jamaica, Canada and the Caribbean.

2025-06-14
Streaming Delivery Observability
1 min read

Streaming Delivery Observability

Event-driven telemetry platform for a high-volume messaging service used by retail banks. Idempotent webhook ingestion with schema validation at the boundary, micro-batched to object storage, status-reconciled in Spark and served with sub-ten-minute freshness. Gave operations the SLA evidence trail that provider credit claims had previously been argued without.

Apache Spark Azure SQL Server Python Power BI Docker
2024-11-20
Governed Financial Reporting Platform
10 min read

Governed Financial Reporting Platform

Governed financial reporting platform replacing a manually assembled spreadsheet process with a single semantic model, controlled report catalogue and Finance-owned access governance. Directors receive self-service unit-level P&L while dynamic row-level security prevents unauthorised financial visibility. Access requests are submitted through an organisation-restricted Microsoft Forms workflow, validated by Python ETL and reconciled into an MDM-controlled access matrix. Finance owns the data source, reporting asset and access decisions; the platform automates their enforcement.

SQL Server Power BI Python Microsoft Fabric MDM RLS Automation Financial Reporting
2024-08-15
Revenue Leakage Detection
9 min read

Revenue Leakage Detection

Revenue-assurance platform reconciling operational work, CRM and billing data where millions in monthly revenue were being left unbilled. Built during a Dynamics CRM to Salesforce migration with no dependable shared key, inconsistent technician coding and a fragmented billing/ERP process. Combined canonical master-data management, deterministic and fuzzy entity resolution, incremental Fabric ETL, Spark processing and Power BI diagnostic workflows, with human-in-the-loop review and governed overrides for ambiguous matches.

T-SQL SQL Server Microsoft Fabric Fabric Data Factory Apache Spark Power BI MDM Entity Resolution
2024-06-01
Platform Reliability Monitoring
1 min read

Platform Reliability Monitoring

Observability layer for the reporting estate. Gateway health, dataset refresh outcomes and agent job state ingested into a modelled serving layer, with alerting bound to SLO breach rather than raw failure count. Paired with a capacity scheduler that parks idle compute, so reliability and unit cost improved on the same change.

Power BI SQL Server Python
No case studies match that search.Try a different term.