Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle. Experience in Data migration using import and export. Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose. Expertise in writing procedures, functions, views, materialized views as required. Ability to write complex sql queries for reporting purpose. Creating complex views,materialized views on multiple table as per customer requirement. Uses PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.