Zin Zin Aye Chan Portfolio

A bit about me

I am a Commerce graduate with dual majors in Business Analytics and Accounting from Macquarie University, with a WAM of 81 and recognition on the 2024 Merit List. My experience includes customer and sales data analysis, segmentation, dashboard design and stakeholder reporting.

I enjoy turning complex data into clear, practical insights that support business decisions. With a strong foundation in finance and accounting, I approach problems with both analytical and commercial thinking. I work confidently across SQL, Tableau, Excel, Python, and R to deliver structured analysis and clear reporting for stakeholders.

10 Analytics & data projects

81 WAM

5+ Tools & languages

Projects

A selection of my data and analytics projects. Use the filters to browse by tool.

Tableau Client project

Business Analytics Project

Overview: an interactive Tableau dashboard built for a real client, Impact100 Sydney, through a university program.
Approach: gathered and cleaned data on 50+ charity organisations, then designed 3 dashboards tailored to different user types.
Outcome: a working tool the client could use to explore funding trends and volunteering opportunities, presented to them directly.

TableauExcel

View on GitHub

Python Unsupervised ML

Customer Segmentation Analysis

Overview: a machine learning project that groups supermarket customers by their shopping behaviour.
Approach: analysed 4,000 customers and used clustering to sort them into 4 distinct groups by age, income and profile.
Outcome: a clear profile of each group, with a tailored marketing approach recommended for all 4.

Pythonscikit-learnpandas

View on GitHub

SQL Cleaning & EDA

MySQL Layoffs Analysis

Overview: a SQL project on a real-world dataset of 2,300+ global tech-company layoffs.
Approach: cleaned the raw data from scratch, removing duplicates and fixing inconsistent entries, then explored it with SQL queries.
Outcome: a clear view of which companies, industries and years were hit hardest.

MySQL

View on GitHub

Excel Time series

Retail Turnover Forecasting

Overview: a sales forecast for Australian department stores based on 8 years of retail data.
Approach: built and fine-tuned a seasonal forecasting model in Excel to predict the next 12 months of sales.
Outcome: a 12-month forecast tested against actual sales to confirm its accuracy.

Microsoft ExcelMinitab

View on GitHub

Python Kaggle competition

Used Car Price Prediction

Overview: a team entry for a Kaggle data competition that predicts a used car's price from details like mileage and engine.
Approach: led the modelling, testing 5 different approaches and selecting the most accurate one.
Outcome: a model that placed well on the competition leaderboard.

Pythonscikit-learnKaggle

View on GitHub

Python Classification

Credit Card Default Prediction

Overview: a model that predicts whether a credit card customer will miss their next payment.
Approach: cleaned and prepared records from 10,000 customers, then trained and tested the model.
Outcome: the final model correctly predicted defaults 81% of the time.

Pythonscikit-learn

View on GitHub

R Statistical modelling

Statistical Data Analysis

Overview: a statistics project written in R, covering 2 real datasets.
Approach: built a model to find the main causes of traffic congestion, and ran an experiment on how recipe and temperature affect baking.
Outcome: the traffic model explained 71% of the variation in congestion across US cities, written up as a clear, reproducible report.

RR Markdown

View on GitHub

Excel Investment analysis

Real Estate Investment Analysis

Overview: an analysis of whether Sydney's Ryde area is a smart place to invest.
Approach: studied 30 years of housing prices, adjusted for inflation, and compared Ryde against the wider Sydney market.
Outcome: a clear investment recommendation weighing growth potential against stability.

Microsoft Excel

View on GitHub

Java Creative coding

2D Game Development

Overview: a 2D game built in Processing (Java).
Approach: programmed a custom character that moves around the screen, with wrap-around edges and collision detection.
Outcome: a playable game where you dodge 2 randomly placed obstacles until you get hit.

ProcessingJava

View on GitHub

Java Creative coding

Snake Game Development

Overview: a fully playable Snake game built in Processing (Java).
Approach: built the full game from scratch, including a welcome screen, a growing snake, collision detection and a score counter.
Outcome: a complete game with win and game-over states. Reach 10 points to win.

ProcessingJava

View on GitHub

Skills & tools

Languages & libraries

SQLPythonRJava pandasNumPyscikit-learnMatplotlibSeaborn

Data & tools

TableauMicrosoft ExcelJupyter NotebookR MarkdownMinitabGitHubPowerBI

Analytical skills

Customer segmentationTime series forecastingMachine learningStatistical modellingHypothesis testingKPI reportingExploratory data analysisData cleaning

Stakeholder skills

Client presentationNon-technical communicationRequirements analysisRecommendations reportingCross-functional collaboration

Experience

Retail Associate

Oct 2023 – Present

Sunglass Hut

Monitor daily sales performance, units sold, and budget attainment using internal stock systems, translating trends into practical floor decisions such as product placement and stock prioritisation adopted by the store manager
Track KPIs including revenue targets and sell-through rates, identify performance gaps, and recommend data-backed operational adjustments
Reconcile 10+ daily cash and card transactions against POS records, tracing discrepancies at transaction level to ensure accurate end-of-day close

Audit Assistant

Sep 2021 – Jun 2022

AIESEC

Reviewed 150+ financial records per period across five branches, applying structured compliance checks against budgets and internal policies
Investigated data anomalies including missing documentation, duplicate entries, and miscategorised transactions by liaising directly with branch members
Consolidated financial submissions from 15+ departments into standardised Excel reports and presented monthly audit findings in clear, accessible language

Business Development Branch Team Lead

Aug 2021 – Jan 2022

AIESEC

Researched and contacted 100+ companies as potential sponsors, managing outreach pipeline in Excel and HubSpot to track status and follow-ups
Converted outreach pipeline into five confirmed sponsorships over six months, contributing to 15% growth in branch sponsorship revenue
Set team KPIs, reviewed pipeline performance weekly, and delivered monthly reports to stakeholders and senior leadership

Education

Bachelor of Commerce ( Business Analytics & Accounting )

Graduated Aug 2025

Macquarie University, Sydney

WAM 81.0 · 2024 Merit List · Peer Mentor, University Peer Mentoring Program.
Relevant units: Data Modelling and Visualisation (HD), Applied Statistics (HD), Business Forecasting (HD), Accounting Information Systems (D), Financial Statement Insights and Analysis (D), Advanced Analytics Techniques (Cr).

Zin Zin Aye Chan

A bit about me

Projects

Business Analytics Project

Customer Segmentation Analysis

MySQL Layoffs Analysis

Retail Turnover Forecasting

Used Car Price Prediction

Credit Card Default Prediction

Statistical Data Analysis

Real Estate Investment Analysis

2D Game Development

Snake Game Development

Skills & tools

Languages & libraries

Data & tools

Analytical skills

Stakeholder skills

Experience

Retail Associate

Audit Assistant

Business Development Branch Team Lead

Education

Bachelor of Commerce ( Business Analytics & Accounting )

Get in touch