SUMMARY:

• Over 9 years of IT experience in developing cost effective solutions as an Oracle Consultant using Oracle Fusion Middleware, Oracle Applications and related technologies including Implementations, upgradations and Customizations.
• Experience from end - to-end on implementing SOA in Oracle Fusion Suite and Web methods product Suit and implementation of B2B Integration.
• Worked on ALSB, SOA and OSB 11G and AIA.
• Familiar with XPath, XQuery, XSLT and WSDL.
• Hands on experience in developing interfaces in BPEL and ESB.
• Worked on various Service Adapters which includes AQ Adapter, JMS Adapter, DB adapter, FTP Adapter, File Adapter, BAM Adapter and Oracle Apps Adapter.
• Designed and implemented several BPEL Processes having different interaction patterns.
• Extensive experience in using PL/SQL, Developer 2000/6i/9i, JDeveloper, SQL*LOADER, TOAD, SQL Navigator, Discoverer 3i/4i/9i/10G, Workflow, Oracle 9i/8i/8/7.x, Unix, Linux, Shell Scripts and Oracle Applications (Financials, Manufacturing and Sales & Distribution modules).
• Experience in Forms customizations and personalization.
• Experience in customizing and developing Oracle reports.
• Experience in middleware technologies ORACLE SOA Suite 11g.
• Experience in developing composites using Mediators and Adapters.
• Expertise in using adapters like O/J - DBC, ftp and APPS adapters.
• Experience in developing end to end B2B Architectures.
• Involved in developing custom xsd’s according to business needs.
• Extensive experience in Oracle 11g SOA Components like BPEL, ESB, Business Rules, Business Process Management-Human Workflow, Adapters (File/FTP, JMS, BAM, Oracle Apps),EDN Event Delivery Network, OWSM Oracle Web-service Management, BAM Business Activity Monitoring, OSB 11G, SOA Web Services.
• Extensive experience in developing RICEW (Reports, Interfaces, Conversions, Extensions and workflow event) components.
• Proficient in developing PL/SQL program units using Procedures, Functions, Packages, Triggers and Public API’s.
• Experience in defining processes relative to Order to Cash, Procure to pay business cycles.
• Proficient in conducting requirements GAP analysis, Business process re-engineering, Solution Design, Test Methodologies, Cutover Strategy, Implementation, Knowledge Transfer and Application Support.
• Recent experience in implementation of INV, PO, AP, AR and OM modules.
• Extensive experience in identifying product gaps, coordinated with development team by creating TAR/SR and obtained one-off fixes. Managed and monitored TAR’s for several P1/P2/P3 issues.
• Extensive experience in Customization of Oracle Application modules, which involves Forms Personalization.
• Extensively worked on AIM documents like BR100, MD050, MD070 and MD120.

TECHNICAL SKILLS:

Oracle Applications: Accounts Payables (AP), Accounts Receivables (AR), Inventory (INV), Order Management (OM), Purchasing (PO), Bill of Materials (BOM) Application Object Library.

Database Tools: PL/SQL, SQL*PLUS, SQL*LOADER, TOAD, SQL Navigator.

Oracle Tools: Reports 2.5/6i/9i, Forms 4.5/6i/9i, Developer 2000/6i/9i, Oracle 8i/9i, XML Publisher, Oracle SOA 11g ( BPEL, Mediator, Human Workflow and Business Rules ), Oracle Service Bus

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 6.5/7.0

Languages: SQL and PL/SQL, C, C++, XML and HTML.

Scripting Language: UNIX Shell Scripting, Cron Jobs.

Application Servers: Oracle10g Application Server

Version Control: PVCS, SharePoint.

Operating Systems: UNIX, Solaris 7/8, Linux, Windows NT/2000/XP/ Windows 7, MS-Dos, Apple Mac OS X.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle SOA Technical Lead

Responsibilities:

• Involved with study of existing system, reviewed Functional (MD50) design documents, produced technical design documents (MD 70) and installation instructions documents (MD 120) as per business requirement.
• Designed and developed integration layer between Oracle EBS and third party system (Dealer Portal applications) using Oracle SOA Suite.
• Designed and developed an integration layer between FedEx Call Tag system and Client based B2B application.
• Well versed with XSD, XML, XSLT and WSDL.
• Worked extensively on Oracle 11g SOA Components like BPEL, ESB, Business Rules, and Business Process Management-Human Workflow.
• Extensive experience with Oracle 11g SOA Adapters (File/FTP, JMS, BAM, Oracle Apps) EDN Event Delivery Network, OWSM Oracle Web-service Management, BAM Business Activity Monitoring .
• Involved in Unit testing and Bug Fixes, Involved in UAT Process (work involved helping Test Team to come up with test cases and Bug Fixes)
• Developed SOA interface between Oracle Apps and POS System in order to maintain daily sales
• Worked extensively on Oracle 11g SOA Components like BPEL, ESB, Business Rules, and Business Process Management-Human Workflow.
• Prepared Test Plans and Test Case Scenarios, detailed documentation and testing instructions for support team.
• Used different activities like catch, catch all within a scope to handle errors within a BPEL process.
• Developed fault policies and commonly used for all the SOA services.
• Error handling is done by invoking log event which has the information about the process. This is handled in catch all block of BPEL process.
• Maintained MDS for all the SOA work.
• Used REST adapter in SOA 12C to call RESTFUL webesrvices.
• Configured Email using email activity using User Messaging Service.
• Scheduled web services using Enterprise Management Scheduler introduced in SOA 12C.
• SSL Configured in WLS console in order to access external webservices.
• Configured DB Adapter, JMS, AQ and BAM Adapter in WLS Console.
• Developed ant scripts in order to deploy SOA artifacts into MDS.
• Developed BPEL processes with validations, exception handling, logging and event data checksum to match incoming payload elements count with outgoing message element count.
• Handled different types of faults like system faults and business faults with in a BPEL process with retry mechanism.
• Maintained MDS for all the SOA work.

Environment: Oracle SOA Suite 12C, Oracle Service Bus, SoapUI, Enterprise Manager, Salesforce,Zuora Subscriptions, JIRA, Toad, SQL Navigator, Windows XP, Windows NT and Windows 7.

Confidential, Santa Clara, CA

Sr. Oracle SOA Technical Lead

Responsibilities:

• Involved with study of existing system, reviewed Functional (MD50) design documents, produced technical design documents (MD 70) and installation instructions documents (MD 120) as per business requirement.
• Extensive experience in developing SOAP, WSDL, XML, XSD’s.
• Developed SOA Composites that calls REST web services using REST Adapter which is introduced in 12C.
• Developed 10g SOA applications in 12C.
• Extensive experience in using SOA components like BPEL, Mediator, Human task and Business rules Engine.
• Unit tested these web service using SOAPUI
• Used OSB (Oracle Service Bus) for REST Crud operations.
• Used HTTP Analyser to debug the issues with RESTful webservices.
• Designed and developed complex XSLT transformations within BPEL process.
• Used Correlation concept for Asynchronous BPEL Process.
• Used database sequence to generate unique number always within the XSLT transformations.
• Created DVMs (Domain Value Maps) to retrieve data dynamically at runtime.
• Used properties within invoke activity to make a successful call to Salesforce as well as RESTful web services.
• Designed Proxy Flows, Business Services, Operational and Conditional Branches for Routing messages at different Stages of the flow.
• Designed and developed process to integrate with Salesforce.
• Developed BPEL process for Billing Revenue System called SAP Conversion change .
• Configured adapter resources like data source, connection pool for database adapter and JMS resources in web logic console.
• Worked on XSLT transformations, XQuery and Xpath.
• Worked on various Service Adapters which includes AQ Adapter, JMS Adapter, DB adapter,FTP Adpater, File Adapter, BAM Adapter, Oracle Apps Adapter .
• Created DFF’s on standard and custom forms to store additional information. Eg: Customer sites form, order lines forms and shipping transactions form.
• Enabled Security to Web-services. Accomplished client’s security and infrastructure requirements using Oracle 11g SOA Web-service Management Component.(OWSM)
• Configured Active Directory (LDAP) for securing the services in SOA.
• Performed unit testing as well as integration testing.
• Prepared Test Plans and Test Case Scenarios, detailed documentation and testing instructions for support team.
• Used free tools like POSTMAN, Request-Bin to test Http Client requests. It allows us to debug webhook requests.
• Used Ant-Scripts by attaching configplan.xml to deploy all the SOA services to different environment.
• Developed BPEL processes with validations, exception handling, logging and event data checksum to match incoming payload elements count with outgoing message element count.
• Handled different types of faults like system faults and business faults with in a BPEL process with retry mechanism.
• Maintained MDS for all the SOA work.

Environment: Oracle SOA Suite 12C, Oracle Service Bus, SoapUI, Enterprise Manager, Salesforce,Zuora Subscriptions, JIRA, Toad, SQL Navigator, Windows XP, Windows NT and Windows 7.

Confidential, Muscatine, IA

Sr. Oracle SOA Technical Lead

Responsibilities:

• Involved with study of existing system, reviewed Functional (MD50) design documents, produced technical design documents (MD 70) and installation instructions documents (MD 120) as per business requirement.
• Designed and developed integration layer between Oracle EBS and third party system (Dealer Portal applications) using Oracle SOA Suite.
• Followed 3-tier SOA Architecture (Requester, Business Service and Provider).
• Requester receives the request from third party application system and converts the message into canonical format.
• Business Service routes the request to the appropriate service provider that calls the webservice exposed by EBS through Integrated SOA Gateway (ISG).
• Provider makes a synchronous call to the EBS Webservice and the response received from EBS webservice will be sent back up to the calling stack of third party application system.
• Created Business agents in EBS for JMS AQ to produce or consume messages through XML Gateway.
• Developed BPEL Processes for Service Requester and Service Provider.
• Used Mediator as a business service.
• Used pre-defined OWSM username-client token security policy to provide user credentials to access webservice exposed by EBS.
• Created and Configured JMS adapter, AQ adapter, BAM adapter, Database adapter.
• Used Ant-Scripts by attaching configplan.xml to deploy all the SOA services to different environment.
• Developed BPEL processes with validations, exception handling, logging and event data checksum to match incoming payload elements count with outgoing message element count.
• Handled different types of faults like system faults and business faults with in a BPEL process with retry mechanism.
• Unit tested these web service using SOAPUI
• Developed custom Business Events and subscriptions.
• Developed Workflows to raise custom business event which in turn calls external web service using SIF.
• Developed RTF Templates using XML BI Publisher.
• Performed tuning on the SQL and PL/SQL packages to improve processing time and efficiency.
• Used SQL trace files in tuning process.
• Create Users and Responsibilities for Security and limit permission as per business needs.
• Worked extensively on Oracle 11g SOA Components like BPEL, ESB, Business Rules, Business Process Management-Human Workflow.
• Used AIA Canonical Model.
• Developed EBM(Enterprise Business Message) based on EBO's(Enterprise Business Objects)and ABM(Application Business Message) using AIA Architecture.
• Prepared Test Plans and Test Case Scenarios, detailed documentation and testing instructions for support team.
• Used different activities like catch, catch all within a scope to handle errors within a BPEL process.
• Developed fault policies and commonly used for all the SOA services.
• Error handling is done by invoking log event which has the information about the process. This is handled in catch all block of BPEL process.
• Maintained MDS for all the SOA work.
• Designed and developed an Outbound Interface between Interlace Systems (Supply-Chain Management tool) and Oracle Applications for Customers (AR), Items (INV), BOMS, On hand Quantity (INV), etc.
• Created DFF’s on standard and custom forms to store additional information. Eg: Customer sites form, order lines forms and shipping transactions form.
• Setup multiple quick codes for INV, PO, OM, AP, and AR. Eg: (Discount Amount Basis, AR Transaction Type Categories, Account Types etc. … to meet current business requirements).
• Developed Inbound Interfaces such as customer creation, Invoice creation, create and apply receipts, Reverse Receipts, Applying Credit memo.
• Developed Outbound Interfaces to pass the information from Oracle Applications to the third party system by making use of Integrated SOA Gateway functionality to invoke an external web service using Service Invocation Framework.
• Customized Invoices Pick and Pack slips to list back ordered items and print discount information in Oracle Order Management (OM) module.
• Designed and developed an interface between third party billing system ( Confidential ) and Confidential to load external invoices data on daily basis. Used SQL*Loader for importing Confidential invoices into Staging tables, and developed PL/SQL API’s for complete validation of data and inserting into AR Interface tables.
• Implemented Purchase Order (PO) outbound (EDI 850), Process Manufacturing Purchase Order (GPOI) outbound (EDI 850), PO Change Order (EDI 860), PO Acknowledgment (EDI 855), PO Change Acknowledgment (EDI 865), PO Receipt (EDI 861) Inbound, Shipping Schedule (EDI 862), AP and AR Invoice Inbound (EDI 810), Shipment notice/Manifest ASN - IN and OUT (EDI 856), Payment Order/Remittance advice (EDI 820) , Price and Sale Catalog (EDI 832), Planning Schedule With Release Capability (EDI 830), Inventory Inquiry Advice (EDI 846), Sales Report (EDI 867), Shipping Schedule (EDI 862) in Oracle R12.1, Inventory Inquiry Advice (EDI 846) EDI processes through PL/SQL custom packages, Standard Oracle XML Gateway and Standard Oracle E-commerce Gateway T-Sets. Automated most of O2C & P2P business process with Oracle XML Gateway and Oracle e-Commerce Gateway EDI transactions.

Environment: Oracle SOA 11g Suite, Oracle Service Bus, SoapUI, Enterprise Manager, Oracle Applications R 12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Windows XP, Windows NT and Windows 7.

Confidential, Austin, TX

Sr. Oracle SOA Consultant

Responsibilities:

• Involved in the system study, requirements, Gap analysis and design documentation.
• Involved in Functional Document review and Prepared Technical Specifications based on the Business Requirement.
• Worked with File Adapter, Database Adapter and JMS Adapter for establishing connection with services in BPEL.
• Developed BPEL processes based on File adapter to poll the files.
• Developed 2 BPEL processes within the same component, which participate in different transaction.
• Designed Proxy Flows, Business Services, Operational and Conditional Branches for Routing messages at different Stages of the flow.
• Configured File adapter in OSB 11G to read the files from local system configured JMS adapter, FTP adapter as part of integration.
• Handled different types of faults like system faults and business faults with in a BPEL process with retry mechanism.
• Installation, configuration and development in Oracle SOA Suite 11.1.1.6.
• Designed and created complete BPEL processes for orchestration using different process activities.
• Used different activities like catch, catch all within a scope to handle errors within a BPEL process.
• Configured adapter resources like data source, connection pool for database adapter and JMS resources in web logic console.
• Worked on XSLT transformations, XQuery and Xpath.
• Worked on various Service Adapters which includes AQ Adapter, JMS Adapter, DB adapter, FTP Adpater, File Adapter, BAM Adapter and Oracle Apps Adapter.
• Created DFF’s on standard and custom forms to store additional information. Eg: Customer sites form, order lines forms and shipping transactions form.
• Developed BPEL processes with validations, exception handling, logging and event data checksum to match incoming payload elements count with outgoing message element count.
• Handled different types of faults like system faults and business faults with in a BPEL process with retry mechanism.
• Used AIA Canonical Model.
• Developed EBM(Enterprise Business Message) based on EBO's(Enterprise Business Objects)and ABM(Application Business Message) using AIA Architecture.
• Enabled Security to Web-services. Accomplished client’s security and infrastructure requirements using Oracle 11g SOA Web-service Management Component.(OWSM)
• Configured Active Directory (LDAP) for securing the services in SOA.
• Performed unit testing as well as integration testing.
• Prepared Test Plans and Test Case Scenarios, detailed documentation and testing instructions for support team.
• Designed Proxy Flows, Business Services, Operational and Conditional Branches for Routing messages at different Stages of the flow.
• Used different Operational, Conditional Branching mechanisms for routing of SOAP based Requests .
• Called the composite services form SOA using SOA - Direct transport.
• Implemented Logging & Error Mechanisms using Log Action, Repot Action and Proxy level Error Handlers .
• Developed WSDL’s and XSD’s, XQuery Transformations for the Messages.
• Used different Activities, Routing, logging, and Error Handling Mechanisms, capabilities of OSB 11G .
• Extensive experience with Oracle 11g SOA Adapters (File/FTP, JMS, BAM, Oracle Apps) EDN Event Delivery Network, OWSM Oracle Web-service Management, BAM Business Activity Monitoring .
• Worked extensively on Oracle 11g SOA Components like BPEL, ESB, Business Rules and Business Process Management-Human Workflow.
• Maintained all the work done using SVN.
• Developed Inbound Interfaces such as customer creation, Invoice creation, create and apply receipts, Reverse Receipts, Applying Credit memo.
• Developed Outbound Interfaces to pass the information from Oracle Applications to the third party system by making use of Integrated SOA Gateway functionality to invoke an external web service using Service Invocation Framework.
• Designed and implemented Purchase Order (PO) outbound (850), Purchase Order Change (POC) (860), AR Invoice inbound (810), Shipment notice/Manifest (ASN 856), Payment Order/Remittance advice (820), Purchase order Acknowledgement Outbound (855), POA Inbound (855), 865 POCA Inbound , Inventory Inquiry Advice (846), Shipping Schedule (EDI 862), Price and Sale Catalog (832), EDI 861 RA/AC, 888 EDI process through PL/SQL custom packages and Oracle E-Commerce Gateway.

Environment: Oracle SOA 11g Suite, Oracle Service Bus, SoapUI, Enterprise Manager, Oracle Applications R 12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Windows XP, Windows NT and Windows 7.

Confidential, Bensalem, PA

Responsibilities:

• Produced Functional design (IFD) and Technical design documents (IFDM) based on the business requirement.
• Designing, Developing and Deploying structured BPEL, and Web Services in Oracle SOA 11g.
• Developed Inbound Interfaces such as customer creation, Invoice creation, create and apply receipts, Reverse Receipts, Applying Credit memo.
• Developed Outbound Interfaces to pass the information from Oracle Applications to the third party system by making use of Integrated SOA Gateway functionality to invoke an external web service using Service Invocation Framework.
• Well versed with XSD, XML, XSLT and WSDL.
• Used AIA Canonical Model.
• Developed EBM(Enterprise Business Message) based on EBO's(Enterprise Business Objects)and ABM(Application Business Message) using AIA Architecture.
• Worked extensively on Oracle 11g SOA Components like BPEL, ESB, Business Rules, and Business Process Management-Human Workflow.
• Worked on various Service Adapters which includes AQ Adapter, JMS Adapter, DB adapter, FTP Adapter, File Adapter, BAM Adapter and Oracle Apps Adapter.
• Worked on routing/approvals of a Supplier Purchase Order and Sales Orders using Oracle 11g SOA components.
• Developed an entirely new composite application for Supplier PO’s.
• Used SOA Mediators which routes the purchase orders depending upon the total Purchase Order amount.
• Developed a sub project composite application to validate credit card details. Used mediator and Database adaptor.
• Used Oracle 11g SOA Asynchronous BPEL to develop and build business processes.
• Get input from mediator about supplier purchase order.
• Using Oracle Apps SOA adapter, invoked a package which validates received data.
• All errors are logged into errors table using SOA database adapter.
• Implemented Human Task Workflow engine to approve or reject a supplier purchase order.
• Implemented Business Rules to have discounts on products based on Total Purchase Order Amount.
• Implemented Business Rule Decision Table to route approved purchase orders to a logistics provider (USPS, UPS or FedEx) based on Total Purchase Order Amount.
• Used Oracle SOA JMS Adapter (Queues) to USPS, UPS or FEDEX.
• Used Event Delivery Networks.
• Created Fault Policies at composite levels.
• Used FTP/SFTP adapters for inbound and outbound communication of files.
• Produced Functional, lead Technical team and developed a business process to extract order information and import shipment confirmations using oracle public API’s. Order information (EDI 940) is sent to a 3’rd party logistics provider (3PL). 3PL ships the product and sends us (EDI945) shipment confirmation with all freight charges, weights, routing info etc…This is a custom B2B implementation.
• Designed and developed end to end B2B Architectures and established EDI communication between Suppliers, Customers & client.
• Extensive experience with all EDI transactions sets and EDI x12 formats.
• Responsible for Trading Partner Setups and establish B2B EDI Communication.
• Extensive experience with EDI x12 formats.

Environment: Oracle SOA 11g Suite, Oracle Service Bus, SoapUI, Enterprise Manager, Oracle Applications R 12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Windows XP, Windows NT and Windows 7.

Confidential

Sr. Oracle Consultant.

Responsibilities:

• Involved in the system study, requirements, Gap analysis and design documentation.
• Involved in Functional Document review and Prepared Technical Specifications based on the Business Requirement.
• Designed and developed Interfaces between third party system and Confidential (AR) exposed these interfaces as web services. Used SOAPUI to test these web services.
• Experience in developing B2B integration via workflow processing, messaging and routing, and enterprise application integration.
• Extensive experience with Oracle 11g SOA Adapters (File/FTP, JMS, BAM, Oracle Apps) EDN Event Delivery Network, OWSM Oracle Web-service Management, BAM Business Activity Monitoring .
• Modification of B2B messaging system on Oracle SOA 10g Suite.
• Exposed Interfaces as web services by generating WSDL and provided security authentication for the web services in EBS using integrated repository responsibility.
• Unit tested these web service using SOAPUI
• Developed custom Business Events and subscriptions.
• Developed Workflows to raise custom business event which in turn calls external web service using SIF.
• Developed RTF Templates using XML BI Publisher.
• Created DFF’s on standard and custom forms to store additional information
• Setup multiple quick codes for INV, PO, OM, AP, and AR to meet current business requirements
• Involved in Building Customizations and Enhancements using Reports and Forms. Involved in Code Review Process to make sure that code is in compliance with AIM methodology.
• Designed and implemented Purchase Order (PO) outbound (850), Purchase Order Change (POC) (860), AR Invoice inbound (810), Shipment notice/Manifest (ASN 856), Payment Order/Remittance advice (820), Purchase order Acknowledgement Outbound (855), POA Inbound (855), 865 POCA Inbound , Inventory Inquiry Advice (846), Shipping Schedule (EDI 862), Price and Sale Catalog (832), EDI 861 RA/AC, 888 EDI process through PL/SQL custom packages and Oracle E-Commerce Gateway.

Environment: Oracle SOA 11g Suite, Oracle Service Bus, SoapUI, Enterprise Manager, Oracle Applications R 12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Windows XP, Windows NT and Windows 7.

Confidential

Sr. Oracle Consultant.

Responsibilities:

• Produced Functional design (MD50) and Technical design documents (MD70) based on the business requirement.
• Produced, Installation Instructions documents (MD120).
• Gathered functional user inputs and produced TE020 document.
• Extensive experience with Oracle 11g SOA Adapters (File/FTP, JMS, BAM, Oracle Apps) EDN Event Delivery Network, OWSM Oracle Web-service Management, BAM Business Activity Monitoring .
• Modification of B2B messaging system on Oracle SOA 10g Suite.
• Extensive experience in developing SOAP, WSDL, XML, XSD’s.
• Configured adapter resources like data source, connection pool for database adapter and JMS resources in weblogic console.
• Designed and developed end to end B2B Architectures.
• Involved in multiple CRP’s and UAT’s to meet business users requirements.
• Implementation of Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• Developed Customer Conversion to convert customers from legacy system into Oracle Applications using Standard public API’s.
• Using DBLinks extracted data from legacy system to Oracle Staging tables
• Developed Custom forms and Reports

Environment: Oracle SOA 11g Suite, Oracle Service Bus, SoapUI, Enterprise Manager, Oracle Applications R 12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Oracle SOA 11g Suite, Windows XP, Windows NT and Windows 7.

Confidential, Knoxville, TN

Sr. Oracle Consultant.

Responsibilities:

• Produced Functional design (MD50) and Technical design documents (MD70) based on the business requirement.
• Produced, Installation Instructions documents (MD120).
• Gathered functional user inputs and produced TE020 document.
• Involved in multiple CRP’s and UAT’s to meet business users requirements.
• Implementation of Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• Well versed with XSD, XML, XSLT and WSDL.
• Worked extensively on Oracle 11g SOA Components like BPEL, ESB, Business Rules, Business Process Management-Human Workflow.
• Experience in developing B2B integration via workflow processing, messaging and routing, and enterprise application integration.
• Extensive experience with Oracle 11g SOA Adapters (File/FTP, JMS, BAM, Oracle Apps) EDN Event Delivery Network, OWSM Oracle Web-service Management, BAM Business Activity Monitoring .
• Modification of B2B messaging system on Oracle SOA 10g Suite.
• Extensive experience in developing SOAP, WSDL, XML, XSD’s.
• Designed and developed end to end B2B Architectures.
• Designed and Developed Staging tables, Data Conversion SQL Loader Programs and Custom PL/SQL API’s (Interfaces) to import legacy system Sales Orders to Oracle Order Management (OM), legacy system Purchase Orders into Oracle Purchasing (PO) and legacy system Bills of Materials into Oracle Bill of Materials (BOM) modules.

Environment: Oracle SOA 11g Suite, Oracle Service Bus, SoapUI, Enterprise Manager, Oracle Applications R 12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Oracle SOA 11g Suite, Windows XP, Windows NT and Windows 7.

Confidential, Redwood City, CA

Sr. Oracle Consultant

Responsibilities:

• Involved with study of existing system, reviewed Functional (MD50) design documents, produced technical design documents (MD 70) and installation instructions documents (MD 120) as per business requirement.
• Involved in Conference Room Pilots (CRP’s) and Quality assurance to give the client a better understanding of the Applications. CRP Setup included: Inventory (INV), Purchasing (PO), Advanced Pricing, Order Management (OM) and Shipping etc.
• Extensive experience in developing SOAP, WSDL, XML, XSD’s.
• Designed and developed multiple BR 100 setup manuals as per business requirement.
• Implementation of Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• Modification of B2B messaging system on Oracle SOA 10g Suite.
• Developed Oracle 11g SOA composites and components.
• Experience in developing B2B integration via workflow processing, messaging and routing, and enterprise application integration.
• Worked on Mediators, Oracle Business Rules and Business Process Management-Human Workflow.
• Extensive experience with Oracle 11g SOA Adapters (File/FTP, JMS, BAM, Oracle Apps) EDN Event Delivery Network, OWSM Oracle Web-service Management, BAM Business Activity Monitoring .
• Developed Fault Policies to handle exceptions in Oracle 11g SOA Composite.
• Extensive implementation experience with Oracle 11g SOA BPEL Activities.
• Designed and developed end to end B2B Architectures.
• Experience in generating BAM (Business Activity Monitoring) Reports.
• Enabled Security to Web-services. Accomplished client’s security and infrastructure requirements using Oracle 11g SOA Web-service Management Component.(OWSM)

Environment: Oracle SOA 11g Suite, Oracle Service Bus, SoapUI, Enterprise Manager, Oracle Applications R 12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Oracle SOA 11g Suite, Windows XP, Windows NT and Windows 7.

Confidential, Santa Monica, CA

Responsibilities:

• Involved in the system study, requirements, Gap analysis and design documentation.
• Involved in Functional Document review and Prepared Technical Specifications based on the Business Requirement.
• Implementation of Order to Cash (O2C) cycle.
• Developed Oracle 11g SOA composites and components.
• Well versed with XSD, XML, XSLT and WSDL.
• Worked on Mediators, Oracle Business Rules and Business Process Management-Human Workflow.
• Extensive experience with Oracle 11g SOA Adapters (File/FTP, JMS, BAM, Oracle Apps) EDN Event Delivery Network, OWSM Oracle Web-service Management, BAM Business Activity Monitoring .

Environment: Oracle SOA 11g Suite, Oracle Service Bus, SoapUI, Enterprise Manager, Oracle Applications R 12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Oracle SOA 11g Suite, Windows XP, Windows NT and Windows 7.

Confidential, Alpharetta, GA

Responsibilities:

• Reviewed Functional (MD50), Produced Technical (MD70) design document and Conversion Mapping Document (CV40) for Item Import and Open Sales Order Import.
• Developed Conversion programs, Staging Tables and Customized PL/SQL API for Item Import and Open Sales Order Import.
• Design and developed an interface between Confidential and Confidential for Cash Receipts (Auto Lockbox).
• Involved in Conversion of Customer information in AR
• Customized the Oracle Order Management Transaction workflows.
• Developed Custom forms and added the zoom functionality.
• Developed PL/SQL programs and scripts. Registered concurrent programs, request groups for reports.
• Created Customized Invoice report for client by modifying standard Invoice Report provided by Oracle
• Enabled descriptive flex fields on Sales orders and Invoices to facilitate additional information.

Confidential, Chicago, IL

Responsibilities:

• Involved in Functional Design Review and preparing the Detail Technical Design Documents.
• Involved in Customization of Standard Oracle Reports as per client requirements.
• Involved in Code Review Process to make sure that code is in compliance with AIM methodology,
• Analyzed and designed customer specific forms and reports and implemented. Reports such as ECO changes Report, Item where used Report, Weekly Inventory Report, Inventory Aging Report Etc and Data entry screens like Quick Customer lookup.
• Developed Interface Program for loading Items information from legacy system to Inventory (INV) interface tables using SQL*Loader and PL/SQL and subsequently ran Item Import to populate the Inventory Base tables.