Glenn Sutton Email & Phone Number

Auckland, New Zealand

Foster Moore Limited work exclusively with goverments and provide business registry products.While Foster Moore has a broad client base including local and federal / national clients, a key client is the New Zealand governments, Ministry of Business, Innovation and Employment (MBIE).I have worked predominantly in the area of ETL specialist on a number of high profile projects both for international clients and for MBIE projects. In addition, I have regularly worked in the… Show more Foster Moore Limited work exclusively with goverments and provide business registry products.While Foster Moore has a broad client base including local and federal / national clients, a key client is the New Zealand governments, Ministry of Business, Innovation and Employment (MBIE).I have worked predominantly in the area of ETL specialist on a number of high profile projects both for international clients and for MBIE projects. In addition, I have regularly worked in the capacity of data migration analyst, in particular in defining source to target mapping and transforms business logic.Projects I have work on include the following clients:New Zealand Governent - MBIE:-----------------------------------Incorporated Societies register (INSOC) https://is-register.companiesoffice.govt.nz/Sole Traders register - https://www.tools.business.govt.nz/choose-business-structure/Financial Service Providers register (FSPR) - https://fsp-register.companiesoffice.govt.nz/Personal Property and Securities register (PPSR) - https://ppsr.companiesoffice.govt.nz/Motor Vehicle Traders register (MVTR) - under developmentBotswana Government: -------------------------Companies and Intellectual Property Authority (CIPA) - Mongo DB to relational to Mongo DB - under developmentBermuda Government:------------------------Companies Register (https://www.gov.bm/department/registrar-companies)Ontario Canada (regionaal goverment):-------------------------------------------Ontario Business Register I have been working with Talend Open Studio for a number of years now and know the product very well. In addition to Talend Open Studio, I use groovy, Python and JPython scripts to augment the ETL process.Our product uses a Mongo database for target and I am proficient in Mongo aggregation pipelines.I am frequently involved with setup of relational database, schema, user and permissions scripting in addition to advaced SQL and PL/SQL primarily across Postgres and Oracle. Show less

Auckland

I worked on the POC2KORU project as the primary test analyst. This project involved the migration of Air NZ Partner Membership data from one database to another as part of an ongoing IS consolidation program.The data migration itself was relatively simple. It involved a considerable of records for migration but the data structures were relatively simple. The core testing effort was around the redevelopment of existing partner membership maintenance software in order to access and… Show more I worked on the POC2KORU project as the primary test analyst. This project involved the migration of Air NZ Partner Membership data from one database to another as part of an ongoing IS consolidation program.The data migration itself was relatively simple. It involved a considerable of records for migration but the data structures were relatively simple. The core testing effort was around the redevelopment of existing partner membership maintenance software in order to access and update data in the new database schema. This involved soap testing and automation using Soapui, Groovy scripting and Oracle SQL.Recently I have been involved in the ETR Enhancements and ETR with EMD projects. Again this has has involved a substantial amount of web service testing using Soapui with test automation and coordination and consolidation of test results. Show less

Auckland

Worked at Foster Moore in the role of Senior Test Analyst (Contractor).I was singularly responsible for the testing of the migration of the NZ Companies Office registry database from the previous database schema to the Foster Moore Catalyst system database . This migration involved over 900,000 company records and comprised over 3.5 million records. This included Company Office records, imaged documents, history records, contact data etc. The migration procedure spanned 72 hours and… Show more Worked at Foster Moore in the role of Senior Test Analyst (Contractor).I was singularly responsible for the testing of the migration of the NZ Companies Office registry database from the previous database schema to the Foster Moore Catalyst system database . This migration involved over 900,000 company records and comprised over 3.5 million records. This included Company Office records, imaged documents, history records, contact data etc. The migration procedure spanned 72 hours and was completed successfully, on time and with very few issues encountered post migration.In addition, I was involved with companies office web applications testing, testing and support of the companies office filing reminders program, soap testing and report development using Oracle SQL and Crystal Reports.http://www.fostermoore.com Show less

Worked here in the role of Contract Test Coordinator.I worked on the initial stages of the PCI project. This project had the objective of meeting industry standards for PCI DSS.This project involved the development and testing of web services and web application integration between a number of Air NZ applications to provide secure credit card transaction storage and retrieval and integration with Payment Services provider DPS.

Worked here as Senior Test Analyst / Testing Lead.This involved testing of daily data synchronisation between mainframe systems in New Zealand and Australia. The data synchronisation process involved materialized views to import daily store products sales and pricepoint inmformation into the Progressive Enterprises Teradata Data Warehouse. I had 1 direct report during this contract

Auckland

Worked here as a Senior Test Analyst on Contract.I was involved with various projects with Jarin Consulting and subsequently FMIT / Foster Moore.The key project I was involved with was the implementation and upgrade of the Ministry of Economic Development's Trust Accounting system.I was the primary test analyst for this module of the wider Insolvency Management System. This system provides the Insolvency Management Service the capability to catalog all Assets and… Show more Worked here as a Senior Test Analyst on Contract.I was involved with various projects with Jarin Consulting and subsequently FMIT / Foster Moore.The key project I was involved with was the implementation and upgrade of the Ministry of Economic Development's Trust Accounting system.I was the primary test analyst for this module of the wider Insolvency Management System. This system provides the Insolvency Management Service the capability to catalog all Assets and Liabilities pertaining to Personal or Company Insolvency. The system comprised complex business rules used to calculate dividends payable to creditors based on the security held by the creditors.This system went live and there were no recorded faults within the first 6 months of operation. Show less