Sr. Oracle Fusion Consultant Resume
Miami, FL
Summary:
- Over 10+ years of experience in providing cost effective solutions by using Oracle ERP and related technologies, my experience spread across Implementations, data migrations, Interfaces, conversions, Enhancements of Oracle Application to ensure business needs are met. Strong technical experience in Oracle Applications 11i modules (Financials & Supply Chain), (AR, AP, GL, FA, INV, OM, PO, AOL, HRMS, SysAdmin) and Oracle Energy of which most recent 6+ year of experience is also with BPEL Process Orchestration and Oracle SOA/BPM Suite Fusion Middleware
- Flexibility to manage offshore production, development and testing team by guiding them in daily issues by using tools like Quality Control tool.
- Strong expertise in the area of system architecture, Cloud Based Integration, component design, MDS repository, implementation, and deployment processes.
- Knowledgeable in software quality concepts such documenting source code and software language specific code quality practices
- Understanding of software development team management support tools such as JIRA
- Experience in Test Driven Development (TDD)
- Experience with Oracle BPM 11g, BPMN 2.0, Oracle SOA 11g, Oracle Weblogic 11g, XML, XSLT, WSDL, JCA adapters
- Understanding of system architecture and component-based architecture and design
- Expertise with BPEL process Orchestration and Enterprise Service Bus (ESB) for integrating ERP applications (Oracle Applications, Hyperion, BAAN, D1), Databases, legacy applications, Flat Files and Portals.
- Good experience with implementing Human Workflow into BPEL orchestration, creating Business Rules, Rule sets, Dictionary of rules and rules Repository
- Experienced using the following SOA Suite technology adaptors for integration with external/legacy systems: Database adaptor; JMS, FTP and File adaptors.
- Experience in packaging and deployment of SOA suite components in different environments; troubleshooting composite services, and defining security and management policies.
- Very good experience with Web Services, XML, XSL, XSLT, XPATH, XQuery, WSDL, Java.
- Very good knowledge in Canonical Models and Application Integration Architecture (AIA), Oracle Service Bus, SoaSuite 11g, Business Activity Monitor (BAM),
- Working Knowledge of SOA-Suite 12c
Behavioral Traits
- Self-driven, confident, strategic but pragmatic, good communicator and team player
- Some Project Management experience
- Ability to work without close supervision and to rigid timescales, ability to work on multiple projects
- Dynamic, pro-active mentality
Oracle Applications:
- Extensive experience in Implementation, Customization, Production and Support of Oracle Applications 11i/R12 Financials/SCM modules (AR, AP, GL, FA, INV, OM, PO, PA, AOL, SysAdmin)
- Strong experience and expertise in Oracle Application RICE (Reports, Interfaces, Conversions, Extensions) development using the Development Suite/tools (like Forms, Reports, PLSQL, Workflow, SQL*Loader, Jdeveloper etc).
- Strong in PL/SQL coding, stored procedures, Functions, database triggers and Unix Shell scripting.
- Experienced with Full Project life cycle and well versed with AIM and SDLC methodologies
TECHNICAL SKILLS:
Fusion Middleware\ Adapters\
- Oracle Fusion Middleware 10/11g, \ FTP, JMS, DB, Oracle Apps, MQ Adapter\
- Oracle SOA Suite 11g, Oracle Service Bus \
- (OSB) 11g, Oracle Weblogic 10g/11g, \
- Oracle Web Services Manager (OWSM), \
- Oracle BAM, BPM, AIA, Oracle Service \
- Registry\
ERP\ Web Technologies\
- Oracle Applications R12 \ 11.5.10(11i), \ XML, HTML, XSLT, XPath, XQuery, \
- 11.0.3, Oracle Financials (FA, GL, AP, AR), \ CSS, DHTML\
- Oracle Manufacturing (INV, OE/OM, PO, \
- WIP, BOM), SysAdmin, AOL\
Web Service Standards\ Database\
- WS-Security, SOAP, REST, WSDL, \ Oracle 9i/10g/11g, MS SQL Server\
- UDDI, XML Schema\
Tools & Utilities\ Operating Systems\
- JDeveloper, Eclipse, SQL-Navigator, \ Windows, UNIX, Solaris, Linux\
- Toad, SQL* Plus, Forms 6i/4.5, Report 6i, \
- Workflow 3.0\Jenkins\
Web/Application Server\
- Apache Tomcat 4.x/5.x, \
- Oracle Weblogic 11g, OC4J 10g\
Professional Experience:
Confidential
Miami, FL
Sr. Oracle Fusion Consultant
Responsibilities:
- Analyzed user requirements, prototyping processes and designing process solutions.
- Liaised with BPM Analysts, Technical engineers and Project executive to build solutions that solved customer problems and delivered business value.
- Contributed effectively to develop solutions in the areas of process flow, business logic and user interface.
- Worked closely with architect to extend and modify architecture where appropriate.
- Directed and supervised research on emerging business process management.
- Perform End-to-End testing of the business process to prove various workflow and integration conditions
- Work on integration issues and determines the integration approach. Coordinate with other areas for integration architecture solutions.
- Developed BPEL modules within SOA Suite for creating services that managed data transformation, business workflow, business processing, data routing, and communication with external systems.
- Used Fault Management Framework to log all the errors in the backend and do appropriate action on the fault occurred.
- Defined XSD schemas for the various services/web services after careful analysis of the customer requirement and the coarse-grained/fine-grained nature of the function.
- Worked with File Adapter, Database Adapter, AQ Adapter, JMS Adapter for establishing connection with services.
- Configure BPM Workspace queues according to specifications.
- Configure out of the box BPM dashboard and Create custom dashboards in the workspace
Environment: Oracle SOA Suite 11g, Oracle Weblogic Server, Jdeveloper 11g, Oracle ADF
Confidential
Denver, CO
Sr. Oracle Fusion Middleware (SOA/BPM) Consultant
Responsibilities:
- Responsible for designing & developing “ServicePortal” – back-office functionality for CO-HIX.
- Developed BPEL modules within SOA Suite for creating services that managed data transformation, business workflow, business processing, data routing, and communication with external systems.
- Involved in writing up the use case documents with functional team & prepare the design documents.
- SAAS Integrated/implemented with Oracle RightNow CX using SOA/OSB, JCA Adapters.The project work involved designing and building a point-to-point integration solution between an existing CRM
- Implemented the Oracle Service Bus for virtualizing some of the services and is also used for load-balancing between the servers
Environment: Oracle SOA Suite 11g, Oracle Weblogic Server, Jdeveloper 11g, Oracle ADF
Confidential Hartford, CT
Sr. Oracle Fusion Middleware (SOA/BPM) Consultant
Responsibilities:
- Responsible for writing architecture spec, coordinating with a team of QA and Business Analyst.
- 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.
- Analyzed the business needs for the processes and modules that needed migration
- Implement old processes into new modules and make sure all the business needs are addressed. Design, development and deployment of Web Services was done using Oracle BPEL, JAVA, and XML (WSDLs)
- Design activities included generating relevant and effective fine-grained or coarse-grained interfaces as XSD, WSDL, and Java artifacts for the various components using Web Services, XML, and Java tools.
- Implemented File-Based repository for sharing XML artifacts across SOA composites.
- Configured Oracle SOA Suite to use Oracle Internet Directory for authentication and authorization.
- Configured BPEL process to report the status to BAM (Business Activity Monitor) Monitor Express.
- Used SVN for version control.
- Defect tracking/resolution using HP Quality Center.
Environment:
Oracle SOA Suite 11g, Oracle Weblogic Server 10.3.2, Jdeveloper 11g, Oracle Apps R12
ConfidentialBoston, MA
Sr. Oracle Fusion Middleware Consultant
Responsibilities:
- Implemented Event Delivery Network functionality.
- Integrated Oracle Applications using JCA Adapters with the legacy system and Oracle Healthcare Insurance module.
- Developed rule-based application by creating a Business Rule component and integrating it into a BPEL process
- Developed Interface Program using PLSQL by mapping the OHI data to AP interface.
- Participated in the development, testing, and production support of various services developed as BPEL modules and exposed as Web services for the Intranet customers.
- Integrated various BPEL events with BAM to monitor the real time data during the execution of the process.
- Interacted with business analysts, customers, architects and team managers during the various phases of the projects.
- Developed BPEL modules within SOA Suite for creating services that managed data transformation, business workflow, business processing, data routing, and communication with external systems.
- Used Fault Management Framework to log all the errors in the backend and do appropriate action on the fault occurred.
Environment:Oracle SOA Suite 11g, Oracle Weblogic Server 10.3.2, Jdeveloper 11g, Oracle Apps R12
Confidential Rochester, NY
Sr. Oracle Fusion Middleware Consultant
Responsibilities:
- Configuring Oracle File and FTP Adapters for High Availability
- Configuring the Credentials for Accessing a Remote FTP Server
- Create a Mediator Component for Business Event Subscription
- Implemented Request-Reply-Fault-Callback Message Exchange Pattern for the Mediators involved.
- Build SOA composite application and integrated BPEL process, business rule, and human task service components. Also created an ADF Task Flow Based on a Human Task.
- Created configuration plan for the target environment, using WebLogic Scripting Tool (WLST) command to deploy SOA Composite Application.
Environment:Oracle SOA Suite 11g, Oracle Weblogic Server 10.3.2, Jdeveloper 11g
ConfidentialDenver, CO
Sr. Oracle Apps/Fusion Middleware Consultant
Responsibilities:
- Design, develop and deploy Business Processes Orchestrated in BPEL and ESB using Oracle JDeveloper and SOA Suite 10.1.3.3
- Fully designed and developed a BPEL process to publish legacy data into Oracle E-Business Suite Open interface tables using APPS-Adapter.
- Deployed BPEL Suitcases to a specific domain.
- Implemented BPEL Process Rejection Handler (File system based).
- Performed propagation of E-Business Suits events with Enterprise Service Bus.
- Invoked BPEL Process thru PL/SQL, JAVA Generic API.
- Deployed BPEL Process using ANT scripts.
- Resolved various issues related to seeded BPEL process on OTM (Oracle Transaction Management) side. Implemented Rule based subscription for Multi consumer Queues in AQ Adapters.
- Mapped variables from multiple sources in a transformation.
- Trapped Error Message in the CatchAll branch of BPEL Process.
Environment: Oracle SOA Suite 10.1.3.4, BPEL, ESB, BAM, Oracle Applications R12, (PO, AP, AR, GL), Oracle JDeveloper, Oracle AS 10.1.3.4, Oracle BPEL PM 10.1.3.4, OWSM, Adapters (Oracle Applications, DB, File, FTP, AQ), Oracle Database 10g/9i, PL/SQL developer, Toad, Forms 10g, Reports 10g, BI Publisher
ConfidentialDallas, TX
Sr. Oracle Apps/Fusion Middleware Consultant
Responsibilities:
- Design, develop and deploy Business Processes Orchestrated in BPEL and ESB using Oracle JDeveloper and SOA Suite 10.1.3.3
- Fully designed and developed a BPEL process to integrate Oracle Applications 11i (E-Business Suite) Inventory Module (INV) with external applications/Flat Files for inbound material transactions. The deployed BPEL process used Oracle Applications Adapters, File Adapters, FTP Adapter and Oracle Material Transaction Open Interface. This Orchestrated BPEL Process had process activities like data conversion, transformation and fault handling
- Used DB Adapters and Oracle ESB to integrate between Oracle database 10g and Microsoft SQL database in order to transfer data from MS SQL to Oracle database on specific table changes
- Upload file into/from ftp location to Oracle Database. FTP and DB adapters were used with Oracle ESB
- Extensively used Fault and Error handling capabilities (Catch and Catch All), Synchronous and Asynchronous processes, Transformations, XSD, XSLT and XPath
- Invoked BPEL Process with the Web service/SOAP Interface.
- Expertise in using PL/SQL API’s, Open Interfaces and custom coding of PL/SQL Packages and using them within the BPEL using Oracle Applications Adapter
- Installation of Middle tier application server (SOA Suite 10.1.3.x), configuring and deploying application adapters and integrating with E-Business Suite
Oracle Applications:
- Worked on data conversion including Customer (TCA), Fixed Asset, Project Accounting, General Ledger journal import.
- Customized Positive Pay Report by modifying file layout and data requirements furnished by bank to be sent to them on daily basis
- Customized Fixed Asset Workflow (FA Account Generator)
- Resolved Order Management Workflow Data corruption issues and customized the seeded workflow as per the business needs.
- Customized and created alert to send email when an order ships.
- Worked on HR Employee Conversion using HR EMPLOYEE APIs. Interfaced addresses of employees/people in Oracle HRMS.
- Migrated SIT (special information types) into Oracle HRMS using HR SIT API.
- Worked on Inbound/Outbound interfaces in Manufacturing Modules specific to Fujitsu Warehouse needs.
- Worked on Stock Locators, Item cost Conversion and Open purchase order conversion.
- Very Well versed with the data flow (Order to Cash) spanning various modules.
- Worked on integration of Vertex Quantum Series and D&B with Oracle Applications which involved setups in Oracle Applications, analyzing its impact on customer conversion, fixed asset and supplier conversion and modifying code accordingly
- Translation of business requirements (MD50s) into technical specifications (MD70s).
- Ensuring the implementation adheres to all standards and methodologies.
- Involved in the database design, SQL Loader Scripts for data conversion from Legacy systems into Oracle Systems.
Environment:Oracle SOA Suite 10.1.3.3, BPEL, ESB, BAM, Oracle Applications(financials & Supply Chain), (INV, OM, PO, AP, AR, GL), Oracle JDeveloper, Oracle AS 10.1.3.3, Oracle BPEL PM 10.1.3.3, OWSM, Adapters (Oracle Applications, DB, File, FTP, AQ, MQ, JMS), Oracle Database 10g/9i, PL/SQL developer, Toad, Forms 10g, Reports 10g, BI Publisher
Confidential Houston, TX
Oracle Apps/Fusion Middleware Consultant
Responsibilities:
Oracle Applications:
- Responsible for implementing different energy modules for P2ES Clients such as Hunt Petroleum, Sheridan, Highmount, Swift etc.
- Worked on various modules of Enterprise Upstream Global Solutions, like Authorization for Expenditure, Joint Venture Accounting, Revenue Settlement, Lease Management and Field Operations Involved in coding interface for loading Legacy data.
- Worked on integration of Oracle Energy and Oracle Financials/Supply Chain modules.
- Worked on Customer Interface, used Auto Invoice import program to load legacy data into Oracle Receivable tables.
- Worked on Open Sales Order conversion and On hand quantities conversion.
- Setup financial statements, generator reports and other standard report for periodic and year end accounting.
- Design and developed validation process in PL-SQL to load legacy invoices into AP.
- Developed Application Extension MD070s using AIM methodology by reviewing MD050s and interacted with functional team to build technical extensions.
- Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables
- Extensively used AOL for registering concurrent programs, request sets, creating custom value sets.
- Involved in writing Technical Specifications
Environment:Oracle Applications 11.5.8 (Energy, PO, GL, AP, AR, OM), PL/SQL, SQL * plus, Oracle Database 9i, TOAD, Reports 6i, Oracle Workflow Builder 2.6, UNIX
Confidential Denver, CO J
Oracle Apps Technical Consultant
Responsibilities:
- Worked on Enterprise Upstream software applications Involved in coding core API’, developed and maintenance of various forms. Also used FOLDERS, SPECIAL triggers in some of the forms extensively coded PL/SQL programs.
- Handled various productions issues related to FORMS & PL/SQL programs. Involved in writing Technical Specifications.
- Extensively used AOL for registering concurrent programs, request sets, creating custom value sets.
- Involved in writing SQL* Loader script and PL/SQL programs for loading, data Mapping, data conversions and validating the data into the staging/target tables from the Legacy source
Environment:Oracle Applications 11.5.3 (GL, AP, AR, Energy, Supply Chain), PL/SQL, SQL * plus, Oracle 8i, TOAD, Reports 6i, Oracle Workflow Builder 2.6, Solaris, Windows NT
Confidential Boston, MA
Oracle Apps Technical Consultant
Responsibilities:
- Developed various custom conversion processes in purchasing. It includes vendors, New Banks, Bank Accounts, Purchase orders and related attachments.
- Developed custom package to validate this data based on system/client requirements and imported into oracle. Developed custom conversion processes to import Cross Reference Rules for GL code combination in General Ledger.
- Developed interfaces to import payable invoices.
- Entered and processed various transactions such as Invoice, Debit Memo, Credit Memo and Deposit. Worked on Auto Invoice and Customer Interface, Entered Receipts and Receipt Information.
- Creation of SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface (OE) programs to support the interface requirements.
- Completed the Receivables Cycle by running the Concurrent Process to transfer transaction information from Oracle Receivables to Oracle General Ledger.
- Troubleshoot various issues related to customer interface. Extensively coded PL/SQL programs using FND FILE, FND MESSAGE, FND CONCURRENT, FND REQUEST, FND GLOBAL.APPS INITIALIZE and FND SUBMIT Packages.
- Involved in writing Technical Specifications for AR & AP modules.
- Worked on GL Intercompany Transactions using GL IEA INTERFACE tables.
Environment:Oracle Applications 11.0 (INV, OM, PO), PL/SQL, SQL*plus, Oracle 8i, TOAD, Reports 6i, UNIX
ConfidentialIndia
Oracle Apps Developer/PLSQL developer
Responsibilities:
- Worked on conversions and customizations (Reports) of different modules extensively worked on GL, AR, AP The forms involved Procedures, Record Groups, LOV, Alerts, Parameters, Global Variables, Multiple Canvases, Multiple Windows, Multiple Blocks, Control Block and triggers at various levels.
- Developed new reports to suit Customer needs The Reports involved Matrix, Group Above with complex queries in Data Model, Complex Layouts, Used the functionality of Additional Default Layout, Parameters, Program Units, and the use of Report Triggers, Used Anchors for vertical and horizontal positioning of objects.
- Developed a custom form to create, update and view attribute information for the Account String using the Descriptive Flex Fields.
- Implementation tasks includes; requirements gathering, installation of Oracle database and E-Business application, design of all required fields for Oracle financials, completing the required setup steps for all modules installed, porting of legacy data, developing test scenarios, and end-user training .
- Involved in custom Application development using Oracle Dev2000 and PLSQL.
Environment:Oracle Applications 10.0, Oracle Dev2000, (PL/SQL, SQL*plus, Oracle 8i, TOAD, Reports 6i, UNIX