Professional Summary:

• 7 years of IT experience in the field of implementation and maintenance of Oracle Application 11i/R12 suite.
• Oracle Applications Techno-Functional consultant with a good exposure in coding, design and use of Oracle E-Biz Suite Application.
• Good knowledge in Procure to Pay Cycle.
• Expertise in AOL setups
• Have extensively worked on PO and iProcurement modules.
• Have experience in Financial modules like AP ,GL and SLA
• Experience in Integrating Custom and 3rd party solutions with Oracle EBS
• Worked extensively in implementation of Client Customizations, Migrations, Conversions, Enhancements and Self-service applications.
• Strong working experience on RICE components.
• Adept at all stages of project lifecycle, from business requirements and technical interpretation to development, testing, user acceptance testing UAT , production support and completion.
• Currently coordinating the last phase of R12 Implementation from Client Site.
• Result oriented, self-starter and able to work with minimum guidance. An enthusiastic person willing to study and experiment new things.

Technical Skills:

Professional Experience:

Confidential

Responsibilities:

• Testing debugging
• Co-ordinate between different teams from different companies to get the work done.
• Designing the solution and getting Sign off from the business.
• Requirements and Analysis for enhancements: Understanding the requirements of the project and act as a technical and functional resource.
• Creation of Project Plan and mobilizing resources for the project.
• Co-ordinate and provide solution on different needs for the business. Overall Business Analysis.
• Migration of Custom AP Objects Mappings/Customizations from 11i to R12.
• Data collection and kick-off meetings for the specific implementation.
• Production implementation and support.

Iflow

• This solution was designed to replace the mark view systems usage in 11i.
• Integration of Rule based engine. Iflow Custom Solution
• Interchange Solution: Solution to migrate custom setups from one instance to another.

Gateway

• Real time interface development through custom Gateway Solution.
• The existing granular events within the gateway are re-used to create new interfaces.
• Custom Payment Automation along with custom Calendar development
• The Payment solution picks templates based on the custom calendar setup.

Environment: Oracle Applications R12, PL SQL, Custom Java Pages

Confidential

Role: Team Lead

Responsibilities:

• Status Reports
• Mentoring Juniors
• Migration of Custom PO Objects from 11i to R12.
• Co-ordination between Onshore and Offshore and business teams.
• Creation of Project Plan and mobilizing resources for the project.
• Requirements and Analysis for enhancements: Understanding the requirements of the project and act as a technical and functional resource.
• Design Review Presentations
• SSS in 11i, for UNSPSC setup was using version 5.4 of the UNSPSC, for R12, version 14 of the UNSPSC is being used. 45 K UNSPSC to be migrated . Entire Conversion/Migration activity was handled.
• 11i User and Responsibility Migration

ICP Design: new custom R12 solution to setup interface parameters. Works similar to profile options. The value setup is at Global/OU/LE/BLE level.

Production Go-Live Co-ordination

Environment: Oracle Applications R12, PL SQL, SQL Loader, Microsoft Excel

Confidential

Responsibilities:

• Designed a mapping solution to incorporate various customizations done in 11i.
• The mapping is based on certain rule types which has context values set at various levels.
• Account Generator In 11i, there were 100 of custom objects that were called by the workflow which was consolidated into 1 using the mapping design in R12.
• HR Interface is used to load over 3 Lakh employees for the organization. After the first full load, the OHR system sends an incremental 6 days a week to SSS which is getting processed based on the mapping design.

Environment: Oracle Applications R12, PL SQL, SQL Loader, Microsoft Excel, OAF Web Pages, AOL, Reports 10g, XML Publisher, Workflow builder.

Confidential

Client among top 10 companies in fortune 500 list is moving its indirect Sourcing platform from oracle EBS 11i to R12.Application is considered as one of the world's most complex business implementation of EBS on Purchase to pay track.

Responsibilities:

• Inventory collection is being done for standardization and for ease of migration to R12. Involved in below standardizations.
• Worked on creating an inventory for all the Interface components
• Inventory for Account Generator Customizations
• Form Personalization and Custom.PLL Inventory.
• Inventory Item Inbound Interface

Environment: Oracle Applications R12, PL SQL, OAF Web Pages, AOL, Workflow builder

Confidential

Responsibilities:

• Analyzed the patches and reproduced the bugs in dev instances.
• Had taken up the responsibility of locating all the packages from the business specific custom tops.
• After applying the patches, again tried to reproduce the bugs in the patching instances to verify whether they are successfully applied or not.
• Compared the files in production and patching instance using Compare IT tool and done retrofitting to apply the customizations on the patches.
• Other SR analysis :
• Worked on a patch to handle multiple correction transactions for a custom Receipt Inbound interface.
• Worked with Oracle regarding an SR that confirms that PO Total amount is calculated after rounding off the line amounts and adding them together.
• Worked on an SR regarding issue while updating an already existing security rule line. Instead of updating the existing rule line, the API used was inserting values into the base table.
• Worked on SR regarding data fix for cancelled PO's.
• Worked on an SR in R12, to fix the issue in AP Invoice distributions where the distribution would be saved in preview mode and not get reflected on the distribution table.

Environment: Oracle Applications 11i/R12, TOAD and PL/SQL, Metalink

Confidential

Responsibilities:

• Created a form for setting up the mapping for the segments.
• Modified the existing workflow package to include all scenarios required for mapping and worked on enhancing the Notification to add a new region which would give the source of account generation.
• Created a bulk loader interface to satisfy the data model and setup the mapping.
• Involved in requirement gathering, design, coding, testing and documentation
• Single member to handle all the responsibilities and was able to deliver all the assigned tasks on time.
• Effectively communicated with client on all phases

Environment: Oracle Applications 11i, Workflow builder, Oracle 10g, Forms 6i, TOAD, SQL Loader, and PL/SQL.

Confidential

Confidential

SSS Shared Sourcing Services transforms all GE business into an E-Business covering all key components of the buy-to-pay business flow, processing and managing requisitions and receipts till payment. SSS mainly does indirect material procurement.

Responsibilities:

As a Techno-Functional Consultant, involved in the following activities.

• Adhere to the processes followed by GE for entire development life cycle.
• Taking up Work for Hire Projects based on Individual Business Requirement
• Was leading the entire Code review activities at offshore.
• Worked closely with Oracle through metalink on number of SR's.
• Retrofitting of RICE components as a part of RUP applying in our Custom instances.
• Development, enhancement and Testing of Stored Procedures and Functions.
• Enhancement of custom Interfaces and forms
• Worked on Account Generator Enhancement.
• Implementation of custom functionalities to new operating units.
• Writing and enhancement to UNIX Shell scripts, .ctl Files and registering in Oracle apps environment.
• Experience in creating XML Publisher reports and using various templates to publish the reports as per user requirements.
• Registering PL/SQL Stored Procedures, reports in Front End using Concurrent Program
• Resolving Performance issues.
• Writing one time scripts to resolve numerous data corruption issues.
• Development of technical and specification design documents like MD 200's.
• Migration, Conversion, Integration activities related to R12.

Major Projects Taken up during initial years:

1.STAR Interfaces : Confidential

Description: Comprises of PO and Receipt Inbound Interfaces. Makes use of custom form which can be used to Re-transmit the PO/Receipt in case of any error during Validation or standard Open interface programs import.

2. OASIS Outbound Interfaces Confidential

Description: Comprises of PO, PO Close and Receipt Outbound Interfaces. Makes use of custom forms to setup mappings. The outbound data goes to those business legacy systems where Payments are done outside SSS. Inbound interface takes care of any closure in PO's.

Environment: Oracle Applications 11i, Oracle 10g, Reports 6i, Forms 6i, TOAD, SQL Loader, and PL/SQL.