John Sushames

Experience

• 

  Zodiac Training Ltd

  May 2003 - Oct 2007

  Data and Communications Director

  Installation and maintenance of all IT assetsSystems integrationProject management of website development and CRM implementation.Design, maintenance and development of the MI reporting system Management of the IT and Administration teamsDevelopment of bespoke database applications to meet the needs of the organizationInterpretation of data and development of reports to monitor and forecast contractual performance and incomeAnalysis of data trends to support strategic and operational decision makingData cleansing, manipulation and migrationLiaising with other members of the senior team and external stakeholders to identify appropriate KPI´s to monitor individual/team/organizational performance Show less

• 

  Greater Wellington Regional Council

  Apr 2008 - Jul 2013

  Systems and Information Team Leader

  Project management of Metlink website re-development (TUANZ finalist) and implementation of the mobile site.Development and implementation of Google Transit within Wellington region.Support and maintainance of specialist information systemsProvision of business analysis skills for the DivisionDevelopment and implementation of QA programme to ensure data accuracy and system integrityManagement of internal and external supplier relationshipsLeading, developing and motivating the team Show less

• 

  Student Job Search

  Jul 2013 - Dec 2014

  BI Analyst

  Development and maintenance of database and reporting infrastructureProvision of situation specific analyses to support business critical decisionsIdentification and monitoring of key organisational drivers through use of dashboard technologies.Identification of opportunities to improve data accuracy and captureDevelopment and maintenance of ETLs and stored proceduresGeneration of custom metrics reports on a daily, weekly, monthly, quarterly, semi-annually, and an as needed basis for business stakeholdersDocumentation of specifications for business intelligence or information technology (IT) reports, dashboards, or other outputsUtilise internal tools, SQL, SAP Crystal reports, SPLUNK, Excel and other reporting tools, build customs reports that will drive core business decisions Show less

• 

  Inhouse Limited

  Apr 2016 - Nov 2016

  BI Consultant

  Worked with business units within a large goverment department to identify and documentBI business requirements. Developed SQL to extract, transform and load data into theDataMart. Designed and built Business Objects Universes and bespoke reporting solutionsto meet business requirements. Trained and supported users in report development.Delivered commercial training for Inhouse Ltd.

• 

  NZ Police

  Jun 2017 - Aug 2017

  Reporting Analyst (Contract)

  Worked with the Human Resources function of New Zealand Police to gather requirementsand document reporting needs. Created a suite of SAP Crystal reports in line with businessrequirements utilising SQL based commands, installed user software and published reportswithin the HEAT incident mangement system. Documented the database structure for futurereference, created a definition of terms document, reporting catalogue and compiled aCrystal report training module.

• 

  Ministry of Social Development (MSD)

  Oct 2017 - now

  Reporting Analyst - Developed a number of key dashboards, including the MSD Operational Excellence performance dashboard and appointments reporting, both rolled out nationally. Developed an in-depth understanding of MSD appointments data to become the subject matter expert and worked collaboratively with senior developers to produce the MSD appointments data mart. Trained and coached team members in SAS EG and VA. Provided data analysis and user friendly commentary to assist in monitoring KPIs and identifying impacts or drivers of performance, alongside providing valuable insights in response to ad hoc requests for information. Show less

  • Senior Reporting Analyst

    Jun 2021 - now

  • Reporting Analyst

    Oct 2017 - now