Zhuoyuan Liu
Melbourne,VIC
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation, and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Careful collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritisation skills.
Overview
3
3
years of professional experience
Work History
Junior Data Analyst
Peroptyx
12.2023 - 04.2024
- Streamlined reporting processes by automating routine tasks using Python and Excel macros.
- Strengthened internal data governance practices by helping to develop and implement policies related to data storage, access, and retention.
- Reduced manual processing time with automation scripts, allowing more focus on strategic initiatives, which supports need for verifying accurate navigation routes in spatial analysis.
- Increased efficiency in data extraction by utilising SQL queries for retrieving relevant information from databases, ensuring accuracy of distance measurements in map management.
Data Analyst Intern
Nielsen
11.2020 - 02.2021
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for broadband performance analysis.
- Optimised SQL queries for faster processing times, increasing overall productivity within team.
- Enhanced data visualisation capabilities for better decision-making with use of advanced BI tools.
- Completed data cleaning and data validation of raw spreadsheets of NBN data to promote robust data management platform using Advanced Excel tools and Python, resulting in accurate data analysis and entry.
- Identified trends and patterns in datasets through exploratory data analysis, leading to actionable insights.
Education
Master of Information Systems - Management Information Systems
University of Melbourne
Parkville, VIC07.2024
Bachelor of Science - Data Science
University of Melbourne
Parkville, VIC07.2022
Skills
- Data Analysis
- Python Programming
- Excel Functions
- SQL and Databases
- Tableau
- R Programming
- Machine Learning
- Statistics and SAS
Languages
English
Full Professional
Chinese (Mandarin)
Native or Bilingual
Chinese (Cantonese)
Native or Bilingual
Timeline
Junior Data Analyst
Peroptyx
12.2023 - 04.2024
Data Analyst Intern
Nielsen
11.2020 - 02.2021
Master of Information Systems - Management Information Systems
University of Melbourne
Bachelor of Science - Data Science
University of Melbourne
Similar Profiles
Nickolay ShvetsovNickolay Shvetsov
Map Evaluator at PeroptyxMap Evaluator at Peroptyx
Nasra TahlilNasra Tahlil
Data Analyst at PeroptyxData Analyst at Peroptyx
Arash MirshahiArash Mirshahi
Data Analyst at PeroptyxData Analyst at Peroptyx