Data & Analytics Engineer with 8+ years of experience designing analytical SQL backends, real-time data pipelines, and automated reporting solutions using Microsoft Fabric and Power BI. Proven ability to bridge operation…
Data & Analytics Engineer with 8+ years of experience designing analytical SQL backends, real-time data pipelines, and automated reporting solutions using Microsoft Fabric and Power BI. Proven ability to bridge operational telemetry (IoT, MQTT, GPS, smart meters) with business intelligence. Strong expertise in SQL data modeling, merging complex datasets, and building rule-based real-time alerting systems. Lean Six Sigma advocate adept at translating complex operational data into actionable KPIs, automated workflows, and cost-saving initiatives.
<p>Developed a Zoho customer journey ticketing system and integrated CRM, Finance, and Inventory modules via APIs.<br>
Built Power BI dashboards for data-driven KPI monitoring and reporting.<br>
Engineered an end-to-end IoT telemetry pipeline for a 2-hotel SmartThings deployment.<br>
Ingested MQTT streams, flattened complex JSON payloads, and routed data via Azure Event Hubs into Microsoft Fabric Eventstream for real-time visualization.<br>
Integrated the real-time IoT data with CMMS workflows to automatically trigger maintenance tickets for faulty devices, demonstrating end-to-end automation from sensor to action.</p>
<p>Built analytical solutions on top of Oracle CC&B and Dynamics CRM using views from transactional and analytical SQL warehouses.<br>
Evaluated premise-level data, account details, and customer service touchpoints.<br>
Architected a main control room dashboard handling a 1-second refresh rate.<br>
Ingested GPS fleet tracking and high-volume operational data via a custom C-based polling program, enabling immediate incident response and monitoring of customer flow and WIP.<br>
Merged complex datasets across differing schemas (mapping utility premises to customer accounts).<br>
Resolved critical data integration faults to ensure data accuracy across all digital channels.<br>
Built a fully automated Power BI solution calculating MTTR, MTTA, MTTF, and Workman Hours (WMH) lost.<br>
Configured rule-based alerting for SLA breaches and win/loss scoring, reducing IT incident response time by 90%.<br>
Developed an IVR case status notification system for contractors and consultants using a lightweight API connection, streamlining emergency response workflows.<br>
Utilized Grafana to enhance real-time operational monitoring, improving SLA performance and proactive issue resolution.</p>
<p>Applied ABC (Pareto) analysis and demand forecasting for 2,000+ SKUs to optimize procurement and supplier coordination.<br>
Automated supply chain workflows using Min/Max formulas, re-order points, and automated decision triggers, improving stock availability and reducing operational costs.<br>
Implemented Zoho-based logistics tracking and CRM solutions, improving end-to-end supply chain visibility.</p>
<p>Designed and deployed analytical data models and interactive dashboards for eBay's used car parts supply chain, improving inventory visibility and operational decision-making.<br>
Leveraged Microsoft Fabric Data Factory and Python (Polars) to accelerate complex data transformations, merging disparate data sources to significantly cut down data modeling time.<br>
Provided training on BI reporting and data visualization to empower proactive stock management and cross-departmental data-driven decision-making.</p>
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
