
Data Analyst
Tata Consultancy Services · Aug 2023 – Jun 2026
- Queried and analysed large-scale structured datasets (5M-10M+ records) using SQL (joins, aggregations, window functions), Python (Pandas, NumPy), and Advanced Excel (PivotTables, complex formulas) to surface trends and eliminate duplicates u2014 improving data reliability by 30%.
- Designed 10+ interactive Power BI dashboards for real-time KPI monitoring, enabling senior stakeholders to track business performance metrics and drive informed decisions during monthly review cycles.
- Optimised recurring reporting cycles by automating SQL queries and Power BI refresh workflows using Python (Pandas, task scheduling) u2014 reducing manual reporting effort by 20% and recovering 15+ hours per week, enabling business units to shift focus toward strategic analysis.
- Performed end-to-end ETL data preparation u2014 extracting, transforming, and validating datasets across multiple source systems u2014 reducing report discrepancies by 25% and delivering decision-ready data for stakeholder reporting.
- Standardised demographic datasets via Python transformation scripts and Excel-based validation checks, improving cross-system data consistency and cutting reconciliation time by 40%.
- Partnered with cross-functional stakeholders to define KPI frameworks, align reporting metrics, and deliver actionable insights to senior leadership - reducing reporting errors by 15% and strengthening forecast accuracy.

