Data Analyst

ASHLEY MENG

RELOCATABLE 206-***-**** adhwir@r.postjobfree.com

EDUCATION

Northeastern University, Seattle, WA April 2021

Master’s Degree in Analytics GPA: 3.96 /4.00

Fudan University, Shanghai, China July 2015

Bachelor’s Degree in Philosophy GPA: 3.40 /4.00

WORK EXPERIENCE

Meituan, Beijing, China June 2020 – September 2020 Data Analyst (HR) Summer Intern

• Accurately measured employee satisfaction by building clustering and predication models with 100k survey data with scikit-learn.

• Increased business reporting efficiency 90% by implementing Python automation while conducting monthly reports for the employee- feedback survey program.

• Designed function of comparatives for the employee insight report system and partnered with the engineer team to conduct User Acceptance Testing for the system.

• Supported data-driven decision making for the recruit, grow and retain talent process by utilizing evaluation and analysis skills. Agricultural Bank of China, Beijing, China February 2020 – April 2020 Data Analyst Intern

• Improved model performance 30% compared to currently utilized linear regression model by performing feature engineering and building a new prediction model for China’s GDP with LightGBM.

• Avoided issuance of risky loans by evaluating credit ratings for target companies based on key financial ratios with Excel VBA. Tencent, Shenzhen, China July 2017 – May 2019

Recruiting Manager Specializing in Analytics & Project Management

• Reduced average resume retrieval process time from 1 hour to 3 minutes by developing a new system using SQL and Excel VBA.

• Designed and implemented ETL pipeline for resume processing that increased the efficiency of finding resumes submitted to the company based on a wide variety of search terms.

• Grew company’s official WeChat account by 10,000 in one year by identifying target audience preferences and catering content providing instructions and tips for interviewing with the company.

• Generated weekly reports for the recruiting and HR core teams detailing recruiting resource operations by analyzing data.

• Acted as Project Manager of the overseas recruiting project at the Game Development Conference in 2018 and 2019 as well as the WeChat Mini Program for upcoming graduate employees. PROJECTS

Pharmacy Claims Database Warehousing MySQL June 2020 – July 2020

• Designed the database structure and developed entity relationship diagrams (ERD) for the pharmacy claims.

• Performed analysis on the insurance payments dataset with complex SQL queries including complex joins, grouping, aggregation, nested subqueries and window functions.

Market Research and Strategic Plan for Ryffine (a technical content consulting startup) Excel April 2020 – June 2020

• Conducted Market Research on the technical content consulting industry including market size estimation, competitor and customer analysis and market outlook analysis.

• Estimated Ryffine’s market share based on their financial statement and current business situation and provided a SWOT analysis matrix for future business development.

Sales Performance Analysis of Costco Electronic Products Tableau March 2020 – April 2020

• Designed and developed reports and dashboards based on sales data of Costco Electronic Products using Tableau Desktop for sales volume and revenue analysis by region, date and brands.

• Provided suggestions for sales strategies based on analysis findings including brand focus for different customer groups as well as seasonal event planning.

YouTube Video Transcoding Time Prediction R December 2019 – January 2020

• Performed feature engineering, built prediction models by using regularized linear regression and neural network for YouTube video transcoding time with 70k records and achieved 0.18 MAPE on test data when using a neural network model.

• Built a logistic regression model using K-means clustering to label the data and achieved a 0.04 error rate on the test data. SKILLS

R SQL Python Advanced Excel – VBA Tableau

Contact this candidate