Abdelrahman El Nabrawy
Cairo
Summary
Dynamic Production and Material Planning Engineer with strong analytical skills, specializing in optimizing production workflows and material requirements. Skilled in using ERP & excel to manage inventory, plan production schedules, and ensure timely delivery of raw materials and finished goods. Proven ability to collaborate across teams, address challenges proactively, with a keen eye for detail and a passion for process improvement and enhancing operational efficiency in dynamic environments.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Production/Material Planner
Jazeera Paints
01.2024 - Current
- Managing Production Orders and Material Planning:
- Managing/creating production orders for both Make-to-Stock (MTS) and Make-to-Order (MTO) products, ensuring timely delivery and efficient use of resources.
- Handle raw and packaging material purchase orders, maintaining optimal stock levels and minimizing inventory Stock out.
- Utilizing SAP ERP and Excel for Strategic Planning:
- Leverage SAP ERP to track production orders, manage stock levels, and optimize material requirements.
- Employ Excel to analyze material needs, aligning with SAP data to ensure accurate forecasting and planning.
- Collaborating and Problem-Solving:
- Work closely with the production team and sales team to track production orders, export sales orders, and meet delivery deadlines, resolving issues promptly to maintain workflow efficiency.
- Take the initiative to issue communications and facilitate coordination across departments, ensuring smooth operations and address Issues as they arise.
- Developing Strategic Plans and Budgets:
- Develop and regularly update weekly production plans to adapt to demand fluctuations.
- Create a 12-month material needs forecast at the beginning of each year to inform budgetary decisions.
- Conduct monthly and yearly Material Requirements Planning (MRP) using SAP to optimize resource allocation and ensure alignment with business objectives.
Production/Material Planner
Advanced Food Industries
01.2022 - 01.2023
- Production Planning: Developed and executed comprehensive production plans to align with demand forecasts, ensuring optimal inventory levels and preventing stockouts, incorporating a comprehensive approach that included not only demand forecasting but also factoring in distributor stocks and factory FG stocks, ensuring optimal utilization of resources.
- Material Control: Implemented efficient material control strategies, overseeing and optimizing stock levels to minimize excess and obsolete inventory, resulting in cost savings.
- Purchasing Order Management: management of purchasing orders, collaborating with Purchasing Team to ensure timely delivery of RM and PM, minimizing production delays and disruptions.
- Strategic Sales Performance Monitoring: Elevated sales performance monitoring by actively engaging in demand forecasting enhancements. Utilizing data analytics to scrutinize product-specific quantities in Forecast relative to sales trends, initiating proactive communication on necessary adjustments to align with sales targets. Resulted in improved turnover from RM and PM to FG to Sales.
Project Planning Engineer
H&O Group
01.2020 - 01.2021
- Collaborated with technical departments to understand their needs and specifications for purchased products for projects, and ensured timely procurement of necessary equipment and materials.
- Evaluated suppliers based on quality, price, delivery time, and other factors, and negotiated purchasing agreements that met the Company needs and budget.
- Ensure project success by Planning, monitoring progress, addressing issues, and communicating effectively with stakeholders
- Created purchase Requests (PRs) and followed up on the PO process to ensure timely delivery of products to the warehouses.
- Worked with two ERP systems (Next and Odoo) For procurement processes and inventory management and sales to improve efficiency.
- Managed an electronic store and purchasing of products, ensuring that the store had sufficient inventory to meet customer demand.
Education
Bachelor Degree - Mechanical-Production Engineering
Modern Academy for Engineering & Technology
01.2018
Skills
- ERP SAP MM/PP
- ERP oracle, ERP Oddo, ERP Next
- Strategic Decision-Making
- Supplier management
- Project planning
- Negotiation
- Cost analysis
- Contract management
- Production Scheduling
- Supply chain management
- Inventory management
- Material requirements planning
- Data Analysis
- Continuous improvement
- Lean manufacturing
- Six Sigma
- Advanced Excel Skills
Certification
- Supply chain course by career 180 (supply with demand planning & Logistics, MRP)
- Supply Chain Principles by Georgia Institute of Technology.
- AWS Cloud Foundation Practitioner Certified.
- Two-Weeks course at AZ Co. For Quality control.
- Sap course for Production planning and Material planning Modules.
Languages
Arabic : Native
Good Command of Spoken & Written English
References
References will be provided upon Request
Timeline
Production/Material Planner
Jazeera Paints
01.2024 - Current
Production/Material Planner
Advanced Food Industries
01.2022 - 01.2023
Project Planning Engineer
H&O Group
01.2020 - 01.2021
Bachelor Degree - Mechanical-Production Engineering
Modern Academy for Engineering & Technology