SUMMARY

• Over 10+ 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), implementingOracle Manufacturing and Planning applications, namelyOracleAdvanced 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

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, North Wales, PA

Technical consultant

Responsibilities:

• Working in Confidential 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).
• Enhancements to Internet Expenses functionality.
• Performed migration of lookup types, value sets, Descriptive Flex fields, Profiles, XML templates, concurrent programs, request sets, requestgroups, 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, Newport Beach, CA

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/OracleBugs / EnhancementsinOracleASCP
• 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, NY

Oracle Techno- Functional Consultant

Responsibilities:

• 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 fixbugs 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 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.
• Assisted in setting up new business entities, legal entities and operating units in line with Oracle’s multi-org architecture.
• Created Advanced Pricing, modifiers & qualifiers for overrides and discounts.
• 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.
• Registration of Program: Registered Reports, SQL*LOADER, PL/SQL Packages, UNIX Shell Script with Oracle AOL.
• Created Oracle Business Areas and Workbooks using Discoverer.
• 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

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

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.