SR

Saptarshi Rakshit

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.

Identity verified by DigiLockerDegree confirmed by N.I.T. Warangal, La Trobe University
Contact details — on requestProof of Work — on request

Experience

C

Associate Consultant, Big Data and EDW III

Celebal Technologies, Mumbai · Jun 2026 – Present

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

Business Analyst

Atomberg Technologies, Mumbai · Aug 2024 – Aug 2025

Not yet confirmed
  • 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.
D

Customer Data Analyst

Directed Technologies, Melbourne · Nov 2021 – Mar 2024

Not yet confirmed
  • 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.
D

Patient Analytics Intern

DPV Health, Melbourne · Mar 2021 – Jun 2021

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

Software Engineering Intern

Siemens, Doha · Oct 2018 – May 2019

Not yet confirmed
  • 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.

Skills 0 proven through work

Also works with

Lead Data EnrichmentGoogle Maps API IntegrationDBSCAN ClusteringK-Means ClusteringStreamlit Application DevelopmentCustomer Behavior AnalysisLogistic Regression ModelingCustomer Churn PredictionStrategic PlanningRegression Metric InterpretationModel Metric Selection & InterpretationMonte Carlo SimulationSARIMA ModelingETL Pipeline DevelopmentForecastingFuzzy Matching Algorithm ImplementationCosine SimilarityAlgorithm Design & OptimisationTabular Data Cleaning & ValidationData-Driven RecommendationsSales AnalysisSeaborn VisualizationAutomated Report GenerationPython DevelopmentQuery WritingER Diagram DesignData MigrationDatabase ManagementData Architecture DesignData ExtractionExploratory Data Analysis (EDA)Operational Performance TrackingReal-Time Dashboard DevelopmentTask AutomationWeighted Scorecard Development

Proof of Work

Proof of Work

Saptarshi shares this with people who ask. You'll hear back either way.

Education

B.Tech, Electronics and Communication Engineering

N.I.T. Warangal · 2014 — 2018

Verified

Master of Business Analytics, Business Analytics

La Trobe University · 2019 — 2021

Verified

Contact details

Contact details

Saptarshi shares this with people who ask. You'll hear back either way.

Ask about this candidate

ClaudeChatGPTPerplexity

AI responses may contain errors. Proof status and source information are provided by Proof of Skill.

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