Prathamesh
Sawant
Data Analyst with 4+ years of experience turning complex datasets into clear decisions. Specialising in Power BI, SQL, Python and cloud analytics across media, pharma, and sustainability sectors.
Turning data into decisions
I'm a Data Analyst and RevOps professional with 4+ years of experience across pharmaceuticals, digital media, and sustainability sectors. My career has progressed from Junior Data Analyst at Capgemini through to Data Analyst at HAVAS Media, and currently RevOps Analyst at Climate Impact Partners — a Certified B Corp.
I specialise in building interactive Power BI dashboards, writing production-grade SQL, and automating reporting pipelines with Python and Azure Data Factory. Whether it's stakeholder-facing KPI reports, A/B testing analysis, or machine learning models for customer behaviour — I turn raw, multi-source data into clear, actionable insight.
I hold an MSc in Advanced Computer Science with Merit from the University of Exeter, where I focused on data science, AI, and optimisation algorithms. I'm comfortable presenting complex findings to both technical teams and senior leadership.
My analytics toolkit
A full-stack data skill set — from raw SQL and Python pipelines through to polished Power BI dashboards and ML models.
Data Visualisation
Programming & Analysis
Database & Storage
ETL & Automation
Cloud & Infrastructure
CRM, GTM & Methodology
Professional journey
4+ years progressing from Junior Data Analyst through to RevOps Analyst across pharma, media, and sustainability.
RevOps Analyst
- Build impactful dashboards, analytical reports, and data visualisations using Power BI, SQL, and Python across operational, commercial, and sustainability-focused business initiatives.
- Collaborate with Finance, Commercial, Operations, Technology, and Customer teams to define and deliver analytical solutions aligned with organisational objectives.
- Develop and maintain cloud-based reporting pipelines using SQL, Python, and Azure-based data environments to support scalable and reliable business reporting.
- Ensure data quality, consistency, and accuracy across dashboards and KPI deliverables through structured validation and governance practices.
- Analyse large multi-source datasets to identify operational trends, stakeholder behaviour patterns, and opportunities for process optimisation across sustainability and commercial activities.
- Present analytical findings clearly to both technical and non-technical audiences, supporting leadership discussions and strategic planning.
Data Analyst
- Led data analytics projects to optimise user experience and conversion rates for ecommerce platforms, developing strategic insights that informed design and marketing decisions.
- Designed and implemented interactive dashboards using Power BI, visualising ecommerce KPIs and customer behaviour trends for marketing and sales teams.
- Collaborated cross-functionally to conduct A/B testing and user research, identifying optimisation opportunities that improved site navigation, layout, and content strategy.
- Regularly analysed sales and conversion data, presenting actionable recommendations to stakeholders for campaign adjustments and strategic planning.
Junior Data Analyst
- Developed interactive dashboards and reports to visualise medical and pharmaceutical data using Power BI and Tableau, empowering stakeholders with real-time KPI insights.
- Conducted rigorous data cleaning, transformation, and validation processes on large-scale datasets using SQL and Python to ensure accuracy and reliability.
- Performed exploratory data analysis (EDA) to uncover trends and actionable insights from clinical and pharmaceutical datasets, supporting evidence-based recommendations.
- Delivered ad-hoc analyses and custom reports using Excel and Power Query, providing timely insights for operational needs.
- Automated recurring reporting tasks using scripting and advanced Excel functions, significantly reducing manual intervention and improving team efficiency.
What I've built
From Power BI dashboards to ML models — projects spanning data engineering, analytics, and AI.
Sales Performance Dashboard
Data Project · University of Exeter
Dec 2023 – Feb 2024
Built a Power BI dashboard tracking sales metrics, customer acquisition, and revenue growth in real-time. Integrated data from SQL databases and Excel to create a unified view of sales performance — improving reporting accuracy and reducing manual effort.
- Multi-source data integration (SQL + Excel)
- Real-time KPI tracking & trend analysis
- Automated refresh pipeline
- Stakeholder-ready visual narratives
Customer Churn Prediction
ML Project · University of Exeter
Nov 2023 – Jan 2024
Built a Logistic Regression model achieving 78% accuracy on customer churn prediction. Analysed customer behaviour data to identify key churn factors including usage patterns and demographics — enabling targeted retention strategies.
- 78% model accuracy with Logistic Regression
- EDA on usage patterns & demographics
- Feature engineering & model validation
- Actionable churn risk segmentation
Generative AI Smart Tutor
MSc Dissertation · University of Exeter
Feb 2024 – Aug 2024
Developed an adaptive learning platform using the Gemini Pro API to personalise content for computer science students. Implemented real-time data processing of student interactions, dynamically adjusting content difficulty and generating contextual examples.
- Gemini Pro API for adaptive content
- Real-time student interaction data pipeline
- Dynamic difficulty adjustment engine
- 40% improvement in engagement metrics
RevOps Analytics Platform
RevOps Analyst · Climate Impact Partners
Aug 2025 – Present
End-to-end revenue operations reporting suite built with Power BI, SQL, and Python on Azure. Tracks pipeline health, win rates, customer acquisition cost, and sustainability KPIs — serving commercial and executive stakeholders across the organisation.
- Live pipeline & revenue dashboards
- Azure Data Factory automation pipelines
- Cross-functional stakeholder reporting
- Sustainability & commercial KPI tracking
Academic background
MSc Advanced Computer Science
University of Exeter
Specialised in cutting-edge topics at the intersection of AI, optimisation, and scalable software systems. Completed a research dissertation on generative AI and adaptive learning platforms using the Gemini Pro API.
Bachelor of Engineering — Instrumentation Engineering
University of Mumbai
Built strong foundations in engineering, mathematics, and computing. Developed skills in both hardware and software systems that underpin my approach to scalable application design.
Let's turn data into impact
I'm actively looking for new opportunities in data analytics, BI, and RevOps in London and beyond. Whether you have a role or just want to connect — reach out.