Ashraf E. Email and Phone Number

- Collaboratively utilized Microsoft Power BI and Tableau to analyze and visualize complex supply chain data, providing actionable insights for supply chain colleagues, top management, and the head of the supply chain.- Proficiently acquired self-taught expertise in VBA macros, collaborating closely with the engineering optimization team within the company to gain valuable skills and insights. Effectively applied these skills to streamline and automate processes across the entire McKesson supply chain department, resulting in a substantial boost to operational efficiency and effectiveness.- Conducted comprehensive forecast analysis utilizing the F&R system, evaluating its suggested forecasts, troubleshooting issues, and leveraging predictive analytics to optimize inventory levels and demand prediction.- Employed advanced data analysis techniques, including SQL and DAX scripting, to collaboratively identify trends, patterns, and opportunities for optimization, contributing to data-driven decision-making and continuous improvement efforts.

- Collaborated cross-functionally to analyze stock allocation data from DCs, fulfillment centers, and 3PLs to efficiently allocate products to customers and stores.- Communicated effectively with stakeholders to update them on recovery dates, shipment details, and KPI information, fostering improved stock health.- Constructed vendor purchase orders based on historical sales rates and forecasts, actively participating in weekly vendor calls to resolve delivery issues and ensure timely procurement.- Developed a robust Bedroom Stock Health Tracker using SAP and BI reports, allowing for effective monitoring of stock levels across the business and driving informed sales actions.- Cultivated strong relationships with logistics teams and consistently provided valuable support to retail colleagues, leading to positive feedback and a role in presenting during B&Q Supply Chain weekly calls.- Led Bedroom stock campaigns by identifying and reallocating intended stock to appropriate distribution centers, ensuring timely store stock allocation, and regular reporting on sales performance against forecasts.

-Assisted in the implementation of monthly stock takes for raw materials and finished goods, ensuring accurate inventory records.-Collaborated with external suppliers to guarantee on-time deliveries and promptly addressed product-related issues, showcasing strong communication and problem-solving skills.-Sourced secondary suppliers for ingredient contingency, meticulously following the Technical approval process.-Employed Microsoft Axapta and Excel to create reports and planning spreadsheets, resulting in improved order efficiency and analysis.

-Innovatively developed an Excel tracker that seamlessly extracted real-time data from the company's ERP system, resulting in more efficient preparation for the manager's weekly meetings.-Enhanced the department's workflow by optimizing the Master Planning workbook used by engineers, facilitating quicker data extraction and insights from the ERP system.-Analyzed data systematically, leveraging advanced Excel skills, and skillfully imparted this knowledge to new staff members through comprehensive training sessions.

-Evaluated EOQ, MOQ, and SS parameters across Aalberts IPS operating companies, incorporating demand forecasts and requirements into a comprehensive business process map.-Selected optimal delivery routes for products, determining new EOQ, MOQ, and SS parameters through thorough desk and field research.-Conducted a Cost-Benefit analysis, identifying potential annual cost reductions of 75,000 euros by optimizing operating expenses.-Collaborated with cross-functional teams to implement process improvements and contributed to data-driven decision-making.-Demonstrated analytical prowess through in-depth evaluation of supply chain metrics, fostering continuous improvement initiatives.

-Utilized advanced Excel skills, including Pivot Tables and Macros, to construct an Excel workbook for real-time monitoring of material consumption in a new production line.-Collaborated with the production team and Operational Excellence colleagues to propose and execute a space area expansion plan for an improved production facility layout, leveraging lean principles and the MaxiLoad tactic.

-Managed Aalberts European vendors for Trade Goods, generating purchase orders based on anticipated demand and customer orders.-Assisted customer service with rush orders and inventory checks, ensuring accurate delivery information and inventory status communication via email and in-person interactions.-Successfully introduced a new purchase policy for a Trade Goods category, reducing carrying costs and optimizing Economic Order Quantity (EOQ) figures.