Surendra Babu Yaluru
Salt Lake City,USA
Summary
Dynamic Senior SQL Developer with over 10 years of experience specializing in SQL Server, SSIS, and seamless data integration across enterprise systems. Proven expertise in schema design, performance tuning, and problem-solving, along with a strong track record of providing production support for financial and academic platforms managing millions of dollars. Recognized for a proactive approach to ownership and early risk detection, consistently delivering reliable solutions within tight deadlines. Committed to leveraging technical skills to drive efficiency and enhance data-driven decision-making in fast-paced environments.
Overview
13
13
years of professional experience
Work History
Database Engineer
Willis Towers Watson (WTW)
Salt Lake City, Utah, USA
07.2021 - Current
- Designed databases and data structures for the Account Management module. Implemented region based DB partitioning. Ensured constraints, indexes, and security exist on the tables; used in-memory tables in Stored Procedures for Performance Optimization.
- Designed and implemented enhancements to existing workflows, like an automated resend mechanism (self-healing) for Balance Transfer requests, successfully preventing orphaned funds totaling $5M across 250 closed accounts ensuring financial accuracy.
- Refactored complex views into optimized Stored Procedures or Functions using Common Table Expressions (CTE), optimized keys, eliminated redundant JOINs, unnecessary conditions, resulting in a 95% improvement in total execution duration and an 82% decrease in average wait times.
- Authored and secured approval for an Architecture Decision Record (ADR) to replace UDF-driven lookup values with normalized reference tables, enforcing Foreign Key constraints across 10+ SQL Server tables, improving Data Integrity.
- Served as SSIS Subject Matter Expert in my portfolio; troubleshooting job failures, resolving incidents to ensure the accurate calculation and export of accounts, account holders, and funds (~$1B annually) to administrators, maintaining operational continuity.
- Led the upgrade of 13 SSIS solutions to SQL Server 2022 by refactoring packages and updating dependencies, ensuring end-to-end ETL stability and platform compatibility.
- Instituted automated tests using the tSQLt framework, safeguarding data integrity, ensuring correct functional behavior and preventing regressions in production.
- Extended SSIS packages with Encryption capabilities, securing all outbound third-party file transfers and protecting sensitive data both at rest and during transmission.
Senior Software Engineer
Integra Micro Software Systems Pvt. Ltd.
Bengaluru, India
02.2018 - 12.2020
- Designed and developed an event-driven notification system for a University's Course registration system, serving 4K students and 12K alerts per semester, through triggers, database queue processing, and scheduled C# services, delivered right the first time with zero rework.
- Automated the annual course intake process for ~50 departments by implementing secure file uploads with validation and automated document consolidation, reducing Academic Calendar preparation time from weeks to days.
- Implemented enterprise security features, including Microsoft authentication for DB access management, automated HTTP-to-HTTPS redirection, and SSL integration, securing access for thousands of users and eliminating insecure traffic.
- Devised a process that obfuscates sensitive data (PII), when restoring databases to lower environments from production backups.
- Rapidly developed an application for Benefits enrollment within days, achieving adoption by hundreds of staff, while generating periodic stakeholder reports, number of users submitted forms, not responded by department, to drive operational visibility and decision-making.
- Delivered end-to-end development and production support for multiple applications; including performance optimizations like reduction of DB contention, troubleshooting system log/transaction log issues, and mitigated high memory utilization.
- Designed and delivered a complaint management system featuring status tracking and email alerts, enhancing transparency and ensuring Data Privacy for students, and staff.
Technology Analyst
Infosys Limited
Mysore, India
03.2013 - 02.2018
- Owned multiple change requests end-to-end, involving upstream changes analysis, downstream impact evaluation and proactive reconciliation of database schema, objects, and DTS packages to ensure System Integrity, up-to-date.
- Proactively resolved a critical UI showstopper on the landing page by independently identifying the root cause and implementing a fix within hours, enabling on-time test release and earning a Golden Stamp award.
- Identified critical defects that escaped both development and QA teams by meticulously validating complex fee calculation logic against independently derived reference models, averting future escalations and rework, and establishing myself as a subject matter expert.
- Analyzed vendor release notes and executed first-time-right system reconciliation, incorporating SQL schema changes, SSIS/DTS modifications, receiving recognition from onsite technical leadership.
Education
MS - Information Systems
University of Utah
12.2021
Bachelor of Technology - Electrical & Electronics
JNTUA college of engineering
India04.2012
Skills
- SQL Server
- TSQL
- RDBMS
- Azure SQL Database
- AWS RDS
- SSIS ETL
- TSQLt
- C#
- NET
- WEB API
- Python
- PyCharm
- Azure
- SSMS
- Visual Studio
- VS Code
- IIS
- JIRA
- GitHub
Timeline
Database Engineer
Willis Towers Watson (WTW)
07.2021 - Current
Senior Software Engineer
Integra Micro Software Systems Pvt. Ltd.
02.2018 - 12.2020
Technology Analyst
Infosys Limited
03.2013 - 02.2018
Bachelor of Technology - Electrical & Electronics
JNTUA college of engineering
MS - Information Systems
University of Utah