Zhiyuan Yang

adjnto@r.postjobfree.com 626-***-**** Temple City, CA 91780

EDUCATION

UCLA Los Angeles, CA Sep 2019 – Sep 2020

• Major: Data Science, Certificate

McMaster University Hamilton, Canada Sep 2016 – Sep 2017

• Major: Engineering, Master’s degree

Nankai University Tianjin, China Sep 2012 – Jun 2016

• Major: International Relations, Bachelor’s degree WORK EXPERIENCE

Data Analyst Intern at GTSP Group Santa Clara, CA Nov 2020 – present

• Grabbed and imported data from www.crunchbase.com into PostgreSQL using Python.

• Analyzed company data by drawing entity relationship diagrams using Visio.

• Built an advanced search UI using Balsamiq.

• Performed front-end web development using HTML, CSS, JavaScript, Thymeleaf and Spring Boot.

• Helped launch a search engine demo with more than 8.52% expected monthly web traffic growth (based on the stats of the main competitor www.itjuzi.com).

Client Advisor Intern at Royal Bank of Canada Toronto, Canada Mar 2019 – Jun 2019

• Assisted in the resolution of client inquiries during daily transactions.

• Referred to the sales team for selling bank products.

• Impacted the revenue growth of 3 different branches by 5% in Q2 2019. Customer Service Rep at CTBC Bank Toronto, Canada Jul 2018 – Feb 2019

• Developed and maintained relationships with commercial clients.

• Processed back office documents from BMO.

• Impacted the revenue growth by 6% in Q3 2018, Q4 2018 and Q1 2019. Administrative Assistant at INTS Consulting Toronto, Canada Sep 2017 – Jun 2018

• Analyzed client data using Excel and generated visual reports for mining client needs.

• Helped organize several marketing campaigns on social medias and schools.

• Impacted the revenue growth by 7% in Q4 2017, Q1 2018 and Q2 2018. PROJECTS

COVID-19 Prediction https://github.com/bennyzy0509/COVID-19_Prediction Jun 2020 – Sep 2020

• Predicted the increase in COVID-19 cases in the U.S. using R.

• Created dashboards with interactive graphs using Tableau.

• Built, visualized and compared several ML models.

• Matched with CDC reports with less than 5% forecasting error. Los Angeles Housing Price https://github.com/bennyzy0509/COVID-19_Prediction Jan 2019 – Apr 2020

• Predicted Los Angeles housing price by zip code using R.

• Analyzed and visualized geographic, environmental and socioeconomic observations.

• Built and visualized a multiple linear regression model with 97.1% accuracy. SKILLS

• Programming: Python, R, HTML, CSS, JavaScript, Java, Excel VBA.

• Databases: PostgreSQL, MySQL, MongoDB.

• Tools: Tableau, Power BI, Visio, Balsamiq.

Contact this candidate