Data Analyst Python

PROFESSIONAL OVERVIEW

●*-year of experience using predictive modeling, data processing, and data mining algorithms to solve business problems.

●Detail-oriented technical and analytical skills in enterprise and cloud systems, data engineering, BI & data analysis & virtualization.

●Agile project management experience with great communication skills with business & IT stakeholders.

SKILLS

●Business Analysis: gather and document business and system requirement documents and user stories to support application and process development.

●Project management: Agile methodology, KANBAN, Lean.

●Data engineering, analysis & Visualization: Writing complex SQL, developing ETL processes, conducting machine learning and designing report & dashboard.

●Technology & Tools: AWS Cloud, Azure, G Cloud, MySQL, Microsoft SQL Server, Python, R, Tableau, QlikView, KNIME.

WORK & PROJECT EXPERIENCE

Puma store location selection (Sponsored School Project)

Fall 2019 Boston, MA

Data Analyst

●Used Puma-provided real datasets to locate a mall in Midwest for Puma to open a new store.

●Analyzed more than 400,000 records in python to build a predict model based on AAA store features using Random Forest.

●Built an interactive dashboard using Tableau for Puma to filter the best location on the map.

Boston Software Group

Summer 2019 Boston, MA

Market Data Analyst

●Conducted the raw data collection process from LinkedIn and Glassdoor

●Scraped more than 16,000 MA based company profiles using python, including company’s name, website, city, revenue, type, industry, year founded and competitors.

●Stored raw data into MongoDB directly for future using.

●Analyzed data using Tableau, targeted 80 potential companies which related to BSG’s future business.

Viacom Social Demographic (Sponsored School Project)

Spring 2019 Boston, MA

Data Scientist

●Used raw datasets from Facebook which provided by Viacom to find the pattern between demographic and the cost per 1000 impressions (CPM).

●Predicted Facebook’s CPM pricing strategy and helped Viacom to make better decision on pricing their own customer.

●Analyzed more than 200,000 records, built prediction model and predicted 443 pages id’s CPM using demographic features from already known 9 pages id’s CPM.

●Applied predicted CPM to original data to find potential targeting viewers.

●Created the conversion funnel based on the data and provided suggestions to Viacom which page should pay more attention and which contents should push to what kind of targeting viewers.

Southern New Hampshire Health

Spring 2017 Nashua, NH

Informatics Analyst

Led Health Insurance Portability and Accountability Act (HIPAA) privacy and security compliance enhancement project, developed the 1ST internal HIPAA audit checklist with 56 check items for the audit team.

●Identified and escalated the top 2 potential risks in clinical setting to upper management via data visualization tool and provided 3 different solutions.

●Revised and migrated Intranet content from old platform to new platform seamlessly and completed the project 3 weeks ahead of the deadline.

●Conducted weekly training sessions to more than 15 webpage owners using both online GoToMeeting and face-to-face delivery methodology.

EDUCATION & CERTIFICATION

Northeastern University Boston, MA

MPS in Data Analytics (GPA: 3.8/4.0), Dec 2019

University of Massachusetts Lowell Lowell, MA

MS Health Informatics & Management (GPA: 3.8/4.0), May 2017

Northeastern University Boston, MA

MS Leadership (GPA 3.86/4.0), May 2014

Nanjing University of Finance & Economics Nanjing, China

BS Business Administration (GPA: 3.7/4.0), June 2004

Tableau Certified

Desktop specialist February 2020 (https://www.youracclaim.com/badges/beec8843-6612-4954-a38c-827990c0666a/linked_in)

Contact this candidate