Summary
Overview
Work History
Education
Skills
Certification
Website
Timeline
Generic

Yuanjian YAO

DOCKLANDS,VIC

Summary

Passionate data analyst with a strong background in BI tools such as SQL, R and Tableau. Proficient in transforming complex datasets into clear insights and experienced in communicating with stakeholders. Demonstrated success in enhancing business processes and driving growth.

Overview

1
1
Certification

Work History

EPL Data Analysis Project

Project: https://yuanjianyao.shinyapps.io/Assignment2/

  • Designed and implemented comprehensive EPL dashboard spanning 2000-2021 using Rshiny.
  • Enhanced user experience by incorporating interactive features such as dropdown menus, clickable elements, and hover functionality.
  • Demonstrated proficiency in data visualization tools including R.

MelCompass Project

Project: https://yuanjianyao.shinyapps.io/Assignment3/

  • Developed MelCompass, a web platform for Melbourne tourists, integrating R Shiny and Tableau for interactive visualizations.
  • Employed innovative features like the3D map for quick attraction browsing, enhancing user experience.
  • Utilized Google API and Tableau for seamless data integration and visualization, providing comprehensive insights.

Office Assistant

Poly Developments And Holdings
06.2022 - 09.2022

• Collaborated with 15+ project managers, analyzed data for evaluation reports that resulted in achieving project requirements and increased efficiency.

• Organized engineering meetings, reaching 500+ views on public media and receiving positive stakeholder feedback.

• Produced and edited 150+ PowerPoint slides and reports for project evaluations using MS Office.

Education

Master of Science - Information Technology

University of Melbourne
Parkville, VIC
11.2024

Bachelor of Science - Civil Engineering(Honour)

University of New South Wales
Sydney, NSW
06.2022

Skills

  • SQL
  • Tableau
  • Python
  • R
  • MS Excel
  • Critical thinking
  • Data visualization
  • Communication

Certification

Google Data Analytics Specialization - Coursera

Credential ID 37GQ9HW7VVLQ


Website

linkedin: www.linkedin.com/in/yuanjian-kean-yao-077589209

Tableau Public: https://public.tableau.com/app/profile/yuanjian.yao

Timeline

Office Assistant

Poly Developments And Holdings
06.2022 - 09.2022

EPL Data Analysis Project

MelCompass Project

Master of Science - Information Technology

University of Melbourne

Bachelor of Science - Civil Engineering(Honour)

University of New South Wales
Yuanjian YAO