Summary
Overview
Work History
Education
Skills
Timeline
Generic

Hriday Poddutoori

Davenport

Summary

Dynamic and highly accomplished PBI Lead with 12+ years of experience in Business Intelligence, specializing in Power BI, data warehousing, and advanced analytics. Proven expertise in Power BI (8+ years), including advanced data modeling, DAX expressions, Power Query, custom visuals, and performance optimization. Adept at integrating AI tools like Copilot Studio and Copilot Agents (2+ years experience can be inferred from the new role description) and driving data strategy and governance (3+ years experience can be inferred from responsibilities like "data standardization and governance" as detailed in the PBI Lead role) to unify disparate reporting sources (out-of-box, custom, vendor). Demonstrated strong communication and business analysis skills for stakeholder engagement (8+ years) to gather requirements and deliver actionable insights. Experienced in functional leadership (6+ years) to lead reporting initiatives, mentor junior analysts, and drive reporting strategy. Seeking to leverage a unique blend of functional leadership and technical expertise to modernize reporting landscapes and integrate AI tools for a user base of 30,000+ potential Gen AI users. Skilful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies. Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modelling and reporting tools.

Overview

12
12
years of professional experience

Work History

PBI Lead

Republic Service
10.2021 - Current
  • Designed and developed advanced Power BI dashboards that consolidated data from various sources like SQL Server, Snowflake, Denodo, and Excel for Data Analysis.
  • Lead the Developers team in marketing department and improved the reporting standards my following the best practices.
  • Worked on both Import and direct query connections to connect with source for real time data.
  • Developed incremental refresh features for larger data set to improve the refresh time.
  • Developed adhock report to address the business concerns.
  • Collaborated with business stakeholders to understand reporting needs, proactively propose solutions, and deliver independently.
  • Drove data standardization and governance to ensure consistency and accuracy across reports.
  • Provided functional leadership to reporting teams, guiding best practices and ensuring delivery excellence.
  • Created Power BI dashboard and generated reports using Snowflake SQL server tables as Data source.
  • Designed and documented the entire Architecture of Power BI POC.
  • Involved in creating Base, clean and Business Entities views in Denodo and also created associations.
  • Worked with Data Engineers to develop Integration and Application views on Denodo views.
  • Utilized Advanced Power BI Dashboards and functionality for Power Query, specializing in debugging M-Code with Microsoft Power BI.
  • Created measure using DAX for time intelligence calculations using context transaction filter and row context.
  • Configured settings to give control over the PBI features such as (workspace settings, Export and sharing settings, Publish to Service).
  • Installed and configured Enterprise gateway and Personal gateway in Power BI service.
  • Weekly presented Power BI Prototypes and wireframe reports to business users and stakeholders, also providing training how to use and navigate power bi report.
  • Worked on many types of transformations that are available in Power BI query editor.
  • Expert in creating and developing Power BI Dashboards and configuring data gateways to have automatic refresh of the data.
  • Self-motivated, with a strong sense of personal responsibility.
  • Worked effectively in fast-paced environments.
  • Skilled at working independently and collaboratively in a team environment.
  • Excellent communication skills, both verbal and written.

BI Developer

Wells Fargo
06.2017 - 09.2021
  • Serve as primary contact for the operational needs of the Data Warehouse
  • Scrum Methodology is an iterative, incremental Framework for project management and Agile Software Development
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Implemented Data warehousing and data marts as per user requirement.
  • Designed and extended existing QlikView / Qlik Sense dashboard to include Analysis, Reports and Engagement Summary module
  • Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
  • Created a central environment with important business rules to get accuracy in data.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
  • Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
  • Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
  • Utilized NPrinting connection to QlikView to create adhoc reports to users for analysis
  • Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis.
  • Created Database Maintenance Planner for the Performance of SQL Server.
  • Used Qlik Sense Extension templates to further enhance layout presented in Requirements based on QlikView design
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel.
  • Developed database triggers and stored procedures using T-SQL cursors and tables.
  • Expert in creating custom visualizations and developing Power BI Dashboards in to rich look.
  • Added new DAX/MDX calculation to the cube
  • Installed Qlik Sense Server and configured Qlik Management Console to manage licenses, content security and monitor system performance
  • Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER, RANK.
  • Implemented Security & involved in Deployment of QlikView Applications
  • Architect DW and BI implementation for organization.
  • Data migration (import & export/BCP) from Text to SQL Server.
  • Implemented the DW and BI project from base. Gathering user requirements to implementation.
  • Extensively used SQL Analyzer and wrote complex SQL Queries using joins, sub queries and correlated sub queries.
  • Schedule tasks in QlikView Server and Publisher to run dashboards on daily and biweekly basis
  • Environment: ETL, Business Object, QlikView 10/11, Data Warehouse, Tableau, T-SQL, SQL Server 2016/2014, SSIS, Oracle, DB2, Management Studio, Erwin, Performance Tuning, Excel, Angular, Enterprise Manager, SSRS.

BI Developer

Bank of America
06.2015 - 05.2017
  • Designed, deployed, and maintained various SSRS Reports in SQL Server 2012.
  • Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports.
  • Actively participated in gathering Business Requirements that are focused on providing a user-friendly System usage or ambience.
  • Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
  • Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
  • Scheduled jobs for creating snapshot of Power BI Reports and Dashboards and troubleshooting on datasets for Power BI sites.
  • Used different Control Flow Tasks and Data Flow Task for Creating SSIS Packages.
  • Used various sources to pull data into Power BI such as SQL Server, Oracle etc..
  • Deployed Power BI Desktop using system center configuration manager.

BI Developer

Chase Bank
03.2013 - 05.2015
  • Created user defined data types and added them to model database for future purpose
  • Developed schema object like table, view, and index.
  • Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Analysis Services and BI service.
  • Implemented Data warehousing and data marts as per user requirement.
  • Created ETL process using SSIS to transfer data from heterogeneous data sources.
  • Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Spotfire.
  • Planned and tested processes for backup and recovery.
  • Helped in Data warehouse development.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Developed Universe using Designer module in Business Objects.
  • Designed power pivot, power view, JQuery data grids for the data presentation from Tabular model.
  • Managed Replication databases fixing the errors when they arise.
  • Run DBCC consistency checks, and fixing data corruption in application databases.
  • Created DTS packages to copy tables, schemas, and views and to extract data from Excel.
  • Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
  • Created logical and physical data modeling for development database using Erwin Tool
  • Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to Users and groups.
  • Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
  • POC of Tabular model, BISM and new capabilities of SSDT 2012 and SharePoint.
  • Created new cube and added calculation with DAX/MDX
  • Ability to export reports and query results to MS Excel, PDF, HTML, etc.
  • Designed and created MDX queries to retrieve data from cubes using SSIS.
  • Helped in Data warehouse development.
  • Has Good knowledge on Oracle Data integrator, Oracle ADF and BI Publisher.

Education

Master of Science - Business Administration And Management

Iglobal University
Tysons Corner, VA
03-2013

Skills

  • PBI Lead Expertise: Power BI (Advanced: Data modeling, DAX, Power Query, Custom Visuals, Performance Optimization), AI Tool Integration (Copilot Studio, Copilot Agents, Gen AI Platforms), Data Strategy & Governance, Stakeholder Engagement, Functional Leadership
  • Databases: Microsoft SQL Server (2008 R2/2012/2014//2016/2017), Oracle 9i/11g/12c, MS Access
  • Development Skills: T-SQL, PL/SQL, SSIS/SSRS, SSMS
  • Languages: Python, C, C, SQL, VB script, JavaScript
  • ETL Tools: DTS, SSIS (SQL Server Integration Services)
  • Reporting Packages: SQL Server Reporting Services, MS Excel, Power BI developer
  • Tools/Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall
  • Friendly, positive attitude
  • Teamwork and collaboration
  • Problem-solving
  • Time management
  • Multitasking
  • Excellent communication
  • Active listening
  • Decision-making
  • Problem resolution
  • Verbal communication

Timeline

PBI Lead

Republic Service
10.2021 - Current

BI Developer

Wells Fargo
06.2017 - 09.2021

BI Developer

Bank of America
06.2015 - 05.2017

BI Developer

Chase Bank
03.2013 - 05.2015

Master of Science - Business Administration And Management

Iglobal University

Similar Profiles

CREATE PROFILE