SHENGJIE QIAN
Shengjie Qian
Apt 5, 2477 Overlook Road, Cleveland Heights, Ohio, 44------------, ------------
SUMMARY
• Skills: Python, R language, SPSS, Tableau, SQL, SAS, Adobe Analytics, Google Analytics
• Experience: Modeling, Coding, Consulting, Assurance, Behavioral Economics
EDUCATION
Master of Science in Management, Business Analytics, January 2021
Weatherhead School of Management, Case Western Reserve University, Cleveland, OH
• Relevant Courses: Data Mining & Visualization, Predictive Modeling, Operations Analytics: Stochastic, Advanced Marketing Analytics, Marketing Models & Digital Analytics, Machine Learning and Artificial Intelligence in Business Analytics
Bachelor of Economics, Quantitative Finance, 2019 Zhejiang University of Technology, Hangzhou, China
• GPA: 3.71/4.0
• Chinese National Scholarship, 1st Class Scholarship, Top Ten College Students, School Outstanding Student
PROFESSIONAL EXPERIENCE Dare 2 Care International, Cleveland, US
Nonprofit organization management.
Summer Intern
• Collecting Data and analyze data to support the website building
06/2020-08/2020
• Manage the survey results from the global panel and learn to create CRM
Meritco Service, Shanghai, China
A strategy and management consulting company services to corporate clients in a variety of industries including consumer goods, industrial products, pharmaceutical/healthcare and TMT.
Research Assistant Intern
• Assist consultants to consumer market research, use R to scratch data, analyze and manage data, interview with experts, and contact qualified consumers to conduct in-depth interviews with consultants
• Sort out interview notes, upload historical notes, and go to the physical store to record the situation of researching industry Ernst & Young Hua Ming LLP, Shanghai, China 07/2017-08-2017 EY is a global leader in assurance, tax, transaction and advisory services.
Assurance Intern
• Verify bank statement and contracts of more than 10 subsidiary companies to ensure the existence and accuracy
• Help to calculate and audit rental costs, produced three audit papers
• Collect, classify and register a total of over 400 audit papers which related previous years to ensure the integrity of the data
KEY ACADEMIC PROJECTS
Adobe Analytics Challenge, Cleveland, US 09/2019-10/2019 A competition organized by Adobe Company to analyze the data of MLB this year.
• Use Adobe Analytics Cloud to analyze the data on the MLB web page and app side and figure out which factors drive customers to buy tickets and merchandise and find improvements of the website and apps.
• Analyze user portraits of MLB customers and find ways to create the excitement and personalized touch online.
Deloitte Innovation Challenge Camp, Shenzhen, China 05/2018-08/2018 A top competition in consulting industry services to guide students use digital thinking to look at industry transformation.
• Propose an online and offline integrated marketing and small program integration environment.
• Do the model of the program, collect data, produce slides, and analyze financial risks.
RELEVANT SKILLS
• Technical Skills: Python, R language, SPSS, Tableau, SQL, SAS, Adobe Analytics, Advanced Excel
• Language Skills: Mandarin (native), English (fluent)
CERTIFICATIONS AND CONTINUING EDUCATION
01/2019-04/2019
• ACCA certificate: Passed F1-F7 and F9 exams
[Qian], page 1 of 1
Shengjie Qian
Apt 5, 2477 Overlook Road, Cleveland Heights, Ohio, 44------------, ------------
SUMMARY
• Skills: Python, R language, SPSS, Tableau, SQL, SAS, Adobe Analytics, Google Analytics
• Experience: Modeling, Coding, Consulting, Assurance, Behavioral Economics
EDUCATION
Master of Science in Management, Business Analytics, January 2021
Weatherhead School of Management, Case Western Reserve University, Cleveland, OH
• Relevant Courses: Data Mining & Visualization, Predictive Modeling, Operations Analytics: Stochastic, Advanced Marketing Analytics, Marketing Models & Digital Analytics, Machine Learning and Artificial Intelligence in Business Analytics
Bachelor of Economics, Quantitative Finance, 2019 Zhejiang University of Technology, Hangzhou, China
• GPA: 3.71/4.0
• Chinese National Scholarship, 1st Class Scholarship, Top Ten College Students, School Outstanding Student
PROFESSIONAL EXPERIENCE Dare 2 Care International, Cleveland, US
Nonprofit organization management.
Summer Intern
• Collecting Data and analyze data to support the website building
06/2020-08/2020
• Manage the survey results from the global panel and learn to create CRM
Meritco Service, Shanghai, China
A strategy and management consulting company services to corporate clients in a variety of industries including consumer goods, industrial products, pharmaceutical/healthcare and TMT.
Research Assistant Intern
• Assist consultants to consumer market research, use R to scratch data, analyze and manage data, interview with experts, and contact qualified consumers to conduct in-depth interviews with consultants
• Sort out interview notes, upload historical notes, and go to the physical store to record the situation of researching industry Ernst & Young Hua Ming LLP, Shanghai, China 07/2017-08-2017 EY is a global leader in assurance, tax, transaction and advisory services.
Assurance Intern
• Verify bank statement and contracts of more than 10 subsidiary companies to ensure the existence and accuracy
• Help to calculate and audit rental costs, produced three audit papers
• Collect, classify and register a total of over 400 audit papers which related previous years to ensure the integrity of the data
KEY ACADEMIC PROJECTS
Adobe Analytics Challenge, Cleveland, US 09/2019-10/2019 A competition organized by Adobe Company to analyze the data of MLB this year.
• Use Adobe Analytics Cloud to analyze the data on the MLB web page and app side and figure out which factors drive customers to buy tickets and merchandise and find improvements of the website and apps.
• Analyze user portraits of MLB customers and find ways to create the excitement and personalized touch online.
Deloitte Innovation Challenge Camp, Shenzhen, China 05/2018-08/2018 A top competition in consulting industry services to guide students use digital thinking to look at industry transformation.
• Propose an online and offline integrated marketing and small program integration environment.
• Do the model of the program, collect data, produce slides, and analyze financial risks.
RELEVANT SKILLS
• Technical Skills: Python, R language, SPSS, Tableau, SQL, SAS, Adobe Analytics, Advanced Excel
• Language Skills: Mandarin (native), English (fluent)
CERTIFICATIONS AND CONTINUING EDUCATION
01/2019-04/2019
• ACCA certificate: Passed F1-F7 and F9 exams
[Qian], page 1 of 1