LIYANG LIU

*** ********* **. *********, ** ***** abz95d@r.postjobfree.com

773-***-****

www.linkedin.com/in/liyangfutureawesomeanalyst/

EDUCATION

KELLSTADT GRADUATE SCHOOL OF BUSINESS DEPAUL University Chicago, IL Sep. 2011

June.2013

Master of Science in Marketing Research and Analysis GPA 3.467

Key Classes: Category Management Analytical Tools for Marketers Web Data Mining/Business Intelligence

Sales Strategy CRM Advanced Marketing Research Scripting for Data Analysis Consumer Behavior

SCHOOL OF BUSINESS Beijing Technology and Business University Beijing, China 2007 2011

Bachelor of International Busness GPA 3.51

Key Classes: Fundamentals of Database Application Statistics Multivariate Analysis Commodity Studies

Finance Practice on Enterprise Resource Planning

Scholarship: Educational Scholarship Winner in 2008, 2009, 2010 and 2011(Top 5% )

EXPERIENCE

ParkWhiz.com Chicago, IL Apr.2013 May.2013

Customer Experience Analyst Intern

Developed an automatically pricing rate calculator to refine pricing strategy/Devised procedures for gathering

data

Scripted with html language and JQuery AJAX function to return JSONP type data from API and MySQL

Logically classified and identified a unified parking time period suite as parameters to test diversified pricing

structures of location sellers in the most efficient way/ Transformed returned data into Excel spreadsheet

Critically analyzed the differences in pricing strategies between ParkWhiz.com and location sellers to check

discount rate and prices needed to be fixed

SIEMENS LIMITED Beijing, China Jun.2012-Aug.2012

Transfer Pricing Analyst I n te rn

Performed Comparable Search Analyses consisted of identifying comparable companies in the an alytical

information database OSIRIS(criteria i.e. geography, SIC code, financial data) / Manual refined the initial list

of companies through the review of the information co ntained in the source documents / V alidated potential

comparable companies through additional research (i.e., through company website or annual reports)

Summarized financial analysis items (i.e. cost of goods, EBIT, net cost plus etc) and performed graphic

design

BEIJING LIXIANG TELECOMMUNICATION SCIENCE CO.,LTD Beijing, China Nov.2010-

Aug.2011

Marketing Analyst Intern Marketing Promotion Assessment Project

Raw research data preprocessing,, modeling and reporting ( SPSS Base SAS, Macros, Graph, Proc SQL,

Statistics)

Conducted promotion project assessment and profitability prediction with logistic regression model

Developed Statistical report and non technical summary/Tested and refined linear regression model

ACADEMIC PROJECTS

Yoplait Light Advertisement Campaigns Analysis Project Jan.2013 Mar.2013

Provided recommendations to improve the effectiveness of Yoplait ads and conducted market segmentation in

statistical method in SPSS.

Enriched our respondents’ profile with detailed, accurate demographic attributes

Grouped 1690 respondents into three sub groups based on levels of favorability towards Yoplait ads by applying

Ward cluster method and cross validation/Select two sub groups as market segment for further analysis

Divided the ads storyline into four components by adopting multiple discrimination analysis to identify over all

ad impact of each second

Created potential buyers’ profile of target segment and pinpointed key characteristics that influence purchasing

with correspondence plot and regression model

United Airlines Comprehensive Marketing Analysis and Strategic Planning Apr.2012 Jun.2012

Framed United Airlines by encompassing all and clarified the static industry position it currently in

Conducted primary research by leveraging digital tools to develop original questionnaires/Collected data

Determined United Airlines position vis à vis existing major competitors’ positions by utilizing perceptual

mapping and factor analysis to provide recommendations for gaining more market share in the competitive market

by repositioning

Provided the insights of consumer preference via conjoint analysis seeking to adjust pricing strategy and to

understand the structure of consumer value systems by breaking down overall consumer judgment of an offering

Optimized feature set to create new market space and to drive higher profit with SWOT analysis, competitive

benchmarking and value curve study.

ASSETS

TECHNICAL SKILLS

•

SAS/SQL/MySQL/html tag/Access/VBA/VB/SPSS/Google Analytics/Microsoft Office/Excel/ Outlook

/Access/Salesforce.com/Pivot Table /Weka.Java/R language

ANALYTICAL SKILLS

Multiple regression/ Polynomial regression/Categorical Data Analysis/ Logistic regression/ Cluster Analysis/

Factor Analysis/ AVONA/ Conjoint Analysis/ Perceptual mapping/ Value curve/ Dynamic

Positioning/ERP/CRM/Competitive Analysis

Contact this candidate