Product Data Analysis | Business Intelligence | Data Engineering | Python | SQL | Excel | Tableau | Power BI | AI / ML Techniques 📍 Palampur, Himachal Pradesh | Gurugram | 📧 mk611453@gmail.com
Product Data Analyst Engineer and Power BI Developer with hands-on experience in business intelligence, dashboard development, Product Analytics, SQL analytics, ETL automation, and KPI reporting. Skilled in Power BI (DAX, Power Query, RLS), SQL, Python, Tableau, Advanced Excel and AI / Machine Learning techniques for transforming complex datasets into actionable business insights. Experienced in data visualization, reporting automation, stakeholder reporting, and decision-support analytics within fintech and business environment.. I transform raw data into actionable insights that drive real business decisions.
- ⚡ Fun fact: I automated reporting workflows that saved 40% manual effort
- Data is the new oil - I help businesses refine it into insights
| 🔁 18% | ⚙️ 35% | ⚡ 40% | 📊 100K+ |
|---|---|---|---|
| uplift in 30-day user retention (A/B tests) | faster data processing via ETL automation | less manual reporting effort | financial transactions analysed |
Power BI Depth: DAX · Power Query · Drill-through · Power BI Service · RLS · Time Intelligence
A lending-portfolio analytics project covering vintage analysis, roll-rate, PAR / NPA and a credit scorecard.
- Risk and collections views that mirror the metrics fintech teams track
- SQL + Python analysis feeding a Power BI dashboard
Stack: Python SQL Power BI DAX
People analytics on 14K+ IBM-style employee records.
- Designed a BI system with RLS, DAX Time Intelligence and a Star Schema
- Regression model flagged 3x higher attrition risk in the 2-4 year tenure band
- 5 workforce dashboards covering salary bands, tenure cohorts and overtime impact
Stack: Python SQL Power BI SSRS Regression
Interactive analytics on 50,000 orders across 2 years.
- Analysed ₹13.5M+ revenue across 8 categories, 5 regions and 4 channels
- Year-over-year comparisons, KPI scorecards and regional breakdowns
- Identified 3 underperforming categories; automated ETL with Pandas + Power Query
Stack: Python Pandas Power Query Power BI DAX
End-to-end ML pipeline on 10,000 customer records.
- Built Logistic Regression, Random Forest and Gradient Boosting models (AUC 0.765)
- Full feature engineering plus cost-based threshold optimisation (FN = $500, FP = $50)
Stack: Python Scikit-learn Pandas Matplotlib Seaborn
More projects: Blinkit Grocery Sales Dashboard · Zomato-Style Food Delivery Analytics (synthetic data) · Hospital Health Data Analytics (synthetic data)
- MCA, Computer Science & Data Analytics: Central University of Himachal Pradesh (Jul 2023 – Jun 2025)
- Microsoft Power BI Data Analyst Associate (PL-300): Microsoft Learn, 2026 (in progress)
- Google Data Analytics Professional Certificate: Google / Coursera, 2024
- SQL for Data Science: UC Davis / Coursera, 2024
- 🎓 GATE Qualified
"Data is the new oil — I help businesses refine it into insights."