Honglin(Holly) Wu

501-***-**** adg5fl@r.postjobfree.com https://www.linkedin.com/in/honglin-holly-wu EDUCATION

Northeastern University - Boston, USA September 2017 - May 2019 Master of Science in Industrial Engineering, GPA: 3.92/4.0 Data Analytics Certificate (Awarded by Northeastern University) Related Courses: Data Mining, Data Management and Database Design, Statistic Methods, Computation and Visualization for Analytics, Operations Research, Economic Decision Making, Project Management. WORK EXPERIENCE

Top Beauty Inc. Walnut, CA, USA Data Analyst August 2020 - Present

• Extracted CRM data to conduct customer segmentation, and generated reports to sales team for mining customer needs.

• Forecasted the product demand in next quarter by using historical data, and conducted what-if analysis to minimize the cost of purchase expense.

Zinvest Financial Service LLC Anaheim, CA, USA Data Analyst September 2019 - August 2020

• Executed A/B testing on email campaign, analyzed the CTR by Python (Numpy), improved advertising efficiency by 9%.

• Loaded and cleaned customer logs data from AWS EC2 to MySQL database. Tracked customer behaviors in the landing page via SQL queries, and provided optimization aspects to enhance user retention rate by 4.1%.

• Grabbed different dimensions of data for market research of new Fintech product business. Wrangled data and provided data- driven recommendations for strategy making.

• Launched visualization reports by Google Analytics and Tableau for traffic monitoring of multiple social media on a weekly basis.

Siemens LTD Beijing, China Data Science Intern April 2018 - September 2018

• Performed ad-hoc analysis using SQL queries and Excel on the metrics of HR data like cost per hire, employee turnover rate to improve recruiting process efficiency.

• Implemented employee data trouble-shooting, specifically with data cleaning and validation. Generated data report to HR by PowerBI to update errored/out-dated employee data. RESEARCHES & PROJECTS

Restaurant Customer Forecasting Dashboard Link January 2019 - April 2019

• Implemented a restaurant customer number prediction model based on Japan restaurants’ history data (3GB) in past 15 months, which guaranteed the restaurant service efficiency. Visualized feature relations by R Shiny as an interactive widget.

• Carried out cross-validation (80% Training, 20% Validation) on ARIMA model to test and evaluate fit-in performance. Real Estate Investment Market Research (Project Manager) September 2018 - December 2018

• Analyzed real estate transaction closing data to optimize investment decision; Reduced data size and processing time by PCA algorithm.

• Predicted future profit of real estate investment with KNN model, calculated AHP for decision making; Increased the profit by 6% for brokers and 4% for customers.

House Rental Information Website Development May 2018 - August 2018

• Developed a house rental information website by crawling data via Python from Airbnb to help acquire lodging information.

• Designed a SQL database to store the rental data and grant different permissions to corresponding users. SKILLS

Coding: SQL, R, Python (Pandas, Numpy, scikit-learn), SPSS, JavaScript, MATLAB Technique: Data Analysis (PCA, Regression, Hadoop), Database Management (MongoDB, Hadoop), Data Visualization (Tableau, R Shiny), Data Reporting (PowerBI), Excel (Formatting, Charting, VBA), Data Modelling, Statistics, Machine Learning (KNN, Kernel Method, Normalization), Economic Decision Making (AHP Factor Analysis), Project Management (CRM, ERP, SalesForce)