To support LP&L’s long-term inventory management improvement initiative, I developed a dynamic, Excel-based Inventory Database designed to increase transparency, streamline material inquires, and provide engineers with immediate access to item specifications, historical unit costs, and approved manufacturer data. With nearly 1,000 active inventory items across multiple locations, this project began with the collection and cleanup of usage data from JD Edwards (E1), followed by the reevaluation of reorder points (ROP) and economic order quantities (EOQ), which I visualized in a dedicated dashboard for comparison.  

From there, I audited and updated specification details, verified approved manufacturers, and standardized formatting across both the internal ERP system and the database itself. To ensure long-term usability, I build a scalable backend Power Query, allowing the system to be refreshed and maintained by future supply chain interns with minimal disruption.  

During the process, I identified over 90 obsolete (“dead”) items – 56 of which still had physical stock in the warehouse. I collaborated with the Purchasing team to initiate an auction and successfully began clearing these materials. Once the database framework was complete, I authored both a Maintenance Guide for future interns and a User Guide for engineers, ensuring the tool could be easily navigated, understood, and sustained in the long term. To supplement these guides, I also produced a short video walkthrough that visually demonstrates how to use and maintain the database – making onboarding faster and more intuitive.  

With the system now live, the next phase focuses on catalog number validation. Many specifications haven’t been updated since the 2010s, and the tool is not structured to include only manufacturers and CAT#s verified as valid, current, and relevant.