Amy Wills Email & Phone Number

Melbourne, Vic, Au

Melbourne, Australia

Extracts, transforms and interprets data to provide analysis and insights on strategic operational performance to enable and influence business decisions.Key Achievements:> Winning a Spark award for the analysis of unstructured text, which increased productivity and accuracy in the analysis of incident data. > Re-designing the process for data delivery to stakeholders which resulted in all data being provided by the Chief Data Office two weeks earlier than it was previously. > Creation of weekly Tableau charts to monitor key headline metrics and act as a trigger for deep dive analysis. > Analysis to identify locations where a high percentage of end users were marked 'not in attendance' for appointments to identify possible field technician issues.> Analysis and alignment of metrics which were being reported by different areas of the business with differing results.

Melbourne, Australia

Captures, interprets and analyses data sets across multiple information systems to provide commercial and analytical insight and recommendations to enable the business to make strategic decisions to improve business performance and customer experience.Key Achievements:>Designing, creating and maintaining a weekly Retail Operations Dashboard for the Chief Operating Officer to summarise key departmental metrics.> Analysis and categorisation of customer detractor feedback, identification and presentation on ideas for process improvements to create a more frictionless customer experience based on this feedback. > Improvement of Net Promoter Score results reporting by using data integration techniques to link SQL database to Excel and automatically cleaning and transforming data. > Analysis of customers on paper billing vs e-billing, presented findings and suggestions as to how to encourage existing customers to sign up for e-billing and the resulting cost savings.> Business partnering with department team leaders to re-build existing reports using automation techniques to gather data from various sources resulting in quicker and more insightful reporting.

Melbourne, Australia

Measure, forecast and provide actionable insights into the net retail margin performance of the business. Involves strategic planning, building financial models and business partnering.Key Achievements:> Built and maintained a new 5 year rolling forecasting and budget model of Commercial & Industrial Gross Margin using best practice financial modeling. > Built a financial model to forecast the impact that reducing prices for current customers in an aim to reduce customer churn would have on company profitability. > Reduced the time taken to produce the month end result by 5 days through conducting a major review of the existing processes and implementing improvements. > Developed and delivered customised Excel training to colleagues to improve efficiencies.> Acted as the Subject Matter Expert for the retail side of the business for the SAP implementation and influenced how the forecasting and budgeting modules were created.

Melbourne, Australia

Monthly financial reporting and variance analysis, coordinating the company-wide KPI Pack, forecasting, annual budgeting, cost analysis, board reporting encompassing business wide performance metrics.Key Achievements:> Built a Return on Investment financial model which assesses proposed marketing campaigns across key financial metrics encompassing cash flows and profitability. This model enabled the company to evaluate the effectiveness of marketing campaigns for the first time.> Transformed the KPI Pack process from entirely manual to automated. This involved stakeholder engagement, liaising with IT developers, User Acceptance Testing, Implementation, Training and Change Management.> Improved the accuracy of Momentum’s Cost to Acquire and Cost to Serve allocations across market segments which involved gaining cost centre managers’ input to determine the most accurate method of allocating their costs across market segments.> Improved the forecasting methodology and accuracy of daily cash receipt forecasting.> Creation of Mass Market Sales Report to calculate the direct cost to acquire customers by sales channel against budget and report the monthly sales against budget.

Graduate Diploma Of Chartered Accounting

Bachelor Of Business & Commerce (Accounting)