SUSHANTH VARMA
Hyderabad
Summary
Results-driven Business Intelligence Professional with 10+ years of experience specializing in service reliability analytics, compliance tracking, and enterprise dashboarding for Fortune 500 financial institutions. Expert in developing comprehensive Reliability Frameworks and Training Analytics platforms that consolidate multi-source data into actionable executive insights. Currently managing CIB-level training compliance and conduct analytics at Wells Fargo, while previously transforming State Street's Service Availability Management through innovative Power BI solutions. Proven track record of reducing operational TAT by 50% and improving decision-making speed by 40% through automation and real-time analytics.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Business Execution Consultant
Wells Fargo
Hyderabad
11.2024 - Current
- Architected enterprise-wide Training Tracking Dashboard for CIB (Corporate & Investment Banking) division, monitoring 7,500+ employees' training compliance across multiple business units
- Scaled solution from CIB to Consumer Banking (CB) population, India Managers segment, and International populations, demonstrating platform versatility
- Developed Develop U Training Dashboard enabling managers to track team completion rates in real-time, improving compliance by 35%
- Coordinated with onshore stakeholders daily for attendance tracking and session completion metrics, ensuring 100% data accuracy
- Built comprehensive Conduct & Culture Management Information Dashboard tracking all issues and complaints at CIB level
- Reduced Turn-Around-Time (TAT) by 50% through Power BI automation and real-time data visualization
- Standardizing commentary templates for automated report generation, projected to save 15+ hours weekly
- Developing VBA Automation solution for Annual Certification generation, expected to reduce certificate creation time by 80%
- Automated certificate drafting and distribution process for entire employee population
- Managed cross-location coordination with Bangalore teams and Hyderabad admin for training logistics and room bookings
- Eliminated 20+ hours of weekly manual reporting through SharePoint-Power BI integration with custom DAX formulas
Business Analyst - Service Availability Management
State Street Corporation
Hyderabad
01.2022 - 10.2024
- Designed and implemented comprehensive Reliability Framework consolidating data from 10+ sources including ServiceNow (Tickets, Incidents, Problems), Windows Licensing, Patches, and Server Memory metrics
- Developed sophisticated weighting algorithms and scoring models to rank team performance across multiple dimensions, providing holistic operational health scores
- Transformed heavy Excel-based RF analytics into real-time Power BI dashboards, featuring advanced visuals, period-over-period comparisons, and dynamic slicers
- Created executive summaries that distilled complex reliability metrics into actionable insights for C-suite consumption
- Built customer-centric impact analysis dashboards using ServiceNow data, enabling proactive identification of service degradation patterns
- Developed aging analysis reports for incidents and problems, reducing backlog by 35% through improved visibility
- Established KPI/SLA monitoring frameworks tracking service availability across critical business functions
- Conducted root cause analysis on service disruptions, implementing preventive measures that decreased incidents by 28%
- Integrated disparate data sources from multiple teams into unified analytical platform using Power Query
- Automated manual reporting processes, saving 30+ hours weekly across the SAM team
- Built comprehensive knowledge base for service availability issues, improving MTTR by 45%
- Collaborated with 5+ cross-functional teams to ensure data accuracy and consistency across platforms
Manager - Business Analytics
HSBC
Bengaluru
05.2021 - 01.2022
- Directed workforce analytics initiatives for 1,000+ employees across India, Poland, and China operations
- Designed cost-per-FTE models and resource optimization dashboards using Power BI
- Developed automated leave governance reporting system, reducing compliance risks by 60%
- Led cross-departmental forecasting projects for hiring and attrition trends, improving prediction accuracy by 30%
- Created dynamic dashboards with stakeholder-specific views for different management levels
Assistant Manager - Operations Analytics
HSBC
Hyderabad
10.2017 - 04.2021
- Pioneered dashboard automation pilot projects for global liquidity management team
- Managed and coached team of 21 analysts, achieving 95% quality scores consistently
- Served as primary liaison between IT and business units for data integration projects
- Led Blue Prism RPA implementation for GDRE process, saving 4 FTE equivalents
- Received AMO Superstar Award twice for exceptional performance and innovation
Customer Service Executive - MI Reporting
HSBC
Hyderabad
03.2015 - 10.2017
- Prepared critical Management Information Reports (MMR, PAMS, GDRE) for senior management review
- Served as Subject Matter Expert for RPA initiatives with Capgemini consulting team
- Documented L1/L2 processes and keystroke automation, enabling 70% reduction in manual tasks
- Trained 15+ team members on automated workflow processes and reporting best practices
Education
Master of Science - Data Science & Analytics
Simplilearn
04.2022
Bachelor of Science - Computer Science
PRRM Engineering College
Hyderabad04.2009
Skills
- Business Intelligence & Analytics
- Power BI
- DAX
- Tableau
- Excel
- VBA
- Data Modelling
- SharePoint Integration
- Service Availability Management
- Training Compliance Analytics
- Reliability Framework Development
- Conduct & Risk Analytics
- Customer Impact Analysis
- Executive Reporting
- Automation
Notable Projects
- Training Compliance Platform, Wells Fargo, 2024-Present, Scaled training tracking from CIB to CB and International populations (7,500+ employees). Integrated Develop U training metrics with manager-level visibility. Coordinated cross-location logistics between Hyderabad, Bangalore, and onshore teams.
- Conduct & Culture MI Dashboard, Wells Fargo, 2024-Present, Centralized issue and complaint tracking for entire CIB division. Reduced TAT by 50% through real-time Power BI visualization. Standardizing commentary for automated report generation.
- VBA Annual Certification Automation, Wells Fargo, 2024-Present, Automating certificate generation for entire employee population. Expected 80% reduction in processing time upon completion. Eliminating manual drafting and distribution processes.
- Enterprise Reliability Framework, State Street, 2022-2024, Consolidated ServiceNow, Windows infrastructure, and operational metrics into unified scoring system. Weighted multi-dimensional performance indicators to create comprehensive team rankings. Delivered real-time Power BI dashboards replacing 50+ Excel reports.
Accomplishments
- VP Special Desk Award - 3 consecutive quarters for exceptional performance (Wells Fargo)
- AMO Superstar Award - 2-time recipient for innovation and leadership (HSBC)
- Enterprise Scale Impact - Managing training compliance for CIB & CB divisions at Wells Fargo
- 50% TAT Reduction - Through Conduct & Culture MI Dashboard implementation
- 80% Efficiency Gain - Via VBA automation for annual certification generation
- Reliability Framework Pioneer - Transformed Excel-based analytics to real-time Power BI at State Street
- Cost Optimization - Saved 4 FTE through automation initiatives ($200K+ annual savings)
- Innovation Leader - Co-hosted 'Idea Tree 2020' presenting comparative analysis of analytics tools
Certification
- Microsoft Certified: Data Analyst Associate (Power BI), 2023
- Microsoft Certified: Excel Expert, 2022
- Google Data Analytics Professional Certificate, 2021
- Dual Master's Certification in Data Science & Analytics, 2022
Timeline
Senior Business Execution Consultant
Wells Fargo
11.2024 - Current
Business Analyst - Service Availability Management
State Street Corporation
01.2022 - 10.2024
Manager - Business Analytics
HSBC
05.2021 - 01.2022
Assistant Manager - Operations Analytics
HSBC
10.2017 - 04.2021
Customer Service Executive - MI Reporting
HSBC
03.2015 - 10.2017
Master of Science - Data Science & Analytics
Simplilearn
Bachelor of Science - Computer Science
PRRM Engineering College