Experience

Capgemini

• IT Services and IT Consulting
• 700 & Above Employee

• Associate Director | insights and Data | Microsoft Practice (Vic)

  • Jul 2022 - Present



Empired

• Australia
• IT Services and IT Consulting
• 100 - 200 Employee

• Data and AI Practice Lead

  • Jul 2021 - Jul 2022

• Principal Consultant

  • Mar 2021 - Jul 2021



Telstra Purple

• Australia
• IT Services and IT Consulting
• 700 & Above Employee

• Lead Consultant

  • Sep 2019 - Mar 2021



Readify

• Software Development
• 1 - 100 Employee

• Lead Consultant Data and Analytics

  • Jan 2019 - Mar 2021



Oakton

• Australia
• IT Services and IT Consulting
• 200 - 300 Employee

• Principal Consultant

  • May 2018 - Jan 2019



Target

• United States
• Retail
• 700 & Above Employee

• Microsoft BI Lead Developer / Data & ETL Architect / Dimensional Modeler

  • Aug 2017 - May 2018

  ▪ Advice and recommendations for Microsoft BI Reporting Solution strategies ▪ Engaged Microsoft to optimize use of MS APS appliance and future capabilities around MS Power BI service in Azure ▪ Developed new Target Dimensional Model using Kimball dimensional modelling principles ▪ Developed automated Microsoft SSIS ETL build framework using BIML and metadata driven approach ▪ Generated and implemented full set of ETL SSIS packages using automated metadata driven framework. For complete loading of iTrade data from Source to Staging, Persistent Staging and Dimensional Model. ▪ Developed new Microsoft SSAS Tabular cubes ▪ Developed Conceptual and Logical Data Models using Enterprise Architect modelling tool ▪ Recommended strategic approach for implementing Physical Data Models using Data Vault 2.0 concepts (Hub, Links, Satellites) ▪ Investigated future state reporting utilizing Power BI and liaised with Microsoft in relation to strategic direction ▪ BI Platform consisting of on premise 1 - SQL Server 2016 2 - Microsoft Analytics Platform Solution (APS) with Parallel Data Warehouse 3 – MS Power BI and SSRS Report Servers 4 – SSAS OLAP Cube Servers 5 – SSIS ETL Servers ▪ Attended weekly Target IT Architecture meetings representing the BI Team as the ETL and Data Architect ▪ Guidance and technical direction to Microsoft BI developers ▪ Assisted in many interviews for hiring new Microsoft dev team members Show less



Toll Group

• Australia
• Transportation, Logistics, Supply Chain and Storage
• 700 & Above Employee

• BI Architect / ETL Architect / Technical Lead Developer / Dimensional Modeller

  • Apr 2016 - Jul 2017

  Reporting Requirements gathering and analysis ▪ BI Reporting Solution strategy and presentation of vision ▪ Engaging Microsoft to understand their BI Roadmap ▪ Developed new Data Warehouse using Kimball dimensional modelling principles ▪ Developed automated SSIS ETL build framework using BIML and metadata driven approach ▪ Developed 6 new SSAS OLAP cubes ▪ Developed a number of SSRS Operational Reports ▪ Prototyped future state reporting utilizing Power BI ▪ Windows Servers Implemented as Azure Virtual Machine ▪ SQL Server 2012 Implemented on various cloud based servers ▪ Tightly encrypted as required for storing highly sensitive Australian Defence Force data Show less



DWS

• Australia
• IT Services and IT Consulting
• 300 - 400 Employee

• Senior Business Intelligence Consultant

  • Jul 2013 - Apr 2016

  Design and construction of BI solutions for DWS clients including NAB and Telstra using Microsoft BI stack and supporting products. TELSTRA ▪ Produced Kimball Dimensional Model for new Pricing Data Mart ▪ Built SSIS Packages using SQL Server 2012 and Visual Studio 2013 ▪ Produced ETL Framework, SQL Server and SSIS Standards ▪ Produced logical model for modelling Telstra products and billing details ▪ Used Teradata SQL Assistant for investigating potential Data Sources ▪ Acted as Data Architect responsible for determining data sources to feed into the new Pricing Data Mart NAB ▪ Develop and present new ETL architecture for processing daily transactions from NextGen platform and generating OLAP cubes for the NAB Wholesale business users. The requirement was to report on NAB Wholesale banking exposures by various dimensional attributes. ▪ Design Data Models for new SQL Server Data Warehouse based on Kimball Dimensional Model ▪ Develop MS SSIS ETL packages to load Dimensional Database ▪ Design and Develop Reconciliation and Validation frameworks integrated into the ETL architecture ▪ Designed and built various SSRS operational reports ▪ Designed and built various SSAS OLAP cubes for the business to analyze and generate reports. The business users utilized Excel Pivot tables to slice and dice the data in the cubes. ▪ Configure SQL Server Agent jobs via MS SQL Server ▪ Liaise with Client in regards to delivery aspects and timeframes ▪ MS Visual Studio used to develop and deploy the solutions above ▪ Development and Testing of SQL Scripts ▪ Development of MDX queries for testing OLAP cubes Show less



Sigma Healthcare

• Australia
• Wholesale
• 400 - 500 Employee

• Senior Microsoft ETL BI Developer

  • Feb 2012 - Feb 2013

  Design and Development of DWH and BI platform in SSIS using SQL Server 2008 and Visual Studio 2008. Design based on Bill Inmon and Ralph Kimball principles ▪ Develop ETL architecture and built SSIS ETL packages for processing daily transactions from ASW ERP system into new data warehouse ▪ Develop ETL architecture and built SSIS ETL packages for migrating existing data warehouse to new data warehouse ▪ Design Data Models for new SQL Server Data Warehouse including Inmon Enterprise Model and Kimball Dimensional Model ▪ Develop MS SQL Server 2008 R2 SSIS ETL packages to load Enterprise Database ▪ Develop MS SQL Server 2008 R2 SSIS ETL packages to load Dimensional Database ▪ Configure SQL Server Agent jobs via MS SQL Server 2008 R2 SSMS ▪ Liaise with Client in regards to delivery aspects and timeframes ▪ MS Visual Studio 2008 (BIDS) was the environment used to develop and deploy the solutions above ▪ Development and Testing of SQL Scripts ▪ CA Erwin was the tool used to develop the data models ▪ Analytix Mapping Manager was the tool used to document the mapping specifications for loading the data models ▪ Recommended and introduced Sigma to 3rd party components from Pragmatic Works for performing Slowly Changing Dimension and other useful components ▪ Assist client IT support to configure all test and production Windows SQL Servers to support Data Warehouse processing requirements ▪ Development of MDX queries for testing OLAP cubes Show less



Mondelēz International

• United States
• Food and Beverage Manufacturing
• 700 & Above Employee

• Senior Microsoft ETL BI Developer

  • Dec 2010 - Oct 2011

  Design and Development of DWH and BI platform in SSIS, SSAS and SSRS using SQL Server 2008 and Visual Studio 2008. Design based on Ralph Kimball principles Develop PDA mobile reports using aspx/c#/xhtml and visual studio 2010 accessing SQL Server ▪ Development of BI Sales Reporting Analytics Requirements Specification ▪ Design Data Model of BI Sales Reporting Analytics Data Warehouse with Kimball Dimension Model ▪ Develop and Test MS SQL Server 2008 SSIS ETL jobs to load Data Warehouse ▪ Develop and Test MS SQL Server 2008 SSIS ETL jobs to load Dimension Model ▪ Develop and Test MS Analysis Server 2008 SSAS OLAP Cubes using Data Warehouse Dimension Model ▪ Develop and Test Microsoft SQL Server 2008 Business Intelligence SSRS Reports ▪ Deploy Sales Reporting OLAP Cubes to end users who queried them using Excel 2007 ▪ Configure and test SQL Server Agent jobs via MS SQL Server 2008 SSMS ▪ Configure Windows Server 2008 R2 Enterprise Reporting Servers as per configuration and security requirements ▪ Liaise with Client in regards to delivery aspects and timeframes ▪ MS Visual Studio 2008 (BIDS) was the environment used to develop and deploy the solutions above ▪ MS Visual Studio 2010 Professional was used to develop ASPX/C# web reports for the PDA Windows 6 mobile reporting ▪ Development and Testing of SQL Scripts ▪ Development and Testing of SSAS Calculated Measures ▪ Development of MDX queries for testing OLAP cubes Show less



QuantumIT

• Australia
• IT Services and IT Consulting
• 1 - 100 Employee

• Senior Microsoft ETL BI Developer

  • Mar 2008 - Nov 2010

  Data Migration, Data Warehouse, OLAP Cubes and SSRS reporting for the following companies: Advantedge financial services -NAB Tenix Solutions Dept of sustainability and Environment Sensis NAB Data Migration, Data Warehouse, OLAP Cubes and SSRS reporting for the following companies: Advantedge financial services -NAB Tenix Solutions Dept of sustainability and Environment Sensis NAB



Advantedge Financial Services

• Financial Services
• 1 - 100 Employee

• Senior Microsoft ETL BI Developer

  • Apr 2010 - Oct 2010

  Data Migration to SQL Server 2008 database Data Migration to SQL Server 2008 database



Department of Sustainability and Environment

• Australia
• Environmental Services
• 300 - 400 Employee

• Senior Microsoft ETL BI Developer

  • Nov 2009 - Mar 2010

  Data Migration to SQL Server 2008 database Data Migration to SQL Server 2008 database



Tenix Solutions

• Melbourne, Victoria, Australia

• Senior Microsoft ETL BI Developer

  • 2009 - Nov 2009

  Data Migration to SQL Server 2008 database, OLAP cubes and SSRS reporting Data Migration to SQL Server 2008 database, OLAP cubes and SSRS reporting



NAB

• Australia
• Banking
• 700 & Above Employee

• Data Warehouse Developer

  • Apr 2008 - Jan 2009

  Design and Dvmt of Data Warehousing solutions Design and Dvmt of Data Warehousing solutions



Sensis

• Australia
• Advertising Services
• 700 & Above Employee

• Data Warehouse Developer / Business Analyst

  • Feb 2008 - Apr 2008

  Designed and developed DWH and BI solution using complete Microsoft technology toolset. Designed and developed DWH and BI solution using complete Microsoft technology toolset.



Telstra

• Australia
• Telecommunications
• 700 & Above Employee

• Websphere Datastage Developer (Enterprise Edition v7.5)

  • Mar 2007 - Jan 2008

  Designed and developed Datastage migration solution for Telstra Designed and developed Datastage migration solution for Telstra



Suncorp Group

• Australia
• Financial Services
• 700 & Above Employee

• Websphere Datastage Developer (Enterprise Edition v7.5)

  • 2001 - 2007

  DataStage Developer (DS Server Edition v7.5) Oracle database DataStage Developer (DS Server Edition v7.5) Oracle database



Coles Myer

• Melbourne, Victoria, Australia

• Project Leader / Senior Analyst Programmer

  • 1999 - 2001

  Designed and developed many cics,COBOL , db2 applications Designed and developed many cics,COBOL , db2 applications



Telstra

• Australia
• Telecommunications
• 700 & Above Employee

• Solution Designer (Technical Architect)

  • 1999 - 1999

  Designed and developed technical solutions Designed and developed technical solutions



Ansett

• Airlines and Aviation
• 1 - 100 Employee

• Senior Technical Consultant / Project Leader

  • 1997 - 1998

  Designed technical solutions to Year 2000 related issues. Designed technical solutions to Year 2000 related issues.



Hitachi Vantara

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Technical Consultant / Project Leader

  • 1996 - 1997

  Designed and developed technical solutions for various clients Designed and developed technical solutions for various clients



Telstra

• Australia
• Telecommunications
• 700 & Above Employee

• Project Leader, Lead Designer and Technical Consultant

  • 1992 - 1996

  Designed and developed middleware solution (ip fabric) using cics,COBOL,db2,appc, lu6.1/2,cpic Designed and developed middleware solution (ip fabric) using cics,COBOL,db2,appc, lu6.1/2,cpic



State Revenue Office Victoria

• Australia
• Government Administration
• 300 - 400 Employee

• Senior Analyst Programmer

  • 1992 - 1992

  Designed and developed windows frontend and cics backed services for landtax solution Designed and developed windows frontend and cics backed services for landtax solution



IOOF

• Australia
• Financial Services
• 500 - 600 Employee

• Senior Analyst Programmer / Designer

  • 1990 - 1992

  Designed and developed cics,COBOL,db2 applications Designed and developed cics,COBOL,db2 applications



Coles Myer

• Analyst Programmer

  • 1987 - 1990

  Designed and developed cics,COBOL,db2 applications

• Operations / Team Leader

  • 1985 - 1987

  Resolved job failures and developed mgmt reporting solutions