Oracle Soa-bpel/ Fusion Consultant Resume
IL
SUMMARY
- Over seven years of experience in development, integration and implementation of software applications.
- Experience in Enterprise Application Integration (EAI), Service Oriented Architecture using Oracle SOA Suite and Oracle Fusion Middleware.
- 3 +yearsof experience in Oracle SOA Suite 10/11g.
- Good Understanding in Oracle E-Business Suite General Ledger (GL), Accounts Receivables (AR), Account Payables (AP), Order Management (OM).
- Hands on experience in installing, configuring SOA Suite10g/11g.
- Designed, Configured and Deployed BPEL Processes, ESB /OSB Services using BPEL Process Manager, and Web Logic Server on SOA Suite 10.1.3.x and 11g.
- Expertise in using BPEL process activities, Decision Service, Partner Links and Adapters (File Adapter, FTP Adapter, Database Adapter, Oracle Applications Adapter, JMS Adapter) for developing custom business processes using Oracle BPEL Process Manager and integrating with different systems using Oracle ESB.
- Proficient in Oracle BPEL Workflow Analysis, Human Tasks and Decision Services and integration with Rules Engine.
- Experience in Oracle SOA Suite 11g, including creating composite, mediator, WorkList Application using WLS and EM.
- Excellent knowledge of web-based standards such as SOAP, UDDI, WSDL, XSD, XPath, XSLT and XML.
- Good experience in developing applications based onOracle SOA, J2EE technologies with JSP, BPEL, ESB,Web services.
- Experience in creating values objects, proxy classes and developing JD Edwards Business Services using Jdeveloper.
- Experience in build-deployment using Ant Scripts
- Well versed in using Class diagrams, Use Case diagrams and Sequence diagrams based on UML architecture.
- Good Experience in writing SQL, PL/SQL, Procedures, Functions, and Packages, Triggers in Oracle 10g/9i.
- Experience in development and customization of Oracle Forms 6i, Oracle Reports 6i.
- Strong experience in Code reviewing and troubleshooting.
- Experience in working with operating systems like 2000/XP/Vista, Microsoft Server 2003, UNIX andLINUX.
- Strong Analytical, Problem Solving and debugging skills.
- Excellent communication and verbal skills, team player, quick learner and self-motivated.
TECHNICAL SKILLS
MiddlewareOracle Fusion Middleware 11g , Oracle SOA Suite 10.1.3.x
J2EE Technologies
Java, JDBC, Servlets, EJB 2.0, JSP, JMS, Struts, Spring
ERP
Oracle Applications, JD Edwards
Application/Web Server
Oracle Web logic Server 11g ,Apache Tomcat, Oracle Application Server 10g
BEA WebLogic 8.1/9.2, JBoss 5.0,4.x
Web Services/Technologies
SOAP,WSDL,UDDI,XSD,XML,XSL,XPATH
Database
Oracle 10g/ 9i /8i, MS SQL Server, MySQL
Programming Languages
C, C++, SQL, PL/SQL
IDE / Tools
JDeveloper 10g/11g, Eclipse, SQL Developer, TOAD, Eclipse, Net Beans, SQL Loader, Oracle Forms 6i,Oracle Reports 6i
Scripting Languages
Java Script, Ant Scripts, Unix Shell Scripting, PHP
Operating System
Windows XP/NT/ 2003,UNIX, Red Hat Linux 7.1/ 6.2, Solaris
Protocols
SOAP, LDAP, TCP/IP, HTTP, FTP,
Versioning Tools
CVS, Visual Source Safe (VSS)
Client: Confidential,ILMay 10 - Present
Role: Oracle SOA-BPEL/ Fusion Consultant
Confidential, is a global leader in the fields of animal health and performance products, with thousands of customers worldwide and a global workforce of hardworking employees. Phibro manufacture and market a broad range of medicinal and nutritional products for several animal species. Phibro implemented TMP Integration project while working with ERP and discrete systems- Marcotte, BRILL, DSI, Loftware etc
Marcotte - Batching System which is responsible for sequencing of Orders, machine and process control, and lot traceability within the Order.
BRILL: Is the standard solution for formula creation and optimization which enables manufacturers to develop the most cost-effective recipe for a specific formula based on required ingredients and nutrients.
Responsibilities:
- Integrated JD Edwards and other third party systems like Marcotte, BRILL, DSI, Loftware using Oracle SOA Suite 11.1.1.3 and WLS 10.3.3.
- Involved in Functional Requirements of the project and end - end implementation of the project.
- Worked with different third party systems, JDE team and documented the Technical Integration Requirements for the project.
- Created Mapping documents for the data elements during the integration process.
- Created Business Services for Work Orders, Bill of Materials, ITEM, and Material Issues in JD Edwards.
- Involved in creating proxies, value objects for Business Services in JD Edwards.
- Created Schema's (Validations) for the data elements involved during Integration Process.
- Developed Fusion interface to invoke Marcotte system to create/update a Work Order in real time, by doing HTTP Post.
- Developed Java Web Service as part of invocation process while working with Custom web services of third party systems.
- Used HTTP Binding Adapter to invoke the end point URL of a web service.
- Worked on tweaking WSDL artifacts, while working on third party system like BRILL for their web services and made sure there are no interoperable issues.
- Worked on XSLT transformation, writing custom templates within XSL while using substring, date, concat and other functions.
- Used DVM for translation of data elements between JDE and third party systems.
- Involved in BPEL Process Orchestration.
- Used File Adapter to poll for the files, and inserted records in the Database using DB Adapter.
- Used DB Adapter to call Stored Procedures to update the DB, worked on modifying some of the Procedures.
- Configured JNDI Name, Connection Pools, Data Sources in WLS.
- Implemented Order Management Workflow (Human Task) for BPEL Process using Oracle Task Manager Work List Application for Work Orders Approval.
- Configured Human Work Flow Notification Properties in Enterprise Manager.
- Implemented Error Handling forFusion Interfaces, included fault policies for sending E-mail Notification after certain retries, when fault occurs.
- Creation ofBusiness rulesfor projectusing Rule Author and Integration of Business Rules with BPEL Processes.
- Configured WS-policies for securing SOA Composite Applications.
- Installed SOA Suite 11.1.1.3 on DEV Environment.
- Monitored, Administered Web logic server, Enterprise manager.
- Responsible for Integration and Unit Testing for the Integration Process.
- Developed Configuration Plans, Ant scripts to build and deploy SOA Applications.
Client: Confidential,MIAug 08 - April 10
Role: Oracle SOA-BPEL/ Fusion Consultant
Confidential, is the holding company for four businesses, the most well-known of which is Amway Corporation the pioneer of Multi-level marketing (MLM). MLM is also referred to as Network Marketing is a business distribution model that allows a parent multi-level marketing company to market their products directly to consumers by means of relationship referral and direct selling. This is a Global implementation with Multi Org, Multiple SOB (Set of Books) with MRC (Multiple Reporting Currencies).
Responsibilities:
- As part of the Fusion Interface development Team I was involved in interfacing external Information systems using BPEL processes.
- Integrated several adapters and used different services from BPEL, ESB and OSB environments while calling synchronous and asynchronous processes/operations.
- Involved in writing MD.070, TE.020 and MD.120 documents.
- Developed Order Request outbound interface using ESB and BPEL processes to automatically interface Sales Orders/Delivery information from Oracle Order Management module to Third Party Logistical System.
- Created the Shipment Confirmation inbound interface using BPEL process to process a Ship Response XML message from the third party logistical system to Ship Confirm the Oracle Delivery using custom Ship Confirm PL/SQL API.
- Configured Oracle applications adapter for invoking custom PL/SQL API to send Oder Status update from Oracle Order Management module to External Systems.
- Used FTP Adapter, Database Adapter in BPEL Process to import flat files and update custom tables.
- Created (ESB) which invokes (BPEL) process to select and estimate freight charges for shipment to the End Customer.
- Implemented Order Management Workflow (Human Task) for BPEL Process using Oracle Task Manager Work List Application for order approval.
- Created JDBC Connection Pools, Data Sources and JNDI names in Application Server Control.
- Defined WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition.
- Worked on various applications of database adapters like transferring the data from file to a table, file to a stored procedure.
- Developed BPEL processes to do various database activities like delete, insert, update, merge, inbound polling operation to poll XML instances.
- Implemented several exception handlers forBPELandESB processes in the project.
- Hands on experience in Oracle ADF.
- Created JSF Templates, pages and customized the Order Entry Pages.
- Worked on ADF Bindings, Data Controls and Page Rendering techniques.
- Worked with creating Menus, pop up functionality and used skins to change the look and feel of the Pages.
- Worked on Creating new screens by using ADF, JSF, and Toplink.
- Involved in Fault policiessetup for BPEL synchronous /asynchronous processes.
- Creation ofBusiness rulesfor projectusing Rule Author and Integration of Business Rules with BPEL Processes.
- Responsible for integration and Unit Testing
- Developed Ant scripts to build and deploy the system.
Client: Confidential,Atlanta, GA April 07 - July 08
Role:Oracle SOA - BPEL Consultant
Confidential, one of GE's five main business units, focuses on developing technology for the aviation, energy, oil and gas, transportation, and water processing industries. GE serves customers in more than 100 countries and employs more than 327,000 people worldwide
Description:
The project was analysis and implementation of Oracle Fusion Middleware with J2EE to develop an Auction Management System to streamline the request for quotations (RFQ) process for procuring equipment and supplies.
Responsibilities:
- Involved in writing Technical specifications for the project and provided inputs while creating SOA standards document.
- Developed end to end BPEL flows.
- Invoked ESB's by creating Partner links for Post Auction Setup.
- Developed different Web Services usingWSDL, SOAP on SOA Suite and deployed on Oracle Application Server.
- Configured File Adapters, DB Adapter,and JMS while creating web services.
- Worked on Mapping XML, XSD and XSL Transformations.
- Implemented Work List Applications and developed Human Tasks for Auction bid approval.
- Created connection pools, data source connections, JNDI names in application server.
- Setup Notification events such asAccount approval to the User Group Administrator; send emails, rejection letters to Suppliers.
- Created a BPEL process to pick the Order data file from external system using (FTP adapter to perform data validation and insert the Order information into Order Interface tables (OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL) using Oracle Applications Adapter. The standard Order Import program interface program was scheduled using Oracle Applications concurrent manager to create sales Orders in Order Management module).
- Developed the Open Supply Orders (Purchase Order Outbound) automated batch process using PL/SQL packages to interface Open Purchase Order Lines from Oracle Purchase Order module to Baxter (external system).
- Created a generic BPEL outbound process using FTP Adapter to FTP data files from UNIX interface directory to the corresponding directory on the FTP server. Created a similar inbound process to revise process.
- Responsible for configuring the JDBC to connect to the Oracle database and JNDI to lookup for services from various components and managed security realms.
- Created several exception handlers for BPEL processes.
- Developed various stored procedures, functions and packages to perform various tasks like updating, inserting and deleting the tables.
- Created indexes on some columns of tables to increase the database performance.
- Created Triggers, Packages in PL/SQL for extraction of data from EBS.
- Involved in creation of Business rules according to the business requirements using Rule Author.
- Analyzed the WSDL of the web services that are invoked using partner links in the BPEL processes.
- Configured web services security policies using Oracle Web Services Manager.
- Used ANT scripts for deployment.
Environment:Oracle SOA Suite 10.1.3.1.0/10.1.3.x, Oracle Applications 11i, JSP, JDBC, JSF,Oracle Application Server 10.1.3.x, JDeveloper 10.1.3.3.0, Oracle 9i/10g, Ant.
Client: Confidential,New York, NY Mar 06 - Mar 07
Role: Sr J2EE Developer /Oracle SOA
Confidential, is one of the world's premier providers of wealth management, securities trading and sales, corporate finance and investment banking services.
Description:
Commercial Loan Process System (CLPS) is an intranet-based loan processing management system built to provide originators and underwriters a personalized, dashboard-type visibility into status of any one or all deals in the pipeline. The core of CLPS is a workflow based task management tool helps the stakeholder to complete a task and a conversation thus moving the deal closer to success.
Responsibilities:
- Prepared detailed business and functional systems requirement specifications, relational data modeling, interface agreements, and documenting detail requirements
- Migrated legacy applications deployed on Tomcat to WebSphere Application Server 6.0
- Developed JSP's using Custom Actions, Java Beans, EJB and Servlets using RAD 6.0 and WebSphere Application Server.
- Developed a web-based reporting system with DAO and Apache Struts-Validator using Struts framework.
- Used all the components of Struts Framework like Action Forms, Action Servlets, Action Mappings, Action Errors, and Apache Tiles.
- Extensively used Java Annotations to simplify the code.
- Prepared detailed business and functional systems requirement specifications, relational data modeling, interface agreements, and documenting detail requirements
- Created Connection Factories, Data sources.
- Used JNDI for Naming and directory services.
- Developed a web-based reporting system with DAO and Apache Struts-Validator using Struts framework.
- Used all the components of Struts Framework like Action Forms, Action Servlets, Action Mappings, Action Errors, and Apache Tiles.
- The Presentation layer is developed using Struts and Tiles framework.
- Developed interfaces and their implementation classes for asynchronous communication with the Middle tier (services) using JMS.
- Responsible for writing complex SQL queries and developed the back-end
- Wrote PL/SQL Procedures, triggers, functions for connection with the backend database (Oracle).
- Performed unit-testing of the application using JUnit.
- Worked with Data and application architect to design solutions, to ensure all application development, testing and deployment is done successfully.
Environment: Oracle SOA Suite 10g, Java, J2EE, JSP, JMS, EJB, JavaScript, XML, Struts, Log4j, Spring 2.5, PL/SQL, Oracle 9i, Rational Rose.
Client: Confidential,Olympia, Washington Oct 05 - Mar 06
Role: J2EE Developer
Confidential, is the trusted provider of internet infrastructure services for the networked world. Billions of times each day, VeriSign\'s their SSL, identity and authentication, and domain name services helps companies and consumers all over the world engage in communications and commerce with confidence.
Responsibilities:
- Involved in gathering User Requirements and Analysis for the system.
- Developed detailed Sequence Diagrams during Analysis and Design of the system. Created models for application\'s dynamic behavior including Use-Case Models, Sequence diagrams and Collaboration Diagrams
- Involved in developing EJB components, JSP pages, later deployed and tested the components.
- Developed JSP's,Servlets,Bean components and EJB's.
- Used Struts framework for developing applications
- Involved in configuring JDBC connection pooling to access the oracle database.
- Created various (Back-end) PL/SQL code to implement business rules through procedures, functions, and packages using Oracle.
- Extensive use of PL/SQL programming writing Stored Procedures, Packages and Functions.
- Involved in building and deployment of EAR, WAR, JAR files on development and production environment.
- Wrote Shell Scripts to perform the End of the day job to process feed files that comes from various systems.
- Monitored the error logs using Log4J and fixed the problems.
Environment: Java, J2EE, Servlets, EJB, Struts, JSP JDBC, JBoss 3.2, Oracle 9i,PL/SQL, Web logic Server, Eclipse.
Client:Confidential,IndiaApril 04 - Sep 05
Role:J2EE Developer
Project Name:Online Banking System
Description
Worked as a J2EE developer in the internet team for Online Banking System. This project allows users to withdraw, deposit and transfer credit online.
Responsibilities:
- Involved in software development life cycle (SDLC), Analysis, Design, Development, System and User Acceptance Testing for Online Banking System.
- Involved in interacting with all levels of business and technology staff. Designed and developed a component-based architecture for Online Banking system.
- Implemented Struts Action classes for business logic and bean classes for validation by using Struts Framework.
- Developed Service (EJB) components for middle tier component implementation and implementation of business logic and Inter communication between components is developed by using XML.
- Developed user interface with JSP and used JSP Tag libraries to simplify the complexity of the application.
- Used Struts which is a Controller component to control the Model and the View. For model used struts to interact with standard data access technology, including Enterprise Java Beans and JDBC
- Developed front-end using HTML, JSP, and Struts.
- Performed input validations using Struts Validator Framework and JavaScript.
- Identified and resolved programming issues, Servlets and EJBs performance tuning opportunities.
- Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL languages.
- Performed and reviewed unit tests using JUnit Testing tool.
- Used Eclipse IDE, Weblogic Application Server and Oracle 9i database.
Client: Confidential,India April 03 - Mar 04
Role: Java Developer
Project Name: Order Management System
Description
Developed an online Order Management Process System in Java .This system is used to track and manage order requests. It is integrated with middleware and back end database. Customers can customize their order using this system which has 3-tier architecture. MVC design pattern was used.
Responsibilities
- Designed and developed use cases, class diagrams and sequence diagrams using UML and Rational Rose
- Developed web pages using Servlets and JSPs for generating HTML pages dynamically.
- Developed Java Beans to be used by JSP pages for presenting web content.
- Wrote JavaScript functions for client side validations.
- Implemented database connectivity with JDBC for communication between application and Oracle 8i database.
- Involved in Normalization and wrote SQL Queries, stored procedures, triggers using PL/SQL for retrieving the customer data from the database.
- Implemented Unit test specification for checking inconsistent data types, overflow and under-flow conditions.
Environment: JDBC, JSP, Servlets, EJB, Apache Tomcat 3.x, Struts, XML, EJB, Eclipse (IDE), JDBC, Oracle8i.
EDUCATION:
Computer Science and Information Technology