Linyi Yao

Boulder, CO 720-***-**** adjkmk@r.postjobfree.com LinkedIn: www.linkedin.com/in/linyi-yao EDUCATION

University of Colorado at Boulder Boulder, CO

Master’s of Business Analytics Expected May 2021

Relevant Courses: Survey of Business Analytics, Fundamentals of Data Analytics, Applied Mathematics, Quantitative Methods, Optimization Modeling, Structured Data Modeling and Analysis University of Colorado at Boulder Boulder, CO

Bachelor of Arts, Major in Computer Science August 2016 – May 2020 Honors and Awards: Dean’s List (Spring 2019)

Relevant Courses: Software Development Methods and Tools, Data Structures, Statistical Methods, Algorithms, Principles of Programming Languages, Discrete Structures, Fundamentals of Human Computer Interactions, Computer Systems, Linear Algebra with Computer Science Applications, Data systems, Machine Learning, Data Mining WORK EXPERIENCE

West China Hospital, Mental Health Center and Psychiatric Laboratory Chengdu, Sichuan Data Analysis Intern July 2019-August 2019

● Used Free Surfer to obtain patient brain data and perform data analysis to help post docs fellows in the next experiment

● Participated in weekly seminars with graduate students to learn about the experimental process ACADEMIC PROJECTS

Software Development Methods and Tools project: Boulder charity search website

● Created a website to help users to become volunteers and donors so that they can easily search to find the right nonprofit for their cause around Boulder

● Used Excel to collect 2000 charities’ data and imported the data into MySQL

● Developed website front end using HTML, CSS, and JavaScript and website back end using PHP and SQL Structured Data Modeling and Analysis: Coffee Shop Data Analytics

● Classified small business inventories and discovered the relationship between customer table and receipt table, understand customer preferences through information interpretation, and improve service quality and efficiency.

● Designed a database and created an Entity Relationship Diagram in order to create growth strategies and help track future growth. Quantitative Methods: Seattle housing price analysis

● Cleaned raw data in R, identified independent and dependent variables and performed multiple regression analysis

● Calculated real estate value using the regression model to help real estate companies reliably guide buyer decisions Data Mining: Overseas students Data Analytics

● Created recommendations to help international students in the United States choose a suitable school and major through the data from the Kaggle website.

● Performed data analysis primarily using Python, including pandas and Matplotlib libraries Optimization Revenue Growth of Bike Rentals in Washington D.C.

● Identified variable correlation and created a regression model in Excel to determine the impact of weather, holidays, rental locations on the number of users in order to Optimization Revenue Growth of Bike Rentals Minimizing Lethality of Traffic Accidents in the State of California

● Performed descriptive analysis in SQL to determine the impact of medical transportation, traffic management, weather influences,and other factors on the lethality of traffic accidents

● Used logistic regression to find the time and location, etc. where traffic accidents are likely to occur. By improving traffic management and increase the number of medical aid stations in order to minimize the lethality of traffic accidents in California VOLUNTEER EXPERIENCE

The Future of Historic Villages and Towns International Conference (Volunteer, June 2019) Chengdu, Sichuan

● Guided scholars, investors, and researchers from all over the world at the airport University of Colorado at Boulder, New Student & Family Programs (Journey Leader, August 2018) Boulder,CO

● led a team of 7 volunteers to help orient 800 international students arriving on campus

● Provided check-in assistance guided campus tours, and mingled with new students to help acclimate them to campus life SKILLS

Experienced: data warehousing, Scala, C++, Free Surfer Familiar: R, Python, Microsoft Excel, SQL Languages: Advanced: English; Native: Chinese.

Contact this candidate