Scott Morrison
Glengarnock,NORTH AYRSHIRE
Summary
Software Developer with 4+ years of experience building internal tools, data-driven workflows, and automation solutions using SQL, Visual Files and Python. Strong background in reporting pipelines, API integrations, and process automation, with proven impact reducing manual workloads by 4+ hours per case and supporting systems handling ~1,000 cases per month. Experienced in maintaining and optimising production systems within regulated business environments.
Overview
5
5
years of professional experience
Work history
IT Developer
Your Conveyancer
Dunfermline, Fife
2023.09 - 2026.06
- Designed and maintained Visual Files automation workflows supporting ~1,000 active conveyancing cases per month
- Built and maintained data reporting pipelines using Python, SQL Server, SSMS, SSRS, and SSIS
- Developed and optimised SQL Server stored procedures to support operational reporting and accurate billing
- Automated data extraction and transformation processes, significantly reducing manual administrative effort
- Owned development, testing, and ongoing maintenance of key internal systems as sole developer
Junior Software Developer
Jones Whyte LLP
Glasgow, GLG
2021.02 - 2023.09
- Debugged, tested, and maintained legacy systems within the Visual Files case management platform
- Collaborated closely with non-technical stakeholders to translate business processes into automated solutions
- Maintained legacy API processes
Education
Level 8 SCQF - Information Technology and Telecommunications
QA Apprenticeships
Glasgow, GLGHigh School Diploma - Graphic Communication, Computing Science, English, Math and Physics
St Matthews
Saltcoats, NAYSkills
Technical Skills
- Python (automation, data processing, reporting)
- SQL Server (SSMS, SSRS, SSIS, stored procedures)
- REST APIs & JSON integration
- Data pipelines & workflow automation
Tools & Platforms
- Visual Files CMS
- Git (basic workflow)
Affiliations
- Personal coding projects
- Learning new technologies
Accomplishments
- Solely designed, implemented, and maintained a production workflow at Your Conveyancer that scaled to support ~1,000 cases per month
- Led a complete overhaul of internal reporting infrastructure using SSMS, SSRS, and SSIS, improving operational insight and data reliability
Timeline
IT Developer
Your Conveyancer
2023.09 - 2026.06
Junior Software Developer
Jones Whyte LLP
2021.02 - 2023.09
Level 8 SCQF - Information Technology and Telecommunications
QA Apprenticeships
High School Diploma - Graphic Communication, Computing Science, English, Math and Physics
St Matthews