Saptarshi Rakshit

+•• ••••• •••••••••••@•••••.com

Associate Consultant, Big Data and EDW III · Celebal Technologies, Mumbai · 4.6 yrs

As an Associate Consultant with 5 years of experience in Big Data and EDW, I thrive on independently tackling complex challenges with a highly logical and organized approach. My passion lies in creatively designing and implementing robust, high-quality solutions, driven by a commitment to technical mastery and an idealistic vision for perfectly structured systems.

Ask about Saptarshi

Skills

Claimed

Lead Data EnrichmentGoogle Maps API IntegrationDBSCAN ClusteringK-Means ClusteringStreamlit Application DevelopmentCustomer Behavior AnalysisLogistic Regression ModelingCustomer Churn PredictionStrategic PlanningRegression Metric InterpretationModel Metric Selection & InterpretationMonte Carlo Simulation

Proof of Experience

Associate Consultant, Big Data and EDW III

Celebal Technologies, Mumbai · Jun 2026 – Present

  • Built automated supplier performance scorecards (on-time delivery, quality, cost metrics) across the supply chain, improving vendor accountability and cutting late shipments by 31%.

Business Analyst

Atomberg Technologies, Mumbai · Aug 2024 – Aug 2025

  • Designed and implemented complete database architecture by migrating sales data from Excel to relational database through ETL pipelines and setting up primary keys and foreign keys.
  • Automated tasks performed routinely by MIS Executives through the application of Python Scripts.
  • Developed Python-based dashboards fetching data from SQL tables and generating Excel reports distributed via Outlook to senior leadership including National Sales Manager, Zonal/Regional/Area Sales Managers, and Head of Supply Chain to support GTM, Supply Chain, and Sales operations.
  • Implemented data deduplication algorithm using Cosine Similarity and Levenshtein Distance to identify 1,041 duplicate retailer records, combining text similarity analysis with geospatial coordinate matching, validated by ground sales.
  • Built comprehensive sales forecasting pipeline combining SARIMAX time series modeling with Monte Carlo simulation, predicting both new retailer acquisition numbers and their expected sales volumes by leveraging historical conversion patterns of 'cold' retailers, enabling probabilistic revenue forecasting with confidence intervals.
  • Built predictive churn model using logistic regression to identify at-risk retailers for next FY, achieving 70% predictive accuracy (AUC = 0.82), with key insight that retailers selling fewer product models (lower Range) had 11x higher churn probability, enabling proactive retention strategies.
  • Developed and delivered an automated system (as a Streamlit Application) which clusters retail locations geographically using DBSCAN and KMeans algorithms, dynamically balances cluster sizes for optimal sales beats.
  • Integrated Google Maps API for address enrichment, delivered interactive maps for route planning, and provided a streamlined workflow for field sales operations to maximize efficiency and coverage.
  • Developed interactive geospatial mapping solution using Python to identify nearest retail partners across all Indian postal codes, presenting location intelligence insights to C-suite leadership for strategic expansion planning.

Customer Data Analyst

Directed Technologies, Melbourne · Nov 2021 – Mar 2024

  • Developed and executed an ETL pipeline to migrate 70 lakh rows of data from Microsoft SQL Server to SingleStore, ensuring data integrity and facilitating efficient storage in the new database.
  • Employed a Decision Tree model (77% accuracy) to predict customer subscription renewals, resulting in a 15% increase in customer acquisition.
  • Led the identification of fuel tax credit opportunities for clients, saving them over Rs 17 crore through analysis of 6 million+ data points.
  • Utilized a multi-variable regression model in Python (75.1% accuracy) to forecast safety risks occurring during trips based on driving behavior patterns.
  • Developed interactive dashboards to visualize data anomalies and trends, enabling stakeholders to meet commercial needs.
  • Collaborated with the Firmware Engineering team to identify erroneous data and its root causes leading to improvement of data quality by 85%.
  • Engaged with SMEs to identify data opportunities and undertook accountability for delivering multiple projects.
  • Leveraged SQL to extract data from large databases by employing fine-tuned SQL queries.
  • Analyzed large GPS and Google Maps API datasets using parallel processing techniques in Python to identify customers visiting competing dealerships.

Patient Analytics Intern

DPV Health, Melbourne · Mar 2021 – Jun 2021

  • Developed a demand forecasting program using a Generalized Additive Model.
  • Employed an interactive dashboard to present forecasts to non-technical stakeholders.

Software Engineering Intern

Siemens, Doha · Oct 2018 – May 2019

  • Integrated a plug-in within the Asset Management System for capturing 360-degree images of electrical elements for monitoring element health.
  • Implemented an acknowledgment mechanism between a fieldwork app and workers using it.

Proof-of-Work

No completed sessions yet. Anything Saptarshi finishes shows up here with the evidence behind it.

Proof of Education

B.Tech, Electronics and Communication Engineering

N.I.T. Warangal · 2014 — 2018

Master of Business Analytics, Business Analytics

La Trobe University · 2019 — 2021

A Proof CV — one profile, kept current, with the proof attached. Back to the portal