Headline

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

About

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. abhishek.karanam.data@gmail.com

Location

Greater Hyderabad Area

Work experience

Data Analyst at Self Employed, Nov 2025 - Present · 8 mos, Hyderabad, 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 at GROWAI Edtech, May 2025 - Oct 2025 · 6 mos, Remote, 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.

Education

Bachelor of Technology - BTech, Computer Science, VEMU Institute of Technology, Chittoor