Data Analyst Marketing

Danlu Pan

**********@*****.*** • +1-929-***-**** 215 W 101 St • New York • NY 10025

Data Analyst

Detail-oriented and self-motivated data analyst with rich knowledge of big data manipulation, analytics and visualization; statistical modeling, machine learning and programming. Experienced in business intelligence, data-driven marketing and corporate growth. Strong interest and curiosity in tech industry. Skills

Advanced Data Mining (SQL) • Machine Learning • Data Visualization(Tableau, D3) Programming(R, Python)• Regression Analysis • A/B Testing • Experimental Design Business Intelligence(BI)• Digital Marketing • UX Design(prototyping) Work Experience

May - Aug. Data Analyst at YIMISHIJI Shanghai, China 2017 (e-commerce version of Wholefoods)

• Analyze and visualize trading data to create dashboards of key metrics using MySQL and Tableau

• Build customer portfolios on customer behavior, demographics and lifecycle in CRM system

• Evaluate marketing events multi-dimensionally to provide creative insights for future marketing

• Build an initial personalized recommender system employing regularized SVD model in Python to give effective recommendation solutions and improve sales Summer Intern at Citi Bank Hangzhou, China

2015 Associate Leader, Young Talent Program

• Propose an information classification platform, Icollege App for freshmen in college

• Design data collection process and give overall control of a 9-member group Projects

Sep. 2017 Colgate digital skin health tracking New York, USA

• Develop project plans and design instructions for data collection through Youcam App

• collect, cleanse and manipulate unstructured beauty app data by conducting statistical analysis through R language, employ R and Tableau to visualize analytical findings

• Provide feasibility reports for Colgate Marketing team to help decision-making process Sep. 2017 Education monitoring project in Ethiopia New York, USA

• Collaborate with CIESIN(The Earth Institute of CU), research on potential educational monitors

• Clean, manipulate and interpret big datasets and build visualization dashboards in R Mar. 2017 Machine learning in spam email classification New York, USA

• Use SVM, AdaLine and logistic regression in R to build binary classifiers to reach over 95% accuracy Education

Jan. 2018 MS in Applied Analytics (Gpa: 3.8/4.0)

(expected) Columbia University New York, USA

Sep. 2012- BS in Mathematics and Applied Mathematics June 2016 Hangzhou Dianzi University Hangzhou, China Honors

Apr. 2015 Honorable Mention of Mathematical and Interdisciplinary Contest in Modeling in USA Languages and Computer Skills

Languages Chinese (native), English (professional working proficiency) Skills R, mysql, Tableau, Excel, Linux, Google Analytics, SAS, Python, Html, Latex

Contact this candidate