About
Data Analyst with internship experience and two end-to-end cloud data projects built on Azure and Snowflake. I work with SQL, Python, Excel, and Power BI to collect, clean, validate, and model data from multiple sources, and I’ve published an auto-refreshing dashboard. I’m looking for a fresher Data Analyst role where I can turn messy data into decisions, and I’m keen to grow toward data engineering.
Experience1
Data Analyst Intern
Dec 2025 — Aug 2026Sandvirp Solutions · Internship · Pune
• Cleaned, transformed and standardized datasets using Python (Pandas) and SQL to improve the accuracy and consistency of downstream reports. • Performed EDA to surface trends, patterns and anomalies, and presented the findings as actionable business insights. • Built interactive Power BI dashboards to track KPIs, enabling stakeholders to monitor performance and make data-driven decisions. • Wrote SQL queries to validate and aggregate datasets and flag data inconsistencies, supporting reliable, accurate reporting.
Projects4
Mandi Price Data Pipeline
Published an auto-refreshing Power BI dashboard on the Snowflake gold layer, fed by an end-to-end ELT pipeline that ingests daily agricultural commodity prices from the data.gov.in REST API into Azure ADLS Gen2. Organized data into bronze, silver, and gold layers and built PySpark and dbt transformations to cleanse, standardize, and load curated tables. Combined a historical backfill from bulk datasets with automated daily incremental API loads, scheduled and orchestrated with Azure Managed Airflow. Secured credentials and secrets with Azure Key Vault.
Open on github.com- Python
- SQL
- PySpark
- dbt
- Airflow
- Snowflake
- Azure ADLS Gen2
- Azure Key Vault
- Power BI
- Git
Urban Mobility and Fleet Data Pipeline
Built a cloud ELT pipeline from Azure ADLS Gen2 into Snowflake, processing ~869K raw trip records across raw, staging, dimensional core, and mart layers. Ingested historical trip datasets and GBFS transit feeds using Python and SQL load routines, with Bash scripting on Linux for file handling. Designed a star-schema dimensional model with fact and dimension tables; implemented source-to-target mapping, data quality validation, and lineage tracking. Authored technical documentation covering business requirements, end-to-end architecture, data flow, and the dimensional model.
Open on github.com- Snowflake
- SQL
- Python
- Azure ADLS Gen2
- Bash/Linux
- Power BI
- Git
Mandi Price Analytics Dashboard
Built an end-to-end pipeline from the data.gov.in REST API to an auto-refreshing Power BI dashboard on Snowflake, tracking daily agricultural commodity prices. Modeled raw data into curated gold-layer tables with dbt, using a bronze-silver-gold (medallion) design on Azure ADLS Gen2. Automated daily incremental API loads and a historical backfill with Python and Apache Airflow, removing manual refreshes. Secured credentials with Azure Key Vault and published a Power BI dashboard for tracking commodity price trends.
Open on github.com- SQL
- Python
- Power BI
- Snowflake
- dbt
- Airflow
- Azure ADLS Gen2
- Azure Key Vault
- Git
Urban Mobility & Fleet Intelligence
Built a Snowflake warehouse from ~869K raw trip records and GBFS transit feeds, organized into raw, staging, dimensional core and mart layers that feed Power BI reports. Designed a star-schema dimensional model (fact and dimension tables) with source-to-target mapping for consistent trip and fleet analysis. Implemented data quality validation and lineage tracking so reports run on trusted, traceable data. Loaded data with Python and SQL, and used Bash scripting on Linux for file handling. Authored technical documentation covering business requirements, architecture, data flow and the dimensional model.
Open on github.com- SQL
- Python
- Snowflake
- Power BI
- Azure ADLS Gen2
- Bash/Linux
- Git
Education1
Bachelor of Technology
2022 — 2026D Y Patil University
Information Technology
Certifications3
SQL
HackerRank
Python
HackerRank
Google Data Analytics
2026coursera