About

Data Analyst with 1+ years of experience using SQL, Power BI, Python, and Excel to analyze data, automate reporting, and deliver business insights. Reduced manual reporting effort by 40% and processed 100K+ records through ETL, data cleaning, transformation, validation, KPI reporting, and dashboard development.

Experience2

  1. Junior Data Analyst

    Dec 2024 — Present

    Dollop Infotech · Indore

    Automated ETL and reporting workflows across 100K+ records using SQL, Python, Excel, APIs, and Power Query, reducing manual reporting effort by 40%. Built Python-based data preprocessing, validation, and data quality pipelines, improving data consistency by 25%. Designed and owned end-to-end Power BI dashboards using DAX and Power Query, replacing manual KPI compilation with centralized interactive reporting.

    • Reduced manual reporting effort by 40%
    • Improved data consistency by 25%
  2. Trainee Intern

    Jun 2024 — Dec 2024

    Dollop Infotech · Internship · Indore

    Conducted EDA, data cleaning, and data transformation on laptop datasets using Python to identify key pricing drivers and trends. Performed feature engineering and applied encoding techniques to prepare structured datasets for predictive analysis. Evaluated model performance using R² and RMSE to assess prediction accuracy.

Projects3

  • EchoChain — Circular Economy Analytics

    Building a business analytics solution using Scrapy, Databricks, Delta Lake, and PySpark to combine secondary-market listings with internal BOM, SKU, and warranty data for product lifecycle, resale value, and refurbishment analysis.

    • Scrapy
    • Databricks
    • Delta Lake
    • PySpark
    • Power BI
    • DAX
  • AtmoSync — Micro-Climate Analytics

    Building a streaming analytics solution using Python, Apache Kafka, Snowflake, dbt, and SQL to analyze IoT container telemetry and commodity pricing for spoilage-risk and shipment decision support.

    • Python
    • Apache Kafka
    • Snowflake
    • dbt
    • SQL
    • Apache Superset
  • Music Analytics Dashboard

    Built an end-to-end BI solution integrating multi-source data through Python APIs, PostgreSQL, SQL, and ETL pipelines to enable music ranking and performance analysis.

    • Python
    • SQL
    • PostgreSQL
    • Power BI
    • Streamlit
    • ETL
    • APIs
    • RapidFuzz
    • Plotly

Education1

  • Bachelor of Technology in Food Engineering

    2017 — 2022

    Institute of Chemical Technology

Certifications4

  • Oracle Analytics Cloud 2025 Certified Professional

    2025

    Oracle

  • SQL (Advanced)

    2025

    HackerRank

  • Data Analytics Job Simulation

    2025

    Deloitte (Forage)

  • Python 101 for Data Science

    2025

    IBM