Summary:

• Over 7.0 years of experience in using Oracle Applications 11i/11.0.3/10.7 in System Analysis, Design, Development, Conversion, Customization, Interfacing, Implementation of business enterprise applications using ERP, Client/Server and Internet Technologies. Specialized in Oracle Applications Supply Chain Management and Financials with sound knowledge of their integration.
• Worked on various versions of 11i. Experience in Oracle Applications Implementation and Upgrade. Experience in setup, customization, data conversion, interface programming, system administration, developing reports and forms.
• Good programming knowledge in Oracle 9i/8i/8/7.x, Developer 2000 (Oracle Forms, Oracle Reports), PL/SQL, SQL*Loader and Discoverer Utilities.
• Strong background in Conversion, Customization and Interfaces of ORACLE Inventory, Shipping, Bill of Material, Costing, Order Management, Forecasting, Purchasing, WIP.
• Excellent analytical, inter-personal and communication skills. Excellent knowledge on DBMS, RDBMS and Distributed databases.

Software and Systems Core Competencies:

• Applications
• Oracle Inventory
• Oracle Order Management
• Oracle Purchasing
• Oracle Bill Of Material
• WIP
• Oracle Shipping
• Oracle Pricing
• Oracle Alerts
• Forecasting
• Oracle Multi-Org
• iSupplier
• Oracle General Ledger
• Accounts Receivables
• Accounts Payables

Technology

• Software, Tools & Languages
• Database
• Developer 2000, Designer 2000, Oracle Discoverer, Oracle SQL*Loader, Shell Scripts, C, HTML, XML Publisher, Oracle Query Builder ,SQL*Plus, SQL, PL/SQL, Oracle Interconnect, TOAD,SQL Navigator, Workflow Builder Oracle DBMS 7/8/9, Oracle Applications
• Hardware & Operating Systems
• Other
• HP-UNIX, Sun Solaris, AIX, NT Server, MS Windows, MS Windows NT, UNIX
• Performance Tuning, Backup and Recovery

Professional/Project Experience:

Confidential, Sep 07 – Dec 09
Oracle Techno-Functional Consultant

Responsibilities:

• Played key role as Production Support Analyst and worked with offshore team to resolve ongoing issues.
• Solely involved in Project Conversion of Oracle Applications to SAP in preparing extracts from all modules involving Items, Routings, BOM’s, On hand Inventory Conversion for all Organizations defined in system, List Prices, Customers, Vendors, Source Lists, Open AP and Open AR.
• Generated scripts for archiving Oracle data as part of System Retiring which includes GL Balances for all Legal Entities defined in system, GL Transactions, detailed AR Billing, Payables, Purchasing Transactions and Sales Transactions. Created UNIX shell scripts to efuse data to destination system.
• Generated Reports (Forecast 12 weekly buckets) sent to suppliers on weekly basis, Forecast Accuracy report that would generate percent error for an item based on forecast/ship quantity in given month.
• Prepared System Maintenance Technical Document.
• Developed custom program that would create Purchase Requisitions based on on-hand quantity for Kanban bins.
• Responsible for designing new responsibilities and Menu’s as part of Segregation of Duties project as part of SOX compliance.
• Extracted UTL files for Customers/Product/Sales/PO Vendors/Purchasing Commodities for database project.
• Created alert that would send email to Customer as Sales order Acknowledgement.
• Used XML Publisher to generate reports.
• Used standard API’s and created procedures for Mass Updating of Inventory Categories. Added new Product Line/Models for Inventory Items.
• Involved in Customization of AR Intercompany – VAT tax for Belgium Customers.
• Generated queries for users that will be used in Discoverer.
• Created DFF’s for Kanban cards and PO line locations per user requirement.
• Created In-transit Report that list Internal orders that are shipped to other Kodak orgs.

Environment: Oracle Applications Release 11.5.10 (INV, CST, MRP, BOM, WIP, OM, Pricing, WSH, AP, AR, GL, PO and Workflow), Oracle Forms6i/ Reports 6i, TOAD, SQL*Loader, PL/SQL, AIX,XML Publisher.

Confidential, Nov 05 – Aug 07
Oracle Techno-Functional Consultant

Responsibilities:

• Imported Sales orders using Order import API’s
• Automated the Pick Release and Ship Confirm Process.
• Customized the transact Move Orders Form to facilitate users to find move order lines using delivery number.
• Customized the Sales Order Form - Additional Information on lots shipped against a sales order line.
• Customized the Shipping transactions form - Modified to query the transactions based on delivery number as default.
• Developed Custom Defaulting Rules, Dependencies and Processing constraints for Order Header and Lines.
• Developed a PL/SQL procedure to add inventory parts to Distribution, OEM and samples price lists.
• Developed reports for Backlog, Shipping log, Booked Orders, Outstanding RMAs, Open Picks, Delinquent Backlog, Commercial Invoice report, Inventory value report, Daily Ship log report (Shipment Analysis)
• Involved in setting up Outside Processing as part of WIP.
• Written interface scripts for importing part numbers from legacy systems to Oracle inventory. Helped users in setting up reports using Discoverer.
• Written scripts for automating inventory transactions viz., miscellaneous issue, miscellaneous receipt and sub inventory transfers
• Written conversion scripts to import lot numbers, and on hand quantities
• Written scripts to create a snapshot of on hand, WIP and in transit quantities

Environment: Oracle Applications 11.0.9 (OM, INV, WSH, WIP, Pricing,), Oracle 8i, Forms/Reports 6i, PL/SQL, SQL*Loader, SQLNAV and Shell scripting, Discoverer.

Confidential, Jun 04 – Sep 05 
Oracle Techno-Functional Consultant 
Responsibilities:

• Played a key Techno-Functional role with finance systems group of the company. Developed and supported multiple interfaces involving data transfer from different third party vendors into payables, receivables and general ledger modules of oracle ERP.
• Involved in Developing/changing Shell Scripts to copy/move/rename data files from/to source/destination folders.
• Created packages to process data and import into gl_interface tables.
• Developed multiple custom reports to display processed invoice data showing division/location based counts and total amounts.
• Performed Report Tuning by utilizing SQL_TRACE and TKPROF utility in UNIX. Using this utility, we could improve the performance of the Reports by either creating new INDEXES or dropping existing ones and also removing any joins that would degrade performance by creating formula columns.
• Developed error reports to display rejected data which could not be processed.
• Used oracle built in programs such as payables open interface, auto invoice and journal import.
• Defined Concurrent Program Executables, Concurrent Programs and attached the Concurrent Programs to the respective Request Groups.
• Involved in documenting the scope for the division consolidation plan to support the New A&P, Food Basics, Food Emporium, Sav-A-Center, and Liquor Divisions.
• Developed a custom Supplier Payment History Report, to review the Payment history based on the Supplier name and Supplier type.
• Developed conversion scripts to import items, item categories, and item costs.
• Imported open sales orders from legacy system.

Environment: Oracle Applications 11.0.3 (AR, AP, PO, GL, OM, INV, Workflow, Sys Admin, AOL), Oracle 8i, Forms 4.5 and Reports 2.5, PL/SQL, SQL*Loader and UNIX

Confidential,Nov 02 – May 04
Oracle Technical Analyst/Developer

Responsibilities:

• Defined Descriptive flex fields necessary for report and form customizations, and distribution sets and bank related information, defined accounting rules for recognition of revenue with respect to service and maintenance contracts in Accounts Payables.
• Designed and developed complete Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Modified the Reports like Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports, Pick Slip/Pack Slip reports.
• Imported Customers and addresses using Customer Interface.
• Worked on Auto Invoice and Receipts workbench.
• Developed SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface (OE) programs to support the interface requirements.
• Extensively utilized AOL to register SQL * Loader programs, Shell Scripts, PL/SQL Procedures, Forms and Reports. In addition, also used the System Administrator responsibility to create users, Responsibilities, Values sets and Request Sets.
• Developed package for validating shipment lines and call Ship Now package proceed to next level of the shipment process. This Package is used for the Auto Ship confirm Process.
• Developed End of Day Shipments Report to query shipments.
• Maintained all the work done using PVCS. Also documented the work by creating various reference manuals for future testers and users.

Environment: Oracle Applications 11.0.3 (AR, AP, PO, OM, WSH, INV, Sys Admin, AOL), Oracle 8i, Forms 4.5 and Reports 2.5, PL/SQL, SQL*Loader, Windows NT, PVCS and UNIX

Education:
BS in Engineering