Project Timeline

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.

Read more

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

AgileBI 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

AgileBI 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 crtical Analytical Data Mart development project.

Included:

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

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