Sara Johnson

Experience

• 

  Motorlaw

  Feb 1998 - Dec 2000

  Legal Panel Liaison Officer

  Handling the administration of road traffic accident claims from instruction through to completion. Including liaison with the solicitor instructed and client where further details were required. Management information including a variety of reports for the board of directors showing allocation of claims to solicitors. Compiling client and solicitor letters.

• 

  The Accident Group

  Jul 2001 - May 2003

  Report Writer/Senior Sales Administrator

  Responsible for the budget tracking of 6 satellite offices based around the country. Liaison with the Regional Sales Managers of each to ensure the budget set by the External Sales Director where adhered to. Management of headcount budget for the Regional Offices and Administration Department which involved ensuring that company procedures regarding recruitment were followed accurately.Collation of External Sales team statistics and presentation of the same to the External Sales Director. Compilation and presentation of historical statistics.Calculation and processing of monthly commission payments for each of the Regional Office sales staff (approximately 1500 people).Writing and delivering Microsoft Excel training to the Administration Department.Writing and compiling “disaster recovery file” for the Administration Department and Regional Offices. Show less

• 

  Price Waterhouse Coopers- PwC

  May 2003 - Jul 2003

  Retained by Price Waterhouse Cooper following The Accident Group Liquidation

  I was named by the board of directors as a staff member to be retained following the liquidation of The Accident Group and my subsequent redundancy. On board for 3 months I assisted with the administration involved under Price Waterhouse Cooper

• 

  Broadcasting Support Services

  Jul 2003 - Nov 2011

  Management Information Reporting Analyst

  Responsible for the businesses internal management information and external client reports. Manipulation of the call telephony and CRM data (using Microsoft Query and MSSQL) to retrieve data and then produce various reports including in depth telephony data from the Avaya telephony data, caller demographics and reports to identify trends for the senior management team and funding partner. These reports were in Excel format and where appropriate VBA Code written for automation.Liaison with the Development Team including making suggestions for CRM development to improve data capture and reviewing telephony vectors to ensure contractual reporting requirements can be met.Continuous monitoring of the business KPI’s to ensure targets are met on a monthly basis.Compilation of call centre advisors team statistics to identify shortfalls in performance and reporting of such to team managers. Show less

• 

  The West Australian

  Feb 2012 - now

  Leading a team of 4 we are responsible for a variety of ETL processes to enable the business to access accurate data from all areas in one location using SSIS and Snowflake. Responsible for the management of Power BI Workspaces for the business, development of Power BI reports and dashboards and working closely with various departments to ensure their data requirements are being met. Also heavily involved in Operational Processes around the business and system administration of our circulation and publishing system. Show less Working on a project implementing a new circulation system I was responsible for the system set up and, later, the data migration process for The West Australians home delivery subscribers. During its development stage, I was also involved heavily in business process mapping for both existing and “to be” business processes in relation to the system changes and their impact to the Circulation department.Following the system implementation, I have been heavily involved in designing, developing and maintaining a process for integrating our subscriber services website and the new system which involved working closely with the departments Analyst Programmer and System Administrator.I have identified and developed a suite of reports using SQL, Excel and VBA to make live, refreshable reports with real time data accessible to the department. Show less

  • Data & Insights Manager

    Aug 2022 - now

  • Data and Reporting Team Lead

    Dec 2017 - Sept 2022

  • Data Analyst/Report Writer

    Jul 2015 - Dec 2017

  • Subscriber Analyst

    Feb 2012 - Jul 2015