Autoglass BodyRepair
- Managed the IT Operations team, merging two helpdesk teams into a single cohesive unit, providing training and guidance for their professional development which let to the team achieving a 100% NPS score among internal customers over a 6-month period
- Oversaw all changes to SQL environment, via planning meetings and code review, to ensure consistency and adherance to "One Vision" ethos
- Created repository data structure, from tables to ETL stored procedures, to reduce load on the databases and enable faster reporting - in some cases reducing page load times from 180 to 5 seconds
- Built tools to automate removal or reporting of customer personal data to comply with GDPR regulations
- Streamlined and simplied code base by replacing all hardcoded .NET queries with SQL stored procedures, reducing code duplication and increasing flexibility
- Created full suite of both automated and on-demand reports for every level of the business using SSRS; Crystal Reports and Orbis Task Centre; or custom internal software, with an average turnaround from request to delivery of under one day
- Designed and oversaw creation of custom HR application including absence, training, recruitment and case management functions; saving £50,000 over a 5 year period