GARY GUIZHAO WANG
Data Analyst
Eight Mile Plains,QLD
Summary
Motivated and results-driven Data Analyst with proven track record in data analytics and process mapping. Identifies business needs and develops valuable solutions to improve accuracy and process optimization. Drives business success with recommendations based on data findings.
Overview
5
5
years of professional experience
8
8
years of post-secondary education
Work History
Data Analyst
MSPHU COVID Respond
Forensic & Scientific Services (FSS), Metro South Public Health
10.2020 - Current
- Participated in requirements meetings and data mapping sessions to understand business needs and built logical templates for real-time needs of reporting and data collection.
- Created various Excel documents to assist with pulling metrics data and presenting information to manager for concise explanations.
- Wrote Excel Macro scripts and advanced Excel functions to validate and adjust data from complex clinical source data such as NOCS and DCoVA effectively while remain high level of accuracy.
- Developed over 10 working files for organizational systems and subsystems to improve and streamline data collection and reporting.
- Successfully interpreted data in to draw conclusions such as “Epi Summary” for managerial action and strategy.
- Synthesized current business intelligence data to produce periodical reports and polished presentations such as COVID Case Dashboard.
- Constantly share ideas and knowledge with co-workers on data analysis, design and information flow to improve data management, monitored use and suggested improvements.
Assistant Finance Officer
PAH Finance Services
PA Hospital, Metro South Health
12.2019 - 10.2020
- Worked closely with admin officer to prepare accounts and documentation as well as conduct audits according to all regulatory requirements regarding Study Education and Research Trust Account Funding Scheme (SERTA).
- Conducted detailed validation and recordkeeping of SERTA staff claim and travel request and offered advice to stakeholders to meet regulatory compliance and standards requirements.
- Maintained and recorded SERTA, Gift & Benefits and Central Loss registers to monitor and report company actions to key stakeholders periodically.
- Prepared and reviewed various journals and implemented corrective action to ascertain 100% accuracy of ledger posting.
- Produced reports and perform reconciliation for internal and external stakeholders periodically including trust and research, PTSS and SERTA.
- Provided advice to other stakeholder on Financial accounting procedures to make sure certain processes are done in specific ways to minimize errors and losses.
- Designed new templates and working files such as S/4 journal preparation template for standardizing and enhancing current policies and procedures to increase productivity and minimize possibility of errors.
Assistant Finance Officer (Asset)
Metro South Finance Services
Garden City Office Park, Metro South Health
07.2017 - 07.2019
- Supported monthly reporting analysis to achieve validation of internal reports and to reconcile non-current asset register to general ledger
- Conducted detailed technical and analytical review of 17 expense GLs and over 10,000 non-current assets monthly and resolved coding, categorizing, and other financial issue.
- Prepared and processed asset transactions and General Ledger journals into S/4 Hana (was FAMMIS) with 100% accuracy.
- Responsible for Inter-entity reimbursements and prepared Inter-entity journals, reports and supporting documentation for full compliance with FMPM.
- Assisted with information for Annual Financial Statements and completed audit queries by thoroughly documenting day-to-day accounting processes and financial records.
- Liaise with other HHS of QH for queries regarding Asset, iPharmacy, Inter-entity and General Ledger.
- Design and developed advanced Macros-enabled Excel templates and working files such as prepayment registers to achieve better consistency, efficiency and accuracy.
Business Support Officer
DonateLife Qld Office
Organ And Tissue Donation, PA Hospital, Metro South Health
06.2016 - 07.2017
- Used FAMMIS and DSS to prepare documents, reports and presentations for business manager monthly including revenue, expenditure, HR and budget.
- Perform monthly comprehensive activities and account assessments across different periods and budget to identify possible issues and profitability of business operations
- Assisted Business Manager for full business operation with thoroughly preparing, gathering and validation documentations including journals, procurement, business case and HR data.
- Managed and tracked Commonwealth funding of DLQ office and distribute across different HHS in Queensland Health.
- Designed new operational database using Microsoft Access for accurate and comprehensive internal managerial reporting, which appreciated by business manager.
Finance Intern
Metro South Finance Services
Garden City Office Park, Metro South Health
02.2016 - 06.2016
- Acting assistant finance officer role and hands-on variety of tasks including GL reconciliation, prepare and processing journals, GPV, asset reporting and help with financial statement.
Education
Certified Public Accountant (CPA) -
CPA Australia
Pending Result Of Last Subject 07.2017 - 12.2021
Master of Business - Professional Accounting
QUT
Gardens Point Campus 02.2014 - 07.2015
Bachelor of Business - Finance
Queensland University of Technology
Gardens Point Campus 02.2012 - 12.2013
Skills
Manipulating, cleansing, and processing data using Excel, Power BI and SQL
Asset management – perform transactions, reporting, reconciliation, revaluation and stock take
General Ledger - journal process and preparation, various reporting and GL reconciliations
Proficient in use of Microsoft Office Software Package, with enhanced knowledge of VBA (Visual Basic for Application) programming, complex Excel formulas, advance formatting and effective data analysis
Update and recreate FAMMIS reports and configure various new reports and templates for S/4 HANA
Work with great care and attention to detail with exceptional efficiency
Referees
Bonnie Macfarlane
Advanced Epidemiologist, Metro South Public Health Unit
07 3156 4044
Bonnie.Macfarlane@health.qld.gov.au
Paula Colhoun
Senior Finance Manager, Finance Service PAH
07 3176 2968
Paula.Colhoun@health.qld.gov.au
Timeline
Data Analyst
MSPHU COVID Respond
10.2020 - Current
Assistant Finance Officer
PAH Finance Services
12.2019 - 10.2020
Assistant Finance Officer (Asset)
Metro South Finance Services
07.2017 - 07.2019
Certified Public Accountant (CPA) -
CPA Australia
07.2017 - 12.2021
Business Support Officer
DonateLife Qld Office
06.2016 - 07.2017
Finance Intern
Metro South Finance Services
02.2016 - 06.2016
Master of Business - Professional Accounting
QUT
02.2014 - 07.2015
Bachelor of Business - Finance
Queensland University of Technology
02.2012 - 12.2013