SUMMARY

• About 7 years of experience in design, development, support, customization and implementation of Oracle Applications (ERP) and 3 years on SOA Integrations.
• Experience working with Web Services and Integrations using Oracle Fusion Middleware components utilizing SOA components such as BPEL, ESB, OSB, BAM and Business Rules
• Extensive experience in defining, analyzing, designing, implementation and support for Oracle Supply Chain Management, Manufacturing and Financial modules like Purchasing (PO), Order Management (ONT), Inventory (INV), Work In Process (WIP), Bills of Material (BOM), Material Resource Planning (MRP), Costing, Shipping (WSH), Advance Pricing (QP), Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL).
• Experience in designing, developing, implementing and customizing RICE Components.
• Proficient in importing data from legacy systems or 3rd party tools to Oracle Applications through interface programs and conversion programs by developing PL/SQL scripts for SQL loader and writing custom wrapper.
• Proficient experience in AOL concepts and System Administration by providing support to apps users in Oracle Applications.
• Extensive experience in Customization and Modification of Forms, Reports using Oracle Forms 4/6i, Oracle Reports 3.0/6i.Experience in developing applications using Oracle RDBMS 9i/8i.
• Excellent skills in designing and developing different types of Reports using Oracle Reports3.0/6i, Discoverer 4i & XML Publisher.
• Good working experience in modeling, automation, and continuous improvement of business processes, routing information of any type according to user - defined business rules using Oracle Workflow 2.6.3.
• Used Oracle AIM documentation for preparing technical design documents for customization and conversions in Project Implementation Methodologies.
• Proficient in understanding the concepts and hierarchical structure of Multi Org. Good knowledge of TCA Architecture.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development using SQL*Loader, SQL developer and Toad as development tools. Created and maintained Database objects.
• Exposure of UNIX Shell Scripting to schedule concurrent programs.
• Worked in projects that involved Fine tuning of queries for faster retrieval of data and involved in resolving various Troubleshoot issues.
• Excellent Team Player with good problem solving approach having strong interpersonal, communication, leadership skills and ability to work in a time-constrained and team-oriented environment.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS

Enterprise Applications: Oracle E-Business Suite Applications R12/11i

ERP/Modules: Oracle Purchasing (PO), Oracle Order Management (OM), Oracle Inventory (INV), Bills of Material (BOM), Costing, Shipping (WSH), Oracle Receivables (AR), Oracle Payables (AP), General Ledger (GL).

Oracle Fusion Middleware: BPEL, ESB, WSM, OC4J, SOA Suite 10g/11g, Adapters (EBS, AQ, JMS, File, FTP), BPEL Adapters Designer, ESB Designer.ADF

Programming Languages: SQL, PL/SQL, C, C++, JAVA, HTML

Development Tools: JDeveloper 10g/11g, Eclipse, Oracle Forms 6i, Oracle Reports 6i, Oracle Workflow 2.6.3

Database: Oracle 8i/9i/10g

Tools: TOAD, SQL*PLUS, SQL* Loader, SQL developer, XML Spy, Rational ClearCase

Operating System: Windows 98/NT/2000/XP/Vista, Windows 7, SUN Solaris 2.5/5.6, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

Oracle Apps Consultant

Responsibilities:

• Developed data validation programs using PL/SQL package/procedures for various objects for loading transaction data from staging table into interface tables
• Developed custom Reports in GL such as Account Analysis Report, Trial Balance Report and Inter-Company Transaction Register Report to keep track of inter company revenues, assets, liabilities and expenses.
• Designed, developed and worked on PO requisition interface and Order Import Interface to import requisition data from third party system to Oracle system.
• Developed interface program to import PO/RMA receipts, Sub-inventory Transfers from the Third Party logistics system to Oracle Inventory by using inbound Electronic Data Interchange.
• Designed and developed a Custom Invoice Report in Oracle Account Receivables.
• Involved in managing concurrent programs, application user setup, defining responsibilities, registering forms and reports.
• Involved in development of reports based on business requirements and registered them in Oracle Applications.
• Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures and Packages.
• Involved in the development of Interfaces/ Conversions to import the data from legacy system into oracle application base tables.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Designed and developed custom program to interface daily all invoices from different systems into AR using Auto invoice, with validation and audit report.
• Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL FILE package.
• Prepared Technical Requirement Specifications MD 70 for all the objects.

Environment: Oracle Applications 11i (INV, PO, AR, AP, OM), Oracle 10g, SQL Developer, TOAD, PL/SQL, SQL* LOADER, Forms 9i, Reports 9i, XML Publisher, OAF, Workflow 2.6.3., BI Publisher

Confidential, San Antonio, TX

Oracle Apps/SOA Consultant

Responsibilities:

• Designed and developed integration solution to Interface SciQuest Invoices with Oracle E Business Suite R12
• Design BPEL Process to Integrate Purchase Orders from SciQuest with Oracle ERP
• Designed and Developed SOA solution to Interface Master Data (Suppliers, Customers, Items) with third party systems
• Developed Generic Exception Handling process to handle exceptions across different SOA interfaces
• Designed and Developed Supplier and Employee Bank Account Conversion in AP module
• Customized Oracle OM search form to add more fields for search criteria
• Involved in the design and development of Vendor Conversion which involves loading new Suppliers, Sites and Contacts in PO
• Designed templates for Invoice Report, Customer Report using XML publisher desktop
• Customized various reports such as EDI Rebate Report, Packing List Report, Commercial invoice Report and Sales Order Acknowledgement.
• Used AQ/MQ Adapters to consume EBS outbound messages and send inbound messages from and to Oracle EBS, legacy systems and trading partners.
• Developed custom interface programs for validating and inserting the On Hand Quantity data into interface tables. Scheduled a standard API to load data into the target base tables.
• Worked on the Oracle Inbound Ship Confirm Interface, which perform actions on Deliveries, Updating shipping attributes, updating the Freight costs by calling an API.
• Worked on Sales Order Interface to populate base tables of OM.
• Documented functional features and behavior of required customizations using AIM methodology. Prepared and involved in analyzing conversion documents CV 40 and CV 60.
• Customized various standard reports in PO, INV and created new reports as per business requirements, using Oracle reports.
• Documented all the above objects using Oracle AIM methodology
• Developed XML Publisher Reports in various modules based on existingOraclereports.

Environment: Oracle Applications 12.1.3 (INV, PO, AR, GL, AP, OM, WSH, QP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Forms 9i, Reports 9i, XML Publisher, OAF, Workflow 2.6.3., BI Publisher

Confidential, Whitehouse Station NJ

Oracle Applications/SOA Consultant

Responsibilities:

• Design and development of integration methodology between Honeywell POMSnet and Oracle MES for weight and dispense of materials.
• Developed various BPEL and ESB interfaces to send the Material Master, Formula and Recipe, Batch information to POMSnet.
• Developed business events for each of the interfaces to trigger the event and routed the process to kick off the particular outbound transaction.
• Used JMS adapters and Java web services to write the messages on to the JMS queues.
• Developed the underlying PLSQL packages, Views and triggers related to the interfaces.
• Developed interfaces for handling Batch Step Complete, Batch Ingredient Allocation and Inventory adjustment transactions from POMSnet to Oracle.
• Designed and developed a sequencing logic to make the transactions sequential as they are interdependent on each other.
• Enhanced the existing Fault Handling application to fit the need of the requirement.
• Developed an email bursting report to notify the concerned persons about the errors.
• ESB is used to route the processes from the triggering event.
• Responsible for preparing TDS (Technical Design Spec) for all the interfaces and processes.
• Customized various standard reports in PO, INV and created new reports as per business requirements, using Oracle reports.

Environment: Oracle Applications 11i (INV, PO, AR, GL, AP, OM, WSH, QP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Forms 6i, Reports 6i, XML Publisher, OAF, Workflow 2.6.3,JDeveloper 10g, BPEL, ESB and BAM.

Confidential, Chicago IL

Oracle Applications/SOA Consultant

Responsibilities:

• Designed and developed a BPEL process to integrate Oracle Applications 11i Inventory Module 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
• Designed wrapper PL/SQL and Java API’s that were invoked from within BPEL PM. Used FTP and DB adapters with ESB to upload files from the ftp location into Oracle database.
• Leveraged the EDI Layer of the SOA Suite along with the EBS Adapters to transmit the advance shipment notification to customers.
• Created BPEL process to invoke web services to extract the Customer information from legacy system to integrate with the Oracle EBS System
• Involved in BOM conversion by developing a custom interface program to load the staging table data into BOM base tables.
• Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables.
• Worked on price list API to populate base tables in QP.
• Involved in customization of various Reports in PO and OM modules using XML Publisher.
• Extensively used AOL for Configuration of Key Flex Fields and Descriptive Flex Fields.
• Registered the automation scripts as concurrent programs and created a scheduling process that invokes the script periodically.
• Developed Custom Order Hold and Discounts program using OM and Advanced Pricing module through PL/SQL.
• Developed Reports using Discoverer 6i, Created business areas, custom views, new folders, conditions and joins based on user requirements.
• Customized Workflows for sending notifications using workflow 2.6.3.
• Involved in the end users on the functionality of Procure to Pay modules.

Environment: Oracle Applications 11i (PO, OM, INV, GL, AP, QP and BOM), TOAD, Oracle 10g, SQL*Plus, PL/SQL, SQL*Loader, SQL Navigator, Forms 6i, Reports 6i, XML Publisher, OAF, Discoverer 6i, Workflow 2.6.3, JDeveloper 9i, BPEL, ESB

Confidential, Hoffman Estates IL

Oracle applications Technical Consultant

Responsibilities:

• Analyzed the Business Systems for Oracle Application integration, interacted with end users to gather and analyzed the technical requirements, designed, drafted specifications, developed and implemented Financial Modules.
• Involved in Customer Conversion to load Customer details into HZ base tables by an API.
• Developed the AP invoices Interface program, loaded the data into interface tables and calling Payable Import Program.
• Loaded Legacy Journals data into interface tables and then populated the base tables of GL by running standard API.
• Implemented and supported AR Auto Invoice import Interface program.
• Involved in Enhancement of the existing system by developing new forms for the system and integrating them with existing modules. Customized existing forms and incorporated new functionalities.
• Involved in customization of standard Oracle reports in AR, AP and GL as per client requirements using Oracle Reports.
• Customized Workflows for sending notifications using workflow 2.6.3. Prepared functional and technical specifications according to Organizational wide standards.
• Registering concurrent programs, request groups for reports and concurrent requests.
• Involved in development of customer Interface and Interacting with users to get the requirements and mappings during conversion.
• Involved in the end users in creating and modifying thereceipts, Invoices, customer detailsfrom front end andhelp them in understanding the complete process and flowof AR and AP modules.
• Performed testing while assuring smooth transition to production, wrote technical documentation, set up user- workshops and assisted with enhancements requests.
• Developed Reports using Discoverer4i, involving creating folders, drill down reports and item classes in AP, AR and GL.

Environment: Oracle Applications Release 11i (11.5.9), AR, AP, GL, OM, PO, WIP Toad, PL/SQL, SQL Plus, Forms 4.5, Reports 6i,SQL* Loader, Workflow 2.6.3, Discoverer 4i.

Confidential, Buffalo Grove, IL

Oracle Applications Technical Consultant

Responsibilities:

• Involved in improving existing functionality and business processes (in the areas of Orders, Contracts, and Invoices) using TCA concepts.
• Converted the data from legacy systems into 11i. Developed control files for SQL*Loader and PL/SQL programs for loading, data mapping, data conversions and validating the data into the interface tables of AP.
• Wrote a Program to insert data into Item Transaction Interface tables based on different Transactions and populated the base tables by calling a seeded API.
• Worked on the Oracle Inbound Ship Confirm Interface, which perform actions on Deliveries, Updating shipping attributes, updating the Freight costs by calling an API.
• Populated customer base tables in AR by implementing customer Interface program.
• Involved in customization of standard Oracle reports in OM, AP as per client requirements using Oracle Reports.
• Involved in customization of schedule order form and moved Promise Date from one canvas to another, using Oracle Forms.
• Designed and developed numerous packages and procedures using various APIs to load data from staging tables into Oracle base tables.
• Developed OM queries to Count Orders by Order Types, Order Source. Identified, demonstrated and documented Order Entry, drop shipments, Internal Orders.
• Updated Profile Options for related modules and successfully upgrade to Multi-org functionality.
• Hands on experience in Oracle Applications System administration, involved in setting up user responsibilities, privileges of users, administering concurrent managers/transaction managers (activate/deactivate, request priorities), registering various Forms and Reports.
• Took part in the entire phase of the project which includes, initial operations analysis, business process re-evaluation, testing,, conversions, customizations and documentation and implementation of modules.

Environment: Oracle Applications Release 11i (11.5.9), AR, AP, INV, OM, WSH, GLToad, PL/SQL, SQL *Plus, Forms 4.5, Reports 6i, SQL* Loader.

Confidential, Boston, MA

Oracle Applications Technical Consultant

Responsibilities:

• Performed PO data conversion by developing a custom wrapper and then populating the Oracle base tables through a standard API.
• Developed interface programs for importing the On Hand Quantity data into interface tables. Scheduled a standard API to load data into the target base tables.
• Developed SQL loader scripts and custom interface programs for importing, validating and inserting the WIP Move Transactions data into the target base tables.
• Performed Item Cost Interface to load data into base tables by calling concurrent program.
• Worked in Oracle Back-end PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using Toad as development tools.
• Developed Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Developed Reports to extract the monthly sales information. Developed custom reports and added columns in the existing reports according to the requirement.
• Involved in Enhancement of the existing system by developing new forms for the system and integrating them with existing modules.
• Worked on tuning the SQL Queries for better performance.
• Developed Reports using Discoverer4i, Created business areas, custom views, new folders, conditions and joins based on user requirements.
• Involved in UNIX Shell Scripting for scheduling concurrent programs.

Environment: Oracle Applications Release 11i, INV, PO, CST, WIP, OM Oracle 9i, PL/SQL, SQL, Forms 4.5, Repots 6i, Discoverer, SQL*Loader, UNIX.

Confidential

Oracle Database Developer

Responsibilities:

• Created and altered logical and physical database objects such as table spaces, tables, indexes, synonyms, sequences, constraints, and triggers to development needs.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Worked closely with database developers to ensure adherence of the database guidelines, standards and procedures and generated system plans.
• Created s procedures, triggers and functions to retrieve data from the database using PL/SQL.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Created user defined Exceptions while Handling Exceptions
• Created Test Packages for other packages and procedures.
• Troubleshooting production problems and worked effectively with address problems.
• Involved in testing and fixing bugs.

Environment: Oracle 8i, PL/SQL, SQL, SQL*Loader, Toad