Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.
Overview
28
28
years of professional experience
1
1
Certification
Work History
SAS Data Integration Consultant
I provided, using SAS Data Integration Studio and SQL, data modelling and ETL solutions for a pilot data
warehouse.
Oracle DBA and ICT System Administrator
Develop Open Plan Earned Value scorecard reports from an Oracle-based project tracking
system for engineers assigned the responsibility of maintaining and enhancing communication
and software systems belonging to Australia’s Airspace
Develop and deploy revised task and project structures in Open Plan to satisfy evolving
business rules
Build Open Plan reporting templates, which use calculated fields and filters, to track business
operations
Maintain organisational information in Open Plan
Research and resolve Open Plan faults and failures
Achievement:
I, as part of a team including senior software developers and engineers, successfully migrated a
CA Super Project Borland/InterBase production system to Welcom Open Plan/Oracle 8.0.5.
Advisory Data Scientist and Data Modeller
05.2019
Solicitor
Australian Government, AGS
05.2019
Data Modeller and Database Developer
Department of Defence
01.2007
Two data warehouse and reporting
engagements, Build an independent data mart, using Microsoft Transact SQL and VBA, to validate a developer
team’s Cognos data cubes
Develop and implement enhancements to an in-production remuneration system to satisfy
ANAO requirements and guidelines using SQL
Achievements:
I built independent reporting data marts, using Microsoft Transact SQL and the Microsoft SQL Server
Management Studio tool, to validate data cubes developed in IBM Cognos by a data developer team
To gain often overlooked insights from datasets and increase the turnaround of business report
development, I recommended to DoD stakeholders the adoption of a technical tool stack including the
Microsoft Dot NET framework, the Microsoft C# programming language, and the SAS Enterprise Guide BI
tool.
Senior Data Consultant
NTT Ltd
02.2016 - Current
Oakton Consulting) focuses on supplying IT and Digital solutions for various Federal
government-based clients facing challenging problems.
Senior Data Integration Specialist and Data Modeller
Australian Transport Safety Bureau, ATSB
10.2022 - 01.2023
ATSB data-flow investigation work order
Responsibilities:
Investigate and document Hubstream data flows into operational ATSB Azure SQL Server
databases and data warehouses
Investigate and document Azure Data Factory data pipelines with Hubstream data touch points
(source and target data stores)
Refactor (re-model) Hubstream data stores as Data Vaults
Design (model) a central Data Warehouse
Achievement:
I co-authored a technical ‘Future-state Data Warehouse Options Paper’ for the ATSB.
Data Specialist, and Data Architect
05.2021 - 10.2021
Data Specialist and Data Architect
Affairs
05.2021 - 10.2021
Owing to the sensitive nature of the project and its future-state BAU programme and the signing of
a Non-Disclosure Agreement (NDA), an outline of responsibilities and outcomes (achievements)
associated with this engagement cannot be divulged.
Senior Data Analyst and Data Modeller
Department of Education, Evidence
10.2019 - 07.2020
ACT – National Education, Base (NEEB)
data integration project, Profile operational Education databases and data warehouses
Catalogue technical and business metadata
Design (model) data micro-services
Develop data micro-services using Transact-SQL within SQL Server Management Studio and
Azure Data Studio
Achievement:
After the implementation of data micro-services, akin to virtual data vaults and reporting data
cubes, into a production environment, there was a significant reduction in time for departmental
policy and data analysts to derive insights from visualisation reports based on ‘Version of Fact’
(‘As Is’) location and timestamped Education administrative data.
Senior Data, Analyst and Data Modeller
12.2017 - 11.2018
Special
Department of Agriculture
12.2017 - 11.2018
Analytics Witness
The responsibilities and results (achievements) of this work order cannot be disclosed due to its
legal nature and the signing of an accompanying Non-Disclosure Agreement (NDA)
And Environment, ACT – Biosecurity Integrated Information
System (BIIS) project
Business Intelligence Analyst and Advisory Data Scientist
01.2017 - 11.2017
Advisory Data Scientist and Data Modeller
ACT Health, Canberra Health Services
01.2017 - 11.2017
Profile operational ‘Imports’ and ‘Exports’ related databases and data warehouses with SQL
Design (model) and develop conceptual and logical data models with Erwin and PlantUML
Design (model) and develop a ‘Master Integrated Data Model’ for Biosecurity stakeholders
Achievement:
Supplying a Master Integrated Data Model to BIIS stakeholders has helped them gain improved
visibility and traceability of data sources and their flow amongst Biosecurity operational systems
and applications
ACT Health Core Integration
SAS Business Intelligence Specialist
Australian Transport Safety Bureau, ACT, Canberra Health Services
05.2017 - 07.2017
And Trade (DFAT)
Major projects include the National Education Evidence Base (NEEB) data integration project, the Biosecurity Integrated
Information System (BIIS) project, and the DFAT data warehouse and analytics project., Analyse, design, and develop customised SAS Output Delivery System (ODS) templates as
curated data in reports and dashboards for Queensland Health data analysts and other
information consumers (stakeholders)
Create ROLAP cubes from single-detail tables with SAS OLAP Cube Studio
Achievements:
I built enterprise business intelligence (BI) pivot table reports (i.e., data cubes) with the SAS OLAP Cube
Studio tool
I developed complex Oracle-to-SAS Proc SQL scripts for data pipelines and enhanced the performance of
these with conversions to pass-through queries.
Senior Data Analyst and Data Modeller
Department of Foreign Affairs and
05.2017 - 07.2017
Undertake data modelling and data integration activities concerning HL7 data within the
existing ACT Health RISPACS solution
Design models with Sparx Systems Enterprise Architect and PlantUML
Capture business metadata in Sparx Systems Enterprise Architect
Achievement:
My data mapping of systems within RISPACS and other data-flow visualisations helped ETL
developers and other data migration specialists in later RISPACS data migration projects
Trade, ACT – data warehouse and analytics project
Business Intelligence Analyst and Advisory Data Scientist
Detailed Design
03.2016 - 12.2016
Provide ‘Preliminary Design’ and ‘, ’ technical system documentation for a
future-state Data Warehouse and Analytics Platform
Recommend advanced analytics suitable for later analytics maturity projects within the
Department of Foreign Affairs and Trade (DFAT)
Research and recommend to the client advanced time series methods employing Artificial
Neural Networks
Achievement:
I advised on time-series methods employing Artificial Neural Networks (ANNs) to address the
client’s business requirement of trend analysis within the Australian Passport Office (APO).
Senior SAS 9.4 Analyst Programmer
05.2015 - 02.2016
Platform, Guide
Ageing
05.2015 - 02.2016
Datacom EDW upgrade project
SAS 9.3, Provide technical assistance to departmental SAS Enterprise, , SAS Forecast Studio, and
SAS Enterprise Miner users
Provide solutions to issues experienced by the departmental SAS user base
Register and maintain Teradata databases and new SAS users as metadata in the SAS
Management Console
Write SAS system change orders (change management) and service requests
Achievement:
I, with the collaboration of SAS Institute Australia, achieved the successful upgrade of the Health EDW SAS
to the 9.3 M2 version.
Senior BI Consultant, Platform Administrator
Catapult BI
10.2010 - 02.2016
A subsidiary of Dialog Information Technology, Catapult Business Intelligence (formerly Formation Data) is a
data management consultancy focused on business-driven solutions
From data warehousing to enterprise
reporting, Catapult BI helps organisations with both the business and technical aspects of managing and
using data
Multiple, : SAS 9.3
Platform Administrator
09.2013 - 05.2015
Senior SAS 9.4 Analyst Programmer
Department of Human Services
09.2013 - 05.2015
Now Services Australia), ACT – Information Warehouse project, Migrate Base SAS programs from a legacy Mainframe to a Unix-based Midrange environment in
both Agile and departmental high-quality settings
Optimise SAS Proc SQL code that sources data from Teradata tables and views
Apply advanced Teradata-specific SQL in SAS Proc SQL code
Assist other SAS migration programmers in the team by providing knowledge transfer of earlier
SAS programming experiences and best practices captured in SAS White Papers
Profile data in Enterprise Teradata data stores and other data repositories as source data for
departmental reports
Achievements:
Successful migration of Base SAS programs from a legacy Mainframe to a Unix-based Midrange
environment for the Department of Human Services (now Services Australia)
I advised departmental and other stakeholders to adopt SAS Data Integration Studio to ‘speed up’ the
migration of complex SAS code and jobs.
Analytics Specialist
07.2012 - 09.2013
Platform Administrator
Ageing
06.2012 - 09.2013
NHR Health Enterprise Data Warehouse BAU programme
SAS 9.4, Responsibilities:
Engage (collaborate) with the NHR Accenture EDW ‘run’ (production) support team and
software vendors
Provide technical assistance to departmental SAS Enterprise Guide 5.1 users
Provide solutions and workarounds to issues experienced by the departmental SAS user base
Gain ‘working’ knowledge of the SAS Management Console
Register and maintain Teradata databases and new SAS users as metadata in the SAS
Management Console
Write SAS administration, general user guides, and knowledge articles.
Senior Teradata ETL Developer
04.2012 - 06.2012
Analytics Specialist
Ageing
04.2012 - 06.2012
ACT – NHR Accenture Enterprise Data Warehouse ‘sprint’ project
SAS 9.3, :
Engage (collaborate) with the NHR Accenture EDW Vertical Prototype (VP) development and
support teams and other stakeholders, including software vendors
Engage (collaborate) with NHR Accenture EDW project managers and stream leads to ensure
that SAS Analytics VP tasks have been developed to high-quality standards within tight and
challenging deadlines akin to ‘start-ups.’
Help members of the NHR Accenture VP testing team with little to no SAS experience and/or
training
Develop advanced analytics prototype scenarios and solutions with SAS Forecast Studio and
SAS Enterprise Miner
Re-model SAS analytics solutions that had changes to their source data
Gain ‘working’ knowledge of optimal in-database Teradata methods with the SAS 9.3 Analytics
Platform
Achievement:
I supplied the Department of Health and Ageing with operational analytical prototype solutions using the
SAS applications of Forecast Studio and Enterprise Miner.
Senior Teradata ETL Developer, Data Engineer
Department of Human Services
02.2012 - 03.2012
Now Services Australia), ACT – CentreLink EDW BAU programme, Engage (collaborate) with the Principal ETL developer to promote the adoption of new ETL
design patterns conducive to Agile (incremental and iterative) development
Engage (collaborate) with project managers (PMs) to ensure work performed in Agile settings
conforms to departmental quality standards
Help non-technical business analysts (BAs) with the development of data mappings and
transformations for refactored and/or decommissioned data stores and ETL jobs
Transfer knowledge of ETL job specifics, aligned to ‘departmental best practices,’ to a new
colleague in the ETL Development team
Profile data in Enterprise Teradata data stores
Develop ETL jobs with the IBM DataStage data integration platform.
Senior Data Modeller
05.2011 - 02.2012
Carer
Human Services
05.2011 - 02.2012
Allowance/Carer Payment
data model project
Senior Data Integration Developer
Department of Health and Ageing, Department of Human Services
12.2010 - 04.2011
And DSEWPaC
Major projects include
the DoHA National Health reform EDW Vertical Prototypes and supporting\mentoring project team members.
Senior Data Modeller
Department of Sustainability
12.2010 - 04.2011
Engage (collaborate) with departmental business intelligence stakeholders to identify
information asymmetries and inconsistencies with business requirements and analyses that
may hamper the development of enterprise-wide data marts for information consumers
Provide and align prior ETL and data integration experiences as insights for the modelling and
management of high-volume, multi-source heterogeneous data
Design (model) and develop robust, fit-for-purpose data models that can be promoted and
assimilated as data marts into the CentreLink EDW (Enterprise Data Warehouse) ecosystem
Design (model) and develop complex, multi-dimensional and multi-granular data models within
the Erwin data modelling environment
Profile data, using advanced SQL, in Enterprise Teradata data stores and repositories, and
business metadata provided by analysts
Maintain and manage a library of data models in a Microsoft SQL Server database
Achievements:
I supplied the Department of Human Services with a combined data model for the CentreLink benefits of
Carer Allowance and Carer Payment
This data model is in production and operation
Environment, Water, Population and Communities (DSEWPaC), ACT
– major database and data warehouse rationalisation project
Senior Data Integration Developer
Metro Power Company
09.2009 - 10.2010
Model data to supplant (replace) ‘source’ and ‘target’ data from Environment Protection and
Biodiversity (EPBC) databases and data warehouses that are to be decommissioned (retired)
Develop refactored ETL jobs for the complete data warehouse development life cycle (DWDLC)
with the Pentaho Business Intelligence platform
Improve the data integrity (trustworthiness) of fact tables in a data mart by developing
Microsoft Transact SQL, Oracle PL/SQL and PostgreSQL SQL scripts for data-cleansing pipelines
that delete fuzzy duplicate records
Achievements:
I successfully applied in-database (i.e., Extract, Load, and Transform) techniques to improve the
performance of data integration jobs (now known as ‘data pipelines’)
I found areas where insightful information could be supplied to C-level stakeholders through location
intelligence and analytics
BHP Billiton Internet of Things project
Principal Statistician and Data Miner, Data Scientist
Queensland Health
05.2009 - 07.2009
Research and develop time-series unsupervised and supervised machine learning (ML)
solutions with the R language and the Statistica and RapidMiner data science platforms
Derive and build novel and hybrid forecasting algorithms with multi-layer artificial neural
networks (ANNs)
Achievement:
I accurately predicted and nowcasted (i.e., short-term forecasted) BHP Billiton mine site electricity
consumption patterns
Data migration and business intelligence
engagement
Consultant
UXC Performance Management
01.2008 - 12.2008
A subsidiary of UXC (now DXC), UXC Performance Management is a data management consultancy with a
focus on providing solutions for various business intelligence platforms.
Business Intelligence Consultant
10.2008 - 11.2008
Assist a Senior Consultant and Project Leader with the prototyping and initial development of a
Text Mining and Analytics solution to manage unstructured and noisy data
Achievement:
I recommended the adoption of appropriate (i.e., fit-for-purpose) Text Analytics software tools from
vendors such as Megaputer Intelligence and SAS to leverage existing client software investments in a
heterogeneous (i.e., mixed) environment.
SAS Platform Consultant
08.2008 - 10.2008
Develop SAS ACTs (Access Control Templates)
Achievement:
I developed a strategy to secure a SAS instance with ICT security specialists at ComSuper and Senior SAS
Consultants in UXC Performance Management.
Business Intelligence
Medicare Australia, now Services Australia, SAS Institute Australia Pty Limited
04.2008 - 06.2008
And Medicare
Australia
SAS Business Intelligence Consultant
Health and Ageing, ACT
03.2008 - 04.2008
Develop business intelligence reports and balanced scorecards using SAS stored processes on
the Enterprise Guide platform
Build data models for the Medicare EDW Team with SAS Data Integration Studio and Enterprise
Guide
Provide analytics-related solutions and services to SAS end-users at Medicare Australia
Provide first- and second-level ad-hoc SAS support
Achievements:
I, with another SAS Institute Consultant, was the ‘first’ at Medicare to have successfully extracted data
from a legacy information system with a proprietary file format for an ETL task
For Medicare SAS
developers and stakeholders, I recommended that this can be achieved in SAS stored processes through
the implementation of refined IBM DB2-specific SQL in SAS Proc SQL blocks
I developed a Naive Forecaster and transferred the requisite knowledge to Medicare EDW team members
with limited statistical backgrounds
I identified areas where the current in-production reporting system could be further enhanced by
integrating an additional analytical system exclusive to SAS
Aged Care (Casper) Data Warehouse project
Business Intelligence project, SAS Business Intelligence Consultant
Commonwealth Bank
02.2008 - 03.2008
Maintain the SAS environment across the bank and transfer knowledge gained to the SAS
Administrator
Maintain all SAS software within the bank, including Data Integration Server, Business
Intelligence Server, Enterprise Guide, and Enterprise Miner
Provide technical support for SAS users
Achievements:
I improved the performance of the SAS instance by tuning a blade server
For the Commonwealth Bank, I tuned both the SAS Metadata Server and the Microsoft Windows 2003
Server
I resolved overnight dropouts and inconsistent user lockouts by investigating the metadata logs associated
with the bank’s SAS instance.
Base SAS Programmer and Statistician
Department of Education
10.2007 - 01.2008
Science
Technology, Engineering and Mathematics (STEM) participation project, Profile, curate, and analyse education-related survey datasets using the Base SAS language and
SAS Enterprise Guide (E-Guide) tool
Achievements:
I, with ABS Census datasets and using SQL and Base SAS languages, developed fit-for-purpose SAS
visualisations and other scorecard reports for the Council of Australian Governments (COAG) and DEST C-
level stakeholders
I gave insights into the key factors responsible for declining Australian secondary school student
participation in advanced mathematics and science units of study.
Data Modeller and Econometrician
Ageing
08.2006 - 10.2007
Health System Expenditure
Modelling
Develop, using Base SAS, robust econometric models to forecast short-term and long-term
expenditure requirements for Australia’s Health System
Extract, using SAS Data Integration Server, multiple data sources provided by hospitals and
other government agencies and convert and load these into the SAS data format
Maintain and promote data through development, testing, and production environments using
SAS Data Integration Server
Achievements:
I supplied reliable forecasts of Medicare and Pharmaceutical Benefits Scheme utilisation and expenditure
to intra- and inter-departmental stakeholders
I was the first in the department to have designed and developed data cubes in Microsoft
Access as an alternative to Microsoft Excel pivot tables to report on multidimensional PBS
data
Expenditure projections for the Australian Health System based on the econometric models I
built have withstood scrutiny by Treasury policy advisors.
Database Developer and Forecaster
Department of Industry
01.2006 - 06.2006
Tourism and Resources, ACT - Trade
Information System (TIS) project
Provide a complete software life cycle solution (i.e., analysis, design, development, testing,
and deployment) to satisfy requirements for a low total cost of management Information
System to be queried by analysts using query tools within the Manufacturing, Engineering and
Construction Division
Cleanse noisy data using Microsoft Transact SQL in an instance of Microsoft SQL Server 2005
Developer’s Edition
Write users’ and administrators' manuals and provide training courses for the Trade
Information System (TIS)
Customise analytical tools to enable forecasts of trade flows
Achievement:
The TIS, which I developed, is being used by departmental stakeholders, and its information is
being sent to the Department of Foreign Affairs and Trade (DFAT) and the Department of the
Prime Minister and Cabinet (PM&C) as a scorecard on Australia’s terms of trade and other net
export positions.
Base SAS Programmer and Labour Market Economist
Department of Employment and Workplace Relations
01.2005 - 11.2005
ACT - labour
market insights programme, I developed SAS analytical models, using the Base SAS language, to report on labour market (LM)
programme outcomes based upon multiple scenarios provided by C-level departmental
stakeholders.
Base SAS Programmer and Econometrician
Tourism Research Australia
10.2004 - 01.2005
Tourism industry avian influenza
impact project, I developed and analysed econometric models to approximate the impact of external shocks on
the Australian macro and global economies using the data science languages of R and Base
SAS
These analyses helped the agency’s stakeholders gauge the probable amount and
duration of offsets to the Australian tourism industry caused by a strain of avian influenza
I recommended suitable forecasting methods such as the Kalman Filter to the project’s
Principal Statistician
Airservices Australia
01.1997 - 10.2004
Base SAS Programmer and Statistical Officer
Health Insurance Commission, now Services Australia
02.1996 - 11.1996
I developed statistical models using the Base SAS language and SAS STAT to forecast utilisation
of services within the Australian Health System and Medibank Private.
Skills
Key Technical Competencies
Trained, some
Experience
Sound working
Knowledge
Highly
Proficient
Specialist
Knowledge
Data Modelling
Conceptual Data Modelling
Logical Data Modelling (Relational)
Logical Data Modelling (Dimensional)
Physical Data Modelling
Business Analysis / Analytics / Machine Learning
Business Requirements Gathering
Sources System Analysis
Data Profiling
Data Mapping
Statistical Modelling
Time Series Analysis and Forecasting
Artificial Neural Networks / Data Mining
Deep Learning Neural Networks
Data Management
Metadata Standards
Data Quality
Data Modelling Tools
Microsoft Visio
Erwin Data Modeler
Sparx Systems Enterprise Architect
PlantUML
BI & Analytical Tools
Python
R
MS Power BI
SQL: MS Transact SQL & Oracle PL/SQL
SAS Visual Analytics
Base SAS Programming
SAS Enterprise Guide
SAS Information Map Studio
SAS OLAP Cube Studio
SAS Web Report Studio
SAS/STAT
SAS/ETS (PROC ARIMA)
SAS Forecast Server
SAS PROC CANCORR
SAS Enterprise Miner
Statistica Data Miner & RapidMiner
MATLAB
Wolfram Mathematica
Databases
MS SQL Server (on-prem & MS Azure)
IBM Db2
Oracle
PostgreSQL
Teradata
NoSQL (multi-model) Marklogic
Data Integration (ETL & ELT) Tools
SQL Server Integration Services (SSIS)
IBM Data Stage
SAS Data Integration Studio
Hitachi Vantara Pentaho
Certification
SAS Consultant
Timeline
Senior Data Integration Specialist and Data Modeller
Australian Transport Safety Bureau, ATSB
10.2022 - 01.2023
Data Specialist, and Data Architect
05.2021 - 10.2021
Data Specialist and Data Architect
Affairs
05.2021 - 10.2021
Senior Data Analyst and Data Modeller
Department of Education, Evidence
10.2019 - 07.2020
Advisory Data Scientist and Data Modeller
05.2019
Solicitor
Australian Government, AGS
05.2019
Senior Data, Analyst and Data Modeller
12.2017 - 11.2018
Special
Department of Agriculture
12.2017 - 11.2018
SAS Business Intelligence Specialist
Australian Transport Safety Bureau, ACT, Canberra Health Services
05.2017 - 07.2017
Senior Data Analyst and Data Modeller
Department of Foreign Affairs and
05.2017 - 07.2017
Business Intelligence Analyst and Advisory Data Scientist
01.2017 - 11.2017
Advisory Data Scientist and Data Modeller
ACT Health, Canberra Health Services
01.2017 - 11.2017
Business Intelligence Analyst and Advisory Data Scientist
Detailed Design
03.2016 - 12.2016
Senior Data Consultant
NTT Ltd
02.2016 - Current
Senior SAS 9.4 Analyst Programmer
05.2015 - 02.2016
Platform, Guide
Ageing
05.2015 - 02.2016
Platform Administrator
09.2013 - 05.2015
Senior SAS 9.4 Analyst Programmer
Department of Human Services
09.2013 - 05.2015
Analytics Specialist
07.2012 - 09.2013
Platform Administrator
Ageing
06.2012 - 09.2013
Senior Teradata ETL Developer
04.2012 - 06.2012
Analytics Specialist
Ageing
04.2012 - 06.2012
Senior Teradata ETL Developer, Data Engineer
Department of Human Services
02.2012 - 03.2012
Senior Data Modeller
05.2011 - 02.2012
Carer
Human Services
05.2011 - 02.2012
Senior Data Integration Developer
Department of Health and Ageing, Department of Human Services
12.2010 - 04.2011
Senior Data Modeller
Department of Sustainability
12.2010 - 04.2011
Senior BI Consultant, Platform Administrator
Catapult BI
10.2010 - 02.2016
Senior Data Integration Developer
Metro Power Company
09.2009 - 10.2010
Principal Statistician and Data Miner, Data Scientist
Queensland Health
05.2009 - 07.2009
Business Intelligence Consultant
10.2008 - 11.2008
SAS Platform Consultant
08.2008 - 10.2008
Business Intelligence
Medicare Australia, now Services Australia, SAS Institute Australia Pty Limited
04.2008 - 06.2008
SAS Business Intelligence Consultant
Health and Ageing, ACT
03.2008 - 04.2008
Business Intelligence project, SAS Business Intelligence Consultant
Commonwealth Bank
02.2008 - 03.2008
Consultant
UXC Performance Management
01.2008 - 12.2008
Base SAS Programmer and Statistician
Department of Education
10.2007 - 01.2008
Data Modeller and Database Developer
Department of Defence
01.2007
Data Modeller and Econometrician
Ageing
08.2006 - 10.2007
Database Developer and Forecaster
Department of Industry
01.2006 - 06.2006
Base SAS Programmer and Labour Market Economist
Department of Employment and Workplace Relations
01.2005 - 11.2005
Base SAS Programmer and Econometrician
Tourism Research Australia
10.2004 - 01.2005
Principal Statistician
Airservices Australia
01.1997 - 10.2004
Base SAS Programmer and Statistical Officer
Health Insurance Commission, now Services Australia