We provide IT Staff Augmentation Services!

Oracle Soa Consultant Resume

0/5 (Submit Your Rating)

FL

SUMMARY:

  • Highly skilled IT professional around 7 years of experience and expertise in software design and development in SOA/OSB/BPM/BPEL/Oracle platform based applications, projects and products.
  • Extensive experience in Web Service Orchestration using Oracle BPEL Manager and Oracle Service Bus (OSB).
  • 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).
  • Experienced at working with Oracle SOA Suite 11g SCA composites and components like BPEL process, Mediator, Business Rules, Human Workflows in JDeveloper.
  • Extensively used following SOA Suite technology adapters for integration solutions between enterprise apps: Database, JMS, B2B, FTP, File, Web Service, BAM, and Oracle applications.
  • Expertise in Design and Development of OSB Interfaces for Routing services and proxy services.
  • Hands on experience using Java Developer, Web Services, SOAP, WSDL, XML, XSLT, XPATH, HTML, UDDI in ESB, BPEL service development.
  • Exposure in Oracle Web Service Manager (OWSM) and Business Activity Monitoring (BAM)
  • In depth understanding of Business Rules implementation, expertise in implementing business rules using Oracle Rules Engine.
  • Hands on experience on Oracle BPEL Process manager performance tuning for improve process level performance.
  • Experience in Enterprise application development using Oracle Application Development Framework (ADF).
  • Experience in building and deployment of several Oracle SOA,OSB applications usingANT.
  • Experience in using Java/J2EE technologies such as JSPs, Servlets, EJBs, JDBC, JNDI
  • Experience in application development, debugging, implementation, supporting dev team, testing of Oracle based ERP using SQL, PLSQL, Shell Scripting, and Database Triggers etc.
  • Extensive Experience in working with PL/SQL packages, Stored Procedures, Functions and Triggers.
  • 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:

Oracle Products: Oracle SOA 11g, E-Business Suite (EBS), Oracle Service Bus (OSB), UCM, BAM, BPEL Process Manager, Oracle Rules Author, Oracle Web Service Manager (OWSM)

Application Servers: Apache Tomcat, MS IIS, Oracle Application Server 10g/11g, Oracle BEA J2EE Web Logic Server, OC4J

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 Application services: SOAP, UDDI, and XML

RDBMS: Oracle 11g/10g/9i/8.x, 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 10g for Fusion Development.

Build Tools: Ant 1.4, Make utility.

IDE: Net Beans, IBM Visual Age, JBuilder, JDeveloper 10.1.3.4, 11g, Eclipse.

Markup languages: HTML, XML, XSD, XPath, XSLT

Web Applications: JSP, JavaScript

Version Control Tools: Visual Safe Source, CVS / RCS. IDE: Net Beans, IBM Visual Age, Builder, JDeveloper 10.1.3.4, 11g, Eclipse.

PROFESSIONAL EXPERIENCE:

Confidential, FL

Oracle SOA Consultant

Responsibilities:

  • Involved in requirements gathering from business, component designing, and deployment and testing of the application.
  • Worked on Business rules implementation and Data Services development on physical and logical components.
  • Extensively used WSDL, XSD’s while creating BPEL process models.
  • Worked on SOA and EBS integration with various BPEL adapters.
  • Built a Shared Service, which is reusable by many applications for moving the file from local FTP Server to Remote FTP Server.
  • Extensively worked on DB Adapter and FTP Adapter.
  • Used Fault policies and Fault Bindings for Error handling.
  • Developed JMS client components to interact with MQSeries.
  • Used OSB to build Proxy and Business services.
  • OSB Programming, Routing Configuration.
  • Extensively worked on creation of JMS Queues and Implementation.
  • Working extensively on XQUERY and XSLT transformations in OSB to provide mapping between the consumer and provider business service.
  • Created WSDLs and Schemas based on Business requirements, Exposed Proxy services and Business services in OSB.
  • Configured Data source and JNDI to access the databases using DB Adapter.
  • Involved in moving the application from test environment to production environment.
  • Used the transform activity in BPEL to map the data from the procedures result set to the tables.
  • Used E-Mail activity to notify the business about any business faults.
  • Used trigger file to start up the process.
  • Created Detail Design Documents and High Level Design Documents.
  • Used Visio to build the design flows.

Environment: Oracle Applications server 11g, Oracle Service Bus, SQL, PL/SQL, TOAD, Oracle BAM, Oracle SOA Suite 11g, JDeveloper 11g, BPEL Process Manager, ESB, Oracle database 10gR2, Eclipse, SoapUI.

Confidential, CA

Oracle SOA Consultant

Responsibilities:

  • Involved in requirements gathering from business, component designing, and deployment and testing of the application.
  • Worked on Business rules implementation and Data Services development on physical and logical components.
  • Extensively used WSDL, XSD’s while creating BPEL process models.
  • Worked on SOA and EBS integration with various BPEL adapters.
  • Built a Shared Service, which is reusable by many applications for moving the file from local FTP Server to Remote FTP Server.
  • Extensively worked on DB Adapter and FTP Adapter.
  • Used Mediator to route data in between the process throughout the design.
  • Used the EDL Batch Event in Mediator to start up the process.
  • Used Job Scheduler to trigger the process at scheduled timings.
  • Used Fault policies and Fault Bindings for Error handling.
  • Developed JMS client components to interact with MQSeries.
  • Configured FTP adapters for different FTP servers.
  • Used OSB to build Proxy and Business services.
  • Configured Data source and JNDI to access the databases using DB Adapter.
  • Used java-embedding activity for executing custom Java Classes for Complex business logic.
  • Used FlowN activity to invoke different independent services in parallel
  • Involved in moving the application from test environment to production environment.
  • Used the transform activity in BPEL to map the data from the procedures result set to the tables.
  • Used E-Mail activity to notify the business about any business faults.
  • Used trigger file to start up the process.
  • Created Detail Design Documents and High Level Design Documents.
  • Used Visio to build the design flows.

Environment: Oracle Applications server 11g, SQL, PL/SQL, TOAD, Oracle BAM, Oracle SOA Suite 11g, JDeveloper 11g, BPEL Process Manager, ESB, Oracle database 10gR2, Eclipse, SoapUI.

Confidential, Seattle, WA

SOA-BPEL Consultant

Responsibilities:

  • Designed and developed a custom error handling framework for the entire organization.
  • Responsible for high-level application architecture and detail design of several interfaces.
  • OSB Programming, Routing Configuration.
  • Used Fault Policies to activate the Custom error-handling framework.
  • JMS adapter was used for Producing and consuming the messages.
  • Used java-embedding activity for executing custom Java Classes for Complex business logic.
  • Extensively used XSLT, XSD, and WSDL.
  • Developed various Web Services using WSDL, SOAP and Oracle JDeveloper.
  • Prepared Design Patterns in XML schemas.
  • Hands on experience in creating a WebUI service-using Oracle ADF.
  • Tested the web services using Soap UI, BPEL Console and Test Suites.
  • Extensively worked on Database adapter and FTP adapter, and configured JNDI and Data Source.
  • Created Stubs to test the OSB services.
  • Involved in the deployment of BPEL, Mediator and ESB services on to the production server.
  • Involved in Systems Integration Testing and System Acceptance Testing strategy.
  • Developed SQL Queries and Stored Procedures.
  • Developed Common coding guidelines and best practices for WLI, web services and logging.
  • Providing and maintaining interface specification with other Legacy Applications( DB2, MQ Registry interfaces)
  • Provide support to development and testing teams during implementation and testing phase.

Environment: Oracle SOA Suite, Oracle 11g, BPEL, ESB, SOA, WSDL, Oracle10g, JDeveloper10g.

Confidential, Oklahoma City, OK

Oracle SOA-BPEL Consultant

Responsibilities:

  • Involved in various phases of Software Development Life Cycle (SDLC) such as modeling, system analysis and design, code generation.
  • Primarily responsible for designing and implementing the application process flows with BPEL.
  • Integration of the application with third party tools such as Credit Bureau using various Adapter Services available in BPEL.
  • Implemented and integrated the business logic in PL/SQL packages using DB Adapters in different BPEL Processes.
  • Implemented Workflow services (Human Tasks) in BPEL to include human interaction whenever required in the business process flow.
  • Used various Workflow patterns, skip rules as per the requirement.
  • Modified existing Oracle PL/SQL Packages and developed new packages whenever required to be accessed from BPEL services.
  • Developed Business Rules Model for the system using Oracle Business Rules Engine.
  • Designed Rules Repository, Dictionary and Rulesets setup in Oracle Rules Engine and developed Business Rules using Rule-author (UI tool for Oracle Rule Engine).
  • Customized Business Rules implementation through BPEL using java to fit the application requirements.
  • Used ADF Business Components (View Objects, Entity Objects) to communicate with DB.
  • Used ANT Script to build the application.
  • Monitored the Debug & Error logs using java Logging Framework.

Environment: Oracle SOA Suite 11g, Oracle 10g, Weblogic Server, Web Services, SQL Server, Siebel 7.8,JDBC, Flatfile, MQ Series, XML, Java, SQL, SOAP, WSDL.

Confidential, Pittsburgh, PA

SOA-BPEL Developer

Responsibilities:

  • Involved in SOA Architectural transformation. Transformed requirements into technical and architecture documents, and authored detailed design documents.
  • Involved in web Services design including WSDL, XML, XSL, XSLT, SOAP Messages and XSDs.
  • Configured B2B trading partners, Agreements and channels.
  • Implemented an outbound ESB to Transform the Billing Information into Report generation Status message (routed to the CSR system) and Report generation letter (routed to a Client Intimation sub-system)
  • Implemented a BPEL process for importing the invoices from Billing Master into Oracle AR using Auto Invoice interface. Involved in peer-reviews of BPEL processes to cross-check the functionality
  • Integrated External website requests with Search Criteria (a J2EE component hosted on Web Sphere), Package Availability and Documented systems.
  • Database schema enhancements, PL/SQL code, stored procedures.
  • Involved in Systems Integration Testing and System Acceptance Testing strategy.

Environment: Oracle SOA Suite 11g, Oracle SOA JDeveloper, OC4J container, Java, XML, Task Manager, Oracle BPEL, Oracle ESB, OC4J SOA Suite

Confidential

SOA Developer

Responsibilities:

  • Translate requirements into technical and middleware architecture solutions.
  • Installation, Configuration of SOA Suite (BPEL, ESB OAS10g) and JDeveloper10g.
  • Involved in development of a model with BPEL. Partner links, XSD, WSDL.
  • Plan and conduct unit and integration testing including test case documentation.
  • Extensively used database adaptor to connect to Oracle database and execute queries, procedures and functions.
  • Extensively used Oracle Loader and PL/SQL for ETL.
  • Performance tuning of SQL queries consisting of many tables with large amount of data.
  • Created Packages, Procedures and Functions that extensively used PL/SQL cursors, user defined object types and exception handling.
  • Enhancements and Functional Specifications.
  • Optimized Query Performance, Session Performance and Reliability.
  • Created complex procedures.

Environment: 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

PL/SQL Developer

Responsibilities:

  • Prepared program specification for the development of PL/SQL Procedures and Functions.
  • Created Custom Staging Tables to handle import data.
  • Created custom triggers, stored procedures, packages and functions to populate different database.
  • Developed SQL* loader scripts to load data in the custom tables.
  • Run Batch files for loading database tables from flat files using SQL*loader.
  • Developed PL /SQL code for updating payment terms.
  • Created indexes on tables and Optimizing Stored Procedure queries.
  • Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions/enhancement on oracle application.
  • Created Indexes and partitioned the tables to improve the performance of the query.
  • Involved in preparing documentation and user support documents.
  • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, MS- Office, Windows NT 4.0/2000/XP Windows2000.

Confidential

PL/SQL Developer

Responsibilities:

  • Developed SQL Applications for extracting the data from the Oracle tables
  • Run Developed PL/SQL code for updating payment terms.
  • Developed Session beans representing different types of business logic and Entity beans representing data persistent logic.
  • Design and Development of front-end using Java Script, JSP and HTML.
  • Developed JMS components to interact with MQSeries.
  • Migrated Servlets to the J2EE architecture.
  • Validation of front-end screens using Java Script before sending data to the Server.
  • Created SQL statements for the effective retrieval and storage of data from the database.

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

We'd love your feedback!