Jun Wang Email & Phone Number

North Sydney, NSW, AU

Sydney, Australia

• Constantly perform multidimensional sales analysis on courses, student status and agent performance, contributing to 5% increase of sales turnover.
• Analyse the viability of current promotions and commission offers every quarter, contributing to 3% decrease of sales with no margin or even causing loss.
• Automated Financial Approval Sheet, which streamlined the certificate issue procedure, contributing to 70% increase in the process efficiency.
• Timely reconcile and process month-end accrual journals such as sales commissions accrual, utilities and payroll expense accrual.
• Efficiently process prepayment amortisation in the month end for expenses such as CRICOS annual registration and insurance, etc.
• Prepare fixed asset depreciation schedule using excel functions such as VLOOKUP, SUMIFS and Pivot Table and post depreciation transactions.

Canberra, Australia

• Streamlined month-end procedure by automating AR ageing report, resulting in 30% increased efficiency in AR reporting and bad debt provision.
• Effectively contributed to 50% increase of the accuracy and efficiency of cash reimbursement by streamlining the expense claim form.
• Efficiently assisted supervisor with tax coding review and monthly BAS preparation.
• Assisted with fixed asset registration and depreciation schedule preparation.
• Actively monitored day-to-day accounts processing and reported suspended transactions to manager if there is any.
• Timely performed bank reconciliations on a daily basis.