Category: Supply Chain & Analytics Projects
-
Nucor Steel — Manufacturing Planning & Saleability Analytics
I worked on a manufacturing analytics project focused on improving planning decisions for non-standard steel coil transitions at Nucor Steel. The project analyzed how production, quality, demand, and variability factors influence the saleability and cost impact of different grade transitions within a steel manufacturing environment. I developed a data-driven penalty model to evaluate transition risk…
-
Autodesk E-Commerce Database Design: SQL & Business Reporting
I completed a database design project focused on improving data consistency, scalability, and reporting accessibility for Autodesk’s e-commerce operations. The project was based on a real-world business case involving digital sales, customer accounts, subscriptions, software products, transactions, pricing, usage records, and support tickets. I designed and refined an EER diagram and relational schema that mapped…
-
Walmart U.S. Retail: Inventory Forecasting & Safety Stock Analysis
I completed an inventory analytics project focused on improving retail replenishment decisions across Walmart-style SKU demand patterns. The project explored how demand variability, reorder points, safety stock levels, holding costs, and stockout risks interact in retail inventory planning. Using Python and Excel, I developed demand forecasting and safety stock models to evaluate reorder point decisions…
-

Travel Itinerary Optimization Model
For my IEOR 164: Optimization project, I developed a stochastic optimization model in Pyomo to design a cost-effective and enjoyable three-day trip to Zion National Park. The model incorporated uncertainties in lodging costs, flight prices, and travel durations while making decisions on transportation, lodging, dining, and activities. By applying scenario-based optimization, I generated an itinerary…
