I build data pipelines that turn messy, scattered sources into clean, verified databases, and the dashboards and apps people use to act on them. Currently a Data Analyst at Firmwise Services India (client: GAIL India Limited), working on SAP/Excel → Oracle ETL and Tableau Server dashboards.
📍 Noida, India · 🎓 B.Tech CSE (Data Science), UPES · 💼 1.5+ years in data analytics
CGD Station Data Platform · private, in active development An end-to-end platform mapping CNG stations of City Gas Distribution operators across India.
- Python extraction pipeline per operator:
discover → fetch → parse → normalize → validate, with robots.txt and Terms-of-Use checks before any source is collected - OpenStreetMap geocoding with an honest per-station precision class instead of fake exact points
- PostgreSQL + PostGIS database with numbered load batches, a change-audit table and SQL verification checks
- FastAPI backend with spatial "near me" and map-viewport queries, and a React Native (Expo) app with List/Map views, shipped as an Android build and a web build for internal testing
| Area | Tools |
|---|---|
| Languages | Python (Pandas, NumPy, Matplotlib, Seaborn), SQL, JavaScript |
| Databases | Oracle, SQL Server (SSMS), PostgreSQL + PostGIS, MySQL, MongoDB |
| Data engineering | ETL pipelines, web scraping (Scrapy, Requests, BeautifulSoup, Playwright), data cleaning & validation, data modeling, geocoding |
| BI & visualization | Tableau & Tableau Server, Power BI (DAX), Looker Studio, Excel |
| Apps & cloud | FastAPI, React Native / Expo, Next.js, AWS S3, Firebase, Git / GitHub |
| Project | What it shows |
|---|---|
| Automated Tradebook Data Pipeline | Python ETL for 1M+ tradebook records into SQL Server, optimised procedures, Power BI (DAX) dashboards |
| Spyder Project | Scrapy pipeline that turns store-locator pages into GeoJSON, with tests (HERE Technologies internship) |
| IoT Precision Agriculture | Raspberry Pi sensors, trained ANFIS model + 15-rule fuzzy controller for irrigation, Firestore logging, live charts |
| Vault Cloud | Next.js file-sharing rooms: invites, S3 pre-signed uploads, Firestore chat |
| SENSEX Crash Analysis | 28 years of SENSEX drawdowns, crash periods and an early-warning rule tested on real data (pandas, Plotly) |
- Data Analyst, Firmwise Services India (client: GAIL India Limited) · Feb 2026 – present
- Data Analyst, Arya Fin-Trade Services · Sep 2024 – Aug 2025
- Data Engineer Intern, HERE Technologies · Jun – Jul 2023
- Data Analyst Intern, Lendingkart Finance · Jul 2023
