Data Engineer
01.2021 - 07.2023 |IAG
Data Integration SQL Server, Greenplum
Involved with a number of data integration projects to identify, analyze and
combine data from many sources into standardized formats. The project
involved two major phases. The first analyzing data from multiple source
systems and creating a standardized format to allow high level use of the data on SQLServer databases.
The second was building on the first set by finding additional attributes to fill
out the data for more general use on a Greenplum database.
ETL Developer
10.2019 - 12.2020 |Stats NZ
Pentaho ETL tools
This contract involved being part of two different teams involved in two projects main projects utilizing Pentaho ETL tools to move and re-shape data between multiple systems.
- The first project for the purposed of reporting.
- The second to populate an online system then retrieve and setup data for analysis.
Consultant Developer
07.2017 - 01.2018 |Kathmandu
SQL Server, Dynamics AX , C#
Design and build a module to interface with an existing Dynamics AX warehouse module to speed up data prepration of work instructions to the warehouse.
BI Consultant
02.2017 - 12.2017 |Fulton Hogan
SQL Server, C#, BizTalk
Contract role to design and develop database and interface for third party front end.
Consultant Developer
02.2016 - 02.2017 |Farmlands Co-operative Society Limited Consultant
SQLServer, BizTalk, SharePoint, C# .Net, SQL, java, aspx
- Consulting and Development including BizTalk/SharePoint systems.
- Integration and SQLServer development.
BI Consultant & .Net Development
09.2014 - 08.2015 |PGW
ASP, .net, jquery, SQLServer, EPIServer
Consultant for Intergen for PGW.
- BI using WhereScape Red & SQLServer Consultant for Intergen at Farmlands Christchurch on a system integration project.
- BI using WhereScape Red & SQLServer
- asp.net web development - new features for existing web site.
ETL Specialist
03.2014 - 07.2014 |Synlait Milk Limited
ETL, SQL
- ETL design and implementation of SQL Server based multi system integration.
BI Consultant
04.2012 - 06.2013 |IAG New Zealand
ETL, SSAS
Lead contract role in the merging of data from a major legacy system with a new replacement system to get an integrated ETL and BI solution. My role was to architect the solution, work on integrated data warehouse and data mart models, then design the Microsoft SSAS cubes to be used. Team leadership and mentoring were also key parts of my role here. Agile and scrum environment.
Microsoft Application Developer
09.2011 - 03.2012 |AMI Insurance Company
SQL, C#, Silverlight, MVVM
Working with the Microsoft development team within AMI to enhance legacy systems.
Primary technologies used were SQL databases and Visual Studio development environment including C#, Silverlight, MVVM and web services.
Architect Developer
09.2010 - 06.2011 |Statistics New Zealand
SQL Server, Silverlight, SSAS
Attached to a small business unit to cover people on leave and determine architectural needs.
This role included:
- Analyse needs.
- Improve data design and convert data (SQL Server 2008).
- Design and implement initial front end portal (Silverlight).
- Design and implement BI cube prototype (SSAS).
- Agile and scrum environment.
Business Intelligence consultant
07.2010 - 09.2010 |Statistics New Zealand
.
This position was offered in order to extend BI training to internal staff and introduce some advanced BI features. It allowed me to focus solely on this area in order to complete a set of earlier identified features that would improve performance and functionality of the Microsoft Cubes used in BI.
Census Solution Architect / BI Architect / Scrum Master
06.2008 - 06.2010 |Statistics New Zealand
.
Initially contracted for 2011 Census IT strategy development, then retained as Census Solution Architect overseeing the upgrade, integration and delivery of the many systems required for the end-to-end collection, process and dissemination of the census. As a BI specialist with Microsoft cubes, data is able to be aggregated is such a way as to delivery versatile, timely, accurate analysis and outputs.
Using agile techniques across different multi-discipline teams has proved to be a key success factor of the programme.
Roles included:
- Strategy development.
- Staff selection & team formation.
- Solution Architect/Technical Team Lead.
- Agile SDLC development within the department.
- All aspects of the agile team life, including.
• Team makeup (up to 4 teams).
• Sprint planning and administration.
• Story planning and priority management.
• Business owner relations.
• Education.
• Project priority planning.
• Dependency planning.
• Prototyping.
• Impediment resolution.
• Hands on development.
- Consulting on tender preparation and evaluations.
BI Architect
06.2007 - 06.2008 |Statistics New Zealand
Microsoft SQLServer
Using Microsoft SQLServer Analysis Server 2005 and later 2008 to create and cube environment that allows the 2006 Census data to be viewed for many different purposes. As an early adopter on the new SQLServer 2005, I was able to take the new options this technology allowed to build large dimensional cubes in ways not possible before.
Design included:
• Dimensional Modelling.
• Multiple facts.
• Many dimensions.
• Large numbers of attributes.
• ADOMD Server use for data confidentially.
• Calculated measures.
• Aggregations.
IT Consultant
03.2002 - 11.2003 |Toll NZ
.
Initially contracted as for system integration project, responsible for the integration of multiple enterprise systems through a shared database. After successful integration, the company required a upgrade to a legacy system that control freight movement that was out of date compared to the other parts of the newly upgraded software suite (including hand held devices, accounts software and database).
To achieve this, I took his design to a small Christchurch based software house and worked with them to deliver and intranet-based solution using .Net technologies.
Technical Consultant, Wholesale Banking System
01.2001 - 03.2002 |London Bridge Software
.
To fill some immediate requirements, I was bought into this project to provide interim team leadership from a technical perspective while completing design of various unfinished parts of the system. This also included code implementation of some of my design, as well as general enhancements/bug fixes. I was later re-hired and sent to Egypt to train a team at a company who had bought the software.
Software Development Consultant
since 02.1994 - Till the present day |NDA
.
As a long term contractor I am often called upon as a resource who is able to hit the ground running to improve productivity and meet stretched deadlines.
Having been contracted in many types of organizations enhances my ability to focus of what is import to the project while adapting to the particular skills area needed at the time.
