Carrollton, Texas, United States
Monitored 3 performance metrics including inventory turnover rate, cash conversion cycle, and safety stock that provide visibility on company-wide supply chain effectiveness, drafted interactive dashboard and digital report using Tableau, and helped the business manager support inventory asset management by adding 1 new automated transition line and reduced inventory shortage by 12% by the end of 2020. Analyzed inventory levels by querying 1.6M+ logistic schedule records with SQL and presenting day-to-day changes with Tableau dashboards, then successfully reorganized logistic lines in the Pacific Northwest region and discovered a new re-order point thus improving service level by 10%. Managed and analyzed over 5M sales and production forecast data to evaluate product demand and supplier production capability via data research and validation with SQL and SAP, then developed new economic order quantity for the top products and reduced inventory cost by 7%.
Increased students’ understanding of course material through review sessions, discussions, and practice problems.
Researched and analyzed the profitability of major European airports and several global airport operation groups, generated a comprehensive industry research report using Excel PivotTables, and the report was introduced to International Air Transport Association (IATA) as a 1st of a kind. Classified and managed airport financial and operational data; reduced overall data collection time for measurements of airport expense management metrics by 20%.
Managed student union activities efficiently and facilitated communication between various student groups.