Experience

National Heavy Vehicle Regulator

• Australia
• Government Administration
• 200 - 300 Employee

• Senior Data Engineer

  • Jan 2020 - Present

• Data Analyst

  • Aug 2015 - Jan 2020

  Data Analysis, Analytics, Reporting, ETL, SSMS, Azure Data Factory, Azure Analysis Services, Excel, VBA, Access, SSIS, SSRS, Power BI, Jira, data warehouse management.



Knowledge Revolution

• Owner

  • Oct 2008 - Jan 2020

  Consultant. Software Development, Databases, SQL, Access, Excel, VBA, Business Analysis, Data Analysis, ETL Consultant. Software Development, Databases, SQL, Access, Excel, VBA, Business Analysis, Data Analysis, ETL



Origin Energy

• Australia
• Utilities
• 700 & Above Employee

• Data Remediation Specialist

  • Jul 2014 - Jul 2015

  Member of the SAP team, replacing Oracle with SAP. I am in the maintenance area, involved in data remediation, validation and transformation.Working extensively with SQL, Access, Excel, VBA, Oracle SQL Developer, MS SQL Server and SAP Information Steward.

• Business Data Analyst

  • Jul 2009 - Jun 2014

  * Oracle EAMS Project (Enterprise Asset Management System). * Collecting and collating all data for loading into eAMS, validation and loading of data. Developed an Access database tool that is effectively a cut-down version of eAMS, allowing all data to be entered and validated for eAMS compatibility. The database generates load files for bulk upload to eAMS, then extracts the loaded data to validate the load. This applies to all asset, activity and preventative maintenance schedules, as well as master data.* Developed a FIFO Travel Booking System (bus and air). Provides all bookings for over 700 people.* Developed Roster applications for Spring Gully, Talinga and First Delivery.* Extraction of data from Oracle tables by SQL for analysis. Often called upon to create complex SQL scripts.* Developed a Downtime data collection, analysis and reporting system and trip reporting system.* Developed many complex macro-driven spreadsheets to enable users to perform regular time-consuming tasks with the click of a button* Developer and Trainer for Excel, Access and VBA Show less



Webbech Pty Ltd

• Owner/director

  • Jun 1996 - 2015

  Software Development, business analysis, training Software Development, business analysis, training



BP Bulwer Island Refinery

• Software Developer

  • Sep 2004 - Jul 2009

  The Refinery belongs to one of the largest private sector energy corporations in the world, and one of the six "super majors" (vertically) integrated private sector oil exploration, natural gas, and petroleum product marketing companies. BP is an extreme user of Excel. Software Developer, reporting to the Project Team manager.; Key Responsibilities Determine user requirements and functional specifications Development, automation and enhancements of Excel and Access models throughout the Refinery, many of which link to Oracle and SQL Server databases Financial and project reporting using SAP BW, automated using VBA. Develop Excel Add-In modules to view information and to look up this data live from Oracle within spreadsheet cells Create and maintain Oracle Databases. Document all project processes, including support documentation Create manuals and training material, working with the IT Learning and Development consultant Administration of all IT project financials and accounting procedures Show less



Uncle Ben's, a subsidiary of the Mars Corporation

• Process Engineer

  • May 1994 - Jul 1996

  is the largest pet food manufacturer in Australia, making canned and dry pet food. GSV is in excess of $600 million. Roles is the largest pet food manufacturer in Australia, making canned and dry pet food. GSV is in excess of $600 million. Roles



Information Services Australia

• ISA Accountant

  • Nov 1991 - May 1994

  Financial accounting Financial accounting



Service and Finance

• Plant Analyst

  • Feb 1988 - Nov 1991

  management accounting management accounting



Masterfoods Australia Percare

• Process Development Engineer

  • Oct 1984 - Feb 1988

  Design of new processes and improvements to existing processes. Design of new processes and improvements to existing processes.