Sr. Oracle Soa Consultant Resume
Washington, DC
SUMMARY
- 8+ years of extensive IT experience in Design, Development, Implementation and Support using Oracle Fusion Middleware, PL/SQL and JAVA.
- Successfully completed numerous Oracle SOA 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.
- Adept at implementing message validation, transformation, enhancement and error handling in OSB using various features like XQuery, XSLT, Service callout, Java etc.
- Good working experience in Oracle Fusion Middleware stack 11g which includes Oracle SOA Suite (BPEL, Mediator, Business Rules, OWSM, BPM)
- Expertise in using SOA technology and application adapters Such as File Adapter, FTP Adapter, Database Adapter, Apps Adapter, AQ Adapter, BAM Adapter, MQ Adapter and JMS Adapter for integration and development of custom business processes using Oracle BPEL and ESB/Mediator.
- 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.
- Experience in Integration of Legacy applications, ERP applications, J2EE applications, using SOA Suite and OSB.
- Expertise in Java, Web Services, XML, XSD, XSLT, XPath, XQuery, WSDL, SOAP, WS-Addressing, WS-Security, WS-Reliable Messaging, Canonical Models, JNDI, JDBC, SAML.
- Experience in working with application servers like Oracle Application Server, Oracle Weblogic Server.
- Experience in Gap Analysis, designing process flows, technical designs, installation and configuration guides, Test Scripts and having good experience in Oracle AIM Methodology.
- Experience working in different work environments which include reputed software services, product development MNC’s and in house BSS/MIS teams.
TECHNICAL SKILLS
Oracle Fusion: Oracle SOA Suite 11g/10g, BPEL, ESB/Mediator, Technology Adapters (DB, File, FTP, AQ, JMS, MQ, EBS and BAM Adapter), OWSM, OSB, BAMOracle Business Rules, BPM Worklist.
Languages & Scripting: UNIX Shell Scripting, JAVA, SQL, PL/SQL, ANT, HTML, XML COBOL, JSP, JSF
Web/Application Servers: Apache Tomcat 3.x/4.x,Oracle Web-logic 10g/11g, IBM Web-Sphere 5.x/6.x
Databases: Oracle9i/10g/11g, IBMDB2.
Development Tools: TOAD, ECLIPSE, JDEVELOPER, Oracle Reports, Oracle FormsXML publisher, Oracle Workflow builder
Version Control Tools: Visual Safe Source, CVS,SVN
APP/WEB Servers: Oracle Application Server OCJ4, IBM Web sphere, OracleWeblogic, OA Framework.
J2EE: JDBC, JSP, JSF, Servlets, ADF.
Operating System: Linux, AIX, Solaris and Windows.
PROFESSIONAL EXPERIENCE
Confidential
Sr. Oracle SOA consultant
Responsibilities:
- Batch Processing implemented using the BPEL components like File Adapter, FTP Adapter, Database Adapter and AQ Adapter.
- Implemented AIA SPM (Session Pool Management ) to improve performance SOA to Siebel web service invocation.
- Implemented Error handling to catch all kinds for business errors and store them into database tables.
- Implemented custom OWSM polices Federal CMS services VerifySSN, VerifyESI,VerifyNON-ESI and RIDP.
- Performed unit testing and involved in integration testing and QA Testing and production support of various services developed as BPEL modules and exposed as Web services
- Used MDS repository to store all the common artifacts between composites like DVM, XSD, Fault policy and Fault Binding files.
- Created Error logger process for error logging and Error Handler Process for resubmitting the error messages to respective processes.
- DB Adapters, File Adapters and Oracle Apps Adapters were used as Partner Links to create and publish the records to Oracle database.
- Used various features like XPath functions, XSLT, Human Task, OWSM policies, Correlation sets, Preference variables, Dynamic URL mappings
- Worked on Fault handling (catch and catchall), Compensation handlers, Messaging and Alerts and Transformations.
- Developed Ant scripts and configuration plans to move the code between the various development, test and production environments as part of the development life cycle.
- Developed unit test cases and test data to reproduce various business errors and system faults. I was involved in building scripts, which perform various tasks like deploying BPEL/Mediator processes, Domain Value Maps (DVMs), Configuring data sources and connection factories etc.
- Enabled automatic recovery for errors from Fault Handlers and stored in dehydration store. Remote exceptions were automatically handled by the BPEL process.
- Developed Technical design documents(TDDs) for SOA Services
Environment: Oracle Fusion Middleware 11g (Oracle SOA Suite, BPEL, Oracle OSB, Oracle Human Task, Oracle Business Rules, Mediators & Adapters), Oracle Database Server 11g JDeveloper 11g, Eclipse, Oracle Web-logic 11g, Java 1.6, WSDL, XML, JAXB, JAXP, UML.
Confidential, Washington, DC
Sr. Oracle SOA/OSB Consultant
Responsibilities:
- Developed and designed BPEL Processes.
- Rebuilt the J2EE application as a BPEL-based solution.
- Built SOA composites using BPEL/Mediator components that exposed some EBS sales order processing functions as web services accessible by all technology platforms in the enterprise through SOAP/WSDL interface.
- Involved in processing inbound and outbound documents.
- Tested the web services using Soap UI, BPEL Console and Test Suites.
- Involved in implementation of security policy model for SOA, which builds a common service to take care of passing the information pertaining to credentials, roles and responsibility. All this information is encapsulated in the form of a SAML request throughout the business process flows.
- Designed JMS Adapters to actively send and receive messages from various enterprise systems.
- Designed, developed and deployed different SOA tasks using BPEL/Mediator/BAM.
- Involved in few SOA administration tasks such as creating and modifying JNDI and managing data source.
- Configured JDBC connection pools and managed database connections, through JDBC data-sources, and JDBC pools.
- Good Knowledge on properties changes in EM, WLS console.
- Used Oracle ESB features like connecting, document transformation and content based routing.
- Implemented Oracle Service Bus for messaging services, connecting to database and for creating Proxy over existing web services.
- Defined test scenarios and test cases for the different operations of the BPEL service access points.
- Used Oracle Mediator for content based routing with synchronous/asynchronous messaging techniques to ensure guaranteed notifications to approvers.
Environment: Oracle Fusion Middleware, XML, SAML, Oracle BPEL, Oracle Mediator, Oracle BAM, XML, Oracle Application Server, XML, XSD, WSDL, Oracle SOA Suite 11g, JDeveloper 11.1.1.X
Confidential, Charlotte, NC
Oracle SOA Development Consultant
Responsibilities:
- Developed Canonical WSDL’s and XSD’s which can be used across the enterprise.
- Used Java Messaging Services (JMS) for reliable and asynchronous exchange important information such as payment status report.
- Used Assign, Transform, Invoke, Flow and FlowN operations in BPEL workflow.
- Created the Custom components that trigger the BPEL Workflow.
- Created utilities for deploying the OSB and BPEL services that could be used over all applications
- Developing complex composites in Oracle SOA 11g in a way they can be further decomposed into granular processes.
- Used BPM Worklist application for human intervention and to notify business users as per the requirement.
- Performed on-call duties as requested by the client.
- Implemented performance tuning strategies at both server level and process level to meet the SLA and Worked on Groovy Scripting for load testing in Soap UI.
- Configured Database Adapter, JMS Adapter and Data sources to different databases and publish and receive JMS messages.
- 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.
Environment: Oracle Fusion Middleware, JMS, SAML, XML, Oracle BPEL, Oracle ESB, Oracle BAM, DB2, SQL, JSP, XSD, WSDL, Web-logic Server, JDeveloper 11g
Confidential, Dayton, OH
SOA Developer /Oracle Fusion Developer
Responsibilities:
- Installation, Configuration of SOA Suite (BPEL) 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 and Email notification services.
- Created JMS Queues and topics.
- Written MD.70 interface technical design document as per AIA standards based on MD.50 functional design document.
- 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.
- Developed a template for the emails sent by BPEL process manager in Plain Text and HTML.
- Involved in processing inbound and outbound documents.
- Tested the web services using Soap UI, BPEL Console and Test Suites.
- Involved in the deployment of BPEL.
- Involved in designing XSLT Transformation where ever required.
Confidential, Newton, MA
Software Engineer
Responsibilities:
- Involved in analysis, design and development of e-bill payment system as well as account transfer system and developed specs that include use cases, class diagrams, sequence diagrams and activity diagrams
- As a Team member I was involved writing Detailed Level design document (DLD), implementing and unit testing various services. This involved understanding the AIA architecture standards and writing the DLD with the HLD and SRS as a reference.
- Involved in PL/SQL coding, Designing and Deployment of Reports.
- Involved in the creation and testing of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes, and Collections.
- Developed a report for the Web using Java Server Pages. Managers for each branch can view this report from any location and also developed Paper reports based on the same data model.
- Involved in coding, debugging and testing as well as performance tuning of SQL Queries.
- Design and Development of front-end using JSF 1.2, JSP and HTML
- Used JAVA, J2EE, PL/SQL, XML, DB2 and HTML.
- Developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Views and others
- Involved in design and development of interfaces for edge applications. This task primarily involved building business services.
Environment: Java, J2EE, JSP, JSF 1.2, CVS, VSS, XML, Oracle Application Server, 9i, 10g Oracle XML, Microsoft Visio, PL/SQL, UNIX, SQL, PL/SQL, Eclipse, Tomcat
Confidential
Oracle Developer
Responsibilities:
- Participate in design, development and support of various new interfaces.
- Interact with business analysts to understand business requirements.
- Performing code changes, upgrades and code migrations.
- Used SQL to write complex queries.
- Developed reports based on the business requirements
- Developed user procedures and prepared user manuals for the new programs
- Maintained Design document and preformed testing.
Environment: JEE, JDBC, Core Java Oracle 10g, SQL, PL/SQL, SQL*Loader, Forms, Linux, Windows
Confidential
Programmer
Responsibilities:
- PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
- Wrote triggers and packages by using PL/SQL for giving security privileges.
- Used Oracle Forms 5.0 was used to design and develop the interface for the system.
- Involved in analysis, Design, Development phases of the project
- Developed Requirement Specifications, Functional and Technical Design.
- Transferred knowledge to paper using Architectural diagrams, process flows and, documented the whole system which includes data modeling according to SDLC.
Environment: Oracle 9g, PL/SQL and Developer 2000(Forms4.5.0, Reports 2.5).
