Sophie Mackellar
Glasgow,UK
Summary
Final-year Business Enterprise student with four years' leadership experience in a fast-paced retail environment, seeking to begin my Chartered Accountancy training within a collaborative, client-facing firm. Through managing inventory and operational reporting at Greggs plc, I strengthened weekly Power BI stock performance from Critical to Healthy, demonstrating analytical thinking, accountability, and attention to compliance. Awarded distinction grades during my operational analysis internship and recognised as the youngest elected board member of a community association, reflecting maturity, responsibility, and initiative. Eager to contribute to Consilium's supportive, team-based Audit environment while developing into a well-rounded business adviser through exposure to owner-managed clients and professional exam progression.
Overview
7
7
years of professional experience
1
1
Certification
Work history
Board Member
Terrace Community Association
Glasgow, Glasgow City
2022.01 - 2026.02
- Supported local planning discussions as youngest committee member.
- Assisted in re-election at 2026 AGM through engagement initiatives.
- Facilitated community development projects by liaising with council stakeholders.
- Nurtured a culture of transparency to foster trust within team.
Shift Manager
Greggs plc
Partick, UK
2021.04 - 2025.09
- Progressed through four roles in four years.
- Assisted with operational tasks in fast-paced retail environment.
- Supported team members during interviews, onboarding, and scheduling.
- Balanced work with academic studies and internships, demonstrating time management skills.
- Enhanced team morale through effective communication and feedback practices.
- Streamlined operations by implementing efficient work procedures.
- Oversaw cash management processes, ensuring accuracy at end of shifts.
- Assisted employees in resolving workplace conflicts, improving overall team harmony.
- Managed inventory control to reduce wastage.
- Reported key metrics to upper management for decision-making processes.
- Optimised shift schedules to improve operational efficiency.
- Motivated employees to achieve sales targets, increasing overall store revenue.
Business Intern, Operational Analysis
Greggs plc
Glasgow, UK
2025.01 - 2025.04
- Assisted in conducting CVP forecasts to analyse store-level performance.
- Supported operational decision-making through detailed performance analysis.
- Helped interpret Power BI dashboards to identify sales trends and efficiency metrics.
Café Assistant
Café Atrium & Cafe Go-Go
Glasgow, UK
2021.04 - 2021.09
- Provided excellent customer service and aided daily operations in a bustling city-centre café environment to ensure a positive customer experience.
- Collaborated closely with team members to foster a supportive work atmosphere.
- Maintained cleanliness of dining and service areas to enhance customer satisfaction.
Hockey Coach
The Glasgow Academy / Matthew Manson Camps
Glasgow
2019.01 - 2021.01
- Assisted head of physical education in coaching technical skills to students from P3 to P7.
- Facilitated training sessions tailored for age groups by simplifying complex drills.
- Supported players in developing skills for enhanced game tactics.
- Encouraged team morale through regular constructive feedback.
- Provided guidance for improved tactical understanding.
- Boosted players' confidence by recognising progress and individual achievements.
Education
BA (Hons) - Business Enterprise
University of Strathclyde
Glasgow 09/2022 - 04/2026
Skills
- Analytical & Commercial Judgement
- Financial & Operational Analysis (Power BI, Excel)
- KPI Monitoring & Performance Reporting
- Strategic Planning & Competitor Analysis
- Accountability & High Standards of Accuracy
- Attention to Detail
- Process Improvement & Operational Efficiency
- Stakeholder Communication & Relationship Management
- Collaborative Leadership & Mentoring
- Resource Management & Inventory Control
- Initiative & Proactive Problem-Solving
- Resilience Under Pressure
- Safety & Compliance Awareness
Certification
- Power BI, Greggs plc, 2025
- Running an Efficient Shop, Greggs plc, 2025
- Elementary Food Hygiene, REHIS, 2020
- Distinction-level Internship Reports, University of Strathclyde, 2025
- Youngest Elected Board Member, Terrace Community Association, 2026
- Most Promising Player, School & District Hockey, 2020
Volunteer
Board Member, Terrace Community Association, 2022-01-01, Present, Elected youngest-ever committee member and re-elected at the 2026 AGM, contributing to local planning discussions, resident engagement initiatives, and community development projects.
Affiliations
- Regular gym training and Pilates, with an interest in mindfulness and maintaining balance alongside study and work. Active in community involvement and local initiatives, and enjoy coaching and mentoring others, particularly in team and leadership settings. Strong interest in sport and structured training environments.
References
References available upon request.
Timeline
Business Intern, Operational Analysis
Greggs plc
2025.01 - 2025.04
Board Member
Terrace Community Association
2022.01 - 2026.02
Shift Manager
Greggs plc
2021.04 - 2025.09
Café Assistant
Café Atrium & Cafe Go-Go
2021.04 - 2021.09
Hockey Coach
The Glasgow Academy / Matthew Manson Camps
2019.01 - 2021.01
BA (Hons) - Business Enterprise
University of Strathclyde
09/2022 - 04/2026