Data Microsoft Office

Xin Gu

**** **** ***, ******* ****, MD 240-***-**** ***.**@*******.***.***

EDUCATION

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

• Master of Science in Business Analytics, GPA: 3.85, Outstanding Graduate Scholarships Northeastern University Qinhuangdao, China June 2017

• Bachelor of Economics, International Economy And Trade, GPA: 3.92, Rank: 1/137

• Three times National Scholarships (Top 1.3%), One time University Top-grade Scholarship, Three times The First Prize Scholarship (Top 10%)

• National Utility Model Patent holder

SKILLS

Languages: Chinese (native), English (fluent)

Technical:

• Programming Languages: Python, R, SQL.

• Hadoop Ecosystem: HDFS, MapReduce, YARN, Hive, Pig, HBase, Sqoop, Spark and Amazon AWS.

• Other Analytical Tools: Tableau, Microsoft Office Suite. PROJECTS

Database Management Systems Consulting Project (SQL, Python, Excel, Django)

• Led a team of 5 to develop live front-end and back-end web interfaces to provide consulting in universities application.

• Collaborated in collecting 1214 available data from 3 different sources for 3 programs and filtered 692 out of 1214 data after data cleansing and processing.

• Directed team members in creating table structure for 692 record Microsoft SQL Server database of college ranking data, developing 4 main business functions, implementing SQL query structure to test each business transactions. NCAA Tournament Outcome Predictive Project (Python, Excel, R)

• Collaborated with team of 3 to build to predict 2018 NCAA Tournament winning teams given a random match-up.

• Preprocessed 4 tables with 236,543 records using Python and identified 22 key predictors as significant features.

• Conducted testing each matchup differently and assigning ranking scores of each team based on the Elo score rating system.

• Collaborated in training sub models such as Naive Bays, linear regression, logistic regression to predict game results- achieved accuracy scores of 83.2%.

Competition Analysis: Business Strategic Decision Support for start-up company(Python)

• Led project design, progress management, business strategic decision and specific tactic selection for start-up restaurants in Las Vegas based on customer respond data from 5,890 restaurants and 1 million customer reviews.

• Collaborated in pair using Python to preprocess data and extracted data from six relational datasets (5.2 GB).

• Applied data visualization and statistical analysis in Python to obtain significant findings across business name, business hour, customer rating, etc.

• Trained multiple statistic models as well as sentiment analysis to obtain significant findings from customer reviews. PROFESSIONAL EXPERIENCE

Accelerant Labs, LLC San Francisco, California (Management Consulting Business) September 2016 - December 2016 Accounting & Data Analyst Intern

• Collaborated in team of 6, in charge of data analysis for project – Alibaba and the Digital Life in 2030.

• Determined 5 key factors out of 200 external driver factors through behavioral data mining as project model assumption.

• Identified 4 possible scenarios out of 10, offered strategic solutions in Robust-Cores & Satellites-Bets model.

• Participated in the establishment of company finance accounting system, including bank account selection, break-even analysis for initial investment and financial risk analysis. WuQiaoYueJuan Textile Limited Co., Ltd Cangzhou, China July 2015 - September 2015 Financial Assistant Intern

• Audited daily production data and warehouse data for workshop planning.

• Managed data input for temporary wage table and quarter cumulative production table.

• Audited workshop daily output data, new storage capacity data and library output data.

• Prepared income statement, balance sheet and cash flow statement on monthly basis.

• Conducted data integration and analysis of internal cost control. LEADERSHIP AND VOLUNTEER EXPERIENCE

Masters Service Learning Club Non-Profit Initiative November 2017- Present Vice President of Events and Innovation

• Organize the VITA (Volunteer Income Tax Assistance) program on University of Maryland site as a site manager as well as a club officer, direct over 88 volunteers to help over 1000 local low-income families in preparing 2018 federal and state tax returns.

• Manage the construction and maintenance of club website on daily basis.

• Build net-work with non-profit organizations in DC area and identify new volunteering opportunities to enrich club events.

Contact this candidate