SUMMARY

• Over 10 years of experience in the Oracle Applications as a Financials Techno Functional Consultant.
• Extensive experience in Design, Development, Testing, Implementation and support of Oracle Applications 11i and R12 Versions.
• Having 10 years of extensive Oracle experience in Oracle Applications and full life cycles Implementation of Oracle E - Business Suite. Hands on experience in Oracle ERP Applications - Accounts Receivables, SLA, iReceivables, General Ledger, Inventory, Order Management, Accounts Payables & HRMS.
• Experience in Requirements Gathering, Analysis, Solutioning, Design, Documentation, conducting CRP Sessions (Conference Room Pilot Sessions), Business discussions, Onsite-Offshore coordination, Testing, Cut-over support.
• Conducted workshops to identify business gaps and converted in to business requirements and participated in user trainings.
• Very strong in Solutioning custom functionalities to meet business requirements by extending or modifying Oracle Applications with Oracle's recommended standards
• Experience includes execution of Oracle Applications implementations including the exposure to e-Business suite R12, numerous Application Support projects with high level of Customer Satisfaction.
• Effectively involved in EBS R12 Implementation, Gap Analysis and Production Support Projects.
• Handled team & lead various testing cycles like System Integration Testing, Customer Acceptance Testing & Conversion Rehearsal Testing.
• Good knowledge in converting business requirements into design requirements and preparing key design documents & Proof of Concepts for client demos.
• Expert in Customization of OAF, Workflows, Developing Oracle Reports, XML Publisher Reports, Interfaces, Conversions, SQL * Loader scripts and shell scripting.
• Strong in developing interfaces based on Service-Oriented Architecture (SOA) using Oracle JDeveloper, Business Process Execution Language (BPEL), Enterprise Service Bus (ESB) and Java Programming.
• Hands on experience in writing JAVA programs to integrate Oracle with third party tools like Red Carpet using web services.
• Experience in writing technical reference guides, user manuals and other technical related documentation according to Application Implementation Methodology (AIM).
• Strong interpersonal, analytical, and communication skills, proven ability as an efficient team member in System Analysis, Design, Development, Migrating and documentation.
• Result oriented, organized with good Presentation skills.
• Excellent learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS

ERP Releases: Oracle Applications 11i, 12.1.1 and 12.1.3

ERP Modules: Oracle Applications 11i, Rel12, Financials (AP, AR, FA, GL), PO, OM, iProcurement, Customers, HRMS (Core HR, OAB, Payroll, Irecruitment, SSHR, AME, OLM), Oracle Application Object Library

DBMS: Oracle 9i,10g,11g

Technologies: SQL,PL/SQL, Application Object Library (AOL/FND), Oracle Workflow, AME, XML Publisher, OAF Personalization’s, Extensions, XML Gateway, Oracle D2k Reports, Oracle SOA Suite 11g, Web ADI, PVCS, BPEL, ESB, BI Publisher, Conversions, Java Programming

Tools: TOAD, PL/SQL Developer, Workflow Builder, JDeveloper, Microsoft Workflow Builder 2.5, 2.6,Project, Clearcase, Source Safe, Kintana, Microsoft Projects, Microsoft Office

Operating System: UNIX, Sun Solaris 2.5, Dos5.0, Windows 3.1/95 and NT & HardwareSun Enterprise Server, RS6000, Dec Alpha, Sun Spark Station, Unix

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle Applications Engineer

Responsibilities:

• Responsible for developing the java program for calling web services to integrate the Oracle Apps with the third party systems like Red Carpet.
• Configure SLA custom sources & custom rules to address and support ad-hoc business requirements.
• Configured Payment Methods, advanced withholding tax in Accounts Payable.
• Configured Cross validation Accounting Rules as part of Oracle GL Configuration.
• Provide Solutions for custom functionalities to meet business requirements by extending or modifying Oracle Applications with Oracle's recommended standards.
• Worked on Transaction DFFs setup, configurations & HR Assignment DFF Setups etc.
• Configured AME to meet Complex Approvals Hierarchy requirements.
• Customizing the AP Invoice Approval Workflow (APINVAPR) to fix issues in the existing Approval Chain.
• Responsible for customizing POAPPRV Workflow to add requisition details to the existing seeded PO Approval notification.
• Designed and Developed Financial Conversions comprising GL Journals, AP Open Invoices and AR Invoices in the context of merging 2 production instances of HR and Finance into one instance.
• Customized OAF pages in iRecievables.
• Developed XML Publisher Reports out of PO using XMLP Bursting that allowed the report output to be emailed to multiple recipients basing on specific data in specific fields of the report.
• Developed complex XML Publisher Reports that shows the trail of requisitions created in Oracle Purchasing to the corresponding AP Invoices in Oracle AP.
• Supporting the existing system by fixing the issues in AP, Purchasing, SSHR, Core HR, etc.
• Responsible for customization of OAF pages of iRecruitment.
• Responsible for building the FSA Wage works Interface.
• Customized the Job title field on the vacancy creation page to show only those jobs which are of lower grade than that of the person trying to create the vacancy.
• Customized the vacancy search page to show the customized regions showing equity, bonus, and salary so that when the user clicks on any vacancy, the above three customized regions show up.
• Customized the approval flows that a vacancy has to go through before it gets created. If the vacancy is created using Manager Self-service, one set of approval chain needs to be followed and if it is created using recruiter responsibility, another set of approval chain needs to be followed.
• Customization of HRSSA Workflow to implement time outs for vacancy creation.
• Daily Status reporting to the manager on day to day activities.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, Billerica, MA

Oracle Applications Architect

Responsibilities:

• Lead a group of consultants for successful implementation of OM Project.
• Was the main POC (Point of Contact) for the technical team and the business/functional team.
• Conducted several CRPs for the users/functional team to evaluate the implemented project.
• Responsible for interacting with the concerned parties involved in the interface to understand the as-is situation.
• Responsible for designing the to-be solution taking into account the as-is and any enhancements/modifications mentioned in the discovery sessions.
• Organizing meetings to get the approval of to-be solution.
• Responsible for breaking up the project into several sub tasks and estimating them and incorporating the same into project plan.
• Responsible for developing Interfaces for Order import using XML Gateway, Workflow and Business Events.
• Responsible for mentoring the team and bringing them up to the speed.
• Enhancing the AR Aging Report to display output in an excel format using XML Publisher.
• Implemented UCM - Universal Customer Master solution
• Designed & developed Party, Customer &Contacts Outbound Interfaces which is input to fusion.
• Did OAF personalizations in iReceivables.
• Designed & developed BPEL process for Customer Inbound Interface.
• Developed BPEL process for Customer Contacts Outbound Interface.
• Developed scripts to subscribe SOA programs from procedures
• Developed a XMLP Report that brings the requisition, its corresponding PO and its corresponding AP Invoices to know the trail of requisition.
• The above report contains different sections like header and detail and also brings in the corresponding budget details for the quarter to which the report would be run.
• The different sections are coded with different colors so that the output has different colors for different sections for easy readability.
• Co-ordinate with the client to get all the required information to resolve the outstanding issues.
• Experience of working with the client.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, New York City, NY

Oracle Applications Consultant

Responsibilities:

• Configured the Dunning Letter Setups including creation of Dunning Letter Set, created customer profile class and attached the dunning letter set to that class
• Developed custom program to implement Dunning letter customization to include the different business streams at the transaction type level and for different levels in the dunning letter set.
• Configured Payment terms in Oracle Accounts Receivable.
• Responsible for developing outbound interfaces like PO Outbound interface using BPEL and Business Events.
• When a PO gets approved, a business event gets fired to which a BPEL process gets subscribed, picks up the data, does the transformations and sends it to the third party systems.
• Worked in developing the XML Publisher Report layouts for the output coming from an interface using the eText-Outbound as the output layout for the template being designed in XML Publisher.
• Enhanced the functionality of iReceivables using oaf customizations.
• The above report is used for EFT and the report output is pdp encrypted.
• Developed AR Invoice interface to import invoices from the legacy system that has some specific requirements for tax code.
• Developed/customized the seeded oracle reports to get the output to Excel format.
• Co-ordinate with the client to get all the required information to resolve the outstanding issues.
• Experience of working with the client.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, North Canton,OH

Oracle Applications Consultant

Responsibilities:

• Responsible for customization of self-service pages of iProcurement like validating the need by date field on one of the checkout pages, etc.
• Responsible for personalizing the self-service pages using OAF.
• Responsible for developing XML Publisher Report that displays barcode on the report output.
• Responsible for developing BI Publisher Report for Dunning Letter Customization in Oracle AR.
• Developed the workflow customization for approval mechanism in self service functions using Approvals Management Engine (AME).
• Developed two programs to send mails to employee and the HR Partner respectively containing the information about the benefits employee enrolled to and the statistics of number of employees enrolled under a HR Partner using PL/SQL and HTML.
• Customized the seeded approval notification to the manager when the employee submits the time card using Workflow, PL/SQL and HTML.
• Co-ordinate with the client to get all the required information to resolve the outstanding issues.
• Sending the weekly status reports to the Project Lead.
• Experience of working with the client.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, San Jose, CA

Oracle Applications Consultant

Responsibilities:

• Responsible for customizing the iRecruitment pages using OAF.
• Responsible for analyzing the forth coming requirements and giving approximate technical estimates for those.
• Developed OAF components like displaying the multi select list boxes, rows to columns, etc.
• Mentoring/guiding the team members and helping them to complete and deliver their objects.
• Co-ordinate with the client to get all the required information to resolve the outstanding issues.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential

Oracle Applications Consultant

Responsibilities:

• As a Team Lead, Responsible for delivering the reports in Oracle Core HR using audit tables to capture the changes that occurred between the given dates.
• HR Interfaces Development using ESB and BPEL.
• Resolving the issues and updating the client.
• Sending the Project Status Report on a weekly basis to the client.
• Co-ordinate with the client to get all the required information to resolve the issues.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, Schaumburg, IL

Oracle Applications Consultant

Responsibilities:

• Customized the Sales Order Header and Lines Workflow to send the sales order data to the third party.
• Developed Action History in a custom notification in exactly the same way as it will be in a seeded notification.
• Designing the best possible solution while minimizing the complexity.
• Guiding/helping the team members in their objects to successful completion.
• Raising and escalating the issues in a timely manner so that the issues are driven to a close.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, Lombard, IL

Oracle Applications Consultant

Responsibilities:

• Leading a team of 3 members for HRMS Customizations in workflows.
• Designing the best possible solution while maintaining synchronism across the requirements.
• This is instrumental as developing a set of requirements can significantly effect the other sets of requirements.
• Coordinating within the team to develop the code.
• This is very important as the customization needs to be implemented in one workflow file which means the code need to be developed synchronously.
• In addition to the above, I am responsible for the design and coding for my own set of requirements.
• I have implemented complex requirements of timeout in workflow in coordination with Oracle AME.
• Guiding/helping the team members in their objects to successful completion.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, Sunnyvale, CA

Oracle Applications Consultant

Responsibilities:

• Core Team member of the Implementation Team
• Coding-Important team member in developing the Customer Contacts Outbound.
• Helping the team members in their objects
• Raising and escalating the issues in a timely manner so that the issues are driven to a close.
• Designing the overall interface structure that involves other systems as well.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, Duluth GA

Oracle Applications Consultant

Responsibilities:

• Core Team member of the Implementation Team
• Coding-Important team member in developing the RICE Components.
• Responsible for Developing Interfaces.
• Mentoring the fellow team members towards the successful delivery of their objects.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, Pittsburgh, PA

Oracle Applications Consultant

Responsibilities:

• Developed Core HR Interface using HR APIs.
• Interfaces Development using ESB and BPEL
• Written a program completely in Java and calling a BPEL process to import the daily exchange rates in GL from 2 banks.
• Used extensively email feature and Java Embedding in the BPEL process that were developed.
• Preparing the Technical and Migration Documents for the Developed Objects.
• Unit Testing.
• Reviewing the code developed by peers.
• Guiding the team members in using JDeveloper to develop the interfaces.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, San Jose, CA

Oracle Applications Consultant

Responsibilities:

• Had customized the HRSSA Workflow notifications.
• Responsible for OAF personalization of iProcurement pages which include creation of new items on the web page and adding LOV to those and migration of personalization across instances using XMLimporter command.
• Preparing the Technical and Migration Documents for the Developed Objects.
• Reviewing the code developed by peers.
• Responsible for retrofitting Interfaces.
• Responsible for migration of all the interface codes using Mercury ITG Tool Kintana.
• As Configuration Manager, responsible for version control and handling the version control tool clear case.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, Southfield, MI

Oracle Applications Consultant

Responsibilities:

• Responsible for all the Workflow related components in this project which include the customization of two seeded HRMS Workflows (HRSSA and OTWF).
• One of the customizations also requires proficiency in Approvals Management (AME) as this functionality is used in the customization of one of the processes in HRSSA Workflow.
• Worked in developing the XML Publisher Report layouts for the output coming from an interface using the eText-Outbound as the output layout for the template being designed in XML Publisher.
• Unit Testing.
• Reviewing the code developed by peers.
• As Configuration Manager, was responsible for proper version control of all the objects and maintenance of version control tool like E-Room.
• Preparing the Technical and Migration Documents for the Developed Objects.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, Los Angeles, CA

Oracle Applications Consultant

Responsibilities:

• Responsible for developing conversions (AP Open Invoices Conversion and PO Conversion)
• Developed Price Protection Report in AR.
• Preparation of Unit Test cases.
• Preparing the Technical and Migration Documents for the Developed Objects.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g

Confidential, Fairfield, CT

Oracle Applications Consultant

Responsibilities:

• Responsible for developing Interfaces (AP Open Invoices and PO)
• Developed the following reports: GEWIP Material Requirements Reports, GEAOL User Details with Responsibilities, GEPO Purchase Detail Report with Requisition & Payables Details.
• Preparation of Unit Test cases.

Environment: Oracle Applications Release 12, UNIX, Oracle 11g