
Swaraj
Data Analyst
Skills

See my services

Work experience
Data Analyst
Zensar Technologies • Full-time
Dec 2024 - Present • 1 yr 10 mos
• Extracted and analyzed large volumes of operational data using complex SQL queries — including joins, subqueries, window functions, CTEs, and aggregations — to surface trends and support data-driven decisions. • Prepared structured datasets and data summaries for leads and stakeholders, enabling downstream reporting and dashboard development on operational KPIs. • Wrote and optimized SQL scripts to clean, validate, and transform raw data from multiple source systems, ensuring accuracy and consistency across all reporting outputs. • Automated recurring data preparation and reporting workflows using Python (Pandas) and Excel (Power Query, Pivot Tables), reducing manual effort across routine reporting cycles. • Analyzed incident and performance data for Cisco enterprise infrastructure, identifying recurring patterns and contributing to a ~25% reduction in repeat issues over 6 months. • Partnered with cross-functional stakeholders across engineering, operations, and finance to conduct root-cause analysis on recurring operational issues, contributing to a 15% improvement in operational efficiency.