Summary
Overview
Work History
Education
Skills
Timeline
Generic

Zihan Cheng

Wolli Creek,NSW

Summary

Recent Master of Commerce graduate specializing in Data Analytics for Business, with a strong background in financial analysis, forecasting, and data-driven decision-making. Skilled in Python, SQL, Tableau, and Excel for data manipulation, visualization, and statistical analysis. Proven ability to present insights to senior stakeholders, driving strategic decisions. Passionate about leveraging data to solve complex business challenges.

Overview

3
3
years of professional experience

Work History

Junior Accountant

House of Quirky
Sydney, NSW
08.2024 - Current
  • Created journal entries accurately and timely month end close processes.
  • Prepared monthly financial statements and supporting schedules.
  • Analyzed balance sheets for mistakes and inaccuracies.
  • Analyzed financial documents to verify data and mathematical accuracy.
  • Collaborated with external partners to complete audits.

Data Analyst

USYD project
Sydney, NSW
04.2024 - 06.2024
  • Cleaned and transformed Chemist Warehouse's two years large transactional datasets using Python and SQL, ensuring high-quality data for analysis.
  • Performed customer segmentation using clustering techniques to identify high-value customers and tailor marketing strategies accordingly.
  • Recommended targeted promotional campaigns and optimized product placement strategies based on the analysis to Chemist Warehouse.

Data Analyst

USYD project
Sydney, NSW
03.2023 - 05.2023
  • Conducted exploratory data analysis (EDA) to identify Big W sales trends, seasonal patterns, and customer purchasing behaviors.
  • Built a demand forecasting model using time-series analysis, which increased Big W's forecasting accuracy by 20%.
  • Created interactive dashboards in Tableau to visualize Big W's sales performance and inventory levels, enabling management to make data-driven decisions.
  • Presented actionable recommendations to stakeholders, leading to a 10% reduction in stockouts and improved sales efficiency.

Data Analyst Intern

NIO
Wuhan
09.2022 - 03.2023
  • Analyzed customer feedback data to identify areas for improvement.
  • Participated in the development of machine learning models to predict outcomes and trends.
  • Assisted in the integration of analytics findings into business processes.
  • Created visualizations using tools like Tableau and Power BI to communicate findings to non-technical stakeholders.

Data Analyst

Gosen Security
Shenzhen
02.2022 - 08.2022
  • Built visualizations that enabled users to quickly interpret results from complex analyses.
  • Optimized existing database structures for better performance on analytics tasks.
  • Developed custom data models and algorithms to apply to data sets, enhancing business operations.

Education

M.D. - Data Analysis

The University of Sydney
Sydney, NSW
07-2024

J.D. - Accounting And Finance

The University of Sydney
Sydney, NSW
12-2022

Skills

  • Tableau
  • SQL
  • Python
  • Visual data representation
  • Data utilization
  • Analytical problem solving
  • Data integrity validation
  • Business needs analysis

Timeline

Junior Accountant

House of Quirky
08.2024 - Current

Data Analyst

USYD project
04.2024 - 06.2024

Data Analyst

USYD project
03.2023 - 05.2023

Data Analyst Intern

NIO
09.2022 - 03.2023

Data Analyst

Gosen Security
02.2022 - 08.2022

M.D. - Data Analysis

The University of Sydney

J.D. - Accounting And Finance

The University of Sydney
Zihan Cheng