dipti User

DU

Open to opportunities

dipti User

@diptiuser1

Business Analyst at 1DigitalStack.ai automating e-commerce analytics across Amazon, Blinkit, Swiggy and Zepto.

At 1DigitalStack.ai, I built an automated analytics product covering market share, share of voice, BCG analysis, competitive landscape, and regional revenue across Amazon, Blinkit, Swiggy, and Zepto. I automated the SQL/Trino-to-Python reporting pipeline to produce 22 client-ready decks in under three hours, replacing a manual process that took three to four days.

I also built Python pipelines for SKU-level sales estimation and automated share-of-voice reporting across 2,800+ search keywords. Earlier, I built Power BI pricing dashboards and Selenium crawlers at 1DigitalStack.ai, and worked on independent projects in Swiggy funnel analysis and retail demand forecasting.

Experience

Work history, roles, and key accomplishments

DI

Current

Business Analyst

Current

1DigitalStack.ai

Apr 2025 - Present (1 year 7 months)

Built automated analytics products and reporting pipelines for e-commerce and quick-commerce channels, reducing reporting time from 3-4 days to under 3 hours. Scaled to multiple enterprise FMCG clients.

SQL Trino Python Power BI ETL Selenium Market Share Analysis Share Of Voice Pricing Analysis Data Storytelling

DI

Analyst

1DigitalStack.ai

Dec 2022 - Mar 2025 (2 years 3 months)

Developed SKU-level pricing dashboards and optimized complex SQL queries for e-commerce datasets. Built Selenium crawlers and automated reporting, improving team efficiency by over 50%.

SQL Power BI Selenium Python Excel E commerce analytics Pricing Analysis

PT

Lecturer, Electrical Engineering

Pusa Institute of Technology

Sep 2018 - Apr 2022 (3 years 7 months)

Taught circuit theory, power systems, and control systems to over 100 students, explaining complex quantitative concepts clearly.

Teaching Circuit Analysis Power Systems Control Systems

Education

Degrees, certifications, and relevant coursework

AN

AIACTR (East Campus, NSUT)

M.Tech, Signal Processing

2015 - 2017

M.Tech in Signal Processing with specialization in ML-based Biometric Recognition. Thesis on Minutiae-based Fingerprint Enhancement & Reconstruction.

HU

HMRITM, GGSIP University

B.Tech, Electrical & Electronics Engineering

2011 - 2015

B.Tech in Electrical & Electronics Engineering.

HA

HackerRank

HackerRank SQL (Intermediate, Basic), SQL

Completed HackerRank SQL certifications at Intermediate and Basic levels.

MY

MySQL

MySQL Data Analysis, Data Analysis

Completed MySQL Data Analysis certification.

SK

Skillovilla

Skillovilla Data Analytics Career Track, Data Analytics

Completed the Skillovilla Data Analytics Career Track.

Tech stack

Software and tools used professionally

Selenium

NumPy

Pandas

MySQL

Python

SQL

XGBoost

LightGBM

CatBoost

Trino

Matplotlib

Power BI

Availability

Open to opportunities

Location

India

Authorized to work in

Social media

Job categories

Skills

E commerce analytics Logistics and Quick Commerce Analytics Market Share Analysis Share Of Voice Pricing Analysis Digital Shelf Analytics SKU Level Sales Estimation Funnel Analysis Forecasting Statistical Analysis ETL Pipelines KPI Design SQL Trino Python

Interested in hiring dipti?

You can contact dipti and 90k+ other talented remote workers on Himalayas.

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!