Aarchie Gupta

Data Analyst

Tata Consultancy Services (TCS)•  January 2020 - Present•  Kolkata, India

Data Analysis & Insights: Analyzed large datasets using SQL and Excel to provide actionable insights that improved client decision-making by 30%. Ticket Management Optimization: Applied Pareto analysis to optimize ticket resolution processes, leading to a 60% reduction in ticket inflow and improving support efficiency. Data Reporting & Visualization: Designed and developed interactive dashboards in Tableau to visualize key performance metrics, enabling stakeholders to track progress and make informed decisions, improving reporting efficiency by 50%. Custom SQL Queries: Created and executed custom SQL queries to meet diverse client requirements, contributing to accurate and timely reporting. Risk Mitigation: Proactively identified and mitigated business risks, preventing potential losses and ensuring project continuity. Team Leadership: Managed and led a team of 6, fostering a collaborative environment and enhancing team performance and skills. Client Relationship Management: Maintained strong relationships with key clients by delivering tailored data solutions and effective communication.