YEDUKONDALU YEPURI

• Developed and implemented complex SQL queries to extract data from multiple databases.
• Created stored procedures, functions, views, triggers and indexes for efficient data manipulation.
• Optimized existing queries by analyzing query plans and execution times.
• Performed database tuning activities such as indexing, partitioning and performance monitoring.
• Collaborated with other developers to design ETL solutions that meet business requirements.
• Provided technical support to users in resolving database related issues and errors.
• Worked closely with Business Analysts to understand functional requirements and translate them into technical designs.

Designed logical and physical models of the databases using ERwin Data Modeler tool.

• Developed and implemented SSRS Reports using SQL Server Reporting Services.
• Developed stored procedures, functions and triggers to support application requirements.
• Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.
• Optimized existing queries for better performance using SQL query tuning techniques.
• Designed complex reports using SQL Server Reporting Services.
• Implemented data migration from legacy systems to new databases.
• Performed backup and recovery of databases on a regular basis.
• Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
• Maintained security by creating user accounts and granting appropriate privileges as needed.
• Provided technical assistance in the form of SQL coding advice to other team members.
• Analyzed business requirements and translated them into logical data models.
• Tested changes to ensure that the system works correctly after implementation.
• Resolved customer service requests related to database errors or performance issues quickly and efficiently.
• Used T-SQL scripting language for creating stored procedures, functions, triggers.
• Integrated multiple data sources into one unified view using views or joins in SQL queries.
• Conducted unit testing of all database objects before deploying them into production environment.
• Tested databases and performed bug fixes.
• Designed and created database systems after reviewing end user's requirements.
• Developed database dictionaries and schemas.
• Prepared documentation for database applications