We provide IT Staff Augmentation Services!

Sr. Oracle Soa Consultant Resume

4.00/5 (Submit Your Rating)

Miami, FL

SUMMARY

  • Over 7+ years of experience in providing enterprise integration solutions using Oracle technology products like Oracle SOA, Oracle ESB, Oracle ERP solutions.
  • Extensive experience in building composite applications involving BPEL, Mediator, Human work flow and Business Rules components.
  • Strong experience service virtualization using OSB 11g.
  • Implemented composite applications using various technology adapters like DB Adapter, FTP Adapter, AQ Adapter, JMS Adapter, B2B Adapter and BAM Adapter.
  • Extensive experience in business flow orchestration using Oracle BPEL.
  • Extensive development experience with Oracle 10g and 11g database.
  • Extensively worked on Enterprise Service Bus (ESB 10g) to filter and route messages to respective partner services.
  • Experience in custom error handling frameworks for SOA implementations.
  • Expertise in creating JDBC, JNDI in weblogic 11g for Database adapter, JMS adapters.
  • Experience in building interactive, real - time dash boards using BAM 11g, and BAM Architect to develop data models.
  • Expertise in working with Reporting and BAM implementation using OSB.
  • Work experience on creating and using of BAM alerts.
  • Knowledge in building Java EE applications using wsdl2java.
  • Working Experience on configuring B2B trading partners, Document definitions, Listening Channels and Agreements.
  • Work experience both Batching, De-Batching and Non EDI transaction sets in B2B.
  • Knowledge in EDI X12 documents interfaces using B2B.
  • Knowledge on Oracle AIA in extending Business Objects and Business Messages to build ACBS.
  • Familiar with attaching/detaching security policies for web services in BPEL implemented in OWSM.
  • Experience in virtualizing services, implementing policies in Oracle Application Gateway (OAG).
  • Familiar with Oracle Enterprise Repository (OER) to manage services and reuse services across enterprise.
  • Strong development experience with JDEV 10g and 11g.
  • Familiar with different components in BPM suite to develop business process flows.
  • Experience in BPEL performance tuning and purge process.
  • Experience in testing cycles and implementation releases.
  • Experience in build and deployment frameworks using ANT and Hudson.
  • Experience in working with offshore teams, and production support teams.
  • Good communication skills and a genuine team player with good organizational and self-management skill.

TECHNICAL SKILLS

Middleware: Oracle SOA 11.1.1.x, E-Business Suite (EBS), Oracle Service Bus (OSB), BPEL Process Manager, Oracle Enterprise Manager, Oracle Web Service Manager (OWSM), Oracle BPM, Oracle BAM, Work list Application, IBM Websphere/process server

Application Servers: Oracle Weblogic Server 10.3.x, Oracle Application Server 10g, Web sphere Apache Tomcat

Languages/ Technologies: SQL, PL/SQL, BPEL, SOAP, Java, C, C++, Unix Shell scripts

Web services: SOAP, UDDI, and WSDL

RDBMS: Oracle 11g/10g/9i/8.x, SQL Server 2005/2008, MySQL

Tools: Toad, SQL * Plus, SQL Developer, SSH, Putty, Altova XML

Build Tools: Ant 1.4, Make utility

Test Tools: Lord Runner, Junit, Soap ui

IDE: JDeveloper11g, OEPE

Markup languages: HTML, XML, XSD, XPath

Operating Systems: Windows, Unix, Linux, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Miami FL

Sr. Oracle SOA Consultant

Responsibilities:

  • Batch Processing implemented using the BPEL components like File Adapter, FTP Adapter, Database Adapter.
  • Developed Canonical WSDL’s and XSD’s which can be used across the enterprise.
  • Used Assign, Transform, Invoke, Flow and FlowN operations in BPEL workflow.
  • Implemented Error handling to catch all kinds for business errors and store them into database tables.
  • Performed unit testing and involved in integration testing and QA Testing and production support of various services developed as BPEL modules and exposed as Web services
  • Used MDS repository to store all the common artifacts between composites like XSD, Fault policy and Fault Binding files.
  • Created Error logger process for error logging and Error Handler Process for resubmitting the error messages to respective processes.
  • DB Adapters, File Adapters and Oracle Apps Adapters were used as Partner Links to create and publish the records to Oracle database threw EBS.
  • Used various features like XPath functions, XSLT, Human Task, OWSM policies, Correlation sets, Preference variables, Dynamic URL mappings
  • Worked on Fault handling (catch and catchall), Compensation handlers, Messaging and Alerts and Transformations.
  • Performed migration of some composite from lower environment to higher.
  • Enabled automatic recovery for errors from Fault Handlers and stored in dehydration store. Remote exceptions were automatically handled by the BPEL process.
  • Involved in few SOA administration tasks such as creating and modifying JNDI and managing data source.
  • Configured JDBC connection pools and managed database connections, through JDBC data-sources, and JDBC pools.
  • Defined test scenarios and test cases for the different operations of the BPEL service access points.
  • Used Oracle Mediator for content based routing with synchronous/asynchronous messaging techniques to ensure guaranteed notifications to approvers.
  • Developed Technical design documents(TDDs) for SOA Services.
  • Developed process flow diagrams for consumer profile management services in Visio.
  • Developed XSLTs using Oracle seeded functions for string formats, date formats.
  • Configured B2B console in which Created Document Definition, Document Protocol Version and Listening Channel for both inbound and outbound transactions.
  • Configured JNDIs for DB adapters and OA adapters.
  • Developed SoapUI test cases for unit testing.

Environment: Oracle Fusion Middleware 11g (Oracle SOA Suite, BPEL, Oracle OSB, Oracle Human Task, Oracle Business Rules, Mediators & Adapters), Oracle Database Server 11g JDeveloper 11g, Eclipse, Oracle Web-logic 11g, WSDL, XML UML, Oracle SQL Developer, Soup UI.

Confidential, Jersey City NJ

Sr. Oracle SOA Consultant

Responsibilities:

  • Designed, developed and deployed different SOA tasks using BPEL/Mediator/BAM.
  • Developed service contracts on soap bindings.
  • Developed business services in OSB using service providers XSDs and WSDLs.
  • Developed SOA-DIRECT SYNC and ASYNC business services to route messages to bpel process layer.
  • Developed OSB proxy services on http, jms, sb protocols.
  • Developed message flows in OSB using service callouts, Publish, Java callouts, route, dynamic route, transport headers.
  • Developed OSB services to handle ASYNC services, used WS-addressing and Reply-To for callback addressing.
  • Developed OSB REST services, implemented http headers name-value tokens.
  • Implemented schema validations and error handlers at proxy level.
  • Used ASSIGN and REPLACE in message flows to transform data, used XQs, XPATHs, Variables.
  • Worked on ANT scripts to build and deploy sbconfig.jar, generate and execute ALSB customization files.
  • Developed complex BPEL processes to handle parallel flows and dynamic flows using FlowN
  • Used Oracle seeded functions and generic functions in Assign and XSLTs to transform payloads to meet consumer services.
  • Worked on complex transformations using variables and templates.
  • Used BPEL preferences and correlation sets in process flows.
  • Good Knowledge on properties changes in EM, WLS console.
  • Worked on complex SQLs, PL/SQL procedures and Functions. Used database adapter services to retrieve data sets from database, update tables using PL/SQL procedures.
  • Worked on File adapters to Write and Append data to files on application server, which were FTPed to vendor systems.
  • Published business events to JMS topics, and consumed via OSB and routed it to consumer via biz services.
  • Implemented error handling at scope level and process level to handle remote faults and binding faults, and reply back to client with proper error codes and error message.
  • Built composites involving BPEL and Mediator. Invoked Mediator component from main process to route it to sub-processes based on filter.
  • Used Dehydrate, Java embedding, Pick, If/Switch activities in process flows.
  • Developed SOA CFG plans to support deployments to multiple environments.
  • Worked on BPEL test suites for testing process flows.
  • Worked on B2B integration in processing the EDI files.

Environment: Oracle SOA Suite 11g (11.1.1.6), Oracle 11g Database, Oracle JDeveloper 11g (11.1.1.6), Oracle Service Bus (11.1.1.6), Oracle Weblogic (10.1.3.6), Oracle SQL Developer 10g, OEPE, Soap UI, Altova XML.

Confidential, Carlsbad, CA

Oracle SOA Developer

Responsibilities:

  • Developed interfaces to support Accounts Payables interfaces with Oracle ERP systems.
  • Developed custom PL/SQL procedures to load data from STG tables to interface tables.
  • Developed File adapter services to pick invoices from application server and load them into STG tables.
  • Developed OAF page to browse APDI spread sheet for payables users to upload invoices to application server.
  • Developed DB adapter services to load invoices to STG tables using BPEL.
  • Developed routing services using mediator component to apply the filters and transform the payloads and route it to corresponding services.
  • Developed services to FTP the files to vendors using FTP adapters and Mediator component.
  • Setup concurrent programs to load invoices from interface tables to payables systems.
  • Developed discoverer reports for accounts payables end users, administered discoverer EUL for payables systems.
  • Worked on SQL tuning using HINTS to optimize queries for reports.
  • Developed services using Oracle Application Adapter to run the concurrent program.
  • Provided interface design documents and mapping documents.
  • Supported migration of services across various environments.
  • Integrated with Oracle XML gateway to exchange messages with ERP systems.

Environment: Oracle SOA Suite 11g (11.1.1.4), Oracle 11g Database, Oracle JDeveloper 11g (11.1.1.4), Oracle Service Bus (11.1.1.4), Oracle Weblogic (10.1.3.4), Oracle SQL Developer 10g, OEPE, Soap UI.

Confidential, Baltimore, MD

SOA Developer

Responsibilities:

  • Involved in various phases of Software Development Life Cycle (SDLC) such as modeling, system analysis and design, code genermsation.
  • Extensively worked on Oracle BPEL to create new process models and enhance the existing process models as per the B2B's.
  • Used Assign, Invoke, Receive, Transform, Sequence, On-Alarm branch in the BPEL process.
  • Configured and deployed resource adapters like AQ Adapter and Applications adapter to weblogic server and used it in SOA suite
  • Used different adapters like DBAdapter, JMS Adapter as part of a BPEL Process.
  • Developed Exception Handling architecture in BPEL for the whole project to handle all the exceptions
  • Developed ANT Scripts to deploy and un-deploy bpel processes in cluster and non-cluster environments.
  • Used XML, XPath, XSL to get the data and transform as per the requirements.
  • Involved in configuring JNDI, DBConnections, and Integration Connections on Oracle application Server.
  • Extensively used WSDL, XSD’s while creating BPEL process models

Environment: Oracle SOA Suite 10g(10.1.3.4), Oracle 10g Database, Oracle JDeveloper 10g (10.1.3.4), Oracle Application Server 10g, Sun Solaris, Visio.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
  • Various 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.
  • 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.
  • Oracle Forms 5.0 used to design and develop the interface for the system.
  • Oracle Report 3.0 was used to create reports.
  • Created Reports like Ledger, Profit and Loss statement, Balance Sheet and Trial Balance.
  • Created Group, Ledgers, Vouchers and Bank Reconciliation statements by using Forms 4.5.
  • Created front-end procedures
  • Created functions with Forms 5.0 to calculate reorder level and reorder quantity.

Environment: Oracle10g, Toad, Oracle Forms 10g, Oracle Reports 10g, HP-UNIX. (also update project points forms to 10g and reports to 10g

Confidential

PL/SQL Developer

Responsibilities:

  • Responsible for Commercial Product Development and Deployment for Finance Industry
  • Design using Model Driven Development process
  • Portable Java component development on JDK and J2SE
  • Client server computing using HTTP over TCP/IP
  • Client side component Development using HTML, XML, CSS, JSP and JavaScript
  • Developing Java Beans, JSP, Servlet components using Eclipse and deploy into JBoss Server
  • Data Modeling and making SQL Server database Communication using JDBC, PL/SQL
  • Making Application Build using ANT Tool and Bug tracking.
  • Interacting with the team for project analysis, Designing, Implementation and Documentation
  • Rapid application development using IBM Clearcase platform
  • Code Optimization, Application performance improvement using SUN Standards

Environment: SQL Server, Eclipse, UNIX, UML

We'd love your feedback!