"Turning raw data into decisions that actually matter."
I'm a final-year B.E. Information Technology student at Savitribai Phule Pune University (CGPA: 8.40), passionate about making data useful — not just readable.
I've worked as a Data Analyst Intern at VOIS and Infosys Springboard, where I built dashboards that teams actually adopted, wrote SQL to clean and analyze large datasets, and worked in Agile s[...]
Right now I'm building FinIQ — an AI-driven financial analytics system with a live Streamlit app powered by Groq API, where the model identifies root causes behind financial performance chan[...]
- 🔍 Currently focused on: Data Analytics, Business Intelligence, AI-powered analytical tools
- 🌱 Learning: Databricks, Advanced DAX, ML for analytics
- 🏆 HackerRank SQL: 4-Star Gold Badge
- 🥇 Top 10 — Pan India Hackathon (Codelite)
- 📬 Reach me: gagandhanapune@gmail.com
- 😄 Pronouns: He/Him
🌐 Live App: finiq07.streamlit.app
PostgreSQL · Python · Databricks · Scikit-learn · Streamlit · Groq API · Power BI · DAX
An end-to-end AI-powered financial analytics system that processes business data to evaluate KPIs and identify the root causes behind performance changes.
| Metric | Value |
|---|---|
| 💰 Total Revenue Analysed | $10.3M |
| 📈 YoY Revenue Growth | 270% |
| 📊 Profit Margin | 24.9% |
| 🌍 Countries Covered | 5 |
| 📦 Product Lines | 6 |
What it does:
- 🔍 Uses Random Forest feature importance to flag key performance drivers — COGS, discount rates, sales volume
- 💡 Groq API powers a live recommendation engine with real-time financial insights
- 📊 Interactive Power BI dashboard with DAX KPIs for executive-level reporting
- 🌐 Fully deployed on Streamlit — live and accessible
(Ongoing)
Python · SQL · Power BI
Analyzed 8,800+ Netflix records to uncover content demand patterns and audience behaviour.
- 📍 Identified 35% higher regional content demand through EDA and content classification
- 🎯 Built Power BI dashboards mapping audience maturity distribution across regions
- 🧹 Full data cleaning, feature engineering, and SQL-based analysis pipeline
Power BI · DAX · Excel · Snowflake Schema
Designed a Snowflake schema data model integrating multiple hotel datasets for scalable BI reporting.
- 📈 DAX-driven insights improved occupancy planning accuracy by 15%
- 💰 KPI dashboards tracking Revenue, ADR, RevPAR, and Occupancy
- 📐 Full dimensional data model with documented data lineage
SQL · MySQL · Advanced Queries
Deep-dived into 10K+ flight records to identify delay root causes across carriers, weather, and NAS.
- ⚡ Automated benchmarking queries — reduced manual analysis effort by ~40%
- 🔍 Used Window Functions, CTEs, Joins, and Aggregations throughout
- 📋 Fully documented query logic and methodology
SQL · PostgreSQL
Cleaned and analyzed 3,000+ sales records to identify packaged food market trends worth ₹1.14L.
| Role | Company | Period |
|---|---|---|
| 🔷 AI / Data Analytics Intern | VOIS | Sep – Oct 2025 |
| 🔷 Data Analyst Intern | Infosys Springboard | Sep – Nov 2025 |
| 🔷 AI/ML Intern | Spark To Ideas | Feb – Mar 2025 |
| 🔷 Data Science Intern | UniConverge Technologies | Apr – Jun 2024 |
| 🔷 AI Intern | Edunet Foundation (Microsoft, SAP, AICTE) | Nov – Dec 2024 |
| Certificate | Issuer |
|---|---|
| 🟠 Generative AI Professional | Oracle |
| 🔵 Data Analytics Essentials | Cisco |
| 🟢 Power BI Visualisation | Infosys Springboard |
| 🔵 Data Analytics (Foundation & Advanced) | SAP |
| 🟣 Enterprise Data Science Basics | IBM |
| 🟡 Advanced Data Analyst Program | NIIT |
| 🟢 Cloud Arcade — 150+ Labs (Premium Milestone) | Google Cloud |
- 🥇 Top 10 — Pan India Hackathon (Codelite)
- 🥈 Naukri Campus Young Turks Qualifier — Score: 95%
- ⭐ HackerRank SQL: 4-Star Gold Badge
I'm actively looking for Data Analyst / Business Intelligence roles (2026 fresher). If you have an opportunity or just want to talk data — reach out!
💡 Data tells a story. I make sure it's the right one.