Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Stella Li

Summary

I have strong interest in working in the field of equity research. I love analysing stocks and companies' financials and I am an avid investor myself. I have very strong excel operational skills gained from my previous jobs. I have solid understanding of three major financial statements. I have knowledge of financial modelling, i.e., Discounted Cash Flow, forecasting models, as well as good report writing skills. Finishing my CA in March 2024, I am also doing CFA level 1 at the moment. I will get CFA ESG investing certificate in November. I can use software, such as Python and MATLAB.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Senior Associate

Macquarie Group, Group Financial Reporting
03.2023 - Current
  • Very strong excel operational skills
  • Handling large data sets in the financial reporting and analysing environment
  • Engaging in Workiva and Power BI projects to facilitate group financial reporting process
  • Routine monthly consolidation process, including setting up new entities and accounts and mapping them
  • Maintaining and preparing monthly portfolio of group entities (around 2,000 legal entities), communicating with Legal Entity Controllers to ensure the accuracy of the group entities’ data
  • Preparing several specific notes of Financial Statements before the announcement day of Macquarie Group
  • Monthly investment data reconciliation and data accuracy maintenance

Associate

PwC Australia I, Financial Service
03.2022 - 03.2023
  • Identify and assess fraud risks specific to each project and tailor the testing approach to address such risks
  • Identify control deficiencies in clients' internal control systems through performing tests of controls and raise the issues with managers to revise audit plans if required
  • Identify risks arising from the use of computer-based accounting systems and evaluate the controls in place within each IT general control domain to mitigate those risks
  • Ensuring client is compliant with the various statutory reporting and compliance bodies
  • Perform substantive testing procedures to gather evidence to identify any material misstatements and assess the accuracy of information contained in the financial reports and their compliance with statutory requirements
  • Ensuring the client is a legal and going concern
  • Assist in the presentation of the Audit findings to the Audit Committee or Board of Directors
  • Comply with documentation archiving and retention requirements.

Financial Accountant

Bikebug Pty Ltd
07.2021 - 03.2022
  • Preparing and processing general ledger journals
  • Reviewing and reconciling daily revenue transactions and resolve financial queries
  • Preparation of weekly sales report and monthly profit and loss including stocktake reporting
  • Bank and credit card reconciliations
  • Reporting and monitoring of cash flow liquidity
  • Preparation of weekly payroll of more than 60 employees
  • Preparation and reconciliation of Payroll Tax
  • Preparation and submission of monthly IAS, quarterly BAS as well as New Zealand GST returns
  • Management of fixed asset register, maintain and update fleet schedule for all assets and depreciation reports
  • Work Compensation and business and liability insurance reviewing
  • Preparing tax review and tax audits to ATO
  • Looking after two Accounts Payable officers and check their weekly payments

Assistant Accountant

Rick Carson Partners
08.2020 - 04.2022
  • Completing basic to mid-level complexity Tax returns for Individuals, Partnerships, Trusts, and Companies
  • Handling AR, AP as well as bank reconciliation for clients
  • Preparing P&L and Balance Sheet for clients
  • Preparation of Financial Accounts for all types of entities;
  • Group restructuring for Tax purpose
  • Assisting clients in preparing BAS, IAS and GST, FBT, payroll Tax
  • Providing proactive advice
  • Completing company, unit trust, family trust registration

Education

Master of Commerce - Quantitative Finance and Accounting

The University of Sydney

Skills

  • Microsoft Excel
  • Effective Time Management
  • Strong Oral and Written Communication Skills
  • Strong Analytical Skills
  • Planning and Organising
  • Microsoft Office
  • Teamwork
  • Multi-task Handling
  • Critical thinking
  • ERP Systems
  • MATLAB
  • Python

Certification

Provisional member - Chartered Accountants Australia and New Zealand

Timeline

Senior Associate

Macquarie Group, Group Financial Reporting
03.2023 - Current

Associate

PwC Australia I, Financial Service
03.2022 - 03.2023

Financial Accountant

Bikebug Pty Ltd
07.2021 - 03.2022

Assistant Accountant

Rick Carson Partners
08.2020 - 04.2022

Master of Commerce - Quantitative Finance and Accounting

The University of Sydney

Similar Profiles

CREATE PROFILE
Stella Li