Ming Shao
Cliffside Park,US
Overview
12
12
years of professional experience
Work History
Product Analyst
Fiverr.com
11.2017 - 10.2018
- I provided analytical support to the product manager and the engineering team by doing the following
- Wrote SQL queries in bigquery to perform funnel analysis to identify opportunities to reduce friction and improve user experience; results were used to define short-term team initiatives in design and engineering
- Performed 70+ AB test analyses to determine the effectiveness of new features and UX designs
- Convinced the Product manager to further invest in several important features (e.g
- Milestone) instead of eliminate them
- 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 (e.g
- Numpy, pandas, matplotlib) to conduct customer cohort analysis
Business Analytics Analyst
AIG, Auto Insurance
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
International Paper
06.2011 - 12.2013
- Strategic Planning and Business Development
- Conducted multiple business cases; effectively delivered two presentations to the CEO Analyzed the financial impact of having packaging equipment service on overall Packaging business; analysis was critical for a grow or exit decision involving $200MM annual revenue Conducted a research study estimating the impact of iPad on print paper demand; results were widely quoted by Marketing and Sales leaders
- 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
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
Bloomington, INBachelor of Engineering - Electrical Engineering
Tongji University
Skills
- Key Technical Skills:
- SQL, bigquery, Tableau, Python, Excel
Timeline
Product Analyst
Fiverr.com
11.2017 - 10.2018
Business Analytics Analyst
AIG, Auto Insurance
12.2013 - 09.2017
Strategic Planning Analyst
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
Similar Profiles
Plawasha KhanPlawasha Khan
Video Editor at Fiverr.comVideo Editor at Fiverr.com
Adithya NairAdithya Nair
3D Generalist at Fiverr.com3D Generalist at Fiverr.com
James DuahJames Duah
Content Writer at Fiverr.comContent Writer at Fiverr.com
Spark TutorsSpark Tutors
Freelance writer at Fiverr.comFreelance writer at Fiverr.com
Elmira HilajElmira Hilaj
Information Security Senior Analyst at National Commercial BankInformation Security Senior Analyst at National Commercial Bank