SUMMARY:

• Oracle Certified with 12 years of experience as an Oracle Application Ebiz Suite and Oracle Fusion Middleware (SOA) Technical Consultant.
• Experienced in Oracle E - business suite 11i/R12 - Order Management (OM), Inventory (INV), Purchasing (PO), Account Payables (AP), Account Receivables (AP), General Ledger (GL), Oracle Process Manufacturing (OPM), HRMS, and AOL modules. Well versed with P2P and O2C cycle in oracle E-business suite.
• Good Knowledge of Oracle Fusion Middleware stack and excellent exposure to SOA (Service Oriented Architecture) and different design patterns used in the integrations. Extensive experience in integration using Oracle Application E-Business Suite Version R12 and Oracle Fusion Middleware (12c,11g,10g) which includes BPEL (12c,11g, 10g), Oracle Service Bus - OSB (12c,11g), AIA, BAM (11g), Oracle Data Integrator (ODI), ESB, EBO, WSDL, XSD, XSLT, XQUERY, XPATH, SOAP UI.
• Worked on the latest Oracle fusion middleware products like Oracle SOA 12c, Oracle SOA 11g.
• Good Understanding of Oracle SOA like Oracle BPEL, Mediator, Oracle Service Bus, Oracle Business Rules, Oracle BAM, Web Services, XSLT , XPath.
• Good Understanding in the nascent architecture Oracle Application Integration Architecture Oracle AIA supporting SOA.
• Expertise in using Oracle Application adapters for File Adapter, FTP Adapter, Database Adapter, AQ Adapter and JMS Adapter for integration.
• Project experiences include full life cycle implementations, upgrades, maintenance and support. Involved in more than 5 Full life cycle implementations for Product, Manufacturing, pharmaceutical clients.
• Extensive Experience in RICE-W: Design, Development, Conversion, Customization, Interfacing and Implementation of Oracle Applications using Oracle SQL/PLSQL, Oracle Forms, Oracle Reports and Oracle XML BI Publisher.
• Extensive experience in working with PL/SQL Stored procedures, triggers, packages using Oracle 8i/9i/10g/11g database. Experience in Development and Customization of Reports/XML Publisher/Form Personalization and customization.
• Hand-on experience on Oracle E-Business Suite Integrated SOA Gateway. Used various methodologies as part of SOA Gateway, including service invocation framework to invoke SOA web services or publish information to the middleware.
• Hands on experience in developing custom web pages by using Application Development Framework (ADF). Good understanding of ADF architecture, ADF development, Bounded & Unbounded task flows, ADF Bindings etc.
• Expert in creating BC4J objects (EO, VO and AM) by using ADF.
• Worked on inbound and outbound Oracle EDI’s (Electronic Data Interchange). Hand’s on experience in Oracle WebADI.
• Experienced in writing AIM (Application Implementation Methodology) Documents - Technical design documents, unit testing documents and Installation Document’s (CCL, MD70, CV60, UTC and MD120).
• Good knowledge of System Administration with hands on experience in creating Users, Responsibilities, Request Groups, Menus, registering concurrent programs, defining Value sets and Descriptive Flex fields. Good knowledge of UNIX shell-scripting. Conduct code review to ensure the work delivered by the team is of high quality standards.
• Good knowledge of System Administrations on Oracle Fusion Middleware with hands on experience in creating users, role, configuring Data source service (JDBC connections),perform JMS Queue setup, JNDI setup, configuration related to BAM on Web-logic console, involved in deployment activity related to SOA components.
• Extensive working knowledge in Analysis, Design, Development, Documentation and Deployment. Involved in implementation, Upgrade and Support of Oracle Applications E-Business Suite using SQL, PL/SQL, Developer Suite 10g, with hands-on experience of various RICE components and Workflow.
• Ownership of the development lifecycle and being responsible for managing technical quality deliverable/resource/schedule/risks throughout the project, working extensively under onsite-offshore model using AIM Methodology. Experience in leading & managing teams and also worked as an on-site coordinator.

TECHNICAL SKILLS:

ERP: Oracle E-business Suite (11.0.3, 11.5.10 and R12)

Oracle Fusion Middleware: BPEL (12c,11g,10g), OSB (12c,11g), AIA, BAM (11g), ODI, ESB, EBO,

WSDL,XSD, XSLT, XQUERY, XPATH:

Work Areas: Forms, Reports, Interfaces, Conversions, Extensions, Form Personalization

and customization, EDI, WebADI:

Database: Oracle 11g/10g/9i/8i

Languages: SQL, PL/SQL, Java, UNIX, Shell Scripting

Reporting Tools: XML Publisher, Microsoft SSBI, Developer suite 10g

Tools and Utilities: TOAD, SQL Loader, SQL Developer, FileZilla (FTP), WinScp, STATs, Kintana, SVN, Hudson, Eclipse, VDI, SOAP UI, Remedy, Microsoft VSS, Citrix ICA Client, Share Point, Harvest, Jdeveloper (12c,11g, 10g), Eclipse, ODI 11g, BAM11g, Microsoft SSBI, Microsoft Project Plan

Oracle Tools/ Components: Oracle Developer 6i / 9i (Forms 6i/9i and Reports 6i/9i), Oracle Workflow, Workflow Business Events, Oracle E-Business Suite Integrated SOA Gateway, XML Publisher, Data Template, SQL *Plus, SQL *Loader, Advance Queuing (AQ).

Version Control: SVN and IBM Rational ClearCase, Harvest

Operating Platforms: Linux, Windows, UNIX

PROFESSIONAL EXPERIENCE:

Lead Oracle Apps / Oracle Fusion Middleware Technical Consultant

Responsibilities:

• Responsible for interacting with Business for requirements and analyzing the existing process.
• Perform Functional Design Document walk-through and written Technical Design Documents based on the Business Requirement document. Assist process team members in functional unit and integration testing activities.
• Involved in overall architecture design of implementing the interfaces using Oracle Fusion Middleware (i.e.: SOA12c, OSB12c) and Oracle E-business suite R12.
• Worked and used Error hospital provided as part of SOA12c installation, to monitor custom processes and to take the corrective actions to fix the issues.
• Designed and developed various integration processes using SOA12c (BPEL, Mediator, Business Rule etc.), OSB12c (Proxy service, business service, pipeline pair etc.). Used different components, adapters available in the tool to achieve the business functionality.
• Worked on Standard oracle provided WSDL’s and created custom WSDL for some of the interfaces. Customized standard EBO’s as per the business requirement.
• As a part of post-production activity, developed a framework, dashboard to monitor defects, SLA monitoring, performance, Defect trends, different aspects of the support processes and derive meaningful information to improve support process using Microsoft SSBI.
• Conduct code review to ensure the work delivered by the team is of high quality standards
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Helped QA analysts and technical team with troubleshooting and fault resolution.
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
• Validated technical designs created by Developers against functional specifications.
• Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
• Responsible for design and development of critical Interfaces using latest technology like SOA12c, OSB12c, AIA and along with oracle E-business suite R12. List of some of the key interfaces includes
• One Source- Employee Integration: The integration brings the employee data from the One Source and interface with the oracle E-business suite R12.Standard API’s, are used to create or update employee information.
• Order Integration: The inbound interface is used to bring order information from OMS to oracle E-business suite R12.
• COA Segment values integration: The inbound interface is used to bring the segments values from BOLT (financial system) to oracle E-business suite R12.
• COA Cross validation Rule integration: The inbound interface is used to bring the validation rules from BOLT (financial system) to oracle E-business suite R12.
• COA Code combinations integration: The inbound interface is used to bring the code combination from BOLT (financial system) to oracle E-business suite R12.
• Purchase Order Interface to BOLT: Outbound interface is used to transfer the purchase orders from Oracle E-business suite R12 to BOLT (financial system).
• PO Receipts Interface Outbound interface is used to transfer the purchase order receipts from Oracle E-business suite R12 to BOLT (financial system).
• SIM-Supplier Integration: Inbound interface to transfer supplier’s information from SIM to Oracle E-business suite R12.
• GL Interface: Inbound interface to transfer GL information into Oracle Ebiz R12 GL base table using Journal import program.
• Developed custom “Address validation Report” using XML Publisher (Data template, .rtf), used bursting functionality to send the email to the specified group.

Environment: Oracle Applications R12 - HRMS, Order management (OM), Purchasing (PO), General Ledger (GL), Payables (AP), Oracle DB 10g, PL/SQL, AQ, Toad, Winscp, Putty, Oracle Fusion Middleware (SOA12c), AIA, XML Publisher

Senior Oracle Apps / Oracle Fusion Middleware Technical Consultant

Responsibilities:

• Worked as an interface track lead and managed integration team scattered at different locations at offshore (India).
• Mentor junior resources on the team and was involved in day to day coordination and status reporting activities with-in the team along with the development work.
• Involved in overall architecture design for implementing the interfaces using Oracle Fusion Middleware (i.e.: SOA11g, OSB 11g, AIA11g, BAM1g) and Oracle E-business suite R12.
• Worked on Standard oracle provided WSDL’s and created custom WSDL for some of the interfaces. Customized standard EBO’s as per the business requirement.
• Designed, developed Global error handling Framework and error monitoring Dashboard for end to end tracking of the interfaces. Dashboard was developed using BAM11g.
• Responsible for functional and technical design reviews and assist process team members in functional unit and integration testing activities.
• Worked on SOAP UI to test web-based integrations/web-services using their WSDL’s, which will expose different operations in SOAP UI those are defined in the WSDL’s.
• Performed load testing of some of the web-based services using SOAP UI.
• Collaborated with the process team on cutover planning and in coordinating integration and user testing cycles, migrations.
• Managed the technology cutover activities, reconciliations, issue management during the post-production hyper case period
• Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
• Responsible for design and development of critical Interfaces using latest technology like SOA11g, OSB11g, AIA11g and with oracle E-business R12. List of some of the key interfaces includes:
• Chart of Accounts Interface: Outbound interface to transfer the COA relevant data from the Oracle E-business suite R12 (Unify Oracle source system) to the Eaton manufacturing facilities (Plants) target systems and any other external (non-Eaton) users of the data.
• Purchase Order Interface: Inbound interface to transfer the purchase orders from all legacy source ERP/Third Party systems to the Oracle E-business suite R12.
• PO Receipts Interface: Inbound interface to transfer the PO Receipts and Returns from all legacy source ERPs to the Oracle E-business suite R12.
• Supplier Interface: Outbound interface to transfer supplier details from Oracle E-business suite R12 to Eaton multiple ERP systems.
• AP Invoice Interface: Inbound interface to transfer the Invoices from all legacy source ERP/Third Party systems to the Oracle E-business suite R12 target system.
• Employee Interface: Inbound interface to transfer the relevant data from the HRMS (Link) source system to the Oracle E-business suite R12 target system.
• AR Interface: Inbound interface to transfer AR invoices from the legacy source to the Oracle E-business suite R12 target system.
• Modified and configured 850 POI EDI program according to R12 instance.
• Modified and configured 810 Invoice out bound EDI according to R12
• Developed ADF pages using page fragments (JSFF) and used in bounded task flows.
• Invoking SOA Web service in ADF.

Environment: Oracle Applications R12 - Purchasing, Account Payables (AP), Account Receivables (AR). HRMS, EDI, Oracle DB 10g, PL/SQL, AQ, Toad, Winscp, Putty, Jdeveloper11g, Eclipse, Oracle Fusion Middleware (SOA11g), BAM11g, AIA, ADF

Senior Oracle Apps / Oracle Fusion Middleware Technical Consultant

Responsibilities:

• Worked as an interface track lead at onsite, managed and maintain team at onsite/offshore. Was involved in day to day coordination activities with the client and onsite/offshore team.
• Involved in functional Requirements Analysis, Technical Designs, Development and Testing.
• Involved in overall architecture design for implementing the interfaces using Service Oriented architecture between custom e-commerce solution and Oracle E-business suite R12.
• Responsible for design and development of critical Interfaces in the engagement using latest technology like ADF, SOA11g, OSB11g, AIA11g and ODI along with oracle E-business suite R12.
• Collaborated with the process team on cutover planning and in coordinating integration and user testing cycles, migrations.
• Managed the technology cutover activities, reconciliations, issue management during the post-production hyper case period
• Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
• Developed complex inbound/outbound interfaces to integrate boundary application and oracle Ebiz using Service Oriented Architecture.
• Designed and developed Global Error handling and Monitoring Framework for interface monitoring, which is used across the project.
• Designed and developed Global Message reprocessing framework to reprocess Error/stuck records. This framework is used across the project for message reprocessing. The screen was developed using ADF.
• Worked on design and development of many interfaces, list of some of the key interfaces includes:
• Shipment Confirmation Interface: Inbound interface to send the shipment information from Red Prairie to Oracle E-business suite R12.
• PO and PO Receipts Inbound Interface: Inbound interface from JDE to send the Oracle Purchase Order and receipt to Oracle E-business suite R12 to create Purchase Order and receipts.
• ASN Inbound Interface: Inbound interface into Oracle E-business suite R12 of ASN (Advance Shipment Notice) from JDE for creating the Receiving transactions in Oracle EBS.
• On-Hand Outbound Interface: Outbound interface to send On Hand details by affiliate level from Oracle E-business suite R12 to the JDE and Manugistics system (ASCE system) to satisfy the requirement for the DRP and demand planning.
• Receipts Outbound Interface: integration components involved sending the receipt information from Affiliate warehouse from Oracle E-business suite R12 to ASCE JDE system.
• Shipment GDW Outbound Interface: Outbound Interface that will send the Shipment details information from Oracle E-business suite R12 to Global Data warehouse (GDW). This interface will support better processing for the Inventory Optimization system and will support the new Allocator program being built. This technical solution will support batch data push from Oracle E-business suite R12 to GDW. There will be another ETL job on GDW side, which will validate and load into GDW schema. Due to large volume data movement and batch-processing nature of the interface, this interface is designed using ODI
• Employee Inbound interface: Inbound interface to move data from external Employee central system to oracle Ebiz.
• Order Interface: Inbound interface used to get order creation, update information from OMS to oracle Ebiz.
• Magic GL Interface: Inbound Interface required to create Journal Entries in Oracle EBS, those are coming from MAGIC system.
• AR Adjustment Interface: Inbound interface from RMS to oracle Ebiz to send AR Adjustments (i.e.: credit, debit memos)
• Developed and customized WEBADI (EXCEL) to upload data into oracle tables. Developed AP invoices WEBADI for creating bulk AP invoices.
• Developed custom ADF screen for the message reprocessing. Used page fragments (JSFF) and used in bounded task flows to achieve the functionality and invoked SOA web services from ADF to interact with the database layer.
• Developed ADF page using images, icons, managed beans, ADF rich UI components like ADF layouts, input texts, buttons, command links, Boolean check box, etc

Environment: Oracle Applications R12 – Order Management (OM), Account Receivables (AR),General Ledger (GL),HRMS, Purchasing (PO), Inventory (INV), WebADI, Developer 10g, Oracle DB 10g, PL/SQL, Toad, WinScp, Putty, Workflow BES,Jdeveloper11g, Eclipse, Oracle Fusion Middleware(SOA11g), OSB(11g), BAM(11g), AIA, ODI(11g), ADF

Senior Oracle Apps / Oracle Fusion Middleware Technical Consultant

Responsibilities:

• Responsible for design and development of some of the critical Interfaces in the engagement using latest technology like Oracle E-business suite R12, SOA10g and AIA.
• Responsible for functional and technical design reviews and assist process team members in functional unit and integration testing activities
• Collaborated with the process team on cutover planning and in coordinating integration and user testing cycles, migrations.
• Managed the technology cutover activities, reconciliations, issue management during the post-production hyper case period
• Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
• Developed complex inbound/outbound interfaces to integrate boundary application and Oracle E-business suite R12 using SOA10g and AIA. Designed a framework to control all outbound interfaces to Boundary system (MES) to follow Singleton architecture.
• Worked on design and development of many interfaces, list of some of the key interfaces includes:
• Item Outbound Interface, this interface is used to send information from Oracle E-business suite R12 to MES. It helps to synchronize Oracle E-business suite R12 and MES for items information.
• Work Order Outbound interface, from Oracle E-business suite R12 to MES: This interface is used to Publish Work Order (OPM batch) related information to MES.
• On-Hand Outbound from Oracle E-business suite R12 to MES for Reconciliation: This interface is used to publish on-hand quantity related information to MES for Reconciliation.
• Lot Status Change Outbound from Oracle E-business suite R12 to MES: This interface is used to publish Lot Status and related information as per the business requirement to MES.
• Work Order Inbound interface from MES to Oracle E-business suite R12: This is an inbound interface, where MES Publishes Work Order (OPM Batch) related information to Ebiz. This interface updates the status of the Batch in Oracle EBS.
• Work Order Step Inbound from MES to Oracle E-business suite R12: This is an inbound interface, where MES publishes Work Order Step (OPM Batch Step) related information to Oracle E-business suite R12. This interface updates the status of the Batch Step in Oracle EBS.
• Designed a framework/architecture using SOA to control all the outbound interfaces from oracle Oracle E-business suite R12 to MES to maintain Singleton architecture. Maintain the sequence of the messages as per their occurrence in Oracle E-business suite R12 and control the flow of the messages in the same sequence to MES.
• Payable Invoices from Brainware to Oracle E-business suite R12 Inbound: This interface gets data from Brainware, to Oracle E-business suite R12 and as per the business requirement does validation, derivation. Using oracle Payable Standard Import program create the invoice and use standard API’s to create attachments to the invoices.
• Involved in defect fix and resolution of the interfaces.

Environment: Oracle Applications R12 – Account Payables (AP), Inventory (INV), Oracle Process Manufacturing (OPM), Developer 10g, Oracle DB 11g, PL/SQL, Toad, SVN, Putty, Jdeveloper10g, Oracle Fusion Middleware (SOA10g), AIA

Senior Oracle Apps Technical Consultant

Responsibilities:

• Involved in functional document (FD) walk through and discussion with client regarding requirements.
• Creation of technical design.
• Development of two custom forms using template.fmb, worked on ZOOM functionality, customization using CUSTOM.PLL and personalization of sales order screen
• POPUP Form which gets invoke when control moves on the unit selling price first time at sales order lines and user can invoke the same form using ZOOM functionality and many business rules are applied on this form.
• Data Entry form to hold information in the custom table.
• Preparing UTP (Unit Test Plan) and IG (Installation Guide) for the build.
• Worked on Various AOL related activities.

Environment: Oracle Applications R12- Order Management (OM), Oracle DB 10g, PL/SQL, Toad, SVN, Form 9i

Senior Oracle Apps Technical Consultant

Responsibilities:

• Involved in requirement gathering with client and designing functional document (FD) walk through and technical design preparation.
• Involved in specifying and review of coding standards for the team.
• Coding and preparation of build for RICE objects.
• Mainly worked on various conversions related to OPM, INV, AP modules.
• (Such as Suppliers, Operations, routing, Formula, Recipe, Stock Locator, Notes Conversions etc.)
• Worked on design and development of interfaces, using BPEL, ESB.
• Developed XML Publisher Reports using Data Template.
• (Lot Genealogy Report, Invoice Print Report (using Data template) etc.).
• Developed various Forms and PL/SQL extensions.
• Worked on Forms personalization, custom.pll and Zoom functionality.
• Involved in validations to the customized forms using CUSTOM.PLL.
• Used FNDLOAD for Messages and Responsibilities templates migration from one instances to other instances.
• Developed various objects and gave production support for those objects.
• Preparing UTP (Unit Test Plan) and IG (Installation Guide) for the build.
• Worked on various AOL related activities.

Environment: Oracle Applications R12 – Oracle Process Manufacturing (OPM), Inventory (INV), Account Payables (AP), Oracle DB 10g, PL/SQL, Oracle Developer Suite 6i, TOAD, UNIX, XML Publisher, STAT, Toad, SVN, Form 9i

Software Engineer - Oracle E-business Suite 11i

Responsibilities:

• Developed Workflow objects.
• Worked on conversion (contract discount and Historical pricing).
• To keep execution of conversion in production on time helped onsite team and pulled the reconciliation (success and fall rate during execution) reports for the same.
• Working on enhancements and fixed SIR’s (Service investigation Request) for RICE objects (specially related to Oracle CRM module).
• Working on enhancements, fixes SIR’s and investigation tickets for workflow objects.

Environment: Oracle Applications R11i – Customer Services, Toad, PL/SQL, PUTTY, WINSCP

Software Engineer - Oracle E-business Suite 11i

Responsibilities:

• Involved in functional document (FD) walk through and discussion with client regarding requirements.
• Creation of technical design.
• Customization of Reports, JSP Customization.
• Worked on Inventory Item Conversion (Item, Revision and category).
• Mainly worked on development and customization conversion and bug fixing.
• Preparing UTP (Unit Test Plan) and IG (Installation Guide) for the build.
• Interaction with client-Solving SIR’s.
• Coding and preparation of build for RICE objects.
• Various AOL related activities.
• Developed objects and also gave production support for those objects.
• Developed some reusable components which organization is using across modules.

Environment: Oracle Applications 11.0.3, 11.5.10 – Inventory (INV), Developer 6i, Oracle DB 9i, PL/SQL, Toad, Putty