PROFESSIONAL EXPERIENCE

• 4 years of Experience in IT with of ERP experience as a Technical or Techno Functional consultant in Developing, Customizing, Testing and Implementation in Oracle Supply Chain, Financials.
• Experienced in Upgrade, Implementation and Production Support of Oracle Application 10.7, 11.0.3,11i, 11.5.9, 11.5.10.2 and R12.0.3
• Experienced in Data Conversion, Interfaces, Extensions, Customization and new development in Oracle Application including OM,INV,PO Oracle Apex Project accounting AP Oracle Workflows (2.6.3).
• Expertise in AOL, System Administration, Workflow and Trading Community Architecture (TCA).
• Experience in XML Publisher & BI Publisher.
• Worked on third party tools (SRS, Remedy and EITF) integrated with Oracle Applications.
• Extensive experience in Oracle backend objects like Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Expertise in developing database applications using Oracle with Developer 2000 (Forms 6i, Reports 6i)
• Extensive experience with Oracle Discoverer 4i/10g including Discoverer Desktop Version and Discoverer Administrator.
• Worked on interfacing in/out of oracle Applications with Legacy Systems and customizations of Oracle Reports (6i/10g) and Forms (4.5/5/6i/9i) of different modules.
• Extensive experience with Oracle AIM (Application Implementation Methodology)
• Experienced in Developing Technical Specification and Design Document.
• Performance Tuning of custom applications including reports and back - end programs by using different application tuning techniques like Explain Plan, tkprof etc.
• Having strong Business and Analytical skills.
• Experience in System Admin tasks like creating/administering Users, Responsibilities, Menus, Forms, Profile options, printer Configurations, registering of concurrent programs.
• Implemented in the Successful live implementations of various ERP Projects for manufacturing and trading Organizations for American, European and Asian continents.

TECHNICAL SKILLS

ERP: Oracle Applications 12.0.3/11i/10.7

ERP Techno Functional: Oracle Workflow, AOL, Alerts, and

SYSADMIN:

Apps Modules: OM, INV, PO, PA, GL, AR.

Operating Systems: Windows XP, Windows NT/2000, UNIX

Languages: C, C++, Shell Script, Java, JSP, SQL, PL/SQLHTML, Java Script:

Databases: Oracle 7.x / 8.x / 9i /10g

Tools/Utilities: TOAD, CVS, PVCS, Clearcase, Kintana, CM Tool

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• SQL Loader scripting.
• Worked closely with project head for product development and testing phase of the project
• Performed implementation and provided training and technical support
• Create Apex triggers for different functions of the application including database and report triggers
• Write technical specifications and refining application data model
• Generate and verify forms and reports
• Create and define Row Sets, Columns Sets and Content Sets
• Created Tables, Synonyms, Sequences and Views
• Assisted in research and solving user testing bugs
• Performed code reviews
• Developing an outbound interface to provide new and updated customer information to the third party system
• Working with SQL loader scripts to load data into staging tables
• Developing and Registering Concurrent Programs for Interfaces and Reports
• P-card import interface

Environment/Tools Used: Oracle EBS APEX .

Confidential

Techno Functional Consultant

Responsibilities:

• Involved in the Implementation and Post-Implementation Support
• Created Technical design and implemented appropriate system setups and security rules.
• Customized PO account generator, Supplier invoice account generator.
• Communicated with Oracle on various bugs and issues seen during the R12.0.5 implementation.
• Developed the Auto Invoice process in AR for importing sales orders.
• Prepared functional design documents for new reports required during the closing process.
• Prepared UAT scripts and work instructions as part of user training, trained user on closing process.
• Worked on forms personalization to personalize several forms as per the clients needs.
• Used SQL*Loader to import data into interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Converted Inventory item on-hand quantity from the legacy system.
• Developed a Custom Forms in Inventory to maintain different projects and accounts handled by the company.
• Worked on Phones conversion Hrms
• Worked on the Procure to Pay process including handling the data conversions for Open Purchase Orders, Vendor Conversion, Open Invoices in AP, Payments in AP, Items in Inventory, etc.
• Developed Shell script for Oracle to Saba Outbound Interface, which is scheduled to run daily that extracts transaction details and Sales Order details for all the Customer POs in Saba Application.
• TCA Conversion - Developed a conversion program to load all the Customers from the external legacy system into the TCA Architecture including HZ PARTIES, HZ CUST ACCOUNTS, HZ RELATIONSHIPS, HZ CONTACTS, HZ CONTACT POINTS, etc
• Worked on the Payments module for defining the wire transfer payment method and to setup the mapping file with the bank to send electronic payments.
• Developed Interface Technical Specification Document for Customs Duty Billing, The scope and
• Developed PL/SQL stored procedure for credit memos containing training unit items, which is scheduled to run daily to generate accounting entries for the credit memos
• Developed new custom reports and also customized standard reports according to business requirements using Oracle Reports Builder
• Designed functional documents MD50s and technical documents MD70s for all the new reports developed.
• Involved in monitoring of the objects developed as part of production support
• Developed migration documents for all the developed components.

Environment: Linux x86, Windows XP, Oracle 10g, Oracle Forms 6i and Reports 6i, Discoverer 10g (Desktop and Administrator), XML Publisher

Confidential

Techno-Functional

Responsibilities:

• Customized the Print RFQ (Request for Quotation) Report (Sourcing Super User) using XML Publisher. Modified XSL Formatting Object (XSL-FO) to customize the template.
• Developed the Auto Invoice Interface in AR to load external invoices into AR.
• Developed a customized process in AR to defer revenue for a period of time.
• This customization revolved around the Revenue Recognition Process.
• Developed the shipping documents like Commercial Invoice, Pick Slip, Pack Slip and Mailing Label in XML Publisher.
• Modified the Data Definition to fetch new fields from the database and display it in the Report.
• Register custom Reports in Oracle Applications, creating Request Groups and assigning to appropriate responsibilities using System Administrator in Oracle Applications.
• Customization in OM Order Type/Line type to meet the specific accounting requirements. Setting up order types, Line types, price list, items, Order holds for booking and AR interface to allow review before creating invoices.
• Tune custom code for Performance and Easy Maintainability.

Environment: Linux x86, Windows XP, Oracle 10g, Oracle Forms 6i and Reports 6i, Discoverer 10g (Desktop and Administrator), XML Publisher