PROFESSIONAL SUMMARY:

• I am over 11+ years of IT experience on Oracle Applications, tools and software
• Over 2 years in Service Oriented Architecture (BPEL) for developing the web services
• 11+ years in Oracle Applications E - Business Suite in Implementation, development, Support environments and Rollouts
• 2 years in Oracle APEX development for various portals using PL/SQL, CSS, HTML and Java scripting
• Strong technical and program solving skills related Oracle EBS Apps Distribution & Manufacturing Modules, Application Object Library and System Administration as well as functional aspects in Oracle Apps 11i and R12
• Sound knowledge on Oracle APEX 4.x and 5.2 for creating web based applications which include various Interactive Reports, Classic Reports, data entry pages, Graphs authentication with external applications and RESTful service
• Expertise in Developing BPEL process with SOA,JNDI,Oracle BAM, Routing using Enterprise Service Bus (ESB) for integrating ERP applications (Oracle Applications, Dynamics), various Web services, Databases, legacy applications
• Expertise in developing and deploying BPEL Processes using technology adapters (Oracle Applications, JMS, MQ, AQ, DB, File and FTP Adapter) Using Web logic Server
• Good knowledge in Human work flow and good experience with XML,XSLT, XPATH, XQUERY, WSDL
• Having hands on experience in Development of RTF, XSL Templates to publish APPS data in client requirement format (PDF, Excel) using Oracle XML Publisher Template builder as well as Discoverer 10.1.2 and Report6i/9i
• Proficiency of using the public APIs (Database & APPS) and also on Data Conversions and Interfaces related to various modules by using APIs as well as standards import process
• Expertise in SQL and PL/SQL programming to develop Sub-Programs, Packages and Triggers.
• Good knowledge in working with standard and Custom Reports using Reports 6i/ 10g and Discoverer 10.1.2 developing the Data Conversions and Interfaces related to various modules.
• Good knowledge in customization of standard Apps forms customization using Form Personalization.
• Worked with Oracle Utilities like Workflow Builder, SQL*Loader, Toad, PL/SQL Dev, Data Loader and Putty.
• Ability to manage multiple tasks/projects, works independently, quickly adapt to new technologies, presentation skills, and good team player.
• Knowledge on Oracle 10g/12c JDeveloper to new create JSF pages using ADF / OAF technology

TECHNICAL PROFICIENCY:

RDBMS: Oracle 9i, 10g, 11g and 12c.

Reporting/ Development Tools: Developer Reports 6i, Forms6i, XML Publisher, Discoverer 10g, Jdeveloper 10g/12c. Eclipse IDE, BPEL and Data loader

Languages: SQL, PL/SQL, XML, Shell Script, Java Scripting, Core Java Programming, CSS, HTML and Java Scripting

Utilities: SQL*Loader and MS-Office

Software/ IDE Tools: PL/SQL Developer, Oracle APEX 4.x, TOAD, SQL*PLUS, Putty, Core ftp, WIN SCP, STAT, Kintana, Clear case, Remedy, Perforce and WSO2

Development Environment: UNIX / LINUX and Windows 7/XP/NT.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Consultant

Environment: Oracle 12c, Oracle Apps R12 12.2.5, 12.2.1 using Oracle BPEL

Responsibilities:

• Development of various Inbound and outbound SOAP based interfaces using Oracle SOA between Expedia Oracle and Egencia applications
• Worked as technical consultant in oracle advance technology SOA-BPEL
• Centralized error handling was achieved by using a common error hospital that received the errors across BPEL, ESB and adapters. In this common project, we used fault policies and catch handlers for BPEL, ESB ERROR topic for ESB and rejected Message Handlers that invoke a BPEL process for the adapters. Errors that required human intervention were also handled using the fault handling framework
• Fault handling, Email Notifications, Messaging, Alerts, Business activity monitoring
• In Procure to Report, I have developed the interfaces to automate the file transactions for Kyriba
• Enhancements on customized report using XML publisher
• Write, analyze, review, and rewrite programs, using workflow chart and diagram, and applying knowledge of computer capabilities, subject matter, and symbolic logic
• Perform or direct revision, repair, or expansion of existing programs to increase operating efficiency or adapt to new requirements
• Correct errors by making appropriate changes and rechecking the program to ensure that the desired results are produced
• Conduct trial runs of programs and software applications to be sure they will produce the desired information and that the instructions are correct
• System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues. Involved in various Interfaces and conversions which consists of both outbound and inbound

Confidential

Technical Consultant

Environment: Oracle 10g, Oracle Apps 11.5.10.2 and R12

Responsibilities:

• Oracle APEX
• Designed and developed solutions for business applications
• Implemented Flowserve Time Tracking, CSR Tracking System, Projects and Purchasing portals.
• Created view Item details web page for searching items details on various wild card parameters
• Custom and Oracle Ebs authentication and authorizations
• Migration from 4.2 to 5.0
• Developments under agile and scrum methodology
• Conversions / Interfaces
• FASTERSQ interfaces to synchronize oracle database and legacy database for MOOSIC
• Item load interface which includes Categories, cross .
• Forms
• Worked on custom Forms like Repair Release, Quote upload tool and PO price change forms.
• Reports
• Customized AP Check Print Report related to CHP organization.
• Developed different custom Reports in XML Publisher
• Created Bursting files for sending report output as emails
• Workflows
• Customize PO Workflow to submit customized PO Printed purchased report and also to send customized notification.
• Customize OM line level Workflow to have different hold when booking the sales order
• Customizing OM: COGS Account Generator Workflow to determine the COGS account based on the “Accounting Split”
• OAF
• PersonalizediExpense attachment upload page to include “Note” to the users at the organization level.
• Worked iniRecruitmentmodule for validating external email id for external users.

Confidential

Technical Consultant

Environment: Developer 10g, Oracle Apps R12

Responsibilities:

• Reports
• Customized AP Check Print Report.
• Developed different custom Reports in XML Publisher
• Conversions
• Customer Data load conversion
• AP invoice interface

Confidential

Software Engineer - Team Lead

Environment: Oracle 9i, Oracle Apps 11.5.10.2

Responsibilities:

• Reports
• Different OPM reports
• Changing the brand for Patent (SGB, PCS), Hünnebeck XML reports
• Customizing XML reports.
• Preparing quality documents.

Confidential

Software Engineer

Environment: Oracle 9i, Oracle Apps 11.5.10.2

Responsibilities:

• Data Loader Programs
• SQL Loader Program for MM PO Purchase Order Headers
• SQL Loader Program for MM PO Purchase Orders Lines
• MHY Inventory Transactions History Data Load
• MHY PO Purchase Orders Headers History Data Load
• MHY PO Purchase Orders Lines History Data Load
• MHY PO Invoice Receipts History Data Load
• SQL Loader Program for MM PO Invoice Receipts
• MHY AP Opened & Closed Invoices History Data Load
• SQL Loader Program for FI AP Opened & Closed Invoices
• MHY GL Posted & Un Posted Journals History Data Load
• SQL Loader Program for FI GL Posted & Un Posted Journals
• Interfaces
• Developed Pricing Lines Inbound Interface to upload OM Price details from legacy system to Oracle Apps Base tables using API QP PRICE LIST PUB.process price list.
• Developed Modifier and Qualifier Inbound Interface to upload Modifiers and Qualifier details from legacy system to Oracle Apps Base tables using API QP Modifiers PUB.Process Modifiers.

Confidential

Software Engineer.

Environment: Oracle 9i, Oracle Apps 11.5.10.2

Responsibilities:

• Created different Release folders and proper documentation
• Developed and customized complex and medium XML reports as well as RDFs.
• Customized discovered report.
• Developed and customized PL SQL Packages
• Developed Custom Database Tables.

Confidential

Software Engineer

Environment: Oracle 9i, Oracle Apps 11.5.9 and 11.5.10

Responsibilities:

• Understanding the functional requirements of the client, Analysis and Review of High Level documents and prepare Technical design document.
• Developed booking and Shipping E-mail Notifications to the customer using Alert Manager.
• Created an E-mail Notification to inform the users about new customer using Alert Manager.
• Customized different standard forms using Form Personalization.
• Worked on different API’s like apps.INV Quantity Tree PUB.Query Quantities, wsh delivery details pub.update shipping attributes, fnd global.apps initialize, wsh deliveries pub.delivery action, wsh freight costs pub.create update freight costs.
• Giving the resolution on different technical as well as EDI related issues as per Integra Support SLA.
• Populating default values into DFF automatically.
• Developed purchase order Inbound Interface to upload the PO details from legacy system to Oracle base tables using SQL* loader.
• Taking trace files.
• Reports
• Customized Aging -7 Buckets - By Account Report using report builder6i
• Customized standard Margin Analysis Report with Order management.
• Customized standard AR Invoice Report and Sales Order Acknowledgement Report.
• Customized standard AR invoices Report for pack-slip using Report 6i Tool.
• Item Data Monitoring Report (XML)
• Sales Order Lot Report (XML)
• Open Order Report in Dollar Value (XML).
• PO Shipping Transactions(Discoverer)
• I Expense details report ( Discoverer)
• Outstanding Purchase Orders Report.
• Work Order Close Out Actual Vs standard Report
• Billing Report.
• Shipping Register Report.
• Minimum Stock Report.
• Work flows:
• Customize OM line level Workflow to transfer line level DFF data from OM to IB and stop the flow until the product is getting installed at customer side.
• Customized line level Workflow to get the approval from OM Manager.
• Interfaces
• Developed GL interface to upload the journals data into oracle apps base tables.
• Developed Order Import Inbound Interface to upload Sales Order details from legacy system to Oracle Apps Base tables.
• Developed GL interface to upload the journals data into oracle apps base tables.
• Developed the Outbound interface to extract data from Oracle apps Base tables into Flat file using UTL FILE package in,