Career Ownership & Leadership Scope

Roles & Responsibilities

Strategic breakdown of architectural mandates, organizational ownership, and designation mappings across 20 years of enterprise data leadership.

Thoughtstorm CanadaJul 2024 – Present

Lead Data & AI Architect

Official DesignationData Analyst

Directing enterprise Microsoft Fabric adoptions, end-to-end RFP technical proposal architecture, and production Medallion implementations across public sector and provincial clients.

Architectural Strategy & Governance

  • Architect scalable Hybrid Medallion Lakehouses (OneLake, Direct Lake, Spark) utilizing Microsoft Fabric F64 capacity.
  • Lead technical bid governance, solution trade-off options, and system topologies for high-stakes public sector RFPs (e.g., Legal Aid BC, Humber Polytechnic).
  • Formulate cross-tenant data governance protocols, PII masking rules, and standardized ingestion patterns.

Client Engagement & Technical Delivery

  • Spearhead cloud migration pipelines for the City of Calgary, resolving complex API rate limits and matter deduplication via window functions.
  • Lead reverse-engineering and modernization discovery assessments across 60+ SQL Server instances for the Niagara Region.
  • Direct cross-functional squads across data engineering, QA, and business stakeholders.

Key Mandates & Delivered Outcomes

✓Microsoft Fabric F64 Medallion Migration
✓Public Sector RFP Defense & Architecture
✓Niagara SQL Estate 5-Year Modernization Roadmap
✓Calgary Legal Data Ingestion Pipeline
Environment:Microsoft FabricAzure SynapseAzure Data FactoryDirect LakePower BIPythonRAG / Agentic AI
Annalect IndiaMay 2023 – Jul 2024

Project Manager / Lead BI Engineer

Official DesignationProject Manager

Led technical project delivery, enterprise dashboard design, and process automation suites across multi-agency operational branches.

Delivery & Process Automation

  • Engineered enterprise Power Apps canvas tools and automated multi-tier approval workflows using Power Automate.
  • Constructed automated REST API extractors to pull ticket lifecycle data from Jira Service Management directly into analytics stores.

Data Modeling & Governance

  • Built normalized tabular data models enforcing Row-Level Security (RLS) across cross-agency leadership reports.
  • Maintained SLA compliance monitors and capacity planning metrics for managerial decision-making.

Key Mandates & Delivered Outcomes

✓Unified Enterprise Ticketing & Allocation System
✓ITSM Jira Power BI Analytical Suite
✓Cross-Agency Operational Scorecards
Environment:Power BIPower AppsPower AutomateJira REST APIsSQL ServerTabular Modeling
Zad Holding (Qatar Food Industries)Jul 2014 – Oct 2023

Lead Data Engineer & Analytics Specialist

Official DesignationSenior Executive

Directed data platform initiatives across manufacturing, sales, supply chain, and finance domains while resolving core enterprise ERP reporting challenges.

Big Data & BI Engineering

  • Managed a 5-person engineering squad building multi-tenant ETL workflows using SSIS, KNIME, and Databricks.
  • Designed SSAS multi-dimensional cubes and scheduled incremental refresh Power BI gateways.
  • Constructed custom C# / ASP.NET operational KPI tracking engines serving multiple group subsidiaries.

Enterprise ERP Data Integration

  • Spearheaded the analytics layer during the Ramco ERP implementation, extracting messy transactional pipelines into clean Qlik Sense models.
  • Engineered custom SCD Type 2 tracking logic to restore point-in-time document visibility for executive management.

Key Mandates & Delivered Outcomes

✓ZPI Multi-Company Performance Index Engine
✓Ramco ERP Analytics Layer & Reconciliation
✓Enterprise Food Manufacturing Data Lakehouse
Environment:SQL ServerSSISSSAS OLAPAzure DatabricksPythonQlik SenseASP.NET