Steve Bai

Sorted over 5,000 sales records according to dimensions including store location, product specification, product category and consumer gender; determined high-relevant product mix (Pomelo Paradis & Oolang Infini); raised average units per transaction by 25% and total monthly sales by 32% nationwide Consolidated 4 separate Excel workbooks (Inventory, Daily Sales, Shipments, In-store Stocks); shortened drafting time of monthly sales report from 3.5 hours to 25 minutes Redesigned online after-sale feedback form on WeChat; increased amount of effective feedback collected on WeChat by 60%