YUCHAN GUO

734-***-**** adts5h@r.postjobfree.com she/her/her

Education

Carnegie Mellon University, Heinz College December 2023 Master of Information Systems Management Pittsburgh, PA

• Courses: Object Oriented Programming (Java), Database Management, Economic Analysis University of Michigan - Ann Arbor April 2022

Bachelor of Science, Data Science Ann Arbor, MI

• James B. Angell Scholar (achieved all A’s in more than two consecutive semesters)

• Courses: Machine Learning (Python), Data Management System (Python & SQL), Data Structures and Algorithms (C++), Information Retrieval & Web Search (Python), Probability and Statistics (R) Skills & Certifications

• Programming Languages: Python, SQL, Tableau, R, C++, Java, API

• Analytical Skills: Machine Learning, Data Visualization, Data Analyst, A/B Tests

• Certification: Google Data Analyst Certification

• Languages: English, Chinese, Japanese (Passed N2) Professional Experience

Research Assistant August 2022 - Present

Biorobotics Lab at Carnegie Mellon University Pittsburgh, PA

• Designed and established a cloud database by Amazon Web Services and Particle to collect, store and analyze medical device data to monitor users’ situations and fix possible issues ahead

• Developed web servers for collecting experiment data directly from equipment utilizing Javascript and APIs Business & Data Analyst Intern May 2022 - August 2022 HireBeat Jersey City, NJ

• Scraped job descriptions by the automatic web crawler from LinkedIn to construct sentiment analysis datasets

• Developed Neural Network model in Python and enhanced the accuracy from 70.25% to 91.45%

• Generated web servers from APIs to acquire templates, rate job descriptions and automatically provide improving suggestions based on features from excellent descriptions samples Data Analyst Intern December 2020 - July 2021

NetEase Beijing, China

• Devised auto-analyzing procedures with SQL and visualized metrics by Tableau such as Daily Active Users, Cost per Recall and Retention Rate to provide insights for management decision making

• Led the data analysis of NetEase Media DSP delivery system, evaluated plans and optimized delivery process

• Exploited strategy A/B tests and algorithm developments by C++ and Python and achieved 2000% increase in daily active and recalled users in three months

Labor Investigation Office Intern June 2020 - August 2020 National Bureau of Statistics Shenyang, China

• Invented standardized yearly labor market surveys to systematize collection of statistical data

• Collected more than 1,000,000 citizens' data from surveyors and merged to support national labor planning

• Visited randomly selected survey participants to verify answers and performed data quality control checks Academic Projects

Predicting Political Preferences of America Counties Based on Twitter April 2022

• Obtained user information and Tweets via python and developed SVM models to predict the dominant political party in each US county and achieved 89.58% accuracy

• Visualized the local parties as a map by Python and gave a class demo to show the real-time voting estimation Family Life Influences Adolescents’ Substance Abuse November 2021

• Produced the linear regression equation to calculate the probability of abuse from five family characteristics

Contact this candidate