# aanshi rathi

aanshi rathi is a remote worker on Himalayas, Business Analyst Intern at Amazon, based in India.

Source: https://himalayas.app/@aanshirathi

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

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 622k+ INR |
| Job categories | Business Analyst, Data Analyst |
| Skills | Business Analysis, Data Analysis, SQL, ETL, Statistical Analysis, Customer Lifetime Value (CLV), Customer Segmentation, Hypothesis Testing, regression, Classification, Time Series Analysis, Forecasting, Machine Learning, Root Cause Analysis, Data Visualization |
| LinkedIn | https://linkedin.com/in/aanshi-rathi |
| GitHub | https://github.com/aanshi8 |

## About

```text
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

### Business Analyst Intern

[Amazon](https://himalayas.app/companies/amazon). Jan 2026 - Jun 2026

```text
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.
```

Skills: SQL, ETL, Amazon-Quicksight, Data-Analysis, Automation

### Data Analyst Intern

GreenCell Mobility. Jun 2025 - Jul 2025

```text
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.
```

Skills: Data-Analysis, CLTV, Segmentation, Benchmarking

## Education

### Symbiosis Statistical Institute

B.Sc. (Hons), Applied Statistics and Data Science. Grade: CGPA: 9.0

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

### Delhi Public School, Vasant Kunj

Class XII, PCM. Grade: 95%

```text
Completed Class XII (PCM) with 95%.
```

## Tech stack

- Tableau
- Amazon Quicksight
- NumPy
- Pandas
- MySQL
- Python
- scikit-learn
- Streamlit
- SQL
- XGBoost
- ChromaDB
- Retrieval-Augmented Generation (RAG)
- Power BI

To contact aanshi, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Lucky User](https://himalayas.app/@luckyuser4): Business Analyst 1, Amazon
- [Somnath Mukherjee](https://himalayas.app/@somnathmukherjee2): Data Analyst Trainee, EME Academy
- [Sumit Mathur](https://himalayas.app/@sumitmathur): Data Visualization Intern, Excelerate
- [Kareena User](https://himalayas.app/@kareenauser): Data Analyst, Batsman Performance
- [Sreejit Dutta](https://himalayas.app/@sreejitdutta): Logistics & Operations Intern, Flipkart
- [Sudhanshu Wagh](https://himalayas.app/@sudhanshuwagh): E Commerce Customer Segmentation & Churn Analysis, Independent Data Analytics Project
- [Sidharth Kumar](https://himalayas.app/@sidharthkumar): Big Data & Business Management Intern, BharatCares
- [Saksham Kharbanda](https://himalayas.app/@sakshamkharbanda1): Operations Data Associate (L2), Amazon
- [Omb User](https://himalayas.app/@omdata): Business Analyst Intern, Apex Deploy
- [Havovi Jilla](https://himalayas.app/@havovijilla): Integration Analyst – Business Analytics, Amazon
