SHRADDHA SANGAVE LinkedIn| GitHub
FUNCTIONAL AREAS
• Data Preparation & Visualization
• Business Intelligence
• Statistical Analysis
• Data Analysis & Reporting
• Database Management
• Collaboration and Support
TECHNICAL SKILLS
• MS-Excel –Data Cleaning, Pivot Tables, Power Query, Visualization, VBA & Macros, Forecasting, Statistical Analysis, and Dashboards
• Power BI – Data Import and Transformation, Data Modelling and Analysis, Visualization, Dashboard Creation
• SQL – DQL, Stored Procedures, Window Functions, CTEs, View, Data Analysis, Query Performance, and Optimization
• Python – Data Structures & Algorithms, OOPs, NumPy, Pandas, Matplotlib, Regression, Hypothesis Testing
• Tableau – Data Modelling, Parameters, Calculated Field, Table Calculations, LODs, and Dashboards
PROFESSIONAL EXPERIENCE
• Data Analyst | Driving Insights & Optimization| Excel, SQL, Python & Power BI – Emotive Corp, Remote08/2024 – 10/2025
◦ Built targeting frameworks for 10,000+ Amazon & eBay listings across UK, US, and EU using Excel, Python, and VBA, enabling performance-focused optimization that increased search visibility by 28% and boosted monthly sales by 22%.
◦ Automated QA processes by building advanced VBA macros and real-time Power BI dashboards, cutting listing errors by 38%, accelerated error detection and streamlined supplier updates across marketplaces, boosting accuracy and efficiency.
◦ Developed AI-assisted vehicle fitment models using Python and SQL, enhancing product visibility and customer satisfaction by 23%, while performing multi-market sales, pricing, and competitor analysis to deliver accurate insights.
• Data Analyst | Comprehensive Data Solutions | Excel, Power BI, Tableau & SQL – Ai Variant, Bengaluru09/2023 – 03/2024
◦ Applied Excel and MySQL for analysis, pivot tables, queries, and procedures, reducing data extraction time by 15% in project tasks.
◦ Elevated data visualization by creating Power BI and Tableau dashboards, advancing data interpretation efficiency by 25%.
• Graduate Apprentice Trainee | Energy Analysis and Optimization | Excel – MSEDCL, Ichalkaranji10/2021 – 10/2022
◦ Investigated MSEDCL energy consumption data, extracting insights that influenced strategic actions, improved decision making by 24%.
◦ Delivered solar cost estimates that helped consumers save over 37% on electricity bills and supported sustainable energy adoption.
PROJECTS
• Business Data Analytics | Excel, SQL | GitHub Repo Link
◦ Engineered improved SQL queries using CTEs, Window Functions, Subqueries, and Views to perform trend, cumulative, segmentation, and performance analysis, improving reporting efficiency by 35% and it is reusable for real world problems.
• E-commerce Analytics | Excel, Power BI, Tableau, SQL | GitHub Repo Link
◦ Enhanced e-commerce platform performance, improving user experience and increasing sales conversion rates by 15%, while crafting interactive dashboards on sales trends, customer behavior, and payment statistics that revealed 5 key areas for improvement.
• Amazon Web Scraping | Python | GitHub Repo Link
◦ Architected a Python-based web scraping tool using Beautiful Soup to extract product titles, prices, and ratings from Amazon pages, converting unstructured data into structured CSV and database formats, which expanded data collection efficiency by 32%.
Visit the GitHub to explore more analytics projects.
EDUCATION
• Bachelor of Electrical Engineering07/2017 – 04/2020
Sharad Institute of Technology College of Engineering, Ichalkaranji (MH, India)