We provide IT Staff Augmentation Services!

Sr Oracle Soa Consultant Resume

0/5 (Submit Your Rating)

Dallas, TX

SUMMARY

  • Middleware integrations specialist with over 7 years of experience in the analysis, design and development of various multi - tiered client-servers, distributed component applications, pre-packaged application integrations and 5 years of extensive development on Oracle SOA 10g and 11g platforms.
  • Extensively worked on middleware integrations using components like Business Process Execution Language (BPEL), Enterprise Service Bus (ESB) and, Business - to-Business Integration (B2B).
  • Developed inbound and outbound interfaces using various Enterprise Application Integration (EAI) patterns using File, FTP, Database, JMS, AQ, MQ, BAM and B2B adapters in BPEL and OSB.
  • Extensive development experience using OAGIS canonical models, BODs and Oracle PIPs.
  • Extensively developed interfaces to integrate with backend Oracle ERP 11i and Rel12 applications using Oracle AQ and Oracle Applications Adapter for HR, Payroll, Manufacturing and Financial modules.
  • Experience in designing and developing business processes for A2A, B2B and C2A integrations using BPM suite and business process orchestration using BPEL.
  • Experience in installing, configuring, managing various applications on Oracle WebLogic Server and Oracle Application Server (10G).
  • Extensively used Oracle Service Bus (OSB) for virtualizing back end services, and integrations for protocol translations (HTTP, JMS, FTP, SB, FLOW, JCA, E-Mail) and message transformations using XQs, XSLTs, MLFs, Java callouts.
  • Extensively worked on SOA 11g components BPEL, Mediator, Business rules, Task flows.
  • Experience in configuring JMS modules, JNDIs, Data sources, File stores, work managers in WebLogic server.
  • Experience in developing web services using SOAP binding, HTTP RESTFUL based services in OSB 11g.
  • Experience in tuning SOA environments using SOA purge scripts, Oracle 10g, 11g database performance tuning, analyze memory leaks and thread dumps.
  • Experience in Business Process Management (BPM) life-cycle to manage, design, monitor and optimize the various existing processes.
  • Exposure in Oracle Web Service Manager (OWSM), Business Activity Monitoring (BAM) and Oracle Enterprise Messaging Service (OEMS).
  • Experience in ANT and Maven scripts for deploying SB-CONFIG and SCA jars to OSB and SOA servers.
  • Experience in developing Oracle 10g and Oracle 11g database objects, PL/SQL packages and stored procedures for Oracle reports and Oracle Database adapters.
  • Experience in leading small to mid-size off shore teams, and coordinate work with teams across globe.
  • Experience with testing applications, defect managements process, and release processes.
  • Highly motivated, detail oriented with excellent written and verbal communication skills, has ability to work independently and as a part of the team.

TECHNICAL SKILLS

Middleware and Applications: Oracle SOA 10g, 11g, E-Business Suite (EBS) 11i and R12, Enterprise Service Bus (ESB), BAM, BPEL Process Manager, Oracle Rules Author, Oracle Web Service Manager (OWSM)Application Servers Apache Tomcat, Oracle Application Server 10g, Oracle BEA J2EE Web Logic Server.

Languages/ Technologies: SQL, PL/SQL, BPEL, SOAP, Java, J2EE (JSP, EJB, Servlets, JDBC, JNDI, JMS, JAXP, SAX / DOM, JAX-RPC), C, C++, Unix Shell scripts

Web services: SOAP, UDDI, and XML

RDBMS: Oracle 10g/9i, SQL Server 2005/2008, MYSQL

Tools: TOAD, SQL * Plus, SQL Developer, Secure Shell Scripting, Rational Rose for UML, MS VSS for Version Control, Oracle JDeveloper 11g for Fusion Development.

Build Tools: Ant, Make utility, Maven.

IDE: Net Beans, Confidential Visual Age, JBuilder, JDeveloper 10g, 11g, Eclipse.

Markup languages: HTML, XML, XSD, XPath, XSLT,Web Applications JSP, JavaScript Source Control PVCS, VSS, CVS, SVN

Test Tools: Software Quality Assurance (SQA) tools - Mercury Interactive-Test,Director, Load Runner, Soap UI.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr Oracle SOA Consultant

Responsibilities:

  • Gathered business requirements for A2A, C2A and B2B integrations and developed integration patterns.
  • Developed common data model to reuse and support application integration across enterprise.
  • Developed interface mapping documents and technical design documents.
  • Developed XSDs and defined SOAP and JMS binding WSDLs for exposing service in OSB.
  • Exposed proxy services to various applications on http protocol.
  • Developed business process in BPEL to generate CSV file and FTP to partner systems on a daily basis.
  • Implemented long running async processes in BPEL used various activities like Assign, Invoke, Receive, Transform, Switch, and fault handlers for process orchestration.
  • Developed utility services and exposed them via OSB for enterprise reusability.
  • Developed database procedures and exposed database services for logging and error handling services, and batch processing applications.
  • Developed JMS adapter services to publish out business events to vendors and partners.
  • Developed BPEL processes to report business trends to BAM dashboards using BPEL sensors.
  • Defined BAM data objects using BAM architect and developed reports using BAM studio.
  • Configured Oracle API gateway and managed s for integration with partners and vendors.
  • Configured Database, JMS, BAM and B2B adapters in WebLogic to support both OSB and SOA managed servers.
  • Implemented complex routing in OSB using dynamic XQs and routing options.
  • Developed java stubs using wsdl2java, and deployed ear to application server using ANT scripts.
  • Configured Data source and JNDI to access the databases using DB Adapter.
  • Developed BPEL test suites for testing SOA process using Assertions and Emulations.
  • Developed scripts for build and deployments of OSB and SOA jars to respective servers.
  • Configured load balancers to support clustered environments.
  • Developed Email alerts as part of business processes using UMS driver in BPEL.
  • Developed flows in BPEL to invoke services in parallel using FlowN activity.

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 UIAltova XML.

Confidential, Westlake Village, CA

Sr. Oracle SOA Developer

Responsibilities:

  • Gathered business requirements for the Item Integration and developed High Level Design Documents.
  • Extensively used XSLT, XSD, and WSDL.
  • Designed and developed an OSB to route to a different procedure on Oracle EBS.
  • Used Oracle Service Bus (OSB) to build Proxy and Business services.
  • Implemented the Oracle Service Bus (OSB) for virtualizing some of the services and also configured it for load balancing between the servers.
  • Created JMS Distributed queues and implemented Audit services Framework for different BPEL processes.
  • Used Fault policies and Fault Bindings for Error handling.
  • Worked broadly on XQUERY and XSLT transformations in OSB to provide mapping between consumer and provider business services.
  • Built OSB Proxy and Biz services to create the Proxy layer for the SOA composites and to isolate the composites from different technology partners in the enterprise.
  • Worked with File Adapter, Database Adapter, JMS Adapter and Oracle Applications Adapter for establishing connection with services in BPEL.
  • Designed various BPEL sensor design and sensor messages.
  • Configured B2B trading partners and channels.
  • Identify, classify, assign and publish services in Oracle Service Registry(OSR).
  • Experience in Business Process Management (BPM) life-cycle to manage, design, monitor and optimize the various existing processes.
  • 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 OSB services on to the production server.

Environment: Oracle SOA Suite 11g, Oracle Application Server 11g, Oracle Service Bus, SQL, PL/SQL, TOAD, Oracle BAM, JDeveloper 11g, BPEL Process Manager, OSB, Oracle database 10gR2, Eclipse, Soap UI

Confidential, Wilmington, Delaware

Sr. Oracle SOA/BPEL Developer

Responsibilities:

  • Developed and translated the requirements to match the technical and fusion middleware solutions.
  • Used B2B Integration for accumulating requirements from Partners, Siebel team and Business analysts by attending various meetings
  • Designed a DB schema consisting of the Headers, Lines and Approver tables.
  • Used SOAP, XML, XPATH, and JMS to send and receive data.
  • Work flow was constructed using BPEL, Task Manager, ESB, Web Services and XPATH.
  • Defined WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition.
  • Design and Developed ESB processes, configure database, file adapters and tuned BPEL and ESB processes.
  • Developed several XSD and DTD Schemas for XML validations. Used Oracle Rules Engine to configure Business Rules. Configured and Deployed web services security Policies using Oracle Web Services Manager.
  • Extensively worked on XML, DTD, XSD, XSLT, AXT in order to transform the message to/from Seibel, Web, IVR and VCP’s in order to complete a process.
  • Design and Implement error handling using the Fault handling framework.
  • The E-Req system is deployed on the Oracle 10g Application Server and tested with several Use Cases.

Environment: Oracle SOA Suite 10.1.3.3.0 , Oracle JDeveloper 10g, WSDL 1.1, OC4J, PL/SQL, XML, XSDTCE AGILE, Oracle BPM, Oracle BPEL, Oracle BPMN, Oracle BAM, Oracle, Sybase, MySQL, Linux.

Confidential, Grand Rapids, MI

Oracle Fusion/SOA Suite Developer

Responsibilities:

  • Used Java Embedding activity for executing Java classes for executing Java web services.
  • Developed several XSD and DTD Schemas for XML validations.
  • Experience in Creating and Configuring the Proxy Services and Business services in ESB using service callout, java callouts, transport headers, routing.
  • ESB is used for scheduling the email notifications.
  • Implemented Oracle Enterprise Service Bus for messaging services, connecting to database and for creating Proxy over existing web services.
  • Worked extensively on JAVA, J2EE, PL/SQL and HTML.
  • Performed both Server side and Client side Validations.
  • Created struts-config.xml file to manage with the page flow.
  • Used Multithreading in Java to increase the performance.
  • Used Java Embedding activity for executing Java classes for executing Java web services.
  • Involved in the development of BAM dashboards for capturing various metrics of various applications.
  • Configured Database Adapter, JMS Adapter and Data sources to different databases and publish and receive JMS messages.
  • Used Log4j to capture the log that includes runtime exception and for logging info and are helpful in debugging the issues.
  • Performed Unit testing using J-unit.
  • Defined test scenarios and test cases for the different operations of the BPEL service access points.
  • Developed the scripts for building and deploying the application.

Environment: Java 1.4, J2EE, Servlets, JSP 2.5, JSTL, HTML5,CSS3, JDBC, Log4J, JavaScript, J-unit 4.1, CVS, Oracle10g, Oracle BAM, Eclipse IDE,XML,SQL,DB Adapter, JMS Adapter.

Confidential

PL/SQL Developer

Responsibilities:

  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Developed PL/SQL scripts to validate and load data into interface tables, oracle backend and database operations were handled using stored procedures.
  • Transferred data using SQL*Loader to database.
  • Developed reports like weekly reports, daily stock status report, monthly reports and periodical reports on stock table.
  • Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
  • Involved in design and development of data validation, load process and error control routines.
  • Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
  • 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 8.0.3.5, PL/SQL and Developer 2000(Forms4.5.0, Reports 2.5).

Confidential

Oracle Developer

Responsibilities:

  • Analysis and Design of the system.
  • Prepared program Specification for the development of PL/SQL Procedures and Functions.
  • Ran Batch files for loading database tables from flat files using SQL*loader.
  • Created PL/SQL scripts for data transformation in line with program specifications.
  • Created Custom Staging Tables to handle import data.
  • Modified existing codes and developed PL/SQL packages to perform certain specialized functions/enhancements on oracle application.
  • Created Indexes and partitioned the tables to improve the performance of the query.
  • Modified existing forms, reports, and graphs as per the requirement.
  • Involved in preparing documentation and user support documents.
  • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance

Environment: Oracle 7.X, SQL, PL/SQL, SQL*Loader, Developer 2000, HTML, Windows 95

We'd love your feedback!