This roles focus is on projects related to Oracle solutions but also include Operational Supportactivities which includes being on-call.Customers have included: Transpower, Housing New Zealand (HNZC), Z Energy, Kiwibank, Ministry of Social Development (MSD), Freightways and FlexicardsKey aspects of this role include:• Maintaining a breadth of knowledge on Oracle products and solutions, both on Cloud and on-premise.• Maintaining strong relationships with customers as well as 3rd parties and vendors is critical to the success of projects in this role.• Writing Statements of Work and contributing to RFI, RFP and RFQ responses.Projects have included: • LDAP Migrations and Upgrades from Sun One to ODSEE, ODSEE to OUD and OID to OUD.• Database Re-platforming projects using Golden Gate for minimal downtime.

This role was primarily focused on projects related to Oracle databases, but it did include operational support activities, including being on-call at times.Customers have included: New Zealand Post, IAG, Vector, Reserve Bank of New Zealand, Transpower, Accident Compensation Corporation (ACC), ARC Innovations, Advanced Metering Services (AMS), Toyota, Ministry of Justice, Department of Internal Affairs (DIA) and Inland Revenue (IRD)Projects did include:• Planning and implementing database upgrades, migrations, re-platforming, patching, licencing reviews and audits. • Designing new database deployments as well consolidated database environments to reduce on- going support costs for customers.• New Datacom customer transitions, notably Transpower and ACC• Designing, coding, maintaining and enhancing Datacom’s Oracle database monitoring solution, including integration for core Toolsets used by Datacom including Nagios, Cacti and CA Service Desk.Maintaining strong relationships with customers, other Datacom teams, both technical teams and account management teams as well as 3rd party vendors is critical to the success of projects in this role.Writing Statements of Work is a key aspect of this role, including interpreting customer requirements and aligning customer requirements with Datacom offerings.Mentoring other staff is an important component of this role, both on new Oracle technologies and best practices as well on Datacom processes.

Primary purpose of this role was to analyse and present data to the Chief Executive as well as Education and Implementation General Managers to assist with decision making for proposed changes to Education Payroll business practices.Significant changes to business practices included:• Establishment of Salary Assessment Unit – All salary assessments centralised to one Service Centre, I was involved in development processes and designing software to track salary assessments.• MoE Payroll Self Service - Development of Web Forms for Schools to enter payroll data, my role was as a Subject Matter Expert and design and development of backend processes, to consolidate data from 8 Oracle databases into a single SQL Server 2005 database, this was achieved using SQL Server Integration Services.• MoE Payroll RFP Response - The Ministry of Education issued an RFP for a complete outsourcing solution for the Schools Payroll. My role was to answer the technical questions regarding the proposed payroll product and to assist in demonstrating the payroll software at the RFP presentation to MoE made by Datacom.• Data Cleansing Project – To cleanse existing payroll data of known anomalies. I provided scripts to find suspect data within the databases as well as scripts to update this data once the correct values had been determined.

This role was primarily focused on providing information to the Marketing teams• Extraction and presentation of data and undertaking analysis to support marketing activities.• Maintain database documentation.• Define print run and mail merge specifications for Fly Buys Point Summary Packs.• Create selection files for targeted offers.• Automation of repetitive tasks.

This role was entirely project focused Projects included:Card Automation (Phase II) - Involved in scoping, development and testing of automation of leave service from a manual salary card based system to an automated system within TeacherManager. This involved analysis of payroll contracts to determine the contractual rules as well as establishing the trade and practice rules outside the contracts. Specifying the software changes required and testing them. Developed an Access 2000 Database with a Visual Basic.NET powered Intranet web page to allow capture of legacy data by Education Service Centres while development of TeacherManager enhancements was in progress. Holiday Pay Automation - The development of an Access 2000 Database to calculate holiday pay due to both Teaching and Non-Teaching Staff by extracting information from Oracle performing calculations using VBA and then inserting the results directly into the Oracle databases via SQL Plus scripts. I updated the both Teaching and Non-Teaching Holiday Pay Calculation processes to be processed entirely via Oracle PL/SQL scripts and stored procedures subsequently.Prior Period Adjustments (PPAS) - The development of a Access2000 desktop application used for making complicated payroll adjustments outside the TeacherManager and then importing the required transactions into TeacherManager to process the adjustments. These adjustments could be Salary Arrears, Tax, Student Loan or Super Refunds or converting Salary to Holiday Pay.

This role was project focused but also required me to provide• Technical and operational support to the Education Service Payroll Centre.• Suggest efficiency enhancements.• Provide analysis.• Evaluate and make recommendations for system improvements.• Develop in-house systems• Document and maintain in-house systems.• Suggest ways to migrate in-house systems into the core payroll system.Routine tasks included• Validating Software Problem Reports.• General testing of new TeacherManager and Datapay releases.• Analysing problems experienced by end users.• Advising workarounds and specifying changes to TeacherManager and/or Datapay to rectify issues.• Planning and implementation of new TeacherManager releases.• Implementation of new collective agreements, both the analysis to determine what impact they have on the Education Payroll and specification of any program changes required as a result as well as processing the Rate Increases and Arrears for employees party to new collectives.Projects included:E-Relievers - Development of an Excel Spreadsheet to be used by schools to enter salary payments to day to day relievers and leave taken by staff which validates the entries and creates a file that is sent to Education Service Centres and Imported into TeacherManager.Manual Pay Application - Development of a Access 2000 desktop application to process Manual Pays and Manual Pay Runs for previous financial years. This application interacted with the TeacherManager, the Oracle databases and the Datapay Payroll Engine. It created an EMS Adjustment File for IRD and validated transactions to ensure there validity.Card Automation (Phase I) - Tested changes to TeacherManager made to facilitate the automated calculation of Salary Service. Prior to this project Salary Service was manually calculated and stored on salary cards. Provided feedback to development team on changes as well as suggesting solutions to the project manager as issues arose.

This role was providing technical support to the over 40 Payroll Officers that processed the Ministry of Education’s Teachers Payroll for all Primary Schools north of Taupo.• Responsible for 1st level technical support of all systems.• Liaising with Primary Teacher Payroll provider Datacom on system improvements • Maximising system productivity.• Performing database queries from Oracle using InfoMaker and Microsoft Access.• Relied on for both technical expertise and payroll knowledge.• Automation of repetitive manual tasks.Significant Accomplishment:The development of a Microsoft Access Reporting Database, known as “Process Logs” that reported on data changes made within the core Teacher’s payroll application “TeacherManager” between defined periods, it was used daily to check integrity of data entry by 40+ Payroll Officers at Multi Serve from mid-1998, and was shown to improve the overall accuracy of the payroll significantly. Process Logs were adopted by the other 3 Education Service Centres, within 2 years, taking the number of daily users to over 120 and continued to be used until August 2012, when the Teacher’s payroll service transitioned to new provider.