Peter Baker
Gore Bay, Canterbury, New Zealand-linkedin.com/in/nzpeter
Summary
I am an IT professional with over 25+ years of experience. Most of my work involves solving problems and finding
solutions that are practical and useful. Delivering robust solutions to meet specific business needs.
I enjoy the public facing side of data, using various tools to visualize it in meaningful ways that identify trends,
highlight patterns or spot outliers to support sound decision making. However, it is the work behind the scenes in
data identification, collection, verification, transformation, integration and modelling that ensures accurate data that
enables good outputs, so I find this work rewarding. Integration and data pipelines are often problem points in a
project and much of my work has revolved around delivering quality outcomes in this space.
My experience with many types of projects across the entire data engineering stack in many industries enables
me to pickup roles with a specific focus in one of these areas or preform broad spectrum roles wherever the need
is greater.
My experience has given me the opportunity to work with people from all aspects of an organisation. An
important aspect of the work is being able to identify the needs and priorities of the stake holders. I have worked
directly for boards, IT heads, subject matter experts or technical users. In teams of as an individual. In all cases
understanding the goals and being able to give recommendations that make both practical and technical sense is
an aspect of the work I enjoy.
I am also and experienced full-stack developer have used many tools in green-field project or as part of long-term
and on-going work.
My key strengths:
Vision, ideas, lateral thinking, patience & perseverance. I’m pragmatic and creative with the ability to join-the-dots.
I am a good problem solver. I can hit the ground running, bring my skills and picking up new things as required to
achieve the goals required.
Experienced in:
Scum Master, Team leading, BI, SQL Server databases, SSAS, data warehousi
Experience
Software Development Consultant
Compute-IT Ltd
Feb 1994 - Present (30 years 4 months)
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.
Peter Baker - page 1
Application Engineer
Verizon Connect
Nov 2023 - May 2024 (7 months)
Database integration, Snowflake design, API programming and general support work.
Data Engineer
IAG
Jan 2021 - Jul 2023 (2 years 7 months)
Involved with a number of data integration projects to identify, analyse and combine data from many
sources into standardized formats. The project involved two major phases. The first analysing data from
multiple source systems and creating a standardised format to allow high level use of the data. The
second was building on the first set by finding additional attributes to fill out the data for more general
use.
ETL Developer
Stats NZ
Oct 2019 - Dec 2020 (1 year 3 months)
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
Kathmandu
Jul 2017 - Jan 2018 (7 months)
Design and build a module to interface with an existing Dynamics AX warehouse module to speed up
data preparation of work instructions to the warehouse.
BI Consultant
Fulton Hogan
Feb 2017 - Dec 2017 (11 months)
Contract role to design and develop database and interface for third party front end.
Consultant
Farmlands Co-operative Society Limited
Feb 2016 - Feb 2017 (1 year 1 month)
Consulting and Development including BizTalk/SharePoint systems. Integration and SQLServer
development.
BI Consultant & .Net Development
Intergen
Sep 2014 - Aug 2015 (1 year)
Consultant for Intergen for PGW
- BI using WhereScape Red & SQLServer
Peter Baker - page 2
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. ASP, .net, jquery, SQLServer,
EPIServer
ETL Specialist
Synlait Milk Limited
Mar 2014 - Jul 2014 (5 months)
ETL design and implementation of SQL Server based multi system integration.
BI Consultant
IAG
Apr 2012 - Jun 2013 (1 year 3 months)
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
AMI Insurance
Sep 2011 - Mar 2012 (7 months)
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
Stats NZ
Sep 2010 - Jun 2011 (10 months)
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
Stats NZ
Jul 2010 - Sep 2010 (3 months)
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.
Peter Baker - page 3
Census Solution Architect, BI Architect, Scrum Master
Stats NZ
2008 - Jun 2010 (2 years)
Initially contracted for 2011 Census IT strategy development, then retained as Census Solution
Architect and Scrum Master 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 project.
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)
• Scrum Master
• 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
Stats NZ
2007 - 2008 (1 year)
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
Toll Group
Peter Baker - page 4
Mar 2002 - Nov 2003 (1 year 9 months)
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
London Bridge Software (
2001 - 2002 (1 year)
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.
Education
Christchurch Polytech
CBC,ACBC, Business Computing
1989 - 1990
Skills
Snowflake • React.js • Node.js • TypeScript • Database Design • JavaScript • ASPX • Informix
• Model-view-viewmodel (MVVM) • C++
Peter Baker - page 5
