Oracle Developer Resume
3.00/5 (Submit Your Rating)
UsA
Summary:
- 8+ Years of Total IT Experience with 5+ years in Oracle Fusion and Oracle applications involving SOA, BPM, Enterprise Application Integration in Design, Development, deployment, Testing, Implementation Support and Administration.
- Extensive working experience with Oracle SOA Suite 11g, and 10g, Oracle Service Bus, SQL, PL/SQL.
- Expertise in SOA, Orchestration and Integration Technologies in the areas of web services, ESB, SOAP, WSDL, BPEL, XML and XSD.
- Experience Installing and Configuring BPEL 10.1.3.4 on Oracle Application Server.
- Hands-on experience working with JMS, File, FTP, AQ, Oracle Application and Data base adapters.
- Expertise in JAVA Adapter to interact with various data bases.
- Expertise in creating JAXB classes from schema to integrate the OSB messages with logic implemented in Java.
- Expertise in generating generic Java methods and encapsulated in JAR files to be used across the application.
- Expertise in creating JMS servers, JMS Modules, JMS queues and JMS topics in Weblogic and Oracle Application Server.
- Involved in archiving the completed BPEL processes, Removal of all successfully processed XML messages and Deletion of stale instances.
- Experience in working with BPEL Sensors.
- Experience in clustering the BPEL/ESB/OWSM on Weblogic Application Server.
- Working knowledge on SOA Implementations involving Web Services using SOAP, WSDL and XML technologies( XML, XSD, XSLT, XPath) & Oracle JDeveloper.
- Strong Business Process Management skills and experience including Process Mapping & Modeling, Process Visualization, Business Process Analysis, Business Process Frameworks & Methods, Business Rules, and Business Process Standards such as BPMN, BPEL
- Domain expertise using Java and Business Process Improvement across a Telecom organizations
- Administrating and Web Services monitoring using Oracle Web Service Manager (OWSM). Configuring components, policies, steps and alerts etc.
- Expertise in Design and Development of OSB Interfaces for Routing services and proxy services and used OEPE for development.
- Extensive Experience in working with PL/SQL packages, Stored Procedures, Functions and Triggers.
- Experience in application development, debugging, implementation, supporting dev team, testing of Oracle based ERP using SQL, PLSQL, Shell Scripting, and Database Triggers etc.
- Experience in build and deployment frameworks using ANT.
- Experience in unit testing of webservices and BPEL processes using Soapui Mocks and BPEL test suites.
- Experience in Oracle OSB to build service proxies that provide features like load-balancing, fault-tolerance and dynamic routing to back-end SOA services.
- Working extensively on XQUERY and XSLT transformations in OSB to provide mapping between the consumer and provider business service
- Developed complex schemas and XSLT transformations in BPEL to read, enhance and process incoming data and map to external provider web service (Provider OSB).
- Created, Configured and Managed Oracle OSB (Oracle Service Bus) Services
Oracle Fusion Middleware Application Server
Oracle SOA Suite10g, 11g, BPEL Process Manager, Oracle Service Bus, Business Activity Monitoring
Developer Tools
Oracle J Developer Studio 10.1.3.4, 11.1.1.6, Eclipse, Squirrel, Baretail
Client Side
Applets, JavaScript
IDE
TOAD,SQL Developer, Eclipse, Jdeveloper
Operating Systems
Windows 2000/XP/7, Linux, UNIX - Solaris.
Adapters
DB Adapter, FTP Adapter, JMS Adapter, AQ Adapter, File Adapter, Web Service Adapter, Application Adapter.
Languages
Java, C++, C, PL/SQL, MySQL, Ant, XLST, Xquery
Databases
Oracle 10g, XE, SQL Server 7.0/2000, MS-Access, HP Non Stop(ZLDS)
XML/Web Services
XML, XSLT, SOAP, DHTML, HTML, UDDI, XSL, VBScript
Professional Summary:
Confidential, USA
Role: Oracle Developer
Confidential a leading natural health and wellness company, markets and distributes nutritional and personal care products through a global direct sales force of over 340,000 active independent Managers, Distributors and customers in more than 40 countries.The Company has three reportable business segments that are divided based on the characteristics of their Distributor base, similarities in compensation plans, as well as the internal organization of NSP’s officers and their responsibilities (NSP Americas, Asia Pacific and Europe; NSP Russia, Central and Eastern Europe and Synergy Worldwide).Nature’s Sunshine Products New Apollo Project implementation going in all financial modules, Order management, Purchasing, WMS and Inventory modules. In this project I am working on Oracle Account Payable, Order Management, Oracle Payments, Inventory and Oracle Purchasing modules.
Responsibilities:
- Create, Modify and test the, forms and script that allows the Oracle ERP applications to run.
- Work from specifications drawn up by software developers or other individuals.
- Assist software developers by analyzing user needs and designing software solutions.
- Develop and write computer programs to store, locate, and retrieve specific documents, data and information.
- Responsible for gathering the requirements and preparing the XSD Schema files, worked on XSL, technologies.
- Worked on Oracle Service Bus, Oracle SOA Suite 11g .Oracle AIA 11g, Oracle BPM 11g.
- Worked on adapter frame work: AQ, JMS, File, DB, Oracle Apps, and Web Service.
- Worked on OSB to created business and proxy services.
- Architected the frame works like Notification, Error Handler and logging frame works in Oracle SOA Suite.
- Developed the complex stored procedures.
- Worked on Mediator for routing to the services.
- Create, Update & Delete Order and Account attachments using standard API in Oracle.
- Invoke legacy shipping business service to identify list of additional shipping method e.g. FEDEX, UPS etc. and store these information in Oracle.
- Listen & subscribe standard business event using AQ adapter to build input elements and pass these information to legacy business service to derive cubing data for pick list report in Oracle.
- Developed BPEL flows using File Adapter, Database Adapter, FTP Adapter, JMS Adapter, AQ Adapter, Web services, HTTP adapter.
- Developed XSLTs using Oracle seeded functions for string formats, date formats.
- Implemented fault policies to retry system exceptions using Fault policy framework.
- Worked on writing complex PL/SQL packages.
- Developed interfaces on Order Management In-bound and Out-bound Interfaces and integrated with Oracle SOA 11g.
Environment: Oracle OSB , Oracle SOA Suite 11g, Oracle BPM Suite 11g, Oracle Weblogic 11g, Enterprise Manager 11g, Jdeveloper 11g, Oracle BPEL Process Manager 11g, BPEL, JMS Adapter, App Adapter, FTP Adapter, DB Adapter, SOAPUI, Jenkins, Oracle BAM 11g, XML, Java, JSP Oracle Database 11g.
Confidential
Role: SOA Developer/OSB Developer
Confidential is an American direct broadcast satellite service provider and broadcaster based in El Segundo, California. DirecTV provides television and audio services to subscribers through satellite transmissions.
Middleware is one of the key system in DIRECTV Landscape which orchestrates the different business process with various heterogeneous systems like billing, order management, portal etc. with existing 200 + services.
This project is to replace their existing ICAN middleware with Oracle Fusion Technologies, enhancing their customer experience by incorporating new and extending the existing functionality/capabilities.
Since the ICAN Implementation is in JAVA we have to analysis the fastest migration approach to Oracle Fusion.
Responsibilities:
- Performing analysis on requirement documents received, assessing the impact of new projects on the OSB infrastructure, estimating time to deliver for the requested modifications
- Working on administration on Weblogic, Governance & SOA Suite.
- Using XSLT to transform message from consumer to the enterprise structure and to the provider schemas.
- Creating well-designed, reusable objects in SOA environment and test plans.
- Created and supported complex composites having multiple BPEL and Mediators across the life cycle.
- Developed JAVA Adapter to interact with HP non-stop data base.
- Developed JAXB classes from schema to integrate the OSB messages with logic implemented in Java.
- Created generic custom Java methods encapsulated in JAR files to be used across the application.
- Designed and developed routing tables for establishing dynamic connections to external web services.
- On-going development and support of middleware environment for internal systems.
- Developed and designed several Generic (Re usable) BPEL Processes & OSB Services.
- Designed Database Adapters to poll for new records and sync data from multiple systems
- Designed JMS Adapters to actively send and receive messages from various enterprise systems.
- Use File adapter and FTP Adapter to poll directories and execute business.
- Involved in the configuration of the connection pools and data sources for Database Adapter and on the application server.
- Used DB adapter to invoke database for OSB Webservices.
- Created Scheduler for BPEL Process.
- Created Fault Policies for Error Handling.
- Created, Configured and Managed OSB (Oracle Service Bus) Services
- Created Connection Factories and Data sources to connect to different databases
- Configured JMS Queues, Connection pools and connection factories to publish and receive JMS messages.
- Customized the PIP (Order 2 Cash) according to the business scenarios.
- Implemented the AIA Error handling framework.
- Used BAM for Alerts and Notifications.
- Developed Adapter proxy service using routing to invoke the business service which internally calls the JMS.
- Configured Security with OSB (OWSM and Custom Implementation)
- Designed and created OSB Proxy and Business Services.
- Executed and wrote complex SQL queries to validate data integration to interact with various DBs – Oracle, ZLDS,etc
- Responsible for Integration and Unit testing of services.
- Deployed the code to multiple environments
Environment: Oracle OSB , Oracle SOA Suite 11g, Oracle BPM Suite 11g, Oracle Weblogic 11g, Enterprise Manager 11g, Jdeveloper 11g, Oracle BPEL Process Manager 11g, BPEL, JMS Adapter, FTP Adapter, DB Adapter, SOAPUI, Jenkins, Oracle BAM 11g, XML, Java, JSP Oracle Database 11g.
Confidential , CA.
Role: SOA Developer/OSB Developer
Confidential the global leader in virtualization and cloud infrastructure, delivers customer-proven solutions that accelerate IT by reducing complexity and enabling more flexible, agile service delivery.
Responsibilities:
- Planning and created and updated Technical Design Documents (TDD) for middleware services.
- Having good working experience on SOA architecture and middleware technologies and co-coordinating with offshore calls.
- Managing deployments to various environments using PPM tool.
- Created Create Entitlement Account BPEL process Business service for OSB using BPEL.
- Merged Create Entitlement and Get CN Number BPEL process.
- Created Entitlement User Business and Proxy’s services using Oracle Service Bus.
- Implemented log messaging concept for BPEL process to track log messages with Transaction ID’s using SPLUNK tool.
- Implemented best practices such as error handling and file archiving in Oracle OSB.
- Created partner link using web service adapter to invoke URL Based OSB and other services.
- Implemented Exception Handling for the BPEL Process models to handle System, Business exceptions and used Compensation handlers to handle the transaction if an exception occurs
- Generated wrapper packages using JDeveloper11g to create OSB Business services.
- Worked with PPM tool to setup auto mated ANT scripts to deploy various environments.
- Developed different SOAP services and Web Services using WSDL, SOAP, AXIS and JDeveloper.
- Developed custom XPath functions to transform messages.
- Extensively used BPEL to determine dynamic partner link calls, updating databases via BPEL, generating proxy stub classes to call BPEL process from a web application, etc
- Working on Architecture design of integrating new functionality into application and user interfaces.
- Used Eclipse to develop other server side components.
Confidential , Chicago, USA
Role: Oracle fusion consultant
Description: Adoption of common goal processes. Implementation of a new oracle ERP instance for EMS Supply chain. Enable mature demand planning and process through oracle value chain planning solution. Replacement of disparate legacy systems with a new simplified architecture. Transform the existing EMS Supply chain process systems to align to a common standard.
Responsibilities:
- Responsible for creating DR (Development Requirements) for Sprint& IAC, CER, Schedule sharing, DFW and Tesseract Interfaces.
- Responsible for Creating System Interaction Diagram.
- Document Data Mapping Guide specification documents. Typically called MIG or IG which is Mapping/Motorola Implementation Guides; Implementation Guide. The MIG contains:
- Data mapping from source system fields to message/file fields
- Data mapping from message/file fields to target fields
- Data mapping of Canonical Messages (i.e. EBO, RN, EDI)
- Configured FTP adapter for Schedule Sharing which is an inbound to fusion.
- Configured Database adapter for Sprint an IAC which has inbound/outbound to fusion.
- Configured JMS adapter for CER.
- Designed and defined exception handling and created Error Handler Process for emailing the exceptions
- Responsible for Deploying BPEL processes in Development, QA and Production servers.
Confidential , GA USA
Role: Oracle Fusion Consultant
Description: The main objective is to design a system that covers the requirements for Track and Trace (TNT) and interacts with desperate systems in order to make the Track and Trace process complete. In order to be able to search for and present Shipment and Scan Events information to the User, the Order Track application will provide an intranet application with features such as order type, order no etc. Order Track will source in information received from different applications such as OTM (Oracle Transport Management), WMS (Warehouse management system), CATS, Mobile Frame, APROMS, Sterling, SAP, Oracle 11i via Fusion into Order Track staging environment and vice versa.
Responsibilities:
- Designed and developed BPEL processes to integrate between different applications such as OTM (Oracle Transport Management), WMS (Warehouse management system), CATS, Mobile Frame, APROMS, and Sterling.
- Configured FTP adapter for APROMS and Sterling which is an inbound to fusion.
- Configured Database adapter for Mobile Frame, CATS, Order Track which has inbound/outbound to fusion.
- Configured JMS adapter for WMS.
- Migrated the existing interfaces from 10g to 11g.
- Designed and defined exception handling and created Error Handler Process for emailing the exceptions.
- Responsible for Writing AID (Application Interface Design) and Technical Documents for all the interfaces.
- Responsible for Deploying BPEL processes in Development, QA and Production servers.
Confidential , Wisconsin
Role: BPEL Consultant
Description: Charter Manufacturing has four core divisions out of which Charter Steel (CS) and Charter Specialty Steel (CSS) Divisions are implementing Process manufacturing business flows.
OPM Quality Management implementation at Charter Steel (CS) and Charter specialty Steel (CSS) will be integrated with their existing MES system. All the specifications including that of Charter, Industry standards and Supplier will be housed in OPM Quality. MES will use these specifications for doing the WIP testing for Melting, Rolling and Processing.
As part of Project implementation, one of the requirements is to download MELT schedule to MES for lot generation. This includes batch details with routing, resource, operations etc along with quality specifications. Oracle Process Manufacturing OPM uses the capabilities of Fusion Middleware to orchestrate the integration process between the MES system and OPM.
Responsibilities:
- Developed and designed BPEL Processes.
- 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 using the EM Console in the Oracle SOA Suite to connect to different databases and publish and receive JMS messages.
- 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.
Confidential, India.
Role: Oracle Developer
Description: This is a package developed for Logistics Department where they deal with import and export of coals. It constitutes Order Receiving, Dealer Master, Coal Master, Customer Master, Staff Master, Dealer transaction, Bank A/c, Ledger Preparation, invoice preparation and Payment Entry, Loans from Bank and credit maintenance.
Responsibilities:
- As a programmer, involved in designing, developing, and delivering a Logistics System.
- Designed various forms using Visual Basic, used extensive object referencing like visual attributes, attached libraries etc.
- Developed several stored procedures, packages, forms triggers and database triggers, used PL/SQL extensively in coding.
- Created Database objects such as Tables, Indexes, Views and Synonyms.
- Extensively developed Oracle PL/SQL stored procedures, functions, cursors and triggers for creating and modifying database objects based on design documents.
- Involved in Unit testing and system testing