Summary

• Expertise in using Partner Links Such as File Adapter, FTP Adapter, Database Adapter, EBS Adapter, AQ Adapter, MQ Adapter and JMS Adapter for integration and development of custom business processes using Oracle ESB and Oracle BPEL Process Manager.
• Working Knowledge of Business Activity Monitoring BAM and Oracle Enterprise Messaging Service OEMS .
• Expertise in Java, Web Services, XML, XSD, XSLT, XPATH, WSDL, Oracle, JDeveloper, SOAP, JNDI, JDBC and Oracle Business Rules Engine
• Integration of Legacy applications, ERP applications with J2EE applications and PLM/PDM Systems using SOA Suite.
• Familiar with Web Services standards like WS-Addressing, WS-Reliable Messaging, WS-I compliance, and WS-BPEL
• Experience with B2B Integrator to create, manage and integrate trading partners using EDI's.
• Experience in full life cycle implementations, production support, and upgrade of Oracle Applications as a technical and techno-functional consultant includes various Oracle Applications modules like Supply Chain Management OM, QP, WSH, INV and PO , Financials AP, AR, GL, FA and PA and Manufacturing ASCP/MRP, BOM, ECO and WIP , all aspects of Application Object Library AOL and Sysadmin
• Strong design and development experience on Open Interfaces inbound and outbound interfaces , APIs and RICE components Oracle Reports, Interfaces, Conversions and Extensions in Oracle SCM, financial and manufacturing modules.
• Very good experience in preparing functional and technical design documents using AIM.
• Expertise in development, customization and personalization of OA pages using Jdeveloper and OA Framework OAF
• Expertise in creating messages, processes, functions and notification workflows and Customizing Workflows using Oracle Workflow Builder 2.6.
• Proficient in SQL, PL/SQL, UNIX Shell scripting and Oracle 10g/9i/8i.
• Experience in Performance Tuning using Explain plan, tkprof, optimizer hints.

SKILL SET:

• RDBMS: ORACLE 11g/10g/9i/8i.
• ERP/Modules: Oracle E-Business suite R12/11i/11.0.3 OM, QP, WSH, INV, PO, AR, AP, GL, FA, PA, CM, ASCP, MRP, BOM, ECO, WIP, CZ/OCD
• Oracle Fusion: Oracle SOA Suite 11g/10g, BPEL, ESB DB, File, FTP, AQ, MQ, EBS and JMS Adapter , OWSM, OSB, BAM, Oracle Business Rules and ADF
• Lang Scripting: UNIX Shell Scripting, JAVA, SQL, PL/SQL, ANT, HTML, XML.
• Release Eng. Tools: CVS, VSS, PVCS, KINTANA, PPM, ClearCase.
• Development Tools: TOAD, ECLIPSE, JDEVELOPER, Oracle Reports, Oracle Forms, XML Publisher, Oracle Workflow builder
• APP/WEB Servers: Oracle Application Server OCJ4, IBM Websphere, Oracle Weblogic, OA Framework.
• J2EE: JDBC, JSP, Struts, Servlets, ADF
• Operating System: Linux, AIX, Solaris and Windows.

Project Profile:

SOA Consultant

• CONFIDENTIAL offers various kinds of Loans, like Home Loans, Education Loans, Credit Cards etc. The Application ECaR Enterprise Collection and Recovery a Data warehouse Application keeps record of all Loans and its details for all LOB's, It's used by the Collection and the recovery agents to keep track on Customer's loans which help them in collecting and recovering the loans issued by Citi Group.
• CONFIDENTIAL offers credit cards processing and distribution services for Citigroup. The Application is for conducting the daily and weekly basis Text, Email, Letter, Dialer and Auto agent campaigns for collections from various delinquent customers and also for loading the data into the data warehouse tables for reporting purpose

Responsibilities:

• Installed, configured and maintained of WebLogic 11.1.1.6 with Clustering with JDBC, JMS, JNDI, SNMP and J2EE Services. Extensive administration experience supporting Web Logic Server including installation, configuration, monitoring, and understand scripts for shell scripting, WLST Web Logic Scripting Tool and deploying applications.
• Installed SOA 11g components Database server, BAM, OSB along with WebLogic Server
• and as an admin enabled ADF on the WebLogic Server.
• Design and Development of stateless and stateful composites using BPEL, JCA Adapters, External Web services, Oracle Apps Adapters.
• Design and development of OSB proxy services, business services, XQuery transformations, custom XQuery functions, JCA Adapters.
• Troubleshooting SOA composites, OSB projects in production environments using thread dumps, heap dumps, log files.
• Performed analysis and design of business requirements.
• Design BPEL workflows to orchestrate business processes across systems
• Design and develop Human Workflow processes to manage US Steel Order dressing process
• Designed Mediator component EBS by performing thin layer of logic.
• Designed Database Adapters to poll for new records and sync data from multiple systems.
• Designed File Adapters and FTP Adapter to write files/records to servers
• Involved in the configuration of the connection pools and data sources for DB Adapter on the application server.
• POC of OEM 11g grid control and OEM 12c.
• Created Scheduler for BPEL Process.
• Created Error E-mail Notification Process using BPEL.
• Created Queues, Connection Factories, Multi Data sources and Data sources.
• Configured JMS Queues, Connection pools and connection factories to connect to different databases and publish and receive JMS messages.
• Used SOAP for information exchange and accessing web service
• Implemented Abstract and Concrete WSDLs in the partner link to contact some Fusion services.
• Implemented the Error handling frame work.
• Responsible for Integration and Unit testing.
• Deployed to multiple environments using ant scripts.

Environment: SOA Suite 11.1.1.6 PS3 , WLS 10.3.4, Oracle 10g/11g Database, SOAP, JDeveloper 11g. Oracle Applications R12. Oracle Weblogic 11.1.1.5,Appache, Active Direcotory, J2EE, J.Developer 10.1.1/2/3, Top link, UML 2.0, JSP 2.0, XML, BPEL, ESB, SOAP, WSDL, UDDI, HTML, JNDI, CVS, Log4J, ANT 1.5,

CONFIDENTIAL

Oracle SOA Developer/Coordinator

• CONFIDENTIAL is a global biopharmaceutical company with operations in over 100 countries they discover, develop, manufacture and market prescription medicines for some important areas of healthcare.
• Participated in development and coordination of multiple projects to build SOA middleware interfaces to integrate various internal and external applications

Responsibilities:

• Responsible for delivering multiple middleware projects successfully as a developer and offshore coordinator
• Developed order and item service flows to integrate .net systems and external systems using BPEL, Mediator and OSB
• Implemented WS-Security and SSL to all the services.
• Developed Canonical WSDL's and XSD's which can be used across the systems.
• Developed re-submission mechanism to re-submit the failed instances using ADF, BPEL and OSB.
• Used Oracle BAM extensively for all the process monitoring.
• Configured and used various adapters like DB Adapter, JMS Adapter, MQ Adapter, AQ Adapter, BAM Adapter
• Participated in all the design and architectural review meetings to present the solution to the client
• Worked on ALSB Customization file, Config plans and ANT scripts for deploying the OSB and Composite services.
• Coordinated all the efforts with offshore development team in design, build, testing and deployment.
• Used BPM Worklist application for human intervention and to notify business users as per the requirement.
• Used Oracle Business Rules to define rules to identify the third party vendors for the order flows.
• Developed test cases using SOAP UI to perform load testing and analyzed perfrmace of all the SOA services.
• Used various middleware technologies like WSDL, SOAP, XML, XSD, XPath, XSLT, Sensors, Correlation Sets, Parallel processing, Canonical Models, BOD's, DVM, OWSM, OEM and BPM in design and development of the services.

Environment and Technologies: Oracle SOA Suite 11g, Web Logic Application Server, BPEL, Mediator, OSB, Oracle BAM, BPM, OBR, Web Service Manager, JDeveloper 11g, Oracle 11g, PL/SQL, TOAD, ADF, Java ,JSP ,JDBC ,ANT ,XML ,XSL.

CONFIDENTIAL

Oracle SOA Consultant

• CONFIDENTIAL is an integrated steel producer with major production operations in the CONFIDENTIAL The company manufactures a wide range of value-added steel sheet and tubular products for the automotive, appliance, container, industrial machinery, construction, and oil and gas industries.
• Participated in implementation of Oracle E-Business suite to integrate various legacy systems with Oracle EBS

Responsibilities:

• Participated in functional design peer-reviews and worked closely with users to gather business requirements. Prepared technical design documents.
• Coordinated with offshore team to develop several SOA interfaces.
• Designed and Developed Common Error Management Framework SOA Composite for capturing the faulted instances.
• Developed Approval workflow for dressing configurator using BPEL, ESB, Human Task, business events etc.
• Implemented integration between the BPM worklist and Oracle eBusiness Suite users
• Developed several interfaces using Oracle BPEL and ESB in Oracle SOA 10g as well as 11g to integrate different legacy systems with Oracle EBS. Participated in up gradation of SOA 10g to 11g.
• Configured and worked with various adapters like EBS, DB, JMS, MQ, AQ, FTP adapters in SOA environment.
• Configured SOA Suite 11g for Sending E-mail Notifications.
• Design integration of BPEL events with BAM sensors including Alerts
• Implement SOA Suite rules engine to include key business decision logic to be abstracted out of individual services and managed in a single repository
• Securing BPEL services using WS-Security, Username tokens with password digest
• Develop ant scripts to deploy BPEL process across different environments
• Responsible for designing services using XSD, BOD Mappings, XML, XPATH, XSLT, SOAP and WS- standards
• Developed entire shipping solution using Oracle Workflow and custom PL/SQL wrappers and standard API's.
• Worked coordinated on several Change Requests, Service Requests, PT defects in SOA, PL/SQL, and Workflow areas for different components

Environment and Technologies: Oracle SOA Suite 10g, 11g, OAS, Web Logic Application Server, Oracle BPEL Process Manager ,Web Service Manager, JDeveloper, Oracle E-Business Suite R12, Oracle 10g, PL/SQL, Work Flow 2.6, UNIX, TOAD, OAF ,Java ,JSP ,JDBC ,ANT ,XML ,XSL.

CONFIDENTIAL

Oracle SOA Consultant

• CONFIDENTIAL is a global multilevel marketing company which produces and distributes weight management and dieting products, cosmetics, general health and nutrition products through a worldwide network of nearly two million independent distributors in nearly 70 countries
• Responsible for designing, developing and deploying the SOA based interfaces using Oracle BPEL, Oracle ESB between various systems

Responsibilities:

• Attend workshops with the business users to understand requirements
• Define technical requirements based on the business requirements workshops.
• Coordinating with offshore development team to develop new enhancements and resolving issues
• Managed users and roles, monitored plans using oracle BAM administrator.
• Responsible for designing services using XSD, XML, XPATH, XSLT and WS- standards
• Created alert rules for report delivery using oracle BAM studio
• Documented the BAM plans, Dashboards that I have developed.
• Designing, Developing and Deploying structured BPEL, ESB and Java Web Services using SOAP over HTTP / JMS, WS-Addressing, correlation sets.
• Define WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition.
• Develop PL/SQL Scripts for the logging the BPEL Job Details for Audit Trail and managing the BPEL Production Environment by purging the transaction data on timely basis.
• Involved in Configuring the System Properties for Deploying BPEL Process in Process Manager.
• Created new Domains in BPEL Process Manager.
• Implement exception handling BPEL using scope and fault handlers to catch the Runtime Faults
• Human workflow between orchestrated services to facilitate manual interactions.
• Enterprise messaging using Oracle AQ and integrating using AQ / JMS Adapter and Used DB Adapter , AQ Adapter and APPS Adapter for developing the BPEL Processes
• Configure XML Gateway for transaction types, trading partner setup etc
• Define SOA environment release checklists for smooth transitioning.
• Developed and customized different PL/SQL packages for use of BPEL middleware
• Coordinate between onsite and offshore teams including technical mentoring

Environment and Technologies: Oracle BPM, Oracle App Server 10.1.3, JDeveloper, BPEL, XML, Web Services, SOAP, WSDL, Oracle10g, ANT, Oracle BAM, ESB, UNIX, CVS, Oracle E-Business Suite R12, Oracle 10g, PL/SQL, UNIX, TOAD

CONFIDENTIAL

Oracle Apps/SOA Developer

• CONFIDENTIAL is one of the world's leading research-based pharmaceutical and healthcare companies, which produces a wide variety of healthcare products, nutritional drinks, and over the counter medicines with operations in over 116 countries
• Involved in Oracle E-Business Suite implemetnation and integrating it with various applications like legacy systems, Main Frames System, E-Commerce Applications, SQL Server Database.

Responsibilities:

• Author technical designs based on the business requirements for conversions, PL/SQL Interfaces and SOA interfaces.
• Developing Interfaces between various systems Inbound and Outbound using Oracle BPEL and Oracle ESB services with CDM in between.
• Involved in development of BPEL processes to capture the total OM life cycle through interactive voice recording which includes Validate purchaser BPEL Process, validate lines BPEL process, validate payment BPEL process, submit order BPEL process and developed all the backend PL/SQL packages for the whole process
• Enterprise messaging using IBM MQ and integrating using MQ / JMS Adapter
• Used BPEL technical adapters like file, ftp, AQ and oracle apps adapter to integrate various systems with Oracle eBusiness suite
• Design and implement Common Error Handling and reporting using Oracle AQ
• Developed various forms like order header, payment region, order lines Involved in order entry and invoice receipts forms using OAF
• Customized Various OA pages like shipping transaction form, Customer details form in Order Management Module as per the business requirement to add new extensions.
• Worked on Open Transaction Interface for loading of Transaction details from external applications and Feeder systems into oracle INV application
• Worked on Receiving open interface to validate and process receipt data from external application into oracle purchasing
• Converted receipts from receiving systems into the Oracle Purchasing tables to support the AP matching process
• Developed a customized weekly inventory report that gives details of pending orders and available quantity of the items in inventory

Environment and Technologies: Oracle SOA Suite 10g ,OAS ,Oracle BPEL Process Manager ,Web Service Manager, Oracle E-Business Suite 11.5.10, Oracle 9i, PL/SQL, ANT, UNIX, TOAD, JDeveloper

CONFIDENTIAL

Oracle Apps Developer

• CONFIDENTIAL is a wireless entertainment service and cellular telephone company, which offers prepaid, and post paid services with more than 5 million users
• Part of the team developing Conversions, Interfaces, OAF pages, workflows for Oracle EBS 11.5.10

Responsibilities:

• Involved in developing and Review of AIM MD050, MD 070, CV 40 and CV 60 documents for INV, OM, PO and AR module implementation/development.
• Imported Sales Order data from legacy system into staging tables and populated Oracle base tables with the sales order data by running the standard OE ORDER PUB API.
• Worked on Replenishment open interface to import replenishment requests from external systems into oracle inventory application.
• Responsible for Development and Implementation of Item, Item Category Conversions using Standard Item Import Program
• Developed custom interface programs for validating and inserting the On Hand Quantity data into interface tables. Scheduled a standard API to load data into the target base tables.
• Designed and developed interface program to capture shop floor data through a custom API process.
• Worked on material reservation public API that allows you to create, update, relieve, transfer, query and delete the Material Reservations for an Inventory Item, using several procedures.
• Worked on Requisitions Open Interface to import requisition details into PO application
• Worked on Purchase documents open interface to import and update Price/Sales Catalog information and also imported Standard Purchase Orders from a Legacy system
• Customized the OM Order line workflow to send the customer notifications when the SR/WO is closed. As part of this multiple notifications/messages/functions/wait were developed and used
• Developed a custom workflow in Order Entry to keep track of the sales order and sending the notifications correspondingly when the order is full filled
• Developed XML Reports using XML/BI Publisher in various modules based on existing oracle reports
• Developed a PL/SQL package which generates XML data to print a delivery note for shipped orders for various countries using OPTIO
• Developed PL/SQL Interfaces for change order synchronization and XML generation package which generates the XML file for that order in Order Management Module.

Environment and Technologies: Oracle EBS 11i, Oracle10g, ANT, UNIX, CVS, OAF, TOAD, OPTIO, PL/SQL, Oracle Reports 6i, JDeveloper