About
Data Analyst with experience in eCommerce analytics, business reporting, and website performance analysis using SQL, Python, Power BI, BigQuery, and Shopify data. Skilled in analyzing customer behavior, conversion funnels, operational performance, and business KPIs to generate actionable insights and improve decision-making. Experienced in dashboard development, workflow automation, and analytics reporting for fast-paced business environments.
Skills & Expertise (22)
Work Experience
Data Analyst
Overlays Clothing Private Limited
Mar 2026 - May 2026
Analyzed 500,000 monthly website sessions using Microsoft Clarity, SQL, and Python to identify drop-off points, user behavior patterns, and conversion bottlenecks, helping improve the website conversion rate from 0.7% to 1.5%. Developed and maintained 10 interactive Power BI dashboards to track website performance, customer behavior, sales trends, and key business metrics, enabling faster and more data-driven decision-making across teams using SQL, Python, and Power BI. Managed Shopify, BigQuery, and SQL-based data pipelines for automated data extraction, transformation, and reporting, improving reporting efficiency and reducing manual reporting effort by 40%. Built an automated inventory planning and restocking system using Google Apps Script, sales velocity analysis, stock coverage tracking, and size-wise demand forecasting, reducing stockout situations and saving nearly 50% of upper management’s planning time. Generated weekly and monthly performance reports and dashboards using Power BI, SQL, and Python with actionable insights to support website growth, customer retention, and business strategy decisions. Tracked and analyzed key KPIs including sessions, conversion rate, revenue per visitor (RPV), landing page performance, and customer journey metrics.
Data Associate
Insight Alpha Research & Solutions Private Limited
Jul 2025 - Mar 2026
Managed end-to-end Power BI workflows including ETL processes, SQL-based data extraction, data preparation, validation, and automation for business reports and dashboards, improving data reliability and reducing manual reporting effort by 40%. Monitored productivity metrics and turnaround time (TAT) across multiple ongoing projects to ensure timely delivery and maintain high-quality execution, contributing to improved operational efficiency and faster project closures. Prepared analytical reports and interactive Power BI dashboards for client discussions with McKinsey & Company and Boston Consulting Group, using SQL to analyze cross-industry trends and strategic opportunities to support business development initiatives and new project generation.
Research Intern
Ernst & Young (India)
Oct 2024 - Jan 2025
Conducted large-scale background verification checks for client candidates, validating employment, education, and regulatory records. Used SQL and MIS reporting techniques to manage, validate, and organize large client datasets for operational reporting and verification processes.
Data Analyst Intern
WattPower Systems Private Limited
Aug 2024 - Sep 2024
Cleaned, structured, and analyzed large datasets using Advanced Excel. Created Power BI reports and visualizations to support sales, financial, and billing analysis.
Education
Bachelors of Commerce (Hons) - Dyal Singh College, University of Delhi
2022 - 2025 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (22)
Click a skill to find developers with the same skill