Shun Liu_Resume
Shun Liu
EDUCATION BACKGROUND
Bentley University McCallum Graduate School of Business, Waltham, MA
Master of Science in Business Analytics, candidate GPA: 3.78/4.0 08/2017 � 05/2019
Core course taken: Data Mining, Intermediate Statistical Modeling, Statistical Design of Experimental for Business, Visualizing Information, Time Series Analysis, Data Management & SQL for Analytics, Optimization and Simulation
University of International Business and Economics (UIBE), Beijing, China
Bachelor of Science in Economics, Major in Finance GPA: 3.60/4.0 09/2013 � 06/2017
TECHNICAL SKILLS
Work experience in Microsoft Word, Excel, PowerPoint;
Class project experience in R, Python, SQL, Tableau, SAS, SPSS, Stata, Java
PROFESSIONAL EXPERIENCE
Bentley University, Waltham, MA 07/2018 � Present Data Analytics Research Assistant, Health Information Sharing Project with Amazon Alexa
The project is still in progress. The goal of this project is to investigate how AI devices (Alexa Echo) can affect the daily life of seniors and the pattern of the daily use of the voice control devices
� Scraped the Alexa user dialog data from the Amazon Alexa website and exported into csv files with Python and Chrome Scraper; Cleaned and organized the raw data with Excel
� Performed text mining, including text parsing, text filtering and text clustering on the user dialog data with SASEM to analyze frequency of all terms, group text data into different categories and improve the features of our Alexa skill
BMW Automotive Financial Services (China), Beijing, China 11/2016 � 05/2017
Data Analyst Intern, Product & Pricing Team, Marketing Department
� Manipulated and processed large volume of monthly vehicle insurance sales data (50 k+ records); Efficiently and accurately performed ad-hoc analysis using advanced Excel features (V-lookup, Pivot Table) requested by the manager
� Created and managed the dashboards with Excel and PowerPoint after performing data analysis with Excel Pivot Table;
Transformed the data into insightful information, e.g. trend analysis, regional analysis, market penetration analysis
� Efficiently searched relevant information and conducted research in global automotive finance industry to identify opportunities for expansion into new businesses and to assess business strategies of the major competitors of BMW
Deloitte (China), Beijing, China 01/2016 � 03/2016
Intern, Audit Services
Engaged in the annual audit for a Fortune Global 500 client in financial industry; Received the highest rating in the intern performance evaluation from the Senior Manager in the team
� Checked 400+ account balances with bank confirmation letters from 150+ banks; Discovered 3+ spreadsheet blunders in client�s accounting material; Effectively communicated with the client company to evaluate the accounting errors
� Helped 2 colleagues to double-check or process data in audit worksheet for 10+ accounting accounts
ACADEMIC PROJECT
Prediction of Income Levels of Adults Using Machine Learning 09/2018 � 10/2018
� Built decision tree and neural network models to predict income levels (<50,000 or ?50,000) based on 25,000 records with R; Applied advanced ensemble tree models for better accuracy; Performed model comparison among models
Forecasting the Number of Foreign Arrivals to the U.S. Using Time Series Analysis 03/2018 � 05/2018
� Worked on a monthly data set from 2004 to 2017 and explored the foreign travel patterns to the U.S. through time series modeling with R in a team of 3; Generated 1-year prediction with R, with the mean absolute percentage error of 12%
Database Management and Modeling Group Project 11/2017
� Led a 4-person team to model the database structure, implement relational database that stores 500+ KB data and retrieve relevant data using well-formed SQL queries; Created well-designed data visualization dashboards using Tableau
MCM/ICM (Mathematical Modeling Contest/ Interdisciplinary Contest in Modeling) 02/2016
� Led a 3-person team to build regression model and time series model to predict water shortage amount in 25 years for a chosen province in China; Responsible for data searching, data processing with Excel and model constructing with R
� Earned �Honorable Mention� out of 9700 participating teams in the world
Shun Liu
EDUCATION BACKGROUND
Bentley University McCallum Graduate School of Business, Waltham, MA
Master of Science in Business Analytics, candidate GPA: 3.78/4.0 08/2017 � 05/2019
Core course taken: Data Mining, Intermediate Statistical Modeling, Statistical Design of Experimental for Business, Visualizing Information, Time Series Analysis, Data Management & SQL for Analytics, Optimization and Simulation
University of International Business and Economics (UIBE), Beijing, China
Bachelor of Science in Economics, Major in Finance GPA: 3.60/4.0 09/2013 � 06/2017
TECHNICAL SKILLS
Work experience in Microsoft Word, Excel, PowerPoint;
Class project experience in R, Python, SQL, Tableau, SAS, SPSS, Stata, Java
PROFESSIONAL EXPERIENCE
Bentley University, Waltham, MA 07/2018 � Present Data Analytics Research Assistant, Health Information Sharing Project with Amazon Alexa
The project is still in progress. The goal of this project is to investigate how AI devices (Alexa Echo) can affect the daily life of seniors and the pattern of the daily use of the voice control devices
� Scraped the Alexa user dialog data from the Amazon Alexa website and exported into csv files with Python and Chrome Scraper; Cleaned and organized the raw data with Excel
� Performed text mining, including text parsing, text filtering and text clustering on the user dialog data with SASEM to analyze frequency of all terms, group text data into different categories and improve the features of our Alexa skill
BMW Automotive Financial Services (China), Beijing, China 11/2016 � 05/2017
Data Analyst Intern, Product & Pricing Team, Marketing Department
� Manipulated and processed large volume of monthly vehicle insurance sales data (50 k+ records); Efficiently and accurately performed ad-hoc analysis using advanced Excel features (V-lookup, Pivot Table) requested by the manager
� Created and managed the dashboards with Excel and PowerPoint after performing data analysis with Excel Pivot Table;
Transformed the data into insightful information, e.g. trend analysis, regional analysis, market penetration analysis
� Efficiently searched relevant information and conducted research in global automotive finance industry to identify opportunities for expansion into new businesses and to assess business strategies of the major competitors of BMW
Deloitte (China), Beijing, China 01/2016 � 03/2016
Intern, Audit Services
Engaged in the annual audit for a Fortune Global 500 client in financial industry; Received the highest rating in the intern performance evaluation from the Senior Manager in the team
� Checked 400+ account balances with bank confirmation letters from 150+ banks; Discovered 3+ spreadsheet blunders in client�s accounting material; Effectively communicated with the client company to evaluate the accounting errors
� Helped 2 colleagues to double-check or process data in audit worksheet for 10+ accounting accounts
ACADEMIC PROJECT
Prediction of Income Levels of Adults Using Machine Learning 09/2018 � 10/2018
� Built decision tree and neural network models to predict income levels (<50,000 or ?50,000) based on 25,000 records with R; Applied advanced ensemble tree models for better accuracy; Performed model comparison among models
Forecasting the Number of Foreign Arrivals to the U.S. Using Time Series Analysis 03/2018 � 05/2018
� Worked on a monthly data set from 2004 to 2017 and explored the foreign travel patterns to the U.S. through time series modeling with R in a team of 3; Generated 1-year prediction with R, with the mean absolute percentage error of 12%
Database Management and Modeling Group Project 11/2017
� Led a 4-person team to model the database structure, implement relational database that stores 500+ KB data and retrieve relevant data using well-formed SQL queries; Created well-designed data visualization dashboards using Tableau
MCM/ICM (Mathematical Modeling Contest/ Interdisciplinary Contest in Modeling) 02/2016
� Led a 3-person team to build regression model and time series model to predict water shortage amount in 25 years for a chosen province in China; Responsible for data searching, data processing with Excel and model constructing with R
� Earned �Honorable Mention� out of 9700 participating teams in the world