Pooja Sonawane

Data Analyst

TATA Consultancy Services (TCS)

Jan 2020 - Apr 2026

Designed and optimized complex SQL queries for large-scale datasets, reducing report generation time by ~30% and enhancing data extraction and transformation efficiency. Developed 10+ high-impact, KPI-driven Power BI dashboards to monitor operational performance, regional metrics, and business insights for senior stakeholders. Automated repetitive data processing and reporting workflows using Python (Pandas, NumPy), eliminating 15+ manual hours per week in recurring tasks. Led data cleansing, validation, and transformation initiatives, improving data quality accuracy by 20% across critical business reporting pipelines. Partnered with cross-functional stakeholders to translate reporting requirements into actionable BI deliverables, presenting executive-ready insights that supported strategic and operational decision-making. Mentored 2–3 junior analysts during onboarding, walking them through complex SQL queries, report logic, and data-validation processes; reviewed their initial queries and guided them in correcting logic issues, enabling them to independently handle routine reporting and validation tasks with improved consistency and accuracy. Progressed from executing assigned analytical tasks to owning end-to-end reporting activities — including requirements gathering, data validation, stakeholder coordination, and issue resolution — while informally leading a 2–3 member team and supporting client-facing discussions to clarify requirements and resolve reporting issues.