Learn Data Skills
Beta
Phoebe Smith

Phoebe Smith

Analyst

Self Employed

Technologies

My Portfolio Highlights

My New Project

Analyzing Students' Mental Health

My New Course

Intermediate SQL

My New Project

Analyzing Students' Mental Health

Analytical pathfinder, leading the way through the data wilderness.

My Work

Take a look at my latest work.

project

Analyzing Students' Mental Health

project

Analyze International Debt Statistics

project

Analyzing Students' Mental Health

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate SQL
Introduction to Excel
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

Spotty Pots Studio and Cafe | May 2024 - Present

Manager

Led day-to-day operations for a studio café, driving a 30% revenue increase by optimising sales processes and customer experience. Managed staff recruitment, training, payroll, and scheduling to maintain efficient service delivery. Introduced automated systems for stock tracking, booking, and accounting using Google Sheets, SQL, and WooCommerce, improving accuracy and workflow. Oversaw web development and payment integration, executing testing and debugging for seamless performance. Streamlined procurement and vendor management, ensuring cost-effective supply chains. Enhanced financial reporting and cashflow through automation, improving business efficiency. Fostered a customer-focused culture while enhancing the digital presence and overall operational reliability.
Show More

Capita | Oct 2022 - Nov 2023

Graduate Actuarial Analyst

Delivered actuarial analysis for Defined Benefit pension schemes, conducting valuations, financial modelling, and risk assessments. Applied statistical techniques such as regression to forecast fund performance. Streamlined PMR reporting and assumption modelling processes, improving accuracy and compliance. Produced detailed stakeholder reports and collaborated with actuaries and investment teams to support pension strategy. Developed models assessing scheme liabilities, mortality, and inflation assumptions to ensure accurate projections. Enhanced data handling workflows, reduced errors in large datasets, and executed sensitivity analyses for financial stability. Maintained SLA compliance while ensuring high-quality deliverables and effective risk mitigation strategies.

Barnett Waddingham | Feb 2020 - Sep 2021

Pension Administration Assistant

Supported Defined Benefit pension scheme administration, managing data rectification during buy-ins and buy-outs and improving accuracy in actuarial calculations. Handled member queries, processed data updates, and liaised with IFAs and next of kin, delivering clear and compliant communication. Assisted in financial reconciliations, ensuring accuracy in scheme transactions and reporting. Collaborated with actuarial and finance teams to support scheme assessments and performance analysis. Streamlined administrative workflows through process automation, boosting efficiency. Ensured adherence to pension regulations, applying knowledge from the Award in Pensions Essentials. Maintained a customer-focused approach, ensuring high service standards and regulatory compliance.

My Education

Take a look at my formal education

Postgraduate Diploma, Operational Research and Applied StatisticsCardiff University / Prifysgol Caerdydd | 2022
Bachelor of Science - BSc, MathematicsUniversity of Leeds | 2019

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free