James Mckenna

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.

About