Materials Operations Intern
Current•Designed and implemented a comprehensive dashboard to showcase critical daily metrics, including Net Inventory, Backflush Errors, EDI Errors, Negative Inventory, No Supply, Missing BOM, and No Items.•Extracted data from QAD reports and PLEX systems for integration into macros supporting visualization.•Developed metrics like Days on Hand (DOH) and Inventory Trends utilizing VLOOKUP functions to support improved decision-making.•Calculated Data Wellness by consolidating all metrics mentioned above using advanced Excel skills, including complex formulas, macros, and VBA.