Resume

Sign in

business analytics data analytics

Location:
Washington, DC
Posted:
September 28, 2018

Contact this candidate

Resume:

Xinyue Shi

**** ******* ****, ******* ****, MD, *0740 202-***-**** ac67re@r.postjobfree.com

EDUCATION

Robert H. Smith School of Business, University of Maryland, College Park, MD December.2018

Master of Science in Business Analytics GPA:3.2/4(top 30%) Major courses: Big Data &Artificial Intelligence; Data Mining &Predictive Analytics; Data Processing &Analytics

School of Business Administration, Northeastern University, Shenyang, China 2017 Bachelor of Economics, Major: Economics in International Economics and Trade GPA: 3.3/4.0(top 20%) Major courses: International Trade; Macroeconomics; Microeconomics; Statistics; Accounting; Finance;

School of Business Administration, National Dong Hwa University, Taiwan 2016 Exchange Program, Major: Finance GPA:4.3/4.5(top 5%)

PROFESSIONAL EXPERIENCE

CreditEase, Big Data Innovation Center, Beijing, China May 2018 – August 2018 Data Analyst

Analyzed weekly and monthly performance of telemarketing and p2p product by using Hive and MySQL;

Overfulfilled 30% KPI and realized 20% increase of sales amount by proposing strategic adjustment advice of changing target client after analyzing monthly sales amount, client amount and client features;

Realized online data visualization of monthly and weekly sales report including Radar, Bar chart and histogram;

Created auto call monitoring system by designing algorithm, compiling python script, and executing dispatch; Realized auto call performance query with different dimensions;

Cheng Tai Investment Management Co., Ltd, Shenyang, China January 2017- June 2017 Investment Analyst

Interacted with founders to help them complete startup launch program;

Leveraged pivot tables in Excel to conduct research on 27 startups to provide strategic recommendation;

Improved 2% SOM for some projects, realized financing for 7 projects and achieved investment return of $30,000.

RELEVANT EXPERIENCE

Python Project,“IMDb Movie Analysis” January 2018 – May 2018

Analyzed movie data for 5000 movies collected from the IMDB website using Excel and python by cleaning, indexing and filtering data for future manipulation;

Discovered multiple features and relationships between 5000 movies’ ranking and factors that influence the overall ranking, such as actors, year released and directors;

Leveraged Random Forest Tree, Logistic Regression, and Naïve Bayes as prediction model; Achieved accuracy of 90.7% compared to the baseline.

R Project, “Airbnb House Rating Prediction” January 2018 – May 2018

Cleaned more than 200,000 data with more than 70 features by using dplyr package;

Used tm package to do text mining and sensitive analysis and created selected features by using Lasso regression;

Leveraged Random Forest Tree, Logistic Regression, Naïve Bayes, XGboosting to train training dataset and applied model to testing dataset;

Achieved accuracy of 86.5% for the best prediction model compared to the baseline.

SQL Project, “Road to Master” October 2017 – December 2017

Built a database system using MySQL and defined relational schema to provide customized solutions related to graduate school programs for prospective students and educational practitioners;

Utilized factors such as program ranking, school location, and faculty to produce immediate value to users;

Leveraged Wix as a graphical user interface frontend to display results;

Provided detailed description and summary of all graduate programs in a user-friendly way.

LEADERSHIP EXPERIENCE

Professional Communications Club, University of Maryland 2017-2018 Vice President of Events

Planed the logistics for all the Association’s activities and events;

Organized Mock Career Fairs which have companies such as Deloitte, Merkle, and PWC, and Career Workshops with more than 500 participations.

ADDITIONAL INFORMATION

Proficient in Excel, SQL, R, Python, Hive, Hadoop, Tableau, Spark and Powerpoint

Certificate: Google Analytics Academy Certificate



Contact this candidate