IdentityProgramming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Extensive RDBMS experience includes Oracle 10g/11g SQL, PL/SQL.
• Created Schema, Users, Tables, Constraints, views, Indexes, Privileges, Cursors, Ref Cursors, anonymous blocks, sequences, synonyms.
• Created oracle Database Users and Roles.
• Developed PL/SQL Packages, Procedures, Functions, SQL Scripts and Database Triggers
to populate the data by applying business logic.
• Used Materialized Views, Packages and Dynamic SQL
• Experienced in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Experience in SQL*loader, Import and Export utilities and Unix Shell scripting.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
• Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database.
• Expertise in using tools such as PL/SQL Developer and SQL*Plus.
• Basic knowledge of ETL Tool.
• Proficient in unit testing (Test Plan creation and Test Case execution).
• Basic knowledge of Oracle Database Architecture
Saidapet, Chennai 
Certified
