Can Liu Resume
CAN LIU
EDUCATION
SIMON BUSINESS SCHOOL, University of Rochester- Rochester, NY
Master of Science in Marketing Analytics (STEM Certified Program, available for full-time and relocation from Jun 2018)
Core Courses: Pricing Policies, Data Analytics by Using R, Marketing Analytics by Using R, Marketing Research, Digital Marketing Strategy.
St. Olaf College - Northfield, MN Mar. 2017
Bachelor of Arts in Economics and Studio Art
Core Courses: Statistic for Economists, Accounting, Management, Urban Economics, Health Care Economics, Art Relevant courses.
Technical skills: Expert in R, Tableau, MySQL, Advanced Excel (Regression, Analytic Solver, Pivot table), SEO, Photoshop, illustrator, Video Editing, In Processing, 3D modeling.
ANALYTICS EXPERIENCE
Xerox Corporation - Rochester, New York Jan.2018 - Jun.2018
Market Research Analyst (Simon Project)
? Created customer profiles and identified target customer segments by cleansing and analyzing data, implementing principle component analysis and cluster analysis with R.�
? Provided recommendations on the product and services for different segments by synthesizing value proposition, social media measurement, and competitive analysis, and created data visualizations using Tableau.
Wegmans Food Chain- Rochester, New York Feb.2018 - March.2018
Marketing Analyst
? Analyzed customer feedback survey data related to new products for a prestigious national food market chain, using R and built a predictive model to determine key attributes for potential new product, making a presentation to client and recommending a product launch.
Project: Analysis of Cost of Asthma in Rice County, St. Olaf College Oct. 2014 - Dec.2014
? Analyzed uncompensated asthma care cost, gathered data from MN Department of Health; reduced ER departments uncompensated health care by 54% by proving cost-effectiveness of hospital in-kind donation programs for Health Finders� cooperative; estimated ROI and break-even analysis.
EXPERIENCE
Mayo Clinic - Rochester, Minnesota
Graduate Intern, Education Department Jun. 2018 � Sep.2018
? Analyzed the monthly email marketing performance to determine which sent dates and subject lines that generates the highest conversion rate and presented the recommendations to managers.
? Examined the pattern of Live Course Registrations by incorporating with traffic data from Google Analytics and transaction data to find the positive influential factors to be replicated in future courses and reported to the leadership board.
? Analyzed the users experience to determine users interface changes for the ce.mayo.edu and offering the suggestions to maximize user engagement.
? Organized content management database and assisted in day to day management of marketing efforts across all channels.
Huawei Technologies Co. Ltd. - Sichuan, China Dec. 2016 - Jan. 2017
Marketing Intern, Marketing and Problem Solving Department
? Evaluated channel partners� annual revenue of each product category and identified top ten partners�and presented revenue distribution across product categories and locations to guide investments.
? Created marketing strategies and provided support with social media efforts by analyzing and collecting customers� feedback and click rates from the social media platforms.
? Planned and coordinated the Channel Partner Reciprocal Banquet with more than 400 participants.
ShangXia Trading (Shanghai) Co. Ltd - Shanghai, China July. 2016 - Aug. 2016
Sales/Marketing Intern, Marketing Department
? Provided recommendation on sales report, sales growth and market response by analyzing day to day sales.
? Recommended enhancing social media presence by collaborating with famous artist for designing new collection.
Sichuan Swan - Lake Development Co., Ltd., Chengdu, China July. 2014 - Aug. 2014
Sales & Marketing Intern, Marketing Department
? Increased sales by 118% by conducting marketing research and SWOT analysis and developed promotional strategies for 5100 Tibet Spring Water Company.
? Proposed new promotional campaigns using new media channels such as WeChat and Weibo.
ASSETS & INTERESTS
? Certifications: Google Analytics Advanced Certificated, Marketing Evolution Certificated.
? Leadership: Co-Chair and VP, Public Relations, St Olaf�s Chinese Culture Club, three years.
? Volunteer: Golf Coach - Coached golf summer camp for children in Chengdu.
? Interests: Photography, Painting and Hiking
CAN LIU
EDUCATION
SIMON BUSINESS SCHOOL, University of Rochester- Rochester, NY
Master of Science in Marketing Analytics (STEM Certified Program, available for full-time and relocation from Jun 2018)
Core Courses: Pricing Policies, Data Analytics by Using R, Marketing Analytics by Using R, Marketing Research, Digital Marketing Strategy.
St. Olaf College - Northfield, MN Mar. 2017
Bachelor of Arts in Economics and Studio Art
Core Courses: Statistic for Economists, Accounting, Management, Urban Economics, Health Care Economics, Art Relevant courses.
Technical skills: Expert in R, Tableau, MySQL, Advanced Excel (Regression, Analytic Solver, Pivot table), SEO, Photoshop, illustrator, Video Editing, In Processing, 3D modeling.
ANALYTICS EXPERIENCE
Xerox Corporation - Rochester, New York Jan.2018 - Jun.2018
Market Research Analyst (Simon Project)
? Created customer profiles and identified target customer segments by cleansing and analyzing data, implementing principle component analysis and cluster analysis with R.�
? Provided recommendations on the product and services for different segments by synthesizing value proposition, social media measurement, and competitive analysis, and created data visualizations using Tableau.
Wegmans Food Chain- Rochester, New York Feb.2018 - March.2018
Marketing Analyst
? Analyzed customer feedback survey data related to new products for a prestigious national food market chain, using R and built a predictive model to determine key attributes for potential new product, making a presentation to client and recommending a product launch.
Project: Analysis of Cost of Asthma in Rice County, St. Olaf College Oct. 2014 - Dec.2014
? Analyzed uncompensated asthma care cost, gathered data from MN Department of Health; reduced ER departments uncompensated health care by 54% by proving cost-effectiveness of hospital in-kind donation programs for Health Finders� cooperative; estimated ROI and break-even analysis.
EXPERIENCE
Mayo Clinic - Rochester, Minnesota
Graduate Intern, Education Department Jun. 2018 � Sep.2018
? Analyzed the monthly email marketing performance to determine which sent dates and subject lines that generates the highest conversion rate and presented the recommendations to managers.
? Examined the pattern of Live Course Registrations by incorporating with traffic data from Google Analytics and transaction data to find the positive influential factors to be replicated in future courses and reported to the leadership board.
? Analyzed the users experience to determine users interface changes for the ce.mayo.edu and offering the suggestions to maximize user engagement.
? Organized content management database and assisted in day to day management of marketing efforts across all channels.
Huawei Technologies Co. Ltd. - Sichuan, China Dec. 2016 - Jan. 2017
Marketing Intern, Marketing and Problem Solving Department
? Evaluated channel partners� annual revenue of each product category and identified top ten partners�and presented revenue distribution across product categories and locations to guide investments.
? Created marketing strategies and provided support with social media efforts by analyzing and collecting customers� feedback and click rates from the social media platforms.
? Planned and coordinated the Channel Partner Reciprocal Banquet with more than 400 participants.
ShangXia Trading (Shanghai) Co. Ltd - Shanghai, China July. 2016 - Aug. 2016
Sales/Marketing Intern, Marketing Department
? Provided recommendation on sales report, sales growth and market response by analyzing day to day sales.
? Recommended enhancing social media presence by collaborating with famous artist for designing new collection.
Sichuan Swan - Lake Development Co., Ltd., Chengdu, China July. 2014 - Aug. 2014
Sales & Marketing Intern, Marketing Department
? Increased sales by 118% by conducting marketing research and SWOT analysis and developed promotional strategies for 5100 Tibet Spring Water Company.
? Proposed new promotional campaigns using new media channels such as WeChat and Weibo.
ASSETS & INTERESTS
? Certifications: Google Analytics Advanced Certificated, Marketing Evolution Certificated.
? Leadership: Co-Chair and VP, Public Relations, St Olaf�s Chinese Culture Club, three years.
? Volunteer: Golf Coach - Coached golf summer camp for children in Chengdu.
? Interests: Photography, Painting and Hiking