Surbhi Jamdade

Data Analyst with hands-on experience in SQL, Power BI, Advanced Excel, Python, and Power Query, with experience developing end-to-end reporting solutions, performing ETL and data transformation, building data models, automating dashboards, and delivering KPI-driven business insights. Experienced in manufacturing, supply chain, marketing, and operational analytics.

Data Analyst - DHOOT TRANSMISSION LTD. - Pune

(2026-03)

• Developed an end-to-end Power BI reporting solution for quality KPIs across multiple manufacturing plants.
• Extracted and validated business data using SQL and performed ETL using Power Query, including cleaning, merging, and transformation.
• Built a Power BI data model from scratch using fact and dimension tables, relationships, and date hierarchies.
• Developed reusable DAX measures for KPI calculations, trend analysis, and performance monitoring.
• Automated reporting workflows and delivered dashboards with slicers, drill-throughs, bookmarks, and interactive visualizations to support plant-level decisions.

Data Analyst Intern - RUBIXE

(2025-08 - 2026-02)

• Cleaned, transformed, and analyzed datasets using SQL, Python (Pandas), Excel, and Power BI.
• Performed EDA to identify customer trends and supply-chain performance drivers.
• Developed KPI dashboards and performed data validation and statistical analysis to improve reporting accuracy.

SEO Executive - STRAITS RESEARCH

(2024-09 - 2025-04)

• Analyzed website performance using Google Analytics and Google Search Console, tracking traffic, CTR, conversions, and keyword rankings.
• Built Excel reports to identify traffic trends and data-driven opportunities for improving search performance.

Online Marketing Executive - FIRSTCRY.COM - Pune

(2022-09 - 2023-12)

• Consolidated and analyzed marketing data from Meta Ads Manager, Excel, Google Sheets, and internal systems.
• Automated recurring campaign reports using Advanced Excel and analyzed ROI, CTR, CPC, and campaign performance for business stakeholders.

MBA - Business Analytics & Marketing - SPPU (2020 - 2022)

BE - Electronics - Shivaji University (2013 - 2017)