Jwala Chandra Pandey

Data Analyst with 2+ years of experience helping teams make better decisions through data. Skilled in SQL, Excel, Power BI, and Python, with hands-on experience in data analysis, dashboard development, and reporting. Experienced in working with large datasets, creating DAX-based metrics, and identifying trends that support business and operational goals.

Senior Analyst - Capgemini - Bangalore, Karnataka

(2024-08)

• Designed and maintained 20+ interactive Power BI dashboards to monitor Sales, operation & business KPIs, improving reporting efficiency by 35% and enabling data-driven decisions.
• Developed and optimized complex SQL queries using Joins, CTEs, Window Functions, and Aggregations, reducing report generation time by 30%.
• Automated reporting and data preparation workflows using Python (Pandas & NumPy) and SQL, saving approximately 8 hours of manual reporting each week.
• Collaborated with cross-functional stakeholders to define KPIs, gather business requirements, and deliver actionable insights that improved operational efficiency by 20%.
• Performed data cleansing, validation, and quality assurance across multiple data sources, improving data accuracy by 25% and reducing reporting errors through data validation processes.

Bachelor of Technology - Electronics and Communication Engineering - Birsa Institute of Technology, Sindri, Dhanbad (2023-06)