Aside

Contact

Download as a PDF


Coding


Visualization


Strength

Disclaimer

Made w/ pagedown.
Source code: Github repo.

Last updated on 2020-07-29.

Main

Dingrui(Frank) Zhang

Business Analyst | R Developer

I enjoy working with data to solve business problems and build tools that help people. My favorite part of working in data science is the constant opportunity to learn, from statistics and software development to real business problems.

Education

Master of Professional Accounting

University of New South Wales

Sydney, Australia

2019 - 2017

Exchange Student Program (Major in Accounting)

University of New South Wales

Sydney, Australia

2017 - 2016

  • Achieved Overall Distinction WAM

Bachelor of Management (Major in Accounting)

Hebei University of Economics and Business

Shijiazhuang, China

2016 - 2013

  • Achieved Overall WAM of 80

Professional Experience

Consultant, Data Analytics

PwC Australia

Sydney, Australia

Present - 2020 Jan

  • Worked on data analysis and visualisation, and bring data analytic techniques to bear on a wide variety of problems. Worked on tight (1-3 month) timeframes to deliver bespoke work on Data Analytics to clients.
  • Utilised advanced BI tools(Power BI, Qlik Sense and Alteryx) to analyse large volume of complex data and present findings to business users in a clear and simple way
  • Provided clean documentation of complex workflows ,code scripts as well as business processes. The documentation helps reproducible work and quality control.

Finance Analyst

The University of Sydney

Sydney, Australia

2019 Dec - 2019 Aug

  • Improved reporting pipelines utilising VBA , SmartView and R to automate processes and provide high-level quality controls.
  • Migrated monthly financial reporting dashboards from excel-based to Power BI. The migration saved more than 50% time comparing with excel-based method
  • Assisted with the preparation of reconciliations of financial and operational data from different sources and provided recommendations to Finance Managers and Head of Schools
  • Assisted with providing budget and forecast for multiple stakeholders

Data Analyst Intern

Travelzoo (NASDAQ: TZOO)

Sydney, Australia

2019 Aug - 2018 Dec

  • Developed an automated program (web scraper) that identifies and stores the marketing data in database to produce the desired reports.
  • Developed multiple macros and R scripts to collect information from multiple sources(ERP, Excel, Text …), analyse data and generate report automatically. Saved more than 50% time.
  • Collected and maintained history operation database and built up weekly operation report for the whole APAC(Asia Pacific) area.
  • Provided operations support for APAC Team, for example: overseas collection deal price point conversion.
  • Built quarterly/monthly dashboard for different countries in APAC area which provided measurements for management.

Junior Financial Analyst

UBI Logistics (Australia) Pty Ltd

Sydney, Australia

2018 Sep - 2017 Aug

  • Developed a billing system based on VBA and R which supports generating billing statements, email automation and aging analysis. This system significantly freed people from heavy and routine manual work, reduced 2 FTE (Full-time equivalent) and improved collecting accounts receivable.
  • 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.
  • Built and maintained a MySQL finance database which helps finance department find discrepancies between forecast and real-time data, also responsible for designing data tables, managing permissions and setting up backups.
  • Worked as a consultant with a team of 5 co-workers from both China and Australia to establish an online invoicing system and successfully coordinated the project between finance and IT team.
  • Provided training to co-workers on program I developed and wrote end-user manual.

Professional Development

CFA Level 1 Passed

CFA Institute (Click here to see badge)

N/A

Present - Aug 2018

26 R Courses on Datacamp

Datacamp (Click here to see the list)
Courses include:

N/A

Present - 2017 Aug

  • Cleansing, Transformation and Visualization of data
  • Reporting and Visualization using Rmarkdown, ggplot2 and Shiny
  • Webscraping with R
  • Use SQL in R