Data Analyst Sales

- * -

Siqiu (Cleo) Li

*** ******** ***, *** *• Cupertino, CA 95014 • 908-***-**** • adcjx9@r.postjobfree.com EDUCATION

WORKING EXPERIENCE

Fabfitfun, Inc. Los Angeles, CA

Supply Chain Analyst Jul 2019 - Now

Using SQL, Salesforce, HighJump and Looker to generate monthly and quarterly reports/dashboards to assist in timely financial closes, explain any variances to budget and initially approve all invoices; support leadership in all process improvements, cost saving and initiatives analysis.

Work with domestic and international carriers to coordinate, track and report on inbound and outbound shipments. Resolve customs clearance/commercial invoice problems on direct imports.

Develop and maintain SOPs (Standard Operating Procedures), vendor guidelines, routing guides and all other reference/training documents.

Point of contact for all logistics related subjects. For example: communication between HQ and warehouse, HTS code and item classification, special labeling for restricted items. Architectural Mailboxes, LLC. Redondo Beach, CA

Logistics and Inventory Analyst Jan 2017 – Jul 2019

Employee of the Year (2018).

Forecast demand and make ordering plans using ERP system (NetSuite), WMS (ForeSight) and Excel. Successfully reduced Week of Stock by 28 weeks within 14 months.

Created proprietary mathematic models to support inventory planning, analyze demand seasonality, relationship between profitability and space expense for each SKU, audit 3PL storage and operation bills, and evaluate logistics cost impact by shrinking packages.

Coordinate with factories, ocean provider, drayage and 3PLs to ensure a timely inventory fulfillment; developed SOP to regulate warehouse’s inbound receiving, picking and shipping process.

Drive continuous improvement in the supply chain. Re-designed pallet configuration for over 300 SKUs, greatly improved warehouse rack utilization. Created "Combo Ordering" strategy for most frequently ordered SKUs allowing factory a stable production plan to make the supply more flexible and robust. CareSource, Inc. Dayton, OH

Data Analyst Feb 2016 – Jan 2017

Transportation Intern May 2015 – Jan 2016

Lead of Post-ride Transportation Survey Project, and the practice significantly extended the management visibility to transportation sub-contractors.

Develop dashboards and reports on transportation, billing, grievances and escalations fields; provide concrete and insightful analysis on different cases demanded by management group.

Amend and optimize service process by tracking and analyzing member grievances and escalations. Wal-Mart Stores, Inc. Shenzhen, China

Sourcing Intern Dec 2013 – Apr 2014

Prepared routine sales reports and conducted data analysis to facilitate sourcing decision making.

Controlled inventory level and managed product status based on sales data assessment.

Collaborated with product vendors and the marketing department to update online store pages. PROFESSINAL SKILLS

Excel, ERP, WMS, SQL, Tableau, HighJump, Salesforce, Looker. The Ohio State University, Fisher College of Business Master of Business Logistics Engineering (MBLE)

Sun Yat-sen University

Bachelor of Logistics Management

Merit-based third-prize scholarship

Exchange student with University of South Australia Columbus, OH

Dec 2015

Guangzhou, China

Jun 2014

Contact this candidate