Gary Humphries

Experience

• 

  University of Bristol

  Sept 2001 - Mar 2015

  Planned, maintained and developed databases to store information from local and multi-centre clinical trials.Responsible for verifying, uploading, and reverse validation of clinical data.Maintained and improved data quality by writing complex SQL queries and reports.Created and introduced real-time performance monitoring tools, using my database and programming skills.Provided quality performance dashboards and management reports.Designed complex queries and reports within SQL Server / MS Access, to provide colleagues and management with data.Developed and introduced systems and processes.Wrote and updated documents, such as functional specifications, standard operating procedures, management information reports, and training material.Managed system upgrades, and liaised with system users / managers / software developers.Identified data anomalies / inaccuracies and addressed these by updating data, making system changes or educating inputting teams.Simplified and streamlined processes for colleagues by utilising my programming skills in VBA.Set-up, trained, and provided helpdesk support to users.Analysed processes to identify user requirements for new and existing information systems.Managed two departmental servers (one physical, one virtual). Show less Developed and maintained the Exams Processing Database, and the Student Attendance & Feedback System, within the School of Economics, Finance and Management, and assisted in all database issues within the Social Sciences and Law Faculty.Analysed data, created queries and produced management reports.Provided 2nd and 3rd line technical IT support to staff and students within the faculty.Had responsibility for three Windows servers (two data, one web). This included disaster recovery, backups, anti-virus, patching, software updates, and hardware maintenance. Show less Managed a small IT team.Designed and developed Access and Oracle databases. I provided external support for a database that I designed that was subsequently sold to two UK universities. Provided IT support to staff and students, and had responsibility for the local network and three servers (two data, one web). I was involved in all areas of network administration, such as user and server management, implementing group policy, upgrading servers, checking daily backups, dealing with all security/virus issues, patching the network, and disaster recovery.Maintained all computer equipment, researched and purchased new software and hardware, and disposed of old equipment, paying particular attention to data protection.Created and kept up-to-date the departmental website using classic ASP.Designed programs in Visual Basic that streamlined processes that assisted colleagues.Developed an authentication system (using ASP and Oracle) that allowed various categories of users to have their own account, each with varying levels of permissions.Ran training courses for staff. Show less

  • Database Manager

    Jan 2013 - Mar 2015

  • IT Support Specialist

    Jun 2011 - Dec 2012

  • Information Systems Manager

    Sept 2001 - Jun 2011
• 

  Bath Spa University

  Aug 2015 - Sept 2018

  Systems Administrator
• 

  University of Bristol

  Oct 2018 - now

  • Senior Application Support Engineer

    Nov 2024 - now

  • Systems Developer

    Oct 2018 - Nov 2024