Currently leading a team at ANZ focused on data pipeline migration to the cloud. This initiative aims to simplify technology and accelerate the transition of workloads by developing a factory model to migrate applications off end-of-life infrastructure. We ensure the seamless migration of data pipelines, modernizing legacy systems to enable more efficient operations, enhanced scalability, and long-term sustainability for critical business applications.

At Kelima, I collaborate directly with clients in the data and performance disciplines to consult, design, and deliver innovative solutions and ICT transformational projects across both cloud and on-premise architectures. My work focuses on optimizing data pipelines and databases while leveraging data analytics to drive actionable insights.

Metricon builds new homes across Victoria, New South Wales, Queensland, and South Australia.ResponsibilitiesAct as the lead technical resource for the data and Business Intelligence (BI) team.Perform system performance tuning to ensure stability and reliability.Design and manage SSIS and Azure Data Factory pipelines.Develop and manage SQL packages for systems integration.Install, administer, and maintain Microsoft SQL databases.AchievementsCRM Migration to Azure Cloud D365Successfully migrated the CRM system from on-premise to Azure Cloud D365. Initially assigned to Velrada, an IT services company that could not complete the project, I assessed their migration framework and collaborated closely with the CRM application developer and two data team members. We extracted, cleansed, and transformed the data to align with the cloud model, successfully automating the migration pipelines and test scripts.Cloud Data Warehouse and ETL DevelopmentPartnered with the data and BI team leader to create an Azure SQL database in the cloud. Developed Azure Data Factory ELT pipelines to pull data from Azure Cloud, AWS Cloud, and on-premise sources into the cloud data warehouse. Employed Kimball methodology to create a datamart for the reporting team.Data Warehouse Server Migration and UpgradeLed the migration and upgrade of an on-premises SQL Server data warehouse from 2008 to 2017, replacing unsupported and unstable systems, including SSIS ETL, SSRS reporting server, and Crystal Reports, ensuring stability and vendor support.Application and Database MigrationAs a database specialist, collaborated with external consultants to migrate applications and databases, including BizTalk, Data Build, Click Home, the Metricon website, and WMS, ensuring stability and compliance with vendor support.

Transdev is a French international transport operator located in Melbourne, Australia.ResponsibilitiesManaged a data team of two members, collaborating with the Data Architect on Microsoft BI and SQL Server database systems.De-duplicated, validated, cleansed, and maintained data as a single source of truth in the master database for employees, fleets, companies, garages, shifts, and trips.Performed system performance tuning to ensure stability and reliability.Oversaw the installation, administration, and maintenance of Microsoft SQL databases.Created and managed dashboards and data analysis reports using SSIS and Power BI.AchievementsIntegration of Microsoft AX Financial System with Infor EAM Asset ManagementAfter Avanade, the IT consulting company, was unable to optimize the existing integration, the project was shifted in-house. Collaborated closely with the Data Architect to integrate Microsoft AX Financial System with the Infor EAM Asset Management application. Developed SQL procedures to facilitate communication between the two applications, which utilize different data formats (SQL tables for AX and XML files for Infor). This integration streamlined the workflow, allowing work orders (WO) created in Infor to generate purchase requisitions (PR) in AX, which, once approved as purchase orders (PO), were sent back to Infor for further processing.Dashboard ReportingAutomated over 75 reports using Microsoft SSRS and SSIS for the business. Created an analytical dashboard report using Power BI by consolidating data from various sources, including TomTom for brake, idle, and acceleration data via web API, customer feedback collected in files, and punctuality and safety data sourced from the RDBMS of the Interframe application.Payroll Database MigrationCollaborated with Sage Micro Pay to successfully migrate payroll databases to new hardware, reducing operational costs.

Ausnet Services is an energy transmission and distribution company located in Melbourne, Australia.ResponsibilitiesCollaborated with the database team leader in a mid-sized team to manage both Oracle and SQL databases.Developed and implemented ETL routines in alignment with the data warehouse (DWH) design and architecture.Supported the development and validation processes throughout the DWH and Business Intelligence systems lifecycle, maintaining user connectivity and ensuring adequate data security.Created and maintained a strategic reporting tool to collect performance statistics, aiding in the capacity planning of Ausnet Services databases.AchievementsWorkout ProjectContributed to the Workout Project by assisting in the migration of a legacy application to the ERP SAP system, utilizing SQL Server and SAP HANA databases.

Jemena is an Australian infrastructure company that builds, owns, and maintains major electricity, gas, and water assets.ResponsibilitiesContributed to the Jemena data center relocation and the MGH customer outage and market systems project.Assisted the lead database specialist in maintaining Oracle and SQL Server databases.Handled database installation, administration, maintenance, monitoring, and performance tuning.

Mark Gurry and Associates (MGA) is an IT consulting and services company located in Melbourne, Australia, specializing in database administration support, development, and testing.ResponsibilitiesProvided production support for over 45 Oracle databases (24x7) and more than 100 development databases.Installed, upgraded, and patched Oracle software as needed across various environments.Created and configured Oracle instances for versions 8i, 9i, and 10g in diverse environments.Maintained Data Guard and physical standby configurations to ensure high availability for critical systems.AchievementsOracle Database MigrationLed the migration of EBS SUN E20K and E25K to new SUN M9000 servers, receiving positive recognition for my efforts in ensuring a smooth transition.

LGR Telecommunications is an IT consulting and services company located in Melbourne, Australia, specializing in BI solutions for the telecom sector.ResponsibilitiesInstalled SQL Server instances in accordance with Standard Operating Environment (SOE) documentation, ITIL-defined processes, and client requirements.Utilized Ola Hallengren scripts and database maintenance plans for SQL Server to ensure comprehensive maintenance, including database backups, integrity checks, index maintenance, and statistics maintenance.Conducted testing of backups and recovery strategies to ensure that Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO) align with Service Level Agreements (SLAs).