Business Analyst

Runhan Su

**** ************ ***., *******, ******, MA. 02134 1-617-***-**** adb6e1@r.postjobfree.com

EDUCATION

Boston University Master of Science September 2018 – January 2020 Major: Applied Business Analytics Certificate: Enterprise Risk Management Courses: Risk Management, Business Analytics, Web Analytics, Financial Concepts, Data mining Shanghai International Studies University (SISU) Bachelor of Arts Major: French September 2013 – July 2017 Tongji University Bachelor of Business Major: Marketing Management September 2014 – July 2016 BUSINESS PROJECTS

New York Real Estate Business Analysis March 2019 – June 2019

Prepared and explored the dataset with over 70,000 observations by dealing with missing values and outliers.

Discarded variables by applying correlation matrix approach. Developed multiple linear regression model on log_price.

Utilized machine learning algorithm K-nearest neighbors, Naïve Bayes, and decision tree to do classification analysis.

Performed K-means clustering approach to found out neighborhoods in NY with highest price, most flexible cancella- tion policy and most reviews and made recommendations to travelers, investors, and competitors. Nike New Product Market Analysis June 2019 – July 2019

Used Conjoint, linear regression analysis and google analytics to analyze Nike womens’ sneaker market.

• Conducting secondary research, typically by combining information from a variety of sources (e.g. annual reports, news articles, industry reports)

Airbnb Real Estate Data Analysis July 2019 – August 2019

Performed data mining and analysis for Airbnb involving visualization, prediction, classification, and clustering.

Forecast price trends by making linear regression and statistical analysis on large data sets with Matlab, generated summary report dashboard and demonstrated to the quantitative analyst. WORK EXPERIENCE

Business Analyst Estée Lauder (Shanghai) Trading Co., LTD. Shanghai, China April 2016 –June 2018

• Ran for multiple marketing campaigns; Analyzing market and client data in Excel to distill insights (e.g. competi- tive analysis, pricing performance, product-line profitability)

• Building statistical models on R (e.g. price elasticities, demand forecasting, geospatial analysis)

• Composed public relations reports for charity events based on collected information, and creating presentations that integrate qualitative knowledge with numerical evidence and provide actionable recommendations

• Participated in the breast cancer campaign event “Pink Ribbon”, by collecting and analyzing data, communicating with vendors, participating in client meetings and updates and interfacing with junior client team members, and evaluating risks.

Finance Analyst Assistant Huashe Wealth Co., LTD, Shanghai, China October 2015 – January 2016

•Made fundamental analysis and Ad hoc Analysis on financial statement, developed and implemented procedures for contract management and administration in compliance with company policy and the business analyst

•Wrote customer specific notes, tracked customer support calls and emails and worked with Engineering Manage- ment for resolution and adding users for customers Media Analyst The Film “Once Again” & Shanghai International Film Festival Shanghai, China October 2015

Responsible for all the social media publication of the film crew, including marketing data analysis.

Attended the Shanghai International Film Festival as the crew member for the movie promotion. HONORS AND LEADERSHIP ACTIVITIES

President of the Student Union SISU Shanghai, China June 2014 – September 2017

Planned and promoted several university-level activities such as “Campus Girl”. ADDITIONAL SKILLS

Language: Native speaker of Mandarin, Fluent in English, intermediate-level of French, beginner of Spanish

Computer: Word, Outlook, Excel, Power BI, PowerPoint, and R, Google Analytics, Python, SQL, Power Pivot

Contact this candidate