Summary:

• 8 years of experience as Oracle Applications EBS Technical Consultant with experience in Versions R12/11i in multiple Oracle Application projects.
• Experienced in the Order-to-Cash and Procure-to-Pay business flows
• Expertise in technical analysis, solution design, development, testing, customization ,extensions of existing EBS systems, involving technical expertise on different modules Purchasing PO , iProcurement, Account Payable AP , Order Management OM , iStore, Inventory INV , Account Receivable AR , E-Business Tax EB-TAX , Sub-Ledger Accounting SLA ,Bill of Material BOM , Work In Process WIP , Oracle Process Manufacturing OPM , Enterprise Asset Management EAM .
• Involved in Implementation, Upgrade and Support of Oracle Applications E-Business Suite using SQL, PL/SQL, Oracle Reports 6i, 10g, BI/XML Publisher Reports, Oracle Application Framework OAF Development, Personalization and Extension, Oracle Form Personalization, Custom.pll, Oracle Workflow, Oracle XML Gateway Message Designer, UNIX and Shell scripting.
• Design and Development of Interface, Conversion programs to import data from various sources into Oracle Applications using PL/SQL, SQL Loader, UTL FILE package. Technically proficient in writing Procedures, Packages, Functions, Triggers, Views, Records, Constraints, Synonyms, Indexes and other database objects.
• Well versed with writing AIM Application Implementation Methodology Documents Technical Design Document - MD70, Conversion Design Document- CV60, Change Management Document- CM40, Installation Instructions Document - MD120, Unit Test Plan Document- TE020.
• Experience in working with the business to gather requirements. Strong programming, debugging and problem solving skills and ability to translate customer requirements into technical solutions.
• Worked with oracle support to resolve seeded application issues .Created service requests SRs with oracle support and tracking them to closure.
• Experience with the following tools: Forms Personalization, TOAD, SQL Developer, Putty, Win SCP, BMC Remedy and version control, PVCS, WINCVS, SVN, Kintana.

Technical Skills:

Primary Skills: Development,Personalization andExtension of OAF, XML Reports, InterfaceandConversions components, Oracle Workflows, Oracle XML Gateway, preparing technical documentation and installation files. Unit and system integration testing.

Operating Systems: Win. XP, 98, UNIX

Languages: Oracle SQL, PLSQL, C, Java, HTML, JavaScript,UNIX Shell Scripting

Development Tools: Toad, SQL Plus, SQL Developer, SQL Loader, JDeveloper, Reports 6i and 10g,BI Publisher, Oracle Workflows, Oracle Message Designer

Scripts: SQL,PLSQL, UNIX Shell Script

Databases: Oracle 10g, 8i, 9i

Configuration Tools: PVCS, WINCVS,SVN, Kintana

Domain Knowledge: Oracle Applications

ERP: Oracle Application E-Business Suite 11.5.10.2, R12

Documentation: MD70, TE020, CV60, CV70, MD120

Server Technologies: Java J2ee

Professional Experience:

Confidential

Role: Senior Oracle Apps Techno Functional Consultant

Responsibilities:

• Responsible for gathering requirements from business on enhancementsfor EDI Order Interfaces, Inventory Interfaces and iProcurement Customization and Extension.
• Designing of file formats for EDI Order interface.
• Developedenhancements for order interface to put order on hold, pass coupon codes, pass one-time ship to, pass additional comments and packing instructions.
• Developed enhancements for inventory interface to send notifications with attachment containing errors records and error message encountered during item creation, category assignment, catalog creation.
• Developed OAF personalization and extensions for iProcurementto default attachment category,clear form fieldswhen Add To Cart button is pressed, hide change button and add validation on cancel button in My Requisitions page for PO linked to requisition.
• Performed setups in Advanced Pricing relating to freight modifier, Promotion modifier.
• Prepared change request documentation and unit test plans. Performedunit testing.
• Migration of objects to higher instances- QA,PROD.
• Prepare installation scripts for migration and installation of solutionsto higher instance.

Environment: Oracle E-Business Suite R12.1.3 iProcurement, Inventory INV , Order Management OM , Oracle Application Framework,SQL, PL/SQL, UNIX, Winscp,Oracle SQL Developer.

Confidential

Role: Senior Oracle Apps Techno Functional Consultant

Responsibilities:

• Interacted with the business users on understanding requirements.
• Worked with third party EDI partner indesigning EDI specifications. Mappedxml message to EDI format.
• XML Gateway setupfor purchasing and payables to enable xml transactions for suppliers.
• Developed custom xml message maps by customizing seeded xml message maps to meet business requirements.To generate/consume xml messages to/from third party applicationand load inbound data into custom staging tables for the following transactions.
• Purchase Order Outbound EDI-850 .
• Purchase Order Changes Outbound EDI-860 .
• Purchase Order Acknowledgement Inbound EDI-855 .
• Purchase Order Advanced Shipment Notice Inbound EDI-856 .
• Payable Invoice Inbound EDI-810 .
• Developed custom interface programs to import advance shipment notice receipt using standard Receiving Open Interface,payable invoice usingPayable Open Interface tables and PO Acknowledgement using standard API.
• Developed concurrent programs which can be run on-demand and also be scheduled as daily jobs to report error records, trigger email notification with error records, reprocessfailed transactions.
• Wrote SQL Scripts to create and drop database objects like tables, synonyms and grants script.
• Extensively utilized the Application Object Library AOL to Register PL/SQL Procedure, Host Script andcreated value sets.
• Prepared installation scripts for migrating and installing solutions in higher instance.
• Unit tested the XML transactions in developmentinstance and provided support duringsystem integration testing and User Acceptance Testing.
• Logged service requests with Oracle and worked with Oracle in resolution of Applications Software defects.
• Development of Technical Design MD070 , Test Case Documents TE020 and Installation Document MD120 and installation files.
• Presented documentation to customer for review.

Environment: Oracle E-Business Suite R11.5.10.2 Purchasing PO , Inventory INV , Order Management OM , Account Payables AP ,XML Gateway Administrator ECX , Workflow web administrator, Oracle XML Gateway Message Designer, Oracle SQL Developer, PL/SQL,UNIX, Winscp.

Confidential

Role: Senior Oracle Apps Techno Functional Consultant

Responsibilities:

Analyzed the custom code componentsin Req to Pay process and retrofittedcustom Plsql Packages, Reports, Forms, Workflows to make them work in R12. Personalization and Extension of OAF pages in various modules.

• Retrofitted custom plsql interfaces - import Suppliers, Banks, Payable Invoices, Requisitions, Purchase Orders, and Receipts.
• Development of custom payment extract and formatting programs in R12 for Citibank and Landski Bank.
• Retrofitted XML Publisher and D2k Reports -Purchase Order Print Report, Change Order Report,RFQreport, Accrual Maintenance Summary Report, Check Print on preprinted stationary report,Duplicate Payment Report, Payable Trial Balance Report, Developed Multi language payment remittance advice.
• Retrofitted custom D2k forms for invoice entry and custom invoice interface.
• D2k form personalization of Purchasing and Invoice workbench.
• Development of custom OAF reports in manufacturing for Material Planning and Availability
• Personalization and Extension of OAF pages
• In iProcurement to default values, hide regions, change list of values, restricting search result to exclude specific set of data for particular responsibility.
• In Supplier setup to mask data, add regions to show additional details, Make DFF attribute mandatory for specific responsibilities, Adding attachment links.
• In Customer setup to make fields disable, required at user level and default values.
• In Purchasing Setup and EB-Tax setup to make pages read only for specific responsibilities.
• Retrofitted shell scripts used for loading data files using sql loader and developed shell script for delivering/retrieving files via FTP and moving files between directories.
• Retrofitted customized PO Approval, PO Document Create workflows.
• Unit testing and System integration testing.
• Preparation of installation files. Migrating and installing code to higher instances.
• Involved in the maintenance and support of existing applications with the users.
• RaisedOracle SR's for seeded product related issue and proactively followed to bring them to closure.
• Handled all the issues during the development phase of the project for PPB2, CRP, UAT1, UAT2
• Worked in the production support to debug and fix the issues in quick time frames.
• Performed code reviews.
• Development of Technical Design MD070 , Test Case Documents TE020 and Installation Document MD120 and installation files.
• Presenting documentation to customer.
• Assigning task to team members.
• Mentored new joinee's on projects with development and migration process.

Environment: Oracle E-Business Suite R12.1.3 Purchasing PO , Account Payable AP ,E-Business Tax E-Tax , Sub Ledger Accounting SLA , iProcurement ICX ,Oracle Reports 10g, Oracle Forms 10g, JDeveloper 10g, Oracle Workflows , SQL, XML/BI Publisher, OAF, PL/SQL, Unix, Winscp

Confidential

Role: Senior Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked with business tomap legacy sales order systemto oracle order entry.
• Development of Inbound Interface and Conversion Program.
• PL/SQL interface for updating offer details in Oracle Trade Management from Demantra.
• Legacy Sales Order Conversion for importing closed and open Sales orders.
• Created SQL Scripts to create and drop database objects like tables, sequence, PL/SQLpackage and grant script.
• Developed Unix Shell Scripts automate to installation oftable, PL/SQL code, concurrent program, value set.
• Utilized the Application Object Library AOL to register PL/SQL package as concurrent programs,value sets.
• Migrating and installing solutions.
• Development of technical design document MD070, CV060 , Installation document MD120 , Installation files and Unit Test Plans TE020 .
• Unit testing.Handled all the issues during the CRP and UATphase of the project.
• Presenting documentation to customer for Review.

Environment: Oracle E-Business Suite R12.1.2 -Order Management OM , Inventory INV , Demantra, OTM, Oracle SQL Developer, PL/SQL,UNIX, Winscp

Confidential

Role: Senior Oracle Apps Technical Consultant

Responsibilities:

• Meeting with customer to understand issues.
• Post-Production Support. Bug fixing in Interfaces, Reports and Form.
• Resolved issues related to error reporting in inbound interfaces - Importing WIP transactions, Importing PO Receipts, packing shipping deliveries to container.
• Resolved issues with custom form built on staging tables to enable re-processing of error records.
• Resolved issues related to scheduling of outbound ASN interface.
• Resolved issues with custom xml report to display correct material status of inventory items.
• Development of change management document-CM040, Installation document MD120 , Installation files and Unit Test Plans TE020 . Unit testing.
• Solved user queries, and maintained clear explanations of problems and resolution logs.
• Preparation of Installation Files. Migrating and installing solutions in QA and PROD instance.
• Presenting documentation to customer for Review.

Environment: Oracle E-Business Suite R12.1.1 - Order Management OM , Purchasing PO , Inventory INV , Work In Process WIP , Bill Of Materials BOM , Oracle Reports 10g, BI Publisher, Oracle SQL Developer, PL/SQL, Winscp, Unix

Confidential

Role: Oracle Apps Technical Consultant

Responsibilities:

• Developed PL/SQL packagesused by custom iStore application interface.
• Development of inbound interface to create Customer, Customer site, Contact, Customer relationship using HZ API's. Converting quote to Order using API's.
• Development of outbound interface in TCA module to extract hierarchical customer relationships.
• Created SQL Scripts to create and drop database objects like tables, sequence, plsql package and grant script.
• Developed Unix Shell Scripts to migrate PLSQL Packages to different instances.
• Development of technical design document MD070 , Installation document MD120 , Installation files and Unit Test Plans TE020 .
• Unit testing and system integration testing.
• Migrating and installing code to higher instances.
• Worked actively to troubleshoot defects during CRP, UAT testing.
• After go-live performed Post production support.
• Presenting documentation to customer for Review.

Environment: Oracle E-Business Suite R12.1.1 - Order Management OM , Inventory INV ,Trading Community Architecture TCA , iStore, PL/SQL, API, Oracle SQL Developer, Unix, Winscp

Confidential

Role: Oracle Apps Technical Consultant

Responsibilities:

• Interacted with the business users on understanding requirements for development of interfaces and reports.
• Development of Inbound and Outbound Interface.Customization and Development of XML Publisher Report.Personalization and extension of OAF pages.
• Developed outbound interface to extractsales order delivery details. Developed inbound interface to update sales order reservations.
• DevelopedMulti-language xml publisher report - AR Invoice Print and Balance Forward Billing report using bill presentment architecture. Purchase Order print, Purchase Order pending invoicing, Voucher print report. Supplier statement. TDS report.
• Developed E-Text template for Payment extract for Citibank Korea.
• Developed OAF extension in iExpenses to default distribution template while entering expenses.
• Development of technical design document MD070, CV060 , Installation document MD120 , Installation files and Unit Test Plans TE020 .
• Wrote SQL Scripts to create, alter, and drop database objects like tables, views, and sequences.
• Developed Unix Shell Scripts to migrate the OAF Personalization code, XML Publisher definitions, Concurrent programs, Value sets to different instances.
• Extensively utilized the Application Object Library AOL to Register PL/SQL Procedures and reports.
• Wrote SQL scripts to create staging tables and developed SQL LOADER Control files to load the legacy data into the staging tables
• Migrated and installedcode components in higher instances.
• Participations in the code reviews and Technical design reviews.
• Worked actively to troubleshoot defects and problem during CRP and UATtesting.
• Performed Post-Production support post Go-Live.

Environment: Oracle E-Business Suite R12.1.1 - Order Management OM , Inventory INV , Purchasing PO , Account Payable AP , Account Receivable AR , Oracle Reports 10g, OAF, Jdeveloper 10g, Oracle SQL Developer, BI Publisher, PL/SQL, Unix, Winscp

KeyWords:

Oracle, Oracle Applications, Oracle Apps, Oracle EBS, E-Business, Ebusiness, Technical, TechnoFunctional, Techno Functional, Supply Chain, SCM, Manufacturing, Distributions, Discrete, R12, 11i, O2C, OTC, Order To Cash, P2P, PTP, Procure To Pay, Purchasing PO , iProcurement, Account Payable AP , Order Management OM , iStore, Inventory INV , Account Receivable AR , E-Business Tax EB-TAX , Sub-Ledger Accounting SLA , Bill of Material BOM , Work In Process WIP , Oracle Process Manufacturing OPM , Enterprise Asset Management EAM . , QP Advance Pricing , Functional, RICE, Reports, Interfaces, Customizations, Extensions, Conversations, Workflow, BOM, SQL, PLSQL, Oracle Reports, Discover, Oracle Forms, BI Publisher, XML Bursting, Oracle Workflow and SQL Tuning, OAF, AOL, Alerts, Inventory INV , Order Management OM , Purchasing PO , Bill of Materials BOM , Magento, BI/XML Publisher, PL/SQL, Purchasing PO , ASCP, Planning, Workflow Builder, General Ledger GL , Supply Chain Management, Supply, Chain, Oracle SCM, Oracle, Oracle Applications, Oracle Apps, Oracle EBS, E-Business, Ebusiness, Technical, TechnoFunctional, Techno Functional, Supply Chain, SCM, Manufacturing, Distributions, Discrete, R12, 11i, O2C, OTC, Order To Cash, P2P, PTP, Procure To Pay, OM, INV, PO, AP, Service Contracts, Install Base, QP Advance Pricing , Functional, RICE, Reports, Interfaces, Customizations, Extensions, Conversations, Workflow, Demantra, BOM, SQL, PLSQL, Oracle Reports, Discover, Oracle Forms, BI Publisher, XML Bursting, Oracle Workflow and SQL Tuning, OAF, AOL, Alerts, Inventory INV , Order Management OM , Purchasing PO , Bill of Materials BOM , Magento, BI/XML Publisher, PL/SQL, iProcurement, iStore, Purchasing PO , iProcurement, Account Payable AP , Order Management OM , iStore, Inventory INV , Account Receivable AR , E-Business Tax EB-TAX , Sub-Ledger Accounting SLA , Bill of Material BOM , Work In Process WIP , Oracle Process Manufacturing OPM , Enterprise Asset Management EAM , Advance Pricing QP , Shipping, Oracle Application Framework OAF , Purchasing PO , ASCP, iProcurement, iStore, Purchasing PO , iProcurement, Account Payable AP , Order Management OM , iStore, Inventory INV , Account Receivable AR , E-Business Tax EB-TAX , Sub-Ledger Accounting SLA , Bill of Material BOM , Work In Process WIP , Oracle Process Manufacturing OPM , Enterprise Asset Management EAM , Advance Pricing QP , Shipping, Oracle Application Framework OAF , Planning, Workflow Builder, General Ledger GL , Supply Chain Management, Supply, Chain, Oracle SCM, Oracle, Oracle Applications, Lead, Oracle Apps, Oracle EBS, E-Business, Ebusiness, Technical, TechnoFunctional, Techno Functional, Supply Chain, SCM, Manufacturing, Distributions, Discrete, iProcurement, iStore, Purchasing PO , iProcurement, Account Payable AP , Order Management OM , iStore, Inventory INV , Account Receivable AR , E-Business Tax EB-TAX , Sub-Ledger Accounting SLA , Bill of Material BOM , Work In Process WIP , Oracle Process Manufacturing OPM , Enterprise Asset Management EAM , Advance Pricing QP , Shipping, Oracle Application Framework OAF , R12, 11i, O2C, OTC, Order To Cash, P2P, PTP, Procure To Pay, OM, INV, PO, AP, Service Contracts, Install Base, QP Advance Pricing , Demantra, BOM, SQL, PLSQL, Oracle Reports, Discover, Oracle Forms, BI Publisher, XML Bursting, Oracle Workflow and SQL Tuning, OAF, AOL, Alerts, Inventory INV , Order Management OM , Purchasing PO , Bill of Materials BOM , Magento, BI/XML Publisher, PL/SQL, Purchasing PO , ASCP, Planning, Workflow Builder, General Ledger GL , Supply Chain Management, Supply, Chain, Oracle SCM, Functional, RICE, Reports, Interfaces, Customizations, Extensions, Conversations, Workflow, Oracle, Oracle Applications, Oracle Apps, Oracle EBS, E-Business, Ebusiness, Technical, TechnoFunctional, Techno Functional, Supply Chain, SCM, Manufacturing, Distributions, Discrete, R12, 11i, O2C, OTC, Order To Cash, P2P, PTP, Procure To Pay, OM, INV, PO, AP, Service Contracts, Install Base, QP Advance Pricing , Demantra, BOM, SQL, PLSQL, Lead, Oracle Reports, Discover, Oracle Forms, BI Publisher, XML Bursting, Oracle Workflow and SQL Tuning, OAF, AOL, Alerts, Inventory INV , Order Management OM , Purchasing PO , Bill of Materials BOM , Magento, BI/XML Publisher, PL/SQL, Purchasing PO , ASCP, Planning, Workflow Builder, General Ledger GL , Supply Chain Management, Supply, Chain, Oracle SCM, Oracle, Oracle Applications, Oracle Apps, Oracle EBS, E-Business, Ebusiness, Technical, TechnoFunctional, Techno Functional, Supply Chain, SCM, Manufacturing, Distributions, Discrete, R12, 11i, O2C, OTC, Order To Cash, P2P, PTP, Procure To Pay, OM, INV, PO, AP, Service Contracts, Install Base, QP Advance Pricing , Demantra, BOM, SQL, PLSQL, Oracle Reports, Discover, Oracle Forms, BI Publisher, XML Bursting, Oracle Workflow and SQL Tuning, OAF, AOL, Alerts, Inventory INV , Order Management OM , Purchasing PO , Bill of Materials BOM , Magento, BI/XML Publisher, PL/SQL, Purchasing PO , ASCP, Planning, Workflow Builder, General Ledger GL , Supply Chain Management, Supply, Chain, Oracle SCM, Functional, RICE, Reports, Interfaces, Customizations, Extensions, Conversations, Workflow.