Saurabh Shrivastav

Saurabh Shrivastav

Data Analyst | Business Intelligence Analyst | AI Software Developer
India
Marathi, Hindi, English

About Me

Results-driven Data Analyst and BI Analyst with 5 years of experience delivering actionable insights and automated analytics solutions for product, marketing, and business teams. Specialized in SQL, Power BI, Tableau, an…

Experience

Senior Data & Business Intelligence Analyst

Subcodevs Inc.
Sep 2023 - Present · 2 years 10 months

Led end-to-end analytics delivery for 50+ global clients across retail, e-commerce, and SaaS, producing executive level KPI frameworks and decision-ready insights for C-suite and functional leaders.
Engineered automated ETL pipelines using Python, SQL, and Apache Airflow, reducing reporting latency by 40% and improving data reliability across batch workflows.
Designed and deployed 20+ interactive dashboards in Power BI and Tableau covering revenue, CAC, retention, conversion funnels, and profitability; improved decision turnaround time by over 27%.
Conducted advanced customer segmentation using Python (Pandas, NumPy, scikit-learn) and SQL, improving campaign targeting, precision and driving a 20% increase in repeat engagement.
Provided technical mentorship to a team of seven analysts in BI development, data modelling, and exploratory analysis, resulting in a 30% increase in team output and reporting consistency.

Senior Data & Business Intelligence Analyst

Subcodevs Inc. · London, UK
Aug 2023 - Present · 2 years 10 months

Led end-to-end analytics delivery for 50+ global clients across retail, e-commerce, and SaaS, producing executive level KPI frameworks and decision-ready insights for C-suite and functional leaders. Engineered automated ETL pipelines using Python, SQL, and Apache Airflow, reducing reporting latency by 40% and improving data reliability across batch workflows. Designed and deployed 20+ interactive dashboards in Power BI and Tableau covering revenue, CAC, retention, conversion funnels, and profitability; improved decision turnaround time by over 27%. Conducted advanced customer segmentation using Python (Pandas, NumPy, scikit-learn) and SQL, improving campaign targeting, precision and driving a 20% increase in repeat engagement. Provided technical mentorship to a team of seven analysts in BI development, data modelling, and exploratory analysis, resulting in a 30% increase in team output and reporting consistency.

Data & Business Intelligence Analyst

Pitra (London-based Startup)
Dec 2022 - Aug 2023 · 8 months

Designed and deployed Power BI dashboards for finance and operations, covering revenue, CLV, CAC, retention, and profitability KPIs; reduced reporting cycles by 40% and improved strategic decision making by 30%.
Performed in-depth analysis of Shopify transactional, behavioural, and marketing data using SQL and Python, contributing to a 15% increase in campaign efficiency and clearer ROI tracking.
Built a multi-layer ROI attribution framework incorporating CLV, margin structures, and channel performance, improving marketing budget allocation accuracy by 25%.
Developed role-specific, drill-down dashboards with real-time filtering to strengthen self-service analytics and reduce dependency on manual reports.
Collaborated with product and marketing leads to define KPI structures, validate data pipelines, and improve data integrity, resulting in a 20% reduction in reporting discrepancies.

Data & Business Intelligence Analyst

Pitra · Greater London, UK
Nov 2022 - Jul 2023 · 8 months

Designed and deployed Power BI dashboards for finance and operations, covering revenue, CLV, CAC, retention, and profitability KPIs; reduced reporting cycles by 40% and improved strategic decision making by 30%. Performed in-depth analysis of Shopify transactional, behavioural, and marketing data using SQL and Python, contributing to a 15% increase in campaign efficiency and clearer ROI tracking. Built a multi-layer ROI attribution framework incorporating CLV, margin structures, and channel performance, improving marketing budget allocation accuracy by 25%. Developed role-specific, drill-down dashboards with real-time filtering to strengthen self-service analytics and reduce dependency on manual reports. Collaborated with product and marketing leads to define KPI structures, validate data pipelines, and improve data integrity, resulting in a 20% reduction in reporting discrepancies.

Data Analyst & AI Software Developer

Subcodevs Inc.
Dec 2019 - Jun 2022 · 2 years 6 months

Designed and implemented analytical data models and Power BI dashboards for 15+ retail and e-commerce clients, reducing reporting turnaround by 35% and improving leadership decision latency.
Conducted customer trend and behavioural analysis using SQL and Python, enabling targeted retention campaigns that increased repeat engagement by 20%.
Developed and deployed machine learning models for churn prediction and performance optimisation, contributing to an 18% reduction in customer attrition through personalised interventions.
Built recommendation systems using Python, SQL, and collaborative filtering techniques, improving recommendation accuracy by 20% and strengthening user retention.
Automated end-to-end data pipelines, improving data flow reliability and reducing manual workload by 30%, enabling the analytics team to shift focus toward strategic insights.

Data Analyst & AI Software Developer

Subcodevs Inc. · New Delhi
Nov 2019 - May 2022 · 2 years 6 months

Designed and implemented analytical data models and Power BI dashboards for 15+ retail and e-commerce clients, reducing reporting turnaround by 35% and improving leadership decision latency. Conducted customer trend and behavioural analysis using SQL and Python, enabling targeted retention campaigns that increased repeat engagement by 20%. Developed and deployed machine learning models for churn prediction and performance optimisation, contributing to an 18% reduction in customer attrition through personalised interventions. Built recommendation systems using Python, SQL, and collaborative filtering techniques, improving recommendation accuracy by 20% and strengthening user retention. Automated end-to-end data pipelines, improving data flow reliability and reducing manual workload by 30%, enabling the analytics team to shift focus toward strategic insights.

PROJECTS

Smart Recommendation System

Queen Mary's College
Duration : 30-Nov-2022 - 31-Aug-2023

Enhanced an existing industry recommendation model by developing a hybrid system using Python, Pandas, and scikit-learn with real e-commerce data, employing data preprocessing, feature engineering, and ML algorithms (matrix factorisation, item-based filtering). Achieved a 20% improvement in recommendation accuracy, significantly boosting user engagement on a live platform. Skills: Data Wrangling, Python, ML Modelling, A/B Testing, Business Impact

Certifications

Python for Artificial Intelligence

IIT · Mumbai, India · 2019

Skills

Excel Python Visual Basic for Applications (VBA) GIT Version Control (GIT) GitHub Informatica PowerCenter ETL Key Performance Indicator (KPI) Pivot Tables Data Visualization Amazon Web Services (AWS) Power BI Tableau Apache Airflow S3 EC2 RDS MySQL PostgreSQL Advanced Excel Pandas NumPy scikit-learn Google Analytics Shopify Analytics DAX Power Query Git VLOOKUP Array formulas Data modelling Machine learning Data visualisation Dashboard design KPI development Reporting automation Business metrics analysis Executive reporting Data storytelling SQL query optimisation Window functions Joins Data cleaning Data wrangling Validation ETL pipeline optimisation Python scripting Predictive analytics Statistical modelling Stakeholder management Executive communication Cross-functional leadership Mentoring Business acumen Decision support Process improvement
Report this Profile?