# Prateek kharwar

Prateek kharwar is a remote worker on Himalayas, Data Analyst Intern at CodeAlpha, based in India.

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

```text
Data Analyst Intern at CodeAlpha; built a product-listing analysis pipeline and created 12 visualizations.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 70k+ INR |
| Job categories | Data Engineer, Data Analyst |
| Skills | Data Engineering, ETL ELT Design, Data Warehouse, Dimensional Modeling, SQL, Python, BigQuery, DBT, Airflow, Data Quality Testing, Data Observability, Workflow Orchestration, CI CD, Google Cloud Platform, Apache Spark |

## About

```text
At CodeAlpha, I built an automated pipeline to scrape and clean more than 700 Flipkart product listings, preparing the data for analysis.

I explored pricing trends, rating distributions, and brand-level patterns with Pandas, Seaborn, and Matplotlib, then created 12 visualizations, including an executive KPI dashboard.

On QueryForge, my self-directed project, I developed a BigQuery data warehouse with a dbt transformation layer, data quality tests, and a Streamlit pipeline health dashboard.

I also built an automated weather data platform using Python, Apache Airflow, dbt, and GitHub Actions, with data-quality checks and historical backfill. My projects include analytics dashboards in Looker Studio and a Gemini-powered copilot that turns natural-language requests into validated BigQuery SQL.
```

## Experience

### Data Analyst Intern

CodeAlpha. May 2026 - Jun 2026

```text
Built an automated scraping-to-cleaning pipeline for 700+ Flipkart product listings using Selenium and BeautifulSoup, resolving encoding errors, merged fields, and duplicates. Conducted EDA with Pandas, Seaborn, and Matplotlib to uncover pricing trends, rating distributions, and brand-level patterns, and created 12 visualizations including an executive KPI dashboard.
```

Skills: Selenium, BeautifulSoup, Python, Pandas, SeaBorn, Matplotlib, EDA, Data-Cleaning, Data-Visualization

## Education

### Indian Institute of Technology Roorkee

Bachelor of Technology, Production and Industrial Engineering. 2021 - 2025. Grade: 7.094

```text
Bachelor of Technology in Production and Industrial Engineering from IIT Roorkee, completed in 2025 with a CGPA of 7.094.
```

### IBM

Introduction to Data Engineering, Data Engineering

```text
Completed Introduction to Data Engineering certification from IBM.
```

### HackerRank

Advanced SQL, SQL

```text
Completed Advanced SQL certification from HackerRank.
```

## Tech stack

- Apache Spark
- Selenium
- Google Cloud Platform
- GitHub Actions
- Pandas
- dbt
- Terraform
- Python
- Streamlit
- pytest
- Git
- Docker
- BeautifulSoup
- Airflow
- SQL
- Seaborn
- Matplotlib
- Power BI
- Looker Studio

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

## People also viewed

- [Sumit Shamlal Chaure](https://himalayas.app/@mitSu): Data Science Intern, Skill Academy by Testbook
- [Nipun Sharma](https://himalayas.app/@nipunsharma2): Data Analytics Intern, IBM SkillsBuild
- [sakshi dosaya](https://himalayas.app/@sakshidosaya): Trainee Consultant, Circulants
- [Priyanka Burra](https://himalayas.app/@priyankaburra): Data Analytics Intern, CodeAlpha
- [Dheeraj User](https://himalayas.app/@dheerajuser5): Data Engineer Intern, Greenfield Analytics
- [Praveen K](https://himalayas.app/@Praveenk2): Data Analyst, Sapiens Research and Analysis
- [Kiranchandran H](https://himalayas.app/@kiranchandranh): Testing Intern – Data Validation & Automation Support, AppGlide Solutions
- [Sayan karmakar](https://himalayas.app/@sayankarmakar2): Data Analyst, Flipkart
- [Rituraj Singh Shekhawat](https://himalayas.app/@riturajsinghshekhawa): Artificial Intelligence Intern, Pinnacle Labs
- [Ujjawal pratap choubey](https://himalayas.app/@ujjawalpratapchoubey): Business Development Associate, Urban Company
