Data Analyst – Gst Investigations, Revenue Management, Data Transformation
- 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.
- 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.
- 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.
- 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.