Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ben Pereira

London

Summary

Finance Data Analyst with a focus on turning complex data into clear insights that support commercial and strategic decisions. Experienced in improving reporting processes, ensuring data reliability, and delivering analysis that drives business outcomes.

Overview

3
3
years of professional experience
9
9
years of post-secondary education
1
1
Certification

Work History

Finance Data Apprentice

Starbucks EMEA
London
06.2023 - Current
  • Transformed Weekly Sales Reporting by replacing a manual Excel model with an automated Power BI solution; reduced preparation time by 95% enabling real-time insights.
  • Implemented POS Data Reporting using Databricks, SQL, and Power BI, replacing manual submissions with a scalable, accurate pipeline; enabled leadership to assess data readiness for strategic rollout across markets.
  • Led Menu Rationalization Analytics across EMEA by developing a Power BI dashboard integrating SKU-level performance, supply chain, and financial data; identified underperforming SKUs and informed cost-saving product decisions.
  • Built EMEA Price-Volume-Mix (PVM) Model, a first-of-its-kind tool analyzing sales variances from pricing, volume, and mix; processed 100M+ rows via Databricks and Alteryx to drive revenue diagnostics and forecasting capability.
  • Redesigned Travel & Expense Model into a dynamic Power BI dashboard and deployed to all VPs across EMEA, providing live, actionable T&E insights to improve spend governance.
  • Built an automated SKU-level forecasting and profitability framework, integrating sales, COGS, and P&L data to enable granular margin analysis and scenario planning across products, stores, and portfolios — significantly enhancing financial visibility and planning accuracy.
  • Co-led launch of Starbucks Data University, presenting to 80+ employees on data careers and personal journey; contributed web content and training, promoting data accessibility and cultural transformation across the org.

Data Analyst Programme

AiCore
09.2022 - 01.2023
  • Trained a computer vision model that detected gestures in real-time
  • Created a Python script using Tensorflow API and OpenCV
  • Developed a system that extracts retail sales data from five different data sources; PDF documents; AWS RDS database; RESTful API, JSON and CSV files
  • Created a Python class which cleans and transforms over 120k rows of data before being loaded into a Postgres database
  • Developed a star-schema database, joining 5-dimension tables to make data easily queryable allowing for sub-millisecond data analysis
  • Used complex SQL queries to derive insights

Education

BSc (Hons) - Biological Sciences

University of Hertfordshire
09.2019 - 06.2022

A-Level - Biology, Chemistry and Religious Studies

St Dominic's Sixth Form College
09.2017 - 06.2019

GCSE - Grades A-C

Salvatorian College
09.2012 - 06.2017

Skills

Microsoft 365 (Advanced Excel, PowerPoint, Word)

undefined

Certification

AiCore - Certified Data Analytics

Timeline

Finance Data Apprentice

Starbucks EMEA
06.2023 - Current

AiCore - Certified Data Analytics

01-2023

Data Analyst Programme

AiCore
09.2022 - 01.2023

BSc (Hons) - Biological Sciences

University of Hertfordshire
09.2019 - 06.2022

A-Level - Biology, Chemistry and Religious Studies

St Dominic's Sixth Form College
09.2017 - 06.2019

GCSE - Grades A-C

Salvatorian College
09.2012 - 06.2017

Similar Profiles

CREATE PROFILE
Ben Pereira