● Software professional 4+ years of experience in Oracle PLSQL developer with sound knowledge in Oracle 10g/11g, SQL, PLSQL and Unix.
● Having good domain experience in Investment Banking.
● Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
● Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like PL/SQL Developer.
● Worked extensively on Ref Cursor, Collections and also in Bulk Collections for better performance and easy retrieval of data.
● Experience in Query optimization & Performance tuning using Execution Plan, Performance Monitor.
● Expertise in Dynamic SQL, Collections and Exception handling.
● Having knowledge in Unix navigation commands like Grep, Sed, Awk, Find, VI editor commands.
● Ability to write complex SQL queries for reporting purposes.
● Capable of working independently and as well as a part of a team.
● Flexible to work in Rotation shifts.
● Expertise in debugging and solving the issues.
● In the documentation part, created Impact Analysis,Root Cause Analysis and Detail Design Document.