Pricing, Machine Learning, Digital Marketing.

Zhehong (Philip) Liu 706-***-****• *******.***@*****.*********.*** • linkedin.com/in/zhehongliu

Analytics and Pricing Qualifications

Specific skills required to perform statistical and technical analysis, use data visualization tools to generate business insights and communicate them with stakeholders in organization.

Capacities to excel in business analyst roles using analytics expertise, knowledge of data analytics, statistical modeling as well as B2B and B2C pricing, evidenced by analytics internships and project achievements.

Proficient in R, Tableau, SQL Server, MySQL, Teradata, Google Analytics, SPSS, Python, JAVA, Microsoft Office. Education

University of Rochester, Simon Business School Rochester, NY Master of Science in Marketing Analytics (STEM-Certified) Anticipated Jun 2016

An intensive business analytics and data science training program focusing on statistics, programming and analytics.

Applies analytics-based approach to solve business problems, leveraging power of big data analytics to build and use models to analyze, visualize and communicate business insights.

Concentration in pricing and revenue management

Merit Scholarship Recipient

The University of Georgia, Terry College of Business Athens, GA Bachelor of Business Administration: Marketing May 2015

A fundamental business administration training program emphasizing in internal and external business communications

Specialized in market research and digital marketing

Co-founder of an internet start-up, Floop.us, which address the problem of over usage of study rooms in Miller Learning Center, the University of Georgia

Analytics Experience

Excellus BlueCross BlueShield Rochester, NY

Business Analyst Jan 2015 - Present

Created a price sensitivity tolerance model to predict customers’ leave or stay for the largest regional insurance company

Used SQL Server and Excel to proficiently manage large internal data sets for detailed analysis

Used R to build and test various models (regression, logit, clustering and classification) by analyzing internal data

Designed a conjoint survey to quantify clients' trade-offs between competing insurance policies and generate business insights to optimize pricing strategy

The Outdoor Group Rochester, NY

Operations Consultant Oct 2015 - Dec 2013

Designed data collection format of company daily operations for analytics applied to Tableau

Analyzed KPIs with drawing process flow and created Tableau Template for further use

Recommended interim data collection system before new ERP system delivered Analytics Projects

Duke University Capstone Project Mar 2015

Formulated data questions, analyzed and visualized large datasets and provided strategic decisions to maximize profit to a real estate company, Watershed Property Management

Used MySQL to extract and create new datasets from a real estate database

Implemented profit maximizing and risk managing analysis in Excel

Created a Tableau dashboard to report sensitivity analysis at the executive level

Articulated business process change for operations and management Early Rider Conjoint Analysis Feb 2015

Utilized segmentation and simulation test market to optimize pricing strategy of a toy horse business using R

Cleaned and reorganized conjoint survey data

Combined Priori and Post Hoc Segmentation to compare features of toy horses and various combinations of

products to provide the best enter-market strategy

Recommended profit maximization strategy based on first choice rule in a simulated test market

Contact this candidate