We provide IT Staff Augmentation Services!

Sr. Oracle Soa Consultant Resume

4.00/5 (Submit Your Rating)

Memphis, TN

SUMMARY:

  • Experience in Oracle SOA Suite with a strong focus on Business Process Execution Language (BPEL), Enterprise Service Bus (ESB), Oracle Service Bus (OSB) and BPM
  • Expert in Oracle SOA Suite 11g (BPEL, Mediator, Business Rules and Human Tasks) & OSB 11g
  • Expert in Oracle SOA Suite 10g (BPEL, ESB, Business Rules and Human Tasks)
  • Designed, developed and deployed Business Processes Orchestrated in BPEL using Oracle J - Developer and SOA Suite 11g
  • Experience in SOA administration tasks such as creating and modifying JNDI and managing domains and data source
  • Used Header based, Content based routing and Domain Value Maps in Mediators
  • Experience using Web Services like XML, XSLT, XPATH, HTML, UDDI in ESB, BPEL service development
  • Experience working with Testing, Debugging, and Deployment of Applications.
  • Expertise in developing Web services using XML, SOAP and WSDL
  • Excellent experience and knowledge of HTML & XML Technologies (XML, DTD, XSLT and Style Sheets)
  • Extensively worked with File Adapter, DB Adapter and JMS Adapter in the BPEL Workflow as well as Mediator/ESB Activity Flow in Oracle SOA 11g/10g
  • Experience in Oracle OSB to build service proxies that provide features like load balancing, fault-tolerance and dynamic routing to back-end SOA services
  • Excellent Working Knowledge of Fault handling (catch and catchall), Compensation, Messaging and Alerts and Transformations
  • Proficient in testing Web Services using SOAPUI
  • Experienced in developing Test Plans and Test Case Scenarios
  • Experience in configuring OWSM Security Policies
  • Expertise in creating X-Query and XSL Transformations in OSB
  • Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms10g/9i, Reports10g/9i and developing concurrent programs using SQL, PL/SQL
  • Good experience with Oracle RDMS (9i, 10g and 11g), Comfortable developing with SQL, PL/SQL, Tables, Triggers, Stored procedures etc
  • Effective Leadership, Presentation & Communication Skills, both written and verbal
  • Strong organizational & multi-tasking skills, Good Project coordination skills and have an ability to manage rapid changes

TECHNICAL SKILLS:

Programming Languages: C, C++, SQL/PLSQL, BPEL, OSB.

Middleware: Oracle Fusion Middleware 11g (Oracle OSB, SOA Suite, Web logic),10g

Adapters: File, FTP, JMS, DB, AQ Adapter, Oracle Apps Adapter

Web/Application Server: Apache Tomcat 6, Oracle Web logic 10g/11g

Web: JSP, XML, HTML, XSLT XPath, XQuery, CSS, Servlets.

Database Systems: Oracle 9i/10g/11g, Microsoft SQL Server 2005/2008

Developer Tools: Oracle JDeveloper11g, Eclipse, Ant, TOAD, Oracle SQL Developer

Operating Systems: Windows 2000 Server/Professional, Windows 95/98/ME/XP/Vista/7, Linux, Unix, Sun Solaris

Project Management Tools: Microsoft Excel, Microsoft Word, Microsoft Project, Microsoft PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

Sr. Oracle SOA Consultant

Responsibilities:

  • Build, support and maintain enterprise integrations while working very closely with other developers, users, and senior management to enhance, construct, and deliver state-of-the art SOA based integrations.
  • Developed BPEL modules within SOA Suite for creating services that managed data transformation, business workflow, business processing, data routing, and communication with State of WV systems.
  • Created XSD Schemas and XSLT Transformations to read, enhance and process incoming data and map it to Web Service Schemas.
  • Established connection with services using File Adapter, Database Adapter, AQ Adapter and JMS Adapter.
  • Used JMS Adapters for publishing messages into JMS Queue and Topics.
  • Created Queues, Connection Factories and Data sources.
  • Worked on OSB in editing the process flow in Proxy and Business Services and adding the pipelines and performing the activity necessary in the pipeline stage.
  • Developed Exception Handling Architecture in BPEL to handle all exceptions
  • Configured OWSM Security Policies to restrict user access on the services
  • Documentation of deployment procedures, monitoring and support processes, security policies, configuration maintenance, migration procedures, and best practices for each component of the integration architecture.
  • Support and improve existing middleware infrastructure, including Oracle Web Logic, OC4J, and SOA BPEL, including performance, provisioning of new systems, and configuration management.
  • Tested the Web Services using SOAP UI, BPEL Console and Test Suites.
  • Used ANT Script to build & deploy the application and SVN for version control across common source code used by developers.
  • Involved in Patch Upgrade and troubleshooting.
  • Developed ALSB customization files and BPEL config plans for deployment across multiple environments.
  • Resolved application integration issues by coordinating with the external application administration teams.
  • Worked using Oracle SQL Developer for creating tables, inserting and updating records.
  • Providing knowledge transition to team members for the components implemented to production

Environment: Oracle SOA Suite 11g, OSB, Oracle Database, Oracle JDeveloper, Oracle SQL Developer, SOAPUI, MS Visio, ANT

Confidential, Portland, OR

Sr. Oracle SOA Consultant

Responsibilities:

  • Involved in the designing and implementing the application process flow with Oracle BPEL .
  • Extensively worked on the transform activity for the complex BPEL process flows to map the data from the procedures result set to the tables.
  • Configured various Adapters including Database Adapter, File Adapter, BAM Adapter and JMS adapter .
  • Configured FTP adapters for different FTP servers.
  • Configured Data source and JNDI to access the databases using DB Adapter.
  • Used on Alarm branch to manage the timeout condition.
  • Involved in Exception Handling architecture development in BPEL for the whole project to handle all the exceptions and alerts
  • Used FlowN activity to invoke different independent services in parallel.
  • Developed various Web Services using WSDL, SOAP and Oracle JDeveloper.
  • Tested web services using SOAPUI .
  • Created XSLT, XSD, WSDL and XQuery by using Eclipse and importing it to OSB.
  • Worked on OSB to build Proxy and Business services.
  • Experience in Importing and exporting the configuration Jar files into and from OSB respectively.
  • Experience on Error Handling in Proxy and Business services in OSB.
  • Extensively worked on OSB in editing the process flow in Proxy and Business services and adding the pipelines and performing the activity necessary in the pipeline stage.
  • Extensively worked on complex business flows orchestrations involving multiple calls to OSB layer, mediator, Async Web Services, and Business rules.
  • Worked on creating the Data Objects in BAM console.
  • Experience in building the Reports in active studio and Alerts in architect using BAM dashboard .
  • Experience in monitoring Business services and processes which are responsible to multiply the performance of BAM server.
  • Logged error messages in BAM if any lookup is not found or in any error/fault case; notified critical errors/faults through emails from BAM.
  • Worked on adding the BAM sensors to BPEL Process.
  • Created data objects in BAM and configured reports to show lifecycle of both inbound/outbound
  • Worked on Configuring the Data source and JNDI for Database adapter.
  • Involved in the deployment of BPEL, Mediator and ESB services on to the production server.
  • Coordinating with multiple teams while developing and outage scenarios.
  • End-to-end support activity to the business users and with other team.
  • Responsible for Enhancement, maintenance and support OTM/Siebel integration flows.

Environment:: Oracle SOA 11g, OTM 6.1.5, JDeveloper, BAM, XML, BPEL, SOAP, WSDL, CA Work Automation, Log4J, ANT 1.5, Oracle Database.

Confidential, Paris, IL

Oracle SOA Developer

Responsibilities:

  • Developed several XSD and DTD Schemas for XML validations.
  • Experience in Creating and Configuring the BPEL services
  • Developed Synchronous, Asynchronous BPEL processes based on the business need.
  • Used Assign, Transform, Invoke activities of BPEL.
  • Used Java Embedding activity to include java code in BPEL processes.
  • Fault Handling using Catch, Catchall a HTML activities.
  • Implemented Oracle BPEL as middleware for orchestration and connecting to various third party web services.
  • Worked extensively on PL/SQL, XML, DB2 and HTML.
  • Responsible in writing UNIX shell scripts for automating batch jobs.
  • Used Struts Framework for Dependency injection and integrated with the Struts Framework and
  • Configured Database Adapter, JMS Adapter and Data sources to different databases and publish and receive JMS messages.
  • Defined test scenarios and test cases for the different operations of the BPEL service access points.

Environment:: Oracle SOA 11g, OTM 6.1.5, JDeveloper, JMS Adapter, Database Adapter, XML, BPEL, SOAP, WSDL, Catch, catchall, PL/SQL, Oracle Database. Invoke Activities.

Confidential, Chicago, IL

Oracle SOA Developer

Responsibilities:

  • Design and develop integration solution between different 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 DBA to create JNDI’s, Data Sources, Connection Factories, and Configured and deployed the plans for all technology adapters like DB Adapter, JMS Adapter and AQ Adapter.
  • Participated in installation, configuration and implementation of Oracle SOA Suite 11g and OSB.
  • Worked on PL/SQL packages which will be invoked from SOA layer to insert the data into SLA tables.
  • Worked on enhancements and change requests, bug fixing, testing and deployments of SOA composites and OSB services.
  • Coordinated all the testing and deployment efforts in various environments.
  • Worked with complex wrapper packages, loops, XSLT’s, error handling and tuning of SOA composites.
  • Design develop common error handling framework, re-submission framework and audit trial framework for middleware components.
  • Created BAM objects, reports, dash boards for real time data transfer and processing of claims from OHI to EBS.
  • Used various features like XPath functions, XSLT, XREF tables, DVMs, Human Task, OWSM policies, Correlation sets etc. to build SOA composites and OSB services.
  • Trained Jr. Developers, users to help the developers with their development and users to make them understand about the tools and helped them in gathering the business requirements by analyzing the technical feasibilities of the Oracle Fusion Tools.

Environment: Oracle SOA Suite 11g, OSB, Oracle Database, Oracle JDeveloper, Oracle SQL Developer, SOAPUI, XREF, XSLT,XPATH, EBS, BAM, OWSM, DVMs, Human Task, Correlation sets

Confidential, Chicago, IL

Middleware Engineer(Implementation/Enhancements)

Responsibilities:

  • Managing and Monitoring the JVM Performance by adjusting WebLogic heap size and garbage collection parameters
  • Monitor and manage SOA Components by using the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks
  • Configuring, Deploying and Monitoring the SOA composite applications
  • Monitor and manage SOA Components by using the Oracle Enterprise Manager and Fusion Admin Console to perform administrative tasks
  • 11g Design, develop and deploy Business Processes Orchestrated in BPEL and ESB using Oracle Jdeveloper and SOA Suite
  • Fully designed and developed a BPEL process to validate and transform data in Oracle Configuration tables to the Database using Database Adapter
  • Worked on JMS, Database, File and SOAP adapters for Oracle ESB

Environment: Oracle Weblogic Server, Oracle SOA Suite 11g,OSB, BPEL, Mediator, OWSM, JDeveloper 11g, Oracle Database, PL/SQL, TOAD,, JDBC, ANT, XML, XSLT, XPath, XQuery.

Confidential

Oracle PL/SQL 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.
  • Oracle Forms 5.0 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.
  • Created Group, Ledgers, Vouchers and Bank Reconciliation statements by using Forms 4.5.
  • Created front-end procedures
  • Created functions with Forms 5.0 to calculate reorder level and reorder quantity.

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

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Verification of functional specifications and review of deliverable.
  • 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.
  • Created Packages, Procedures and Functions that extensively used PL/SQL cursors, user defined object types and exception handling.
  • Used SQL trace facility, to accurately assess the efficiency of the SQL statements when the application runs.
  • Created complex procedures.
  • Queries with Sub-clause are used for data retrieval.

Environment: Oracle 9i, SQL, PL/SQL, Erwin Tool 3.5.2, Shell Scripting, UNIX, Sun Solaris.

We'd love your feedback!