Sales Microsoft Office

Huan Guo

301-***-**** *********@*****.*** No sponsorship required

EDUCATION

University of Maryland, College Park, MD

Robert H. Smith School of Business 2014.05

Master of Science in Business (MSB), Focus Area: Marketing Analytics Northwest University, China 2013.07

Bachelor of Economics, International Economics and Trade GPA: 3.7/4.0

• Received Academic Scholarships-Dean’s List 2010-2011

• Vice President of Student Union

EXPERIENCE

Chang’an Calligraphy Exhibition, Shaanxi Province, China 2009.02-2010.02 Marketing Analyst

• Identified marketing strategy for Chinese calligraphy sales and reached targeted segments;

• Leveraged Excel to classify artworks according to the style, price, and customers’ demographically profile; Managed database in SAS and transferred literary profile to data to create a new client digital profile in Excel;

• Led team of 15 to analyze the promotion and advertising of calligraphy;

• Contributed to the design and management of company’s website and blog; Bank of China, Shaanxi Branch, China 2010.04-2010.12 Sales Assistant

• Managed data collection and data analysis in Excel to show the trends of new financial products;

• Worked collaborate with bank clerk to process private deposit and withdraw transactions;

• Co-generated private funds sales in consumer credit service; Bank of China, Shaanxi Branch, China 2012.02-2012.12 Financial Analyst Assistant

• Collected data and analyzed company’s profile in Excel before making financial investment;

• Managed in-house investment performance database; Contributed to finance management function to support the direct manager of finance department;

• Analyzed financial data in SAS and Excel to contribute financial report and provided statistic information and recommendation;

Lady M Online Boutique 2014.09-Present

Personal Style Consult

• Collected online shopping trends from diversity social network website; Made questionnaire about specific shopping category; Analyzed research results in Excel and SAS to target different customer segments;

• Doubled the customers by advertising through diversity social media and targeting particular segment

ADDITIONAL INFORMATION

• Language: English (Full professional proficiency) Mandarin (Native or bilingual proficiency)

• Technical: Microsoft Office, Excel, SAS, SPSS, R, SQL, Tableau, Google Analytics, Machine Learning, Infographic;

• Volunteer: International Horticultural Exposition 2011 Xi’an China 2011 Taught English and Chinese in rural area in China 2010

Contact this candidate