s
swarajchoudhari

Swaraj

@swarajchoudhari

Data Analyst

India
English
About me
Data Analyst with ~1.8 years of experience delivering data extraction, analysis, and operational reporting on Cisco enterprise projects at Zensar Technologies. Proficient in SQL, Power BI, Python, and Excel, with hands-on experience querying large datasets, identifying trends, and delivering actionable insights that support business and operational decision-making.... Read more

Skills

s
swarajchoudhari
Swaraj
Offline • 

See my services

Data Engineering Consulting
I will build etl pipelines using python, sql, pyspark and spark

Work experience

Zensar_Technologies

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.