Ajinomoto Foods North America
CO-OP Packaging Engineer · May 2024 — April 2025
PythonPandasNumPyData AnalysisDatabase Architecture
CO-OP Packaging Engineer at Ajinomoto Foods North America (California)
Key Achievements
- Database Architecture & Migration: Led the consolidation of over 26,000 packaging data points into a new central database (Product Vision). Analyzed over 750 legacy specifications to design a streamlined schema, reducing attributes to 31 essentials through collaboration with R&D, Procurement, and New Product Introduction teams.
- Cost-Saving Analysis: Developed a Python-based tool using Pandas and NumPy to analyze case similarities with the Euclidean distance formula. Identified over $150,000 in potential annual savings through corrugate case consolidation.
- Executive Presentation: Presented the cost-saving analysis findings to senior leadership, including the CEO and Chief Supply Chain Officer.
- Cross-Functional Data Support: Served as the primary data resource for major company initiatives, providing critical packaging data for 17 new robot palletizing systems and sustainability reporting to major clients like Kroger and US Foods.
- System Customization: Designed and configured a dynamic reporting template within the Product Vision system to automate the generation of standardized specification sheets for cross-functional teams.