SUMMARY:

• Over 11+years of experience in the Information Technology field with extensive experience in Database development, RDBMS based application, Requirement gathering and analysis, Unit Testing and monitoring, Documentation and technical support.
• Oracle certified professional ( OCP ), Oracle Certified Associate ( OCA ), Brain bench oracle forms certified.
• Experience in development of complex queries, stored procedures, functions, packages etc using PL / SQL for data processing and reporting
• Expertise in Query performance tuning, optimization and database cleanup activities.
• Multiple project experience involving Implementation, Upgrade, Customizations, Conversions,
• Re - implementation, Support, Solutions on Oracle ERP
• Programming and applications development experience using Oracle 8i/9i/10g/11g, Forms6i/10g, Reports6i/10g, and PL/SQL, XML Publisher and Oracle Workflow.
• Expertise in developing applications using Oracle (PL/SQL, SQL) and D2k (Forms, Reports).
• Experienced user of PL/SQL for development of server-end program units as well as reusable codes using Procedures and functions.
• Experience with interpreting the validations on the front end screens and transforming those validations into stored procedures.
• Experienced in dynamic SQL, PL/SQL Collections, Exception handling and tuning.
• Experienced in writing SQL queries creating different kinds of reports from large scale database.
• Experienced in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Experience in developing R.I.C.E (Reports, Interfaces, Conversions, Extensions) components across Financials and SCM Modules.
• Good Technical Knowledge of Financials and supply chain modules on Oracle applications.
• Exposure with roles and responsibilities of Team / Module Leading, Onsite-Offshore Coordination, Development and Customization, Excellent knowledge of software quality processes and documentation.
• Exposoure in providing end user training.
• Setup and maintain documentation and standards
• Hands on experience in preparing MD50,MD70,CV40,CV60,TE40,TE50 and MD120.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i/8i

Languages: SQL, PL/SQL, UNIX Shell Programming

Tools: /IDEs: Kintana, WinSCP, ClearCase, PVCS, Toad, SQL DeveloperPutty, HP Quality Center:

Oracle ERP Version: R12 (12.1.3, 12.0.4, 12.0.6), 11i (11.5.10)

Oracle Tools / Components: ETL, Oracle Developer 6i/10g (Forms 6i/10gand Reports 6i/10g), Oracle Workflow, Oracle XML Publisher, SQL *Plus,SQL *Loader, WEB ADI

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr. Oracle PL/SQL Developer

• Involved in Technical Designs preparation, Development and Testing on finance and supply chain modules.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design and custom components on ETL.
• Design and developed the scripts to create table, views, indexes, sequences and other database objects.
• Involved in development of Transformation load packages which are used on ETL process.
• Involved in design of oracle DDL database objects and analyzing of DML statements for database design.
• Involved in architecture design for implementing the interfaces for Oracle E-business suite R12.
• Developed complex database objects like Packages, Procedures, Functions, and Triggers etc on custom requirements
• Developed dynamic packages using of DBMS packages and DBMS SQL packages.
• Involved in design, development of Oracle interfaces, conversions objects.
• Developed materialized views for data replication in distributed environments.
• Worked on Performance Tuning for Oracle RDBMS.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Design and developed new custom oracle forms some of them are custom oracle batch reservations form where oracle reservations and move order generations are handled and call to custom forms and reports are available from a single form itself.
• Design, developed and customized oracle reports/Bi reports like batch pick ticket, Receipt traveler report, shipping instructions report etc.
• Developed multiple interfaces and conversions on finance and supply chain modules, some of them are PO Mass close, Approved Supplier List, purchase order creation etc.
• Worked on Form Customizations and Form Personalization.
• Responsible to analyze change request impacts and to provide feasible solution.
• Managed the Data Migration activities for WMS modules, custom components consists of Custom forms, Custom oracle reports, packages, procedures, functions etc.
• Involved in data migration from 11i to R12.
• Involved in 11i to R12 upgrade process.
• Involved in tuning the queries for faster and better performance of the SQL queries.
• Analyzed the impact of upgraded components from 11i to R12 and make necessary changes to the CEMILI objects.
• Resolve problems and issues which arise post Go-Live.
• Developed SQL queries which are used by OBIEE team and Data warehouse teams.
• Developed the PL/SQL queries to share the system information with the high level management of the client for analysis purpose.
• Responsible for performance tuning of queries.
• Developing Technical documents & Unit test Documents.
• Responsible for preparing of end user training documents.
• Involved in post production support .
• Involved in support during various testing phases of the project as Unit Testing, Functionality Testing, System Integration Testing and regression testing. Supporting in Go-Live activities in various releases of the PPG engagement.
• Involved in development and improvement of standard methods for data migration.
• Responsible to maintain the project matrix for the quality analysis.
• Managed Oracle support service requests and provide required data/follow-up for faster issue resolution.
• Mentor project team members.
• Document weekly SLA monitoring reports and support activity reports.
• As a member of Design review team, performed code review and design review activities.

Environment: and Tools: Oracle (11g, 10g, 9i), Oracle Applications 12.1.3, 11i, PL/SQL, Oracle Form 10g, Oracle Reports 10g SQL Developer, Oracle Workflow, XML Publisher Reports, WEB ADI, MSCA, WinSCP, Putty, Unix, TOAD, SQL Developer.

Confidential

Sr. Oracle PL/SQL Developer

• Leading the team by giving technical guidance.
• Preparation of High level and low level design document for the project.
• Lead offshore development team, prioritize and assign deliverables to team members. Involved in upgrading of 11.5.10 objects To R12.1.3
• Provided estimates on RICEW/CEMLIs for upgrade on database side.
• Developed Oracle PL/SQL scripts to perform data extraction, manipulation and loading of CSV, and flat-files.
• Developed materialized views for data replication in distributed environments.
• Developed Laser Check Printing solution in eText format in R12 by Customized the standard payment formats while upgrading to R12 from 11i .
• Involved in development of new RICE components for the 11i obsolete components which cannot be used in R12.
• Development of PL/SQL Queries and other database objects like, Packages, functions, procedure etc .
• Involved in customizing of PO Approval workflow when migrated from 11i to R12.
• Responsible for Identify non upgradable components and provide alternate solutions.
• Responsible for analyzing of impact of upgraded components and make necessary changes to the CEMILI objects
• Involved in studying the impact of Upgrade on Custom objects and performing necessary changes.
• Designed and developed custom components on P2P, O2C modules
• Developed an extension object to move the data from the 11i system to R12 on ad-hoc basis
• Developing Technical documents (MD 70)& Unit test results (UTR) Documents.
• Suggest the process changes and templates required to meet the CMMI level2 standards.
• Responsible for technical design reviews and assist process team members in unit testing and integration testing activities
• Involved in identifying the queries which are taking long execution time and provide solutions to tune queries.
• Execution of test scripts during integration testing.
• Code review of developed components.
• Provided scripts to deployment team, verifying the implementation in the UAT environment.
• Preparation of Weekly status documents and attending review calls along with coordination with Onsite team.
• Managed the Data Migration activities.
• Hands-off experience using Kintana software for migrating DB objects, AOL objects between ERP instances
• Create deployment scripts/patches and verify correctness of RICEW/CEMLI migrations
• Responsible for critical Oracle SR monitoring and follow up activity.
• Worked closely with Users and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.
• Accountable for deliverables - provide status reports of work completed, active, planned, and obstacles

Environment: and Tools: Oracle (11g, 10g, 9i), Oracle Applications 12.1.3, 11i, PL/SQL, Oracle Form, SQL Developer, Oracle Workflow, Oracle Reports, XML Publisher Reports, WINSCP, UNIX and TOAD.

Confidential, Houston, TX

Sr. Oracle PL/SQL Developer

• Analysis and design of project requirements.
• Was a part of an development team dealing with daily build activities and analyzing the new requirements and change requests.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Worked on database links and also worked on tables, various types of views like inline and materialized views in different databases by linking the databases.
• Worked on Performance Tuning for Oracle RDBMS.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Involved in the development of RICE components.
• Designed and Developed the Custom Oracle Form for various schemes and offers provided by the client to its end-customer.
• Development/customized of Oracle packages, procedures, functions, triggers’ etc for customization activities
• Developed employee Inbound interface: Inbound interface to move data from external Employee central system to oracle Ebiz.
• Developed Custom Program to Import Price Lists and Price List Lines etc.
• Worked on Various AOL related activities.
• Bug Fixing, supporting the customer
• Preparing of technical design documents
• Performing Unit Testing on the developed components
• Prepared the required Unit and Integration test scenarios to the key business users as part of UAT deliverables in the project.
• LDT preparation & migration activities
• Coordinating with Onsite team for Understanding of requirements
• Preparation of Weekly status documents and attending review calls along with coordination with Onsite team.

Environment: and Tools: Oracle (11g, 10g, 9i), Oracle Applications 12.1.3, 11i, PL/SQL, Oracle Form, SQL Developer, Oracle Workflow, Oracle Reports, XML Publisher Reports, WINSCP, UNIX and TOAD.

Confidential

Sr. Oracle PL/SQL Developer

• Developed database programs, structures, forms and reports using Oracle SQL 10g, Oracle PL/SQL10g, Oracle Forms 10g, Oracle Reports 11g, Toad and SQLPlus.
• Created automated programs using Active Batch, Unix Shell, Oracle PL/SQL 10g, Toad and SQLPlus.
• Implemented complex SQL queries on the database along with Stored Procedures, triggers andPL/SQL code blocks Used PL/SQL and SQL*Plus programming to write stored procedures, queries, triggers, objects, and views on normalized database tables.
• Developed validation program for interfaces programs.
• Generated PL/SQL and shell scripts for scheduling periodic load processes
• Developed enhancements using Form Personalization and Form Customizations
• Developed and designed various custom forms to meet client needs, one such example is the common error handling form for the Interfaces where user can view the error’s encountered during interfaces.
• Developed RTF Templates, Data Template Definitions, Data Definitions for various custom reports using BI Publisher.
• Developed custom program to validate and import Open Invoices into Oracle Payables.
• Worked on SQL query tuning, stored procedure optimization, error logging and debugging activities.
• Responded to user queries and clarification on client central application. Worked on oracle Business events for integration with SOA.
• Developed multiple interfaces and conversions.
• Developed several database objects (Views, Procedures, Functions, Triggers, Tables, Synonyms and Packages), Shell scripts and SQL Loaded Control files as components of technical solution.
• Designed and developed custom components on P2P, O2C modules
• Resolve problems and issues which arise.
• Preparing MD070, CV060,CV040,TE50,UTR documents.
• Preparing of end user training documents.
• Support during various testing phases of the project as Unit Testing, Functionality Testing, System Integration Testing and regression testing. Supporting in Go-Live activities in various releases of the PPG engagement.
• Developed the PL/SQL query to provide the data to the Oracle Finance Team and Supply Chain Team for analysis purpose
• Interaction with Level III support teams (CEMLI) wherever required, and including liaison with Confidential via Metal ink for troubleshooting issues related to Oracle Applications.

Environment: and Tools: Oracle (10g, 9i), Oracle Applications 12.1.3, 11i, PL/SQL, Oracle Form, SQL Developer, Oracle Workflow, Oracle Reports, XML Publisher Reports, WINSCP, UNIX and TOAD.

Confidential

Sr. Oracle PL/SQL Developer

• Involved in providing post production support.
• Developed packages, procedures, function to implement business requirements.
• Legacy system (GIL (Generic interface layer) monitoring for Inbound files and resolving the issue that occur.
• Designed and Developed the Conversions on P2P, O2C. It includes Supplier, Supplier Bank, PO, Customer Conversion and Item Conversion Legacy system conversion activities
• AOL module related activities
• Monitoring daily inbound files and resolve any issues as when they occur in production.
• Order Interface: Inbound interface used to get order creation, update information from legacy system to oracle Ebiz.
• Worked on resolving performance issues with custom reports.
• Development/customized of Oracle packages, procedures, functions, triggers’ etc. for migration & customization activities
• Developed packages and programs for archiving and purging data.
• Bug Fixing, supporting the customer issues raised.
• Interaction with client-Solving SR’s.
• Coding, Unit Testing and peer reviewing according to technical specification
• Managed the Data Migration activity.

Environment: and Tools: Oracle (10g, 9i), Oracle Applications 12.1.3, 11i, PL/SQL, AUTOSYS, Oracle Form, SQL Developer, Oracle Workflow, Oracle Reports, XML Publisher Reports, WINSCP, GIL System, UNIX and TOAD.

Confidential, Atlanta, Georgia

Oracle financial integration

• Performed the requirement analysis, estimation, design review and code review
• Involved in migration of legacy data in to oracle ERP, some of them are customer import, price list import etc.
• Developed PL/SQL Packages, Shell scripts and SQL Loader Control files for various conversions projects
• Involved in Interface development for archiving of data from legacy system.
• Involved in loading data from flat files into database tables using SQL* Loader
• Legacy system conversion activities
• AOL Module related activities
• Preparation od SQL scripts to be used for loaded data validation.
• Forms Customization activities.
• Developed some reusable components which organization is using across modules.
• Development of a data conversion program using SQL*Loader
• Deliverables review on the custom components developed.
• Involved in technical design, unit test documentation preparation
• SQL Authentication. Rebuilding indexes on various tables. Preparing Test Cases and performing Unit Testing.
• Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
• Involved in data migration activities

Environment: and Tools: Oracle (10g, 9i), Oracle Applications 11.5.10, SQL, PL/SQL, Oracle Form, SQL Developer, Oracle Workflow, Oracle Reports, XML Publisher Reports, PL/SQL, WINSCP, UNIX and TOAD

Confidential

Oracle Technical Consultant

• Team Leader coordinator
• Responsible for understanding the GAPS, user legacy system and to identify the potential scope.
• Developed custom forms and reports to meet the client requirement
• Developed packages, functions, procedures and PL/SQL scripts as per the client functional requirement.
• Involved in END to END testing of components
• Gap analysis, requirement analysis
• Involved in impact analysis of change requests
• Development of new oracle packages
• Evaluate user test cases/scripts and perform unit, integration testing
• Bug Fixing, supporting the customer

Environment: and Tools: PREMIA Oracle ERP, Oracle Form, SQL Developer, Oracle Reports, Reports, PL/SQL, WINSCP, UNIX,TOAD

Confidential

Health Insurance implementation

• Coding, Unit Testing and peer reviewing according to technical specification
• PCS, PS, SRS Preparation
• Screen’s development using Forms 6i.
• Developing of new reports, forms.
• Gap analysis, requirement analysis
• Guiding other team-mates in the Reports Analysis and Development
• Written procedures, Packages and Trigger with PL/SQL
• Design and Development of user interface using Oracle Forms
• Database design and creation of tables, stored procedures, triggers and sequences.
• Developing PL/SQL blocks for the validation of forms.
• Developing reports as per user requirements.
• Bug Fixing, supporting the customer

Environment: and Tools: SQL, PL/SQL, PREMIA Oracle ERP, Oracle Form, SQL Developer, Oracle Reports, Reports, WINSCP, Unix, TOAD

Confidential

Oracle Technical Consultant

• Developed custom forms and reports to meet the client requirement
• Developed formula master logic which is unique in nature to and increased business revenues for fidelity to a great extent.
• Developed numerous custom objects as per client requirement
• Developed packages, functions, procedures and PL/SQL scripts to meet the client requirements
• Responsible for Analysis of the specifications provided by the client.
• Involved in design and development, testing and implementation of Oracle Forms and Reports.
• Responsible for coding /Changing numerous packages, procedures, functions.
• Testing - unit testing, integration testing and acceptance testing.
• Generation of Migration documents, Technical documents.
• Involved in End user training Confidential client side.
• Provide end user support for application development.
• Preparation of system user manual and imparting training to end users.

Environment: and Tools: SQL, PL/SQL, FINS Oracle ERP, Oracle Form, SQL Developer, Oracle Reports, Reports, WINSCP, UNIX