Philip Davies Email and Phone Number

• Engaged to conduct the Roster Modelling Project to analyse the change in demand & utilisation levels of the ‘000’ Emergency Operation Centres operators over time• Build a rostering model with the flexible capability of doing scenario modelling to identify the resourcing needed to best cover EOC centre current and future demand.

• Designed and built the model that calculated the royalty due to the Queensland Government for all oil and gas production in Queensland• Requiring the allowance for changing royalty rates, benchmark pricing, converting unit volumes, identifying product type and allowing for the easy addition of new joint ventures.

• Built a new suite of reports and dashboards from data from the new Sales CRM system (Sugar)• Project lead for development of new reports and dashboards for Monthly results using Yellowfin BI • Produce weekly and monthly performance reports• Perform analysis of benefits claims and review benefit pricing and limits

Member of the strategic transformation project team for the New RAH

Following a detailed analysis of data from business activities, including claim frequency, sales conversion rates,customer retention rates and expenses. I build a model that presented current performance results, with the capability to show clear visualisations of key KPI's and variances. It also provided an up to the moment rolling forecast with the ability to compare to set budget.This enabled the company to quickly identify variances to Plan and take remedial action

Evaluated and implemented pricing actions for motor and home products.Continuous analysis of policy risk factors ie flood areas, fire, hail, location, age, gender, make, model, security etc., focussed on segment profitabilityFor the last 11 years i built the AAMI Budget Model for use in all statesIn 2007 I was given projects by the CEO to build models for other companies in the group, among them AAMI Business, Just Car Insurance, Bingle, APIA, Shannons and AAI NZ