<ul>
<li>Automated material planning and procurement workflows using Microsoft Excel and Power Query, minimizing manual effort through data-driven automation.</li>
<li>Integrated and transformed data from BOQ, Project Schedule, Activity Mapping, Material Coefficients, Store Records, and DCT into a centralized material planning model.</li>
<li>Developed a schedule-driven material planning engine to estimate future material requirements using activity mapping and material consumption coefficients.</li>
<li data-section-id="18n1nes" data-start="2850" data-end="3035">Implemented procurement planning calculations including Lead Time, Buffer Days, Vendor Processing Time (VPT), Safety Stock, and Reorder Point (ROP) to support inventory decisions.</li>
<li data-section-id="y3vy2f" data-start="3036" data-end="3215">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.</li>
<li data-section-id="1wprdln" data-start="3216" data-end="3348">Documented workflows, business logic, and Power Query transformations to improve maintainability and facilitate knowledge sharing.</li>
</ul>