Venkatrathnam Duddela

Developed T-SQL objects including stored procedures, functions, views, and triggers based on business requirements. Built and maintained SSIS ETL packages for extraction, transformation, validation, and loading, and created Azure Data Factory pipelines with linked services, datasets, and triggers. Produced SSRS reports and supported data warehouse models using fact and dimension tables with star/snowflake schemas. Handled query optimization, indexing and execution plan tuning, plus data migration validation and production/UAT support for ETL, database, and reporting issues.

Delivered SQL Server and MSBI features for a parking operations and transaction processing platform. Implemented T-SQL logic and SSIS-based ETL workflows for data integration and validation, and created SSRS reports for operational visibility. Monitored scheduled SQL Server Agent jobs and investigated production issues using root cause analysis, supporting UAT and post-deployment validation.

Built database and reporting components for a parking data management solution focused on operational and financial outputs. Developed complex SQL queries, views, and stored procedures, and implemented SSIS ETL workflows for data migration and source-to-target validation. Created SSRS reports, supported SQL Server replication activities, and performed reconciliation to investigate and resolve data discrepancies.

Worked on a cloud data integration and analytics platform on Microsoft Azure for enterprise transformation and reporting. Developed Azure Data Factory pipelines with linked services, datasets, and triggers, including scheduled ETL workflows and pipeline monitoring with error handling. Performed validation and reconciliation for source-to-target data and troubleshot ADF pipeline failures and data processing issues using Azure SQL Database and SQL Server.