SUMMARY

• Over 10.0 years of experience which includes working as SOA(Service Oriented Architecture) Architect working on BPEL, Oracle Service Bus (OSB) Human Task, integration with Java Technologies, Web services, Fault Handling, BAM, B2B Oracle ERP Techno - Functional Consultant working on implementation, upgrade and production Support projects.
• Expertise in Developing BPEL process with SOA,B2B, JNDI, Oracle BAM, Routing using Enterprise Service Bus (ESB) for integrating ERP applications (Oracle Applications, PeopleSoft), various Web services, Databases, legacy applications
• Expertise in developing and deploying BPEL Processes using technology adapters (Oracle Applications, JMS, MQ, AQ, DB, Fil e and FTP Adapter) Using Web logic Server
• Expert in 11i and release 12 Oracle Applications (GL, AP, AR, PO, OM, INV,BOM, WMS, Costing, WIP, Projects System Administration, Workflow, Oracle Applications Programming Interface (API’s), Custom PLL and Open Interfaces) and Oracle Workflow Builder.
• Worked extensively on BPEL, Human Task, data conversions, data Migrations, Customization of Forms, Reports, OA Framework and coding Interfaces.
• Experienced in working with Oracle Service Bus involving in creating Proxy and Business Services
• Good Working Experience in JDeveloper, Pl/Sql Developer, Oracle10g/9i/8i/7.3, Forms 4.5/5.0/6i, Reports 2.5/ 3.0/ 6i, PL/SQL, SQL, SQL*Loader, External tables, Pro*C, Data Loader.
• Strong knowledge on Oracle ADF (Application Development Framework) creating EO,VO, Task flows to create custom ADF Pages
• Experienced in Developing Custom Forms, Custom Reports and registering them as Concurrent Programs in Oracle Applications 11i.
• Experienced in complete Software Development Life Cycle (SDLC) including Requirement Analysis, Design, Development, Testing and deployment.
• Extensive experience in writing PL/SQL Packages, Stored procedures, Triggers and Functions.
• Very good knowledge of AIA including standard AIA PIPs, Design Patterns, Concept of Business Objects along with Foundation Pack
• Strong with Application Object Library (AOL) module and expert in System Administrator and Applications Developer responsibilities such as Creation of Users, Responsibilities, Functions, Menus, Request Sets, Value Sets, Flex Fields and Profile Options.
• Expert in writing UNIX shell scripts.
• Very good hands on experience with Oracle Discoverer which includes report development, Discoverer Administration, configuring Discoverer and End User Layer(EUL).
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
• Excellent track record in demonstrating strong analytical and problem solving skills, computer proficiency, and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

• Oracle SOA Suite 11g
• OC4J
• BPM
• Web logic Web Services (9.2/10)
• ESB
• OWSM
• BAM
• B2B
• Oracle ERP
• Jdeveloper
• SQL*PLUS
• SQL*Loader
• PB
• Oracle 9i/10g
• MS
• Developer 2000/6i
• SQL
• PL/SQL
• C
• Pro*C
• C++
• Java
• UNIX
• Linux
• MS-Dos
• PVCS
• SQL Navigator
• TOAD
• MS Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Oracle Apps SOA Consultant

Responsibilities:

• Designed and developed the entire B2B Project using Oracle B2B, SOA and XML Gateway for 850,860,865,855,856 and 995
• Created the new Agreements, Partners (B2B), Custom Schemas and Mapping Documents.
• Created SOA Composites using B2B, JDBC adapters, Oracle APPS Adapters, Custom PLSQL Procedures to validate and process the appropriate messages
• Created complex BPEL Processes with real-item exception notifications and exception handling
• Used Business Rules, DVM’s extensively to make the composites more scalable and modular
• Worked on XSLT, XPATH XQUERY for mapping of external EDI Messages to Oracle Applications
• Worked on XML Gateway setups to handle the inbound and outbound messages via trading partner setups and create custom procedures for triggering the appropriate messages
• Organized the Technical and Functional Designs with the entire team both in-house and through vendors to discuss the limitations and best practices for the implementation and also go-live support
• Extensively worked on Mobile Customizations creating new Pages / using CustomListiner classes to handle the user requirements
• Create Custom Rules, Strategies, and Advance Wave Criteria’s per complex SQL’s business requirements.
• Worked on customizing ASCP hook to in- corporate Serial Number assigning to Work orders
• Worked on creating multiple scripts during Pre-go live ranging from deleting/Creating locators, sub-inventory transfer scripts, updating Cost groups etc.
• Worked on multiple reports using XML Publisher/Oracle Reports to support the day-today requirements
• Extensively worked on documenting the work using MD-70/MD120 etc. per companies’ standards.
• Worked on creating a new ADF Pages for users on shipping floor, manufacturing line to search for the games staged in different locators and the shipping dates for each game.

Environment: Oracle Applications INV, BOM, WMS, Costing, WIP,SOA Suite 11g, Jdeveloper 11.1.1.7.0 , BPEL,, Mediators, Adapters, ADF, Java, XML, XSD, SQL, PLSQL, Java, Unix

Confidential, NJ

Oracle SOA Consultant

Responsibilities:

• Analyzed and re-designed around 90 existing JPD’s into BPEL processes. This involved in fine tuning and incorporating SOA-features to improve the performance.
• Developed new OSB Projects for Upstream and Downstream systems (Ex: Switches, UI) which were the entry and exit channels for the Provisioning System by creating the Proxy and Business Services.
• Extensively used File, Database, JMS, EJB, FTP Etc Adapters to communicate with the Systems both internal and externally
• Worked extensively on Web Services, BPEL Transformations, Creating Schema objects from Java VO’s, Logging Services.
• Designed and developed custom Fault Handling mechanism which suited the BPS system.
• Developed Scheduler system using Quartz Scheduler to kick off few BPEL Processes on timely fashion
• Worked extensively on Database developing PL/SQL Packages, Query by Examples, Complex SQL Queries and using them with Database Adapter and was also involved in Fine Tuning some of the existing pieces.
• Was involved in improving the BPEL performance by changing some of the Administrative parameters which brought down the BPEL execution time
• Worked on Debugging the Java Controls which were exposed as EJB Services.
• Worked on Documenting the Design and implementation of the BPS Project and was also involved in educating the Customer with new System and explaining them the Advantages of Oracle SOA Suite.
• This Project involved on working with over 3000 Test cases and I was efficiently involved in successful completion and migration.

Environment: Oracle SOA Suite 11g, Jdeveloper 11.1.1.6, BPEL, OSB, Mediators, Adapters, Java, XML, XSD, SQL, PLSQL, Java, Unix

Confidential, SFO

Oracle SOA /Apps Consultant

Responsibilities:

• Re-created BPEL composites to include BAM adapters so as to enable the Logging feature and created BAM web services which will be used for logging purpose in all the EDI Transactions.
• Designed and Developed new EDI 943 which would send Outbound message to the EDI Partners
• Developed Custom Email Alerts from BAM for any Inventory related errors.
• Used various adapters like B2B, File, Database, Oracle Apps, BAM etc.
• Configure Oracle B2B Partners and Agreements to enable Relationship.
• Re-Design and Develop B2B Views in Database to avoid huge execution times when getting Oracle ERP data.
• Worked on Custom Workflows, Reports to fix the bugs and enhancements as per Business needs
• Fixed the Bursting Control Reports which were running into errors for the past 1 year, as part of bug fixing.
• Documented by analyzing all the custom objects the Client has, as the implementers missed given them.

Environment: Oracle SOA Suite 11g, BAM, B2B, BPEL, Mediators, Human Task, Adapters, Oracle ERP (Release 12.1.3), SQL, PLSQL, Java, Unix, TOAD, JDeveloper

Confidential, MA

Oracle SOA /Apps Consultant

Responsibilities:

• Created multiple BPEL processes to orchestrate the Order process starting from receiving the Order to Calling OE ORDER PUB API in Order Management
• Used File Adapters extensively to read the cXML documents sent by the External Client.
• Created a Web-service which is used to send the Message to ARIBA and SCIQUEST
• Used Human Task (Email) to send appropriate Emails to the client in case of exception and also order confirmation.
• Created Java Servlet to read the CXML input which comes as an HTTP POST request. Fine tuned the Servlet to read the XSD only once for each session, to improve the performance.
• Created Dynamic and lookup based code to help the customer customize for a new client in future, this includes the SHIP TO, BILL TO lookups
• Extensively worked on XML and XSD to get the correct one to use for the cXML type message.
• Created Oracle Concurrent Programs which can be scheduled to generate the Order confirmation and Invoice for each orders that comes in as a cXML from the External client
• Worked on using the Sensors to keep track of the BPEL flow.
• Used Java-Embedding when necessary during the BPEL flow to post the messages to external Clients using HTTP POST.
• Documented a clear MD-70 to detail all the technical design for the Project.

Environment: Oracle SOA Suite 11g, BPEL, Human Task, Adapters, Oracle ERP (Release 12), SQL, PLSQL, Java, Unix, TOAD, JDeveloper

Confidential, Las Vegas

Oracle SOA /Apps Consultant

Responsibilities:

• Imported Orders into OM using BPEL process by using Public API’s and customer packages.
• Extensively used File and Database Adapters for Handling and Massaging of the data
• Exposed Custom Oracle Packages as Web-Services using SOA suite.
• Implemented Error Handling for all the Applications to Properly handle all kinds of Exceptions
• Involved to Defining WSDL for BPEL process, Partner Links, and developing business logic and created Events and time outs for the BPEL process activity
• Errors which need Human Intervention were handled using Human Task created which would automatically send E-mails as needed.
• Used Pick and OnAlarm Services in BPEL as needed.
• Worked on complex Oracle Reports 6i with XML Publisher, to customize many reports for the client such as Freight Summary, Order Summary, Booth - Check Reports etc.
• Developed a Custom Form Customer Balance History which consolidated all the Sales Orders, Invoices, Receipts Adjustments for a customer for any given show. This involved creating a Search window having complicated and dynamic logic which defines the resulting rows as output.
• Worked on Oracle Workflows to accommodate new organizational changes as per clients requirements.

Environment: Oracle SOA Suite (10.1.3), BPEL, Human Task, Adapters, Oracle ERP (Release 12, 11i), SQL, PLSQL, Java, OAFramework, Unix, TOAD, JDeveloper, Developer 6i.

Confidential, Plano, TX

Oracle Applications Consultant

Responsibilities:

• Designed and created complete BPEL Processes for orchestration using different process activities using Oracle SOA Suite 10.1.3.4.
• Extensively used File Adapters and Database Adapters in the system to move data processed dynamically.
• Configured Human Workflow for generating emails and approval notifications as needed by client.
• Designed and defined exception handling. Created Error logger process for error logging and Error Handler Process for resubmitting the error messages to respective processes.
• Built the required ESB infrastructure for this implementation which involved mappings and transformations of the data.
• Created custom Faults and also handled Remote fault to notify them to appropriate users.
• Developed custom JSP pages for user-interaction on top of a Legacy Application to validate and process data in real-time mode communicating with Oracle Applications database.
• Developed Backend Code using PL/SQL to perform Custom tasks, such as Search, Delegations etc.
• Used External Tables extensively to load data from external files during Bulk Upload of Data.
• Integrated Custom Oracle Workflows for the Approval Management of the Adjustments created.
• Created custom Forms and Registered into Oracle Applications GL and AR.
• Developed Reports using XML Publisher, Oracle BI for the Business.
• Performed SQL Tuning to many existing programs to improve the performance.
• Created numerous Concurrent Requests, for programs developed.
• Developed Backend Procedures to in corporate new functionality of Delegations Custom P&L Tool currently being used by Confidential &T for Profit and Loss Adjustments.

Environment: Oracle SOA Suite (10.1.3), BPEL, Human Task, Adapters, Fault Handling, Oracle ERP (Release 12, 11i), SQL, PLSQL, Java, OAFramework, Unix, TOAD, JDeveloper, Developer 6i, Oracle BI.

Confidential, St. Louis

Oracle Applications Technical Consultant

Responsibilities:

• Worked on Project Approval Workflow (PAPROWF) and Project Change Order Workflow (PAWFCISC) to customize it from end to end.
• Re-designed Lawson to Oracle HR Interface as per the user requirements.
• Customized the Project PO Requisition Account Generator Workflow extensively to in corporate new requirement to involve Projects in requisitions.
• Create a new GL COA Mapping Interface and CM to GL Interface for MCF.
• Involved in Creating an BES interface which to upgrade the existing MCBS system.
• Used JDeveloper to perform OA Framework Extensions to Controllers and View Objects.
• Customized Custom.pll to in corporate zoom functionality for AP Fishes for Belgium Localizations.
• Created Bank Statement Loader- Corporate program which is run on a daily basis to upload the electronic bank statements from JPMC into Oracle Cash Management.
• Involved in modifying many custom views, to improve the performance while utilizing the features of 10g during upgrade.
• Implemented many code fixes, enhanced workflows, in modules such as GL, AR, AP, Projects, CM, as per user requirements for enhancements.
• Involved in many fixes for the Folders in Discoverer, along with improving the performance of the views behind by tuning.
• Developed many reports using Oracle Report Builder along with XML Publisher and also CSV reports using PLSQL.
• Created many Data fix scripts, to be implemented in Production as per Confidential standard rules.

Environment: Oracle Apps 11i, GL, AP, AR, PO, CM, Projects, Project Costing, Resource Management, Project Billing, Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, JDeveloper, TOAD.

Confidential, Washington, DC

Oracle Applications Technical Consultant

Responsibilities:

• Analyzed and Documented Premium Calculation Program with data flow diagrams.
• Designed and documented functional specification (MD 60) document for Interface.
• Involved in Designing the MD70 Technical specification Document.
• Used SQL loader and developed PL/SQL programs to load data from PAS Legislative System to Oracle Staging Tables.
• Wrote Pl/SQL scripts to develop interfaces between Staging Tables and Oracle Tables for a custom Responsibility.
• Worked on Oracle API’s to complete the transfer from Staging to Oracle Base Tables
• Worked on Workflow Builder to change the Approvals Criteria in AP Invoice Approval Workflow
• Customized the Custom.pll file to make changes in Forms as per the Clients requirement.
• Designed an inbound and outbound interface between Oracle Financials system and existing legacy system.
• Designed and Developed Customized Reports and Interface programs as per client requirements using XML Publisher
• Developed Custom Forms, Shell Scripts and SQL Scripts and registered them in Oracle Applications.
• Appropriate changes were made in this program to reflect 2007 legislative changes for VRP.
• Tested the changes in CDE-T, ITC environments.
• Supported PAS Pre-processing in CDE-I, CDE- T and ITC environments.
• Worked on the Architectural Diagram for PAS interfaces in ITC and Production.

Environment: Oracle Apps 11i, GL, AP, AR, PO, OM Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, Unix Shell Scripting, TOAD.