Saurabh Shrivastav

Saurabh Shrivastav

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

نبذة عني

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…

الخبرة

Senior Data & Business Intelligence Analyst

Subcodevs Inc.
Sep 2023 - حتى الآن · 2 سنوات 10 أشهر

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 - حتى الآن · 2 سنوات 10 أشهر

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 أشهر

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 أشهر

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 سنوات 6 أشهر

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 سنوات 6 أشهر

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.

المشاريع

Smart Recommendation System

Queen Mary's College
المدة : 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

الشهادات

Python for Artificial Intelligence

IIT · Mumbai, India · 2019

المهارات

إكسل بايثون (لغة برمجة) فيجوال بيسك للتطبيقات (VBA) جيت (GIT) منصة GitHub للتعاون على تطوير البرمجيات أدوات ETL من إنفورماتيكا Powercenter مؤشر الأداء الرئيسي (KPI) الجداول المحورية التصور البياني للبيانات خدمات أمازون ويب (AWS) باور بي آي تابلو 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
الإبلاغ عن هذا الملف الشخصي؟