Pranav Asane

About

Data Analyst (fresher, 0-1 years experience) with strong hands-on experience in SQL querying, data cleaning, exploratory data analysis, KPI tracking, dashboard design, and business intelligence reporting. Proficient in Python, SQL, Pandas, Plotly, and Streamlit. Built analytics systems processing 100K+ records with automated reporting, anomaly detection, trend analysis, and AI powered insights. Skilled in data modeling, ETL pipelines, statistical analysis, and translating data into actionable business decisions. Immediate joiner; open to on-site, hybrid, or remote roles.

Skills

Projects

• BI Copilot — Natural Language Business Intelligence Assistant

  - Built AI-powered BI tool converting plain-English business questions to SQL, executing against PostgreSQL, and auto generating the most appropriate Plotly chart (bar, line, scatter, pie) with plain-English AI-written i

  Pandas · Plotly · PostgreSQL · Python · SQL · Streamlit

• Olist E-Commerce Analytics Pipeline

  - Built end-to-end analytics pipeline collecting, cleaning, and validating 110K+ e-commerce orders from 9 raw CSV datasets using PySpark; engineered 8 domain KPIs including delivery delay score, seller late rate, and ca

  Pandas · Plotly · Python · SQL · Streamlit

• Dynamic Pricing ML Engine

  - Collected, cleaned, and merged 100K+ real e-commerce orders from 9 CSV datasets; performed EDA and engineered 8 domain-specific analytical features including category demand score, competitor price gap, and customer re

  LightGBM · NumPy · Pandas · Python · Scikit-learn · XGBoost