Welcome to Mortimer XYZ

A few things you should know upfront:

My name is Christopher, but most people call me Chris. I live and work in the capital of Australia, Canberra, and I’m passionate about technology and design. I like to work on most data related things including Engineering, Analytics, Warehousing and Business Intelligence as well as web development.

Timeline (recent first)

Working @ Australian Government

Health Sector 2024 Google Cloud Data Engineer / Cloud Engineer / Web Developer

• Architected and engineered a Google Cloud Platform organization and Azure Entra / DevOps organization
• For both the migration of data from a Hadoop platform (Nifi and Impala/Hive) to Google Cloud Platform and the ingestion of public data to BigQuery
• Designing and developing a mono repo (using Python poetry) for managing Google Cloud Functions / Workflows / Apache Beam / Dataflow / Dataform pipelines in Python / JavaScript
• Building custom Docker images for Dataflow and Flask web applications
• Deploying to GCP using Terraform and Bash scripts with the Gloud SDK as scheduled Dataflow runs
• Analysing source systems (Teradata and Microsoft SQL Server) and reverse engineering requirements from the Nifi pipelines due to missing corporate knowledge and documentation
• Calling an LLM (Google Gemini) through Vertex AI using BigQuery ML from Dataform
• Management of project tasks and deliverable in Jira and Azure DevOps

Health Sector 2022/23 Web Developer / Data Scientist / Analyst

• Full stack machine learning architecture as well as web development
• Development and architecture of a web application for integration of Natural Language Processing (NLP) predictions and labelling with business reporting
• Python Flask, Alembic, SQLite3, AdminLTE (built on top of Bootstrap) with JavaScript libraries including DropZone.js
• Use of Git (and Bitbucket)
• Configuration of Linux environment
• Maintaining and developing R scripts that read and write from many data sources and targets
• Sourcing data from multiple data warehouses (Teradata and Oracle) into R environment

Agriculture Sector 2021/22 Data Scientist / Data Engineer / Cloud Engineer

• Primarily working on both on-prem and Cloud Microsoft Data platforms including SQL Server, Power BI and Azure
• Contributed to architecture for an Azure Data Analytics platform
• Building solutions on Azure Databricks including configuring clusters, writing shell scripts, engineering data between on premises SQL Server to Azure SQL Managed Instance and Azure Data Lake Storage (Gen2)
• Configuring CNTLM proxy for authenticating against a Windows proxy from a Linux machine
• Refactoring machine learning models (Python) from SQL Server Machine Learning Services to Databricks
• Python development for automation of things and ML pipelines
• Strategies for source control of Power BI PBIX files in Git
• Gathering requirements from business areas and subsequent development of Power BI dashboards
• Curating and orchestrating data using a SQL first ELT framework

Health Sector 2020/21 Primarily working on a website upgrade and Information Management

• Technical Lead and architect for the refresh of Health Workforce Data
  • At time of project
• Web development (Gulp, Fractal, Node.js) content, design and Business Intelligence (Tableau)
• Assessing the technology landscape and building proof of concepts in Tableau, Power BI, Qlik Sense
• Analysing usage of systems, parsing apache logs, and Windows file systems using Python, TPT scripts to load to Teradata in native JSON format, Qlik for analysis
• Powershell and Python for automation
• Implemented Git hooks for deployment

Worked @ Australian Government

2019/20 BI Analyst / Data Engineer

• Primarily working on strategic Information Management projects
• Assessing the technology landscape and building proof of concepts in SQL Server, Power BI, Python and web technologies
• Analysis of social media data including sentiment analysis SQL Server: Graph and Machine Learning services; network and sentiment analysis; minor DBA tasks
• Jupyter notebooks for Python and R
• Scripting the download of data from public APIs and loading to SQL Server
• SSAS, Power BI and Cognos Analytics
• Web based documentation including system architecture diagrams Cytoscpe.js framework

Worked @ Consulting

SAS 2019 Consultant

• Information and technical security architecture of a new Viya deployment
• Designing and implementing the security model of a new visual analytics platform on SAS Viya
• Developing Python and bash scripts for the automation of processes such as adding new security groups on the OS (Linux Redhat) and SAS Platform

Teradata 2016 BI Analyst

• Multiple end to end data projects from data sourcing to BI and Analytics
• Utilising the Teradata Aster Analytics platform (Teradata Vantage)
• Built dashboards in Tableau and SAS Visual Analytics and developed custom-built web applications (Jquery / Bootstrap)
• DBA work including database hierarchy, users and roles/privileges
• ETL development including Teradata TPT scripts, Python, bash, calling REST APIs, processing JSON, loading data to a SAS LASR server
• SAS Platform admin including managing SAS users and user groups

Worked @ Australian Government

Health Sector 2006->2016 In various data related roles including data analysis, ETL, time series forecasting, web development

• Developing a strategy for the warehousing of data in a Teradata EDW including data modelling and ETL
• Designing a web-based system for cleansing data using SAS Stored Processes
• Developing and expenditure forecasting model
• Developing improved UI for forecasting
• Transitioning to a Teradata EDW from a SAS midrange environment

Freelance

Sigma Motors ACT 2022 Web developer and Cloud infrastructure

• Developed and deployed a marketing website for Sigma Motors ACT Sigma Motors ACT
• AWS/Google cloud platform/Azure virtual machine configuration, networking and firewall rules
• AWS Route 53 DNS configuration
• Gatsby.js for frontend and Contentful CMS for content
• Infrastructure and application installation and CICD (Nginx, Git)

Code

Here are the programming languages I’m either good at or have have used them enough to write them here.

print('Python')

select 'SQL' as language;

console.log('Javascript');

<h1>HTML</h1>

.css {
  font: CSS;
}

echo 'Bash'

Write-Host 'Powershell'

%put SAS;

print('R')

Studied

Australian National University 2002->2006

Majored in Mathematics (Computational), Minored in Physics