Sai Sumanth Sistla
Power BI Developer

Sai Sumanth Sistla

Works at Deloitte Tax Services India.
Work with Sai Sumanth Work with a Power BI Developer

About

Sai Sumanth Sistla is an experienced Power BI and Crystal Reports expert with ten years of background in business intelligence, data management, data analytics, data modeling, and automation. He works as a senior consultant at Deloitte Tax Services India, where he designs and implements BI reporting and analytics solutions, such as dashboards, reports, and ad-hoc capabilities. His skills include Microsoft Power BI, Alteryx and Tableau, Microsoft SQL Server, Microsoft Excel, SAP (G/L and BW-FI modules), Hyperion Essbase, and VBA.

Employment

3 roles
Jan 2016 - Sep 2021 5 years 8 months
Senior Consultant
Deloitte Tax Services India
  • Designed and implemented BI reporting and analytics solutions, such as dashboards, reports, and ad-hoc capabilities using MS Power BI.
  • Worked as a part of Deloitte Tax with NFTS (National Federal Tax Services) team to provide end-end support on Global Incentives application which is being used by over 1,000 clients across the US, UK, Canada, Australia, and South Africa.
  • Involved in the creation of tables, debugging stored procedures, and user-defined functions which were used to implement business rules.
  • Generated SQL queries using necessary join conditions. Wrote T-SQL statements (queries) for retrieval of data and involved in performance tuning of TSQL queries.
  • Interacted with the stakeholders and gathering any requirements in terms of applications such as customizing pages, change in the business logic and the look and feel of the pages. Responsible for backing up, restoring system and other databases as per requirements.
  • Enabled Alteryx in the Global Incentives application by building workflows to ease data imports into the application as a part of data analytics. Involved in data preparation, data blending, and the creation of data models, data sets using Alteryx.
  • Advised and aided clients in building their data strategies, helped define key KPIs and objectives, and formulated requirements. Maintained databases, cleansing and validating data as needed.
  • Worked with the testing team to build the test cases and involve in smoke testing, load testing, unit testing. Ensured that all the test cases for newly developed features are being tested properly in stage and production environments.
  • Prepared dynamic dashboards using VBA and advanced Excel formulae for management’s review of workflow. Worked on the Power BI reports and dashboards with SQL Server/Tabular SSAS sources. Worked on custom visualizations and DAX expressions.
Dec 2014 - Dec 2016 2 years
Performance Analyst
Deloitte Support Services India
  • Worked in core talent services team, part of human resources to steer automation, data analysis, and reporting functions.
  • Maintained the roster for all the 8,000 professionals who work under the TAX function in Deloitte through dashboards and views built across Tableau.
  • Designed and deployed rich graphic visualizations with drill-down and drop-down menu options and parameters using Tableau.
  • Worked on automating reports and maintaining the performance-related information such as performance ratings for all the professionals to support leaders, process specialists, human resource managers to take a call on a professional's performance at mid-year and year-end.
  • Developed Tableau data visualizations using cross tabs, heat maps, box and whisker charts, scatter plots, geographic maps, pie charts and bar charts, and density charts for the partners for talent reviews across service lines.
Jan 2011 - Dec 2014 3 years 11 months
Financial Analyst
Deloitte Support Services India
  • Worked as a part of the Finance COE (Centre of Excellence) team and assisted the automation of the finance department’s manual processes by writing VBA code using macros and formulas to speed up processes.
  • Identified and interpreted trends and patterns in data sets and communicated information to the management and clients.
  • Supported the financial reporting process by providing periodic/year-end financial data to functional management and US-based financial analysts on an accurate and timely basis.
  • Involved in interpreting raw data, providing reports for analysis and completing research on variances to plan, prior year, forecasts, preparing periodic flash reports for directors and partners to analyze key performance indicators and biweekly trends.
  • Automated several existing excel reports by using VBA which helped the business in delivering the reports in a timely manner which helped the leadership in executive-level decision making.
  • Supported business leaders in the US through analysis of key performance indicators and trends biweekly. 

Education

Jun 2011 - Jun 2013 2 years
Masters in Business Administration, Finance
St Augustine PG College

Portfolio

6 items