Mahdi Salem
Lead Data Engineer & Operational Intelligence Architect
Transforming operational complexity into high-precision data architectures, real-time shop-floor platforms, and executive business intelligence. Over a decade bridging aerospace manufacturing, energy, and enterprise systems to deliver decision clarity.
Quick Contact & Status
- Status: Authorized to work in Canada (Citizen)
- Location: Richmond Hill / Toronto, ON
- Arrangements: Hybrid / Remote / On-Site
- Email: Mahhdy@live.com
- Website: mahdisalem.com
Executive Profile & Approach
I architect the data systems and operational workflows that make complex organizations transparent and manageable. Over more than a decade at Bombardier Aviation, Triumph Group, and across the aerospace, heavy manufacturing, and energy sectors, I have engineered high-throughput ETL data pipelines, deployed 150+ Power BI and Power Apps solutions, and built full-stack production-tracking applications connecting factory mechanics to executive steering committees.
What distinguishes my work is an interdisciplinary combination of deep technical execution and strategic organizational design. Before focusing on data architecture, I spent over a decade as a management consultant and director—principally in industrial exploration and drilling—leading business process re-engineering (BPR), organizational restructuring, and Total Quality Management (TQM).
Backed by an MBA in Strategic Management and ongoing doctoral research in Public Policy & Decision Systems (investigating ethical and mathematical evaluation of complex institutional policies), I don't just generate visual charts: I diagnose structural friction, eliminate data silos, automate manual bottlenecks, and establish resilient governance models.
Data Engineering & ETL
Enterprise SSIS packages, automated reconciliation across SAP/MES, Azure Data Lake, and T-SQL optimizations.
BI & Decision Systems
150+ certified Power BI semantic models, advanced DAX, Row-Level Security, and executive Andon dashboards.
Full-Stack & Automation
ASP.NET Core, Angular, SignalR, Python, VBA, and Power Apps closing operational gaps on the shop floor.
Core Competencies & Technical Capabilities
BI & Semantic Modeling
Data Engineering & ETL
Software & Automation
Operations & Methods
Featured Systems Portfolio & Technical Case Studies
Adaptive OSW Production Tracking Ecosystem
A mission-critical shop-floor execution and labor visibility web application engineered to handle volatile, non-standard assembly tasks (OSW). Connects shop-floor mechanics directly to real-time TV boards and executive approval portals.
- Engineered multi-tier architecture using ASP.NET Core Web API, Angular 19, Entity Framework Core, and real-time SignalR broadcasts.
- Touch/non-touch labor tracking and automated job-kit readiness verification across multi-station aircraft assembly.
- Dedicated Kiosk interface for shop mechanics and high-visibility TV Board display for floor management.
- Integrated manager sign-off portal with automated variance detection against SAP production orders.
Enterprise Data Quality & Multi-System Reconciliation Engine
Architected enterprise SSIS ETL pipelines and automated reconciliation frameworks that continuously reconcile work orders, parts inventory, non-conformance reports, and labor clockings across disparate legacy SAP and MES systems.
- Automated nightly and intra-day cross-database reconciliation, flagging BOM discrepancies, orphan jobs, and scrap variances.
- Constructed a unified Data Quality KPI Framework delivering 100% data auditability to PMO and QA executive teams.
- Optimized heavy ETL throughput, slashing database lock contention and reducing package runtimes by over 70%.
Rapid-Response Shop-Floor Automation & Alerting Suite
Designed and deployed rapid-response automation tools that eliminated administrative friction and bridge critical ERP workflow gaps across engineering, supply chain, and shop-floor operations.
- Automated Crew Load Chart generation with VBA & Python, reducing daily processing time by 98.8% (from 3 hours down to 2 minutes).
- Automated Non-Conformance (RNC) reporting tool that generated root-cause dossiers in 3 minutes without manual re-entry.
- Digitized Daily Management Meeting (DMM) reporting into an interactive dashboard, improving reporting efficiency by 200%.
Enterprise Power BI Governance & Executive BI Ecosystem
Engineered a centralized Business Intelligence ecosystem composed of 150+ certified Power BI reports and Power Apps solutions, standardizing organizational KPI definitions and self-service analytics across divisions.
- Designed robust star-schema semantic models with complex DAX calculations, incremental refresh, and Row-Level Security (RLS).
- Monitored and optimized Power BI Premium capacity utilizing Azure Data Lake and Log Analytics.
- Created standardized Bombardier Operational Excellence reporting templates adopted enterprise-wide.
Certifications, Digital Badges & Education
Browse converted high-resolution credentials, Credly verified badges, and academic specializations.
Official role-based credentials in Data Engineering, Power BI, Azure, and Power Platform.
6 Credentials
Microsoft Certified: Power BI Data Analyst Associate
Microsoft Certified: Power Platform App Maker Associate
Microsoft Certified: Azure Data Fundamentals
Microsoft Certified: Power Platform Fundamentals
Microsoft Office Specialist: Excel 2016 Expert
Microsoft PowerApps Specialist Certification
Professional Experience & Leadership
Lead Data Engineer & Power BI Developer
Lead technical data architect for manufacturing intelligence, transforming dynamic shop-floor environments into scalable data platforms and real-time business intelligence ecosystems for executive leadership, Production Andon teams, Quality Assurance (QA), and PMO governance.
- Designed, deployed, and maintained enterprise SSIS data pipelines across multi-factory, multi-country manufacturing facilities (Canada, Mexico, US).
- Engineered and deployed 150+ Power BI reports, dynamic dashboards, and PowerApps solutions for Production Andon, QA, and PMO governance.
- Implemented a Data Quality KPI framework to measure, audit, and reconcile discrepancies between SAP, MES, and local operational databases.
- Integrated Azure Data Lake and Azure Portal services to monitor and optimize Power BI Premium capacity usage while maximizing query performance.
- Designed and launched the adaptive OSW Production Tracking web application using .NET Core and Angular for complex, non-standard aircraft structural assembly.
- Engineered 10+ rapid-response automation tools to streamline cross-departmental coordination, eliminating manual data entry.
Senior Data & Process Analyst
- Automated Crew Load Chart generation with VBA, slashing processing time by 98.8% (from 3 hours down to 2 minutes) while eliminating manual data entry errors.
- Engineered a Python web application for attendance tracking integrated with Crew Load analytics to measure shift efficiency.
- Architected daily, weekly, and monthly operational reporting across macro workflows and granular aircraft-wing manufacturing structures.
Process Improvement Lead & Senior Logistics Lead
- Built Manpower Mapping systems to classify touch and non-touch labor, reducing non-value-added idle time.
- Architected Line Logistic Cage tracking to display job-kit status and workability, preventing downstream assembly bottlenecks.
- Developed automated RNC reporting reducing dossier generation time to 3 minutes; digitized Daily Management Meeting reporting into automated dashboards (+200% efficiency).
- Managed parts, tooling, and hardware inventory in SAP and resolved critical shortages with vendors.
Executive Transformation & Consulting Roles
- Director, Systems & Methods: Built enterprise documentation framework accelerating first drilling project readiness to 3 months; led work-study resulting in an audit-verified 15% productivity gain.
- VP, Marketing & Transformation Manager: Led 31 process-improvement projects within 30 days; managed organizational restructuring while safeguarding key technical assets.
- Lead Business Consultant: Directed 30+ consulting engagements in Strategic Planning, Business Process Re-engineering (BPR), TQM, and Six Sigma across heavy industrial sectors.
Formal Academic Education
PhD in Public Policy
Tarbiat Modares University
Research focus on quantitative and ethical evaluation frameworks for public policies, decision science, and systemic institutional modeling.
Master of Business Administration (MBA)
Allameh Tabatabaie University
Specialization in strategic management, organizational design, marketing analytics, and systems engineering.
BSc in Industrial Engineering
Top Engineering Faculty
Foundations in operations research, statistical quality control, work study, stochastic modeling, and systems engineering.
Let's discuss how data intelligence can transform your operations.
Whether you need enterprise data pipelines, high-precision Power BI governance, or full-stack shop-floor execution systems, let's connect.