Andrew Hellyer

Innovative, results-driven professional with extensive experience developing, testing, and maintaining high-performance software solutions. Notable success ensuring software security, scalability, and reliability throughout the development lifecycle. Expert in coordinating with cross-functional teams to analyze business requirements, design architecture, and implement software that aligns with organizational goals.

Talent for quickly learning new information, procedures, and technologies. Strong leadership skills, with capacity to steer and empower cross-functional teams for increasing overall workflow in a fast-paced environment. Demonstrated communication and presentation skills; committed to cultivating relations with clients and stakeholders.

Senior Software Developer at Moneytree Inc (2012-11 – 2025-11)

Design and develop online loan management systems and back-office systems.

• Design and develop online loan management systems (web). This was done using HTML, CSS, Javascript, Java, XML, JSON, Bootstrap, Apache Tomcat, SOAP, REST, jQuery.
• Design and develop back-office systems. This was done using Business Basic.

Senior Software Developer at Alaska Air (2011-06 – 2012-10)

Design and develop back-office and ticketing systems.

• Design and develop back-office and ticketing systems. This was done using VB, SQL Server and Crystal Reports.

Application Architect/Database Administrator at Automotive Retailers Association (2004-09 – 2010-12)

Design, build and administer database systems and group insurance administration systems.

• Design, build and administer the SQL Server database used in the group insurance benefit administration system database (including tables, views, triggers, procedures, scheduling, backups etc).
• Design and develop group insurance administration system. This was started using VB6, COM and has since migrated to VB.NET with a database in MS SQL Server. Crystal Reports is used for reporting. This project is now in the maintenance phase.

Team Leader at Automotive Retailers Association (2004-09 – 2010-12)

Database administration and custom systems development.

• Database administration of the SQL Server database (including tables, views, triggers, procedures, scheduling, backups etc).
• Design and develop custom forestry management systems. This was done using VB6, COM and MS Access.
• Design and develop custom benefit administration system. This was done using VB.NET and MS SQL Server.

Senior Programmer-Analyst at Automotive Retailers Association (2004-09 – 2010-12)

Database administration and customization development for accounting software.

• Database administration of various SQL Server & Oracle databases database (including tables, views, triggers, procedures, scheduling, backups etc).
• Designing and developing customisations to the Agresso Business World accounting software package. The tools used included VB, VBA, SQL Server, Oracle, and Crystal Reports.

Senior Programmer-Analyst at Automotive Retailers Association (2004-09 – 2010-12)

Budget management system development and system interface design.

• Designing and developing the new Budget Data Management System for BC Transit. This system is built using Oracle Designer 2000 and Oracle Forms and incorporating Oracle SQL and Oracle PL/SQL. This project also required some Visual Basic development for building MS Excel reports via OLE from Oracle Forms. This application is a web-based application.
• Designing and developing the interface between the BCFC Labour System and the BCFC HRIS (Human Resource Information System).
• Enhancing the Catering Management Information System (CMIS) for BC Ferry Corporation using PowerBuilder.