SUMMARY:

• 9 yrs. Oracle Certified Professional with programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Effectively made use of Table Functions, Indexes, Collections, Analytical functions, and Materialized Views.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle and SQL-Server databases..
• Writing/tuning Complex database objects like Stored Procedures, Functions, and Packages and Triggers using SQL and PL/SQL.
• Experience in Dynamic SQL, Records and PL/SQL Tables.
• Involved in large volume data migration to Enterprise Data Warehouse using PL/SQL, UNIX scripts, SQL Loader.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Involved in creating Procedures, packages using REF Cursors, BULK collects and BULK binds.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization CBO .
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
• Superior knowledge in generating XML documents and Extract / Parsing XML.
• Requirement gathering and conceptual design of databases in multiple projects
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Excellent Analytical and Problem solving skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. Oracle Developer

Responsibilities:

• Working on Production Data fixes including Invoices, Payments and Enrollment.
• Performs Oracle database troubleshooting and management.
• Extensively worked in Oracle SQL, PL/SQL, SQL Plus, SQL Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Analyze and troubleshoot system Issue in timely manner.
• Involved in Maintenance and Resolve CR Tickets. Perform Change Request CR / Implementation Request IR after bug fixes.

Environment: Oracle 10g/9i Database, SQL, PL/SQL, Perl/Shell Scripting, Windows 7 Enterprise, Sun Solaris, SQL Loader, SQL Developer, Notepad , Microsoft Office.

Confidential

Role: Sr. Oracle Developer

Responsibilities:

• Design and implement databases and database support tools and procedures in support of complex business application development requirements and processes for N7 Converted Clients.
• Involved in Technical Specification of the Requirements for Converted clients Catalog System
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Performs Oracle database troubleshooting and management.
• Extensively worked in Oracle SQL, PL/SQL, SQL Plus, SQL Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Involved in Offer setup Data Configuration of Gift cards and Merchandise.
• Developed and Updated Shell scripts and SQL control files.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• As per business requirement developing/customizing reports.
• Attending daily/weekly meetings with BSA s and other members.
• Involved in Performance tuning of complex queries.

Environment: Oracle 10g/9i Database, SQL, PL/SQL, Perl/Shell Scripting, Informatica, Cognos Reports, Windows 7 Enterprise, Sun Solaris, TOAD 12, SQL Developer, Subversion, Notepad , Microsoft Office

Confidential

Role: Senior Programmer Analyst

Responsibilities:

• Setup, build and automate database code deployment.
• Performs Oracle database troubleshooting and management.
• Responsible for the integrity and security of data in these databases.
• Responsible for performance tuning of Database Applications.
• Worked with QA and BSA team throughout the project until post production support.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using UNIX Shell Scripts.
• Loaded Oracle tables from flat files using SQL Loader and Import Tools,
• Involved in documenting users requirements, technical specifications and Reporting manuals.
• Used Bulk Collect feature to improve performance.
• Analyzed and computed statistics to improve response time for queries.
• Responsible for Code merge and version through Tortoise subversion.

Environment: Oracle 10g/9i Database, SQL, PL/SQL, Perl/Shell Scripting, Informatica, Cognos Reports, Windows 7 Enterprise, Sun Solaris, SQL Loader, TOAD 12, SQL Developer, PVCS, Subversion, Notepad , Microsoft Office.

Confidential

Role: Sr. Programmer Analyst

Responsibilities:

• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
• Develop logical and physical data models using Erwin.
• Developed new PL/SQL procedures, functions, packages etc. based upon the business rules.
• Prepared/customized UNIX Perl scripts for batch processing.
• Involved in Unit Testing and assisted in facilitating User Acceptance testing.
• Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the project.
• Built Data base objects like Tables, Sequences, Indexes, Triggers, and Views.
• Extensive working experience in analyzing reason for job failures, handling user queries

Environment: Oracle 10g/9i Database, SQL, PL/SQL, Perl/Shell Scripting, Informatica, Cognos Reports, Windows 7 Enterprise, Sun Solaris, Oracle XE, SQL Loader, TOAD 12, SQL Developer, PVCS, Notepad , Microsoft Office.

Confidential

Role: Oracle Developer

Responsibilities:

• Writing PL/SQL code Procedures, Functions and Packages for various data Transactions
• Up gradation and Enhanced customized screens from Oracle Forms 6i to Oracle Forms 10g
• Up gradation and Enhanced reports from Report Builder 6i to Report 10g
• Encryption and Decryption of data Using Algorithm AES256
• Worked with users on application problems. When these problems were the result of code bugs, fixed the bugs and worked with quality assurance analysts to verify the corrections.
• Trained new developer to assist in ongoing system support and maintenance.
• Developed processes to manage daily work flow of information by communicating, redesigning, and establishing follow up techniques to prioritize tasks, manage scheduling conflicts, and direct priority items to attention of managers.

Environment: Oracle 10g Database, SQL, PL/SQL, Forms 10g, Reports 10g, Toad, SQL Loader

Confidential

Role: Sr. Oracle Developer

Responsibilities:

• Development of data entry screens using forms 6i Tabbed Forms, Master Detail Form
• Developing Stored Procedures, Functions, Packages and documenting them
• Developing report as per client requirement using Report6i.
• Write Complex and ad-hoc queries for retrieving and populating data in to tables
• Design and develop the GUI's for the application using Oracle Forms 6 for legacy systems and core advance Form 10.
• Worked on applications using various other programming languages including SQR, C, and Shell Scripts
• Re-Write some of the complex SQR API's in to PL/SQL application.
• Analyze and evaluate statistics on the Application and Databases.
• Extensive Use of tools like TOAD and SQLPLUS for handling the database activities.
• Worked with Data Bound controls like Data Table, Explain Plans, Data View and Query Viewer.
• Design Database Views and Structures as Global Temporary tables for faster Querying and improve performance at the application level.
• System Testing, Debugging and finding solution to the project related issues.
• Effective Interaction with System administrators, Network Administrators and Production Support and other Application groups through on call for high priority issues and write shell script for daily processes
• Used Version control to maintain code changes
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.

Environment: Oracle 9i, MS Access, Pl/SQL, Forms 6i/10, Reports 6i/10, Toad, UNIX, PRO C, SQL Plus, Windows XP Professional, Sun Solaris 2.7, SQR Structured Query Reporter

Confidential

Role: Oracle Developer

Responsibilities:

• Writing PL/SQL code Procedures, Functions and Packages for various data feeds
• SQL and PL/SQL Tuning using EXPLAIN PLAN and SQL HINTS
• Developed customized screens to enter survey data using Oracle Forms 6i
• Developed reports for surveys using Report Builder 6i

Environment: Oracle 8i Database, SQL, PL/SQL, Forms 6i, Reports 6i, Toad