Main
Frank Zhang, CA
- Seasoned data analytics/engineering expert and chartered accountant, boasting six years of experience in harnessing data for critical business insights and strategic decision-making.
- Proficient in the realms of data warehousing, ELT processes, data analysis, visualization, and crafting insightful business intelligence reports.
- Exhibits a robust blend of sharp analytical skills and business savvy, adept at addressing complex business challenges in collaboration with non-technical teams.
- Proven leadership abilities in steering data-focused teams and forging effective cross-functional collaborations.
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
Pyfwc
N/A
N/A
- A Python library provides wrapper around Australian Fair Work Commission API.