• Led to set up the systematic inventory refill process, performed weekly inventory report analysis by using SQL, Excel and Tableau on 2000+SKUs, identified demand tracking exceptions and adjusted the stock, decreasing the shortage by 25% and saving the inventory cost by 10%• Managed the daily sourcing and procurement for sales and production, achieving 12% cost reduction for purchase cost and decreasing 10% lead time• Overseed all PO-related operations conducted by four departments, including finance and logistics, decreasing the lead time by 5%• Responsible for production schedule by analyzing the demand and stock change, monitored the raw material allocations and coordinated with Co-man to ensure production finish on time, decreasing 10% shortage• Developed and executed supplier approval, product selection, negotiation and product ordering strategies, increasing 10+ qualified supplier and 50+ new SKUs• Collaborated with 4 departments including IT and sales on system improvements project, identified root causes and provided the instructional advice

• Analyzed customer behavior by using SQL queries, Excel, and Tableau, suggested quotes for 500+ items with a 5% increase in revenue and a 10% increase in repurchase rate• Generated weekly sales report analysis by using SQL queries, Power Queries, VLOOKUP, and Pivot table• Processed sales order and purchasing orders, arranged 20+ LTL shipments daily for Inbound and Outbound• Designed and implemented the quality assessment SOP with cross-functional team (colleting needs, drafting proposals, testing the SOP, and improving the process), presented the system to the senior management and applied project management skills to launch the SOP on time

Teaching assistant for following courses:BCOM 3310 Business CommunicationBCOM 4350 Advanced Business CommunicationENGY 6362 Project Management in Engineering and OperationsSYSM 6303 Statistics and Data AnalysisOPRE 3333 Quantitative Business AnalysisOPRE 3310 Operation Management

• Led a 5-member team to develop short-term course project, established the candidate course pool for 3-years by market research and cost-benefit analysis using Excel, reduced the short-term project preliminary process by 35%• Managed the cooperation projects with Vanguard and McDonald ’s, pre-analyzed the benefits and risks for the company to effectively evaluate projects, provided 2 proposals to streamline the operation process, reduced 12% overall prep time• Built up and visualized an effective dynamic evaluation dashboard model for the potential new courses by using Power BI, optimized and accelerated the new courses development process by 20%

• Led a 3-member team for an international lighting company research, collected the industrial and competitors data through a survey, processed the 15,000+ survey and industry data in R language, conducted PCA modeling and SWOT-PEST analysis, delivered 2 reports (“Enterprise International Market Research” and “Enterprise Future Strategy Report”)• Responsible for the research about international development of a famous Chinese technology company, collected the operation and market data through interviews with distributors, factory managers and etc., processed the data by R, and visualized the data by Power BI, analyzed and forecast the Indian market, delivered 1 research report• Supervised the sourcing and contract research for a well-known European cosmetics company, collected and sorted the data of current and potential suppliers, evaluated the capacity and quality of the suppliers, delivered 1 research report

• Researched and provided customer reference for the sales by collecting data and information from government portals and industry associations, creating online dashboards with Power BI, improved efficiency by 25%• Interlinked Standard Chartered Bank’s project on “Clients company’s credit analysis reports,” modified final reports