Post Job Free
Sign in

Data Analyst

Location:
Brooklyn, NY
Posted:
July 20, 2020

Contact this candidate

Resume:

************@*****.***

1-614-***-****

I have extensive experiences working with multiple Fortune 500 companies in marketing analytics, predictive modeling, ROI analysis, and data-driven strategies design to drive performance. I am looking for Data Scientist, Data Engineer or Data Analytics related experienced roles. Languages: 3-years coding experiences in SQL and Python (Pandas, Scikit-Learn Packages) Data Science:

Statistical Techniques – ANOVA, Time Series, Forecasting, A/B Test, Hypothesis Test, Optimization Machine Learning – Regression, Classification, Clustering, Decision Tree, SVM, NLP Big Data – Spark, Hive, TensorFlow

Data Visualization – Tableau, Looker

Others: Advanced Excel, PowerPoint

EDUCATION

Fordham University, New York 2017 – 2018 Dec

M.S in Data Analytics – GPA 3.65

University of North Carolina, Chapel Hill 2013 – 2016 B.S. in Mathematical Decision Science - Statistics PROFESSIONAL EXPERIENCES

Ipsos MMA – New York, NY

Senior Data Analyst – Delivery Team May 2019 – May 2020

§ Marketing Analytics – Industries Engaged: CPG/Durable Goods/Retail o Build and maintain ETL process on cross-channel media and financials datasets o Define, evaluate and monitor Metrics to measure performance and marketing results o Lead outsourced data engineering team on monitor anomalies and validate data quality, communicating analysis results with cross-functional teams o Build multi-variate regression models to explore correlations, contributions, effectiveness of marketing campaigns, tune model for better performance o Execute marketing ROI and MROI optimization scenarios for revenue forecasting, drive 15%-25% revenue growth with minimal marketing spends

o Build interactive dashboard/data visualizations with Tableau/PowerPoint and present Findings with clear recommendations to non-technical clients and stakeholders o Work on 3-4 projects simultaneously, maintaining high efficiency and meeting all deadlines

§ Data Transformation Automated System Design – A leading Coffee Machine Manufacturer o Lead and design an automation system using SQL to create/manage Snowflake databases, write Python codes to transform raw data into easy-to-use datasets using statistical methods

(moving average, de-seasonalize, decay, laggings and etc) for modeling feeds o Responsible for end-to-end system improvement and implementation, which increased work efficiency by 250%

o Helped build machine learning models to forecast product penetration rate in target markets

§ Menu Price Optimization – NC Based Restaurant Chain o Leverage TB - level transactions, promotions and marketing spend data, use Python to perform statistical analysis, identify patterns/colorations between promotions and sale performance o Develop price-mix-models to test menu price optimization hypothesis o Build clustering models – KNN to cluster stores from national level to different key clusters to improve operations efficiency

Elaine Li

PROFILE AND SKILLS

************@*****.***

1-614-***-****

CollectorIQ – New York, NY May 2018 – Jan 2019

Data Scientist

§ Develop machine learning models to predict liquidity level and price of art collectibles, providing insights for art investors

§ Implement NLP (NLTK/Sandford Core NLP package) to analyze importance level of text features

§ Conduct sentimental analysis to improve overall model performance

§ Deliver bespoke presentations to non-tech-background senior management regularly on using data science to provide opportunities for company development. PROJECTS

University Endowment Use-Case Analysis with Selective Learning Oct – Dec 2018

§ Crawled Twitter followers of Universities with Python Twitter API

§ Built Random Forest, SVM, Gradient Boosting, Deep Neutral Network classification applications to analyze whether universities poorly use endowments fund using various measures

(MAPE, R-square)

§ Applied selective learning to improve classifiers’ performance. Divvy Shard Bike Big Data Analysis with Spark March – May 2018

§ Built Spark and Spark SQL-based models to analyze time-series Divvy sharing bike usage data

§ Implemented machine learning models to predict future bike usage given weather forecast info

§ Visualized results on Chicago map using Tableau

§ Made recommendations for China Ofo shard bike company on Chicago market entry strategy. Readmission Rate Prediction of diabetic inpatients with Machine Learning March – April 2018

§ Built machine learning models (SVM, Decision Tree, Neutral Network) with TensorFlow on hospital readmission rate forecasting.



Contact this candidate