# Prachi Gupta

Prachi Gupta is a remote worker on Himalayas, Data Analyst Intern at Bluestock, based in India.

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

```text
Data Analyst Intern at Bluestock who built a mutual fund analytics pipeline measuring risk and performance.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 401k+ INR |
| Job categories | Data Analyst |
| Skills | Data Analysis, Mutual Fund Analysis, Financial Performance, CAGR, Sharpe Ratio, Sortino Ratio, Value At Risk (VaR), CVaR, Data Ingestion, data transformation, Database Design, Star Schemas, AI ML, Frontend Development, API Development |
| LinkedIn | https://linkedin.com/in/prachi-gupta10 |

## About

```text
At Bluestock, I built a multi-phase mutual fund performance analytics pipeline using Python and SQLite, with a star schema database design.

I managed data ingestion and transformation with SQLAlchemy and developed Jupyter Notebooks with analytical charts. I analysed CAGR, Sharpe Ratio, Sortino Ratio, and Value at Risk across fund categories.

At TechHack 2.0, I helped build an AI-powered police assistance platform that won the Smart AI for Government Services track. I led frontend development and API generation for a chatbot that helps officers identify applicable laws and generate FIR drafts.

I also developed a POS and quick commerce integration model for real-time inventory tracking, and a digital health platform for Kerala workers with an Emergency SOS Button, AI chatbot, and multilingual interface.
```

## Experience

### Data Analyst Intern

Bluestock. May 2026 - Jul 2026

```text
Built a multi-phase mutual fund performance analytics pipeline using Python and SQLite with a star schema database design. Managed data ingestion and transformation via SQLAlchemy and developed Jupyter Notebooks with analytical charts.
```

Skills: Python, SQLite, SQLAlchemy, Jupyter-Notebooks, Data-Analysis, Investment-Analytics, CAGR, Sharpe-Ratio, Sortino-Ratio, Value-At-Risk-(VaR)

## Education

### Oriental Institute of Science and Technology (RGPV)

Bachelor of Technology, Information Technology. 2023 - Present

```text
Pursuing a Bachelor of Technology in Information Technology from 2023 to 2027.
```

### S.T. Joseph’s Convent School

Higher Secondary Certificate, General Studies. 2022 - 2023

```text
Completed Class XII with a Higher Secondary Certificate from 2022 to 2023.
```

### S.T. Joseph’s Convent School

Secondary School Certificate, General Studies. 2020 - 2021

```text
Completed Class X with a Secondary School Certificate from 2020 to 2021.
```

## Tech stack

- MongoDB
- SQLite
- Node.js
- JavaScript
- Python
- Java
- SQLAlchemy
- SQL
- Power BI

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

## People also viewed

- [Suraj Narayan User](https://himalayas.app/@surajnarayanuser): Data Analyst Intern, Bluestock Fintech
- [saivardhan yejjipurapu](https://himalayas.app/@saivardhanyejjipurap): Data Analyst Intern, Bluestock
- [Hifza Tanveer](https://himalayas.app/@hifzatanveer): Data Analyst Intern, Bluestock Fintech
- [Kalyan Parvatham kalyan](https://himalayas.app/@kalyanparvathamkalya): Data Analyst Intern, Bluestock Fintech
- [Deepansh Arora](https://himalayas.app/@deepansharora): Data Analyst Intern (Python Engineering), Bluestock Fintech
- [Arushi Awasthi](https://himalayas.app/@arushiawasthi): Data & Systems Intern, Bluestock Fintech
- [Neha Pole](https://himalayas.app/@nehapole): Data Analyst Intern, Bluestock Fintech
- [Nishant Parmar](https://himalayas.app/@nishant2011): Data Analyst Intern, Bluestock Fintech
- [Sumit Sharma](https://himalayas.app/@sumitsharma28): Data Analyst Intern, Bluestock Fintech
- [Ayeman Fathima](https://himalayas.app/@ayemanfathima): Data Analytics Intern, Bluestock Fintech
