We provide IT Staff Augmentation Services!

Oracle Soa Developer Resume

3.00/5 (Submit Your Rating)

Oceanport, NJ

SUMMARY:

  • Over 9 years of extensive experience in all phases of software development life cycle (SDLC) that includes Requirement Analysis, Design, Development, Integration, Documentation, Testing, Deployment, Code Management, Maintenance, Enhancements and Quality Control of Client Server Architecture and Web Technologies from medium to large - scale enterprise projects.
  • Extensive experience on Middleware platforms, having designed, developed and leveraged Enterprise Application Integrations.
  • Strong Experience in design, development, testing and documentation of business processes using Oracle SOA Suite 11g/10g (BPEL, ESB/Mediator, OWSM, Rules Engine, BPM Work list, BAM) and Oracle Service Bus/ALSB, Web Center Suite 11g, and JDeveloper 11g/10.x.
  • Expertise in Business Process Execution Language (BPEL) and Enterprise Service Bus (ESB), Oracle Service Bus (OSB) Administration and troubleshooting on Windows, and Unix Environments.
  • Expertise in SOA, EAI, BAM, Data Warehousing, Client-Server, ERP.
  • Expertise in Business Process Integration, Service Orchestration, and Routing using Oracle SOA Suite Fusion Products (BPEL, OSB, ESB, Web Services) and IBM Message Queuing(MQ) Series.
  • Experience in various configurations and tuning of Oracle SOA Suite application server and managed servers.
  • Expertise in using SOA technology adapters Such as File Adapter, FTP Adapter, Database Adapter, EBS Adapter, AQ Adapter, BAM Adapter, MQ Adapter and JMS Adapter for Integration and development of custom business processes using Oracle BPEL and ESB/Mediator.
  • Experience in Integration of Legacy applications, ERP applications, J2EE applications, .Net Applications and PLM/PDM Systems using SOA Suite.
  • Excellent Working Knowledge of Fault Handling framework, Business Rules Engine (Decision Service), BPM WorkList (Human Task), Business Activity Monitoring (BAM) and Oracle Enterprise Messaging Service (OEMS) in SOA Suite 11g and 10g.
  • Expertise in Java, Web Services, XML, XSD, XSLT, XPath, XQuery, WSDL, SOAP, WS-Addressing, WS-Security, WS-Reliable Messaging, OAGIS BOD’s, Canonical Models, JNDI, JDBC.
  • Experience in working with application servers like Oracle Application Server, Oracle Web logic Server.
  • Experience with B2B Integrator to create, manage and integrate trading partners using EDI’s.
  • Proficient in SQL, PL/SQL, database Performance Tuning, UNIX Shell scripting and Oracle 11g/10g/9i/8i
  • Expertise in Oracle Service Component Architecture (SCA).
  • Exposure in Oracle Web Service Manager (OWSM) and Business Activity Monitoring (BAM).
  • Experience on Cross Platform (Web & Client-Server) application development and design using Object Oriented Programming, Java /J2EE technologies.
  • Exposure in Java, J2EE, JavaBeans, EJB,JMS, Applets RMI, Servlets, JSP, JDBC, XML, XSD XSL, XSLT, JNDI, Object oriented design patterns (Enterprise Architecture, Model View Controller (MVC) architecture),Struts framework, Web work, Hibernate, ASP, Ant, Eclipse 3.0, JUnit and other latest open source technologies and LDAP Server on Windows and UNIX environments
  • Hands on experience using Java Developer, Web Services, SOAP, WSDL, XML, XSLT, XPATH, HTML, UDDI in ESB, BPEL service development.
  • Hands on experience with several databases like Oracle, SQL Server, MySQL, Sybase & DB2.
  • Experience in application development, debugging, implementation, supporting development team, testing of Oracle based ERP using SQL, PLSQL, Shell Scripting, PL/SQL packages, Stored Procedures, Functions and Database Triggers etc.
  • Experience in writing ANT build scripts to automate the compilation, creating directory structures, generate classes from WSDL, deploy the services onto the Web Server, and generate JAR and WAR files.
  • Expertise in SOA, Orchestration and Integration Technologies in the areas of Web Services, OSB,ESB, SOAP, BAM, WSDL, BPEL, XML, Messaging, LDAP, BPM, Portal, XSD, OSR, UDDI, XML, Coherence, Collaboration, and Web services Security and Virtualization of Services OWSM.
  • Excellent communication and interpersonal skills.
  • Experienced in handling projects independently as well as leading a team.

TECHNICALSKILLS:

Oracle Middleware Products: Oracle SOA Suite 11g/10g, E: Business Suite (EBS), Enterprise Service Bus (ESB), Oracle Service Bus (OSB), BAM, OTM, BPEL Process Manager, Oracle Web Services Manager, Oracle Rules Author, WorkList Application, Oracle Web Service Manager (OWSM).

Languages: Java /J2EE (EJB, JSP, JDBC, JMS, JNDI, SOAP Web Service), Java Swing, XML, UML, Pro C++ and Shell Programming, C/C++, SQL, PL/SQL.

Operating Systems: Windows 95/98, Windows 2000, Windows XP, Windows 7, Windows NT 4.0, UNIX

Web/Application Servers: WebLogic Server, WebSphere, and Apache/Tomcat, OC4J App server, Oracle BPEL Process Manager.

XML/Web Services: XML, XSD, XSLT, SOAP, DHTML, HTML, UDDI, XSL, VBScript, XPATH, XQUERY, JavaScript.

Adapters: DB Adapter, Oracle Apps Adapter, JMS Adapter, MQ Adapter, FileAdapter, Siebel.

Methodologies: MVC Architecture, Client/Server Architecture

Databases: Oracle 11g/10g/9i/8i, MS SQL Server, PL/SQL, Sybase, Teradata, DB2.

Database Tools: Toad, SQL PLUS, SQL developer, SQL Navigator.

Build Tools: Ant 1.4, Make utility.

Version Control Tools: Visual Safe Source, CVS / RCS, Sub Version.

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

Test Tools: Software Quality Assurance (SQA) tools - Mercury Interactive-Test Director, Load Runner, JCK (Java Compatibility Kit), JUnit.

PROFESSIONAL EXPERIENCE:

Confidential, Oceanport, NJ

Oracle SOA Developer

Responsibilities:

  • Involved in designing, development, testing and deployment of BPEL Process and Mediator Services, Business Rules and Human task.
  • Developed XSD design patterns and BPEL processes.
  • Developed complex schemas and XSLT transformations to read, enhance and process incoming data and map it to E-business Suite Web Service Schemas.
  • Design, trouble shoot and implement BPEL solution for integration between application's task workflow
  • Design and implement error handling framework using the Fault handling framework which logs all errors in the backend and does appropriate actions.
  • Create and configure Business Rules to set the priority of the incoming messages, integrate the same with the BPEL workflow.
  • Developed custom SQL to purge the BPEL instance data from the SOA dehydration store, for ease in Maintenance.
  • Used UMS in several components like BPEL, BAM and Web Center.
  • Used XSLT mediation which allows mapping data from one message type to other.
  • 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 ESB services on to the production server.
  • Worked with AQ Adapters to pick messages from the queues and performance tuned according to its payloads
  • Consumed E-business Suite Web Services to insert new account details.
  • Deployed real-time operational dashboards, monitoring and alerting applications over the web using Oracle Business Activity Monitoring (BAM).
  • Orchestrated the entire business process and human task flows using BPEL Process Manager, ESB, Web Services, WSDL, SOAP, UDDI, XML, Oracle Top Link, and Oracle JDeveloper.
  • Scaled the system to take corrective actions if there are sudden business process environment changes.
  • Used Oracle ESB for content based routing with synchronous/asynchronous messaging techniques to ensure guaranteed notifications to approvers.
  • Customized Workflow Manager to manage chain, Cost Center, Controller and special approvals.
  • Created Approval Rules for Threshold limit, number of approvals and using Oracle Business Rules and Decision services.
  • Created and Configure predictive alerts and notify a distribution list when certain SLA conditions are met.
  • Create UI’s for the Human Workflow interaction.

Environment: Oracle SOA Suite 10.1.3.1/10.1.3.3 , Oracle App Server 10g/Web logic Server 10.3.1, Enterprise Manager, Jdeveloper 10.1.3.4, Oracle BPEL Process Manager 10.1.3.3, BPEL, AQ Adapter, FTP Adapter, DB Adapter, Oracle BAM 10.1.3, XML, Java, B2B, J2EE, JSP Oracle Database 10g.

Confidential, Bloomington, IL

Oracle SOA Developer

Responsibilities:

  • Developed a Service Oriented Architecture (SOA) application services involving designing and creating schemas and WSDL’s (web services) to develop SCAcomposites and OSB proxies to integrate with multiple systems.
  • Extracted CRM data from the existing legacy Customer databases to allow for single point of data entry and loaded into the Oracle based Client server system.
  • Developed complex schemas and XSLT transformations to read, enhance and process incoming data and map it to Web Service Schemas.
  • Worked with Web services extensively providing SOAP fault handling and security propagation and used fault Policies to activate the Custom error handling framework.
  • Design, develop, and deploy the integration through Oracle Aqua Logic Service Bus (OSB) for accessing and exposing Enterprise web services to external systems.
  • Developed complex Proxy Service's Message flows with different types of routing e.g. Static routing, Dynamic routing, Operational branching, Split join etc.
  • Worked on complex Xquery and XSLT transformations to transform internal applications schema to Enterprise schemas.
  • JMS adapter was used for Producing and consuming the messages.
  • Used java embedding activity for executing custom Java Classes for Complex business logic.
  • Used OSB to build Proxy and Business services.
  • 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 Web UI 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.
  • Developed routing tables for dynamic connections to external heterogeneous web services.
  • Design, develop, and deploy the integration BPEL/mediator processes in IDE tool Jdeveloper.
  • Develop processes using AQ and DB adapters of Oracle BPEL and performance tuning them for the expected load, Transformations, Exception Handling, and use of Third Party JDBC Drivers. Added correlation sets for the callback service in BPEL processes.
  • Implemented Exception Handling Reporting application to collect and email error records to business users for exception analysis and possible fix.
  • Implemented multi-layered fault handling to capture Business Fault and System Faults in SOA artifacts.
  • Designed and developed ANT build scripts to deploy composites, Oracle Service Bus Projects and Java applications on Web logic.
  • Worked in all deployment processes to SIT, QA and Production Environments. Handled various errors thrown throughout the process and coordinated with the team.
  • Helped plan the transition of 10g projects. Designed migration of 10g SOA projects to 11g composite applications.
  • Developed BPEL Processes to execute Enterprise Business Flow for removing duplicate contacts.
  • Deployment of multiple SOA SCA’s and Java WAR’s for QA testing and in the production environment using OSB console and EM console.
  • Configure Direct Binding adapters, and configure interfaces in OSB for changes in business requirements
  • Resolve tickets and enhancements from backlog items created during code development.

Environment: Oracle SOA Suite 11.1.1.3/11.1.1.4 , Web logic Server 10.3.3/10.3.4 , Enterprise Manager 11.1.1.3/11.1.1.4 , .Oracle Service Bus 11g, Jdeveloper 11.1.1.3/11.1.1.4 , BPEL, AQ Adapter, FTP Adapter, DB Adapter, XML, Java,B2B, J2EE,J2BC, JSP Oracle Database 11g.

Confidential, Orlando, FL

PLSQL/SOA Developer

Responsibilities:

  • Developed a Service Oriented Architecture (SOA) based design of the collaboration product involving designing and creating schemas and WSDL’s (web services) to develop BPEL processes to integrate various incompatible modules.
  • Design, develop, and deploy the integration through Oracle Aqua Logic Service Bus (OSB) for accessing and exposing web services to external systems.
  • Developed routing tables for dynamic connections to external heterogeneous web services.
  • Deploy, develop and suggest best practice methodologies for developing integration processes between modules in E-Business Suite and IBM MQ series.
  • Configure Application adapters and integration between Oracle E-Business Suite and Oracle Business process manager.
  • Design, develop, and deploy the integration process in IDE tool Jdeveloper.
  • Deploying and Configuring processes which uses MQSeries Adapter.
  • Deploy and test business process for business modules. The modules included transfer of data to and fro client server systems.
  • Develop processes using FTP and DBadapters of Oracle BPEL and performance tuning them for the expected load, Transformations, Exception Handling, and use of Third Party JDBC Drivers.
  • Developed an Order project prototype using Oracle ESB to process and transform complex business process by using different components like JMS, MQ Adapter, SOAP Adapter, File Adapter, and DB Adapter.
  • 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 transaction or a process.
  • Developed Exception handling architecture in BPEL for the whole project to handle all the exceptions and alerts.
  • Developed different SOAP services and Web Services using WSDL, SOAP, AXIS, and Oracle JDeveloper.
  • Developed custom XPath functions in ESB to transform messages.
  • Written SQL Queries to get data from different databases.
  • Developed and enhanced changes in Oracle ESB and BPEL projects as per the business requirements.
  • Extensively used java embedding activity for executing custom Java Classes for Complex business logic.
  • Understanding complex business processes, designing, coding and testing as per the business requirements.
  • Developed Content Delivery System using ADF technologies.
  • Design and implement a generic Error handling and reporting and business process retry mechanism using Oracle AQ and BPEL.
  • Installation of BAM, configuring Users and their appropriate roles.
  • Design develop and integration of BPEL events with BAM to pump real time data.
  • Create multiple dashboards for Front Office as well as Middle Office managers to monitor task status as well individual work basket allocation and completion.
  • 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.
  • Extensive testing was done on the programs for achieving accuracy, timely processing of data.
  • 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 test plans, unit testing, System integration testing, implementation and maintenance.
  • 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.
  • Queries with Sub-clause are used for data retrieval.
  • Developed PL/SQLprocedures to get the legacy data into oracle staging tables
  • Developed triggers to perform the validation as and when the data comes into staging tables
  • Developed the SQL script to do the proper validations on the data from Legacy in staging table.
  • Developed PL/SQLprocedures and functions to run the Process Order API after successful validation of the data from legacy system
  • Unit testing of developed Components.
  • Design of the overall database using Entity Relationship diagrams.
  • Data loading and Extracting function using SQL * Loader.
  • Designed and developed all the Tables, Views for the system in Oracle.

Environment: Oracle Application Server 10.1.3, Oracle SOA SUITE 10.1.3.1/10.1.3.3 , Oracle BPEL Process Manager 10.1.3.3, Oracle E-business Suite R12, Oracle Jdeveloper 10.1.3.3/10.1.3.4 , Oracle Database 10g (PL/SQL), BPEL, File, MQ and DB Adapters, J2EE web services,PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, MS- Office.

Confidential, Bridgewater, NJ

PLSQL/BPEL developer

Responsibilities:

  • Installation of middle tier application server, deploying and configuring Applications adapters and integration between Oracle E-Business Suite and Oracle Business process manager.
  • Administration of BPEL process instances and configuring adapters. Deploy, develop and suggest best practice methodologies for developing integration processes between modules in E-Business Suite and IBM MQ series.
  • Used OSB for virtualization of the E-business Suite web services and transformation.
  • Developed OSB projects in AE using routing tables for dynamic endpoints.
  • Design, develop, and deploy the integration process in IDE tool Jdeveloper.
  • Deploying and Configuring processes which use MQSeries Adapter.
  • Deploy and test business process for business modules. The modules included transfer of data to and fro client server systems.
  • Performance tuning processes for the expected load, Transformations, Exception Handling, and use of Third Party JDBC Drivers.
  • Used transformations to map source xml files to destination schemas.
  • Design and implement a generic Error handling and reporting and business process retry mechanism using Oracle AQ and BPEL.
  • Develop, deploy and test business process for business modules. The modules included transfer of data to and fro client server systems.
  • 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.
  • Created indexes on tables and Optimizing Stored Procedure queries.
  • Design, Development and testing of Reports using SQL*plus.
  • 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.
  • Extensively used Oracle Loader and PL/SQL.
  • Identified business rules for data migration and perform data administration through data models.
  • Performance tuning of SQL queries consisting of many tables with large amount of data.

Environment: Oracle Application Server 10.1.3.4, Oracle BPEL Process Manager 10.1.3.3, Oracle E- Business Suite R12, Oracle Jdeveloper 10.1.3.3/10.1.3.4 , Oracle Service Bus 10g, Web logic Server 8.1Oracle Database 10g (PL/SQL), BPEL, File, JMS and DB Adapters, J2EE web services.

Confidential

Oracle 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.
  • 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 test plans, unit testing, System integration testing, implementation and maintenance.
  • Used Oracle Forms 5.0 was 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.
  • Used Forms 4.5 to create Group, Ledgers, Vouchers and Bank Reconciliation statements
  • 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.
  • Created front-end procedures and functions with Forms 5.0 to calculate reorder level and reorder quantity.
  • Queries with Sub-clause are used for data retrieval.

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

We'd love your feedback!