Skip to main content
aanshi rathiAR
Looking for a job

aanshi rathi

@aanshirathi

Business Analyst Intern at Amazon who built a QuickSight dashboard tracking inventory delays across 100+ warehouses.

India
Message

At Amazon, I developed SQL queries and ETL pipelines across transshipment and inventory data to support automated root-cause analysis of recurring delays. I also built an Amazon QuickSight dashboard tracking inventory delays across 100+ warehouses.

I created an Audit Insights view that classified 8,000 fulfilment centre audit reports into root-cause categories, and prototyped an ORCA workflow to identify and delete stuck inventory past operational deadlines.

At GreenCell Mobility, I estimated Customer Lifetime Value from transaction data and segmented customers into three tiers to guide retention strategy. I also flagged a competitor pricing anomaly that was confirmed and resolved.

In my projects, I compared forecasting models for Walmart sales and gold prices, and built a Python RAG-based document assistant using Streamlit and ChromaDB. My work includes testing safeguards against unsupported answers and providing source citations.

Experience

Work history, roles, and key accomplishments

Amazon logoAM

Business Analyst Intern

Jan 2026 - Jun 2026 (5 months)

Developed SQL queries and ETL pipelines joining 7 tables across millions of rows to support automated root-cause analysis of recurring delays. Built an Amazon QuickSight dashboard tracking inventory delays across 100+ warehouses and an Audit Insights view classifying 8,000 audit reports.

GM

Data Analyst Intern

GreenCell Mobility

Jun 2025 - Jul 2025 (1 month)

Estimated Customer Lifetime Value (CLTV) from transaction data and segmented customers into 3 tiers to guide retention strategy. Spotted a pricing anomaly on a competitor's website during benchmarking and flagged it to the sales team.

Data Analysis
CLTV
SegmentationBenchmarking

Education

Degrees, certifications, and relevant coursework

SI

Symbiosis Statistical Institute

B.Sc. (Hons), Applied Statistics and Data Science

Grade: CGPA: 9.0

Pursued a B.Sc. (Hons) in Applied Statistics and Data Science, achieving a CGPA of 9.0.

DK

Delhi Public School, Vasant Kunj

Class XII, PCM

Grade: 95%

Completed Class XII (PCM) with 95%.

Interested in hiring aanshi?

You can contact aanshi and 600K+ other talented remote workers on Himalayas.

Message aanshi

People also viewed

View all talent

Get matched with your dream remote job

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

Sign up
Himalayas profile for an example user named Frankie Sullivan