Delivery

Timeline of engagements where I have helped organisations to deliver something different

Programme Technical Adviser – EDAP Implementation

Oranga Tamariki
Enterprise Data and Analytics Platform
Aug 21 – Mar 22

Programme technical advisor assisting Oranga Tamariki with implementing an Enterprise Data and Analytics Platform capability.

Included:

  • Lead the platform design and build workstream
  • Contributed to the design of a Modern Data Platform
  • Lead the selection of data collection, ELT, version control and IAC components
  • Supported other EDAP workstreams

Programme Technical Adviser- EDAP Procurement

Oranga Tamariki
Enterprise Data and Analytics Platform
Nov 20 – July 21

Programme technical advisor assisting Oranga Tamariki with creating an Enterprise Data and Analytics Platform capability.

Included:

  • Validation and updating of capability architecture
  • Creation of a reference architecture
  • Advice on agile data way of working
  • Co-creation of Request for Proposal
  • Providing support and advice throughout the RFP process, resulting in the successful selection of a implementation vendor

Agile Data Consultant

Oranga Tamariki
Performance Management Project Review
Sep 20 – Nov 20

Reviewed an inflight Performance Management delivery project and provided options and recommendations to improve the technical maturity of the project.

Agile Data Coach

Contact Energy
Data and Analytics Platform Modernisation
Mar 19 – Mar 20

Coached the performance, data and analytics team as part of the implementation of a new data platform.

Highlights:

  • Scaled from 1 squad to 5 squads, including cross organisation squads
  • Introduced a number of agile scaling patterns from Spotify
  • Assisted with the platform roadmap and architecture
  • Combination of AWS and open source technology platform

 

Agile Data Coach

PowerCo
Data and Analytics Platform Modernisation
Nov 18 – Mar 20

Coached the data and analytics team as part of the implementation of a new data platform.

Highlights:

  • Mentored a number of internal scrum masters
  • Operated under a remote first team structure
  • Reviewed the initial platform architecture options
  • Google Cloud and open source technology platform

Data Blueprint

AMP NZ
Data Blueprint
Aug 19 – Sep 19

Delivered a data blueprint to provide a future state Operating Model, Architecture and Technology platform to enable the replacement of the legacy data platform with a modern data and analytics capabilities.

 

Business Analytics Blueprint

PHARMAC
Business Analytics Blueprint
Oct 18 – Dec 18

Delivered a business analytics blueprint provide a future state Operating Model and Technology platform to enable  improvements in the organisations analytics capabilities.

 

Technical Lead – Analytics 2.0 (Big Data) Platform

Technical Lead – Analytics 2.0 (Big Data) Platform

Accident Compensation Corporation
Analytics 2.0 Project
Mar 18 – Sept 18

Lead the technical delivery of an Analytics platform utilising integrated Attunity, MapR and SAS Viya capabilities deployed in both Azure and AWS.

Coached internal BI and data teams on implementing new data, analytics and content using an AgileBI approach.

Delivery Lead – Client Transformation Data

Delivery Lead – Client Transformation Data

Accident Compensation Corporation
Client Transformation Data
Nov 17 – Feb 18

I lead a multiple phase review of the impact on critical business data as a result of the organisational wide implementation of the  Client Transformation programme.

Phase 1 resulted in a recommended approach and roadmap for implementation,  Phase 2 resulted in a successful Proof of Concept of a Big Data Vault.

Read more

Solution Architect – R Platform

Solution Architect – R Platform

New Zealand Transport Agency
R Platform
Oct 17 – Dec 17

Solution Design and Proof of Concept to move NZTA Statistical Analysts from using R Studio on local desktops to using R on Azure Virtual Desktop Servers based on the Microsoft Azure Data Science Virtual Machine (DSVM).

Read more

Enterprise Architect – Enterprise Information and Data Thought Leadership

Accident Compensation Corporation
Analytics 2.0 Project
Aug 17 – Oct 17

Assisting ACC with understanding how they will change and adapt their approach to operational reporting, warehousing, use of information/ data, and analytics as part of a large transformation programme.

Delivered a set of Enterprise Data Principals and Patterns as well as a Reference Archtecture based on a “Big Data Warehouse” approach.

Read more

Architect – BI Platform Replacement

New Zealand Transport Agency
BI Platform Replacement
Feb 17 – Oct 17

Developed the Cloud Architecure to deploy an end to end Data Vault and BI solution into the Microsoft Azure Cloud.

Included:

    • Microsoft SQL Server
    • Microsoft Master Data Services
    • BIML data acqusition
    • Data Vault
    • Qlik Sense Enterprise
    • Sql Server Reporting Services

Also included the assisting with the PIA and Cloud Assesment process and all the other onerous processes required when you are deploying the first production nearshore cloud solution for a NZ government agency.

Read more

Agile Data Coach – TEC

Tertiary Education Commission
Capability Uplift
Jul 15 – Dec 16

I was privileged to be given the opportunity to coach a unique team at TEC on how to use AgileBI processes to implement a brand new BI capability that would end up surfacing content to over 4000 external users.

The result was after a successfull 3 months the team splitting into two AgileBI Scrum teams to increase their output, and become one of the highest performing AgileBI teams that I have the pleasure to coach.

It included:

  • SCRUM
  • KANBAN
  • BEAM
  • Qlik Sense

One of the highlights was when the internal analyst stepped into the Scrum Master role as part of the project and has become one of the most inspiring and talented scrum masters I know.

The project they delivered has also become a renowned success in NZ.

Read more

Agile Data Coach – Analytical Data Mart

ANZ Bank
Analytical Data Mart Project
Jan 15 – Apr 15

Coached an experienced and high performing Data and BI Development team on how to implement disciplined AgileBI processes, as part of a critical Analytical Data Mart development project.

Highlights:

  • SCRUM
  • BEAM
  • Data Vault
  • Dimensional Star Schemas
  • Metadata Reporting

Enterprise Architect – Master Data Management Review and Roadmap

Advanced Metering Services
Analytics 2.0 Project
Dec 14 – Dec 14

Delivered a Master Data Management review and roadmap for AMSr.

Included Reference Data, SOA/ESB and Governance components of MDM.

Read more

Solution Architect – Advanced Security Model

Ministry of Justice
SAS Security Project
Mar 13 – Mar 13

Designed and implemented an advanced security model within SAS 9.3 for a large Government Department.

Included:

  • Row level security
  • Column level masking
  • Removing shared identities (Pooled workspace server etc)
  • Multiple environments, Dev, UAT, Discovery, Production
  • Release process across environments.
Read more

Solution Architect – Data Integration

Contact Energy
SAS Data Integration for SAP
Dec 12 – Dec 12

The OptimalBI team combined with the install and configuration firepower of Australian Scorpio partners implemented the SAS Data Surveyor for SAP components required to extract data from SAP B/W and load it into Oracle.

Coach – Life Time Value and Segmentation Model

Powershop
Lifetime Value and Segmentation
Oct 12 – Mar 13

Working with an Innovative Powershop we defined and implemented a SAS Enterprise Miner based Analytical model that calculated Customer Life Time value and Segmentation model.

All wrapped up and visualised via a sexy Infographic of the customer segmentation.

Coach – Platform Migration

Government Department
SAS Migration
Oct 12 – Mar 13

The OptimalBI SAS Admin team assisted a Government Department in their migration from SAS 9.1 to SAS 9.3, by mentoring their team during each step of the migration.

Think we also did a few of the steps and wrote a little code ourselves as well 😉

Solution Architect – Greenfields BI/EDW

Earthquake Commission
BI/EDW Project
Oct 12 – Aug 13

Solution Architect for a Microsoft SQL Server 2012 & Sharepoint 2013 BI/DW environment.

Members of OptimalBI are also providing implementation, data integration and report development skills for the build phase.

Deployment includes:

  • Microsoft SQL Server 2012 Enterprise edition
  • SSRS
  • SSAS (Tabular and OLAP)
  • SSIS
  • PowerPivot and PowerView
  • Visual Studio/Report Designer
  • Sharepiont 2013
  • Attunity Change Data Capture
Read more

Enterprise Architect – Master Data Management

NZTA
Master Data Management Strategy
Mar 12 – Apr 13

The OptimalBI team delivered a Master Data Management (MDM) strategy and roadmap to articulate how the organisation can harness the myriad of data sources and ensure a single view of each data entity is available and managed.

Coach & Solution Architect – EDW

Ministry of Justice
Oracle Enterprise Data Warehouse
Sep 11 – Jun 12

Provided a mentoring and leadership role to assist in defining the solution Architecture for a Oracle based EDW project for a Government Agency.

Included:

– Oracle Golden Gate, RAC, ODI, OLAP EDW platform
– Integration with SAS BI Environment
– Complex Data Masking Security requirements/analysis
– Assistance in RFP process and evaluation
– Proof of Concept
– Project team and BAU team structure recommendations

Solution Architect – EDW

Housing New Zealand
Data Warehouse
Jan 08 – Jun 10

Ensured the success of Phase 3 of the data warehouse and introducing a more structured development approach.

This required the development of a three year roadmap and the creation of a new team with additional Data Warehousing and Business Intelligence resources.

Key Responsibilities

  • Design map for the Data Warehouse for the next three years;
  • Design and develop the role out of SAS Strategic Performance Management to support the organisations Statement of Intent, Management and Operational reporting requirements;
  • Design the Business Intelligence reporting architecture to support business users ranging from general report viewers through to advanced analysts;
  • Oversee the DI and BI team leads;
  • Implement, maintain and enhance the Wiki environment, which provides a collaborative and centralised environment to store all business rules, development standards and other supporting information