Data Analyst Sales

Shuying Zhang

Phone: +1-773-***-**** Email: ****************@*.************.***

Education

Northwestern University, Evanston, IL December 2019 M.S. in Project Management, Minor in Entrepreneurship Overall GPA: 3.86/4.00 Courses: Machine Learning; Design & Analysis of Algorithms; Social Dynamic & Network Analytics; NUvention: Web + Media; Programming for Big Data; Managerial Finance; Managerial Accounting Beijing Jiaotong University, Beijing, China July 2016 B.S. in Economics Overall GPA: 3.74/4.00

Dataquest, certificate of Data Scientist & certificate of Data Analyst November 2020 Skillsets

Technical Skills: Excel; SQL; Database; Python; Tableau; Power BI; Gephi; SPSS

Statistical Knowledge: Regression; Classification; Clustering; Dimensionality Reduction; A/B Tests

Analytics: AARRR framework; user segmentation; cluster analysis; Value Proposition Canvas; MVP testing Experience

Data Analyst Intern, Amaral Lab, Northwestern University, Evanston October 2019-Present

Extracted, cleaned, aggregated, and manipulated required data from over 10GB json data files. Data Analyst Intern, Infinet.CO, Chicago October 2019-December 2019

Mined and sorted monthly sales data with Python to highlight purchasing trends and research underlying causes of variance to create accurate and timely reports, leading to a 15% reduction in operating costs

Coordinated with engineers for data cleaning and variables selection to ensure data analyzable

Conducted statistical analyses to leverage the results to drive market decision and survey development PTA, Consulting Department, McKinsey & Company March 2018-May 2018

Provided strategy consultancy for an internet financial service company, researched on payment ecosystem industry and drafted legal opinions

Assisted the supervisor to sort and analyze both external and internal data to verify initial hypotheses and participated in on-call meetings

Founder, Secret App October 2013-January 2014

Assessed user feedback and lead initiatives for product adjustments to grow user base and satisfaction

Used Axure to create the product prototype and built the roadmap for app; got 1 million of angel investment Projects

Machine Learning on automatic characterization of cuisine September 2019-December 2019

Cleaned data and extracted information through word lemmatization, used bag-of-words and tried TF*IDF method to deal with dataset

Conducted data analysis using logistical model, SVM, KNN, decision tree, and random forest method to identify cuisine by ingredients and got 81% accuracy on the testing set Growiy: Tools help home growers troubleshoot problems January 2019-June 2019

Worked collaboratively with developers, designers; built the product roadmap based on business vision & market and competitive analysis

Tested and iterated app & website based on 200 customer research via interviews of potential users

Developed the pricing model and customer acquisition tactic, created wireframing based on user feedbacks Network Analysis: Identifying hubs in the music industry January 2019-March 2019

Performed 20 years’ data wrangling on unstructured data, processed missing values, audited data quality of 1566 nodes and 1860 edges; stored cleaned data and analyzed in Gephi

Created two CSV files for Gephi, compared nodes and edges by modularity, path length & clustering coefficient to identify the insights of music industry

Interfaced with data scientists, analyzed industry data, developed assumptions, drafted descriptive analysis

Contact this candidate