Revanth Reddy Gaddam

Project: Spend Analytics Supply Chain
Client: Black and Veatch, Kansas, the US.
Duration: July-2023 to Till Date

• Overview: Black & Veatch is a global engineering, procurement, and construction company specializing in critical human infrastructure in energy, water, telecommunications, and environmental sectors
• Developed and built data integration ETL pipelines to migrate data from on-premises to the cloud using Azure Data Factory, enabling seamless data movement between various sources and destinations
• Designed and optimized ETL processes to transform and load data from heterogeneous sources into Azure Data Lakes and Warehouses, improving data accessibility for analytics
• Proficient in creating, monitoring, and optimizing data pipelines to ensure efficient processing and timely delivery of insights, conducting performance tuning to enhance data flow and reduce processing times through parallel processing and data partitioning
• Configured Linked Services, Datasets, cloud and self-hosted Integration Runtimes (IR), and scheduled triggers in Azure Data Factory to automate data loads, minimizing manual intervention and ensuring timely data availability
• Created date hierarchy partitions in Azure Data Lake Storage Gen 2 to organize data across multiple layers and extracted data from various sources like SQL Server and SharePoint, transforming, cleansing, and validating it before loading into the destination
• Configured alerts for Azure Pipeline failures and successes through email notifications using Logic Apps
• Analyzed business requirements and built logical data models to describe data relationships and structures effectively
• Executed tasks such as cleansing, shaping, and modeling data using Power Query, Power Pivot, and DAX, while maintaining workspaces and providing secure access through Row-Level Security (RLS) based on user roles
• Designed and implemented an interactive Power BI dashboard to visualize spend analytics for projects and assess vendor performance
• Created calculated columns, measures, and tables using DAX expressions in Power BI Desktop, including time intelligence, date, text, aggregation, and filter functions
• Designed and built complex reports and dashboards in Power BI, utilizing filters (slicers), drill-downs, drill-throughs, tooltips, buttons, and edit interactions to enhance user experience
• Extensively used bookmarks and the selection pane to display all visuals on a single page, implementing drill-through capabilities for seamless navigation between summary and detailed data
• Applied visual, page, and report-level filters, ensuring unnecessary filters were hidden from users to streamline the interface
• Responsible for understanding both technical and functional business requirements by reviewing specifications and gathering input from business users and analysts
• Published reports to the Power BI service and managed access for required users, scheduling automatic refreshes to ensure data accuracy
• Created Power BI apps for production workspaces, enhancing report distribution and user accessibility.

Project: Data Engineering & Power BI Support
Client: Black and Veatch, Kansas, the US.
Duration: Feb -2022 to Jun-2023

• Overview: Black & Veatch is a global engineering, procurement, and construction company specializing in critical human infrastructure in energy, water, telecommunications, and environmental sectors
• Monitor daily pipeline jobs to ensure successful execution
• Investigate failures and ensure data is loaded into the data warehouse while maintaining the integrity of existing Azure Data Factory pipeline jobs
• Oversee Power BI dataset refresh schedules, addressing any failures promptly
• Enhance data integration processes between various sources
• Extract data from diverse sources, including APIs, Oracle, ADLS, SFTP, SharePoint, Salesforce, and Google BigQuery, to the data warehouse
• Develop new Azure Data Factory pipelines and transform data as required
• Resolve incidents proactively to prevent SLA breaches
• Support existing workspaces, semantic models, Power BI dashboards, and reports
• Transform data during loading into Azure Data Warehouse using Data Factory and stored procedures
• Create stored procedures for incremental data loading and manage deletion flags in tables
• Design schemas and tables in Azure Data Warehouse, load data using Azure Data Factory, and manage access permissions at the schema and object levels
• Develop stored procedures for both incremental and full data loads according to client specifications
• Deploy new developments from the working branch to the live branch using Azure DevOps
• Address data quality issues, including duplication, missing records, and execution failures of stored procedures
• Manage user access through Azure Active Directory groups for databases, schemas, tables, and views
• Create additional report pages in Power BI based on specific requirements
• Monitor the end-to-end data platform, including IR server CPU utilization, memory utilization, and Azure Synapse dedicated pool DWU usage

Project: Productivity Tracker
Company: ICICI Bank Ltd.
Duration: Feb-2020 to Aug-2021

• Extract insights from data to inform decision-making
• Developed reports highlighting key metrics, including top branches by volume, the most utilized services by customer type, and global branch performance maps
• Imported data from SQL Server to Power BI for reporting purposes
• Possess extensive knowledge of data modeling and Power Query for data transformation
• Utilized Power Query to clean, transform, and load data efficiently into Power BI
• Created and managed complex queries to combine multiple data sources and streamline data preparation
• Worked extensively with Power BI Desktop and Power BI Service
• Created required measures and calculated columns using DAX
• Enhanced user experience by implementing bookmarks, buttons, and drill-through functionality
• Implemented Row-Level Security (RLS) to restrict branch performance visibility to branch heads and employee performance to individual employees
• Configured Power BI gateways for data refresh processes in Power BI Service
• Scheduled dataset refreshes according to project requirements
• Created dashboards to capture customer feedback for actionable insights
• Experienced in publishing Power BI reports and dashboards in Power BI Service