10/05/2026 updated
100 % available
Power BI Consultant | Manufacturing Analytics & OEE Dashboards | Product Costing
Cairo, Egypt
Worldwide
B.Sc. Mechanical Engineering (Design & Production Engineering) - Ain Shams University, 2005About me
Power BI consultant for manufacturers with 20+ years of plant operations experience. I build OEE, downtime and product-costing dashboards that cut losses: productivity +30%, downtime -25% in my own plant. I speak both shop floor and data. Open to remote projects.
AutoCADData AnalysisAutodesk InventorExcel Pivot TablesInventory Management SoftwareManufacturing EngineeringOperating ExpensePowerpivotOracle PrimaveraMicrosoft Power BIAnalysis of Business ProcessesCost EngineeringPowerqueryKpi Reporting
Plant Operations Management
Leadership of integrated plant operations covering Production, Maintenance, Inventory, Procurement and Supply Chain activities, including management of approximately 85 employees and definition of annual operational objectives with KPI monitoring across Safety, Quality, Delivery, Cost and Productivity.
Manufacturing Analytics & Power BI
Development of multi-line manufacturing analytics dashboards using Power BI, Power Query and Power Pivot, covering OEE, production performance, downtime, product costing, profitability and operational KPI analysis for management decision support.
Product Costing & Cost Analysis
Creation of interactive dynamic costing models calculating component consumption and cost based on product configuration, dimensions, carrier, packing, production-loss assumptions, utilities, wages and overhead, with detailed raw-material cost contribution analysis.
Maintenance Management
Planning and execution of preventive and corrective maintenance programs for compressors, pumps, chillers, turbines, process equipment and industrial oil-fired boilers, resulting in a reduction of equipment downtime by more than 25%.
MRP & Inventory Control
Design and implementation of integrated MRP solutions covering production planning, inventory control, purchasing and sales-order management, including Excel-based MRP systems for raw-material planning and spare-parts management.
Mechanical Design (AutoCAD & Autodesk Inventor)
Design of 3D mechanical assemblies and detailed fabrication drawings using Autodesk Inventor and AutoCAD, including a 150-ton industrial weighbridge and a three-silo supporting platform with approximately 60 tons total storage capacity.
Operational Excellence & Process Improvement
Implementation of productivity-improvement and cost-reduction projects using Six Sigma and work-study methods, achieving productivity improvements of more than 30% through process optimization and continuous-improvement initiatives.
Financial Reporting & P&L Analytics (Excel)
Development of structured financial-reporting dashboards transforming transaction data into Profit & Loss and Balance Sheet statements, including revenue, COGS, gross profit, expenses, net income, assets, liabilities, equity and balance reconciliation.
Fleet Cost & Maintenance Analytics
Development of fleet-level and vehicle-level analysis of mileage, fuel, oil, maintenance, services, traffic costs, driver and vehicle performance, maintenance categories and operating-cost trends using Power BI.
Project Planning (Primavera P6)
Application of Primavera P6 for project planning and scheduling in engineering and capital expenditure projects.
Leadership of integrated plant operations covering Production, Maintenance, Inventory, Procurement and Supply Chain activities, including management of approximately 85 employees and definition of annual operational objectives with KPI monitoring across Safety, Quality, Delivery, Cost and Productivity.
Manufacturing Analytics & Power BI
Development of multi-line manufacturing analytics dashboards using Power BI, Power Query and Power Pivot, covering OEE, production performance, downtime, product costing, profitability and operational KPI analysis for management decision support.
Product Costing & Cost Analysis
Creation of interactive dynamic costing models calculating component consumption and cost based on product configuration, dimensions, carrier, packing, production-loss assumptions, utilities, wages and overhead, with detailed raw-material cost contribution analysis.
Maintenance Management
Planning and execution of preventive and corrective maintenance programs for compressors, pumps, chillers, turbines, process equipment and industrial oil-fired boilers, resulting in a reduction of equipment downtime by more than 25%.
MRP & Inventory Control
Design and implementation of integrated MRP solutions covering production planning, inventory control, purchasing and sales-order management, including Excel-based MRP systems for raw-material planning and spare-parts management.
Mechanical Design (AutoCAD & Autodesk Inventor)
Design of 3D mechanical assemblies and detailed fabrication drawings using Autodesk Inventor and AutoCAD, including a 150-ton industrial weighbridge and a three-silo supporting platform with approximately 60 tons total storage capacity.
Operational Excellence & Process Improvement
Implementation of productivity-improvement and cost-reduction projects using Six Sigma and work-study methods, achieving productivity improvements of more than 30% through process optimization and continuous-improvement initiatives.
Financial Reporting & P&L Analytics (Excel)
Development of structured financial-reporting dashboards transforming transaction data into Profit & Loss and Balance Sheet statements, including revenue, COGS, gross profit, expenses, net income, assets, liabilities, equity and balance reconciliation.
Fleet Cost & Maintenance Analytics
Development of fleet-level and vehicle-level analysis of mileage, fuel, oil, maintenance, services, traffic costs, driver and vehicle performance, maintenance categories and operating-cost trends using Power BI.
Project Planning (Primavera P6)
Application of Primavera P6 for project planning and scheduling in engineering and capital expenditure projects.
Experience
Professional experience10+ years
Freelancer since2021
Languages
ArabicNative speakerEnglishFluent
Project history
Lead integrated plant operations covering Production, Maintenance, Inventory, Procurement and Supply Chain activities. Direct and develop approximately 85 employees. Define annual operational objectives and monitor KPIs covering Safety, Quality, Delivery, Cost and Productivity. Drive operational excellence, waste reduction, process optimization and cost-control initiatives. Lead preventive and corrective maintenance programs. Develop management dashboards and analytical models for production, OEE, downtime, manufacturing cost and operational decision support.
Set production and maintenance plans and coordinated execution with supervisors and technicians. Managed raw-material planning, inventory control, spare-parts management and procurement activities. Implemented productivity-improvement and cost-reduction projects using Six Sigma and work-study methods. Designed an Excel-based MRP solution for inventory, purchasing and production control. Designed and supervised execution of the 150-ton industrial weighbridge and three-silo supporting platform.
Executed production plans, prepared process sheets, monitored performance and managed maintenance activities for key plant equipment.