SUMMARY:

• 8+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.
• Successfully completed numerous Oracle SOA and Oracle EBS implementations, involving in complete SDLC which includes analysis, design, documentation, development, testing, deployments, support and enhancements using waterfall as well as agile methodologies in top-down and bottom-up approaches.
• Expertise in Enterprise Service Bus (ESB), Oracle Mediator, Java Message Service (JMS) Queues, Oracle Advanced Queues (AQ), Oracle Resource Adapters.
• Knowledge in Oracle Business Activity Monitoring (BAM), Oracle Application Development Framework (ADF), and Oracle Enterprise Messaging Service (OEMS).
• 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) Oracle Service Bus/ALSB and AIA PIP
• Expertise in designing and building robust and fault - tolerant Fusion Middleware components in BPEL and OSB using the Oracle Fault Management Framework and catch/compensate activities.
• Knowledge on creating proxy and task services using Oracle Service Bus ( OSB ).
• Worked extensively on XQuery and XSLT transformations in OSB to provide mapping between the consumer and provider business service.
• Expertise in using SOA technology and application 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
• Expertise in Design and Development of ESB Interfaces for Routing services, Adapter Services, SOAP Services.
• Extensive experience in developing Oracle Fusion integration with Siebel CRM.
• Excellent Working Knowledge of Fault Handling framework, Business Rules Engine (Decision Service), BPM Work list (Human Task), Business Activity Monitoring (BAM), domain Value Maps (DVM), XREF tables and Oracle Enterprise Messaging Service (OEMS) in SOA Suite 11g and 10g
• Experience with B2B Integrator to create, manage and integrate trading partners using EDI’s
• Experience in full life cycle implementations, production support, and upgrade of Oracle Applications as techno-functional consultant includes various modules like Supply Chain Management (OM, QP, WSH, INV and PO), Financials (AP, AR, GL, FA and PA) and Manufacturing (ASCP/MRP, BOM, ECO and WIP), all aspects of Application Object Library (AOL) and System admin.
• Experience on Cross Platform (Web & Client-Server) application development and design using Object Oriented Programming, Java /J2EE technologies.
• 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.
• Good knowledge about version control tools such as CVS, PVCS, VSS, Star Team, SVN and Clear Case
• 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: Oracle SOA 11.1.1.5, E-Business Suite (EBS), Enterprise Service Bus (ESB), Oracle Service Bus, Application Development Framework (ADF), Oracle AIA, BAM, BPEL Process Manager, Oracle Mediator, Oracle Rules Author, Oracle Web Service Manager (OWSM).

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

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

Build Tools: Ant 1.4, Make utility.

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

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

Web Applications: JSP, JavaScript

Operating Systems: Windows, UNIX, Linux, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle SOA/ OSB Consultant

Responsibilities:

• Responsible for delivering multiple middleware projects successfully as a developer and offshore coordinator
• Participated in all the design and architectural review meetings to present the solution to the client
• Installation and Configuration of Oracle Fusion 12.2.1.0.0
• Responsible for setting up and maintaining Oracle SOA 12c in DOCKER.
• Prepared process flows, technical design documents, and installation and configuration guides, UTR’s for all the SOA interfaces I have developed.
• Implemented successful migration of business from Fusion Middleware 11 g to Fusion Middleware 12 C .
• Developed order and item service flows to integrate .Net systems and external third party systems using BPEL, Mediator and OSB
• Developed all the item flows for item integration using proxy services and business services in OSB.
• Developed partner link BPEL using web service adapter to invoke URL Based OSB and other services.
• Developed order flows for order integration using OSB proxy services, business services, SOA composite (BPEL, Mediator)
• Used BPM Worklist application for human intervention and to notify business users as per the requirement.
• Experience with Oracle Enterprise Manager 12c OEM12c and configuration of SOA Management packs to Monitor and Manage SOA applications Runtime Infrastructure.
• Used Oracle Business Rules to define rules to identify the third-party vendors for the order flows
• Configured and used various adapters like File Adapter, FPT Adapter, DB Adapter, JMS Adapter, AQ Adapter, and BAM Adapter.
• Developed Canonical WSDL’s and XSD’s which can be used across the enterprise.
• Developed re-submission mechanism to re-submit the failed instances using ADF, BPEL and OSB.
• Used Oracle BAM extensively for all the process monitoring, reporting and alerts.
• Coordinated all the efforts with offshore development team in design, build, testing and deployment.
• Developed test cases using SOAP UI and JRA recordings to perform load testing and analysed performance of all the SOA services to identify the bottlenecks and tune accordingly.
• Used various middleware technologies like WSDL, SOAP, XML, XSD, XPath, XSLT, Sensors, Correlation Sets, Parallel processing, Canonical Models, BOD’s, DVM, OWSM, OEM and BPM in design and development of the services.

Environment: Oracle SOA Suite 11g, Web Logic Application Server, BPEL, Mediator, OSB, Oracle BAM, BPM Worklist, BRE, OWSM, JDeveloper 11g, Oracle 11g, PL/SQL, TOAD, ADF, Java, JSP, JDBC, ANT, XML, XSLT, XPath, XQuery

Confidential, Quincy, MA

Oracle SOA/BPEL/ OSB Consultant

Responsibilities:

• Involved in various phases of Software Development Life Cycle (SDLC).
• Extensively used Oracle BPEL to build composite services and business processes.
• Design, develop integration solution between Oracle health insurance and Oracle E-Business Suite systems using BPEL, Mediator, OSB Proxy and Business Services to transfer various types of claims data from OHI to EBS for invoicing and ledger accounting.
• Worked with various adapters like DB, EBS, File, FTP, AQ and JMS to build the interface solution
• Worked with Oracle OSB to build service proxies for virtualizing that provided features like load balancing, fault-tolerance, dynamic transformation and dynamic routing to back-end SOA services which involves dealing with XQUERY and XSLT.
• Created Stubs to test the OSB services. Used SoapUI for testing the Endpoint URL
• Worked on developing OSB services supporting various protocols including JMS, FTP and DB.
• Worked on XQuery Transformations in OSB 11g.
• Worked on creating OSB Services on WSDL based, XML based and Message types
• Configured JNDI, Integration Connections, DBConnections on Oracle Application Server.
• Worked on improving the performance of 11g Purge Process.
• Used various adapters like File Adapter, FTP Adapter, DB Adapter, JMS Adapter as part of a BPEL Process.
• Used Java Embedding activity for executing Java classes for complex business logic.
• 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 1.1, SOAP 1.1, AXIS 1.2, and Oracle JDeveloper.
• Extensively used WSDL, XSD’s while creating BPEL process models.
• Extensively worked on XML, DTD, XSD, and XSLT.
• Used Assign activity to define the copy rules and add expressions in a BPEL process.
• Written SQL queries to query dehydration store to monitor the transactions processing at a given intervals.
• Worked on PL/SQL packages which will be invoked from SOA layer to insert the data into SLAtables
• Worked with complex wrapper packages, loops, XSLT’s, error handling and tuning of SOAcomposites.
• Design develop common error handling framework, re-submission framework and audit trial framework for middleware components.

Environment: Oracle SOA Suite 11g, OSB, Oracle WebLogic 10.3, Oracle Database 11g, Oracle BPEL Console, Oracle SQLDeveloper 10g, Oracle JDeveloper, TOAD, MS Office 2003, Microsoft Visual Studio 2005, Axis1.4, Java 1.5, J2EE.

Confidential, Erie, PA

Oracle SOA-BPEL Consultant

Responsibilities:

• To capture the requirements of integration I suggested design approaches to the solution designer for integration part.
• Implemented the concepts of AIA - EBO, EBS and ABCS using components of Oracle SOA Suite - BPEL, ESB.
• Developed Requester ABCS and Provider ABCS and have done OWSM gateway configurations.
• Process Integration Pack(PIP) developed based on Oracle Application Integration Architecture(AIA)
• Developed various Web Services using WSDL, SOAP and Oracle JDeveloper
• Developed and Registered Various ESB services.
• Designed and developed an ESB to route to a different procedure on Oracle EBS.
• Developed ESB routing rules, groups and systems. Implemented the rules in Rule Engine.
• Performed GAP analysis.
• Prepared XML schema’s for Design Patterns.
• Design and Implement error handling using the Fault handling framework.
• Extensively worked on Exception handling which allows the BPEL processes to handle exceptions.
• DB Adapters, File Adapters and AQ Adapters were used as Partner Links in the design of the application through BPEL.
• AQs were used in the design of various BPEL processes for DE Queues purposes.
• Designed various BPEL sensor design and sensor messages.
• Correlate BPEL sensor data from different instances and different activities from same instance and store the data in BAM.
• 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.
• For automating the deployment of the ESB projects, developed a custom ANT script.

Environment: Oracle Applications server 10g, SQL, Oracle AIA Foundation Pack 2.2, PL/SQL, TOAD, Oracle BAM, Oracle SOA Suite 10.3.3, JDeveloper 10g, BPEL Process Manager, ESB, Oracle database 10gR2.

Confidential, Bloomington, IL

Enterprise Management System (EMS) Developer

Responsibilities:

• Gathering system requirements through client interactions for manufacturing, accounts receivables and other modules.
• Analyze the client requirements and decide upon the various design changes to be made in the system using D2K.
• Testing stored procedures, programs (FORMS6i) before deploying into the production database.
• Debugging the existing code.
• Development and review of Low Level Design documents for individual components.
• Developing reports using PL/SQL from the various databases.
• Customized AR module as per the customer’s requirement using Forms 6i/4.5. Designed and developed interactive forms to support data entry, querying and updating the Oracle database.
• Developed PL/SQL packages, Oracle tables, stored procedures, triggers and Unix shell scripts.
• Involved in Unit testing and Integration testing of forms and reports.
• Code walk through to optimize the validated code.
• Created batch job in regular maintenance, production support to load the data using shell scripts, PL/SQL.
• Conducted training and information sessions for end users.
• Query optimization through the use of diagnostic tools like Explain Plan. Coordinated with other developers in tuning long running SQL queries to enhance system performance.
• Setting up and managing Oracle database replication among development and production databases.
• Configuration Management using SCCS.
• Change Requirements Servicing, Bug Fixes, Testing and Integration and releases of the enhanced programs.
• Work directly with non-IT business analysts throughout the development cycle, and provide post- implementation support, once developed including investigation of data and report issues identified by customers.

Environment: Oracle 9i/8i, PL/SQL, SQL PLUS, Sun Solaris 5.6, SQL*Loader, HP UX 10.2, SQL Server 7, TOAD, SCCS, forms 4.5/6i, Reports 2.5/6i.

Confidential

Oracle Developer

Responsibilities:

• Performed a proof-of-concept to establish the feasibility of a possible integration between the said systems, while analyzing standard features and potential incompatibilities associated with them.
• Designed the architecture for the project based upon the features and capabilities associated with the applications, needed to be integrated.
• Leveraged Oracle Business Event System framework to fetch necessary information from EBS and publish it to middleware.
• Implementation and development of Oracle ESB module.
• Installed and configured the high availability setup for Oracle ESB. This includes setting up Oracle application servers and Apache web servers in a cluster, installing the runtime and repository ESB components and configuring the web servers with a load balancer. The high-availability implementation is done on Linux servers.
• 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.
• 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.

Environment: Oracle, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, MS- Office, WindowsNT 4.0/2000/XP Windows2000.