SUMMARY

• Around 7 years of experience in Application Development & Support using Oracle SQL, PL/SQL on UNIX environment
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Strong Knowledge on Oracle Architecture and Database Design.
• Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.
• Experience in Database design using Normalization and E/R Diagrams.
• Rich experience in writing SQL Coding, Views, PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL.
• Experience in developing Joins, Indexes and sequences.
• Extreme Use of Exception Handling methods along with Pragma Exception init in order to associate our own created exception names.
• Experience in writing Technical Design Documents and Developing Unit Test Documents.
• A Self - starter with a positive attitude, willingness to learn new concepts and accept challenges.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g

Scripting: UNIX Shell Scripting

GUI: Asp .Net

Languages: SQL, PLSQL, Shell scripting, C#

Tools: SQL Developer, SQL plus

Version Control: Tortoise SVN

Build Tools: Jenkins

Applications: MS Office and MS Visio.

Operating Systems: Windows 7, Windows Vista, XP, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr. Oracle PLSQL developer

Responsibilities:

• Responsible for gathering the requirements, designing, developing, testing, metrics and project coordination.
• Responsible for creating the System Requirements and Detailed design document.
• Responsible for guiding the team technically, code review and code delivery.
• Developing Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Developing database objects including Tables, Clusters, Cursors, Indexes, Views, Sequences, Packages, Synonyms, Triggers and Procedures to troubleshoot any database problems.
• Performing unit testing
• Working with QA team to perform Integration testing followed by implementation
• Provide technical support for any application related issues
• Work towards continual service improvements by way of optimizing the code
• Involved in spearheading value additions/process improvements recommendation to the client
• Designing and developing the customizations based on the client requirement

Environment: Oracle 11g SQL, PL/SQL and UNIX Shell Scripting

Confidential, IL

PLSQL developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases. Perform code review as well as design review and provide code approval for production implementation.
• Tuned the SQL queries as well as PL/SQL programs using hints, indexes, partitions and other performance tuning techniques.
• Designed and developed complex Oracle PL/SQL procedures, functions, packages, views, materialized views, triggers, constraints, synonyms and sequences for complex reporting environment with Oracle 11g database.
• Load external file with millions of records into system tables using SQL Loader and generate the outbound file using UTL File package.

Environment: Oracle 11g SQL, PL/SQL, and UNIX Shell Scripting

Confidential

PLSQL developer

Responsibilities:

• Responsible for gathering the requirements, designing, developing, testing, metrics and project coordination.
• Responsible for creating the System Requirements and Detailed design document.
• Responsible for guiding the team technically, code review and code delivery.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Developed database objects including Tables, Clusters, Cursors, Indexes, Views, Sequences, Packages, Synonyms, Triggers and Procedures to troubleshoot any database problems.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Procedures for collecting the data as per business rules and loaded the data in lookup table with the help of Bulk Collections.
• Developed SQL scripts to extract data the various lookup and delta tables and Spool to a flat file.

Environment: Oracle 9i SQL, PL/SQL

Confidential

Support Engineer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created and Modified PL/SQL Triggers, Procedures, Functions and packages.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Developed SQL scripts to Create database objects like Tables, Views and Sequences.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Used For all and Bulk collect to fetch large volumes of data from table.
• Developed Complex Triggers in reports before/after for validation of user input.
• Performed Unit Testing and supported Integration Testing and End User Testing.
• Extensively worked on production issues with effective defect management.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.

Environment: Oracle 10g SQL, PL/