# Aanchal Rath

Aanchal Rath is a remote worker on Himalayas, Data Analyst at Paytm, based in India.

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

```text
Data Analyst at Paytm who built SQL merchant-risk detection and automated MySQL reporting with Python.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India, United States, United Kingdom |
| Salary expectations | 70k+ INR |
| Job categories | Data Analyst, AI Engineer, Machine Learning Engineer |
| Skills | Data Analysis, SQL, Risk Detection, Churn Analysis, Python, Machine Learning, Computer Vision, Data Structures And Algorithms, MySQL, Pandas, SQLAlchemy, NumPy, Matplotlib, XGBoost, OpenCV |

## About

```text
At Paytm, I built SQL threshold queries and depletion rules to identify at-risk merchants. I also designed MTD-versus-NMTD reports to track merchant activity trends and flag early signs of churn.

I automated data extraction from MySQL with a Python pipeline using pandas and SQLAlchemy, streamlining operations-team reporting. I also created Excel dashboards to surface merchant churn-risk insights for business stakeholders.

In my projects, I built a command-line video stabilizer using KLT optical flow and developed AI projects for health prediction and cultural-heritage exploration. I’m studying Computer Science Engineering with an AI/ML specialization at Vellore Institute of Technology.
```

## Experience

### Data Analyst

[Paytm](https://himalayas.app/companies/paytm). May 2026 - Jul 2026

```text
Built GMV-based merchant risk detection logic using SQL threshold queries and depletion rules to identify at-risk merchants. Designed MTD vs. NMTD comparison reports to track merchant activity trends and flag early signs of churn.
```

Skills: SQL, Python, Pandas, SQLAlchemy, Excel, Data-Analysis, Risk-Detection, Reporting

## Education

### Vellore Institute of Technology

B.Tech, Computer Science Engineering with specialization in AI/ML. 2024 - Present. Grade: 8.1 GPA

```text
Pursuing a B.Tech in Computer Science Engineering with a specialization in AI/ML, with an expected graduation in 2028.
```

## Tech stack

- NumPy
- Pandas
- MySQL
- Figma
- OpenCV
- Python
- Java
- C++
- SQLAlchemy
- pytest
- Git
- SQL
- XGBoost
- Matplotlib
- Google Cloud

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

## People also viewed

- [Hariharan Jothiraman](https://himalayas.app/@Hariharan_Jothiraman): Data Analyst, Self Employed
- [Gowhar Addepalli](https://himalayas.app/@gowharaddepalli): Data Science & Analytics Intern, Zidio Development
- [Pavanteja Reddy](https://himalayas.app/@pavantejareddy): Data Analyst, Teleperformance Global Solutions Pvt. Ltd.
- [Aayush Pant](https://himalayas.app/@aayushpant): Independent Learning & Exam Prep, Independent Learning & Competitive Exam Preparation
- [Hari Hari](https://himalayas.app/@harihari1): Data Analytics Intern, LearnTube.ai
- [NAGA VAISHNAVI](https://himalayas.app/@nagavaishnavi): Data Science Undergraduate, Mahatma Gandhi Institute of Technology
- [PATLOLA ASHWITH REDDY](https://himalayas.app/@patlolaashwithreddy): B.Tech Student, St. Peter's Engineering College
- [Bhoumesh Kumar Dutta](https://himalayas.app/@bhoumeshkumardutta1): Data Analyst Intern, Techcoder Software (OPC) Pvt. Ltd.
- [Neha Arabati](https://himalayas.app/@nehaarabati): Volunteer, IEEE Student Club
- [Navadeep S](https://himalayas.app/@navadeeps): Data Science Intern, Prodigy Infotech
