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.• Assist with P&L variance analysis, providing insight to both favourable and unfavourable variances and the drivers behind them. • Review revenue recognition, posting adjusting entry for deferred revenue within expected time frame.• Review tax coding and prepare monthly BAS instalments on a timely basis. • Assist with financial statements preparation and forecasting.• Effectively adjust provision for refund in the year end by analysing visa-refused rates of the latest 3 months and figures of last year same period.• Process payroll fortnightly for 42 employees within one day. • Provide oversight and direct supervision of the accounts payable officer and 3 accounts receivable officers in different locations.• Effectively communicate with agents and vendors for financial enquiries.• Other ad hoc duties and reports.

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. • Processed credit cards and petty cash reconciliation. • Processed vendor bills and sales invoices to MYOB system accurately within expected time frame.• Processed payroll fortnightly for 10 employees in a timely manner.• Efficiently communicated with internal and external stakeholders.• Worked as part of a team to address inconsistencies between records, demonstrating excellent detail-oriented and analytical abilities.• Actively handled general enquiries in a timely manner.• Professionally handled and documented master files of stakeholders including clients, vendors and employees.• Other ad hoc duties.