Professional Summary:

• Over 7 years of professional work experience as techno-functional consultant in Oracle ERP Application R12, 11i .
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite.
• Good Functional/Technical Knowledge in Oracle Applications with Distribution and Supply Chain Modules like OM-Order Management, INV-Inventory, PO-Purchasing, WSH-Shipping Financial modules like GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables , implementing OracleManufacturing and Planning applications, namely Oracle Advanced Supply Chain Planning, .
• Experience in all aspects of Software Development Life Cycle including System Analysis, Software Design, Development, Implementation and Testing.
• Expertise in Customization, Upgrade, Implementation and Production Support of Oracle Financials and Oracle Supply Chain modules.
• Excellent skills in Oracle 9i,10g,11g environments using SQL,PL/SQL, Developer 6i/2000 Oracle Forms 6i/10g and Reports 6i/10g , Discoverer 10g.
• Experience in Designing and developing reports using XML/BI Publisher.
• Strong coding experience in PL/SQL development using Packages, Stored Procedures with Functions, Triggers, Writing and Tuning complex SQL statements.
• Expertise in Design, Development and Customization of RICE Reports, Interface, Conversions and Extensions using PL/SQL, SQL Loader, UTL File etc.
• Extensive experience in customization of forms, Form Personalization, Customization of Reports, defining value sets and Defining Profile values by using Application Object Library AOL and Functional setups.
• Strong working knowledge in sub-ledger flows: Order to Cash, Procure to pay and drop ship processes.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Strong exposure on Trading Community Architecture TCA and multi-org in 11i and R12.
• Worked in designing various Technical and Functional Documents like MD070 and MD120 and Conversion Mapping CV060 using AIM Methodology.
• Ability to learn and implement the setups needed for financial, distribution and supply chain modules.
• Excellent analytical, problem solving, communication skills and interpersonal skills and consistently being organized by management and peer for producing high quality work.

Technical Skills:

• ERP Versions: Oracle Applications 11i, R12
• Modules: General Ledger GL , Oracle Payables AP , Oracle Receivables AR , Oracle Purchasing PO , Oracle Inventory INV , Order Management OM , Shipping WSH , Bill of Materials BOM , Work in Process WIP ,MES, Cash Management, Fixed Assets FA , QP- Advanced Pricing, iExpenses
• Languages: PL/SQL, SQL, C, C , Java, HTML, XML
• Self-Service Modules: i-Expenses, i-procurement
• Tools: Developer 2000, XML Publisher, SQL Loader, Toad, PL/SQL Developer, SQL PLUS, Oracle Workflow, Oracle Discoverer 10g/9i, OA Framework, HP- Quality Center, Oracle application Express APEX
• Databases: Oracle 9i, 10g, 11g, MS SQL Server 2010
• Operating System: Windows NT, UNIX, Windows-95, 98, 2000, 2003, 2007

Professional Experience:

Confidential

Role: Oracle apps Techno-Functional Consultant

Responsibilities:

• Involved in trouble shooting issues and helped development team in bug fixing. Following a strict change management process involves user tickets followed by problem analysis, development or bug fixes, unit testing and user acceptance testing.
• Documented the required trouble shooting issues maintained at all stages.
• Raising TAR's and working with oracle support for escalating issues and finding resolutions.
• Performed functional setups in OM module like setup of Transaction types, invoicing rules, Approval limits and Payment terms.
• Worked on designing and implementing Oracle Alerts and Lookups.
• Performed customer setups in Trading Community Architecture TCA .
• Developed workflows in for PO and OM workflows and debugged errors like duplicate rows in modules schema.
• Worked on Multi Organization structure, Multiple Reporting Currencies, Key and Descriptive flex fields, System Administrator
• Developed interface program for conversion of sales orders using the Order Import Open Interface program.
• Developed custom program to create orders SCM Orders. ASCP
• Developed Schedule Ship report to identify the errors in the shipment dates for the retail customers. This report lets the internal sales force identify the manual errors committed during the order booking process.
• Customized the Order Header workflow to place custom holds as per client requirement before the order is booked.
• Developed Sales Order Report using XML Publisher.
• Worked on oracle alerts and developed alerts to send mail notification to employees for settlement of advances in Oracle Payables.

Registration of Program: Registered Reports, SQL LOADER, PL/SQL Package with Oracle AOL.

Confidential

Role: Technical consultant

Description: Confidential is an International pharmaceutical company headquartered in Israel. It is the largest generic drug manufacturer in the world and one of the fifteen largest pharmaceutical companies in the world.

Responsibilities:

• Enhancements to Internet Expenses functionality.
• Working in TEVA ERP implementation project as an Oracle Applications Technical Consultant.
• Designed Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and iprocurement.
• Using SQL Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Customized the standard Cross Order Volume Report in Oracle Advanced Pricing QP module.
• Developed conversion program for validating and importing Open AR Transactions Invoices from legacy system to Oracle interface tables. Used Auto invoice Master Program to load the interface table data into Oracle AR base tables.
• Developed a custom layout XML format according to the user specifications and worked on incorporating it to the standard print Purchase Order and Invoice reports using XML Publisher BI Publisher .
• Performed migration of lookup types, value sets, Descriptive Flex fields, Profiles, XML templates, concurrent programs, request sets, request groups, menus, responsibilities, and alerts between database instances.
• Developed custom reports: Sub Ledger Accounting Report and New Account Code Combination Report using XML Publisher.
• Developed Customer License Form to save the Customer's License information.
• Involved in migrating developed objects between instances. Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL.
• Extensively involved in developing Technical Design Documents MD70 using Application Implementation Methodology AIM .

Environment: Oracle Apps R12, Procure-2-Pay, Oracle 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV, iExpenses, TCA, TOAD, Discoverer, XML Publisher, SQL Developer, Forms 6i , UNIX, Shell Scripting, WINDOWS XP.

Confidential

Role: Oracle Apps Technical Consultant

Responsibilities:

• This project was an upgrade project which involved the upgradation of Oracle Applications 11.5.8 to Oracle Application R12.
• Involved in following modules INV, AP, AR, OM, WIP, BOM, OPM, FA and iprocurement.
• Customized the components, upgraded shell scripts, which calls reports, control files and SQL files which are in the production.
• Migrated objects into Oracle Apps EBS R12.
• Setup Custom Modifiers to derive discounted price for few business requirements.
• Worked on the staging R12 Apps environment to convert AP suppliers and AP Open Invoices from 11i to TCA Model and AP of R12.
• Prepared technical design documentation and Unit test plan documents for XML Reports, Conversions and few Extensions.
• Developed Program for Item Conversion and Supplier Data Conversion.
• Developed Backlog Summary report for Sales Orders.
• Developed the templates for several reports using XML publisher.
• Developed Open Purchase Order Report.
• Involved in Item Import Interface and Item Cost Import Interface.
• Designed developed the custom interface program to create and update an item in Item Hub with database validations.
• Involved in Personalizing the Custom OAF page.
• Develop and manage the Oracle e-Commerce EDI Gateway products from a product management perspective, and integrate electronic business transactions with Oracle applications.
• Contributed to the design specifications of the Oracle XML Gateway and advised other product teams on the development of XML messages.
• Identified many Gaps/ Oracle Bugs / Enhancements in Oracle ASCP
• Developed Margin Analysis Report which will pull all the sales orders that are ship confirmed and Invoices that are created manually and created through Auto Invoice.
• Developed Price Book Extract Report for various price lists.
• Prepared design documents MD050 and technical documents MD070 for all the customizations.

Environment : Oracle Apps Release 12 12.1.3 , SQL, PL-SQL, Oracle 10g, Forms Reports, Putty, Workflow, WinSCP, UNIX.

Confidential

Description: Confidential has well-established franchises in the therapeutic areas of the central nervous and cardiovascular systems, and always explores new product opportunities that address a range of health conditions.

Responsibilities:

• Created Oracle Business Areas and Workbooks using Discoverer.
• Registration of Program: Registered Reports, SQL LOADER, PL/SQL Packages, UNIX Shell Script with Oracle AOL.
• Created Advanced Pricing, modifiers qualifiers for overrides and discounts.
• Assisted in setting up new business entities, legal entities and operating units in line with Oracle's multi-org architecture.
• Developed a custom Interface to: Update the customer account numbers that are no longer active, Create a relationship with the newly added customer account numbers. Delete the existing outdated customer account number relationship and Update the shipping details of the existing customer account numbers.
• Developed and tested PL/SQL package that contains utilities to support workflow activities of Contract Purchase Agreement a type of purchase order approval workflow process for Oracle Contracts and Sourcing applications.
• Developed and tested PL/SQL package that contains common utility functions and procedures to support Oracle Custom application workflow activities approval.
• Provided production support involving PL/SQL programming for Oracle Workflow to fix bugs and enhance the functionality.
• Defined expense report template required to generate expense reports for employees in Oracle Payables.
• Developed mapping between oracle interface file and ANSI standard EDI transactions.
• Developed a Pricing Formula in Oracle Advanced Pricing QP module to dynamically update the pricing of items.
• Developed PO Vendor Report, Vendor ledger report using XML Publisher
• Worked on oracle alerts and developed alerts to send mail notification to employees for settlement of advances in Oracle Payables.
• Developed reports like Pick Slip, Packing Slip, and Mailing Label for Shipping and Credit Order Detail, Orders by Item, Order Detail Summary Reports for Order Management and also Created New Reports as per client requests using XML Publisher.
• Prepared design documents MD0.50 and technical documents MD0.70 for all the customizations.

Environment: Oracle EBS 11.5.10, Order-2-Cash, INV, OM, PO, AR, AP, GL, QP, Oracle 10g, Forms 6i, Reports 6i, SQL, PL/SQL, Oracle Alerts, TOAD, SQL Developer, XML Publisher, Discoverer, UNIX

Confidential

Role: Technical consultant

Responsibilities:

• Used SQL Loader for import into custom tables and PL/SQL for complete validation of data and inserting into interface tables.
• Designed Sales Order check list and Quotation reports using XML Publisher.
• Creation of Concurrent executables and Concurrent Programs for Reports.
• Created PL/SQL package to validate customer, invoice type, banks, payment terms and currency data and insert the validated data into interface tables.
• Developed Customer interface to transfer and validate Customer data from legacy system to AR.
• Developed AR Customer Conversion Process from the legacy systems to Oracle Apps.
• Customized the standard Cross Order Volume Report in Oracle Advanced Pricing QP module.
• Performed Modifiers related setups in Oracle Advanced Pricing QP module for maintaining the discounts surcharges of items.
• Developed a Pricing Formula in Oracle Advanced Pricing QP module to dynamically update the pricing of items.
• Involved in design and development of Shipment Notification Concurrent program. This concurrent program sends email notification on the Order. This concurrent program uses the workflow for sending notifications.
• Customized some of the standard Oracle 11i critical reports like AR invoice, Past Due Invoice, Bank Account Listing, Employee Listing Report and GL Account Analysis to the client business requirements.
• Involved in preparation of Functional and Technical Documentation using AIM Methodology.

Environment: Oracle Applications 11.5.8, Developer 6i, Discoverer, UNIX, TOAD, Oracle 9i, Oracle Developer 2000 Forms 6i and Reports 6i , PL/SQL

Confidential

Title: Oracle Programmer

Responsibilities:

• Captured business requirements.
• Study the existing system and review it.
• Proposing the possible enhancements based on the above study.
• Involved in creating customer invoice reports.
• Extensively worked on UTL FILE Packages in Reading data from data files and put them in database tables.
• Development of functional specifications for developing reports with Finance team.
• Creation of Packages, Stored Procedures triggers using PL/SQL.
• Load the data using SQL Loader.
• Prepare the unit test cases and responsible for execution.
• Review enhancements made by peers in the team.
• Preparing High level and Low level design documents.

Environment: Oracle 9i, Developer 2000, Forms 6i, Reports 6i, SQL, PL/SQL, COM, XML, Windows NT 4.0, MS Access 2000.