Summary
Overview
Work History
Education
Skills
Curricular Certifications
Timeline
Generic

JIAYI (JEN) MAO

Dundas,NSW

Summary

Recent Master of Professional Accounting graduate from UNSW Sydney, with a robust foundation in Accounting and Finance. Demonstrated expertise in financial auditing and project management through internships at EY China and Asia Pacific Group CPAs, showcasing exceptional analytical, organizational, and leadership skills. Adept in creating advanced VBA programs to enhance auditing processes, with a proven track record of improving team productivity. Fluent in English and Mandarin, with advanced proficiency in programming languages including VBA, SQL, and Python. Eager to contribute to team success through administrative and project management support, leveraging outstanding interpersonal and critical thinking abilities.

Overview

1
1
year of professional experience

Work History

Intern

EY China (China Universal Asset Management team)
Shanghai, China
12.2022 - 04.2023
  • Leaded the bank confirmation process, demonstrating exceptional organizational skills
  • Acted as a pivotal communication link between the Global Delivery Services (GDS) team and banking institutions, ensuring timely updates and progress tracking
  • Elevated to the position of Team Leader for interns, responsible for meticulous oversight of my peers' work, ensuring accuracy and efficiency in all tasks
  • Developed and implemented advanced VBA programs, significantly enhancing the auditing process
  • This initiative, taken upon the Senior Manager's request, led to the creation of automated tools for generating Balance Sheets for 279 funds, and the preparation of comprehensive working paper H
  • Enhanced streamlining workflow and increased productivity within the team
  • Received FIC rating 5/5.

Intern

Asia Pacific (Group) CPAs (Special General Partnership)
China
07.2022 - 09.2022
  • Responsible for managing the cash equivalent section in a high-profile due diligence project
  • Demonstrated meticulous attention to detail by thoroughly checking each bank account for accuracy
  • Proactively engaged in sending out confirmations and maintaining clear, effective communication with banks to ensure the integrity and accuracy of financial information.

Education

Master of Professional Accounting - Professional Accounting

UNSW Sydney
12.2023

Bachelor of Engineering - Electrical Engineering

McMaster University
06.2021

Skills

  • VBA
  • SQL
  • Java
  • Microsoft Office
  • MATLAB
  • Python
  • [English] Proficient
  • [Mandarin] Native

Curricular Certifications

  • PwC US Audit Job Simulation on Forage, Completed a job simulation focused on control testing of a client's purchasing process for PwC's Audit team, Compiled thorough walkthrough documentation including findings, Outlined the purchase process in a flowchart and risk control matrix
  • KPMG U.S. Career Catalyst: Audit Job Simulation on Forage, Completed a job simulation focused on conducting an audit for a hypothetical client, Ashbourne Industries., Determined the materiality of general ledger accounts to plan the audit., Prepared, sent, and evaluated the results of confirmations sent to third parties., Reviewed the client's order-to-cash (OTC) process., Communicated the audit findings via a video presentation and reviewed the audit opinion.
  • Microsoft Office Specialist: Excel 2019 Expert, Expert-level proficiency in Excel, validated by a globally recognized certification.

Timeline

Intern

EY China (China Universal Asset Management team)
12.2022 - 04.2023

Intern

Asia Pacific (Group) CPAs (Special General Partnership)
07.2022 - 09.2022

Master of Professional Accounting - Professional Accounting

UNSW Sydney

Bachelor of Engineering - Electrical Engineering

McMaster University
JIAYI (JEN) MAO