PROFESSIONAL SUMMARY:

• Expertise in implementation using Business Process Execution Language (BPEL),Business Process Management (BPM) and Good knowledge on Enterprise Service Bus (ESB), Oracle Service Bus (OSB) Administration and troubleshooting on Windows.
• Hands on experience on with File Adapters, AQ Adapters, MQ Adapters, DB Adapters and Java Messaging Service (JMS) in BPEL processes.
• Cross application integration using adapters, File Adapter and DB Adapter, FTP etc.
• Excellent knowledge of Web Services, SOAP, WSDL, XML, XSLT, XPATH, HTML.
• Exposure in Oracle Web Service Manager (OWSM) and Business Activity Monitoring (BAM).
• Extensive experience with design, development and deployment of business process integration using Oracle SOA - Fusion Middleware, BPEL (Business Process Execution Language), OSB (Oracle Service Bus).
• Implemented Oracle Service Bus(OSB) for messaging services, connecting to database and for creating Proxy over existing web services and used Transformations and Validations before Persisting Business Services to endpoint
• Good Exposure on WSO2 and proficient in ESB and SOA Concepts.
• Migration experience from SOA 10g to SOA Suite 11g (Oracle Web logic Server Administration console, Oracle Enterprise Manager Fusion Middleware control)
• Exposure in Oracle Applications 11i Oracle Financials (AR, AP, GL) modules of Oracle Applications 11i in multi Org, multicurrency environment
• Exposure in Oracle Application customizations including Forms, Reports and Concurrent Programs.
• Hands on experience with several databases like Oracle, SQLServer, MySQL.
• Experience on application/web servers like WebLogic 7/8, Oracle Application Server 10g.
• Experience in writing ANT build scripts to automate the compilation, creating directory structures, generate classes from WSDL, deploy the services onto the Web Server, and generate JAR and WAR files.
• Good experience in PL/SQL, SQL, writing stored procedures, triggers, functions, packages and exposed to various databases.
• Good experience in understanding and designing solutions for complex integration scenarios.
• Ability to work in a team environment and as an individual with strong technical and communication skills, and good zeal in adapting new technologies in a fast paced environment.
• Very good in performing Root-cause analysis, Requirement analysis, Business process mapping, Issue identification/resolution.
• Excellent understanding about ANSI X12 EDI standards and have experience in using Oracle B2B document editor.

TECHNICAL SKILLS:

Operating System: Windows 95/98/2000/XP/Vista/7.

Databases: Oracle 8i/9i/10g/11g, SQL Server, MS Access.

Middleware: Oracle SOA Suite 11g/10g (BPEL, ESB, OSB).

Application Server: WebLogic 9.2/10.3.1/2 ;Oracle Application Server 10.1.3.1/10.1.3.3 , Apache, Tomcat.XML XML, XSLT, SOAP, HTML, UDDI, XSL, HTTP, JMS.

Web Services: WebLogic, WebSphere.

IDE: TOAD, SQL Developer, Eclipse, SOAPUI.

Languages: Java, C, PL/SQL,MSSQL.

WORK EXPERIENCE:

Confidential, Winston - NC

Oracle Soa Developer

Responsibilities:

• Involved in proof of concept (POC), and developed a model with BPEL Partner links, XSD, WSDL.
• Plan and conduct unit and integration testing including test case documentation.
• Configured various Adapters including Database, AQ and Email notification services.
• Designed and developed a framework for fault handling in BPEL processes, Java classes and PL/SQL APIs in the project.
• Developed an authentication process for workers and integrated with Rules Engine.
• Designed and developed a BPEL process with multiple operations to search, to load list of values (LOV) from Oracle and deployed in ESB to route PL/SQL procedures based on Search Type and other criteria.
• Created many of Business service using Oracle Service Bus (OSB) and used OSB to create Proxy service.
• Worked on complex XQUERY and XSLT transformations to transform internal applications schema to external schemas.
• Developed routing tables for dynamic connections to external heterogeneous web services.
• Design, develop, and deploy the integration BPEL/mediator processes in IDE tool Jdeveloper.
• Developed custom SQL to purge the BPEL instance data from the SOA dehydration store, for ease in maintenance.
• Used XSLT mediation which allows mapping data from one message type to other.
• Developed a template for the emails sent by BPEL process manager in Plain Text and HTML to the Human flow task.
• Tested the web services using Soap UI, BPEL Console and Test Suites.
• Involved in peer-reviews of BPEL processes to cross-check the functionality.
• Involved in the deployment of BPEL, Mediator and ESB services on to the production server.

Environment: Oracle SOA Suite (11.1.1.6), Oracle SOA Suite 10.1.3.3.0 , WSDL 1.1, SOAP 1.1, XML, XSD, DTD, XSL, SQL Navigator 5, Oracle JDeveloper 10g, IBM Rational, Lotus Notes, Altova XMLSpy, Dimensions 9.1, MS Office 2003, Windows XP.

Confidential, Plano, TX

Oracle Soa Consultant

Responsibilities:

• Analyzed the business requirement and provided technical Solution for the interface.
• Designed the end to end flow based on Business requirement.
• Created AIA Interfaces for using Human Work flow and Configured Exception Handlers in BPEL Processes to call the AIA Error Handling Interfaces to provide customized User Notifications in case of errors
• Created Queue, Connection Factories & JNDI in WebLogic server.
• Configured JMS adapter to queue large order messages and configured service instance monitoring properties in the WebLogic server console.
• Configured sync max time out property while using synchronous process within the flow for authentication purpose.
• Used WSDL to invoke the API of the Partner system and validate user Authentication.
• Worked with WebLogic server console to configure JMS module to set up sub-deployment, SOAJMS module as Target server
• Deployed the applications using Ant script to WebLogic server.
• Created MDS repository to store all XMLs and WSDL files
• Leveraged existing Notification system and configured users to send email notifications on AIA framework.
• Configured HTTP binding adapter to Post (request-response) configurations to receive/send PO from (partners)
• Worked with EM console to extract payload in case of system failure or memory loss and configured Payload extraction, Retry mechanism, Instance Id search

Environment: SOA 11.1.1.3, WebLogic server, Jdeveloper 11.1.1.5, AIA, SOAJMS, ANT Script, HTTP Binding Adapter, EM Console.

Confidential, Nashville, TN

Oracle SOA Developer

Responsibilities:

• Responsible for gathering business requirements from business analysts and technical team.
• Designed and developed the technical and functional documents
• Used Mediator for routing rules, transformation and for filtering.
• Developed custom XPATH functions in mediator for transferring messages.
• Developed and designed BPEL Processes.
• Developed an Order project prototype using Mediator to process and transform complex business process by using different components like JMS, MQ Adapter, SOAP Adapter, File Adapter and DB Adapter.
• Wrote business rules on database side.
• Developed complex schemas and XSLT transformations to read, enhance and process incoming data and map it to E-business Suite Web Service Schemas.
• Implemented BPEL processes for invoking a number of services.
• Developed test cases and scenarios for different operations of BPEL service access points.
• Used JDeveloper for designing and development of integration process.

Environment: Oracle SOA Suite 11g, WebLogic Server, JDeveloper, Oracle Database 11g, BPEL, Mediator, XML, XSLT, XSD, SOAP, MQ, File and DB Adapters, WSDL, Business Rules, Web services.

Confidential, Itasca, IL

PL/SQL Programmer

Responsibilities:

• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages. Features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated.
• Developed SQL Applications for extracting the data from the Oracle tables. Used Oracle SQL*Plus tool for running SQL scripts containing statements and qu0eries
• Wrote triggers, menus and stored procedures in PL/SQL
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• Wrote triggers and packages by using PL/SQL for giving security privileges.
• Used Oracle Forms 5.0 was used to design and develop the interface for the system.
• Created Reports like Ledger, Profit and Loss statement, Balance Sheet and Trial Balance.
• Used Forms 4.5 to create Group, Ledgers, Vouchers and Bank Reconciliation statements
• Created front-end procedures and functions with Forms 5.0 to calculate reorder level and reorder quantity.

Environment: Oracle 10g, PL/SQL and Developer 2000(Forms4.5.0, Reports 2.5).

Confidential

PL/SQL Developer

Responsibilities:

• Team member in development of an in house MRP package to integrate Material Procurement, Inventory Control, Spares Management, Preventive Maintenance Planning Module and Production Control System Projects.
• Developed various reports using Reports Builder and PLSQL: Manpower Forecast and Planning, Daily and Monthly Production, Goods Receipt Note, Inspection Report, Acceptance & Rejection Reports, Issue of Material, Material Utilization.
• Worked on fine-tuning of SQL queries and PLSQL procedures for improved performance. Utilized Explain Plans to analyze and SQL Hints where ever required.
• Customized the ‘OM: Generate Cost of Goods Sold Account’ Workflow to generate the COGS account that meets the business requirements.
• Developed Various Reports in GL, AP and AR and customized them using XML Publisher.
• Customized existingDunning Reportand Invoice PrintingReport in Accounts Receivables usingXML/BI Publisher.
• Customized various reports in Order Management, Inventory and Shipping. Some of them are Pack List, Bill of Lading, Sales Acknowledgement Report, Order Holds Report, Delivery Detail Report.
• Involved in writing stored procedures in PL/SQL to validate, select, insert and update data in material procurement module. Material procurement module enables shop floor engineers to requisition and procure items involved in production and maintenance of machinery from central stores as well as from company vendors.

Environment: Oracle Apps Release 11i (11.0.3/11.5.8 ), Oracle Database (8i/9i), SQL*Plus, SQL*Loader, Forms 10g, UNIX, TOAD, Discoverer 10g, Reports 10g, BI Publisher/XML Publisher, SQL DEVELOPER.

Confidential

PL/SQL Developer

Responsibilities:

• Study and design of entire system.
• Design of the overall database using Entity Relationship diagrams.
• Installed Oracle 10g Database; was involved in gathering requirements for DB design
• Was involved in creating the Application Schemas, Table, Indexes and Views
• Wrote PL/SQL packages, Shell and PERL scripts to monitor the growth of the DB and collect statistics
• Worked closely with C/C++ programmers for developing programs to call the PL/SQL packages
• Troubleshoot DB problems and also involved in Performance Tuning
• Made changes to Oracle Apps Forms and Reports using Designer/Developer for testing purposes
• Used Oracle SQL*Plus tool for running SQL scripts containing statements and qu0eries
• Wrote triggers, menus and stored procedures in PL/SQL
• Data loading and Extracting function using Oracle SQL Developer.
• Designed and developed all the Tables, Views for the system in Oracle.
• Designed and developed forms, validation procedures for query and update of data.

Environment: PL/SQL Developer, TOAD, C, C++, Java, Oracle Proc*C, Java Database Connectivity (JDBC), SQL Scripts, PL/SQL packages and stored procedures, Perl, Shell scripting, Linux, Oracle Forms and Reports.