About Me
Sheenfy Wang
Main Job: Data Analyst
Birth: 1995/01/15
Location : Shanghai, China
Height: 183cm
Email: sheenfywang@gmail.com
MBTI: INTJ
1.Employment
1.1 Previous Work Experience
Shanghai Solar Investment Advisor Co.,Ltd.
Data Analyst
Shanghai, China
Sep 2021 – Now
Overview:
•My main responsibility is to optimize the sales process ,provide advice on sales management and offer data-backed opinions on the company’s products.
•The company makes a profit by selling subscription-based investment advisory products.
•Our sales are all over mainland china, and Sichuan is the highest sales place.
•Payment and refund rates are our most critical metrics.
Main Contribution:
- Increased highest monthly sales by 109% and average monthly sales by 24%.
- Established a complete indicator system has been to enable each business unit to measure its own business level.
- Developed word frequency analysis of refund customers, optimized the functionality of the product, and reduced the refund rate by 11% in the current month.
Job Duty
- Data analysis and report
Daily / monthly / dual monthly / quarterly / yearly data analysis & report
Thematic analysis report
Campaign analysis & report
- Data Support
Build a company data analysis system and discover key data indicators
Provide the data support that the business unit needs
Measure the effect of business unit action
- Data Modeling & Predict
Regression and classification prediction are carried out through machine learning algorithms
A/B testing by by T-test and Chi-square test
- Data analysis and report
Shanghai Beirui Information Technology Co.,Ltd.
Data Analysis (Overseas)
Shanghai, China
Dec 2019 – July 2021
Overview:
•Responsible for providing data support and strategy for AweSun, a remote control software, to gain user growth worldwide
•The software supports multiple platforms : Windows/ Mac OS/ iOS/ Android .
•The main markets for our software : United States / South Korea / India / Vietnam / China Taiwan.
•We promoted our products through various media: SEO / SEM / Influencer / Blogger / WOM ,etc.
•The key metrics of our performance is ‘Online‘ and ‘Remote control times‘(One Metric that matters)
Main Contribution:
- Online from 15K to 157K,an increase of 947%
- OMTM (One Metric That Matter) from 7K to 40K , an increase of 471%
- Cooperated with 47 Youtubers to produce 72 videos and gained 97M views worldwide
Job Duty
- Data analysis and report
Daily / monthly / dual monthly / quarterly / yearly data analysis & report
Media mentions analysis & report
Campaign analysis & report
- SEM
Google Ads (Display & Search Ads)
Facebook Ads (App ads)
Adjust and optimize ads through A/B testing
- Market survey
Analyze our intended market through a data-driven approach
- Data analysis and report
1.2 Other Work Experience
Shanghai Nantang Industry Ltd.
Overseas e-commerce operation specialist
Shanghai Qianen Education Co.,Ltd.
New media editor
Shanghai, China
Jan 2019 – Dec 2019
Shanghai, China
June 2018 – Dec 2018
2.Education
Shanghai Beirui Information Technology Co.,Ltd.
Overseas Marketing Executive
Shanghai, China
Dec 2019 – July 2021
Shanghai Institute of Technology
Bachelor of Economics and Management
University of Oulu
Exchange Program (Business Entrepreneurship)
Shanghai Changdao Middle School
High School (As a sports specialty)
Shanghai, China
June 2018
Oulu, Finland
2017 – 2018
Shanghai, China
June 2015
3.Skills
3.1 Data Analysis
Tool:
- SQL
- Python(Numpy, Pandas, Matplotlib, Seaborn , Sklearn)
- Tableau
- Google Analytics (Website Data)
- AppsFlyer (App Data)
- Excel
Reference:
3.2 Extra Business Skills
- SEM(Adwords/Facebook)
- SEO
- Market Research
- WBS(Work Structure Breakdown)
Gantt chart
Flow chart
3.3 Photography
Tool:
- Photoshop
- Illustrator
3.4 Graphic Design
Tool:
- Photoshop
- Illustrator