Experience

RASSURE

• Australia
• Airlines and Aviation
• 1 - 100 Employee

• Senior Data Analyst

  • Sep 2021 - Present

  Software development via the use of Excel, VBA and SQL to identify violations in airlines fare rules and ticketing processes: - Translating complex airline industry rules and codes to Excel and VBA programs, functions and formulas - Optimisation of existing Excel/VBA models - achieving 10 times performance improvements in calculation time - Creation and implementation of Excel and VBA best practices across the organisation Software development via the use of Excel, VBA and SQL to identify violations in airlines fare rules and ticketing processes: - Translating complex airline industry rules and codes to Excel and VBA programs, functions and formulas - Optimisation of existing Excel/VBA models - achieving 10 times performance improvements in calculation time - Creation and implementation of Excel and VBA best practices across the organisation



NSW Trustee and Guardian

• Australia
• Government Administration
• 200 - 300 Employee

• Financial Analyst

  • May 2021 - Aug 2021

  In-house analyst to undertake ad-hoc projects including: - New Product Rollout pricing and invoice generation - model rolled out to all NSWTG client service centres - Optimisation of staff resources - Finding optimal number of resources to maximise productivity across the department - Error Tracking and Risk Weighing - creating quantitative risk matrix to identify at risk clients In-house analyst to undertake ad-hoc projects including: - New Product Rollout pricing and invoice generation - model rolled out to all NSWTG client service centres - Optimisation of staff resources - Finding optimal number of resources to maximise productivity across the department - Error Tracking and Risk Weighing - creating quantitative risk matrix to identify at risk clients



CL Commodities

• Australia
• Farming
• 1 - 100 Employee

• Financial Analyst

  • Apr 2020 - Aug 2021

  Creation of bespoke tools including: - Logistics optimisation - Deriving optimal freight logistics Australia wide - Commodity Arbitrage - Identifying arbitrage opportunities in Australian grain markets - Export Pricing Models - Pricing domestic commodities for international exportation - Freight Cost Calculator - Calculating cost of freight Australia wide using Google Maps API Creation of bespoke tools including: - Logistics optimisation - Deriving optimal freight logistics Australia wide - Commodity Arbitrage - Identifying arbitrage opportunities in Australian grain markets - Export Pricing Models - Pricing domestic commodities for international exportation - Freight Cost Calculator - Calculating cost of freight Australia wide using Google Maps API



Forecast

• Australia
• Information Services
• 1 - 100 Employee

• Financial Analyst/Data Analyst

  • Aug 2018 - Mar 2020

  Creation of bespoke best-practice financial models for clients in the mining, solar and traditional energy and renewable energy industries: - Cash flow modelling - Reporting and forecasting - integrating historical and forecasted financial data - Project feasibility modelling - Three-statement models - Modelling of PPA contracts In addition, other data projects included: - Secondment to the UK's largest pay-TV broadcaster to assist with customer segmentation analytics - Time series modelling using ARIMAX for one of Australia's largest fuel retailers - Geospatial analysis of the NSW fuel market - Creation of automated quotation estimator tool Show less



SGS Economics and Planning

• Australia
• Public Policy Offices
• 1 - 100 Employee

• Economic Consultant

  • Jul 2016 - Aug 2018

  Economic and financial analysis of large scale, high cost government infrastructure related projects. Analysis included: - Economic and Financial Appraisal's (Cost-Benefit Analysis, Economic Impact Assessments, Operating models ) of the redevelopment of schools, recreation and leisure facilities, new transport infrastructure - Retail supply and demand modelling - Transport impact modelling - Demographic profiling and forecasting - Data analysis and visualisation - economic, demographic and spatial data - Machine Learning and Statistical/Econometric Modelling - clustering algorithms and multinomial logistic regression Show less



Western Sydney University

• Australia
• Higher Education
• 700 & Above Employee

• Research Assistant

  • Nov 2013 - May 2014

  - Researching and collating data from a variety of sources - Analysing and interpreting data - Compiling data and structuring reports - Researching and collating data from a variety of sources - Analysing and interpreting data - Compiling data and structuring reports