Sarthak BHATNAGAR

Data Analyst Intern

e-Suvidha Technologies (Suvidha Global Services OPC Pvt. Ltd.)

Dec 2025 - Jun 2026

Collected, cleaned, and analyzed 9,000+ structured retail sales records across multiple sources (ETL-style extract–clean–load workflow), ensuring data accuracy and consistency. Built interactive Power BI dashboards for KPI tracking, trend analysis, and regional performance reporting for stakeholders. Performed Exploratory Data Analysis (EDA) to validate profit margin trends, discount impacts, and regional performance gaps, flagging inconsistencies before reporting. Automated recurring reports using Excel Pivot Tables and Power Query, improving reporting turnaround time. Generated data-driven insights leading to a 12% improvement in overall profitability through pricing optimization strategies. Analyzed 10,000+ e-commerce records using advanced SQL (joins, subqueries, window functions) to extract customer and revenue insights, and reviewed query logic for accuracy and optimization. Identified customer purchasing behavior, top-selling products, and revenue trends through systematic data analysis. Segmented high-value customers via SQL queries to support retention strategies for Operations and Marketing teams. Applied Python (Pandas, NumPy) for data cleaning, validation, and EDA to prepare datasets for reporting and visualization.