Data Analyst
Tata Consultancy Services (Client: GE Appliances – Haier) · Mar 2022 – Nov 2025
- Analysed sales and order management datasets to generate KPI reports, identify business trends, and provide actionable insights for performance improvement.
- Wrote and optimized complex SQL queries (Oracle SQL) to detect null values, duplicates, and data inconsistencies across ERP datasets, reducing data quality issues by ~30%.
- Performed data cleaning, preprocessing, and Exploratory Data Analysis (EDA) using Python (Pandas, NumPy) to ensure data accuracy and reliability.
- Designed interactive Power BI dashboards with drill-through analysis, dynamic slicers, and trend visualizations, reducing ad-hoc reporting requests by 40%.
- Built DAX measures for sales performance metrics including Month-over-Month (MoM) growth, Year-to-Date (YTD) revenue, and regional sales variance to support executive decision-making.
- Automated weekly and monthly reporting workflows using Power BI and Excel, saving approximately 12 hours of manual effort per week across the reporting team.
- Leveraged advanced Excel functions (VLOOKUP, XLOOKUP, INDEX-MATCH, Pivot Tables) to streamline data analysis and reporting, saving over 2 hours per week.


