SUSHMANTH PAPABATHINI

Client : Mercedes Benz Financial Services (MBFS)

Dashboard Development & Business Impact

• Working with Cross function teams for building automated Power BI dashboards that give insights into Key Metrics like Cure rates, Delinquency, RORAC and on external agents like dealers’ performance against set targets.
• Collaborated with 3+ cross-functional teams (e.g., Finance, Sales, Operations) to build and automate over 15 Power BI dashboards. These dashboards provided insights into key metrics such as cure rates, delinquency, and RORAC, enabling a 10% improvement in tracking dealer performance against targets.
• Created various Power BI reports like Map reports, Waterfall reports, Bar charts, Column chart, Line chart.
• Designed and developed over 20 visually engaging Power BI reports, utilizing a variety of charts (Map, Waterfall, Bar, Line) to translate complex data into actionable insights for senior management.

Data Transformation & Modeling (ETL)

• Extensively worked on Power BI transformations like Split column, Group by column, Append queries, Merge queries, Pivot, Unpivot, and Custom column.
• Performed complex data transformations in Power Query by merging and appending over 10 different data sources, and using features like pivoting and custom columns to prepare data for analysis, reducing manual data prep time by 25%.
• Building the relationship between tables by using Power Map.
• Engineered robust data models by creating and managing relationships between more than 20 tables, ensuring data integrity and enabling advanced analytics across multiple datasets.

Advanced Analytics & DAX

• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
• Wrote over 50 complex DAX measures and functions (e.g., CALCULATE, SUMX, Time Intelligence) to create sophisticated calculations and KPIs that were critical for business analysis.

Reporting & Automation

• Used different types of Filters in Power BI like Visual level Filter, Page level Filter, Report level Filter, Drill through filter and Slicer.
• Enhanced user experience and interactivity by implementing 5+ types of filters and drill-through functionality, allowing over 100 users to perform self-service analysis and investigate data from high-level summaries down to individual records.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Configured and managed scheduled data refreshes for over 15 critical reports in the Power BI Service, ensuring business leaders had access to up-to-date information daily and reducing manual refresh efforts by 100%.

• Client : British Telecom PLC
  Environment: Power BI, Oracle, Tableau Desktop/Server
• Contributed to critical design decisions by participating in over 20 strategic meetings with business owners, ensuring technical solutions aligned perfectly with business objectives.
• Designed, developed, and maintained a portfolio of 15+ interactive Power BI dashboards and reports, supporting over 100 users and fulfilling dozens of ad-hoc reporting requests from leadership.
• Engineered and managed complex data models by integrating 10+ new data sources, structuring relationships between 50+ tables, and authoring over 75 advanced DAX calculations.
• Managed the end-to-end deployment lifecycle in Power BI Service, configuring workspace permissions and implementing role-based security (RLS) for 5 distinct user groups to ensure data governance and security.
• Increased data pipeline reliability by 30% by monitoring scheduled refreshes, proactively resolving gateway and connectivity failures, and optimizing data source connections.
• Ensured 99.9% report accuracy by conducting daily functional and data validation tests, which reduced user-reported data errors by 40% post-deployment.
• Improved average report load times by 25% across key dashboards by optimizing query efficiency, refactoring complex DAX measures, and resolving performance bottlenecks.
• Acted as the key liaison between technical and business teams, collaborating with 4 cross-functional departments (including IT, Project Management, and Customer Support) to gather requirements and implement 20+ dashboard enhancements.
• Authored and maintained 10+ Standard Operating Procedures (SOPs) for data warehouse refreshes and report testing, standardizing processes across QA, UAT, and Production environments.