Ravi Kiran Reddy Yeddula

Company Overview: PSECU is a state-chartered credit union, headquartered in Harrisburg, Pennsylvania. PSECU provides consumers, corporations, governments, and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management.

• Designed, created, and configured logical SQL servers, databases, and elastic pools in the Azure Cloud environment to meet organizational requirements.
• Orchestrated data import/export processes within Azure Cloud, ensuring secure and efficient data transfer.
• Configured robust monitoring alerts and interactive dashboards leveraging SQL Server capabilities to enable proactive system health checks.
• Developed and managed Azure Synapse Pipelines to orchestrate and automate data workflows, including data ingestion, transformation, and loading.
• Implemented complex ETL workflows in Synapse Pipelines, integrating various data sources such as Azure Blob Storage, Azure SQL Database, and Data Lake.
• Utilized Notebooks in Synapse to develop data transformation logic using Python and PySpark, enabling large-scale data processing.
• Wrote and optimized PySpark scripts to process and transform big data stored in Azure Data Lake and Delta Lake.
• Developed parameterized pipelines to support reusable workflows and dynamically control activities such as data partitioning and incremental loads.
• Configured monitoring and debugging for Synapse Pipelines to ensure seamless data flow and identify failures for quick resolution.
• Created and designed ETL processes consisting of SSIS packages, stored procedures, and PowerShell scripts.
• Developed advanced SSIS packages for loading data from diverse sources, including Excel, Access, and flat files.
• Created SQL Server Integration Services (SSIS) packages for both incremental and full data loads, enabling seamless integration from various sources.
• Applied ETL best practices, including error handling, logging, and reusable components, to ensure maintainability and reliability.
• Designed and developed complex SSAS cubes for multidimensional data analysis, supporting advanced business intelligence and decision-making.
• Assisted BI Developers in building cubes using extracted and transformed data from the data warehouse, enabling actionable insights.
• Engineered advanced data optimization techniques, including paginated/row-compressed tables, columnstore indexes, and table partitions to enhance database performance and scalability.
• Designed and developed efficient database objects, including stored procedures, functions, views, and triggers using T-SQL to streamline data transformation.
• Managed and optimized critical database components, including T-SQL views, cursors, index statistics, and query execution plans to enhance system performance.
• Automated routine database operations such as backups and reindexing through custom scripts, ensuring seamless daily job execution.
• Identified and resolved performance bottlenecks, fine-tuning queries, ETL mappings, and workflows to maximize efficiency and minimize latency.
• Designed and delivered comprehensive SSRS reports and Excel-based solutions, including expense analysis and balance sheet analysis tailored to business needs.
• Configured and managed monitoring alerts and dashboards for proactive system checks in both SQL Server and Redgate.
• Provided 24/7 production support, ensuring timely database and log backups, restoration processes, and reliable backup scheduling.
• Secured critical data by backing up master and system databases and implementing disaster recovery strategies, such as configuring replication servers and transactional replication.
• Configured SQL Server Always On Availability Groups and clustering to ensure high availability and disaster recovery for critical applications.
• Configured replication servers and transactional replication for high availability and redundancy.

Company Overview: PSECU is a state-chartered credit union in Harrisburg, Pennsylvania. PSECU provides consumers, corporations, governments, and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management

• Administered SQL Server environments (2012, 2014, 2016) with Always On Availability Groups, Windows Server Failover Clustering (WSFC), and high availability solutions.
• Migrated large databases from SQL Server 2008 to newer versions, troubleshooting performance and compatibility issues.
• Designed and implemented Always On architectures across different clusters, including Active/Passive setups with read-only replicas and listeners.
• Monitored and managed SQL Server performance using Redgate tools (SQL Monitor, SQL Dependency Tracker, SQL Compare) and configured alerts to ensure proactive issue resolution.
• Designed and optimized database structures, including data files, filegroups, indexing, and capacity planning, ensuring performance and scalability.
• Automated operational tasks using PowerShell scripts, including performance monitoring, security audits, and database backups.
• Implemented log shipping, mirroring, and backup strategies for disaster recovery, ensuring data integrity with DBCC consistency checks.
• Developed, deployed, and optimized SSIS packages for complex ETL workflows, integrating data from multiple sources.
• Resolved performance bottlenecks using SQL Profiler, execution plans, and index tuning, and eliminated deadlocks through query optimization.
• Provided 24/7 production support, troubleshooting job failures, managing replication servers, and ensuring system uptime.
• Managed database security by creating and maintaining users, roles, and privileges, ensuring compliance with security policies.
• Performed SQL Server patching and upgrades, applying service packs and hotfixes to maintain system reliability.
• Collaborated with stakeholders to analyze system requirements, reverse engineer legacy systems, and design optimized database solutions.