Aside

Contact

Download this vitae as a PDF


Skills

Data Analytics:SQL, Python, R, Alteryx
Data Visualization:PowerBI, Qlik, Tableau
Cloud:AWS, GCP, Azure
Other Techniques:Git, Devops, Excel, VBA, Javascript
Business Acumen
Communication
Leadership/Management

Main

Frank Zhang, CA

Education

Master of Professional Accounting

University of New South Wales

Sydney, Australia

2019 - 2017

Bachelor of Management (Major in Accounting)

Hebei University of Economics and Business

China

2017 - 2013

Professional Experience

Senior Consultant, Data Analytics

PwC Australia

Sydney, Australia

Present - 2021 Jul

  • Leveraged advanced data analysis and visualization methodologies to equip clients with critical insights from their data, enabling them to make strategic, informed decisions. Employed a suite of tools including SQL, Tableau, Excel, Python, R for this purpose.
  • Implemented data pipelines for diverse projects, involving the creation of data tables and formulation of SQL queries, complemented by meticulous data validation, modelling and visualization. This process was enhanced using tools like SQL, Git, and cloud platforms such as GCP, AWS, and Azure.
  • Collaborated effectively with both internal and external stakeholders to facilitate decision-making and implement strategies that propelled project advancement. Bridged the gap between technical and non-technical teams, aligning data insights with strategic business objectives.
  • Led the development of standardized data assets and was responsible for providing comprehensive documentation, quality control, and training to the team. This initiative significantly elevated job quality and resulted in a remarkable 50% improvement in team efficiency.
  • Successfully collaborated with clients and internal teams, encompassing both technical and non-technical backgrounds. Utilized strong communication skills to navigate intricate technical and business discussions, effectively driving project delivery and aiding clients in strategically achieving their business objectives.

Consultant, Data Analytics

PwC Australia

Sydney, Australia

2021 June - 2020 Jan

  • Worked on data analysis and visualisation, and bring data analytic techniques to bear on a wide variety of problems.
  • Developed and maintained easy-to-use product and provided training and documentation for both internal and external parties.

Finance Analyst

The University of Sydney

Sydney, Australia

2019 Dec - 2019 Aug

  • Designed, developed and maintained standardized budget/forecast models, tools and guidelines to improve the accuracy, consistency, timeliness and quality of budgeting and forecasting throughout the Faculties and these are continued to be used across the University faculties.

Data Analyst

Travelzoo

Sydney, Australia

2019 Aug - 2018 Dec

  • Built and maintained quarterly/monthly dashboard for different countries and provided ad-hoc support which provided strategic measurements for management.

Junior Financial Analyst

UBI Logistics (Australia) Pty Ltd

Sydney, Australia

2018 Sep - 2017 Aug

  • Developed a procedure to analyse data, identify discrepancies and design reporting mechanism, which allow on-time and accurate measure of the company performance. This procedure is still utilized and has been able to recover more than 120,000 AUD in the past 1 year, which otherwise would be lost because of the information inaccuracy.

Professional Development/Projects

Full Member (3088357)

Chartered Accountants ANZ

N/A

Present - 2023 Mar

CFA Level 1

CFA Institute (link to certificate)

N/A

Present - 2018 Aug

Alteryx Core Certificate

Alteryx (link to certificate)

N/A

Present - 2020 Jan

Pyfwc

(link to project)

N/A

N/A

  • A Python library provides wrapper around Australian Fair Work Commission API.