Sumit Shah

Experience

• 

  Tata Communications

  Aug 2023 - now

  Executive MIS & Analytics

  • Developed and managed critical reporting tools and performance metrics, driving a 25% increase in data-driven decision-making within the PMO team.•Implemented automation scripts that reduced the average report generation time from 4 hours to 20 Mins, improving efficiency by 92%.•Designed and developed secure, role-based Key Performance Indicator (KPI) dashboards using Excel and VBA, implementing Role-Based Access Control (RBAC) to ensure data visibility aligns with user roles and permissions.•Built and developed real-time Revenue Dashboards in Excel and VBA, automating data refresh, enhancing security with proper authorization protocols, and streamlining insights for sales and leadership teams.•Conducted data analysis of churn forecasts for Customer Success Managers (CSM), comparing weekly forecasts to control churn.•Ensured ongoing dashboard maintenance and functionality to support comprehensive data analysis and align with evolving business needs.•Participated in on-call responsibilities, managing sensitive content and collaborating with teams to resolve issues quickly and efficiently.•Worked with internal teams to design and implement new systems and process improvements, driving automation and efficiency initiatives.•Conducted in-depth data analysis of churn forecasts, identifying and addressing key trends to improve customer retention.• Designed and Developed interconnected dashboards using Qlik Sense and Salesforce (SFDC), optimizing data visualization to provide clear visibility into sales intimation statuses and MDM inventory levels, streamlining communication and decision-making. Show less