SUMMARY

• Over 8 Years of experience in implementing and maintaining Oracle E - Business Suite R12 and 11.5.X.
• Techno Functional experience in implementing Oracle Applications with exposure to SOA architecture. Expertise in analysis, design, development, enhancements, customizations, migration, interfacing and conversions using Oracle Applications.
• Experience as Oracle SOA integration developer using Oracle SOA suite 11g, J2EE and web services.
• Expertise in Oracle BPEL Process manager in all stages of project life cycle.
• Expertise in Developing, Customizing, Implementation of RICE Components and Production Support of Oracle Financials: GL, AP, iExpenses, PO, iProcurement, AME, FA, OM, INV, Advanced Pricing, AR, CM, AOL and SYSADMIN.
• Expertise in Order to Cash and Procure to Pay in Oracle Applications.
• Designed and Configured Business Processes using BPEL Process Manager, JDeveloper. Designed and Deployed ESB Services onto Oracle SOA Suite 10.1.3.X. Working Knowledge of Business Activity Monitoring (BAM) and Enterprise Messaging Service (EMS).
• Experience with B2B Integrator to create, manage and integrate trading partners using EDI’s.
• Expertise in using File Adapter, FTP Adapter, Database Adapter, AQ Adapter and JMS Adapter for integration using Oracle ESB and for developing custom business processes using Oracle BPEL Process Manager. Coded and Deployed Java Web Services onto Oracle Fusion Middleware.
• Experience in writing Test Cases using AIM standards.
• Expertise in XML Publisher, Workflow Builder and Application Workflow Developer.
• Good knowledge on Oracle AIA Foundation pack and PIP.
• Expertise in development and customization of Reports, Forms, Interfaces and APIs with APPS Standards.
• Expertise in designing Application Implementation Methodology (AIM) documents such as MD 50, MD 70, MD120 and TE20/30.

TECHNICAL SKILLS

ERP Modules: Oracle Applications 11i (11.5.X) E-Business Suite (GL, AP, AR, PO, FA, OM, CM, AOL and System Administrator).

Databases: Oracle 8i/9i/10g, Microsoft Access 2000/XP.

Tools: Toad, SQL developer and SQL* Loader.

GUI: Oracle jdeveloper, Forms 6i, Reports 6i, Oracle Discoverer 4i/10g, XML Publisher, Workflow.

Languages: C, JAVA, SQL, PL/SQL, HTML, XML, Perl and Shell Scripting.

Platforms: Sun Solaris, Linux, HP-UNIX, IBM AIX, Windows NT/2003 Server

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Applications/FMW Consultant

Responsibilities:

• Implementation of Oracle Product Data Hub (PDH) / Product Information Management (PIM) for Nintendo of America.
• Item Conversion with Item Attributes, User-Defined Attributes (UDAs) in PIM, Related Items, Item Categories, Template Assignment, Customer Items and Customer Item Cross References.
• Integration of Agile PLM - Oracle PIM, using Process Integration Pack (PIP). Worked on PIP extensions for the gaps and business requirements. Used SOA for development of webservices.
• Integration of PIM with various downstream applications using SOA Gateway and PL/SQL APIs.
• Custom Workflow processes for Notifications in PIM for Item Creates and Updates.
• Configuration of Business events for real-time data sync for Item Outbound.
• Implementation of Oracle Product Data Hub (PDH) / Product Information Management (PIM) for a financial services client.
• Configured PDQ (Product Data Quality) Server and PIM Connector installation.
• Designed and developed various Inbound feeds to Product Hub using PDQ services. Developed DSAs using Knowledge Studio and Application Studio.
• Knowledge of APIs in DLS/PIM Connector and Architecture of PDQ Server.
• Developed interfaces and used batch import processes in PIM to import/update items with Data quality.
• Worked on the mappings related to Oracle PIM and other information systems which require feeds In and out of Product Hub.
• Worked on PL/SQL API to Import Items and UDA creation/sync. Configured Attribute groups, atributes and value sets etc in Product Hub.
• Development of a Custom PIP(Process Integration Pack) using AIA (Application Integration Architecture) to integrate Oracle E-Business Suite and Oracle CRM On Demand.
• Designed and Developed SOA Composites such as BPEL and Mediator services for the Custom PIP to Sync Customers.
• Versions used are WebLogic 10.3.3, FMW 11.1.1.3, AIA 11.1.1.3, EBS 11.5.10.2 and CRM On Demand R17.
• Extended EBOs such as CustomerParty EBM to include the custom fields.
• Used MDS in SOA to store and use the Artifacts such as EBOs, ABOs, Xrefs and DVMs.
• Worked on Design and Development of BPEL and OSB services.
• Expertise with Keystore setups in Weblogic which are using in Webservice security policies.
• Hands on experience with Oracle CRM On Demand Accounts and Custom Objects and the exposed Web Services (formerly Siebel CRM On Demand).
• Worked on Oracle APIs to create/update customers in EBS using FMW 11g Adapters.
• Worked on Functional Requirements document.
• Integrated Peoplesoft Campus Solutions with Siebel UCM using BPEL 10.1.3.4
• Worked on Identity and Trust keystores in Weblogic server to setup SSL configuration and Outbound Webservice security in OSB 10.3 (OSB Administration)
• Worked on Design and Development of BPEL and OSB services.
• Designed and Developed OSB service to integrate PeopleSoft Campus Solutions with various 3rd party WebServices which includes Web service security.
• Involved in Requirements gathering for Product Data Hub implementations.
• Designed Technical Architecture document for Product Hub (Oracle PIM) implementation.
• Designed Functional Requirements document.
• Developed Inbound/Outbound feeds for Product Data Hub.
• Configured PIM (Product Information Management).
• Developed PL/SQL wrapper APIs to call seeded APIs for the Inbound feeds to Product Information Management (Product Data Hub)

Confidential, Green bay, WI

Oracle Applications/SOA Consultant

Responsibilities:

• Designed and developed an interface to Oracle HR from Siebel which includes an Enterprise Service using BPEL and PL/SQL to extract employee data. Employees will be created as Contacts in Siebel Claims for processing claims.
• Worked on Customizations/Integrations for Oracle applications using SOA suite (fusion middleware) to integrate with Siebel and other legacy systems.
• Using AIA standards extended PIP for integrations between various applications.
• Extended Process Integration Packs to integrate Oracle EBS and OTM. Designed process to integrate Siebel CRM and Oracle EBS.
• Designed Customizations to Integrate oracle applications with various other systems such as Siebel and OTM.
• Designed functional/technical documents for extending the PIPs given by Oracle using AIA FP standards.
• Configuration of PIM (Product Information Management) PIP (Process Integration Pack).
• Designed and developed BPEL processes to integrate with AR Module.

Confidential, Emeryville - CA

Oracle Applications/SOA Consultant

Responsibilities:

• Implementation of Oracle Applications R12.
• Prepared test scripts (TE-40) across various modules.
• Involved in testing in various customizations (CEMLI’s)
• Designed and Developed Order import to bring orders from various websites to Oracle Order Management for fulfillment and accounting.
• Designed and Developed check printing CEMLI as part of ipayments module, created two custom RTF’s for XML Publisher report.
• Developed BPEL/SOA Processes to integrate Oracle Applications with website.
• Created and Used APIs to create the orders in real time and also applied Holds to the order to based on the business requirements.
• Developed and maintained various BPEL processes to integrate with various other systems.
• Created wrapper packages for Customer creations and Sales Reps during the Import.
• Worked on Processing Constraints and defaulting rules.
• Implemented forms personalization in order management.
• Worked on importing various types of Orders including ATO Models and PTO Models.
• Configured various BOM Models as part of the requirement.

Environment: Oracle Apps 12.0.5, PL/SQL, Oracle 10g, Toad, SQL*Loader, XML Publisher, Jdeveloper, Fusion Middleware, BPEL, ESB, SOA Suite (Oracle Fusion Middleware) 10.1.3.4, Workflow builder, Linux.

Confidential, Santa Clara - CA

Oracle Applications Consultant

Responsibilities:

• As a techno-functional consultant implemented oracle internet expenses for US based employees.
• Developed American Express(Amex) credit card interface using SIFT Utility and the Interface loads the empolyee credit card transactions into Oracle Internet Expenses(iExpenses).
• Developed supplier P-Card interface which loads invoices that are received in a Visa VCF4 format.
• Developed a new Remittance advice program to generate the Remittance file for American Express for the Invoices using AMEX IB/CP format.
• Implemented Punchouts to suppliers using oracle exchange, PO in cXML format.
• Developed a payment format program to generate the Payment file for the bank (wellsfargo) which contains the standard format for wellsfargo to make the payments to suppliers using Electronic payment method.
• Involved in Design and Review of the functional technical documents for the wellsfargo Commerical card expense reporting process specific to Confidential which involves payment process for the Ghost card (P-card) suppliers.
• Involved in design to load invoices for high volume suppliers.
• Converted existing reports XML publisher based reports with multi page layouts.

Environment: Oracle Apps 11.5.10.2 Modules: (GL, AP, PO, iProcurement, iExpenses), PL/SQL, Oracle 10g, Toad, SQL*Loader, Reports 6i, Discoverer 10g, XML Publisher, Workflow builder, Markview, Linux.

Confidential, Sunnyvale - CA

Oracle Applications Consultant

Responsibilities:

• Involved in the second phase of the project, which involves upgrading SOA suite to 10.1.3.3.
• Handled the BPEL upgrade project in migrating Oracle Application Server from windows to Linux environment with an upgrade in version (10.1.2.2 to 10.1.3.3).
• Incorporated various changes to the process to resolve issues related to upgrade.
• Performed an end-to-end execution of test cases across link and UAT instances.
• Worked in cross-functional team environment for the BPEL upgrade such as Siebel, TIBCO, BAM and B2B.
• Worked on Concurred Manager (CM) Server separation, which improves the performance of the application by migrating CM server.
• Automated Ant scripts for deployment of business process designed using Oracle BPEL process manger.
• Deployed processes on a cluster based SOA Suite.
• Supported Order-to-cash modules and fixed some of the process related bugs.

Environment: Oracle Apps 11.5.9 Modules: (GL, INV, AR, OM, Pricing, Shipping), PL/SQL, Oracle 10g, Toad, SQL*Loader, Reports 6i, Discoverer 10g, XML Publisher, Jdeveloper, Fusion Middleware, BPEL, ESB, SOA Suite (Oracle Fusion Middleware) 10.1.3.3, Workflow builder, Linux.

Confidential, San Diego - CA

Oracle Applications Techno - Functional Consultant

Responsibilities:

• Involved in gathering the requirements and setups in iExpenses module.
• Identified the gaps and written functional design documents and technical design documents.
• Written and tested test cases for iExpense implementation and also conducted CRP/UAT.
• Worked on Integration with Oracle Imaging and process management (Stellent) to integrate with the oracle apps, which enables automation and eliminates paper based expense report by storing the images in the server.
• Personalized OA framework pages in Oracle Internet Expenses.
• Customized Workflow to automate iexpenses with Stellent (IBPM).
• Implemented long running Asynchronous and Synchronous Business Integration and Service Orchestration modules using BPEL to integrate Stellant IPM, E-Business Suite
• Designed BPEL process, which integrates Oracle iExpenses and Stellent (Oracle Imaging and Process Management).
• Designed and Implemented Java WebServices using Oracle Jdeveloper.
• Designed and Implemented JMS queues and Topics using AQ and MQ.
• Installed and configured the Oracle SOA Suite for High Availability, Load Balancing, Clustering and Redundancy with Active-Active topology on multiple nodes.

Environment: Oracle Apps 11.5.10.2 Modules: (AP, PO, IEXPENSES), PL/SQL, OA Framework, Oracle 9i, Toad, Workflow builder, Fusion Middleware 10.1.3.3, BPEL process Manager, Oracle Imaging and Process Management (Stellent), UNIX.

Confidential, Scottsdale - AZ

Oracle Applications Consultant

Responsibilities:

• Developed custom inbound AP invoice interface for loading legacy system invoices into Oracle Accounts Payables interface tables by creating XML Schema and Using BPEL Process Manager of SOA Suite. The process also runs the concurrent program to store the data into base tables.
• Defined and managed a trading partner using RosettaNet protocol of Integrator B2B of Oracle Application Server 10g.
• Used SOA Adapters to integrate with oracle E Business Suite.
• Configured oracle SOA suite for high availability and load balancing.
• Developed deployment plan for different SOA environments.
• Worked on customizing Purchase Order (850) EDI using B2B integrator.
• Developed GL budget interface process using BPEL using Apps Adapter for loading external budget journals into Oracle General Ledger. Wrote a XSD Schema to cross validate budget journals into interface table.
• Exposed PL/SQL Packaged procedures/functions and Java Programs as Web Services which were invoked from a third party application.
• Worked on Oracle applications Adapter in Fusion Middleware, Data Hubs and involved in setting up Business Activity Monitoring (BAM).
• Worked on AUTO-LOCKBOX Interface by developing SQL*Loader scripts for importing customer payments from banks to AR interface tables, and finally to the base tables.
• Successfully designed and implemented the Payables Open Interface which involved in the data migration from legacy system to the Oracle Payables. Involved in creation of Loader File, loaded invoices into the interface tables using SQL*Loader and then used the Payables Open Interface to import the data into the base tables.
• Involved in developing a custom package for importing orders through order import open interfaces in order management.
• Using Auto Invoice Interface imported Standard invoices, Credit memos and Debit memos from legacy system to Oracle Receivables tables using PL/SQL packages/procedures and Auto Invoice Import program.
• Customized existing custom oracle reports to replace plain text output to PDF format using XML Publisher. Worked on XML Publisher bursting to send PDF reports via email.
• Customized Expenses workflow in iexpeneses to incorporate rules according to the company requirement.
• Customized workflow for order lines in Order Management to incorporate ATP check in standard line flow and in Purchase Order Lines for min purchase quantity and budget availability.
• Interaction with the end user to gather the requirement for the customization of modules as well as for all kinds of reports.
• Designed MD70 Technical documents based on AIM standards.

Environment: Oracle Apps 11.5.10.2 Modules: (GL, AP, PO, AR, OM, INV, PRICING, SHIPPING, ), PL/SQL, Oracle 10g, Toad, SQL*Loader, Reports 6i, Forms 6i, Discoverer 10g, XML Publisher, Jdeveloper, BPEL,ESB,SOA Suite, Workflow builder, Linux.

Confidential, Dallas - TX

Oracle Applications Consultant/SOA Developer

Responsibilities:

• Developed several XSD’s for XML validations. Used Oracle Rules Engine to configure Business Rules. Configured and Deployed web services security Policies using Oracle Web Services Manager (OWSM).
• Designed BPEL process using Oracle BPEL process manager of SOA Suite by levering the existing conventional business flow mapping legacy system with Oracle E business suite.
• Created an Enterprise Service Bus (ESB) along with a BPEL process to filter and route PO related invoices to different Vendors.
• Developed BPEL Process using oracle BPEL process manager of Fusion Middleware that loads PO requisitions into interface table for requisitions using the adapters built on JCA 1.5 architecture.
• Supported existing BPEL processes and SOA suite and resolved some of the configuration related issues.
• Defined Line Transaction Descriptive Flexfield and derived those lines into the interface tables. BPEL Process is used to load all the invoices into a temporary staging table using the Database Adapter.
• Configured Business Rules using Rules Engine and used in BPEL Process.
• Used OWSM of SOA suite for web services security.
• Configured JMS queues and topics in oracle AQ and IBM MQ for asynchronous requests.
• Used ESB for transformation, routing requests to integrate dataflow between AQ, MQ and various data sources.
• Designed and Implemented web services using session beans (EJB’s) and message driven beans (MDB’s) for asynchronous business processes.
• Involved in system administration and AOL activities like creation of Users, Request groups, Request sets, User menus and Responsibilities, value sets and form functions.
• Developed an Interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Involved in customization of Statements, Remittance, PO Print, AP Self Billing Invoice, Supplier Open Balance, Supplier Return Document and AR Invoices using XML Publisher.
• Customized workflow for Requisition approval in iProcurement.

Environment: Oracle Apps 11.5.10 (GL, AP, PO, AR, OM), PL/SQL, Oracle 9i, Toad, Reports 6i, Jdeveloper, XML, XSD, SOAP, Web Services, BPEL, ESB, SOA Suite 10.1.2.2, XML Publisher, Workflow and Linux.

Confidential, NJ

Oracle Applications Consultant

Responsibilities:

• Designed and Developed the interface program to Import Journals into General Ledger using SQL*Loader, PL/SQL package and Journal Import Concurrent program.
• Designed and Developed the interface program to load the Invoices from a legacy system into Oracle Payables using SQL*Loader, PL/SQL package and Payables Open Interface Import Concurrent program.
• Involved in the migration of the several reports to 11i in Order Management which includes packing slip, pick slip, mailing label.
• Modified/maintained Oracle Workflow for PO approval process and setup users for notifications.
• Customized Dunning Letter Process and AR Aging Reports.
• Prepared customer profile classes and customers, statement cycles, dunning letter sets, receipt classes, receipt sources and payment methods.
• Customized standard reports such as Account Analysis Report, Journal Batch Summary report (GL Transaction report), Past due Invoice report and AGING BUCKETS in General Ledger and Accounts Receivable.
• Involved in overriding E-Mail Addresses for all Notifications in oracle workflows.
• Developed control file to load customer information from flat file into staging tables, using SQL * loader then validated data and inserted into AR Interface Tables.
• Implemented Custom Item Creation Process. A set of custom programs was developed to facilitate mass load of Items and other related Information. The different processes included loading of items to Item Master, creating Item Categories, loading the Pricelist and creating the Approved Supplier list and Sourcing rules. The form was developed using PL/SQL and Inventory Interfaces, Inventory APIs and Pricing APIs and Purchasing Interfaces.
• Designed, developed and tested FSG reports.
• Enhanced Oracle Discoverer reporting environment, created new business areas, custom views, joins, custom folders, calculated items, and workbooks across modules and troubleshooting.
• Created End User Layers and Business Areas, identified and resolved security issues.

Environment: Oracle Apps 11.5.9 (GL, PO, OM, AR, INV), PL/SQL, Oracle 9i, Toad, Discoverer 4i, SQL*Loader, Reports 6i, Forms 6i.