Wang_Resume_DA
Jianyu (Alfred) Wang
------------ | ------------ | ------------/in/-jianyu-wang
EDUCATION _
Carnegie Mellon University Pittsburgh, PA
Master of Information Systems Management – Business Intelligence & Data Analytics (STEM) Aug 2019 – Dec 2020
? Courses: Database Management, Machine Learning for Problem Solving, Unstructured Data Analytics, Advanced Business Analytics, Distributed Systems, A/B Testing, Applied Econometrics, Product Management in IT
? GPA: 3.2/4.0
Emory University Atlanta, GA
Bachelor of Arts in Joint Major: Economics & Mathematics (STEM) Aug 2015 – May 2019
? GPA: 3.6/4.0
WORK EXPERIENCE
Game Data Analyst Intern Shenzhen, China (Remote)
Tencent May 2020 – Aug 2020
? Optimized operational strategies on mobile gaming by developing RFM and AARRR models through calculating and visualizing key KPIs using Python and SQL, conducted A/B Test, and successfully increased retention by 9%
? Launched market research, industry analysis, and competitive product analysis for WeChat Game Center and TikTok Game Center, and composed a competitive product analysis report
Data Analyst Intern Chengdu, China
Wanyi Power Jun 2018 – Aug 2018
? Conducted business analysis on temperature data from major hydropower stations in Sichuan Province using hypothesis testing and regression analysis to predict future electricity generation with respect to environmental changes
? Created a data visualization dashboard using Tableau to automatically show the relationship of the geographic location of hydropower stations and electricity-consuming corporations
ACADEMIC PROJECTS
Information Fatigue and Its Impact on Covid-19 Mitigation Efforts Pittsburgh, PA
Capstone Project – Project Manager Sep 2020 – Dec 2020
? Applied TFIDF and LDA model to measure the novelty of Covid related news, and used Infostop algorithm to identify home address and movement radius of people in Pittsburgh to test the correlation and causality
? Utilized Brandwatch for social data mining and visualized personas on Covid related topics
Client: A+E Networks Pittsburgh, PA
Course: Measuring Social – Data Analyst Jan 2020 – Apr 2020
? Provided social media marketing strategies which entice audiences to tune-in linear programming of A+E History channel by conducting audience and competitor analysis to assess personas using Brandwatch
? Designed a program premiere evaluation metric by calculating and visualizing key KPIs using Python to evaluate the efficiency of program promotion on different social channels, and proposed targeted improvement plans
SKILLS
Programming Skills: Python, SQL, Java, R, STATA
Python Packages: Numpy, Pandas, Scikit-Learn, PyTorch, spaCy, Matplotlib, Seaborn, Plotly
Software: AWS, Pittsburgh Super Computing, Tableau, Brandwatch, MS Office
Jianyu (Alfred) Wang
------------ | ------------ | ------------/in/-jianyu-wang
EDUCATION _
Carnegie Mellon University Pittsburgh, PA
Master of Information Systems Management – Business Intelligence & Data Analytics (STEM) Aug 2019 – Dec 2020
? Courses: Database Management, Machine Learning for Problem Solving, Unstructured Data Analytics, Advanced Business Analytics, Distributed Systems, A/B Testing, Applied Econometrics, Product Management in IT
? GPA: 3.2/4.0
Emory University Atlanta, GA
Bachelor of Arts in Joint Major: Economics & Mathematics (STEM) Aug 2015 – May 2019
? GPA: 3.6/4.0
WORK EXPERIENCE
Game Data Analyst Intern Shenzhen, China (Remote)
Tencent May 2020 – Aug 2020
? Optimized operational strategies on mobile gaming by developing RFM and AARRR models through calculating and visualizing key KPIs using Python and SQL, conducted A/B Test, and successfully increased retention by 9%
? Launched market research, industry analysis, and competitive product analysis for WeChat Game Center and TikTok Game Center, and composed a competitive product analysis report
Data Analyst Intern Chengdu, China
Wanyi Power Jun 2018 – Aug 2018
? Conducted business analysis on temperature data from major hydropower stations in Sichuan Province using hypothesis testing and regression analysis to predict future electricity generation with respect to environmental changes
? Created a data visualization dashboard using Tableau to automatically show the relationship of the geographic location of hydropower stations and electricity-consuming corporations
ACADEMIC PROJECTS
Information Fatigue and Its Impact on Covid-19 Mitigation Efforts Pittsburgh, PA
Capstone Project – Project Manager Sep 2020 – Dec 2020
? Applied TFIDF and LDA model to measure the novelty of Covid related news, and used Infostop algorithm to identify home address and movement radius of people in Pittsburgh to test the correlation and causality
? Utilized Brandwatch for social data mining and visualized personas on Covid related topics
Client: A+E Networks Pittsburgh, PA
Course: Measuring Social – Data Analyst Jan 2020 – Apr 2020
? Provided social media marketing strategies which entice audiences to tune-in linear programming of A+E History channel by conducting audience and competitor analysis to assess personas using Brandwatch
? Designed a program premiere evaluation metric by calculating and visualizing key KPIs using Python to evaluate the efficiency of program promotion on different social channels, and proposed targeted improvement plans
SKILLS
Programming Skills: Python, SQL, Java, R, STATA
Python Packages: Numpy, Pandas, Scikit-Learn, PyTorch, spaCy, Matplotlib, Seaborn, Plotly
Software: AWS, Pittsburgh Super Computing, Tableau, Brandwatch, MS Office