Mohammed Ehsan

About

Most dashboards need babysitting. Mine don't. I build analytics platforms from scratch. Not just dashboards. The full stack underneath them: finding the right data, connecting messy sources, building pipelines from raw to gold, defining the right measures, and delivering something leadership actually checks every morning. Recent work: 1. Built the entire data infrastructure for a 17+ outlet specialty coffee chain. Microsoft Fabric Lakehouse, PySpark transformations, 1.4M+ orders, executive Power BI dashboard refreshing every 30 minutes. Delivered in under 30 days. The CEO and MD use it daily. 2. A facilities company had footfall data locked inside camera systems. I reverse-engineered undocumented APIs, built Python collectors, implemented real-time streaming, and automated ingestion across 3 buildings. 500K+ records flowing 24/7. 3. A university needed centralized feedback tracking across 30+ departments. Built it end to end using Power Apps, SQL, Python for sentiment analysis, Power BI for reporting, and Power Automate for alerts. Resolution time dropped 65%.6+ years across F&B, education, facilities, procurement, and manufacturing. I work with Microsoft Fabric, Power BI, SQL, Python, and enough undocumented APIs to know that patience is a technical skill. Messy data in. Clean, automated insights out. If you're trying to turn operational data into something people actually use, let's talk.

Experience

• Business Data Analyst · F&B Operations Analytics12-01-2025 –

  Built a Microsoft Fabric Lakehouse for a specialty coffee chain, processing 1M+ orders across 17 outlets using a Bronze to Silver to Gold architecture. Implemented PySpark ETL, product mix analytics, and market basket analysis. Delivered an executive-ready Power BI operations dashboard designed for quick consumption by leadership, with a 30-minute refresh cadence. End-to-end delivery completed in under 30 days. Also reverse-engineered a third-party drive-thru vendor’s calculation logic to build a real-time operations dashboard that aligns exactly with the source system.

• Data Analytics Engineer · Multi-Building Surveillance Analytics12-01-2025 – 01-01-2026

  Built an end-to-end real-time analytics platform integrating Dahua DSS REST APIs with SQL Server and Power BI across three geographically distributed buildings. Developed Python collectors for live footfall and face demographic events, processing over 500K records. Implemented Kafka-based streaming to support real-time operational monitoring and downstream analytics. Designed a normalized SQL data model with reliable upsert patterns and time-intelligence support, and automated continuous ingestion with logging and monitoring for 24/7 availability. Delivered Power BI dashboards with YoY and MoM analysis, demographic trends, and drill-through from yearly to daily views.

• BI & Automation Analyst · Horizon University College11-01-2024 – 12-01-2025

  Owned BI and automation for a university under Ministry accreditation oversight. Delivered regulator-aligned KPI dashboards and a centralized feedback resolution system across 30+ units, reducing resolution time by 65 percent. Built an LLM-powered document search tool for audit teams using Python and FAISS, cutting preparation time by 70 percent.

• Warehouse Operations Manager · ProDrive PTO & Hydraulics10-01-2023 – 10-01-2024

  Led integration of Sage ERP and Zoho CRM into a unified analytics layer supporting procurement, inventory, and customer insights. Delivered Power BI dashboards and automated SQL-based pipelines, reducing procurement costs by 15 percent and improving process efficiency by 25 percent.

• Procurement Analyst · Fugro07-01-2021 – 09-01-2023

  Built Power BI and Excel VBA dashboards to support procurement planning and BOMs exceeding $1.5M, improving supplier visibility and reducing reporting time by 30 percent. Applied Kanban-based analytics to production workflows, helping reduce lead times by 30 percent.

Education

• Sheridan CollegeBusiness Analysis and Process Management
• Western UniversityMaster of Engineering - MEng, Mechanical and Materials Engineering
• The Oxford College of EngineeringBachelor of Engineering - BE, Mechatronics Engineering

Similar talent on Pangea

Julian R.Business Intelligence (BI) Analyst | Power BI, SQL & KPI/Analytics (7+ Years)Bogotá, BogotaSarah S.Data Analyst | Driving Data-Driven Decisions |Colorado Springs, CORolonda H.Transforming Business with Data & Strategy | | Empowering Growth Through AnalyticsNorth Carolina, USAGaniu A.Business Intelligence and Data Analyst | Helping Business Leaders and Data Teams Unlock Insights with Automated Data Transformation, Visualization using Power Query, Power BI, Sisense, Python, and SQL | PL-300 Certified