XUAN GAO
Perth,WA
Summary
Graduated from the University of Western Australia with Master's of Business Analytics in December 2022 and have gained 4 years experience as an Assistant accountant. Python beginner and in the process of attaining the CPA certification. A keen interest in financial analysis and data analysis. Attention to detail, proactive, strong learning ability, familiar with client management, data analysis, project coordination and other work processes, cross-departmental communication and resource integration skills. Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level Business Analyst position. Ready to help team achieve company goals.
Overview
3
3
years of professional experience
Work History
Business Analyst
Department of Water and Environment Regulation
01.2022 - 01.2022
- Project Launching and Preparation: Identified the project scope and delivery modality; defining the objectives of each phase of the project and developing team workflows to ensure that the project proceeds in an orderly manner; appropriately distributing tasks to each team member; draw up timetables to control the project process
- Data Cleansing and Modelling: Extracted data and worked on data cleansing via Microsoft Excel based on project scope; calculated the flooding event annual average damages by modelling analysis and advanced the comparative analysis among different cost bases
- Scenario Estimation: Made damage estimation in different degrees of climate change and generated constructively recommendations on the aspects of policies and regulations, such as levee, land buyback policy, minimum floor height policy, etc
- Visualization and Presentation: Visualized related results in Tableau and generate final report; presented to clients in a presentation format.
Data Analyst
Data Warehouse of the Australian and UK Job Markets (ETL)
01.2022 - 01.2022
- Extract and consolidate data based on business queries
- Conduct data cleansing work on large data sets using Python
- Architect the data warehouse and load data into SSMS (SQL Server Management Studio), and make sure that the data warehouse is effective in solving certain business needs
- Build connection between Power BI and SSMS, and present clearly and efficiently visualised dashboards to address specific business insights
- Build analytical reports and provide implementable solutions.
Assistant Accountant
Sergio D'Orazio & Associates Pty Ltd
01.2020 - 01.2023
- Business Activity Statement Preparation and lodgment: Contact the client requesting bank statements, receipts and other documentation required to prepare and lodge the client's BAS
- Bookkeeping: Bank reconciliations; Resolution of general ledger issues and generate journals into monthly general ledger; Fuel Tax Credits calculation; Payroll and superannuation preparation
- Financial Statement and Management Account Preparation: Prepare the clients year-end financial statements for annual income tax return needs; Prepare management financial statements for clients reporting requirements
- Financial Analysis: Helping clients to develop, maintain financial models/applications (VBA Excel/Access) to automate and streamline business processes and perform financial analysis.
Education
Master of Business Analytics -
The University of Western Australia
01.2022
Bachelor of Commerce (Accounting) -
The University of Western Australia
01.2019
Skills
- SQL Queries
- XERO/MYOB Accounting Software
- Advanced Excel Skill
- Tableau
- Power BI
- Python
Languages
Chinese
English
The Other Part of Me
- A passion for exploring the unknown and enjoying learning about people from different cultures.
- Enjoy having a plan and being logical on matters.
- Positive and optimistic attitude, able to self-digest stress.
- An enthusiastic snowboarder and traveller.
- Food lover
Timeline
Business Analyst
Department of Water and Environment Regulation
01.2022 - 01.2022
Data Analyst
Data Warehouse of the Australian and UK Job Markets (ETL)
01.2022 - 01.2022
Assistant Accountant
Sergio D'Orazio & Associates Pty Ltd
01.2020 - 01.2023
Master of Business Analytics -
The University of Western Australia
Bachelor of Commerce (Accounting) -
The University of Western Australia
Similar Profiles
Phil FitzgeraldPhil Fitzgerald
Assistant Director, Production Services (EL1) at Department of Climate Change, Energy, the Environment and Water (DCCEEW)Assistant Director, Production Services (EL1) at Department of Climate Change, Energy, the Environment and Water (DCCEEW)
Leah De BastosLeah De Bastos
Senior Operations Leader, Compliance and Regulation at Department of Climate Change, Energy the Environment & WaterSenior Operations Leader, Compliance and Regulation at Department of Climate Change, Energy the Environment & Water
Vannary DiepVannary Diep
Executive Assistant to Dr. Ilse Kiessling at Department of Climate Change, Energy, Environment and WaterExecutive Assistant to Dr. Ilse Kiessling at Department of Climate Change, Energy, Environment and Water