Krishna G Hegde

Data Analyst with hands-on experience in e-commerce analytics, pricing analytics, sales analytics, business intelligence, KPI reporting, dashboard development, and performance analysis. Skilled in SQL, Power BI, DAX, Advanced Excel, VBA/Macros, Python, data visualization, forecasting, reporting automation, and business analytics.

Data Analyst Associate at WishKaro

• Reduced website return rate from 40% to 18% and Meesho return rate from 35% to 25% through SKU-level, product-level, and root-cause analysis of return patterns.
• Improved website conversion rate from 1.5% to 3% through landing-path and conversion funnel analysis, identifying customer journey drop-offs and optimization opportunities.
• Automated daily, weekly, and monthly MIS reporting for sales, revenue, returns, inventory, and SKU performance, reducing reporting time from 2-3 hours to 20-30 minutes.
• Developed and maintained 10-15 Power BI KPI dashboards covering sales performance, revenue trends, return rates, marketplace performance, and business KPIs.
• Conducted pricing and marketplace performance analysis across 30K-40K products on Website, Flipkart, Myntra, and Meesho to identify pricing gaps, product trends, and competitive opportunities.
• Analyzed Shopify traffic, sessions, customer behavior, and abandoned-cart data using available queries and filters to identify funnel drop-offs and support conversion optimization.
• Automated Excel and Google Sheets reporting workflows using VBA, formulas, macros, and reporting templates.
• Performed inventory trend analysis and forecasting using historical sales data and average daily sales metrics.

Data Science Intern at British Airways - Forage (2025-04 – 2025-04)

• Analyzed airline booking and customer behavior data to identify factors influencing booking completion.
• Built and evaluated Random Forest classification models and applied SMOTE to address class imbalance, achieving approximately 91% model accuracy.
• Identified key booking drivers including lead time, baggage selection, sales channel, and length of stay.
• Technologies: Python, Pandas, Scikit-learn, Random Forest.

Data Analytics Intern at Quantium - Forage (2025-03 – 2025-03)

• Analyzed retail transaction and customer data to evaluate sales, customer count, and transaction performance.
• Conducted uplift testing to compare trial stores with control stores and assess business impact.
• Delivered structured analytical recommendations using business-focused reporting.
• Technologies: Python, Pandas, Power BI.

Data Analytics Intern at NullClass (2024-12 – 2025-04)

• Developed interactive Power BI dashboards to analyze engagement and rating trends.
• Created DAX measures, calculated columns, KPIs, and advanced visualizations.
• Technologies: Power BI, DAX, Plotly.

MSc in Biochemistry – Karnataka University, Dharwad (2023-01 – 2023-01)