Post Job Free

Resume

Sign in

Business Analyst

Location:
New York City, NY
Posted:
February 11, 2019

Contact this candidate

Resume:

YAO YAO

E: ac8gaf@r.postjobfree.com ● M: 301-***-**** ● New York, NY

EDUCATION

ST. JOHN’S UNIVERSITY, PETER J. TOBIN COLLEGE OF BUSINESS Queens, NY Master of Business Administration - Business Analytics, GPA 3.6 May 2019 Relative Courses: Predictive Analytics and Business Forecast; Prescriptive Analytics and Spreadsheet Modelling; Database Management UNIVERSITY OF MARYLAND, COLLEGE OF BEHAVIORAL & SOCIAL SCIENCES College Park, MD Bachelor of Arts - Economics May 2017

SELECTIVE PROJECTS EXPERIENCE

MySQL Relational Database Design January 2019

2 Collected information of six groups of five students in the Database Management course and utilized MySQL to design a simple database for student groups

2 First, created a table named STJOHNS

o Identified Student ID as a primary key; Set student’s name and major as other two attributes in data type of varchar with the maximum length of 20 characters; Input the final attribute – group number for each student 2 Created a second table named GROUP

o Identified group number as a primary key of the GROUP table; Input Project’s name and meeting frequency as two attributes in this table; Finally, set Leader ID as a foreign key, which referenced Student ID in the STJOHNS table

Generalized Additive Modeling - Activion Blizzard, Inc. Stock Price April 2018 2 Ran GAM regression and residual analysis in R with 80 observations and 4 variables: BVPS, CFPS, EPS and ROA 2 Completed a sequence chart of actual and predicted price and successfully reached a result with 96.54% explanatory power Predictive Analysis - IBM Corporation Stock Price December 2017 2 Utilized FactSet database and ran linear regression and residual analysis in R to test functional specification 2 Identified return on assets (ROA) and earnings per share (EPS) as strongest variables Cross Tabulation Analysis - Consumer Behavior November 2017 2 Randomly chose 100 students at St. John’s University, and conducted a survey on their preferences between McDonald’s and Burger King

2 Utilized SPSS and formed cross tabulations to analyze the relevant factors that affected students’ preferences 2 Reached a result that selected students’ gender and country significantly affected their choices between McDonald’s and Burger King

TECHNICAL AND LANGUAGE SKILLS

Computer Skills: R, SPSS, MySQL, MS Access, EXCEL Solver/Pivot Table/Decision Tools, Tableau Language Skills: English, Mandarin, Cantonese

WORK EXPERIENCE

Pfizer Inc. Beijing, CHINA

Business Analytics & Insights Internship June 2018 - August 2018 2 Captured data by using IMS database and government data platforms; updated analyses using the most recent data to update more accurate reports

2 Participated in Eliquis Price Adjusting Strategy Optimum Project in China area; analyzed the number of prescription, sales and sales volume of Eliquis and other competitors, and market share of related molecules used in cooperative hospitals 2 Worked with a team in 2018 NRDL Impact Analysis; Managed the updating data and analyzing YOY, growth rate and lift of certain years of a product Norvasc

Golden Eagle Asset Management Co., Ltd Guangzhou, CHINA Equity Research Internship June 2017 - August 2017 2 Utilized Microsoft SPSS and WIND software to track and analyze pet industry related data 2 Successfully interpreted data and draw conclusions in a final report on the outlook of the pet industry in China 2 Analyzed listed pet companies and looking for potential companies that are good for investment 2 Researched and updated required materials needed for partners 2 Assorted notes taken from securities company's road show



Contact this candidate