SUMMARY

• Over 9 Years of analysis, design and development experience in the IT industry in various modules of Oracle E-Business Suite Applications.
• Strong technical knowledge of Oracle Applications Ver. 11i10, 11.5.5, 11.0.3 Distribution, Financial, Manufacturing Modules.
• Extensively worked in RICE Reports, Interfaces, Customization, and Enhancements
• Strong experience in Oracle Development - APIs, PL/SQL, Packages, Triggers, Procedures, Custom.pll.
• Experienced in Customization of Forms, data conversions and writing validations before transferring data from temporary table to interface tables.
• Prepared technical design documents for customizations and conversions using AIM documentation methodology.
• Have Experience in order to cash and procure to pay.
• Excellent understanding of SDLC methodologies as well as quality assurance techniques.
• Equally effective in working independently as well as a Team Player with strong problem solving capabilities and effective interpersonal and communication skills.

TECHNICAL SKILLS

WORK EXPERIENCE

Confidential

Sr. Oracle Apps Consultant

• Schlumberger/Smith International are leading worldwide suppliers of premium drilling products and services to the oil and gas industry.
• Data Conversion/Extraction for Item/Revision/Categories/Item Cost/OH/SO/PO/BOM/WIP/Work Orders for across the globle. Currently Involve in Omni Seals and Romania Data Extraction/Conversion.
• Prepared Dyna Drill Invoice using RDF and XML Builder for newly implemented Entity.
• Develop form for pathfinder to support Asset Capitalization.
• Used form Personalization to restrict some PO match for Dyna Drill
• Developed Smith Bits Commission report.
• Cordination with offshore team.
• Developed AR and AP intercompany report in Oracle and Output generated in e bound file.
• Modified most of the package/function/Triggers/Reports as a part of ORG-SPLIT projects.
• Going forward need to support PIVOTS

Confidential

Sr. Oracle Apps Developer and Analyst

• Providing production support on OM and B2B - monitoring day-today processes, ensuring timely fix of the production problems encountered, data fixes, facilitates in execution of the Month/Quarter/Year End batch processes troubleshoot the issues for the business users and business analyst.
• Enhance current B2B interface to work with PTO model for configurable product structure
• Modify key order data logic, such as Shipment Priority, Payment Terms and Shipping Method etc.
• Create predefined PO number which contains SO number when PO is created through 3B2 programs 294 SO Number F 1 .
• Create new directory structure on Oracle and equinox servers
• Modify programs to support the current Open Orders which has the old line number by using cut-off date
• Supporting the system components during system testing, integration testing and during promotion of these components to production environment.
• Integration between OM and B2B using below process

• 3A4 Outbound Interface
• 3A7 Inbound Interface
• 3A8 Outbound Interface
• 3B2 Inbound Interface

Confidential

Sr. Oracle Apps Developer and Analyst

Key Contributions

• Based upon MD50, developed MD070 and reviewed same with the SME.
• Developed/Modified Inbound and Outbound components for Dual and Final State to facilitate data movement from FMW to ERP and vice versa for below processes
• EDI850 Inbound Orders
• EDI855 Outbound VMI Suggested PO
• EDI860 Inbound Purchase Order Changes
• EDI855 Outbound Order Status
• EDI865/870 Outbound Shipment Status PO change
• Involved in UT/SIT/UAT and Performance testing
• Handshake between ERP and Oracle Fusion FMW .
• Acted as liaison between third party vendors and other teams

Confidential

Sr. Oracle Apps Developer and Analyst

Responsibilities

• Worked with business to determine archival needs, proposing solution and finally testing different Purge Programs.
• Developed Concurrent Programs to create Archive responsibilities and assign to the users in Reporting instance during daily refresh activity.
• Cleaned up around 144 Millions Inventory Orphan records which build up due to older version in Inventory and Costing Module.
• As per the solution given by HP, fixed all the objects which failed due to 5.1 upgrade in OM, MFG, INV, PO and Custom Trigger.
• Customized standard Value Set OE SRS ORDER NUMBER in OM to resolve ROW ID issue in Reporting Instance
• Fixed Order/Invoice Summary Report, Sales Order Acknowledgment, Shipments Report, Shipment Summary Report, Shipping Action Report to overcome ROWID and Value Set Issue for Archive Data in Reporting Instance
• Customized Custom.pll to restrict Trade Restricted User to view ECO's in reporting instance LPRPT .
• Prepared Unit Test Cases and Unit Test Results document.

Confidential

Responsibilities

• Involved in module, Integration and Sanity testing in multiple instance before and after each phase. Executed Test scripts and captured the results of Inventory, Mfg NSO, Mfg Sys, Order Entry, OSM and purchasing module.
• Part of Load Testing Pre Post for 500 Users, 750 Users and 1000 Users through concurrent programs.
• Defects are captured in HP QC tool and resolved issues which are noticed during UAT.
• Developed interface program of shipment process which takes the order from OM to Install Base tables.
• Involved in handling several APIs in service contracts such as using different packages of service contracts OKS .
• Involved in Forms and workflow customization for Aborting the Task workflow process for Create service request form in CRM- Field Service Module.
• Created test plans and Test cases.
• Executing test scripts
• Tested Different Kinds of Holds in Order Management during Book, Pick, Release and shipping Status.
• Inbound and Outbound Interface Testing
• 2 weeks post GO-LIVE Support.

Confidential

Responsibilities

• Project plan review with Client.
• Involved in weekly status meeting.
• Coordinating with offshore team to achieve the project plan timelines.
• Prepare MD070 Technical document based on MD050 Functional .
• Generate Flat file from Temp. SO and used that files to create BOM and Routing using Oracle API
• Involved in UAT and the process of getting all the required approval to migrate the objects in production.
• Coordinating with Oracle Security and Pipeline group for object migration during migration window.
• Go-Live Communication to all the Project Team and relevant team.
• 2 weeks post GO-LIVE Support.