Contract Database/Software Developer at WMS Group

WMS Group currently operate one mine on the West Coast and are soon to begin operation at a second (more to come). I was approached to assist the IT and Compliance Manager to help set up and operate the data monitoring, data collection and reporting processes for production and compliance purposes. The interfaces are varied, data is received from the Truck GPS systems, numerous testing agencies for Resource Consent compliance (water, atmosphere, radiation, waste, etc), testing results of the final product (levels of presence for many metals and other elements), regular readings are also sent from the SCADA system in place at the mine. Several e-forms have been developed which allow for operational reporting by mine staff throughout the day. Architected and developed several interfaces to collect data, process 3rd party supplied data, identify and send alerts should levels reach preset limits, transform the data to provide metrics on operations (productivity, downtime) and Resource Consent compliance. Interfaces are via WPF desktop apps, Power Automate, API and Mobile apps (Android). Data is resident in Azure SQL databases developed and supported by me and dashboards are currently generated via KlipFolio and Power BI and several static reports are generated from the SQL databases.

Application Developer, App Support & BA at CentrePort Ltd

My official duties for this role were: Support core CentrePort Applications through the management and implementation of faults and enhancements, documentation, and resolution of system problems. Identify improvements and efficiencies of such processes. Modify and implement the improved processes. Investigate and implement tools and processes to improve CentrePort’s business activities. I also continued to develop new processes, SQL Server databases and applications (using WPF and Winforms) that assisted the business operations, such as a new application to enable the creation, maintenance and management of Standard Operational Procedure documents, enhancements to the Infrastructure reporting tool, additional interfaces to manage data being submitted from multiple third parties (for both Financial billing and yard control). I was also instrumental in redesigning, updating and managing the Corporate SQL Server data warehouses for both operations and finance and presenting the data to the business in SSRS, MyBI, Klipfolio and generating Power BI reports and dashboards for the senior management team using data from SQL Server. The tools I employed during my time at CentrePort were been mainly SQL Server, C# (Visual Studio), Office VBA and two 3rd party applications called JotForm and Think Automation. I assisted in the support, enhancment and maintenance of the Jade applications used on Port. During the Covid pandemic I also developed several processes and applications that enabled CentrePort to manage the internal process for distribution and collection of RATs and also an application for automatically parsing the pdf a submitted Vax Passport and loading the information into our security system. I was managing 20+ applications and processes and 19 SQL Databases in production that I have fully designed and developed at my time here at CentrePort. I continue to carry out this support on an ad-hoc contract basis.

Contract Developer at CentrePort Ltd

Originally tasked with replacing the permanent developer who is on a special project, tasked with looking after the company’s in-house applications (Jade) - making enhancements, fixes and general day to day maintenance. Any other software related duties that help the port run in a smooth manner – including finding Cloud based solutions to assist the Cruise Manager in managing the visitors/passenger/guest access to the Wharf and the creation of interfaces to manage the data from those sources. Creating custom apps to enable many work areas to carry out their duties more effectively. Such as automating the port visitor/worker induction system, enhancing the weighbridge process (to reduce manual handling of paperwork), creating an ‘Authority to Access’ work approval process and application, an Infrastructure Project Reporting tool, a tool to allow the Trainers to manage the learning requirements of all staff. All applications and processes were developed using a variety of tools (incl SQL Server, C#, Office VBA) and cloud-based services such as Jotform, Trybooking and Attendium (and their APIs) and building interfaces between them. Migrate Security cardholder/access rights data from old system (Facility Commander) to new System (Gallagher) Manage the Port’s Financial and Operational Data warehouses. Creating reports from those sources and providing data to the Port’s Operational Dashboards Built a process that reads Log Manifest data from CSV, Excel and PDF files and writes the details to a database for reporting and billing purposes. Managing the Port’s Website content updates (Joomla). Carry out out general Desktop support duties when needed.

Contract Developer at NZ Police

Assisting the Police as part of a small team to deliver a new application designed to assist an investigative team in managing all documents, events, exhibits, tasks and team members for serious crimes operations. It is also being designed so it can be scaled down so it can even be used for lower level investigations - such as burglaries. Developed using Winforms, C#, Agile methodology, API, RESTful, JSON, and Oracle.

Contract Developer at Te Kura (Correspondence School)

Contracted to complete a Teacher Aide Management application/database enabling the School to manage the Teacher Aide/Student relationships, funding and timesheet management for the Teacher Aides. Also created a new application to enable HR to reconcile the Teachers leave balances between their own systems and Novopay. All development was completed employing C#.Net, ASP.NET, MVC and SQL Server and was built to Te Kura Standards that applied at the time.

Contract/Snr Developer at Bank of NZ

Contracted to assist in the requirements definition and subsequently develop a browser-based application to enable a work group to manage error files being returned from Credit Agencies- these error files were generated as a result of Customer Credit detail files being sent by the Bank. It enabled the errors to be assigned to individuals in the work group based on the error type and allowed for the status of the error to be managed. It employed C#.Net, ASP.NET, MVC and SQL Server and was built to BNZ Standards that applied at the time.

Senior Developer at Mercury IT Ltd

Responsible for: Business analysis, system design and development of business solutions primarily using the Microsoft .Net platform (MVC, C#, VB.Net, SQL Server) for Mercury clients. Involvement in the design and development of a major project for the Nursing Council of NZ being a new system to manage the registration and practice of NZ Nurses employing a mix of MVC, C#, VB.NET and SQL Server. Have supported and enhanced the applications (desktop and on-line products) over the years. Development, implementation and support of a Case Management system for the Nursing Council. Data migration and implementation of modified versions of the Nursing Council Registry application for the following Health Regulatory Bodies; Chiropractors, Optometrists, Dispensing Opticians, Podiatrists. Involved in the design, development and support of the online application process for Chiropractors and Podiatrists. Devised and support interfaces between the databases and third-party developers for the Optometrists and Dispensing Opticians online applications. Worked on a version of the back-office systems for the Psychologists and Osteopaths boards a new development for the Royal Society of NZ (browser based back office system to manage membership) and made enhancements to the NZ Kennel Club’s Registration System (VB and MySQL). Primary developer for the replacement of the in-house membership system for the Institute of Professional Engineers (NZ), a re-write of an old application updated to .NET and SQL 2008. Has now been mothballed and replaced. Developed, Maintained and enhanced smaller scale applications for other Mercury clients across number of industries using various technologies and techniques. Presales consultations.

Contract Developer at Foodstuffs (WN)

Rebuilt a Delphi/Interbase application that managed the ‘Flybuy’ loyalty scheme into a .NET 2 /SQL Server 2005 version. Also developed a Windows CE application (using .NET compact framework) that counted the number of bins that entered a washing machine and recorded the barcode detail of the bin.

Contract Developer at Valuation Consultants NZ Ltd

Contract development work on an automated property valuation model (AVM).

Contract/Snr Developer at Telecom NZ

Contract development and support for Telecom NZ projects.

Contract Consultant/Developer/Supporter/Trainer at Reboot Ltd.

Contract development, support and training for multiple clients for an accounting software package

Contract Developer at Central Technical Advisory Service

Contract database development.

Info Delivery Manager at EDS NZ Ltd

Web app and database development

Contract Developer at Robins Gioia

Contract development work for Programme Management and Project Risk Management tools.

Contract Developer at Data Torque Ltd

Contract development work.

Contract Developer at Foodstuffs (WN)

Contract development work.

Contract Developer at Ministry of Forestry

Contract development work.