Rohit Kumar

Data Analyst

Tata Consultancy Services

Mar 2022 - Present

•Developed interactive Power BI dashboards with DAX to monitor Service Requests and Incidents, improving SLA monitoring accuracy by 40% and accelerating operational decision-making for stakeholders. •Built executive-level dashboards for Weekly Highlights and Service Improvement tracking, consolidating operational metrics into a centralized reporting solution and reducing report preparation time by 80%. •Designed a Power BI feedback analytics dashboard consolidating 417+ survey ratings and 650+ sentiment records across multiple countries — including sentiment analysis and category-level performance tracking — to help stakeholders monitor satisfaction trends and identify improvement areas in real time. •Automated data extraction and scheduled reporting workflows, eliminating manual reporting effort and ensuring timely and consistent delivery of business insights. •Wrote and optimized complex SQL queries, stored procedures, views, and functions in MS SQL Server and MySQL to extract, transform, and validate data — improving query execution time and overall data processing efficiency. •Designed and deployed SSRS reports aligned to business requirements, enabling accurate, timely, and self-serve reporting for stakeholders. •Identified and resolved data inconsistencies and reporting defects, improving overall data accuracy and report reliability across dashboards. •Partnered with business stakeholders to gather requirements and translate them into scalable data models — bridging the gap between raw data and actionable business decisions.