Zhou (Joe) Xu
EDUCATION
Kellstadt Graduate School of Business, DePaul University Chicago, IL
Master of Science in Marketing Analysis GPA: 3.88 March 2019
Relevant Coursework: Data Analysis and Regression, Market Research, Marketing Strategies and Planning, Precision Marketing, CRM, and Foundations of Data Science
College of Business, Missouri State University Springfield, MO
Bachelor of Science in Marketing Management GPA: 3.54 May 2016
Relevant Coursework: Applied Business Statistics and Operations Management
EXPERIENCE
SAS Project – Data Analytics and Regression, DePaul University Summer 2018
Built a linear regression model using SAS to explore factors that best predict the user ratings of Apple Store apps; identified number of available languages, game app dummy and app size to be the three most significant indicators for higher ratings.
Performed exploratory data analysis and tested multiple data transformations to improve model fit; used backward and stepwise regression to avoid model overfitting.
Compared and selected models by examining their Adjusted R^2 in training and testing data set.
SAMSUNG – Market Analysis & Strategy Development, DePaul University Spring 2018
Identified the key growth pain points by applying SWOT, 4Ps and Porter’s model; formulated plans for brand enhancement based on the analyses.
Recommended three strategies to address issues identified, including CRM optimization, increasing product showroom, and product diversification.
Led a team of five to develop and present insights that gained high approval from the professor.
Precision Market – Segmentation & Targeting, DePaul University Spring 2018
Performed segmentation analysis of a shopping mall customer data to target high-value groups, such as 35-65 female with families.
Constructed visualization using SPSS for the more intuitive presentation of the research results.
Brainstormed potential activities, such as complimentary yoga classes, inside the shopping mall to further improve customer experience.
YueYang Flagship Shop of Hongkong Royal Furniture Group, China
Market Manager / Market Researcher 2016 – 2017
Executed CRM campaigns to build better relationships with current and existing customers for better cross-sell and up-sell, which increased gross sales by 10% over the previous month.
Hired and trained six employees who, in less than two months, successfully collected around 300 survey responses and recruited eight potential customers to participate in focus group studies.
Developed and presented growth strategies based on focus group findings to the business owner, the following implementation resulted in a 20% sales growth month over month.
Performed customer segmentation analysis to aid the development of marketing campaigns.
SKILLS
Excel, SPSS, PowerPoint (Proficient); SAS, Google Analytics, SQL (Basic)
ADDITIONAL INFORMATION
Volunteer of "Working in The School" at DePaul University 2017
Volunteer of “Little Brother – Friends of the Elderly” in Chicago 2017
EDUCATION
Kellstadt Graduate School of Business, DePaul University Chicago, IL
Master of Science in Marketing Analysis GPA: 3.88 March 2019
Relevant Coursework: Data Analysis and Regression, Market Research, Marketing Strategies and Planning, Precision Marketing, CRM, and Foundations of Data Science
College of Business, Missouri State University Springfield, MO
Bachelor of Science in Marketing Management GPA: 3.54 May 2016
Relevant Coursework: Applied Business Statistics and Operations Management
EXPERIENCE
SAS Project – Data Analytics and Regression, DePaul University Summer 2018
Built a linear regression model using SAS to explore factors that best predict the user ratings of Apple Store apps; identified number of available languages, game app dummy and app size to be the three most significant indicators for higher ratings.
Performed exploratory data analysis and tested multiple data transformations to improve model fit; used backward and stepwise regression to avoid model overfitting.
Compared and selected models by examining their Adjusted R^2 in training and testing data set.
SAMSUNG – Market Analysis & Strategy Development, DePaul University Spring 2018
Identified the key growth pain points by applying SWOT, 4Ps and Porter’s model; formulated plans for brand enhancement based on the analyses.
Recommended three strategies to address issues identified, including CRM optimization, increasing product showroom, and product diversification.
Led a team of five to develop and present insights that gained high approval from the professor.
Precision Market – Segmentation & Targeting, DePaul University Spring 2018
Performed segmentation analysis of a shopping mall customer data to target high-value groups, such as 35-65 female with families.
Constructed visualization using SPSS for the more intuitive presentation of the research results.
Brainstormed potential activities, such as complimentary yoga classes, inside the shopping mall to further improve customer experience.
YueYang Flagship Shop of Hongkong Royal Furniture Group, China
Market Manager / Market Researcher 2016 – 2017
Executed CRM campaigns to build better relationships with current and existing customers for better cross-sell and up-sell, which increased gross sales by 10% over the previous month.
Hired and trained six employees who, in less than two months, successfully collected around 300 survey responses and recruited eight potential customers to participate in focus group studies.
Developed and presented growth strategies based on focus group findings to the business owner, the following implementation resulted in a 20% sales growth month over month.
Performed customer segmentation analysis to aid the development of marketing campaigns.
SKILLS
Excel, SPSS, PowerPoint (Proficient); SAS, Google Analytics, SQL (Basic)
ADDITIONAL INFORMATION
Volunteer of "Working in The School" at DePaul University 2017
Volunteer of “Little Brother – Friends of the Elderly” in Chicago 2017