• Automated material planning and procurement workflows using Microsoft Excel and Power Query, minimizing manual effort through data-driven automation.
• Integrated and transformed data from BOQ, Project Schedule, Activity Mapping, Material Coefficients, Store Records, and DCT into a centralized material planning model.
• Developed a schedule-driven material planning engine to estimate future material requirements using activity mapping and material consumption coefficients.
• Implemented procurement planning calculations including Lead Time, Buffer Days, Vendor Processing Time (VPT), Safety Stock, and Reorder Point (ROP) to support inventory decisions.
• Designed an interactive procurement dashboard providing recommendations on What to Order, How Much to Order, and When to Order based on projected demand and available stock.
• Documented workflows, business logic, and Power Query transformations to improve maintainability and facilitate knowledge sharing.