Experience

Auswide Bank Ltd

• Australia
• Banking
• 100 - 200 Employee

• Senior Business Intelligence Developer

  • Sep 2020 - Present



Lite n' Easy

• Food and Beverage Manufacturing
• 100 - 200 Employee

• Database Administrator

  • Dec 2019 - Sep 2020

  Light n’ Easy have 6 data centres spread over Australia. Giving each factory continue operation should connectivity be lost. Each data centre has 3 Always On Availability Group (AG) clusters plus Replication Distributor and Factory servers. • I initially performed a companywide health check. This identified several inconsistencies and non-conforming to MS best practice. Issues where identified and fixed. • Setup performance monitoring using PRTG for both servers and applications. • Performance tuning such as Index’s and TSQL code. • Mentor and support developers. • Day to day trouble shooting. • Development work using TSQL and SSIS • It was identified that all the data centres where using aging host & SAN technology and would not be able deliver the expected business growth. A project was created to move to an on-premises / Cloud model. With the cloud servers acting as primary and on-premises servers as secondary / backup servers should the connection to the cloud be lost. o Take part in project planning meetings o Implemented an on-premises / Cloud model o Migrate 1 data centre to an on-premises / Cloud model this included 3 AG Clusters and 2 standalone servers, at the same time we upgraded the SQL Server from 2017 to 2019 giving us the ability to use TDE encryption. o Implement TDE encryption on all databases. o Initial trouble connection issues, which turned out to be very small due to testing performed prior to going live. o Setting up of replication to the factory servers. • Due to the success of the cloud project I repeated the on-premises / cloud model on 4 other data centres, leaving one data centre to go through the process at a later date due to business and technical challenges.



Entain Australia - Home of Ladbrokes Australia and Neds

• Australia
• Entertainment Providers
• 100 - 200 Employee

• Business Intelligence Developer

  • Sep 2019 - Nov 2019

  ACHIEVEMENTS • Working as part of a team to develop new fact and dimension tables to enable the accounts and auditing departments to perform In-depth analysis of transactional data from the new betting engine. This was a very complex piece of work due to the business rules, which applied over the four brands (Ladbrokes, Neds, Bookmaker & Betstar). ACHIEVEMENTS • Working as part of a team to develop new fact and dimension tables to enable the accounts and auditing departments to perform In-depth analysis of transactional data from the new betting engine. This was a very complex piece of work due to the business rules, which applied over the four brands (Ladbrokes, Neds, Bookmaker & Betstar).



Gladstone Ports Corporation Ltd

• Australia
• Wholesale Import and Export
• 200 - 300 Employee

• Senior Database Administrator

  • Oct 2018 - Apr 2019

  ACHIEVEMENTS • Implemented SQL 2016 AG cluster. • Advised on migrating to Azure • Upgrade SQL 2008 to SQL 2016 Project • Implemented SQL maintenance plans across SQL servers • Implemented SQL service pack process. • Reviewed SQL infrastructure ACHIEVEMENTS • Implemented SQL 2016 AG cluster. • Advised on migrating to Azure • Upgrade SQL 2008 to SQL 2016 Project • Implemented SQL maintenance plans across SQL servers • Implemented SQL service pack process. • Reviewed SQL infrastructure



Queensland Health

• Australia
• Hospitals and Health Care
• 700 & Above Employee

• Senior Database Administrator

  • Jun 2016 - Oct 2018

  ACHIEVEMENTS • Rhapsody Project o Qualified Rhapsody developer o Part of the implementation team for Rhapsody and Data Lake project. o As part of the team, I worked on the initial design and testing of the Rhapsody engine to take multiple message formats such as HL7 from JCAPS, SQL, SOAP and RESTful APIs. These messages were routed to the Data Lake and medical equipment and software using HL7 messaging. During the implementation of ieMR we routed messages between ieMR and medical machines such as blood pressure monitors and JCAPS, to enable paperless hospital. o The project was achieved using multiple routes and smart connectors to allow for data sources to be unavailable without affecting other routes • Performed a quick hand over from incumbent DBA to provide DBA cover at Queensland Health Lady Cilento Children’s Hospital. • Provided DBA support to a large mission critical environment covering SQL HADRON, SQL clusters. SharePoint & SSRS environments. • Replaced SQL Server maintenance plans with Hallengren scripts that cover most maintenance requirements including backups, Index’s, data consistency checks. • Contributed to SQL Server standards and best practice documentation. • Performed an audit of SQL Server licensing. • Enhanced Solarwinds monitoring of MS SQL Server. • Implemented daily checks for all SQL servers. • Member of the project team for the McKessons implementation • Part of the Data Lake project working closely with the data lake manager to ensure schema designs meet business requirements.



BGW Group

• Australia
• Wholesale
• 1 - 100 Employee

• Contract BI Consultant

  • May 2012 - Jun 2016

  As required contract to develop ETL process using SQL Server 2008 R2 SSIS consolidating 4 ERP systems (Momentum Pro) into a datawarehouse for reporting. Data such as Sales, Products, Purchasing, Stock & Personnel are mapped onto a standard set of accounts that are common across the 4 companies. As required contract to develop ETL process using SQL Server 2008 R2 SSIS consolidating 4 ERP systems (Momentum Pro) into a datawarehouse for reporting. Data such as Sales, Products, Purchasing, Stock & Personnel are mapped onto a standard set of accounts that are common across the 4 companies.



My Geo Gear

• Owner

  • Feb 2012 - Jun 2016

  Online sales of Geocaching Travel bugs We custom design Geocaching trackable. www.mygeogear.com Online sales of Geocaching Travel bugs We custom design Geocaching trackable. www.mygeogear.com



Queensland Health

• Australia
• Hospitals and Health Care
• 700 & Above Employee

• SQL Server DBA

  • Mar 2016 - Mar 2016

  Contract to provide holiday cover for Snr DBA. Focusing on providing DBA support to on going projects. DBA support of large multi server VM environment including Microsoft SQL Server 2008, 2008r2, 2012, 2014 SQL clusters Hadron always-on servers. Contract to provide holiday cover for Snr DBA. Focusing on providing DBA support to on going projects. DBA support of large multi server VM environment including Microsoft SQL Server 2008, 2008r2, 2012, 2014 SQL clusters Hadron always-on servers.



Citigold Inc

• United States
• Luxury Goods & Jewelry

• Dba

  • Sep 2013 - Dec 2013

  Led setup of new SQL 2012 SQL servers with replication between 2 mine sites and head office Designed and implemented backup and DR solution (redundancy system) Designed custom MS Access-based Geology front-end, based on: Needs assessments conducted with operational and commercial personnel o Understanding of on-site personnel technological capacity for manual data entry process o Managing legacy issues of multiple author database • Imported data from legacy database ensuring data meets new data rules, cross: o Core sampling data (entered manually by site staff) o GPS data • Supported data cleansing to conform to new data rules • Developed quality data interrogation and reporting modules, including 3D views of mine operations



Geocachers New Zealand

• Owner

  • Apr 2009 - Aug 2012

  Owner and founder of Geocachers New Zealand. We provide Geocaching related items to the New Zealand & Australian market. Owner and founder of Geocachers New Zealand. We provide Geocaching related items to the New Zealand & Australian market.



Gen-i

• Snr SQL DBA and Datawarehouse Consultant

  • Jan 2007 - Aug 2010

  Working in the DBA BAU ICT-Ops area I was lead DBA supporting a number of corporate clients offering the full range of MS SQL Server platform including MSSQL, SSIS, MSRS, MSAS. Site size ranged from 5 servers up employing the full range of skills required to manage complex environments. Over the last 12 months I have been the lead DBA in setting up and supporting Gen-I ready cloud technology and development of their WhereScape Red Data warehouse for billing end customers. Working within a team of 16 DBA’s of multiple disciplines (Oracle, Sybase & MSSQL). I have an extensive knowledge of ITIL & other change management processes.



Atlantis

• Advertising Services
• 500 - 600 Employee

• snr SQL DBA / Developer

  • May 2004 - Jan 2007

  Atlantis provides an in house developed and supported Customer Management System (CRM) aimed at the retail market. Providing Point of Sale (POS) integration into our in house CRM System. I am responsible for the 200 production / development databases and management of the DBA team (3). My main achievements while working at Atlantis Award for innovation, Building the DBA team, Upgrading to new database servers, Upgrading to a SAN, and Study into upgrading to SQL server 2005, Design of several Data warehouse solutions. I am responsible for the security of running of a point’s calculation system designed and ran on behalf of a major Australasian bank reporting directly to the General Manager.



FIRST Rate

• Australia
• Advertising Services
• 1 - 100 Employee

• Snr Software Developer

  • May 2003 - May 2004

  First Rate Ltd provides online marketing consultancy to the New Zealand market with a view of expanding into Australia sometime in 2004. There main commercial advantage is a web enabled metrics-gathering tool that collects referrer, impression and action information from client’s online customers. This information is then displayed in a Marketing friendly format. The system (Mediatracker) was originally written using Microsoft SQL server with an ASP front end. This was proving very slow in delivering the complex reports. I redesigned Mediatracker using Microsoft SQL server and Microsoft OLAP with a middle tier solution using MDX and VB to provide the ASP front end. Mediatracker currently handles over 200 transactions per second with sufficient capacity to handle over 2000 transactions per second. During the re design stage I was responsible for the specification and purchase of the new servers (Win 2003) and the appointment of the hosting company. The added capacity and response rate of Mediatracker has enabled First Rate to gain several high profile clients including Air New Zealand, Netcheck and Sorted to name a couple.



Amcal

• Contract SQL Consultant

  • Mar 2003 - May 2003

  Under contract with Amcal Pharmacy head office to re-design there current data warehouse, and data extraction tools. Each evening the head office system (Advanced Retail) poles all 200 Amcal stores for their POS (point Of Sale) transactions. Which are pulled into the main Back office database, which in tern is transformed into the data warehouse from where business intelligence reports are produced using a number of reporting solutions including OLAP, MS Access, Visual Basic and Crystal Reports. The transformation element of the project has been designed using DTS and Stored Procedures on a SQL 2K platform.



CHEP

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

• Contract SQL VB Developer

  • Sep 2002 - Mar 2003

  I have been on full time contract with Chep NZ since September 2002. I was initially contracted to re-develop their freight management system written in VB and SQL. I updated the VB code to use Stored Procedures Once completed I was kept on to design a new data warehouse to bring together several disjointed systems including Finance and Freight movement from there ERP system (PCMS) to allow the management greater visibility of the valuable data that was previously unavailable. This project is ongoing with further development of reports and inclusion of other system into the data warehouse. The tools used for the data warehouse project include DTS, Stored Procedures, and Triggers. During this contract I have also developed several smaller web enabled applications using ASP and SQL one of which enables the customer service team to enter and track sales prospects against actuals drawn from the ERP system.



Olapworks

• Snr Dev

  • Nov 2001 - May 2002

  Olapworks provided data warehouse technology to the medium to large companies with the New Zealand market place. It was decided that Swisswin ltd would close its office in New Zealand and concentrate on the German market place. This has resulted in my position being made redundant. I was responsible for the overall technical advancement of the companies products, man management of the of 2 development staff on a day-to-day bases. Project management of internal and external client projects. On a daily bases I would be in direct contact with the customer giving both project updates and dealing with any business issues arising from the installation of the software. I actively promoted the complete SDLC process into Swisswin to ensure that the clients projects where completed to specification and to project plan.



BAE Systems

• United Kingdom
• Defense and Space Manufacturing
• 700 & Above Employee

• Application Dev Manager

  • May 1994 - Sep 2000

   During my time with Marconi I had several positions all involving promotions, I was originally hired to design CM tools using Microsoft Access but soon progressed to designing company wide systems utilising the company Intranet and SQL Server. While in the position I was responsible for rolling out several major web based systems across the company including:  Time Management system – SQL Server with a web front-end time and project costing system. Used by 4 divisions of Marconi totalling over 5,000 users.  CMM process assessment system – SQL Server with a Web and MS Access front-end used to assess the CMM level of divisions within Marconi.  Fagan process system – SQL Server with a web front-end system used to collect metrics while using the “Fagan Defect Free Process” I was twice awarded with an ACAS award as a result of the systems I developed saving the company significant money. Being a defence company processes where paramount in the development of software. I worked both to company standards and implements and worked to project specific standards. All systems where developed using the Fagan Defect Free Development process, which inspects all aspects of the development, program from Requirements though to test. In addition to the Fagan all software was subjected to pier review.