With responsibility for the full development life cycle, from requirement analysis through to planning, design, development, testing and finally deployment; part of a team that developed a full set of ERP modules across finance/accounting, purchasing, manufacturing, sales and customer service.

• 1990 employed as an Analyst/Programmer to improve the business ERP system.
• Existing screens/forms written in COBOL extended to added new features.
• Using the CQCS 4GL from Cyberscience, Cyberquery (CQ) used to provide business information and reports, Cyberscreen (CS) allowed rapid application development (RAD) of new screens/systems. The RAD nature of CQCS, along with the Lean manufacturing thinking of Nuaire, naturally led to a form of Agile development methodology.
• For Y2K compliance, all ERP modules completely rewritten with CQCS, providing a bespoke and fully in-house developed system, which continues to be developed and extended.
• In 2010, Oracle Database SE introduced, allowing the use of and integration with other systems beyond CQCS; Java, PL/SQL and PHP now used too.

Sample Fan Selector data sheets:

Used Java SE extensively to create utilities and applications to enhance business processes, often for Oracle DB integration where standard PL/SQL wasn't sophisticated enough.

Examples:

• Integrated with customer EDI system for the automated creation of sales orders from an electronic purchase order. Utilised JDBC, XML, SFTP and IMAP.
• Created a utility to take output from Autodesk Inventor and generate full Bill of Materials (BOM) in the ERP system; including new purchased components, sub-assemblies and finished goods, along with their production method.
• Integrated with a Paxton Net2 access control system to automatically generate muster-point-specific fire roll call lists on POS receipt printers positioned at different fire exits, when the fire alarm sounded.
• Created a system to monitor and audit all changes to users and groups within Windows Active Directory, along with file system access permissions to enforce appropriate access controls to files and applications.

Created software for Nuaire's automated test facilities; these are industry accredited reverberant chambers for testing aerodynamic and acoustic performance of fans. Using C# to control Advantech data acquisition and digital I/O cards linked to a variety of controls and sensors, the system automated changing environmental conditions of the fan under test whilst gathering power, noise and performance data.

Was the database administrator for 3 (production, development and DR) Oracle Database 11g R2 Standard servers, recently migrating to 19c. All instances used physical on-premises RHEL servers.

Responsibilities include:

• Installation and maintenance of Oracle Database software.
• Monitoring and resolution of performance issues, using custom scripts and SQL along with Solarwinds Database Performance Analyser.
• Defining suitable database storage structures and tablespaces.
• Maintenance of database schema tables and views for ERP system.
• Creation of stored procedures and triggers to enhance ERP function.
• Creation of data migration jobs and scripts.
• Creation of data backup and disaster recovery jobs and procedures.
• Tools used: Oracle Enterprise Manager, RMAN, SQL*Developer, SQL*Plus, Solarwinds DPA

30 years experience being responsible for a variety of Windows and Unix/Linux based systems, nowadays mostly virtualised on VMware ESXi hosts and clusters.

Responsibilities include:

• Defining hardware requirements and procuring. Typically Dell PowerEdge servers with Dell SCv2000 and Dot Hill AssureSAN 2000 series SAN's.
• Installation and maintenance of OS.
• Create backup, restore and disaster recovery processes. Utilised Veeam Backup & Recovery and Veritas Backup Exec.
• Managing email through on-premises Exchange Server (2000 to 2013), GFI Archiver and hosted Mimecast email gateway.
• Managing Windows Active Directory (AD).
• Maintain security through patch management, firewalls and user maintenance.
• Filesystem housekeeping and storage management.
• Application installation and configuration.
• Shell scripting, PowerShell and batch file programming.
• Use of standard network and server monitoring and diagnostic tools.
• ManageEngine Endpoint Central used for much of the Windows server and workstation management, including patch management, software deployment, OS deployment, USB device management and end-user support through remote desktop sharing.

Together with the Systems Administrator role, I designed, built and maintained the wired/wireless network and structured cabling infrastructure across three sites, connected through BT Ethernet Connect and Short Haul Data Services. Each with its own data centre for resilience, failover and disaster recovery.

Technologies used include:

• Dell PowerConnect 5000 and N1500 series switches for core data and telephony.
• Ubiquiti UniFi switches for CCTV and wireless networks.
• Ubiquiti EdgeMAX switches and routers for edge switching and DMZ.
• Ubiquiti UniFi OS Consoles, wireless access points and camera security products.
• BTNet leased lines for Internet connectivity.
• Smoothwall UTM and Sophos WSA appliances for Internet access and content filtering.
• DrayTek Vigor 3910 series and Barracuda CloudGen firewall's used for remote access home working through IPsec and SSLVPN tunnels.
• pfSense routers for inter-LAN/VLAN security.

Promoted to Group IT Manager in 2012, managing 10 other staff, covering development, infrastructure and support. Additional to typical management tasks, duties included:

• Managing the internal, external & hosted network infrastructure including cabling, servers, switches, wired and wireless, network security including firewalls, VPN’s, anti-malware, content monitoring and filtering.
• Oversee the security, backups, archiving & disaster recovery of all systems.
• Introduction of new telephony, unified-communications and contact centre systems.
• Ensuring that IT activities are within the limits of applicable laws, codes and regulations. Specifically, DPA, GDPR, RIPA, CMA and HRA.
• Develop and implement IT policies and procedures in accordance with auditing requirements.
• Managing the IT Help Desk (Spiceworks).

Responsible for all aspects of Nuaire cybersecurity, including:

• Complying with audits and implementing recommendations
• Policies and procedures
• Education, training and awareness of users
• Access control management - physical and logical
• Network and application security
• Continuity management
• Legal and regulatory compliance

Cybersecurity best efforts and practises forefront in all IT processes, despite this, I have an extraordinary first-hand experience of a ransomware attack and the devastation it brings. Led a team of dedicated IT professionals in swiftly recovering the business back to a business-as-usual state. This process was a unique learning experience.

I took time away from Nuaire travelling throughout Canada and the US, during which I held several positions including security guard, telemarketer, tile setter and running the evening front-of-house for a guesthouse. Was also a volunteer for the Northwest Wildlife Preservation Society in Vancouver, helping with the organisation of the prestigious Canadian Marine Life Conference.