SUMMARY:

• Experienced Senior Oracle Applications Developer, working in ERP for over 15 Years around OTC, PTP and Master Data management modules.
• Good Experience in Procure to Pay and Order to Cash business flows, mainly working in Purchasing, Inventory, Order Management modules. Worked extensively in Master Data management modules like PLM (Oracle Product Lifecycle Management), Supplier and Customer Data Hub.
• Extensively worked on various RICE objects design and development in both Oracle Applications R12 and 11i.
• Proficient with various Reporting techniques and tools including Reports Builder 6i/9i/10g, XML Publisher.
• Experience in developing Workflows using workflow builder and customized some standard Oracle Workflows.
• Experience in developing OAF personalization’s, Customizations.
• Proficient in System Administration activities including developing custom applications, responsibilities, menus and request groups. Registering Concurrent programs and Request Sets. Defining value sets, flex - fields, lookup values, profile options and printers.
• Proficient in SQL and PLSQL Scripting, developing various database objects such as Tables, Views, Indexes, Sequences and/or PLSQL objects like Stored Procedures, Packages, Triggers, etc.,
• Hands on experience in UNIX Shell Scripting. SOA BPEL Processes, REST Web Services. Developed scripts for automation of various concurrent processes, file handling, archiving, etc. and registered them as host concurrent programs.
• Actively involved in handling of many production issues and fixing Bugs, working in close proximity with Oracle Support by logging Service requests, escalations, patch analysis and application.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications R12, 11i Purchasing, Inventory, Order Management, Oracle PIM, Oracle Customer Master Data Hub, Oracle Pricing

Oracle Tools: Reports 10g, Workflow Builder, XML Publisher, Jdeveloper.

Database: Oracle 11g,10g

Development Tools: SQL*Plus, TOAD, PLSQL Developer, SQL*Developer.

Application Utilities: SQL*Loader, TKPROF, UTL FILE, FND LOAD.

Operating System: HP-UNIX, LINUX, WINDOWS.

PROFESSIONAL EXPERIENCE:

Sr. Oracle Apps Developer

Confidential

Responsibilities:

• Understanding the requirements by involving in the meetings, design and development of Interfaces/Conversions and reports.
• Involved in extracting the Supplier data from transaction systems and Designed and Developed conversion programs for converting suppliers to HUB instance.
• Created AME setups for integrating iSupplier with Oracle AME (Approval Management Engine)

Sr. Oracle Apps Developer

Confidential

Responsibilities:

• Understanding the requirements by involving in the meetings, design and development of Interfaces/Conversions and reports.
• Designed and Developed codes for various periodic Inbound interfaces:
• Created various packages, procedures and functions for validating the data and loading into the interface tables. Registered the processes as Concurrent programs and combined and the load, validation and Import script as request sets.
• Created a new custom OAF screen as per business requirement which will allow them to create/update Items/UDA’s/Categories by uploading the data in excel sheet from their desktop. User will prepare the data file in excel format and upload the excel from their desktop from the custom screen. This screen has the capability to stage the data, call the validation/Load program and then present the errors on the screen.
• Created different OAF customizations, Personalization’s for Oracle product management HUB screens
• Worked in creating SOA services for Oracle Customers inquiry, Oracle Items inquiry, Oracle Items Pricing inquiry and Oracle Sales Order Booking.
• Modified Oracle seeded PIM workflows to change the notifications as per Brazil localization requirements.
• Created reports for Order management modules, Oracle costing modules.
• Created Custom WEBADI’s (Desktop Integrator) for the Stock Locators, Cross Reference and approving Item approval notifications in mass.
• Handled different conversions for Project like Item conversions, UDA conversions, Item categories conversion.
• Worked on version control software SVN, migration tool PPM & Defect tracking tool Remedy.
• Worked in collaboration with Oracle Support for resolving various bugs.
• Working on Production tickets to resolve the issues in Production by creating data fix scripts.
• Helping business users to resolve the issues in production.

Environment: Oracle Applications R12, Oracle Database (11g), UNIX, TOAD, Reports, XML Publisher.

Sr. Oracle Apps Developer

Confidential

Responsibilities:

• Understanding the requirements by involving in the meetings, design and development of Interfaces/Conversions and reports.
• Designed and Developed codes for various periodic Inbound interfaces.
• Created conversion programs for Items, Item User Defined attributes, Item Categories, Employees, Purchase Orders.
• Created OAF personalization’s for Oracle PIM module as per the business requirements.
• Worked on various BI Publisher reports like Customer Credit exposure etc.
• Worked in collaboration with Oracle Support for resolving various bugs.
• Worked on version control software SVN, migration tool PPM & Defect tracking tool Remedy.
• Developed PL/SQL packages for getting Customer detail, Item Pricing details and Booking Sales Order.
• Created BPEL processes for above mentioned processes.
• Working on Production tickets to resolve the issues in Production by creating data fix scripts.
• Helping business users to resolve the issues in production.

Environment: Oracle Applications R12, Oracle Database (11g), UNIX, TOAD, Reports, XML Publisher.

Sr. Oracle Apps Developer/Technology Lead

Confidential

Responsibilities:

• Understanding the requirements by involving in the Business meetings, authored Technical Specification, Change analysis and migration documentation.
• Designed and Developed codes for various periodic Inbound and Outbound interfaces including:
• Purchase Order Outbound
• Purchase Order Changes Outbound
• ASN Subscribe from Suppliers
• PO Acknowledgment from Suppliers
• Extensively utilized SQLLOADER, UTL FILE concepts for reading files and loading into oracle database. Created various packages, procedures and functions for validating the data and loading into the interface tables. Registered the processes as Concurrent programs and combined and the load, validation and Import script as request sets.
• Created new workflows for the above mentioned interfaces to handle business requirements.
• Developed custom mail UNIX script and registered as concurrent program which can be used to send notifications with attachments as of when required.
• Supported existing interfaces into 11.5.10.2, by efficiently communicating and reprocessing as of when required. Enhanced interface codes for better debugging and error handling.
• Extensively worked in collaboration with Oracle Support for resolving various bugs.
• Worked on version control software Perforce, migration tool Kintana & Defect tracking HP quality Center.

Environment: Oracle Applications 11i, Oracle Database (11g), UNIX, TOAD, Reports 6i/10g, XML Publisher, Workflow Builder, SYSAID, Perforce, Kintana.

Sr. Oracle Apps Developer

Confidential

Responsibilities:

• Developed various reports in oracle XML publisher and registered them as Concurrent Programs.
• Designed and developed various PLSQL programs and registered them as concurrent programs to fetch the data.
• Involved in designing and developing various reusable packages and procedures, which were utilized by various programs.
• Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Utilized FND LOAD for data migration of various system administration objects, between various instances such as Menus, Custom Responsibilities, Personalization’s, Concurrent Programs, Value Sets, Flex-fields, lookups and others.
• Prepared training documents and conducted sessions with business users, to train them in the newly developed custom extensions of the existing oracle system.
• Extensively worked on Production issues, and resolved various bugs working in collaboration with Oracle Support on Sev1 and Sev2 Service requests.

Environment: Oracle Applications 11i (12.0.6) (PO, INV, OM, BOM, WIP), Oracle Database (11g), SQL*Plus, SQL*Loader, PLSQL Developer, XML Publisher.

Oracle Apps Developer

Confidential

Responsibilities:

• Requirement Gathering and Business analysis document Preparation. With extensive involvement in the Functional design of r12 implementation and conversions of Item Master data and its corresponding entities, Supplier Master Data and Customer Master Data.
• Responsible for converting whole Master data like Items, Suppliers, Customers, Employees etc. from Legacy system to destination system.
• Developed different interfaces for publishing the master data to different downstream systems.
• Developed different interfaces for subscribing to the data being published form publisher.
• Developed various interfaces in Oracle like Items import, Suppliers import, Customers import, Cross reference import, Item Categories Import, Sales Order Import.
• Worked on Purchasing Documents Open Interface to import Purchase orders in to Oracle Purchasing Module. This custom program is to convert the Standard historical Purchase Orders in to Oracle application.
• Developed PL/SQL package to insert customer information using TCA API.
• Worked extensively on Oracle PIM module and was involved in functional setups.
• Created different Oracle XML Publisher reports like Distribution center Inventory report giving the On hand item information and other item master data related information in BI Publisher.
• Created database, table spaces, user schemas, and database administration with maintenance, Created Stored Procedures, Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user’s specifications.
• Worked on customizing the standard functionality of Oracle iSupplier Portal. Created a custom workflow to trigger notifications to business user whenever any changes were done by supplier.
• Worked on creating an interface in OTM to subscribe to Shipments through Direct XML procedure.
• Creating new categories into the system and handled various issues like mass changing of buyer names for existing items, updating item attributes and item revisions, cleaning up of stuck up pending transactions, sub inventory transfer issues, serial number and lot number issues
• Ensured that the programs were properly tuned to comply with the performance requirements.
• Supported the team with Post production issues. Acted as a Maintenance functional support for guiding users understanding the new system and solve daily problems.
• Worked extensively on client Perforce for tracking the changes (Change/ Version Control) and promotion between different instances.
• Acted as a mediator between the business users and developer team for efficient problem understanding and to deliver accurate codes.
• Performed Unit Testing of various objects and performed defect analysis and FIX during the pre-production stage.
• Worked with Oracle Support to identify and solve various R12 Severity 1 issues with 24/7 availability and collaboration.

Environment: Oracle Apps Release R12, 11i (12.0.4) (PO, INV, AOL, PIM), Oracle Database (11g), SQL*Plus, SQL*Loader, TOAD, XML Publisher, UNIX, Mercury Quality Center.