Case Studies

26 production programs across 11 clients — from real-time drilling analytics and MLOps at scale to enterprise cloud migrations, governed BI, and telco campaign platforms (2008–2026).

T-Mobile, USA (via Procogia)

Telecommunications · 2025 – Present

Customer Sentiment Analysis Platform

Unified customer sentiment by combining social listening (Sprinklr, LinkedIn), CRM interactions, and network performance signals into a single lakehouse platform.

Role

Senior Data Engineer / Data Architect

Challenge

High-volume, heterogeneous sources with no common model; slow Spark jobs and excessive data movement; no validation layer for executive dashboards.

Solution

Built scalable Databricks/PySpark ETL pipelines integrating Sprinklr, LinkedIn, CRM, network data and external APIs into a centralized lakehouse with curated models, semantic layer, Power BI dashboards, and pipeline monitoring.

Technologies

SprinklrAzure DatabricksPySparkDatabricks SQLAzure Data LakePower BI

Data EngineeringData AnalyticsCloud Enablement

Optimized

Spark pipeline runtime

Single

Trusted sentiment KPI source

Getty Images, USA (via Procogia)

Digital Media / Visual Content · Jun 2024 – Jan 2026

ML Workflow Automation & Model Deployment (MLOps)

Automated end-to-end ML workflows for computer-vision and search models at scale, from dataset versioning through training, evaluation, and deployment.

Role

Senior Data Engineer / Machine Learning Ops Architect

Challenge

No automated path from dataset version to deployment; inference cost and latency not benchmarked; experiment metadata scattered, blocking reproducibility.

Solution

Architected GitLab-driven SageMaker workflows with versioned datasets and hyperparameter tuning; deployed TensorRT/Ray/Triton inference on Docker/ECR; built EMR-to-SageMaker MME retraining pipelines and Aurora metadata models with automated lineage.

Technologies

AWS SageMakerEMRAuroraGitLab CI/CDTerraformDockerTensorRTRayTriton

Generative AIData EngineeringCloud Enablement

One-click

Retraining & deployment

Benchmarked

Inference cost & latency

ARC Resources Ltd, Canada

Oil & Gas (Upstream) · May/Jul 2022 – May 2024

Real-time Drilling Data Ingestion

Streaming IoT rig data from NOV and PASON hubs into Databricks for real-time on-bottom drilling performance visibility.

Role

Senior Data Engineer / Data Architect

Challenge

High-frequency IoT telemetry from multiple vendors; no schema governance; historical EDR data in Welldata.ca and PASON Datahub needed alignment with live feeds.

Solution

Real-time Databricks/PySpark/Delta Lake pipeline with Z1/Z2/Z3 zones, On-Bottom Drilling depth-based aggregation, and automated historical EDR backfilling through ADLS.

Technologies

Azure DatabricksDelta LakeAzure IoT HubsPySparkAzure DevOpsPower BI

Data EngineeringInternet of Things (IoT)Cloud Enablement

Near real-time

Drilling insights

Optimized

Depth-based storage

ARC Resources Ltd, Canada

Oil & Gas (Upstream) · May/Jul 2022 – May 2024

Geo & Well Analytics Data Ingestion

Wellbore trajectory and formation-level analytics combining GIS data with drilling events for subsurface and completions teams.

Role

Senior Data Engineer / Data Architect

Challenge

Geospatial joins at scale between well trajectories and geological formations; dashboard latency on large Delta tables.

Solution

Built geospatial PySpark models, segment aggregation pipelines by geological formation, and optimized Delta Lake storage and SQL query patterns.

Technologies

Azure DatabricksPySparkGIS datasetsDelta LakePower BI

Data EngineeringData Analytics

Faster

Dashboard response

Improved

Subsurface insight

ARC Resources Ltd, Canada

Oil & Gas (Upstream) · May/Jul 2022 – May 2024

Segment Aggregation & Completion Analytics

Aggregated completion and frac pressure time-series data with anomaly detection to support production analytics.

Role

Senior Data Engineer / Data Architect

Challenge

Multi-level L0/L1 time-series computations on completion data; manual deployment and monitoring of pipelines and reporting.

Solution

Automated L0/L1 pipelines, PySpark/Delta upsert anomaly-detection frameworks, and Azure DevOps CI/CD for pipelines and Power BI models.

Technologies

Azure DatabricksPySparkDelta LakeAzure DevOps CI/CDPower BI

Data EngineeringData Analytics

Automated

Release path for assets

Earlier

Pressure anomaly detection

ARC Resources Ltd, Canada

Oil & Gas (Upstream) · May/Jul 2022 – May 2024

Databricks Unity Catalog Migration

Migrated lakehouse assets across Landing, Integration and Consumption zones to Unity Catalog for governance, lineage and fine-grained access control.

Role

Senior Data Engineer / Data Architect

Challenge

Onboarding existing models and pipelines without breaking consumers; keeping schemas and permissions consistent across dev, test and prod.

Solution

Migration framework with automated schema registration, table migration, permission sync, schema-drift detection, AAD-integrated security with data masking, and multi-environment CI/CD.

Technologies

Unity CatalogAzure DatabricksDelta LakeAzure ADAzure DevOps

Data GovernanceData EngineeringCloud Enablement

Unified

Governance & lineage

Auditable

Multi-env releases

TE Connectivity, USA (via Adastra)

Manufacturing / Electronics · Nov 2022 – Jan 2025

SAP/Non-SAP Source System Migration into Microsoft Fabric

Consolidated SAP and non-SAP source systems onto Microsoft Fabric for scalable analytics and modern Power BI reporting.

Role

Senior Data Engineer

Challenge

Legacy logic in SAS and Oracle PL/SQL; heterogeneous sources requiring replication; handover to client teams with limited Fabric experience.

Solution

Migration using Synapse, Databricks and OneLake; rewrote SAS/PL/SQL to PySpark; Qlik Replicate + Databricks pipelines feeding Power BI with full documentation.

Technologies

Microsoft FabricOneLakeAzure DatabricksAzure Data FactoryQlik ReplicatePower BI

Data EngineeringCloud EnablementData Analytics

Modernized

Analytics platform

Real-time

Reporting capability

TE Connectivity, USA (via Adastra)

Manufacturing / Electronics · Nov 2022 – Jan 2025

PartXRef Dashboard Migration

Migrated the Part Cross-Reference dashboard from Excel to a governed Microsoft Fabric platform with fast report generation.

Role

Senior Data Engineer

Challenge

Excel-based dashboard with manual refresh and no scalability; inconsistent environment provisioning across regions and tenants.

Solution

Provisioned Azure SQL, Synapse and Data Factory via ARM/Bicep; migrated dashboard to Fabric; moved data to PostgreSQL with .NET reports and team training.

Technologies

Microsoft FabricAzure SynapsePostgreSQLARM templatesBicepPower BI

Data EngineeringData AnalyticsCloud Enablement

<5 sec

Report generation

Standardized

Multi-region deployments

TE Connectivity, USA (via Adastra)

Manufacturing / Electronics · Nov 2022 – Jan 2025

Pricing Data Analytics Project

Pricing analytics, budget forecasting and Azure cost visibility for finance stakeholders across the data platform.

Role

Senior Data Engineer

Challenge

No auditing or anomaly detection across Synapse, Data Factory and SQL DW; budget overrun risk with unmonitored cloud spend.

Solution

Azure Monitor and Log Analytics for auditing; cost-management alerts; real-time Power BI financial dashboards; scalable Synapse/OneLake pipelines with access-log audits.

Technologies

Azure SynapseMicrosoft FabricAzure MonitorLog AnalyticsPower BI

Data AnalyticsData GovernanceCloud Enablement

Proactive

Cost control

Compliance-ready

Audit trail

TE Connectivity, USA (via Adastra)

Manufacturing / Electronics · Nov 2022 – Jan 2025

Data Platform SAS Migration into Azure

Migrated legacy SAS workloads to a secure, governed Azure platform with self-service Power BI and Tableau reporting.

Role

Senior Data Engineer / Analytics Consultant

Challenge

SAS code compatibility and performance in SQL DW; secure cross-functional access to sensitive data.

Solution

Migrated SAS to Azure SQL DW; configured Synapse with Azure AD and PIM; ARM-based IaC provisioning; diagnostic logging and activity monitoring.

Technologies

Azure SynapseAzure SQL DWAzure Data FactoryPythonPower BITableau

Data EngineeringCloud EnablementData Analytics

Faster

Environment setup

Hardened

Security posture

TE Connectivity, USA (via Adastra)

Manufacturing / Electronics · Nov 2022 – Jan 2025

Discover Data Migration – Microsoft Fabric

Full-scale migration of a business data platform into Microsoft Fabric with automated, standardized integration workflows.

Role

Senior Data Engineer / MLOps Engineer

Challenge

Establishing reliable, automated data integration on a new platform.

Solution

Migration pipeline using Fabric Data Factory, OneLake and Fabric Warehouse with DBT and Python transformations, testing, and Power BI reporting.

Technologies

Microsoft FabricOneLakeDBTPythonPower BI

Data EngineeringCloud Enablement

Automated

Integration workflows

Reliable

Fabric platform delivery

TD Bank, Canada (via Adastra)

Banking / Financial Services · Nov 2020 – Nov 2022

Data Platform Migration into Azure – Financial Reporting

Migrated TD's financial reporting platform to Azure with Snowflake as the analytical warehouse and Databricks for ingestion with 24×7 operational support.

Role

Senior Azure Consultant – Financial Reporting

Challenge

Operational stability across Snowflake, DBT, Databricks and Tableau; business-rule consistency across raw, history and invalid records.

Solution

DBT transformations with YAML unit tests; Databricks ingestion and ETL pipelines; multi-zone raw → curated → consumption in Snowflake; Tableau semantic layers.

Technologies

SnowflakeAzure DatabricksDBTAzure Data FactoryTableau

Data EngineeringData AnalyticsCloud Enablement

Tested

Business rule consistency

24×7

Platform operations

TD Bank, Canada (via Adastra)

Banking / Financial Services · Jan 2025 – Present

SAS Migration to Databricks & Analytics Modernization

Migrated legacy SAS ETL and analytics workloads to a Databricks lakehouse for scalability, performance and maintainability.

Role

Senior Data Engineer / Senior Data Consultant

Challenge

Reverse-engineering complex SAS programs; regulatory reconciliation of SAS vs. Databricks outputs; performance tuning on large financial datasets.

Solution

Translated SAS to Databricks SQL and PySpark; lakehouse raw → curated models; Delta partitioning; Tableau dashboards with validated metrics and reconciliation runbooks.

Technologies

Azure DatabricksPySparkDelta LakeAzure Data FactorySASTableau

Data EngineeringData AnalyticsCloud Enablement

Validated

SAS reconciliation

Documented

Migration lineage

Sun Life Financial, Canada

Insurance / Wealth Management · Aug 2019 – Nov 2020

IFDS Data Migration into AWS – Individual Wealth Portfolio

Migrated IFDS data for Individual Wealth (segregated and mutual funds) into AWS with controlled client exposure and operational dashboards.

Role

Manager, Data Analytics

Challenge

Multiple source systems and file formats; strict data-exposure rules per client/portfolio; cross-functional delivery with fixed timelines.

Solution

Ingestion pipelines into Redshift with IAM roles and row-level security; Tableau dashboards for Individual Wealth Operations; managed dev, QA and rollout teams.

Technologies

IBM DataStageAWS RedshiftIAMPythonTableauSalesforce

Data EngineeringData AnalyticsCloud Enablement

Governed

Client-scoped access

On-time

Migration delivery

Home Hardware Stores Limited, Canada

Retail · May 2018 – Aug 2019

Enterprise Analytics Solution – POS of 500 Stores (POS500)

Enterprise analytics across point-of-sale data from 500 stores with data governance and master-data management during a POS migration.

Role

Azure Data Engineer / Cloud Analytics Consultant

Challenge

Ingesting POS data from 500 stores with inconsistent quality; coordinating 4 onshore and 10 offshore team members.

Solution

Led ETL/analytics team building POS500 on Azure with governance and MDM; Azure Data Pipeline and SSIS flows with data quality remediation.

Technologies

Microsoft AzureAzure Data PipelineSSISPower BISQL

Data EngineeringData GovernanceData Analytics

500

Stores integrated

Enterprise-wide

POS reporting

Bell Canada

Telecommunications · Apr 2017 – Apr 2018

Bell Residential Services (BRS) Inbound Campaign Solution

Improved real-time inbound offer presentation to residential customers and reduced reliance on mass marketing.

Role

BI / Analytics Consultant

Challenge

Low inbound campaign presentation success (74%); campaign data spread across Oracle and Teradata.

Solution

Designed Unica inbound campaigns; built Cognos reports; sourced new data in Oracle and Teradata for targeted campaign management.

Technologies

IBM Unica CampaignUnica InteractCognosOracleTeradata

Data AnalyticsData Engineering

74→98%

Campaign presentation success

Lower

Mass-marketing cost

DiGi Telecommunications (Telenor), Malaysia

Telecommunications · Aug 2012 – Sep 2016

Campaign Management System (CMS)

Real-time loyalty campaigns, contextual marketing and Next Best Offer across all customer touchpoints.

Role

Technical Lead

Challenge

Real-time personalization from CDR streams; multi-channel orchestration; high support-contract OPEX.

Solution

Customer 360 behavioural analytics; Next Best Offer propensity logic; fulfilment orchestration between CMS and external systems.

Technologies

IBM Unica CampaignKnowesis SIFTSIFT OrchestratorCDR processing

Data AnalyticsData Engineering

20%

OPEX reduction

Customer 360

Behavioural analytics

DiGi Telecommunications (Telenor), Malaysia

Telecommunications · Aug 2012 – Sep 2016

Enterprise BI Teradata Migration to AWS Cloud

Cloud roadmap and migration of a 200 TB on-premises Teradata EDW to AWS Redshift with executive OPEX/CAPEX business case.

Role

Enterprise Solution Architect

Challenge

200 TB enterprise DWH migration; vendor selection across Microsoft, Google and AWS; executive buy-in required.

Solution

Enterprise cloud roadmap with OPEX/CAPEX analysis; RFP/RFQ with top vendors; Teradata to Redshift migration with governance and MDM alignment.

Technologies

TeradataAWS RedshiftBusiness ObjectsQlik SenseOracle Data Integrator

Data EngineeringCloud EnablementData Governance

$10M

OPEX/CAPEX reduction

200 TB

EDW on Redshift

DiGi Telecommunications (Telenor), Malaysia

Telecommunications · Aug 2012 – Sep 2016

Sales & Marketing KPI Dashboards

Consolidated KPI visibility for sales and marketing leadership across business units.

Role

Senior Developer & Business Analyst

Challenge

Gathering detailed requirements across business units; coordinating BA, development, QA, rollout and managed services.

Solution

Led business analysts on requirements; developed Tableau and Business Objects dashboards; managed cross-functional delivery.

Technologies

TableauSAP Business Objects

Data AnalyticsBusiness Intelligence

On-time

Dashboard delivery

Unified

Sales & marketing KPIs

DiGi Telecommunications (Telenor), Malaysia

Telecommunications · Aug 2012 – Sep 2016

Data Network Analytics (DNA)

Network and subscriber analytics toolset to probe, monitor and troubleshoot the subscriber base.

Role

Technical Lead

Challenge

High-volume network data in Vertica and Teradata; data governance and quality across a new analytics domain.

Solution

Subscriber-analysis toolset with Erwin-modelled data; Oracle Data Integrator integration; governance and data-quality architecture.

Technologies

HP VerticaTeradataErwinOracle Data IntegratorZhilabs-CEA

Data EngineeringData GovernanceData Analytics

On scope

Ready-for-service delivery

Governed

Network analytics domain

DiGi Telecommunications (Telenor), Malaysia

Telecommunications · Aug 2012 – Sep 2016

Enterprise Data Warehouse (EDW) Optimization

Optimized batch ETL windows and storage costs on Teradata to enable near-real-time reporting.

Role

Technical Lead

Challenge

Long mini-batch execution times; storage growth on Teradata.

Solution

Optimized mini-batch execution and ETL timings; aligned operations with governance and MDM; delivered BO/QlikView applications.

Technologies

TeradataBusiness ObjectsQlikViewHadoopHiveOracle Data Integrator

Data EngineeringData Analytics

40%

Faster mini-batch execution

$250K

Saved via optimization

DiGi Telecommunications (Telenor), Malaysia

Telecommunications · Aug 2012 – Sep 2016

BI & DWH Operations Leadership

Led the BI function for Malaysia's leading telco, maintaining SLAs while driving uplift projects and cost savings.

Role

Head of Data Engineering, BI & DWH Operations

Challenge

Maintaining availability and data-delivery SLAs while driving uplift projects; managing large OPEX and CAPEX portfolios.

Solution

Ran BI uplifts and operations; maintained data dictionary, catalog and MDM documents per ITIL; drove cost-saving initiatives.

Technologies

TeradataBusiness ObjectsQlikIBM UnicaITIL

Data GovernanceData EngineeringData Analytics

99.5%

Platform availability

$9M

OPEX budget managed

HCL Technologies, Singapore

IT Services (Telecom client) · Jul 2011 – Aug 2012

EDM Implementation Project

Enterprise data management implementation on Teradata for a large telecom client, transitioning from Waterfall to Agile mid-project.

Role

Technical Lead

Challenge

Very large distributed team (40–50); release management across SIT, UAT, regression and production.

Solution

Led development, release and configuration management; Erwin ER models for revenue assurance and customer lifecycle; ODI migration with technical documentation.

Technologies

TeradataErwinOracle Data Integrator

Data EngineeringData Governance

Timely

Governed rollouts

Documented

Architecture & data quality

Telenor, Pakistan

Telecommunications · Sep 2008 – Mar 2011

Semantic Layer / OLAP Data Cube Design

New OLAP cube layer over the Teradata warehouse for KPI reporting across business units.

Role

BI Lead

Challenge

Conceptual and logical modelling of a new semantic layer over the enterprise warehouse.

Solution

Led data modelling; delivered Teradata architecture, data model and reporting design; built ETL with SSIS and PL/SQL.

Technologies

TeradataBusiness ObjectsSSISPL/SQL

Data AnalyticsData Engineering

Delivered

KPI reporting layer

Multi-BU

Semantic coverage

Telenor, Pakistan

Telecommunications · Sep 2008 – Mar 2011

Data Quality & Governance Program

Resolved subject-area data quality issues and implemented monitoring to restore reporting trust.

Role

Data Project Manager

Challenge

Quality issues across subject areas undermined reporting; needed monitoring while resolving root causes.

Solution

Implemented governance and monitoring for data quality; BI/ETL architecture with SSIS and Informatica.

Technologies

TeradataBusiness ObjectsSSISInformatica

Data GovernanceData Engineering

10–15%

Data quality improvement

Monitored

Subject-area quality

Telenor, Pakistan

Telecommunications · Sep 2008 – Mar 2011

DWH / Revenue Assurance Appliance & Dashboards

Revenue assurance and marketing dashboards with a stable DWH/RA appliance and L1/L2 production support.

Role

Data Engineering, DWH & BI

Challenge

Continual service improvement while supporting production revenue assurance workloads.

Solution

Developed DWH/RA appliance with L1/L2 support; Business Objects dashboards for Revenue Assurance and Marketing.

Technologies

TeradataErwinBusiness Objects

Data EngineeringData Analytics

Sustained

DWH/BI operations

Improved

Data quality

Facing a similar challenge?

Let's discuss how Analytics Enablers can help you achieve comparable results.

Book a Discovery Call Send a Message