Case 1 · Turned a 7.5-Day Oracle Job into a 14-Hour Hadoop Delivery
Processed 15.3B rows under deadline using Hadoop + Hive scale-out with zero production impact.
Engineering & Data Projects
This section presents hands-on engineering and analytics projects from production and production-like environments, covering ETL pipelines, Oracle SQL optimization, Hadoop/Hive processing, monitoring, automation, and large-scale data delivery.
Case 2 · Telecom Agent Commission Verification System Redesign
Moved commission verification from settlement-time full scans to automated daily incremental checks.
Case 3 · Oracle Address Search Optimization
Sub-second address lookup through Oracle indexing and SQL tuning.
Write-up in progress
Case 4 · 05:00 Synthetic Monitoring
Early-morning synthetic checks across 120 hosts to catch incidents before business hours.
Write-up in progress
Case 5 · Provincial Cutover ETL
Large-scale user cutover with resilient ETL and data integrity checks.
Write-up in progress
Case 6 · Preemptive Complaint Automation
Detecting and resolving service issues before they become customer complaints.
Write-up in progress
Case 7 · Invoice Contingency Delivery
Billing contingency delivery designed to protect invoice timelines.
Write-up in progress
Case 8 · Youth NGO Analytics — Community Insights
Calgary youth-service analytics using demographic and engagement data to explore equity and participation.