Sr.soa/bpel Consultant Resume
Summary
- 7 years of professional experience in the Industry with strong hands on Architectural and Development experience in SOA, ESB, Enterprise Application Integrations, B2B Integrations, client-server, Data Warehousing and ERP.
- 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.
- Worked on Business Process Management (PM) life-cycle to manage, design, monitor and optimize the various existing processes.
- Good Knowledge in Telecom, Banking, Insurance, Energy, Data Warehouse, Logistics & Transportation, Hospitality and Outsourced Business Solutions domains.
- Extensive experience on Middleware platforms, having designed, developed and leveraged Enterprise Application Integrations & B2B Integration solutions, for numerous customers.
- Good working experience in SOA/Web Services (SOAP, WSDL, UDDI), ESB, BPEL for realizing SOA architecture
- Expertise in using Technology Adapters for integration using Oracle ESB and in the development of custom business processes using Oracle BPEL Process Manager.
- Expertise in Mediator for evaluating routing rules, performing transformations, applying optional time delays, and in invoking services or raising a business event.
- Designed and developed components for Web Services (WSDL, SOAP) development based on SOA environment.
- Experienced in handling projects independently as well as leading a team.
- Skilled at programming on different Java IDE’s like Oracle JDeveloper, Eclipse, NetBeans & JBuilder.
- Experience in using Oracle Technical adapters for integration using Oracle ESB and for development of custom business processes using Oracle BPEL Process Manager.
- Expertise in Design and Development of ESB Interfaces for Routing services, Adapter Services, SOAP Services.
- Performance tuning, production support for BPEL, ESB services.
- Expertise in Business Process Integration, Service Orchestration, and Routing using Oracle SOA Suite Fusion Products.
- Good knowledge in BAM applications, Business Rules in SOA
- Experience in application development, debugging, implementation, supporting dev team, testing of Oracle based ERP using SQL, PLSQL, Shell Scripting, Database Triggers etc.
- Extensive Experience in working with PL/SQL packages, Stored Procedures, Functions and Triggers
- Excellent experience in product technical support for installation, configuration and deployment and integration with different systems.
- Knowledge on Oracle Service Bus.
- Excellent communication skills with strong work ethics and have consistently demonstrated strong teamwork.
- Able to work effectively at all organizational levels and have an ability to manage rapid changes.
Technical Skills:
Middleware : Oracle SOA 11.1.1.5, E-Business Suite(EBS), Enterprise Service
Bus (ESB), Oracle Service Bus, BAM, BPEL Process Manager,
Oracle Rules Author, Oracle Web Service Manager (OWSM)
Application Servers : Oracle Application Server 10g/11g, Oracle BEA J2EE Web
Logic Server, Apache Tomcat.
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, SQL*Loader
Web 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 : JDeveloper 11g, 10.1.3.4,Net Beans, IBM Visual Age, JBuilder,
Eclipse.
Markup languages : HTML, XML, XSD, XPath, XSLT
Web Applications : JSP, JavaScript
Operating Systems : Windows, Unix, Linux, Sun Solaris
EDUCATION
- Master of Science in Computer Science .
- Bachelor of Engineering in Computer Science and Engineering
Experience:
Confidential, Orlando, FL July 2010 - Present
Sr.SOA/BPEL Consultant
Project: Client Invoice Services (CIS) is a global invoice payment, validation and consolidation application with servers in the US, England, Australia and Hong Kong. CIS stores granular invoice detail and client specific information, and feeds appropriate data to accounts payable and/or billing systems such as IBS/UB, ACUS. CIS supports payment of invoices in country / in currency. CIS is front ended by our EDI gateway that enables e-bonding with internal source billers and external 3rd party vendors for receipt of invoices to be validated and paid, including EDI, CABS, XML and other delimited files. CIS processes approximately 200K invoices per month with 94% automation in support of many AT&T large business customers such as Shell, GM, State of California, State of Georgia, and State of Texas etc. CIS supports approximately $1.2B in annual billed revenue.
Responsibilities:
- Developed various Web Services using WSDL, SOAP and Oracle JDeveloper.
- Implemented the concepts of AIA using components of Oracle SOA Suite.
- Process Integration Pack(PIP) developed based on Oracle Application Integration Architecture(AIA).
- Suggested design approaches to the solution designer to capture the requirements, for integration part.
- Developed and Registered Various ESB services.
- Prepared XML schema’s for Design Patterns.
- DB Adapters, File Adapters and AQ Adapters were used as Partner Links in the design of the application through BPEL.
- Used Multithreading in Java Client and parallel processing in BPEL processes to increase performance.
- 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.
- Designed and built Session Façade frame work to control the Data Models.
- Mapped Persistent data objects and stored using TopLink objects.
- Used ADF to create entity objects and associations between heterogeneous systems as the web front end for reporting and various other functionalities.
- DB Adapters, File Adapters and Oracle Apps Adapters were used as Partner Links to create and publish the records to Oracle database using BPEL.
- Correlate BPEL sensor data from different instances and different activities from same instance and store the data in BAM.
- Extensively worked on Exception handling which allows the BPEL processes to handle exceptions.
- Extensively worked on Oracle BPEL for creating new processes and enhancing the existing process models as per the B2B\'s.
- Written SQL queries to query dehydration store to monitor the transactions processing at a given intervals.
- Identify, classify, assign and publish services in Oracle Service Registry(OSR).
- Design BAM dashboards for process monitoring: through put, response times, process states, performance figures.
- JMS adaptor was used for Producing and consuming the messages.
- Involved in designing XSLT Transformation wherever needed.
- Developed a custom ANT script for automating the deployment of ESB projects.
Environment: Oracle SOA Suite 11.1.1.5, Oracle Web Logic server 10.3, SQL, Oracle AIA Foundation Pack 2.2, Oracle BAM, JDeveloper 11g, BPEL Process Manager, ESB, Oracle database 10g PL/SQL, TOAD.
Confidential, Lake Forest, IL February 2010 – June 2010
SOA Developer /Oracle Fusion Developer
Responsibilities:
- Installation, Configuration of SOA Suite (BPEL, ESB Business Rules) and JDeveloper10g.
- Involved in building Human Workflow to create a user interface to process the task running the workflow process.
- Used FlowN activity to invoke different independent services in parallel.
- Configured various Adapters including Database, AQ and Email notification services.
- Implemented concepts of AIA using components of oracle SOA suite- BPEL, ESB.
- Designed and developed a framework for Fault handling in BPEL processes, Java classes and PL/SQL APIs in the project.
- Developed custom SQL to purge the BPEL instance data from the SOA dehydration store, for ease in maintenance.
- Used Assign ,Transform ,Invoke ,Flow and Switch operations in BPEL workflow.
- Created the Custom components that triggers the BPEL Workflow.
- Batch Processing implemented using the BPEL components like File Adapter, FTP Adapter, Database Adapter and AQ Adapter.
- Used SOAP, XML, XPATH, and JMS to send and receive data.
- Extracting document content via a web service / BPEL process.
- Developed a template for the emails sent by BPEL process manager in Plain Text and HTML.
- Tested the web services using Soap UI, BPEL Console and Test Suites.
- Involved in the deployment of BPEL and ESB services on to the production server.
- Involved in designing XSLT Transformation where ever required.
Environment: Oracle SOA Suite 11g, JDBC, Flatfile, MQ Series, XML, Java, SOAP, WSDL, Web Services, SQL Server, Oracle10g.
Confidential, St. Louis, MO September 2008 - January 2010
SOA Developer
Responsibilities:
- Used JMS adapter (Java Message service) for Producing and consuming the messages.
- Used DB adapter to poll for the changes in a database and also for the lookups.
- Extensively used XSLT, XSD, and WSDL.
- Developed various Web Services using WSDL, SOAP and Oracle JDeveloper.
- Prepared Design Patterns in XML schemas.
- Designed XSLT Transformation wherever needed.
- Tested the web services using Soap UI, BPEL Console and Test Suites.
- Used OSB to build Proxy and Business services.
- Created performance test scenarios and tested the performance of web services using an open source load test tool Load UI.
- Used Fault Policies to activate the Custom error handling framework.
- Extensively worked on Database adapter and FTP adapter, and configured JNDI and Data Source.
- Created Stubs to test the BPEL.
- Part of a development team in developing Framework for error handling with BPEL fault notification handlers.
- Defined WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition.
- 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.
- Developed Human Workflow using Oracle Task Manager Worklist Application for the Approvals of the ECO in Oracle Applications.
- 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.
Environment: Oracle Applications server 10g, SQL, PL/SQL, TOAD, Oracle BAM, Oracle SOA Suite 11g, JDeveloper 11g, BPEL Process Manager, ESB, Oracle database 10gR2, Eclipse, SoapUI.
Confidential, Colorado Springs, CO November 2007-August 2008
SOA Developer
SOA Consultant - This project is to integrate the Siebel CRM with back end legacy systems utilizing Oracle SOA Suite. As they migrated from Siebel 6.3 to Siebel 7.8, it was required to integrate with the existing back end systems to support the business. Some of the integrated components are (Order, Asset, Accounts, Products, Contacts, Projects, Position, Responsibility, Employee, and Billing).
Responsibilities:
- Involved in various phases of Software Development Life Cycle (SDLC) such as modeling, system analysis and design, code generation.
- Design and developed middle ware solution for interfaces using BPEL Process Manager and JDeveloper
- Installation, Configuration of SOA Suite (BPEL, ESB Business Rules) and JDeveloper10g.
- Involved in POC, and developed a model with BPEL. Partnerlinks, XSD, WSDL.
- Plan and conduct unit and integration testing including test case documentation
- Configured various Adapters including Database, AQ and Email notification services.
- Designed and developed a framework for Fault handling in BPEL processes, Java classes and PL/SQL APIs in the project.
- Developed an authentication process for customers and integrated with Rules Engine.
- Designed and developed a BPEL process with multiple operations to search, to load LOVs from Oracle and load dimensions from Oracle and deployed in ESB to route PL/SQL procedures based on Search Type and other criteria.
- Worked on Oracle Service Bus proven, lightweight and scalable SOA integration platform that delivers low-cost, standards-based integration for high-volume, mission critical SOA environments.
- Worked on (OBS) Oracle Service Bus provides built-in management and monitoring capabilities and supports out-of-the-box integration with SOA Governance products.
- Worked on 24 x 7 time frame that deliver stringent SLAs with intelligent load balancing and in-built high-availability infrastructure
- Worked on Oracle Customer Relationship Management (CRM) application to driven sales, service, and marketing.
- Designed and developed a service to send notifications upon Order booking.
- Developed Interface Program for creation of Purchase Orders using BPEL Process. Modified/maintained Oracle Workflow for PO approval process and setup users for notifications.
Environment: Oracle SOA Suite 10.1.3.1, Siebel 7.8,JDBC, Flatfile, MQ Series, XML, Java, SOAP, WSDL, Web Services, SQL Server, Oracle10g.
Confidential, Philadelphia, PA June 2006 – October 2007
SOA Developer
Responsibilities:
- Developed and designed BPEL Processes.
- Rebuilt the J2EE application as a BPEL-based solution.
- Wrote custom business rules on the database side.
- Designed Database Adapters to poll for new call details and sync data from multiple systems
- Designed BPEL process invokes a number of services, which includes going out directly to the source of the call detail records to get the information necessary to enrich the event data.
- Designed JMS Adapters to actively send and receive messages from various enterprise systems.
- Configured Database Adapter, JMS Adapter and Data sources to different databases and publish and receive JMS messages.
- Used Flow, Flow N, human task, empty, terminate, switch in the BPEL process.
- 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.
- Created, Configured and Managed Oracle ESB (Enterprise Service Bus).
- Used Oracle ESB features like connecting, document transformation and content based routing.
- Defined test scenarios and test cases for the different operations of the BPEL service access points.
- Developed unit test cases and test data to reproduce various business errors and system faults.
Environment: Oracle Fusion Middleware, XML, SQL2005, Oracle BPEL, Oracle ESB, Oracle BAM, XML, Oracle Application Server, XML, XSD, WSDL, Microsoft Visio.
Confidential. Scranton, PA Jan 2005- May 2006
SWIF (State Workers Insurance Fund), Bureau of Business Application Development
Oracle Developer
Responsibilities:
- Production and test environment support for code/data investigations and finalizations; update/maintenance of application rules and tables.
- Modify and maintains existing forms, reports and queries to optimize performance. Gather and analyze report requirements from clients. Develop parameter driven reports against stored procedure, query, based on multiple databases that are deployed using Oracle 9i /10g, Forms/Reports 9i.
- Develop and executed test cases to verify integrity of report results. Troubleshoot and document processing errors and data integrity issues.
- Worked with the end users to get the business requirements to generate the key reports for the annual statements.
- Wrote SQL statements, SQL Query tuning, schemas and PL/SQL code. Created SQL*plus reports as per client\'s various needs, and developed business objects.
- Involved in creating SQL queries.
- Developed forms and reports using Forms 9i and Reports 9i.
- Created tables, views, triggers, packages, stored procedures and functions to calculate various values for available quantity, manage allocations, pick quantities and pick release for multiple allocations/single allocations.
- Wrote complex SQL queries for reports and PL/SQL code for report triggers before/after for validation of user input.
- Created paper and web reports.
- Developed complicated Oracle Reports with formula columns, computed columns.
Modified report formats by controlling the print direction and pagination of the Repeating frame, spacing between records. - Used format triggers for masking date time and currency formats and validation triggers.
- Wrote code for form-level, block-level and item-level validation of data in Oracle forms.
- Wrote UNIX shell scripts to automate data load processes, wrapper.
- Developed transactional screens to enable user interaction and enforce data integrity and business rules, database transactions and database inquiry.
Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, Oracle Developer 2000, Forms 9i, Reports 9i, Toad, Shell Scripting, UNIX, HTML, Windows XP/NT.
Confidential, Columbus, OH Mar 2004 – Dec 2004
Oracle Developer
Account Transaction System
Responsibilities:
- Created and managed many objects in large Oracle Databases containing millions of records.
- Performed design, coding, implementation and support.
- Monitor existing SQL code and do performance tuning if necessary
- Used EXPLAIN PLAN, ANALYZE, HINTS, TK-Prof and SQL Trace to tune queries for better performance and also Extensive Usage of Indexes.
- Loaded and unloaded data sets from or to Oracle Databases using various kinds of data loading tools such as SQL*Loader and Oracle Import/Export Utility
- Wrote Stored Procedure, Package and Triggers.
- Designed and developed a custom database (Tables, Views, Functions, Procedures, Packages)
- Wrote complex SQL queries usingjoins and correlated sub queries.
- Validations have been done in front-end and as will in backend using triggers.
- Developed Unix Shell scripts to automate repetitive database processes.
- Integrated, tested, debugged and implemented application systems
- Prepared the detailed design documentation for business requirements.
- Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes
Environment: Oracle 9i/10g, UNIX, PL/SQL, SQL*PLUS, SQL, TOAD, SQL*Loader, Reports & Forms 9i, Windows XP, HTML, UNIX.