James Mckenna

Developed and maintained SQL Server 2022 stored procedures to automate operational tasks, improve data processing efficiency, and streamline ticket management workflows. Designed and implemented a UPRN verification solution using SQL Server and SSIS, automating file imports and validating property records against database sources to identify and report data discrepancies. Built a technology services planning application using Python and SQL Server, providing a user-friendly interface for managing data and improving planning processes.

SQL and Automation Graduate at Great Places Housing Group (2024-09 – Present)

• Developed and maintained SQL Server 2022 stored procedures to automate operational tasks, improve data processing efficiency, and streamline ticket management workflows.
• Designed and implemented a UPRN verification solution using SQL Server and SSIS, automating file imports and validating property records against database sources to identify and report data discrepancies.
• Built a technology services planning application using Python and SQL Server, providing a user-friendly interface for managing data and improving planning processes.
• Managed and resolved emergency support tickets, prioritising critical issues and delivering timely solutions within operational deadlines.
• Created a workflow automation application in Python to support property disposal processes, reducing manual data handling and improving collaboration between teams.
• Collaborated with stakeholders to gather requirements, translate business needs into technical solutions, and identify opportunities for process improvement and automation.

Data and General Administrator at UKHCDO Ltd (2023-07 – 2024-05)

• Created machine learning algorithms using K-Means Clustering, Support Vector Machines, and Isolation Forest for outlier detection using SQL, KNIME, and Python, which led to the team creating a higher quality annual report.
• Fully automated the process for Subject Access Requests using KNIME, which has improved work efficiency and ensured subject data is correct.
• Converted Access SQL queries to SQL Server queries for data cleaning on the National Haemophilia Database.
• Created and maintained MS Excel spreadsheets and MS Access databases.
• Provided administrative and technical support to stakeholders, ensuring timely resolution of enquiries and maintaining high standards of data quality.

MSc in Advanced Computer Science – Liverpool Hope University (2021-10 – 2022-10)

BSc in Computer Science – Liverpool Hope University (2018-10 – 2021-06)