DAN SHAO (Charmain)

240-***-**** ● adchkw@r.postjobfree.com ● https://www.linkedin.com/in/dan-shao-9a2522161/ Data Analyst

EDUCATION

University of Maryland, Robert H. Smith School of Business College Park, MD Master of Science in Business Analytics, GPA 3.8/4.0 (TOP 10%) August 2018—December 2019

• Courses: Data Mining & Predictive Analytics (R), Data Processing and Analysis in Python, Big Data (NoSQL) and AI (Deep Learning) for Business, Database Management Systems, Google Analytics (Google Ads), Decision & Operation Analytics (Advanced Excel) Macao Polytechnic Institute, School of Business, Macao, China Bachelor of Business Administration, Marketing, GPA 3.7/4.0 (TOP 1%, Scholarships for 4 years) August 2014—June 2018

• Courses: Business Statistics, Marketing Forecasting, Business Research Methods, Advertising and Promotion

• “Silver Award” of China College Students’ Entrepreneurship Competition in 2016 (Leader/CEO) – National-Level Award

• “Merit Award” of University Students Statistical Project in 2016 held by Macao DSEC (Leader) – Provincial-Level Award TECHNICAL SKILLS

• Tools: Python, SQL, R, Tableau, SPSS, PowerPoint, Google Analytics, Excel (Solver and @Risk), Hadoop, Spark, Hive, Pig

• Skills and Knowledge: Data Mining, Data Visualization, DBMS, Machine Learning, A/B Test, Digital Marketing

WORK EXPERIENCE

University of Maryland—Robert H. Smith Business School College Park, MD Teaching Assistant for Courses of Python & Google Analytics Jan 2020—Present

• Assisting professor in administrative duties necessary, advising/holding office hours or tutoring students as needed. Cinovoo New York, NY

Data Analyst Intern June 2019—August 2019

• Maintained terabyte-level user databases for ad-hoc projects, prepared 500+ SQL queries in both MySQL and SQL Server, proper data visualizations in Tableau and Python, increased overall efficiency by about 20%

• Conducted data mining to identify user patterns via Time Series Analysis for customer clustering and segmentation

• Validated data for problem identification and significance across 5+ data sources such as Google Analytics; initiating data mining, modeling, testing and reporting; demonstrated results in effective display for intended clients with less tech knowledge BlueFocus Communication Group Co. Ltd. (Ranked 9 in 2018 Global PR Agency) Beijing, China Digital Marketing Intern June 2017—August 2017

• Summarized and visualized target customer insights via PowerPoint and Excel in a cross-functional team; brainstormed and delivered 10+ digital marketing strategies and 5+ data analysis reports to multi-level audience

• Individually developed and designed an advertising plan for “Zhuan Zhuan”, a Chinese e-commerce secondary market platform, and presented to a group of 10+ executives and representatives of clients PROJECT EXPERIENCE

Python, Data Processing, EDA, Modeling: Data Analysis & NLP for Rating and User Review of Apps in Google App Store

• Performed proper cleaning, processing, transforming and visualization on dataset from Kaggle, using packages such as numpy, pandas, matplotlib, seaborn, NLTK, scikit-learn; EDA and data modeling mainly on rating, pricing and reviews of apps

• Addressed business issues and gave constructive suggestions for both app developers and Google App Store Pricing Analytics, Machine Learning: Modeling on Property Listing Price and Time to Sell for Roofstock

• Developed model communicating the relationship between the choice of a listing price for a particular property and how quickly a matching offer is likely to come in, helped Roofstock achieve better user experience and higher retention rate

• Modeling machine learning methods: linear regression, random forest, PCA, etc.; final prediction accuracy is 84% R, Data Cleaning, Data Processing, Modeling: Predict Return Rate of Patients in a Hospital within 30 days

• Utilized such model and methods as logistic regression, classification tree, K-mean, KNN, PCA, random forest, and boosting to predict target variable in a detailed-oriented manner; final accuracy was higher than base line, reaching 79% Machine Leaning, Deep Learning, Kaggle Competition: Click Fraud Prediction & Understand Patterns of Blacklisted Users

• Preprocessed highly imbalanced data, EDA and Feature Engineering before modeling under Keras and TensorFlow in Python

• Implemented machine learning and neuron network methods, and repeated parameter debugging and tuning of these models was worked out; final AUROC is ranked in top 30% of all engaged kagglers Google Analytics, Google AdWords, Google Ads, Client Management: Google AdWords Campaign for ‘Rug Rats’

• Designed marketing campaign and AdWords strategies for the real-world client, modified 30+ landing pages, added 700+ keywords, tracked and analyzed user behaviors

• Acquired 489 new customers, engaged over 2,000 active users, and increased client’s revenue by 30% within 3 weeks

Contact this candidate