Poonam Jadhav

Data Analyst

Pune, Maharashtra 2+ yrs exp 86 · Excellent

About

Results-driven Data Analyst with 2+ years of experience in analyzing complex datasets to deliver actionable business insights. Proficient in SQL (MySQL, PostgreSQL, Microsoft SQL Server) and Python (Pandas, NumPy, Matplotlib, Seaborn) for data extraction and analysis. Skilled in building interactive dashboards using Power BI and Tableau, along with advanced Excel (VBA, Power Query) for reporting and automation. Experienced in data cleaning, validation, data modeling, and ETL pipeline development to support efficient, data-driven decision-making. Strong understanding of business KPIs, data visualization best practices, and stakeholder communication to translate data into meaningful insights.

Skills & Expertise (38)

SQL Advanced

8.0/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Data Cleaning Advanced

7.0/10

Years Exp

ETL Advanced

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

KPI development Pandas NumPy Jupiter Notebook VS Code EDA A/B testing MIS Reporting Root Cause Analysis Data Pipeline Design Analytical Thinking Attention to Detail Cross-Functional Collaboration Problem Solving Communication HLOOKUP MySql Postgresql Microsoft SQL Server Azure Data Studio Tableau Matplotlib Seaborn VLOOKUP Descriptive Statistics Pivot Tables IF Functions Data Validation Macros VBA Power Query Hypothesis Testing Regression Analysis

Work Experience

Associate Analyst (Data Analysis & Reporting)

Zensar Technologies

Dec 2023 - Present

Collected, cleaned, and analysed large-scale business datasets (50,000+ records/month) to identify trends, anomalies, and patterns; improved data accuracy by ~25% and delivered actionable insights to stakeholders across 3 departments. Performed Exploratory Data Analysis (EDA) on structured datasets; conducted root cause analysis on data discrepancies and implemented corrective measures, improving data accuracy by 20%+ across reporting pipelines. Designed and executed ETL pipelines integrating 5+ source systems, reducing data preparation time by ~30% and ensuring consistent data availability for downstream reporting. Developed SQL queries (Joins, Subqueries, Window Functions, CTEs) to extract and aggregate datasets of 100,000+ rows, supporting business reporting for 4+ teams. Built data validation frameworks using Excel and SQL to ensure data integrity, completeness, and consistency; reduced data errors by ~15% across key reporting datasets. Designed and maintained interactive Power BI dashboards with DAX measures to visualize KPIs, headcount trends, and cost centre performance; dashboards used by 10+ leadership stakeholders for weekly decision-making. Developed and automated monthly MIS reports using advanced Excel (VLOOKUP, Pivot Tables, IF formulas, Macros, VBA), reducing manual reporting effort by ~40% and saving 8+ hours/month. Created end-to-end reporting pipelines integrating data from 5+ sources, reducing report turnaround time by 35% and improving consistency of business reporting across teams. Translated complex data findings into clear summaries and visualizations for non-technical stakeholders; delivered 10+ insight reports enabling data-driven decisions across 3 business functions. Collaborated with 4+ cross-functional teams on process improvement initiatives; participated in data audits and compliance reviews, ensuring 100% reporting accuracy for quarterly reviews. Coordinated with IT and system teams to ensure data feeds are accurate, complete, and processed on schedule; maintained 98%+ on-time data delivery for downstream reporting.