SQL, SAS, Python, Tableau, Excel, Java/C#

CHEN

CAO

***

Mc

Lellan

Dr,

Apt

****,

South

San

Francisco,

CA,

***** *****:

(352)

*** ****

E Mail:

**********@*****.*** SUMMARY OF SKILLS AND CERTIFICATION

• Business Intelligence Skills: Excel, SQL, Tableau, XLMiner, STAT, MongoDB, Access.

• Other Skills: JAVA, Python, C#, JSON, Microsoft Office Suite.

• Language: English, Mandarin

CERTIFICATION

• SAS Base (certified Base Programmer for SAS 9).

• SAS Advanced (certified Base Programmer for SAS 9).

• Google Analytics Certification.

EXPERIENCE

Research Data Analyst July 2016 - Present

University of Florida – Information System and Operation Management Gainesville, FL

• Led a 4-people team, took over the responsibility of content operations of a public account on a mobile social media platform. By conducting user research and requirement analysis, changed the operations strategies, Planned and published 12 special topics. Attracted 200 followers in under one month with 0 cost, and gained 20% increase in the number of daily active users.

• Managed a team to analyze the beddings of 4 different brands (Ikea, Muji, Zara, H&M). Gathered data through web crawler with Python, manipulated 2000 records with Excel (such as Pivot table and V lookup) and Tableau. Compare various aspects of the product (style, fiber content, color and price etc.) to provide the guidance for customers when they made the purchase decision.

• Conducted research of Local Bike Share System. Collected more than 8000 research data from the questionnaires and public data, generated a report with the recommendation for the company to make wiser strategies regarding on the allocation of bike share system and find the factors will affect the way how user choose this service.

• Monitored the progression of projects, made timeline adjustments as needed and delivered research result on time. Ensured project documentation is complete and communicated. Operation Analyst May 2015 - May 2016

Sundix Technology Gainesville, FL

• Analyzed the E-commerce business report to access the factors that affect the profit, proposed the solutions for optimizing the conversion rate based on history data and influenced the sales up to 100% growth.

• Based on historical data, detected the problem of wrong items were shipped and avoided $20,000 loss.

• Monitored fulfillment performance and shipping options to ensure the logistic system was efficient and constant.

• Identified workflow improvements and observed results of operation improvement initiatives. Improved product picking process, reduced labor cost by 30% for the packaging stage.

• Coordinated budgets, timelines and resources to guarantee timely execution of standardized and Ad-hoc tasks.

• Managed SKUs on a product level and worked with appropriate teams to keep inventory is accurate and forecasted, updated product and transaction data within the ERP system. Community Assistant Jan 2014 - Feb 2015

UF Housing & Residence Education, University of Florida Gainesville, FL

• Awarded for graduate housing community: “Year of Service (2014)” and “Appreciation Certificate (2015)”.

• On-call duty and daily management for multicultural residents in all on-campus communities. EDUCATION

UNIVERSITY OF FLORIDA, Warrington School of Business 2013 - 2015 Master of Science in Information System and Operation Management Gainesville, FL ANHUI NORMAL UNIVERSITY, Department of Economics 2007 - 2011 Bachelor of Economics Anhui, China

Contact this candidate