SUMMARY

• Twelve years of IT experience and expertise as a Techno Functional Consultant in Oracle SOA Suite 10g/11g (Oracle Fusion Middleware), Oracle Database 11g/10g/9i, Oracle Applications R12/11i.
• Proficient in database management, front end development and in Service Oriented Architecture - Middleware with good experience in Agile methodology.
• Experienced in implementing Service Oriented Architecture components such as BPEL, ESB, OSB and BAM (Business Activity Monitoring)
• Proficient in WebLogic Admin work like Server Maintenance, Various JNDI resource creation, MDS maintenance, Admin patch implimentations.
• Experienced in implementing BPEL process activities and services like Human Task, Flow, FTP adapter, AQ adapters, MQ adapters, JMS adapters and Java Web service in BPEL processes.
• Good understanding of SOA with the middleware technologies with Oracle Application Server, BPEL (Business Process Execution Language) process manager for application integration.
• Experienced in developing OSB routing processes and monitoring them from OSB console.
• Experienced in setting up JNDI locations for DB and FTP standalone adapters using Oracle Application Server Console.
• Documented, designed and developed inbound and outbound interface programs using JDeveloper 11g, Oracle BPEL, ESB and BAM.
• Experienced in System Administration, registered forms, functions, menus, sub-menus and customized responsibilities, worked on segregation of duties process.
• Proficient in XML and XSL transformations along with schema definition.
• Proficient in developing Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Proficient in developing Packages, Classes, Methods and other Core Java Skill sets.
• Experienced in customizing new and existing Forms and Reports according to client specifications to suit improvised business processes.
• Experienced in UNIX shell scripting and Workflow Customization.
• Experienced in planning, estimation, presentation and developing design documentation using the AIM Technique, MS Visio, MS Project, etc.
• Handled production support activities and interacted with users of different nationalities.
• Experienced in migrating code from instance to instance using version control software Rational Clear Case and Rational Clear Quest.
• Knowledgeable in year end and month end closing procedures.
• Possess Strong Analytical and Comprehensive problem solving abilities, coupled with self-motivation and result oriented collaborative thinking.
• Knowledge of Project Billing and Project Costing.
• Able to plan, monitor, support and deliver on time while within the budget in high pressure environments.
• Excellent verbal communication and inter-personal skills at the technical and user level.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i/8i, MS SQL 2005, 2008, MYSQL, DB2, MS Access

Middleware: Oracle SOA Suite 11g/10g (BPEL, OSB, Mediator, BAM, ADF, B2B ) (Oracle Fusion Middleware)

DB Modules: GL, AP, AR, PO, CM, OM, OPM, INV, SYSADMIN, AOL, SCM, BRM

CRM: SIEBEL UCM

Languages: SQL, PL/SQL, T-SQL, XML, Java,, UML C, VC++

Operating Systems: UNIX (Sun Solaris, AIX), LINUX, Windows (98/NT/XP)

Software Tools: Toad, SQL*Loader, Data Loader, Discoverer 2.5/4i/10g, APEX 3.0, MS Project, MS Office, Visio, JDeveloper 10/11x, Eclipse

GUI’s/Utilities: Oracle Forms 10g/9iAS/6i/4.5, Oracle Reports 10g/9iAS/6i/2.5, FSG, ADI, Workflow 3.0, XML/BI Publisher

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Oracle SOA/OSB/BAM Lead (Fusion Middleware)

Environment: Oracle SOA Suite 11g, Oracle BAM 11g, OSB, Oracle Database 11g, Oracle EBS 12.1.3, Weblogic Server 10.3.6, Jdeveloper 11.1.1.7.0, PL/SQL Developer, OEPE Eclipse 4.3.1.

Responsibilities:

• Responsible for design, development and implementation of EBS Integration (AP module) with Medidata, IMPACT, IBMRivermine Systems.
• Responsible for the design, development and implementation of SalesForce integration with Enterprise Data Warehouse.
• Responsible for design, development and implementation of Siebel UCM integration with TRIALMD (Dotnet Application)
• Responsible for OIM (singlesign on) integration with PeopleSoft for role sync service.
• Responsible for design and development of DataObjects and Reports for generating various integration reports using Oracle BAM
• Developed composites with various adapters like Database Adapter, File Adapter, JMS Adapters, and Web Service Adapters as per the requirements.
• Developed services using OSB with complex flow.
• Developed Complex XSLT & XQuery Transformations
• Written complex XSD and WSDLs as per the requirements.
• Responsible for the Migration of Development code across various environments.
• Involved in testing the applications with QA team.
• Involved in most of the day to day WebLogic Admin works like JMS, Database, FTP, BAM jndi creation.
• Involved in Dev, Test Server maintenance works in Unix
• Responsible for the development of Error Handling framework which stores the data in and email to the required end users.
• Responsible of communication with Oracle Managed Cloud Service for various production activities using SR and RFCs.
• Responsible for documentation of all the developed applications using BPMN 2.0 notation
• Involved in Production support and responsible for troubleshooting application.

Confidential, Herndon, VA

Oracle SOA Lead, Java Developer (Fusion Middleware)

Environment: Oracle SOA Suite 11g, OSB, Oracle 11g, Weblogic Server 10.3.6, Jdeveloper 11.1.1.6.0, PL/SQL Developer, OEPE Eclipse 4.3.1.

Responsibilities:

• Responsible for design, development and implementation of Broadband Provisioning system using Oracle SOA and Java spring applications.
• Responsible for the design, development and implementation of complex business orchestration in SOA BPEL 2.0.
• Developed composites and BPEL process with various adapters and activities respectively.
• Implemented complex XSL transformations.
• Implemented Error Handling framework for the above mentioned BPEL processes.
• Baseline creation and development of BCP migration process in Java.
• Implemented JDBC connection and DB helper Classes for the IMS migration.
• Migrated Java code between different versions.
• Maintenance of SVN code repository for the code development codes.
• Involved in development of test cases for the IMS Migration process.

Confidential, Mclean, VA

Oracle SOA / OSB Lead (Fusion Middleware)

Environment: .: Oracle SOA Suite 11g, OSB, Oracle 11g, Weblogic Server 11g R2,Jdeveloper 11.1.1.6.0, PL/SQL Developer, Oracle Data Modeler, ERVIN and XML/BI Publisher, Maven

Responsibilities:

• Responsible for design, development and implementation of Enterprise service for Risk management department in OSB.
• Responsible for the design, development and implementation of transformation service using SOA BPEL.
• Developed File adapters and Database adapters and complex transformation in BPEL to move the data from flat files to database.
• Implemented Error Handling framework for the above mentioned BPEL processes.
• Developed Proxy Service and Business services for various purposes to achieve the above mentioned OSB enterprise application.
• Developed Proxy services with complex flow, which includes most of the components in the stage.
• Implemented the Error Handling for each and every Stage as per the business requirement.
• Developed XQuery Transformation and used them the proxy service.
• Configured the security policy to the services and implementation of logging services.
• Developed Business Service for various purposes like publishing messages to Topic or Queue or writing on a file.
• Used various adaptors like File Adapter, Database Adapter and JMS Adapter in the OSB.
• Responsible for maintenance of Clear Case for the code checkins.
• Responsible for the transfer of development code between Dev environments to various other environments like test, perf, UAT.
• Maven scripts and configuration plans were used to move the code between the various developments, test.
• Responsible for production deployment plan document and final deployment.
• Responsible for the development of Maven commends to make the deployment simpler.
• Involved in development of test cases for the mentioned enterprise service.

Confidential, Burlington, VT

Oracle SOA Lead Developer / B2B Developer

Environment: Oracle SOA Suite 11g, Oracle 11g, SIEBEL 8.2, Web logic Server 11g R2, Jdeveloper 11.1.1.6.0, SQL Developer, Oracle Data Modeler, ERVIN and XML/BI Publisher

Responsibilities:

• Responsible for design and development of integration methodology between SIEBEL and One Gate using Oracle SOA as Integration layer.
• Developed SOA Process and B2B Process to integrate various Healthcare providers with the customers.
• Design and Development of Integration solution for Invoice Interface for the Benissance who processes the money using 834.
• Design and Development of Interface for B2B adaptors including the creation of 834 & 820 files.
• Responsible for the integration of B2B processes with various carriers.
• Written various Schema (XSD) files as per the requirements for BPEL and other components.
• Prepared mapping documents according to company standards.
• Designed complex composites and BPEL process as per the business requirements.
• Designed an Error Handling Framework to handle exceptions across different integration systems in Oracle SOA.
• Deployment of the BPEL process in integration server for integration testing, QA server for QA testing and in Production environment.
• Documentation of all the components developed using Oracle AIM Methodology
• Responsible for the code migrations between various environments like SIT 1, SIT 2, UAT and production environments.
• Responsible for the development of all oracle objects like functions, procedures, packages, triggers, etc.., related to migration and integration environments.
• Responsible for performance tuning in application level as well as database level.
• Responsible for documenting the Integration process in BPMN 2.0 standard notations.

Confidential, Irvine, CA

SOA Lead Developer / Oracle Database Architect

Environment: Oracle Applications Release 11.5.10.2 (AP, GL, AR, PO, Inventory, OPM), Oracle 10g, Oracle SOA Suite 10g/ 11g, BPEL, OSB, BAM, Jdeveloper 11g, IBM WebSphere, TOAD and XML/BI Publisher

Responsibilities:

• Responsible for design and development of integration methodology between Honeywell POMSnet and Oracle MES for weight and dispense of materials.
• Developed various BPEL and ESB interfaces to send the Material Master, Formula and Recipe, Batch information to POMSnet.
• Developed integration frame work with IBM WebSphere.
• Developed business events for each of the interfaces to trigger the event and routed the process to kick off the particular outbound transaction.
• Used JMS adapters and Java web services to write the messages on to the JMS queues.
• Developed data model as per the requirement in both OLTP as well as OLAP environments.
• Developed star schema in OLAP environment for various reporting purpose.
• Developed the underlying PLSQL packages, Views and triggers related to the interfaces.
• Developed interfaces for handling Batch Step Complete, Batch Ingredient Allocation and Inventory adjustment transactions from POMSnet to Oracle.
• Designed and developed a sequencing logic to make the transactions sequential as they are interdependent on each other.
• Enhanced the existing Fault Handling application to fit the need of the requirement.
• Developed an email bursting report to notify the concerned persons about the errors.
• ESB is used to route the processes from the triggering event.
• Responsible for preparing TDS (Technical Design Spec) for all the interfaces and processes.
• Responsible for unit testing and involved in integration testing and QA Testing.

Confidential, Hopkinton, MA

Oracle SOA Lead Developer/ PL/SQL Developer

Responsibilities:

• Responsible for developing a Global Business intelligence report to the users in Israel.
• Developed a BPEL interface to read the CSV file from a secured remote FTP server, parse the file and load it into custom tables based on the requirement.
• Used FTP adapters, XSL transformations to achieve the data validation and load into the custom tables.
• Configured JMS adapter over MQ Adapter, File Adapter and Database adapter.
• Designed the OAGIS BOD schemas.
• Used BPEL’s Email notification activity to send an email report to the concerned lotus notes group and other users.
• Responsible for setting up JNDI connection for secure FTP server in Application Server.
• Responsible for sending an email report to the users when the data load fails.
• Prepared MD70 (Technical Design Documents) for the interface and the objects involved in the process.
• Prepared mapping documents according to company standards.
• Involved in documentation reviews.
• Responsible for creating all data call related procedures, functions and packages in PL/SQL.

Confidential, Troy, MI

Oracle SOA Developer

Responsibilities:

• Responsible for developing several BPEL interfaces for integrating Oracle with Manhattan Associates WM.
• Developed processes to transfer Master Data between Oracle EBS and third party systems using Oracle BPEL and Oracle ODI.
• Developed BPEL Process to Transfer Vendors, Customers, Items to make the data in sync between Oracle EBS and WM using hierarchical queries.
• Developed BPEL interfaces for bridging Pick Tickets and ASNs (Advanced Shipment Notice) to WM and receive the PIXs for the corresponding ASNs.
• Used a global business event that is triggered from oracle and used an Oracle Apps adapter to capture the event and route the process.
• Designed and developed a methodology to provide the user with the ability to modify the XML message.
• Developed Oracle Forms to Query and Update information related to the Integration points as per user requirements.
• Used Dynamic Entity Forms to parse and load the XML into Oracle Dynamic Entity Forms. The parsed XML would be in flat user friendly form structure.
• The modified fields are then transformed into XML message as per the XML schema.
• Responsible for maintaining the error reprocess OA form.
• Prepared TDS for all the interfaces and its related objects.

Confidential, Boston, MA

Oracle Applications Technical Consultant

Environment: Oracle Applications Release 11.5.10.2 (AP, GL, AR, PO), Oracle 10g, Oracle SOA Suite 10g, BPEL, Jdeveloper 10g, SQL, PL/SQL, Forms 10g, Discoverer 4i/10g, SQL * Loader, and TOAD

Responsibilities:

• Responsible for developing Web Services using BPEL.
• Imported AP Invoices from a Legacy system into UFMS through a BPEL Process.
• Responsible for building BPEL projects to send Email notifications through email process activity
• Handled runtime faults, binding faults and system faults in the BPEL interfaces.
• Developed Audit Toolkit Process Selection Form where the user can select the audit extract/s they have to run when required.
• Developed Supplier Automation Inbound Interface which gets the temporary supplier information onto UFMS.
• Configured Concurrent Executables, Concurrent Programs, Custom Flex fields, Custom Lookups, Request Sets, Request Groups, Functions, Menus, Sub-Menus and Custom Responsibilities.
• Created XML Publisher reports for generating sales invoices.
• Developed BAM dashboard reports for GL, AP, AR and PO.
• Developed Audit extraction SQLs involving GL, AP, AR, PO and FV (Federal Financial) modules.
• Developed Custom API and used BPEL process to invoke the API to load the external data into the corresponding tables at the end of every month.
• Involved in Handling CR’s (Change Requests) for various Audit tasks.
• Involved in creating the UAT scripts.
• Responsible for fixing various UAT bugs.

Confidential

Oracle Consultant

Environment: Oracle Applications Release 11.5.10.2 (AP, GL, AR, Oracle 10g, Oracle SOA Suite 10.1.3.1 (BPEL SOA), Jdeveloper 10g, SQL, PL/SQL, Forms 6i, Reports 6i, SQL * Loader, Workflow Builder, TOAD and XML/BI Publisher.

Responsibilities:

• Involved in design, development and support process of integrating the Online Billing System (OBS) with Oracle Applications 11.5.10.2 instance.
• Implemented Invoice import interface process using BPEL (Apps Adapter) for loading invoice information into Oracle Payables base tables.
• Developed BPEL and ESB processes to load the active customers into Oracle API interface tables.
• Worked extensively on XSL Transformations, routing elements in developing BPEL and ESB process
• Developed BPEL process for reading the source data from an external system using the File Adapter.
• Created BPEL processes using Jdeveloper 10g to import project information from legacy systems into oracle projects.
• Involved in import of customer information from the OBS instance to the 11i instance using BPEL processes.
• Developed concurrent programs to allow users to update party information in the 11i instance.
• Developed Dynamic User Interface where in the text printed on the screen is pulled from tables and the check boxes, text items are dynamically arranged per Business rules using Forms 6i.
• Used BPEL processes in Conversion of the existing sales transactions in the AR module of OBS system to AR module in the 11i instance.
• Worked on AR setups to accommodate the OBS business process in to the current 11i system with minimal impact to both business processes.
• Created Descriptive Flex fields on some base tables in AR modules to accommodate for seamless integration of OBS business process.
• Developed XML Publisher reports as per the client’s template to provide billing details to the commercial customers.
• Involved in design and development of Interface program using BPEL for importing Sales Transactions from legacy accounting system.
• Created scripts to map and create accounting Flex field rules from OBS instance accommodating the changing accounting structure and providing the files and loading them in to Development Instance and UAT instance using Data Load tool.
• Developed supporting Functional and Technical documentation.