Katherine Bertram
Pershore,Worcestershire
Summary
BSc, MSc, fCMgr
Skilled communicator and detail-orientated data analyst with expertise in collecting, synthesising and interpreting complex information. Experience in organisation, events management, and using strong written and verbal communication skills for a variety of purposes. Strong background in research methodologies, data processing, and reporting. Experience in managing and analysing datasets to drive insights and inform decision making. Highly proficient in identifying trends, ensuring data accuracy and communication findings to key stakeholders.
Clean, full driver's license
Overview
9
9
years of professional experience
5
5
years of post-secondary education
Work history
Information Analyst
Gloucestershire NHS Foundation Trust
Cheltenham, Gloucestershire
2023.11 - 2026.03
- Prioritised and created a variety of over 100 synthesised data reports for multiple stakeholders using my skills with SQL, Tableau, and Microsoft Excel
- Maintained strict and conflicting deadlines with a high level of accuracy
- Presented clear and digestible reports to a variety of stakeholders using strong written and verbal communication skills
- Supported service and clinical managers to identify their new and ongoing needs, and built dashboards and reports to fulfil those needs
- Produced a wide variety of internal reports and statutory returns for the trust, from daily to quarterly returns
- Rapidly learnt and used SQL at an intermediate level to interrogate large quantities of surgical data, leading to a reduction in my team's workload
Progress Leader
Saint Augustine's Catholic High School
Redditch, Worcestershire
2022.02 - 2023.07
- Data Manager for literacy software, collecting and processing raw data to identify students requiring literacy intervention
- Organised multiple school trips from inception to completion, including managing students on the day and taking responsibility for the safety of students and staff through detailed risk assessments and initiative during the trip
- Handled a variety of quantitative and qualitative data, synthesised into regular reports for key stakeholders including the Senior Leadership Team
- Built strong working relationships with colleagues and rapport with 'challenging' SEND students
- Delivered targeted interventions with significant positive impact on reading ages - 22% increase in SEND students with reading age above actual age
- Created written materials for different purposes including learning resources, letters to parents, and information booklets for school trips
Content Creator
The Arabian Magazine (Voluntary Role)
2017.07 - 2022.02
- Wrote over 50 monthly blogs documenting life with Arabian horses, promoting the breed and changing public perception towards the Arabian as a performance horse
- Produced high quality, impactful content to strict deadlines, consistently meeting company standards
- Scheduled content releases to meet required deadlines
- Provided live result updates under high pressure and to tight deadlines
- Currently write informational and report articles in multiple publications for national and international release on an 'adhoc' basis
Events Manager (Committee Member)
Heart of England Endurance Group (Voluntary Role)
2018.01 - 2022.01
- Granted sole charge of the annual AGM and Awards Dinner all four years of my term on committee
- Researched and booked venues, negotiating rates that resulted in client cost savings
- Established excellent working relationships with several trusted contractors and suppliers to secure rosettes, trophies, prizes and entertainment
- Successfully managed events under budget while maintaining to deliver exceptional event management services
- Managed ticket sales and hosted the event on the night
Education
Master of Science - Business and Organisational Psychology
Coventry University
Coventry 2020.09 - 2021.07
Bachelor of Science - Psychology
University of Birmingham
Birmingham, England 2017.09 - 2020.07
A-Levels -
Prince Henry's High School
Evesham, Worcestershire 2015.09 - 2017.06
Skills
- Research and report writing
- Database management
- Data collection and analysis
- Data visualisation
- Stakeholder communication
- Event management and coordination
- Written and verbal communication
- Technical Skills: SQL, Tableau, Microsoft Excel
Timeline
Information Analyst
Gloucestershire NHS Foundation Trust
2023.11 - 2026.03
Progress Leader
Saint Augustine's Catholic High School
2022.02 - 2023.07
Master of Science - Business and Organisational Psychology
Coventry University
2020.09 - 2021.07
Events Manager (Committee Member)
Heart of England Endurance Group (Voluntary Role)
2018.01 - 2022.01
Bachelor of Science - Psychology
University of Birmingham
2017.09 - 2020.07
Content Creator
The Arabian Magazine (Voluntary Role)
2017.07 - 2022.02
A-Levels -
Prince Henry's High School
2015.09 - 2017.06