Experience in tuning complex SQL statements using Explain plan and SQL trace.Experience in maintaining and developing database objects like tables, views, indexes, sequences, synonyms etc.Experience in quality testing of data-warehouse objects, using a customized scripts based on in-house methodology.Utilized oracle advance features like Bulk Bind (Bulk collect, For all), Ref Cursor, and Index - By Tables.Experience of complete Software Development lifecycle (SDLC) process.Fundamental understanding of materialized views, replication, and external tables.Written PL/SQL validation scripts to transfer clean data from staging tables to production tables. Developed SQL*Loader control programs to transfer external data into staging tables.Proficient in writing stored and application procedures, packages, database triggers and functions using PL/SQL.Involved in database design and data modeling to create ER diagram and database objects.8 years of experience in Oracle, SQL, PL/SQL, and SAS technologies involving database design, application development, implementation, quality testing, statistical analysis, and support.

Toad for oracle query builder