Panyu Zhang

adkiew@r.postjobfree.com 740-***-**** www.linkedin.com/in/panyu-zhang Malden, MA 02148 EDUCATION

Northeastern University, Boston, MA 2019 - 2020

Master in Analytics (STEM Certified, OPT for 36 Months) GPA: 3.82 Relevant courses: Data Mining Applications, Data Warehousing and SQL, Data Management and Big Data, Artificial Intelligence Chongqing University of Posts and Telecommunications, Chongqing, China 2012 - 2016 Bachelor of Engineering Management, concentration: Project Management and Cost Estimation Activities: Student Union President, Construction Simulation Project Manager, Associate Office Administrator TECHNICAL SKILLS

Statistical Inference: A/B Testing, Hypothesis testing, Probability, Simulations, Confidence intervals, Correlation, Regression Data Engineering: Data Extraction, Manipulation and database management, MySQL, Snowflake, Firebase, AWS Machine Learning: Regression Analysis, Clustering, K-Means, Decision Tree, Random forest, SVM, GBM Programming Languages: Python(Pandas, Numpy, SciPy, Matplotlib, Scikit-Learn), R, SQL Business Analysis: Tableau, Microsoft Excel(VLOOKUP, Macro, Pivot table), Power BI, Google Analysis EXPERIENCE

At Home Group Boston, MA

Data Analyst(Experiential Learning Project) 2020/09-2020/12

• Collected zip-code level data for retail stores, dataset includes 75 variables that may affect furniture retail business performance.

• Performed EDA, feature engineering, correlation analysis, and clustering for segmentation and pattern detection.

• Implemented Support Vector Regressor, Multilinear Regression, and Random Forest Model to analyze and predict the retail store sales based on the high correlation variables.

• Provided business insights including recommending future store locations and distribution of product levels in different locations. Analytics Consult, LLC Belmont, MA

Data Analyst Intern 2020/02-2020/07

• Worked with online pharmacy client’s ERP system and performed ETL process by using MySQL to support analytical processing.

• Monitored marketing data from 4 online search engines and prioritized advertising budget. Created Tableau dashboards and reports KPIs like click rate, site interaction rate, and time spent on webpages.

• Classified users in database and build machine learning models to predict purchasing behavior of customers.

• Enhanced telemarketing system by developing a priority contact list with RFM model, resulted a 30% increase in purchase rate after one month.

• Worked with cross functional teams to develop Church Build widget on website. This includes managing Google Firebase and helping visualize church visit and activity data for church owners. General Electric Aviation Boston, MA

Data Analyst(Experiential Learning Project) 2020/01-2020/03

• Conducted feature engineering to get new useful attributes and to do EDA of the processed large scale dataset.

• Used K-means clustering and the elbow method to find important features and insights about the dataset, provide analysis reports according to the cluster results and findings.

• Built supervised learning predict model with Decision Tree, Random Forest, increased model accuracy through setting threshold, and using confusion matrix to measure the accuracy. The final predict model can successfully predict 96% risk alerts.

• Provided new risk prevent system and recommended improvements such as restructure risk group to reduce IP thief. ADDITIONAL PROJECTS

Software Pricing A/B Test 2021/01 - 2021/02

• Recommended software price that can increase more revenue, used Chi-square testing and hypothesis testing to evaluate A/B test.

• Visualized factors that affect conversion rate include multiple download sources, devices, and operative systems. Yelp Review Analysis 2020/10 - 2020/11

• Implemented text mining on 5 million customer reviews to find the negative and positive words in 7 cuisine types on presentation. Google Play Store Game APP Analysis 2020/07 - 2020/08

• Analyzed the data of 13,144 different games, built regression model to predict various variables and user ratings by Python. Boston Economic Indicators Analysis 2020/02 - 2020/03

• Developed Trend BI Dashboards on Tableau to predict Boston’s economy by identifying key Boston economy indicators, and performed data cleaning and feature selection to implement Timeseries to predict Boston economic trend. Washington DC Bike Sharing Industry Data Analysis 2019/11 - 2019/12

• Provided practical business insights regarding promotion timing and bike quality through correlations and predictive model by R. Regional Public Housing Agencies Database 2019/09 - 2019/10

• Structured Housing inspection database and wrote SQL query to perform database functionalities for analytical processing.

Contact this candidate