Abhishek K

Data Analyst | SQL · Python · Power BI · Excel | ₹4.5L Revenue Leakage Detected · 24% Conversion Uplift · 30% Reporting Time Saved | Open to Work · India

I’m a Data Analyst skilled in SQL, Python, Power BI, and Excel, focused on solving real business problems using data. During my internship at GrowAI Edtech: Cleaned and validated 50K+ records using Python and Excel, reducing data errors by 25% and fixing KPI miscalculations Built 3 Power BI dashboards, saving 12+ hours/week and reducing reporting effort by 30% Optimized SQL queries (CTEs, window functions), improving report speed by 20% Delivered ad-hoc analysis within 24–48 hours, supporting marketing and operations decisions Projects: Identified ₹4.5L revenue leakage in 100K+ e-commerce transactions (75% from payment failures) and built a tracking dashboard Ran an A/B test on 20K users, improving conversion rate by 24% Built cohort analysis on 100K+ users, identifying <1% retention after month one Skills: SQL (CTEs, window functions, joins) Python (Pandas, NumPy) Power BI (DAX, dashboards, data modeling) Excel (MIS reporting, pivots) EDA · A/B Testing · Cohort & Funnel Analysis · KPI Reporting I’m actively looking for Data Analyst / MIS Analyst / Reporting Analyst roles (0–2 years) where I can contribute from day one. [email protected]

Experience

Data Analyst

Self Employed · Nov 2025 – Present

Not yet confirmed

• End-to-end data analysis projects built on real business problems using Python, SQL, Power BI, and Excel.
• - Analyzed 100,000+ e-commerce transactions using Python and SQL, identifying ₹4.5L in revenue leakage from failed orders — traced 75% of loss to credit card payment failures — and built an interactive Power BI dashboard to monitor leakage by payment method, region, and order type
• - Designed and analyzed an A/B test on 20,000 users to evaluate a checkout flow change, achieving a statistically validated 24% improvement in conversion rate with segment-level recommendations
• - Conducted cohort analysis on 100,000+ user records using Python and SQL, revealing less than 1% retention beyond month one, and proposed targeted loyalty and re-engagement campaigns based on drop-off patterns
• Tools: Python (Pandas, NumPy, Matplotlib) · SQL · Power BI (DAX) · Excel · Cohort Analysis · A/B Testing · Funnel Analysis

Data Analyst Intern

GROWAI Edtech · May 2025 – Oct 2025

Not yet confirmed

• Cleaned and validated 50,000+ records using Python and Excel, reducing data errors by 25% and eliminating KPI miscalculations across all weekly reports.
• Built 3 automated Power BI dashboards for marketing and operations teams, saving 12+ hours of manual reporting per week (30% reduction).
• Optimized SQL queries using CTEs and window functions, cutting report processing time by 20% and accelerating stakeholder delivery.
• Delivered ad-hoc business analysis to leadership within 24–48 hours, with insights directly influencing campaign and operations decisions.
• Standardized KPI definitions across departments through cross-team stakeholder alignment, eliminating reporting discrepancies.