SUMMARY

• Around 9 years of IT experience working as Oracle Technical Consultant/Analyst on Sun Solaris, AIX 5.3 and Windows 2000/XP Professional/NT Server in 24x7 Production and Development environments.
• Experience with Oracle 8i, 9i, 10g versions.
• Experience in writing Packages, Procedures, functions and triggers using PL/SQL.
• Optimising the SQL Queries through Database Tuning using TOAD/PLSQL Developer.
• Experience in Oracle 8i/9i/10g/11g (both on UNIX and Windows environment), SQL*Loader, Export, Import, PL/SQL, SQL*Plus, Performance Tuning of Database by optimizing SQL and PL/SQL scripts.
• Documentation as per the client requirement.
• Expertise in developing forms using Oracle Forms 6.0/6i/9i/10g/11g, Oracle Designer 9i/10g and Reports using Oracle Reports 6.0/6i/9i/10g/11g, SQR Reports.
• Experience on Korn/Bourne shell scripting, includes file monitoring scripts, data manipulation scripts and data load scripts.
• Extensively used Hummingbird and SSH for transfer and compilation of Oracle forms and reports developed.
• Responsibilities include client interaction to understand expectations, requirements, formulating solutions, designing the architecture and developing the application besides managing teams.
• SQL loader, DB links, Materialized view creation, index creation and fine - tune queries.
• Involved in Resolving the Tickets in Service Center depending on the priority of the tickets.
• Good understanding of UNIX concepts and architecture.
• Initiating the project with identifying the requirements, estimating and designing. Ensuring and implementing a good development plan. Work distribution and tracking is one of the prime responsibilities.
• Experience on Logical & Physical Designing of Databases. Data Modelling, Conceptual Design & Data Architecture. Extensive use of Erwin as a modelling tool.
• Experience in technical documentation.
• Good communication and interpersonal skills.

TECHNICAL SKILLS

RDBMS: Oracle 8i, 9i, 10g, 11g.

GUI Tools: Oracle Forms 6i/9i/10g/11g, Oracle Reports 6i/9i/10g/11g, Oracle Designer 9i/10g.

Languages: SQL, PL/SQL, SQR, UNIX Shell Scripting.

Other Tools: SQL*LOADER, Putty, SQL Navigator, PL/SQL Developer, TOAD, Hummingbird, SSH

Operating Systems: Sun Solaris 5.8/5.6,HP-UX 11.x/10.x, AIX 5.3, Linux, UNIX, Windows 2000/03/NT/XP

PROFESSIONAL EXPERIENCE

Confidential, NJ

Lead Oracle Developer

Responsibilities:

• Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions etc.
• Extensively worked on Developing Forms 10g and Testing of Forms.
• Developed Available Inventory reports using Oracle Reports 10g.
• Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
• Performed SQL performance tuning for various PL/SQL packages, Oracle forms and Oracle Reports.
• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Provided Application support with production support.
• Involved in Writing Backend Procedures, Function & Packages in PL/SQL.
• Trouble shooting and provide support for Production environment.
• Maintained the data integrity and security using integrity constraints and database triggers
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards, besides reviewing the code.
• Customization of code as per the user requirements.
• Involved in writing the database triggers to furnish the audit details.
• Extensively used Dynamic SQL in Oracle Forms and Oracle Reports.
• Designed notification process for order movement using PL/SQL.
• Developed Unix Shell Scripts to automate backend jobs, load data into the database.
• Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanisms for data migration for bulk upload.
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization.
• Developed various forms as per the requirements for data processing.
• Involved in Preparing Detailed technical documents

Environment: Oracle 10g, TOAD for Oracle 10g, Oracle Reports Builder 6i/10g, Oracle Forms Builder 6i/10, Unix, Hummingbird.

Confidential, NE

Sr. Oracle Developer

Responsibilities:

• Developed Available Inventory reports using Oracle Reports 10g.
• Developed new forms and new reports using Oracle Forms 10g and Reports 6i/10g.
• Extensively used Dynamic SQL in Oracle Forms and Oracle Reports.
• Written PL/SQL programs for generating reports from Oracle Database.
• Created several materialized views for reporting purpose and better performance.
• Done the data loading (Migration) process from flat files XML files into the new database respective tables using SQLLDR by writing scripts.
• Developed the complex search Measurement functionality by writing stored procedures, package and function.
• Tuning SQL using Explain Plan and SQL Tuner.
• Detected and rectified errors. Modified & enhanced the related PL/SQL stored procedures according to the requirements.
• Used TOAD Xpert for development of Oracle scripts and procedures.
• Assisted the team of Developers in SQL statement tuning and use of ANALYZE command, Events trace to track the execution plan of statements.
• Involved in Writing Backend Packages extensively in PL/SQL.
• Defining and reviewing the coding standards, besides reviewing the code.
• Customization of code as per the user requirements.
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using Explain plan, Tkprof, SQL Trace, Analyze, Ordered Hints, query tuning and optimization.
• Built Error management System for the Capturing all the Errors in the Packages and all the errors that belong to pl/sql are generated using error management system.
• Extensive Use of External tables and Creating Sequences to generate numbers on the fly.
• Co-ordination between development, testing and production teams and attending bridge calls and technical.
• Developed Front-end screens using Oracle Forms 10g, Reports 10g.
• Migration of Front end forms, reports from forms 9i to 10g.
• Created, debugged and modified form level validations.
• Unit testing of all the forms and reports developed and modified thoroughly before QA testing.
• Closely worked with functional team and users in resolving the issues.
• Provided Tier3 Application support with 24/7 production support.

Environment: Oracle 9.2/10g, Oracle Discoverer 9i, Oracle forms 10g, Oracle Reports 10g, SQL, PLSQL, TOAD Xpert Ver 7.6, SQLLDR, SSH.

Confidential, Seattle

Sr. Oracle Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions etc.
• Extensively worked on Developing Forms 9i and Testing of Forms.
• Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
• Involved in writing the database triggers to furnish the audit details.
• Developed Available Inventory reports using Oracle Reports 10g.
• Extensively used Dynamic SQL in Oracle Forms and Oracle Reports.
• Designed notification process for order movement using PL/SQL.
• Developed Unix Shell Scripts to automate backend jobs, load data into the database.
• Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanism for data migration for bulk upload.
• Performed SQL performance tuning for various PL/SQL packages, Oracle forms and Oracle Reports.
• Provided Tier3 Application support with 24/7 production support.
• Involved in Writing Backend Procedures, Function & Packages in PL/SQL.
• Trouble shooting and provide 24x7 supports for Production environment.
• Maintained the data integrity and security using integrity constraints and database triggers
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards, besides reviewing the code.
• Customization of code as per the user requirements.
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization.
• Developed various forms as per the requirements for data processing.
• Involved in Preparing Detailed technical documents

Environment: Oracle 10g, PL/SQL Developer 7.1.5, Oracle Reports Builder 6i/10g, Oracle Forms Builder 6i/10g, Java, AIX 5.3, Unix, PERL, Hummingbird.

Confidential, FL

Sr. Oracle Developer

Responsibilities:

• Responsible for gathering requirements from users for reports development and interface program customizations and in analyzing business process.
• Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
• Involved in writing the database triggers to furnish the audit details.
• Developed Available Inventory reports using Oracle Reports 10g.
• Developed new forms and new reports using Oracle Forms 10g and Reports 6i/10g.
• Extensively used Dynamic SQL in Oracle Forms and Oracle Reports.
• Modified order line report using SQR.
• Designed notification process for order movement using PL/SQL.
• Developed Unix Shell Scripts to automate backend jobs, load data into the database.
• Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanism for data migration for bulk upload.
• Performance Tuning using Hints, Indexes, Explain Plan, TKPROF.
• Performed SQL performance tuning for various PL/SQL packages, Oracle forms and Oracle Reports.
• Worked with the production support team in resolving tickets.

Environment: Oracle 10g, PL/SQL Developer 7.1.5, Oracle Reports Builder 6i/10g, Oracle Forms Builder 6i/10g, SQR, PITTS.CON, PVCS, Java, AIX 5.3, Unix, PERL, Hummingbird.

Confidential, Austin, TX

Sr. Oracle Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with client.
• Responsible for assigned code /screen modifications, enhancements and adhoc data requests.
• Generated new forms for front end user application using Oracle forms Builder 10g.
• Involved in developing new reports and enhancements to the existing reports using Oracle Reports 10g.
• Developed a PL/SQL package 'VZ GC USAGE REPORT' for generating a report which displays the details of customers who received gift cards.
• Developed stored procedure 'load addr std’ which updates the information of the addresses of the transactions, so that they can be checked for valid address.
• Developed a PL/SQL package 'VZ EXP REDEEM REPORT' for generating a report which facilitates in analyzing the gift cards redeemed by the customer.
• Used SQL * Loader to upload the data provided in the staging tables to cleaned further before fulfilling them.
• Worked as production support for Verizon rebate system to troubleshoot the problems that occur during the production run.
• Extensively involved in developing new database objects such as Tables, Views, Procedures, Functions and Packages as per the business requirements.
• Extensive use of LOVs, RG, Alerts, Object groups & features in Oracle forms 10g for developing new screens.
• Used lexical parameters in developing new reports using Oracle Reports 10g.
• Extensively involved in generation of adhoc reports for month end and quarter end data to be sent to the lenders as per the requirements.
• Wrote PL/SQL Procedures, Functions and Triggers in different places using Oracle Forms and Reports 10g.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Involved in Code Reviews and preparing unit test cases.
• Involved in preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Designed and extensively worked on project documentation, creation of solution design document with workflows using Visual Studio for every project.
• Extensively used External tables and Created Sequences to generate numbers on the fly.
• Involved in developing new korn shell scripts and modified existing shell scripts as per business requirements.
• Used Serena Version Controls repository for database objects, Oracle Forms Reports, sqrs, shell scripts dev.
• Extensively involved in back door data fix for production support. Provided 24/7 production support.

Environment: Oracle 10g, SQL Navigator 6.0, Oracle Reports Builder 10g, Oracle Forms Builder 10g, Oracle Designer 9i/10g, Serena Change Man Version Control, Unix.

Confidential, NJ

Sr. Oracle Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with client.
• Extensively Involved in Preparing Detailed technical documents from the functional specifications.
• Reviewed the logical and physical database design and Technical Specifications.
• Done the re-engineering process for Test Planning module from the existing EDW Database.
• Written PL/SQL programs for generating reports from Oracle Database.
• Defined UNIX shell scripts for file comparisons & file manipulations.
• Created several materialized views for reporting purpose and better performance.
• Expertise in setting up UNIX cron jobs using cron tab in Unix
• Done the data loading (Migration) process from flat files XML files into the new database respective tables using SQLLDR by writing scripts.
• Developed the complex search Measurement functionality by writing stored procedures, package and function.
• Tuning SQL using Explain Plan and SQL Tuner.
• Detected and rectified errors. Modified & enhanced the related PL/SQL stored procedures according to the requirements.
• Used TOAD Xpert for development of Oracle scripts and procedures.
• Assisted the team of Developers in SQL statement tuning and use of ANALYZE command, Events trace to track the execution plan of statements.
• Involved in Writing Backend Packages extensively in PL/SQL.
• Defining and reviewing the coding standards, besides reviewing the code.
• Customization of code as per the user requirements.
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS, query tuning and optimization.
• Built Error management System for the Capturing all the Errors in the Packages and all the errors that belong to pl/sql are generated using error management system.
• Extensive Use of External tables and Creating Sequences to generate numbers on the fly.
• Co-ordination between development, testing and production teams and attending bridge calls and technical.
• Developed Front-end screens using Oracle Forms 10g, Reports 10g.
• Migration of Front end forms, reports from forms 9i to 10g.
• Created, debugged and modified form level validations.
• Unit testing of all the forms and reports developed and modified thoroughly before QA testing.
• Closely worked with functional team and users in resolving the issues.
• Provided Tier3 Application support with 24/7 production support.

Environment: Oracle 9.2/10g, Oracle Discoverer 9i, Oracle forms 9i/10g, Oracle Reports 9i/10g, PERL, SQL, PLSQL, TOAD Xpert Ver 7.6, PVCS, SQLLDR, Erwin, AIX 5.3, SSH.

Confidential, Des Moines, IA

Oracle PL/SQL developer

Responsibilities:

• Involved in Capturing Requirements defined and Managed as Part of CMM.
• Designed oracle LIMS interfaces for data validations & data integration process.
• Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.
• Defined stored procedures, functions & packages for Oracle LIMS application.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle 10g.
• Built physical data structures like tables, views, constraints & Indexes.
• Implemented business rules by using database triggers.
• Participated and contributed in discussions about database issues, performed applications tuning by analyzing trace files and explain plans.
• Supported development and test databases for on going development and testing.
• Worked extensively in tuning SQL, PL/SQL and Stored procedures, identifying and resolving tuning issues. Implemented Indexing and Security Management.
• Integrated Oracle reports with Oracle forms interface and delivered to users.
• Responsible for migrating the data from different databases into a centralized database for reporting using database triggers, procedures and packages to generate reports for customers based on requirements.
• Analyzed sql statements and implemented explain plan with Index hints.
• Created several materialized views for reporting purpose and better performance.
• Expertise in setting up UNIX cron jobs using crontab in UNIX.
• Designed and developed various types of Forms and Reports for Oracle LIMS application.
• Customized and maintained several Forms and Reports.

Environment: Oracle 10g/9i, Oracle reports Builder, Oracle LIMS, SQL, PL/SQL, SQL*LIMS v5.0.1, Rational Rose, Erwin, TOAD, Forms, Reports, UNIX.

Confidential, MA

Oracle PL/SQL Developer

Responsibilities:

• Creation of back end triggers for faster and integral data.
• Writing Custom Packages to implement various functional areas.
• Loading Data from legacy system via SQL* loader.
• Developed UNIX shell scripts for handling large number of files.
• Schedule jobs via oracle jobs using DBMS JOB.
• Use of various DBMS packages to reuse code and automate scripts.
• Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors.
• Extensive use of Oracle 9i features.
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance, Extensive Usage of Indexes.
• Extensive use of TOAD for extracting scripts from the dictionary.
• Extensive use of PL/SQL Collections and Records.
• Creation of Synonyms to create read only objects to maintain the security to give access to specific users.
• Use of Sequences to automate number generation.
• Use of different Exception Handlers and also Create Some User defined Exception Handlers.
• Customization of the support screens.
• Use of Bit map and Function based indexes to improve performance of queries.
• Design and development of Interfaces to Integrate modules.
• Extensive use of dynamic SQL in developing new reports using Oracle Reports 6i.
• Involved in developing scripts for compiling the forms and reports developed AIX 5.3.
• Extensive use of SSH for transfer of forms and reports between AIX and windows operating systems.
• Extensively Involved in Developing Transaction Forms, which involve a lot of validations at all, the levels like Field, Block and Form Level.

Environment: Oracle 9i/8i, UNIX, SQL*Loader, D2K, TOAD, AIX 5.3.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in Preparing Low Level Design Documents, High Level Design Documents.
• Coded the Stored Procedures and functions. And well tuned the SQL in the application.
• Involved in writing PL/SQL packages and database triggers.
• Migration of databases from one version to the other versions and applying patches.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Generation of the flat files using UTL FILE package for the mainframe users.
• Database design, E-R diagrams, Logical, Physical layout design using Erwin.
• Extensively Involved in Knowledge Transfer for documentation team for development activities.
• Data modeling, database design and creation of database using data modeling tools. Creation of Data Flow diagrams and Entity Relation Diagrams using Erwin.
• Defining and reviewing the coding standards, besides reviewing the code.
• Involved in developing and modifying numerous forms and reports using Forms Builder and Reports Builder.
• Analyzing the enhancement / support request, estimating effort and providing architectural and technical support to the team, besides developing key components.

Environment: Oracle 8, Forms 6i, Reports 6i, Erwin, UNIX and Windows NT.