We provide IT Staff Augmentation Services!

Oracle Soa Consultant Resume Profile

3.00/5 (Submit Your Rating)

Summary

  • Very well conversant with all the aspects of SOA, BPEL, SCA Components, Business Events and Data Model of Oracle Applications R12 and 11i, ODI Interfacing.
  • Strong understanding of Service Oriented Architecture SOA concepts, Service Component Architecture specifications, BPEL and web services implementation
  • Good working on SOA with the middleware technologies with Oracle Application Server, BPEL Business Process Execution Language process manager for Oracle EBS and other application integration.
  • Worked on several integration points for Oracle E-Business with outside applications such as Seibel, OTM, Web sphere etc using BPEL SOA and ESB process.
  • Excellent knowledge of SOA and BPEL process and its components such as wsdl, routing, adapters, xpath, dvm, queues, business events etc, Human workflows, Rules Engine.
  • Experience with integrating and invoking services using technology adapters DB Adapter, AQ adapter, File adapters, OA Adapters, BAM Adapter, FTP adapter etc, JMS Adapter .
  • Experience working and designing AQ, JMS Queues ans Business events related with queues.
  • Transforming complex Message Data in ESB, Mediator and BPEL using XSLT transformation and various BPEL functions
  • Thorough understanding of Oracle Applications Implementation Methodology AIM , documentation MD50, MD70 and using version control tools such as PVCS and CVS.
  • Design and development RICEWF Reports, Interfaces, Conversions, Extensions, Workflow and Forms .
  • Excellent experience working in 24 7 Production support environment and resolving the complex issues in limited time frame.
  • Experience analyzing, troubleshooting, debugging, and optimizing complex applications with multiple components and interfaces
  • Provide day to day support for the Oracle E-Business in the areas of Supply chain, Financials, including integration points with other application systems with excellent service levels.
  • Excellent Experience in SQL and PLSQL query tuning using various Oracle tools and methodologies.
  • Working on Oracle SRs, Metalink and responsible to follow up with it till close.
  • Excellent working knowledge of Oracle 11g, 6i, 9i and BI/XML Publisher Reports and designed numerous reports using this tools for various modules.
  • Extensive experience with developing stored procedures, packages, functions, database triggers, exception handlers, advance queuing and cursors in PLSQL.
  • Experience using ODI Oracle Data Integrator for Data Migration projects.
  • Experience using Topology, Knowledge Modules, Change Data Capture, Metadata in ODI.
  • Experience building ETL processes from scratch
  • Developed and customized different versions of Workflows and Workflow Business Events.
  • Good experience in Unit testing and System Integration testing.
  • Excellent Conceptual, Business, Analytical and presentation skills.

Project Engagements

Confidential

Oracle SOA EBS Integration Developer

Responsibilities:

Business analysis of several Oracle and other applications engagements within organization. Defining architecture for integrating various systems using Oracle Fusion Middleware SOA and other tools present in the organization. Engaged in the next generation of EAI and B2B integration projects. Working on in Enterprise Architecture Custom integration development based on Service Oriented Architecture SOA utilizing Web Service, ESB, Oracle SOA Suite, Weblogic server, IBM Web Sphere, JMS Queues and different adapters. Involved in business process analysis skills and Architectural modeling. Working using Topology, Knowledge Modules, Change Data Capture, Metadata in ODI. Designing various integration applications and programs to achieve the goal of Business and integrating B2B Business to Business applications too. Providing integration solution to integrate outside and inside applications and systems based on B2B relation. I am responsible for integration of company application and systems in several domains including financial, supply chain, warehouse, transportation etc, Application and tools mainly working includes SOA, BPEL, B2B, Oracle applications ERP, ODI,xml ,xslt, unix, plsql, sql, J developer, SOAP, web services technology etc.

Confidential

Oracle SOA Consultant and Developer

  • Responsible for Architecture Design and development of Oracle E-Business R12, SOA, BPEL 2.0 Process for Oracle E-Business pertaining to different modules and applications and integrating the existing trading partner's through SOA 11g.
  • Integrating various Oracle E-Business mainly Manufacturing modules with Agile and other modules using SOA tools such as on SOA 11g BPEL, Mediator.
  • Development of SOA composites for integration of various other applications in the organization.
  • Integration of Oracle Agile and Oracle E- Business using SOA thorough adapters and JMS Queues.

Confidential

Responsibilities

  • Responsible for Architecture Design and development of Oracle E-Business R12, SOA, BPEL 2.0 Process for Oracle E-Business pertaining to different modules and applications and integrating the existing trading partner's through SOA 11g.
  • Integrating various Oracle E-Business modules with web commerce using SOA tools such as on SOA 11g BPEL, Mediator, and BAM.
  • Working mostly on Oracle Order Management and TCA Customers to integrate these modules based on Oracle E- Business R12 with outside customer Portal based on web commerce through development of SOA based web services build in SOA 11G sca model.
  • SOA services are being called from external application such as web sphere and are built for real time interfacing heavily using DB Adapter, xsd and xslt transformation using mediator for different kind of operations in the service call.
  • Working on plsql packages, order and customer api's, functions and other plsql and DB objects in Oracle E-Business R12.
  • Developing BPEL composites web services using Oracle J Developer, SOA 11g using XML and SCA technologies.
  • Working on the Integration standards such as XML, XSLT, and WSDL for integration.
  • Some hands on SOA Administration server for creating data sources, Jndi's soa partitions and managing soa composites.
  • Working on several SOA adapters along with Oracle AQ, Oracle RDBMS, PLSQL, SQL and other coding patterns in oracle.
  • Involved in Business process analysis and design and technical documentation such as MD80 and MD120.

Confidential

Responsibilities

  • Responsible for Architecture Design and development of Oracle E-Business R12, SOA 11g, B2B, BPEL 2.0 Process for Oracle E-Business pertaining to different modules and applications and integrating the existing trading partner's through B2B Soa.
  • Integrating various trading partner's with the main vendor using SOA, B2B standards and technologies EDI, XML, XSLT, XSD, B2B, SOA, Oracle BPEL, ESB, Mediator, BAM, Human Workflow, Oracle Fusion Middleware etc.
  • Gathers, analyzes, and documents business requirements to support the design and development of technology and process solutions for SOA B2B.
  • Development of BPEL and SOA components, processes, adapters, web services, etc. Contributing to design reviews and help shape future project direction.
  • Involved in Development, Deployment and execution of soa composites BPEL Processes using Oracle SOA Suite 11g and sca architecture.
  • Integrating and invoking Services through various adapters such as db adapter, oa adapter, file adapter, BAM adapter etc.
  • Transforming Message Data in Mediator and BPEL using complex XSLT transformation and using advance features of xpath and xslt transformation.
  • Working on messages and message queuing using oracle advance queuing and AQ adapters in soa in conjunction with oracle business events and alerts.
  • Good Experience with the SOA development lifecycle from SOA design, development, testing to production Support.
  • Translates business requirements into technology solutions using the B2B Methodology and SOA composite.
  • Coordination with various Departments to understand the requirement and Map it into Existing Business using B2B Adapters in SOA Composites and complex xslt transformation.
  • Strong working on WSDL Web services and other components of SOA Composite such as adapters, calling external services rules engine, xpath, xslt, and other components of BPEL Console.
  • Involved in some DBA related activities such as setting of JDBC, JNDI connection and connection details for adapters.
  • Design of oracle plsql packages and procedures which include several API's to integrate Oracle E- Business modules with SOA B2B system.
  • Developing both inbound and outbound interfaces for Oracle E- Business interfaces for several modules.
  • Good Experience with Web Services, SOAP, WSDL, XML, XSD, XSLT, Oracle DB Adapters, Oracle EBiz Adapters, JMS, Oracle AQ and FTP Adapters.
  • Experience with the entire Oracle SOA Middleware Architecture including Application Server, Web logic Server Enterprise Manager, BPEL Process Manager, Service Bus, Rules Engine, Notification services etc.
  • Produce business solution models, technical work products e.g. MD.070, Interface Control Documents, Unit Test Plans, MD 050 etc.

Confidential

Oracle SOA Consultant

Responsibilities

  • Responsible for Design development and architecture of Oracle E-Business ,SOA, BPEL Process for Oracle E-Business pertaining to different modules and applications.
  • Working on Integration of various Oracle E-Business modules with third party applications and systems using Oracle SOA BPEL fusion middleware technologies.
  • Developed several SOA BPEL Process for integration with Oracle E-Business such as Suppliers, HR Locations, suppliers insurance and contacts etc.
  • Designed the BPEL process for AP Payments process to be integrated with B2B for EDI Payments.
  • Designed and developed custom Business Events for triggering BPEL Process from Oracle E- Business and receiving the same in SOA Process through Oracle application adapter.
  • Worked on several conversions such as Salesrep, Employee assignments, absence etc.
  • Developed and supported various inbound and outbound interfaces for SCM, HR and Financial modules.
  • Integrating various applications with the use of workflow business events and initiating the B2B Processes using those along with advance BPEL and Oracle Plsql.
  • Coordinating with QA's, functional and users for proper testing and deployment of the objects in various instances.
  • Working on Interfaces ad conversions for Oracle EBS for AP, PO, HR, OM, PA, INV and other modules. Worked on several API's for interface and conversions of the same.
  • Development and customization of several reports using Oracle BI Publisher Oracle reports 10g. Also conversion of Oracle reports to BI publisher reports.
  • Worked on various outbound and inbound interface and EBS Conversions and used several API's in Oracle Financial, HRMS and Supply chain modules. Used BPEL process as well as UTL FILE to integrate EBS from legacy applications.
  • Involved in query tuning and object optimization of those which are already developed and need tuning.

Confidential

Oracle EBS Techno functional Consultant Oracle E-Business-R12

Responsibilities:

.

  • Responsible for Design development and architecture of Oracle E-Business R12 for Supply chain, Service Contracts and
  • Financials modules which includes OM, AR, PO, INV, GL, Install Base, Advance pricing and service Contracts
  • Working mainly on RICEW objects which also include User communication, requirement gathering, and data analysis, designing specs and coding to end business process.
  • Working on Interfaces and conversions for several modules such as Invoicing and Orders.
  • Working on advanced features of plsql such as advance queuing, Workflow Business Events system and xml documents.
  • Main resource for XML Publisher reporting and designing and developing reports for various modules such as OM,AR,PO,GL,Service contracts and Install Base.
  • Working on transformation of Oracle standard reports to XML publisher reports using various tools and techniques.
  • Using most of the advanced features of Oracle and XML reporting such as mailing and bursting.
  • Working on Interfaces and conversions such as Customer conversion and complete knowledge of TCA Architecture.
  • Responsible for deployment and testing of the developed objects to various instances and involved in MD50 and MD 70 specing.
  • Tuning several plsql objects and sql queries for better performance and optimization.
  • Working on different features of Oracle Apps such as alerts, value sets, and sysadmin. Tasks, lookups, Functions. Menus and other features.

Confidential

Oracle SOA EBS Consultant

Responsibilities:

  • I am responsible for End to End implementation and integration of business units for various modules of Oracle Applications including PO,GL, AR, PA, OM, INV. the Project involves the integration between the Business units and Mapping data elements from client legacy systems to ERP interface tables and vice versa. Writing plsql and Unix scripts to transform and extract data from legacy systems according to conversion specifications Perform data validation with Functional Area Leads and code reviews with key technical and functional staff along with coordinating with DBA's for tech issues and patch works.
  • Excellent working of Oracle Application and worked on several outbound inbound interfaces and reports along with other Oracle Application works such as flex fields, Menus Concurrent Managers, advanced plsql procedures, functions, triggers, events, workflows, views, performance tuning. Good experience working on RICE components for end to end implementation and support for different modules from Financial to supply chain.
  • Extensively worked on XML/BI Publisher and oracle reports 10g from designing Creating Template definitions and Data Definitions and using various latest features for Publisher such as BI Publisher bursting to different sources Network Drive, Email, Printer etc. Passing the report input from flat file etc.
  • Worked mainly on RICE components reports and Interfaces and extensions for various modules. Developed several inbound and outbound interface using plsql advanced methods such as collections utl file sql loader and also various Oracle supplied packages. Used the Unix scripting to support the interfaces and transfers.
  • Migrating and uploading data using APIs, and performing data conversions and Creating extensions and interfaces
  • Responsible for documentation and testing of the developed objects pertaining to MD50 and MD70 in detail explaining each and every object used in the single process.
  • Designed several BPEL Integration process with other applications using adapters and other SOA features.
  • Worked with routing and transformation in ESB and BPEL call in ESB for end to end integration.
  • Building BPEL processes and integration of OA modules using BPEL SOA web services.
  • Worked on XSD, WSDL, EBO, EBM for integration of BPEL SOA with Oracle application using adapters and other services.
  • Excellent working on Unit testing and system integration testing for the developed objects both in development and testing instances.

Confidential

Sr. Oracle Apps Techno Functional Consultant

Responsibilities:

  • Provided support on GL, AR,OM, PO, INV,HRMS of Oracle E-Business Suite
  • Worked Extensively on RICE components of Oracle E Business and extensively worked on reports 10g and Interfaces Inbound and Outbound . Workflow components customization form customization and forms Personalization also worked to some extent on XML Gateway and EDI extensions for purchasing module.
  • Assisted functional people with functional works and was involved in Unit testing Document creation and developing test plans for different modules.
  • Worked in XML documents for customizing and developing the Purchase Orders in Xml Format to be send to supplier.
  • Designed several reports in Xml Publisher for Purchasing and contracts module and used the latest features of XML reporting from XML Bursting to routing the report to Destination mode.
  • Worked on EDI Extension Interface to send Purchase Order Information to Supplier in the EDI Process. This was accomplished by EDI extensible architecture calling a standard package provided by oracle during the EDI file creation process.
  • Designed an Outbound Interface Plsql program to get the data from oracle tables to be sent Purchase Order information based on XML format to Partners through XML Gateway for document type 003 Process PO 007.
  • Created and implemented Sql Loader scripts, Unix Scripts and also UTL File for purpose of Interfacing to and from Oracle Apps.
  • Worked on customization and development of OM and Customer interfaces through interface tables and API's
  • Design and implement a business process for various types for master data to be loaded on a regular basis based on the existing Implementation of the legacy systems.
  • Extensively worked on XML/BI Publisher from designing Creating Template definitions and Data Definitions and using various latest features for Publisher such as BI Publisher bursting to different sources Network Drive, Email, Printer etc. Passing the report input from flat file etc.
  • Modified the PO Approval workflow to include business rules pertaining to Organization including notifications and attributes apart from defining different roles.
  • Created workflow events to be trapped for BPEL process and invoking BPEL process from EBS.
  • Worked on different features of Oracle Apps such as alerts, value sets, and sysadmin. Tasks, lookups, Functions. Menus and other features.

Confidential

Sr. Oracle Apps Technical Consultant

Responsibilities:

  • Responsible for various techno-functional activities in the project and took Lead for various Sub Projects acting as Team Lead.
  • Provided support on PO, AP, GL, AR, INV, OM and Contract modules.
  • Analyzed and translated business requirements to technical requirements and architecture.
  • Developed functional and technical specifications documents based on the business requirements
  • Rigorously worked on RICE components for Oracle EBS pertaining to various modules.

We'd love your feedback!