Oracle Soa Consultant Resume
FL
SUMMARY:
- Highly skilled IT professional around 7 years of experience and expertise in software design and development in SOA/OSB/BPM/BPEL/Oracle platform based applications, projects and products.
- Extensive experience in Web Service Orchestration using Oracle BPEL Manager and Oracle Service Bus (OSB).
- Extensive experience with design, development and deployment of business process integration using Oracle SOA - Fusion Middleware, BPEL (Business Process Execution Language), OSB (Oracle Service Bus).
- Experienced at working with Oracle SOA Suite 11g SCA composites and components like BPEL process, Mediator, Business Rules, Human Workflows in JDeveloper.
- Extensively used following SOA Suite technology adapters for integration solutions between enterprise apps: Database, JMS, B2B, FTP, File, Web Service, BAM, and Oracle applications.
- Expertise in Design and Development of OSB Interfaces for Routing services and proxy services.
- Hands on experience using Java Developer, Web Services, SOAP, WSDL, XML, XSLT, XPATH, HTML, UDDI in ESB, BPEL service development.
- Exposure in Oracle Web Service Manager (OWSM) and Business Activity Monitoring (BAM)
- In depth understanding of Business Rules implementation, expertise in implementing business rules using Oracle Rules Engine.
- Hands on experience on Oracle BPEL Process manager performance tuning for improve process level performance.
- Experience in Enterprise application development using Oracle Application Development Framework (ADF).
- Experience in building and deployment of several Oracle SOA,OSB applications usingANT.
- 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.
- Extensive Experience in working with PL/SQL packages, Stored Procedures, Functions and Triggers.
- 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:
Oracle Products: Oracle SOA 11g, E-Business Suite (EBS), Oracle Service Bus (OSB), UCM, BAM, BPEL Process Manager, Oracle Rules Author, Oracle Web Service Manager (OWSM)
Application Servers: Apache Tomcat, MS IIS, Oracle Application Server 10g/11g, Oracle BEA J2EE Web Logic Server, OC4J
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 Application 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: Net Beans, IBM Visual Age, JBuilder, JDeveloper 10.1.3.4, 11g, Eclipse.
Markup languages: HTML, XML, XSD, XPath, XSLT
Web Applications: JSP, JavaScript
Version Control Tools: Visual Safe Source, CVS / RCS. IDE: Net Beans, IBM Visual Age, Builder, JDeveloper 10.1.3.4, 11g, Eclipse.
PROFESSIONAL EXPERIENCE:
Confidential, FL
Oracle SOA Consultant
Responsibilities:
- Involved in requirements gathering from business, component designing, and deployment and testing of the application.
- Worked on Business rules implementation and Data Services development on physical and logical components.
- Extensively used WSDL, XSD’s while creating BPEL process models.
- Worked on SOA and EBS integration with various BPEL adapters.
- Built a Shared Service, which is reusable by many applications for moving the file from local FTP Server to Remote FTP Server.
- Extensively worked on DB Adapter and FTP Adapter.
- Used Fault policies and Fault Bindings for Error handling.
- Developed JMS client components to interact with MQSeries.
- Used OSB to build Proxy and Business services.
- OSB Programming, Routing Configuration.
- Extensively worked on creation of JMS Queues and Implementation.
- Working extensively on XQUERY and XSLT transformations in OSB to provide mapping between the consumer and provider business service.
- Created WSDLs and Schemas based on Business requirements, Exposed Proxy services and Business services in OSB.
- Configured Data source and JNDI to access the databases using DB Adapter.
- Involved in moving the application from test environment to production environment.
- Used the transform activity in BPEL to map the data from the procedures result set to the tables.
- Used E-Mail activity to notify the business about any business faults.
- Used trigger file to start up the process.
- Created Detail Design Documents and High Level Design Documents.
- Used Visio to build the design flows.
Environment: Oracle Applications server 11g, Oracle Service Bus, SQL, PL/SQL, TOAD, Oracle BAM, Oracle SOA Suite 11g, JDeveloper 11g, BPEL Process Manager, ESB, Oracle database 10gR2, Eclipse, SoapUI.
Confidential, CA
Oracle SOA Consultant
Responsibilities:
- Involved in requirements gathering from business, component designing, and deployment and testing of the application.
- Worked on Business rules implementation and Data Services development on physical and logical components.
- Extensively used WSDL, XSD’s while creating BPEL process models.
- Worked on SOA and EBS integration with various BPEL adapters.
- Built a Shared Service, which is reusable by many applications for moving the file from local FTP Server to Remote FTP Server.
- Extensively worked on DB Adapter and FTP Adapter.
- Used Mediator to route data in between the process throughout the design.
- Used the EDL Batch Event in Mediator to start up the process.
- Used Job Scheduler to trigger the process at scheduled timings.
- Used Fault policies and Fault Bindings for Error handling.
- Developed JMS client components to interact with MQSeries.
- Configured FTP adapters for different FTP servers.
- Used OSB to build Proxy and Business services.
- Configured Data source and JNDI to access the databases using DB Adapter.
- Used java-embedding activity for executing custom Java Classes for Complex business logic.
- Used FlowN activity to invoke different independent services in parallel
- Involved in moving the application from test environment to production environment.
- Used the transform activity in BPEL to map the data from the procedures result set to the tables.
- Used E-Mail activity to notify the business about any business faults.
- Used trigger file to start up the process.
- Created Detail Design Documents and High Level Design Documents.
- Used Visio to build the design flows.
Environment: Oracle Applications server 11g, SQL, PL/SQL, TOAD, Oracle BAM, Oracle SOA Suite 11g, JDeveloper 11g, BPEL Process Manager, ESB, Oracle database 10gR2, Eclipse, SoapUI.
Confidential, Seattle, WA
SOA-BPEL Consultant
Responsibilities:
- Designed and developed a custom error handling framework for the entire organization.
- Responsible for high-level application architecture and detail design of several interfaces.
- OSB Programming, Routing Configuration.
- Used Fault Policies to activate the Custom error-handling framework.
- JMS adapter was used for Producing and consuming the messages.
- Used java-embedding activity for executing custom Java Classes for Complex business logic.
- Extensively used XSLT, XSD, and WSDL.
- Developed various Web Services using WSDL, SOAP and Oracle JDeveloper.
- Prepared Design Patterns in XML schemas.
- Hands on experience in creating a WebUI service-using Oracle ADF.
- Tested the web services using Soap UI, BPEL Console and Test Suites.
- Extensively worked on Database adapter and FTP adapter, and configured JNDI and Data Source.
- Created Stubs to test the OSB services.
- Involved in the deployment of BPEL, Mediator and ESB services on to the production server.
- Involved in Systems Integration Testing and System Acceptance Testing strategy.
- Developed SQL Queries and Stored Procedures.
- Developed Common coding guidelines and best practices for WLI, web services and logging.
- Providing and maintaining interface specification with other Legacy Applications( DB2, MQ Registry interfaces)
- Provide support to development and testing teams during implementation and testing phase.
Environment: Oracle SOA Suite, Oracle 11g, BPEL, ESB, SOA, WSDL, Oracle10g, JDeveloper10g.
Confidential, Oklahoma City, OK
Oracle SOA-BPEL Consultant
Responsibilities:
- Involved in various phases of Software Development Life Cycle (SDLC) such as modeling, system analysis and design, code generation.
- Primarily responsible for designing and implementing the application process flows with BPEL.
- Integration of the application with third party tools such as Credit Bureau using various Adapter Services available in BPEL.
- 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.
- Used various Workflow patterns, skip rules as per the requirement.
- Modified existing Oracle PL/SQL Packages and developed new packages whenever required to be accessed from BPEL services.
- Developed Business Rules Model for the system using Oracle Business Rules Engine.
- Designed Rules Repository, Dictionary and Rulesets setup in Oracle Rules Engine and developed Business Rules using Rule-author (UI tool for Oracle Rule Engine).
- Customized Business Rules implementation through BPEL using java to fit the application requirements.
- Used ADF Business Components (View Objects, Entity Objects) to communicate with DB.
- Used ANT Script to build the application.
- Monitored the Debug & Error logs using java Logging Framework.
Environment: Oracle SOA Suite 11g, Oracle 10g, Weblogic Server, Web Services, SQL Server, Siebel 7.8,JDBC, Flatfile, MQ Series, XML, Java, SQL, SOAP, WSDL.
Confidential, Pittsburgh, PA
SOA-BPEL Developer
Responsibilities:
- Involved in SOA Architectural transformation. Transformed requirements into technical and architecture documents, and authored detailed design documents.
- Involved in web Services design including WSDL, XML, XSL, XSLT, SOAP Messages and XSDs.
- Configured B2B trading partners, Agreements and channels.
- Implemented an outbound ESB to Transform the Billing Information into Report generation Status message (routed to the CSR system) and Report generation letter (routed to a Client Intimation sub-system)
- Implemented a BPEL process for importing the invoices from Billing Master into Oracle AR using Auto Invoice interface. Involved in peer-reviews of BPEL processes to cross-check the functionality
- Integrated External website requests with Search Criteria (a J2EE component hosted on Web Sphere), Package Availability and Documented systems.
- Database schema enhancements, PL/SQL code, stored procedures.
- Involved in Systems Integration Testing and System Acceptance Testing strategy.
Environment: Oracle SOA Suite 11g, Oracle SOA JDeveloper, OC4J container, Java, XML, Task Manager, Oracle BPEL, Oracle ESB, OC4J SOA Suite
Confidential
SOA Developer
Responsibilities:
- Translate requirements into technical and middleware architecture solutions.
- Installation, Configuration of SOA Suite (BPEL, ESB OAS10g) and JDeveloper10g.
- Involved in development of a model with BPEL. Partner links, XSD, WSDL.
- Plan and conduct unit and integration testing including test case documentation.
- Extensively used database adaptor to connect to Oracle database and execute queries, procedures and functions.
- Extensively used Oracle Loader and PL/SQL for ETL.
- 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.
- Enhancements and Functional Specifications.
- Optimized Query Performance, Session Performance and Reliability.
- Created complex procedures.
Environment: Oracle SOA Suite 10.1.3.3.0 , WSDL 1.1, SOAP 1.1, XML, XSD, DTD, XSL, SQL Navigator 5, Oracle JDeveloper 10g, IBM Rational, Lotus Notes, Altova XMLSpy, Dimensions 9.1, MS Office 2003, Windows XP.
Confidential
PL/SQL Developer
Responsibilities:
- 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.
- 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 9i/10g, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, MS- Office, Windows NT 4.0/2000/XP Windows2000.
Confidential
PL/SQL Developer
Responsibilities:
- Developed SQL Applications for extracting the data from the Oracle tables
- Run Developed PL/SQL code for updating payment terms.
- Developed Session beans representing different types of business logic and Entity beans representing data persistent logic.
- Design and Development of front-end using Java Script, JSP and HTML.
- Developed JMS components to interact with MQSeries.
- Migrated Servlets to the J2EE architecture.
- Validation of front-end screens using Java Script before sending data to the Server.
- Created SQL statements for the effective retrieval and storage of data from the database.
Environment: Oracle 8.0.3.5, PL/SQL and Developer 2000(Forms4.5.0, Reports 2.5).