Having around 4 Years of experience in IT industry as a Programmer (PL/SQL Developer) as well as production support engineer.
Experience in SQL and PL/SQL.
Experience in writing, Cursors, Joins, Exceptions, Sub queries, Stored Procedures, Functions, Packages and Database Triggers, views, synonyms using PL/SQL in oracle.
Proficient in creating several other database objects like Sequences, Indexes, Views.
Wrote complex SQL queries using Joins, Inline views, Analytical functions, Sub queries and correlated sub queries to retrieve data from the database.
Good Knowledge in Materialized Views.
Experience in modifying various existing packages, procedures, functions, triggers and Materialized Views according to the new business needs.
Experience on using PL/SQL Collections.
Hands on Dynamic SQL and Exception handling..