Skills

Primary

SQL Server:Development (T-SQL), Administration (Install, Configure, Maintain)

Data-Modelling:Relational, Dimensional, Snow-Flake, Normal-forms

Azure Data:SQL Azure, EventHub, Stream Analytics

Azure Infrastructure:AppService, Function-Apps, Virtual Machines , Azure-Automation, Logic-Apps, Docker, Kubernetes

NoSql:ElasticSearch (ELK Stack)

DevOps:AZ Cli, AzurePS-RM, ARM-Templates, VSTS (Azure DevOps), Bamboo, Jenkins, Octopus Deploy, Application Insights

Powershell:Azure-Modules, Powershell-Modules, Functions

Product Management:ServiceNow, Jira, Trello, SharePoint, Confluence

Secondary

Programming:Perl, C# .Net, Python

Data-Tools:SSRS, SSIS, Power-Query, Power-BI, Logstash, Kibana, R (R-Project)

Infrastructure:Server 2008+,Linux debian, vSphere, Hyper-V, Azure IAAS, BladeLogic

Big Data:Azure Data Lake, Azure Cosmos DB, HortonWorks

Tool Set:GIT, SVN, XML-XSLT, Prince 2 Certified

Experience

Oneview Healthcare (ASX: One)

Data Platform (Technical Architect) • Current | Contract Ending Jan 2020

A greenfield project to build out a Data Platform for internal and external users.

Worked on the design and implementation of the platform built on the cloud. The platform provided its consumers with a dimensional-modelled (Kimball) which consumed data from both real-time and batch sources.

Highlights

  • Real-time reporting empowered by steam analytics and Event Hubs
  • Orchestration using Azure Automation, Azure Functions
  • Containerisation using Docker
  • Facilitated easy adaption of containers with custom Powershell modules, providing single command environments.
  • Implemented agile CI/CD using Docker, Azure Dev Ops(VSTS), UnitTesting Framework (tSQLt), End2End Integration-Tests (Custom Test Harness), Octopus.

KBC Bank

Solution Architect (Data Systems) • Feb, 2017 — May, 2018

Worked in the Insights and Data-science team providing guidance on architecture and hands-on development of systems.

Highlights:

  • A large migration of a multi-system platform from one Data-center to another.
  • Brought in Agile processes for data-science team
  • Provided mentoring on data-technologies to multiple-teams
  • Architected and re-engineered the data-science platform.

Fleetmatics

Senior Database Developer | Operational Database • Feb, 2015 — Feb, 2017

Worked on the field service management platform as a database developer responsible for the data systems.

Highlights:

  • Migrated from a monolith to a micro-service architecture DDD
  • Migrated from SVN/VSTS to git, assisting in training and supporting the entire team.
  • Automated with PowerShell repetitive business tasks & development tasks (like Environment resets).
  • Build a Azure Automation tool to provide SQL-Server-agent like functionality for SQL Azure.
  • Using the Automation-tool, built a monitoring platform to capture key SQL Azure metrics.
  • Built Power-BI dashboard that correlated our monitor database with Google Analytics information.
  • Setup end-to-end CI process with custom build-module written in Powershell, including tSQLt unit tests and Slack Integration. (BitBucket, Jenkins, tSQLt, Powershell)

RageSpark

Database Developer | VOIP, Report, Telephony • Jul 2014 — Feb 2015

Worked on a telephony management system. Building reports (T-SQL), performance tuning, deployments and support.

Highlights:

  • Performance tuning reports on several million rows of call data.
  • Improved deployment with Powershell and answer-files See less.

Vidappt

Database Developer | Data Application • Sep 2012 — Feb 2014

An I.T. Application and Service Provider. Using in-house Proprietary Code-Generation tools, built a variety web-apps (CMS/CRM/Online Booking) by integrating Data-modelling with Proprietary XML configuration data & domain specific C#.

Heco Systems

System Analyst | Manufacturing Systems • Jun 2010 — Sep 2012

Created Google-Apps based management systems, covering business operations of Production, Sales, & Product-Support

Heco Systems

Infrastructure | Windows Systems • Nov 2009 — Jun 2010

Deployed base IT Infrastructure (Networking / Storage / Servers / Desktops / Firewall)

Education

Dundalk Institute of Technology (DKIT)

Bsc. Computer Science - Networking & Support • 2009

Recognition

MCSA Microsoft SQL Server 2012

Microsoft • 2013

MCSA SQL Server 2012

MCSA Windows Server 2003

Microsoft • 2007

MCSA Windows Server 2003 - Exchange