Sign in

R Python SQL Linux Matlab Minitab Sas SQL Tableau Excel Powerpoint Wor

Miami, FL
March 05, 2018

Contact this candidate


Yaqing Guo


Master of Business Analytics with Product Sales and Investment Consultant Experience


University of Miami Business School

Coral Gables, Florida

Master of Science in Business Analytics

May 2018

GPA: 3.50

Scholarships Recipient

Shandong University

Shandong, China

Bachelor of Economics

June 2017

GPA: 84.7/100

Focus Area: Finance, Marketing


Data Mining • Data Visualization • Forecasting • Modeling • Revenue Strategy • Risk Assessment • Leadership • Teamwork

Process Improvement • Design of Experiments • Six Sigma Management



Florida Panthers (Capstone Project)

Miami, Florida, United States

Florida Panthers are a professional ice hockey team based in the Miami metropolitan area.

February 2018 to Present

Use data from email and digital marketing to predict which kinds of emails and advertisements are popular

Analyze data, identify specific models and summarize findings and significance


Miami, Florida, United States

Online retailer of pet food and other pet-related products.

February 2018

Rectified the unbalanced data, built several models and used the best model to predict whether an item needs to be restocked

Increased sensitivity accuracy from 17% to 64%

Professional Experience

XS Furniture Co. Ltd

Hebei, China

Specializes in manufacturing and exporting metal glass furniture Australia, Canada, New Zeeland.

February 2017 to April 2017

Sales Representative Intern

Research inventory, conduct customer outreach to sell furniture and provide work progress report to management.

Refined the lead generation process and established business relationship with new client companies by collecting and analyzing data from manufacturing fairs

Created $350,000 revenue by customizing product recommendations to clients

Led and trained new interns on how to manage client business relationships by teaching them how to handle order fulfillments

Gained job offer after accomplishing internship

China Construction Bank

Shanxi, China

One of the "big four" banks in the People's Republic of China.

October 2016 to January 2017

Financial Management Department Intern

Conduct customer research, recommend and sell proper investment products to customers and report work to customer manager.

Narrowed potential customer base by using R and locating potential female purchasers between forty to sixty years old

Created over $27,000 revenue in two months by leading other interns to work as a team, selling products to preselected customers and offering suitable financial products based on their account analysis

Boosted work productivity by training other interns on R in late period of internship


Languages: English (fluent) Chinese (native)

Computer Skills: R Python SQL Linux MATLAB Minitab SAS SQL Tableau Excel PowerPoint Word

Activities: Head of Student Academic Department in Business School and Vice President of International Business and Trade Club at Shandong University

Contact this candidate