David Ellingham Email & Phone Number

Harrogate, Gb

Leeds, England, United Kingdom

Leeds, England, United Kingdom

The role currently involves supporting Jet2 ecommerce applications, investigating, identifying, and resolving technical issues, also providing root cause analysis for system outages and business critical incidents. T-SQL is used for data correction and the creation/updating of stored procedures utilised by Jet2’s applications. High demand and reduced staff during the pandemic created a strong need for streamlining and automating tasks. Therefore, to enable me to better manage and prioritise my workload, I have created a number of stored procedures to handle various cases. These include the searching and correcting of invalid data caused by either bugs or user input as well as modifying existing procedures with the capacity to run automatically and handle inputs in bulk where the tickets are of a similar nature.Additional tasks include:• Composing business reports via SQL queries for other teams in the business.• Investigating, replicating, and raising bugs.• Reviewing and prioritising a quick wins list with the development team.• On call application and operations cover during peak season• Creating and testing API requests via SoapUI

Harrogate, United Kingdom

Previously responsible for the provision of all Unit4 Technical Support carried out via telephone and remote connection to customer sites. Key tasks and responsibilities were to investigate, document and resolve the technical problems passed to the support team via Unit4's logging system. Technical investigations mainly focus on Unit4's bespoke financial software but also included the investigation of customer's operating systems, RDBMS and web/environment/network configurations with an aim to resolve all issues in accordance with Unit4's response times and escalation procedures. A wide range of technical skills were required as Unit4 Financials is a multiplatform single ledger which supports customers that vary from small companies hosting on a windows environment, to large multinationals that utilize Linux or IBM iSeries/AIX. Additional tasks include: • Writing SQL scripts to investigate or correct issues with customer's financial data • Bug replication to forward onto development • Restore system outages and business critical issues • Troubleshooting customer environments hosting Unit4 software via remote connections to setup monitoring and tracing tools such as Wireshark, SQLTrace and GCeasy in addition to acquiring and processing various server logs for investigation

Wakefield, United Kingdom

Provided first line technical support for the Home Office private network and IT infrastructure which involved a variety of tasks such as supporting the POISE IV virtual environment and legacy systems, remote software, hardware support and diagnostics for printers, workstations and specialist scanning equipment used for immigration/border control (fingerprint/facial scanners or tools used to scan vehicles/ships for materials at secure sites). Acting as first point of contact and incident logging for non-Fujitsu systems within the Home Office for IBM, HP, or ATOS. Incidents involved gathering, documenting and tracking incident information to resolution, technical diagnostics and providing a solution. This was a fast-paced environment with an expectation to provide a quick and accurate resolution within tight timescales. First time fixes were a high priority, knowing and highlighting when escalation was required in order to provide good customer service