Data Engineer

• Mar 2023 - Present

ETL Developer

• Sep 2022 - Mar 2023

HR Reporting Analyst

• May 2021 - Aug 2022

• Dayforce HCM Systems Administrator carrying out tasks related to user passwords, role security and payroll configuration. • Carrying out extensive analysis of ADP Payroll data in comparison with Dayforce Payroll data in preparation for go-live of Dayforce Payroll system for Australian employees and advising Payroll team members of any identified discrepancies. This ensures that employees are paid correctly in the first Dayforce pay run. This analysis was made possible by importing both ADP and Dayforce data into a SQL Server database and carrying out detailed SQL queries using full outer joins to compare data that existed in both systems as well as identifying employees that may have existed in 1 system but not the other. • Developing custom reports for Dayforce users with specific requirements to display data from Employee Personal Details and modules such as Payroll, Learning Workforce Scheduling and Performance. • Developed automated tasks to simplify tasks for HR team members to highlight issues such as employee anniversaries, expiring employee visas and incomplete onboarding tasks. • Developing custom SQL scripts to produce XML files which are then imported into the Dayforce system to allow bulk changes of employee data, therefore saving time spent by manual data entry tasks. Show less

Technical Product Analyst

• Apr 2018 - May 2021

Looking for new Opportunities

• Feb 2018 - Apr 2018

Senior Analyst (AO6) (Temporary)

• Jan 2018 - Feb 2018

Healthcare Purchasing and Funding Branch Healthcare Purchasing and System Performance Division Short-term contract using SQL Server Management Studio 2016 to develop SQL Server queries and stored procedures to facilitate the movement of data from SQL Server tables to AS/400 tables to enable more efficient processing of large queries and reports Healthcare Purchasing and Funding Branch Healthcare Purchasing and System Performance Division Short-term contract using SQL Server Management Studio 2016 to develop SQL Server queries and stored procedures to facilitate the movement of data from SQL Server tables to AS/400 tables to enable more efficient processing of large queries and reports

Deployment Technician

• Dec 2017 - Dec 2017

This was a brief temporary contract to assist Greenbox deployment staff with overflow work which involves the replacement of 172 Dell computers at QUT's Gardens Point and Kelvin Grove campuses. This involved the removal of existing computers and monitors, installing new replacement hardware and assisting QUT Health IT staff with the installation of replacement departmental computer image This was a brief temporary contract to assist Greenbox deployment staff with overflow work which involves the replacement of 172 Dell computers at QUT's Gardens Point and Kelvin Grove campuses. This involved the removal of existing computers and monitors, installing new replacement hardware and assisting QUT Health IT staff with the installation of replacement departmental computer image

Looking for new Opportunities

• Jul 2017 - Nov 2017

ERP Support Officer

• Jan 2007 - Jul 2017

Provide Sales Support to staff in Fone Zone and Telstra-Branded Stores Australia wide Develop SQL queries using IBM iSeries Develop SQL queries using SQL Server 2005 and 2008 Develop SSIS Packages using Microsoft Visual Studio 2005 and 2008 Schedule regular reporting using Visual Cron Excel spreadsheet development using complex formulas and Visual Basic macros to enable automation of Store and Area Targets Submission by Vita Group Retail and Area Managers. Extensive and ongoing testing of data submitted from Advanced Retail at store level to ensure it was in a compatible format for uploading into JD Edwards tables, Company Administrator for Globalsoft Spreadsheet Server users, carrying out regular installs and uninstalls of this software dependent on user requirements. Show less

Systems Administrator

• Oct 2005 - Nov 2006

Provide Technical IT Support for Hoepners Offices in Ipswich, Sydney, Melbourne and Adelaide. Provide Technical IT Support for Hoepners Offices in Ipswich, Sydney, Melbourne and Adelaide.

Microsoft Access and Excel Developer

• Nov 2001 - Oct 2005

Developed several large end user spreadsheets and databases in Excel and Access comprising large amounts of Visual Basic automation to reduce paper handling and assist with statistical record keeping Developed several large end user spreadsheets and databases in Excel and Access comprising large amounts of Visual Basic automation to reduce paper handling and assist with statistical record keeping

IT Consultant

• Jun 1999 - Nov 2001

Performed several short term contracts performing tasks such as software rollouts and Help Desk Support Performed several short term contracts performing tasks such as software rollouts and Help Desk Support

SAP R/2 Facilitator

• Aug 1996 - Dec 1998

Team leader responsible for implementation of SAP R/2 PP and MM modules within Queensland Rail's Workshops Group.Analysed Supply system master data to eliminate duplicates.Developed macros and interface between Excel and mainframe to create thousands of Material Masters quickly without the need for tedious repetitive typing.Worked closely with trades staff to develop Work Centres, Routes and Bills of Material to improve manufacturing processes and reduce both overstocking and stock shortages through Just-In-Time processes.Analysed inventory levels according to the principles of Pareto's Law. (ABC of Inventory) Show less

Production Coordinator

• 1993 - Aug 1996

Project Management on several Rollingstock construction projects,Developed and updated Gantt charts as necessary to distribute to relevant project managers and team leaders,Plant Maintenance Scheduling using MIMSResource and Production Planning using MIMSDaily Rollingstock repair surveys to determine repairs needed to Rollingstock entering the Workshops.Network Administrator for Ipswich Workshops Token Ring LAN

Production Assistant

• 1992 - 1993

Learning the principles of Plant Maintenance Scheduling, Production Planning, Inventory Management, Project Management, Purchasing from external vendors

Electrical Fitter/Mechanic

• Apr 1984 - Jan 1992

Various electrical repair and installation duties.Extensive exposure to repairs to electrical/pneumatic components for Queensland Rail's electric train fleet

Electrical Apprentice

• Jan 1981 - Apr 1984

Learning the various aspects of the electrical trade:Motor re-winding, small and large appliance repair, Rollingstock electrical repair and re-wiring