Data Science · Analytics · Retail · FMCG

Hey! I'm Rosewal —
Let's explore my journey...

A certified Data Scientist and Analyst with 7+ years of retail and FMCG experience. I combine machine learning, statistical modelling, and business intelligence to turn complex data into smarter decisions — using Python, SQL, Power BI, and scikit-learn.

Rosewal Almeida

Why Me?

I'm a DataCamp-certified Associate Data Scientist and Microsoft-certified (PL-300) Data Analyst with 7+ years of experience in fast-paced retail and FMCG environments. My journey spans managing a Sainsbury's store in Scotland — leading a team of 40, driving 24% year-on-year sales growth, and generating £945K+ monthly revenue — to executing trade marketing across 1,000+ outlets at ITC Limited in India.

Today, I combine that domain expertise with machine learning, statistical modelling, and data visualisation — building predictive models, customer segmentation pipelines, and interactive dashboards using Python, scikit-learn, SQL, and Power BI that don't just look good — they drive action.

By the Numbers

7+
Years in Retail & Analytics
24%
YoY Sales Growth
1000+
Outlets Managed
£945K
Monthly Revenue Led
Python scikit-learn Pandas NumPy Matplotlib Seaborn Machine Learning Supervised Learning Unsupervised Learning Tree-Based Models Regression Classification Clustering PCA SQL PostgreSQL Power BI DAX Power Query Excel Hypothesis Testing A/B Testing Looker Studio Google Analytics 4 Retail Analytics FMCG Trade Marketing

Projects

🏥

Diabetes Prediction — ML Classification

An end-to-end machine learning project predicting diabetes using Random Forest with GridSearchCV tuning, SHAP explainability, and model persistence.

Pythonscikit-learnRandom ForestSHAP
🎵

Spotify Music Analytics Dashboard

A Power BI dashboard analysing Spotify performance across 2023–2024, uncovering listener trends, top artists, and song popularity to optimise promotion strategies.

Power BIDAXMusic Analytics
🏏

IPL Analysis Dashboard (2008–2022)

A Power BI dashboard covering every IPL season from 2008–2022. Connected to MS SQL Server & PostgreSQL, with advanced DAX and time intelligence.

Power BIDAXSQL ServerPostgreSQL
🛍️

Customer Shopping Behaviour Dashboard

A Power BI dashboard built from 3,900 retail transactions across 50 locations, exploring customer shopping behaviour for loyalty, marketing, and subscription strategy.

Power BISQL ServerFeature EngineeringRetail
📊

Blinkit Sales Analysis Dashboard

An interactive Power BI dashboard analysing 8,500+ retail item records across outlet formats and locations for executive decision-making.

Power BIDAXSQLRetail
🌿

Plant Co. Performance Report

Built an interactive Power BI dashboard comparing YTD vs PYTD sales, gross profit, and quantity with instant metric toggling.

Power BIDAXPower QueryExcel
🛒

Retail Loyalty Program Analytics

Advanced SQL on a multi-table retail dataset to extract purchase patterns, segment loyalty members, and track retention with Python visualisations.

PostgreSQLPythonPandasSeaborn
🔍

Advanced SQL Data Analytics

A complete data pipeline in PostgreSQL — database creation, EDA, KPI calculation, and customer/product segmentation for business-ready reports.

PostgreSQLSQLData PipelineSegmentation
🎓

Developer Survey Capstone

Explored how developer compensation, satisfaction, and tech preferences vary by age, role, and geography using the Stack Overflow Survey.

PythonSQLLooker StudioEDA
📚

Library Database Management

Designed a relational database for library operations — book rentals, returns, stock management, and staff performance tracking.

SQLDDL/DMLStored Procedures

✦ About This Project

⚡ Key Features

</> Tech Stack

Let's Work Together

Whether you're looking for a data analyst, want to collaborate on a project, or just want to talk analytics and retail — my inbox is always open.

Resume — Rosewal Almeida