Ming Shao
Cliffside Park,USA
Overview
12
12
years of professional experience
Work History
Product Analyst
Fiverr.com
New York, NY
11.2017 - 10.2018
- Provided analytical support to the product manager and the engineering team by writing SQL queries in bigquery to perform funnel analysis to identify opportunities to reduce friction and improve user experience; performed 70+ AB test analyses; convinced the Product manager to further invest in several important features; developed recurring KPI reports to track user happiness, conversion, retention, cancellation by user segments and category using SQL in bigquery and Tableau; used bigquery and Python to conduct customer cohort analysis.
Business Analytics Analyst, Auto Insurance
AIG
New York, NY
12.2013 - 09.2017
- Wrote SQL queries to research and analyze KPIs such as conversion, retention, and loss ratio to evaluate business performance by customer type, geography, and claim history; developed and automated monthly auto insurance business intelligence reports in Tableau; performed ad-hoc and ongoing analysis to support product managers and actuarial team by writing SQL queries, identified trends and recommended corrective actions; conducted broker footprint analysis to explore opportunities to increase quotes; built an Excel VBA tool to generate broker list by zip code and radius for distribution team to target potential brokers.
Strategic Planning Analyst, Strategic Planning and Business Development
International Paper
Cincinnati, OH
06.2011 - 12.2013
- Conducted multiple business cases; effectively delivered two presentations to the CEO; analyzed the financial impact of having packaging equipment service on overall Packaging business; conducted a research study estimating the impact of iPad on print paper demand; performed contribution margin analysis by business segment and by customer, identifying patterns and opportunity to improve profits; supported the business planning process of a $2B product segment by performing analysis and developing strategic insights; developed and maintained monthly business intelligence report for Packaging business segment.
Senior Analyst
BASES, The Nielsen Company
Shanghai, China
06.2006 - 03.2009
- Managed seven sales forecasting projects for a major consumer goods company; performed sales forecasting for new initiatives in China and Thailand using analytical model; evaluated the market potential and concept weakness by performing market research and product specific positioning; made recommendations to the client to optimize the marketing plan.
Education
Master of Business Administration -
Kelley School of Business, Indiana University
05.2011
Bachelor of Engineering, Electrical Engineering -
Tongji University
06.2006
Skills
- SQL
- Bigquery
- Tableau
- Python
- Excel
Permanent Resident
True
Timeline
Product Analyst
Fiverr.com
11.2017 - 10.2018
Business Analytics Analyst, Auto Insurance
AIG
12.2013 - 09.2017
Strategic Planning Analyst, Strategic Planning and Business Development
International Paper
06.2011 - 12.2013
Senior Analyst
BASES, The Nielsen Company
06.2006 - 03.2009
Master of Business Administration -
Kelley School of Business, Indiana University
Bachelor of Engineering, Electrical Engineering -
Tongji University