Modukuru Nagaraju

• Having 3.5 years of experience in Application development and Support projects using SQL, PL/SQL and Unix with extensive understanding of different Application development tools and technologies.

• Having good experience in SQL and PLSQL development using ORACLE 11g and ORACLE 12c. ORACLE 19c.SQL Server Management Studio 11

• Extensive experience in creating complex database objects like stored procedure, Functions, Packages, Collections and Triggers.

• Experience in Creating Tables, Views, Constraints, Sequences and Synonyms.

• Extensive experience in DDL, DML, TCL Commands.

• Proficient in PL/SQL programming of using Cursors, user defined exception, Pragma Autonomous Transaction, Bulk Collect and for all, Explain Plan, Sys refcursor, indexes, Analytical Functions,

• Aware of the Concept of Exception handling mechanism in various scope and visibility. • Having knowledge on Performance Tuning.

• Involved in development of code from scratch for the given requirement.

• Planning, delivering and implementation of quality solutions as per scheduled milestones.

• Good communicational and interpersonal skills and involved in client interactions for scoping, effort estimates and status reporting.

• Ability to learn new technologies with minimal time period and excellence in team playing with multi-location teams.

• Experience on Autosys Scheduling Jobs

• Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.
• Demonstrated leadership by making improvements to work processes and helping to train others.
• Prioritized and organized tasks to efficiently accomplish service goals.
• Planned and completed group projects, working smoothly with others.
• Achieved cost-savings by developing functional solutions to problems.

• • Developed stored procedures, functions, Triggers, PLSQL programmed unit etc as per the project requirement
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Based on the mapping document we will create tables and write triggers for enhanced validation and business logic management.
• Modified existing procedures, functions as per the Project requirements.
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Using SQL developer tool we are debugging the code and unit test.
• Created record types, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Attend the daily scrum meetings