Mark Wu Email & Phone Number

Sydney, Australia

Lead technical specialist in resolving a series of long-running material financial incidents and risks in the Advice, Trustee, and AMP Life businesses. Development of data models to support detective controls in complex multi-system data. Verification of data transformation project artefacts.Responsibilities:• Developed adviser single practice ETL model for group payroll tax analysis purpose that derived from multiple sources including Salesforces, Peoplesoft ledgers, payment system, ASIC & ATO records. The SQL informatics script driven report was in a customised data warehouse way (layer 2) that refreshed automatically in AWS Redshift Dbeaver.• Subject matter expert on revenue & finance data in the internal data transformation project - Advice Data Layer and My-Insight BI Dashboard, including data quality verification, lineage reconciliation, and data view design.• Development of models to support the Mergers & Acquisition teams in managing buyer value delivery.• Developed licensee payment Data Models using SQL and Get & Transform (Power Query) for the identification and management of unclaimed GST & invalid GST claims working with Finance, Tax and Business teams.• Analysis and models to support substantial reduction of balance sheet liability and the corresponding recognition of profit in business P&Ls.• Development of key control reporting to support the required outcomes from the Banking Royal Commission and ASIC Breach notices in respect of payee & revenue management.Achievements:• Developed the Licensee GST data model to assist the group finance & taxes to bring down the XXM $ provision & Risk (over-claimed GST due to issuing RCTI to the non-GST registered practices) to XM $. • Developed the business data to the GL data reconciliation process that has identified XM $ under claimed input GST credits due to GL mapping process inconsistence. • Created robust process that supported the adjustment of XXM $ overstated liability into P&L.

Sydney

Responsibilities:• Annual statutory reporting, incl preparation of A-IFRS statutory TB from the book of US GAAP, disclosure notes preparation; liaison with auditor; and ASIC Submission. • Handling tax effect accounting; corporate tax pack; preparation & liaison with EY for income tax return, true-up prior year tax matters, and transfer pricing reporting. Responsible for FBT, BAS, Payroll tax, and ESS (employee share scheme), including thorough working paper and backup, complex reconciliation, and troubleshooting for variance, etc.• 2IC for the month end close and the on-time deliverables of all monthly reporting to UK by strict deadline. Achievements:• Enhanced the internal control and process improvement that resulted in obtaining highest grade from the group internal audit team.• Streamlined the month end close process that reduced the closing time from 4 days to 2.5 days. Ontime submission of the annual ASIC reports and tax return to ATO.• Reconciled the payroll accounting to the ADP Payroll system generated ATO annual group certificate that enhanced accuracy. Automated a high-volume cash journal process that reduced processing time from 8 hours to 1 hour.

North Ryde, Nsw, Australia

Covance is a NYSE listed comprehensive pharmaceutical development services companies with operations in more than 60 countries and employees over 10,000 worldwide. Its APAC operation covered Australia, Singapore, Hong Kong, Japan, Malaysia, and India, with annual turnover of 40M USD.Started as financial accountant, then was promoted into senior financial accountant. I have participated in various ad-hoc projects in this fast-paced global corporation, including financial analyst for 6 Sigma operation improvement project; ERP PeopleSoft implementation; asset management outsourcing into Genpact in India; project accounting for 20M new laboratory in Shanghai; and secondment as payroll specialist. I left Covance due to redundancy as the APAC finance function was relocated from Sydney into Singapore.

North Ryde, Nsw, Australia

Preparing regional financial reports. Responsible for annual budget preparation and monthly-consolidated Actual vs. forecast review. Handled GL reconciliation. Prepared BAS, FBT, annual audit, statutory reporting and tax.

Sydney, Australia

Start-up and supervise shared service AP functionality for five hotels. Responsible for monthly financial reporting, balance sheet reconciliation, and BAS return.

Brookvale, Nsw, Australia

Responsible for monthly P&L and balance sheet statement. Maintain cost/inventory system. Generate sales analytical reports. Managed payroll for Australia, New Zealand, Singapore, and Hong Kong.

Business, Accounting, Credit

Master Of Business, Business, To Be Completed