SUMMARY

• Having 10+ Yrs. of extensive experience in Oracle Applications as a Techno Functional expert and currently working as Oracle Applications Senior Developer for various assignments and performed Business Analysis, configuring, customizing and implementing Oracle Applications across various industries.
• Having seven full life cycle implementation, upgradation and support experience in Oracle Applications R12/11i modules like Order Management (OM), Shipping (WSH), Purchasing (PO), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Service Contracts (OKS), Accounts Payables (AP), Planning, Quality (QA) Modules and having good knowledge on Oracle Trading Community Architecture (TCA).
• Extensive experience in developing RICE components (Reports, Interfaces, API’s, Conversions & Extensions) in Oracle Applications E - Business suite 11i and R12.
• Well versed with AOL/Sys Admin Tasks such as Creation of request groups, menus, Registration of concurrent programs, Descriptive Flex Fields, Value sets & Lookups.
• Proficient in importing data from Legacy systems to Applications using Interfaces and Conversions.
• Proficient in Developing and Customizing Oracle Reports using Report Builder 6i/10g, XML/BI Publisher, Outbound Interfaces, Shell Scripts using UNIX Shell Scripting and Forms in Oracle Applications.
• Proficient in developing Optio Reports.
• Having good knowledge on Procure to Pay and Order to Cash cycles.
• Extensively worked on Reports, Forms, Packages, Database Triggers, PL/SQL Stored Procedures and Functions.
• Expertise knowledge in Database Languages SQL, PL/SQL and SQL * Loader and Database Tools SQL * Plus and TOAD.
• Knowledge of Oracle Metalink functionality/technical support area toad in resolving application problems and solutions
• Expertise knowledge in Performance Tuning by using EXPLAIN PLAN, TKPROF, Hints and indexes to tune SQL queries.
• Having good exposure in client interaction, requirement gathering and AIM Methodology.
• Expertise in Repositories and Code Migration with Star Team/Perforce/PVCS and KINTANA tools
• Worked for the enormous Clients like Oracle Corporation, Confidential, Confidential & Coulters, Confidential Energy/Health Care/Plastics, Confidential & having good domain exposure on Insurance/Health Care industries.
• Experience in analysis, design, build and test of Oracle Application Framework (OAF).
• Designing and Customizing Workflows using Workflow Builder and Workflow Administration.
• Having good Knowledge on AIM Methodology.
• Writing and maintaining Technical Specification document MD70 and Functional Specification document MD50.
• Performed detailed analysis, gathered requirements and specifications in Software Development Life Cycle (SDLC) process and performed unit testing, integration and production install and support

TECHNICAL SKILLS

ERP: Oracle Applications R12 and 11i (AOL and Sys Admin.)

Operating Systems: Windows 7 and Unix

Modules: OM, PO, INV, BOM, WIP, AP, AR, PDH, OKS, WSH

Reporting Tools: Oracle Reports 10g, BI Publisher, workflow, Optio, OAF, Forms Personalization

Languages/Packages: SQL, PL/SQL, shell scripting

Databases: SQL *Loader, SQL Developer and TOAD for Oracle 9i & 10g

Utilities: SQL*Loader, Data Loader

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Senior Developer Oracle Application

Environment: Oracle Apps release R12, Developer 10g and Oracle 10g.

Responsibilities:

• Coordination with Functional Team and Client Key users for Gathering requirements, analyzing, solution design & deliverables.
• Development and Personalization of Purchasing Forms using Oracle Application Framework (OAF)
• Worked on development and upgradation of XML/BI Publisher, Form Personalization, Interfaces, Conversions in Order Management (OM), Purchasing (PO), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Oracle Product Data Hub (PDH) and Service Contracts.
• Worked on UNIX Shell Scripts, OAF, and Workflow Intrusive Customization of Standard PL /SQL Programs.
• Worked on go-live activities/post-production troubleshooting. AOL, OM & SYS Admin Tasks.
• Optimization and simplification of the existing custom objects.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Provide Customer Training as required & Dealt with variety of client issues related to system design as well as to business.
• Development of new enhancements as and when need arises from the business and proficient in Post-production activities.
• Build and maintain repository for deliverables & business development documents

Confidential, BREA, CA

Senior Developer Oracle Applications

Environment: Oracle Apps release R12, Developer 10g and Oracle 10g.

Responsibilities:

• Senior developer for Manufacturing and SCM track enhancements, developments and issues mainly dealing with modules OM, INV, PO, AP, BOM, WIP, Planning and Quality.
• Analyze, Design, Develop, tested several migration projects like Carls Brea Phase I, Indy Phase I, Prague OU, Indy Phase II which involves several components like Conversions, Interfaces, XM/BI Reports, Forms, Workflow and UNIX Shell Scripting.
• Handled the conversion of Optio reports to XML reports includes, Design, develop, testing and delivery of the objects.
• Coordination with Functional Team and Client Key users for gathering requirements, analyzing, solution design & deliverables.
• Worked on development and modification of XML/BI Publisher, Optio Reports, Form Personalization, Interfaces, Conversions, Unix Shell Scripts, Intrusive Customization of Standard PL /SQL Programs, AOL, OM & SYS Admin Tasks.
• Responsible for Analyze, Design, Develop, Unit test the components.
• Did many conversions on PO, OM, Customers, and Vendors which can re-usable across all the projects for data migration.
• Used TKPROF and Explain Plan utilities to analyze poorly performing PL/SQL packages. Modified several program structures to introduce Performance Tuning techniques like Global Temporary Tables, Bulk Processing and Parallel Execution Methods to improve the performance by 90%.
• Developed Outbound Interface in several modules using UTL FILE utility to generate extract and FTP file to different server locations.
• Optimization and simplification of the existing custom objects.
• Provide Customer Training as required & Dealt with variety of client issues related to system design as well as to business.
• Development of new enhancements as and when need arises from the business and proficient in Post-production activities.
• Build and maintain repository for deliverables & business development documents.
• Actively involved in day-to-day support activities for Oracle EBS 11i Finance Multi-Org stream by troubleshooting, providing solutions and communicating with the users through Support tickets.
• Analyze, root cause analysis, Applying fixes, providing solutions for Prod Issues.
• Extensive Experience in OM API's like order creation, order updating and pricing.

Confidential, Sunnyvale, CA

Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 10g.

Responsibilities:

• Collecting Confidential Health Care Business requirement and Leveraging with Oracle Applications
• Worked on different modules like PO, OM, Inv, BOM, AP, AR, Quality & Planning.
• Worked on development and modification of XML/BI Publisher, Optio Reports, Form Personalization, Interfaces, Conversions, Unix Shell Scripts, Intrusive Customization of Standard PL /SQL Programs, AOL, OM & SYS Admin Tasks.
• Worked on Enhancements and bug fixes
• Developed Technical Design Documents as per the Client coding standards & Project Quality plan.
• Developed the code and Completed Unit testing for Interfaces and Reports as per client requirements.
• Created Procedures, Functions, Triggers, Values Sets, Lookups, Descriptive Flex Fields (DFF) and other AOL/database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables. Request Sets.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Development of new enhancements as and when need arises from the business and proficient in Post-production activities.
• Build and maintain repository for deliverables & business development documents.
• Actively involved in day-to-day support activities for Oracle EBS 11i Finance Multi-Org stream by troubleshooting, providing solutions and communicating with the users through Support tickets.
• Analyze, root cause analysis, Applying fixes, providing solutions for Prod Issues.
• Extensive Experience in OM API's like order creation, order updating and pricing.
• Optimization and simplification of the existing custom objects.
• Responsible for Analyze, Design, Develop, Unit test the components.

Confidential, San Diego, CA

Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 9i.

Responsibilities:

• Worked on different modules like PO, AP, AR, OM and INV.
• Worked on Supplier Conversion
• Worked on a custom interface on the Tax information of the sample products which don’t have any revenue.
• Involved in the design of Technical Documents (MD64’s and MD 70’s) preparation.
• Worked on the development and testing of Forms, Conversions, Interfaces and Shell Scripts in the stipulated time frame with a quality output.
• Developed the Reports like PO Print Report and Sales Order Acknowledgement report using XML Publisher.
• Prepared the Unit Test Scripts Document to mention Test Cases and Scenarios for the developed components.
• Developed Barcode Reports.
• Reviewed the Technical Design Documents and Codes prepared by the project team members and taken Confidential Energy process trainings to the team members which are newly joined into the project.
• Initiative in revisiting and optimizing the quality of the components developed.
• Developed some other conversions and interfaces other than the specified and fixed issues at the time of UTA phase.
• Provided post go-live support for developed components as well as for other components.
• Created Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables.
• Writing Unit Test cases and testing after completion of the Object.
• Involved in end to end testing from Quote Creation to Order.
• Customizations, personalization and Extensions on Quoting web pages using Oracle Application Framework as per client requirement.
• Collecting Confidential Energy Business requirement and Leveraging with Oracle Applications.

Confidential, Richmond, VA

Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 9i.

Responsibilities:

• Involved in designing and developing Technical Documents for Interfaces, Forms and Reports.
• Developed the code and Completed Unit testing for Interfaces, Forms and Reports as per client requirements.
• Worked on Modification of Forms, Reports, PL/SQL Programs and Shell Scripts.
• Modifying and testing of the RICE components in the stipulated time frame with a quality output.
• Worked on Enhancements and bug fixes for all Data Controller components.
• Used PL/SQL for validating the data from legacy system to interface tables. Run journal import to load the data into Oracle application tables.
• Frequently interacted with Client for gathering the requirements and arranged client meetings to accomplish the task given.
• Prepared the Documents as per the Client coding standards, Project Quality plan and followed CMMi process.
• Doing Custom Developments and support scripts on business requirements.
• Developed Extensions to custom business flow from Order management, install base to service contracts for raising credit memos and invoices in AR.
• Developed and Customized the Discoverer by using Discoverer tool as per the client requirement.
• Developed and customized the Forms and worked with the Custom.pll for doing modifications to the Standard Forms.
• Coordination with the Associate Consultants for resolving the issues raised by client as per their business requirements.
• Successfully completed the build and Unit testing from the Technical design document prepared by the developers as per client standards
• Involved on designing and developing Technical Documents.
• Reports development of Account Payables, Account Receivables modules based on client requirements.

Confidential, BREA, CA

Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 6i.

Responsibilities:

• Developed and Customized the Interfaces like Price List, Item Import, Order Import and so on as per the client requirement.
• Developed and Customized the Reports in Oracle Applications using Reports 6i.
• Developed and Customized the Discoverer by using Discoverer tool as per the client requirement.
• Developed and customized the Forms and worked with the Custom.pll for doing modifications to the Standard Forms.
• Coordination with the Associate Consultants for resolving the issues raised by client as per their business requirements.
• Reviewed the Technical Design Documents and Codes prepared by the project team members and taken Confidential Energy process trainings to the team members which are newly joined into the project.
• Initiative in revisiting and optimizing the quality of the components developed.
• Developed some other conversions and interfaces other than the specified and fixed issues at the time of UTA phase.
• Provided post go-live support for developed components as well as for other components.
• Created Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables.
• Writing Unit Test cases and testing after completion of the Object.
• Involved in end to end testing from Quote Creation to Order.
• Customizations, personalization and Extensions on Quoting web pages using Oracle Application Framework as per client requirement.
• Collecting Confidential Health Care Business requirement and Leveraging with Oracle Applications.

Confidential, Dallas, TX

Associate Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 6i.

Responsibilities:

• Involved on designing and developing Technical Documents.
• Reports development of Account Payables, Account Receivables modules based on client requirements.
• Worked on AP and AR Modules.
• Delivered all the Reports within the expected time lines.
• Successfully completed the build and Unit testing from the Technical design document prepared by the developers as per client standards.
• Developed and Customized the Interfaces like Price List, Item Import, Order Import and so on as per the client requirement.
• Developed and Customized the Reports in Oracle Applications using Reports 6i.
• Developed and Customized the Discoverer by using Discoverer tool as per the client requirement.
• Developed and customized the Forms and worked with the Custom.pll for doing modifications to the Standard Forms.
• Coordination with the Associate Consultants for resolving the issues raised by client as per their business requirements.
• Reviewed the Technical Design Documents and Codes prepared by the project team members and taken Confidential Energy process trainings to the team members which are newly joined into the project.
• Initiative in revisiting and optimizing the quality of the components developed.
• Developed some other conversions and interfaces other than the specified and fixed issues at the time of UTA phase.