Xiaohan Gu Email & Phone Number

Beijing, China

Shanghai City, China

• Using Tableau Data Visualization software to filter, sort and analyze price quotes from different suppliers, found the lowest price and established long-term contracts with them to lower the costs• Cooperated with financial team to forecast next 3 month sales of products by using linear regression model, optimized holding on-hands inventory level, determined order quantity by EOQ model and increased profit by 0.5%• Collected Purchasing Orders, analyzed information in SAP System to align resources, suggest proper order quantity, order price and order time interval to increase effectiveness• Acquired primary and secondary data of suppliers’ contact information to generate a “Call List”, decreased the average time of finding information of suppliers by 1 hour per day

East Lansing, Michigan

Beijing City, China

• Leveraged extensive datasets and SQL to execute strategic analysis, and predicted the clients’ demand for next season, accomplished inventory risk management and lower the inventory holding cost by 1%• Communicated with our customers, leveraged Maslow’s hierarchy of needs theory to analyze product, made improvements, suggested company to move its focusing from “physiological needs” to “safety needs”, achieved a higher customer satisfaction• Translated unique customer needs in Chinese, Japanese and English to capture a broader customer field

Master'S Degree, Business Analytics And Risk Management

Bachelor Of Arts - Ba, Supply Chain Management

Bachelor Of Arts - Ba, Logistics, Materials, And Supply Chain Management