Summary
Overview
Work History
Education
Skills
Certification
References
Timeline
Generic

Joyce LIU

Kogarah,NSW

Summary

Motivated Analytics Specialist with a decade of experience in financial analysis, data modeling, and leveraging advanced analytics tools such as Power BI. Expert at transforming complex data into actionable insights for strategic decision-making and enhancing business processes. Aiming to utilize my analytical skills and passion for data storytelling to contribute to TAFE NSW’s objectives, ensuring accurate financial information aids pivotal business decisions.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Analytics Specialist

TAFE NSW
SYDNEY
01.2023 - Current
  • Designed and implemented student complaint BI dashboard, significantly improving resolution efficiency by 35% and supporting decision-making by 20%
  • Played a pivotal role in optimizing the BI reporting team's processes by managing a comprehensive ticketing system, enhancing report development and access control
  • Contributed to the BI report peer review panel, ensuring all reports met TAFE's high-quality standards, thereby enhancing the reliability and impact of BI reporting.

Finance Transition ANALYST

TAFE NSW
SYDNEY
08.2022 - 12.2023
  • Developed a financial performance dashboard using Power BI, merging financial and operational metrics to improve financial reporting efficiency by 20% and enhance decision-making by 25%
  • Conducted in-depth financial analysis and presented insights to stakeholders, leading to a 25% improvement in decision-making efficiency
  • Enhanced financial process optimization and service catalog development, elevating stakeholder satisfaction by 25% and expediting service resolution by 30%.

Finance Business ANALYST

TAFE NSW
Sydney
10.2019 - 08.2022
  • Established a centralized financial reporting system for delivery regions, streamlining the month-end financial performance reporting process, reducing report preparation effort by 80%, and increasing efficiency by 30%
  • Developed dynamic dashboards with Excel, integrating KPIs to improve regional decision-making accuracy by 25%, showcasing advanced data visualization skills
  • Played a key role in the budgeting and forecasting cycle by developing an FTE budget load template, achieving a 10% improvement in budget accuracy, and a 15% reduction in preparation time, thereby aligning financial planning with organizational goals
  • Innovated an employee cost analysis report, enhancing the precision of teaching cost insights by 15% and supporting data-driven decision-making through improved data accuracy and timeliness.

Finance OFFICER

TAFE NSW
Sydney
03.2016 - 10.2019
  • Conducted data analysis and financial reporting, adapting to diverse business needs, and ensuring timely and accurate month-end closures
  • Identified and rectified financial discrepancies, significantly enhancing budget report accuracy and financial integrity
  • Managed and executed key financial transactions, including sales and purchase orders, and maintained accurate fixed asset and balance sheet records
  • Streamlined the salary accrual process for part-time casual teachers, reducing journal preparation time by 50% and increasing accuracy by 30%
  • Developed and implemented training revenue exception reports, correcting misallocations, and increasing revenue accuracy by 20%.

ACCOUNTANT

Century21 Real Estate
Sydney
07.2015 - 03.2016
  • Managed daily financial transactions for rental and sales trust accounts, and performed data analysis on operating expenses, achieving timely accuracy in data processing and a 15% reduction in costs.

ACCOUNTANT

Homeland Construction P/L
Sydney
11.2014 - 07.2015
  • Oversaw receipt and payment recordkeeping, reconciled the general ledger, and prepared BAS and IAS, ensuring the accuracy and integrity of financial data and contributing to comprehensive financial reporting.

Financial & Management Accountant

China Mobile Limited
09.2011 - 10.2014
  • Delivered monthly financial management reports with a 17% increase in accuracy, automating asset depreciation processes for a 25% gain in productivity.

Education

Master of Professional ACCOUNTING -

University of Technology Sydney
08.2011

Skills

  • Data Analysis and Business Intelligence
  • Advanced Excel
  • Power BI
  • Power Pivot
  • Power Query
  • SQL
  • Financial Analysis and Reporting
  • Advanced Data Visualization
  • Stakeholder Engagement and Communication
  • Strategic Problem-Solving

Certification

  • CPA Australia, 10435424, 2017 - 2019
  • Microsoft Certified: Power BI Data Analyst Associate
  • Microsoft Certified: Azure Data Fundamentals
  • Microsoft Certified: Power Platform Fundamentals

References

References available upon request.

Timeline

Analytics Specialist

TAFE NSW
01.2023 - Current

Finance Transition ANALYST

TAFE NSW
08.2022 - 12.2023

Finance Business ANALYST

TAFE NSW
10.2019 - 08.2022

Finance OFFICER

TAFE NSW
03.2016 - 10.2019

ACCOUNTANT

Century21 Real Estate
07.2015 - 03.2016

ACCOUNTANT

Homeland Construction P/L
11.2014 - 07.2015

Financial & Management Accountant

China Mobile Limited
09.2011 - 10.2014

Master of Professional ACCOUNTING -

University of Technology Sydney
Joyce LIU