Data Analyst

Meiling Zeng

Boston, MA 860-***-**** *********@*****.*** linkedin.com/in/meiling-zeng

EDUCATION

NORTHEASTERN UNIVERSITY Boston, MA

Master of Science, Business Analytics Expected Dec 2022

Relevant Coursework: Data Analysis; Business Analysis; Machine Learning; Data Visual/Dashboard

QUANZHOU NORMAL UNIVERSITY Quanzhou, China

Bachelor of Public Administration Sept 2015 – Jun 2019

WORK EXPERIENCE

HANGZHOU KAIKELA EDUCATION TECHNOLOGY Hangzhou, China

Data Analyst Mar 2020 – Aug 2021

●Aggregated unstructured data from 10+ sources using Python and SQL to build out the data and reporting infrastructure of a new product; led to 50000+ users’ growth and $1,000,000 in new revenue.

●Analyzed data from 10000+ monthly active users and built user and product portrait to increase user stickiness towards product; increased average user engagement time by 2x and user retention rate by 20%.

●Built Tableau dashboard to visualize core business KPIs (e.g., Monthly Product Revenue) to provide real-time insights into users and products, improving product renewal efficiency by 30%.

●Built logistic regression and clustering models to help the SEO team to optimize recommendation algorithm system and identify potential customers from free trail users; lift the unpaid user conversion rate by 15%.

●Collaborated with production operations, IT and sales departments to maintain manuals and SOPs.

NEW ORIENTAL EDUCATION & TECHNOLOGY GROUP (NYSE: EDU) Hangzhou, China

Product Operation Analyst June 2019 – Feb 2020

●Collaborated on product line review for all products, analyzing total sales, gross margin and customer activity; Associated with writing product and marketing analysis report.

●Designed, executed, and optimized digital and off-line marketing campaign to increase product visibility and market performance; led to 10% increase in ROI.

●Improved existing course product offerings and designed new course products; Improved product optimization rate by 30%.

WENZHOU UJOY INTERTIONAL TRADE INC. Wenzhou, China

Foreign Trade E-Commerce Specialist Internship June 2018 – Sept 2018

●Operated foreign trade e-commerce business in mainstream online platforms; Maintained and updated products online.

●Delt with enquiries and shipments; Executed and tracked the orders; Explored new customers overseas.

●Analyzed online sales data; Designed and implemented promotional activities; Successfully boosted sales rate by 20%.

UNIVERSITY PROJECTS

DONALDSON NLP SENTIMENT ANALYSIS CAPSTONE, Project Manager Sept 2022 - Nov 2022

●Worked as a project manager to successfully predict the trend of powertrain technology in heavy equipment industry.

●Designed and implemented the schema of data collection, data cleaning, and sentiment analysis by Python and Google API; Extracted more than 100,000 comments by 10+ keywords related with 150+ companies; Generated sentiment scores for each comment; Utilized Tableau, R and Excel to create data visualization dashboard.

●Successfully predicted the market of new energy powertrains; Improved the prediction accuracy by 75%.

OGRANIC FARM CUSTOMER CHURN PREDICTION, Project Manager Jan 2022 - May 2022

●Built logistic regression, KNN and clustering models in Python environment to identify the feature distribution of customer groups and predict the leave or stay of customers next year; gained the prediction accuracy as 96%.

●Identified 2 clusters as the most valuable customers to maintain; improve the marketing efficiency by 30%.

ADDITIONAL

Technical Skills: R, Python, MySQL, Advanced Excel, SAS, Java, Tableau, Power BI, Alteryx Designer, UiPath, Google Analytics, Web Scraping, Natural Language Process, Sentiment Analysis, Time Series Forecasting, Predicting Models.

Certifications & Training: Basic and Advanced Google Analytics; Online Course in Python (Coursera).

Contact this candidate