SUMMARY:

• Over 7 years of experience in providing cost effective solutions using Oracle ERP.
• Extensive experience in defining, analyzing, designing, implementing and support for Oracle Supply Chain Management, Manufacturing and Financial modules like Accounts Payables (AP), Purchasing (PO), Order Management (OM), Inventory (INV), Accounts Receivables (AR), General Ledger (GL), Advance Pricing (QP), Costing, Shipping (WSH), Work In Process (WIP), Bills of Material (BOM), Material Resource Planning (MRP).
• Experienced in AOL concepts and System Administration
• Experience in preparing functional and technical specifications, schema documents, test cases, flow charts, production support and user support documents using AIM methodologies.
• Expertise in new implementation as well as conversions of Legacy System to Oracle Applications, RICE (Reports, Interfaces, Configuration, Enhancements) and migration.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers, and other database objects using SQL and PL/SQL and Unix Shell scripting.
• Functional implementation experience, which encompasses order fulfillment process analysis, process design, mapping & re - engineering, process gap analysis and resolution, troubleshooting and issue resolution.
• Experience in developing Interface/Conversion Programs for integrating third party applications with Oracle Applications.
• Excellent Team Player with good problem solving approach having strong inter personal, communication, leadership skills and ability to work in a time-constrained and team-oriented environment.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS:

ERP: Oracle applications SCM, Financial and Manufacturing modules like Accounts Payables (AP), Purchasing (PO), Order Management (OM), Inventory (INV), Accounts Receivables (AR), General Ledger (GL), Advance Pricing (QP), Costing, Shipping (WSH), Work In Process (WIP), Bills of Material (BOM), Material Resource Planning (MRP).

Languages: SQL, PL/SQL

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

Tools: Toad, SQL*Plus, SQL*Loader, Reports 6i/10g, Forms 6i/10g, Discoverer 4i/10g, Oracle workflow Builder 2.5/2.6, XML Publisher 2.6, AIM 3.0, Data Loader

Operating Systems: WINDOWS 10, SUN Solaris 2.5/5.6, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, New Orleans, LA

Oracle apps Functional Consultant

Responsibilities:

• Set up AP bank accounts, bank documents, bank codes, reporting entity and expense report templates.
• Worked on upgrading Oracle from 11.5.10.2 to 12.1.3 - mainly responsible for PO and AP modules.
• Created custom check payment formats for R12.
• Worked on converting all suppliers to Electronic payments and almost completely diminishing paper checks.
• Worked on developing AP Invoice interface between Siebel and Oracle to import and process all invoices.
• Worked on customizing - AP Invoice form for Mark view related attachments, AR receipts form for printing Cash window receipts.
• Conducted end-user meetings to review current business processes and requirement gathering.
• Performed on-site requirement analysis and developed functional specifications for the modules
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL * Loader and did all the necessary validations before loading into AP INVOICES INTERFACE, AP INVOICE LINES INTERFACE tables and Calling Payable Import Program.
• Loaded Legacy Journals data into interface tables and then populated the base tables of GL by running standard API.
• Developed custom Reports in GL such as Account Analysis Report, customized Trial Balance Report and Inter-Company Transaction Register Report to keep track of inter company revenues, assets, liabilities and expenses.
• Designed and Developed AR Invoice Import interface program to load AR Invoices into Oracle E Business Suite.
• Developed AP Invoice on HOLD report to check all the invoices which are on hold based on the suppliers and set of books, which helps in resolving the problems in the AP invoice hold/release process.
• Developed custom process to extract consolidated billing Customer invoices to be sent to the bank for monthly payments.

Environment: Oracle Applications 11.5.10.2, 12.1.3, Oracle Property Manager, Budgeting, Project Accounting, Grants, Fixed Assets (FA), Advance Procurement, iSupplier, SQL, PL/SQL, Oracle Workflow builder 2.6, Forms 6i, OAF, Oracle 10g, SQL*Loader, TOAD, SQL Tools, UNIX.

Oracle apps Functional Consultant

Responsibilities:

• Configured Inter-Org Transfers and IR/ISO scenarios as the case warranted for various scenarios. Configured Drop Ship and Back to Back order scenario’s for items that needed to be shipped directly to the sale locations and the warehouse
• Created sales orders, pick release and ship conformations. Defined Items, category, unit of measures, defining inventory organizations. Defined item attribute control, item type, asset item, expense item, item catalog.
• Authored a few MD-70’s and also assisted in documenting MD-50’s using AIM.
• Defined sub inventories, expense sub inventory, container, freight carriers and Shipping methods. Checking on-hand quantizes, transferring items between sub inventories, transferring Items between organizations, receiving the item in the destination organization.
• Assisted in conversion and migration tasks, preparation of Conversion tracking document, inventory planning methods (min-max, reorder-Point), ABC Analysis, cycle counting & physical inventory.
• Worked on Purchase Order workflow which included routing of Purchase orders and relieving the Purchase orders and the requisitions that are stuck in process when the Transaction processor is down.
• Managed catalog content for centralized purchasing and accessing multiple carts. Setup automatic purchase requisitions, approval routing configuration, approval hierarchy. Also created informational templates, attachment setups.
• Defined and configured customizations such as restricting a Buyer to a location, adding descriptive flex fields for a Requisitions and Purchase Orders. Customized the BPA update program by extending the standard retroactive price functionality.
• Resolved issues coming out of Post Go Live Stabilization and accommodated client's request in customizing some of the standard business processes to resolve the customization related issues in Costing. Written Functional Specifications for RICE objects tested and delivered.

Environment: Oracle Applications11i, PL/SQL, SQL Plus, Forms 4.5, Reports 6i, SQL* Loader, Workflow 2.6.3, Discoverer 4i.

Oracle apps Technical Consultant

Responsibilities:

• Involved in Customization of various Financials Modules (GL, AP, AR, PO, INV and OM). Successfully Interacted with Functional Consultants, QA team, DBA team and development teams. Developed Technical MD70 specification.
• Customized menus, added new concurrent requests, registered the custom applications, value sets etc. using System Administrator Module.
• Developed Concurrent Programs to interface Customer data from Legacy Systems to AR.
• Developed PL/SQL package to insert customer information using TCA API.
• Implemented Auto Lock Box process.
• Customized AP Check report in accordance to clients check printing stationary. Customized Report for Cash/Bank Book Report.
• Involved in implementing various business process extensions of Order-to-Cash and Procure-to-Pay cycles as per the business requirements.
• Loading Catalogs into iProcurement. Actively participated in the implementation of Punch-out.
• Workflow customizations in Purchasing Module i.e. PO Requisition Approval and PO Approval.
• Customization of Order Management Workflow for Sales Order Approval.
• Developed XML/BI Publisher reports for standard purchase order with 2-Way 3-Way- 4-Way matching, Customer aging report.
• Involved in writing the mapping and process Documents of Journal Import in GL and Invoice Interface in AP, for daily interfaces from the Legacy Mainframes System.
• Rectified the errors in the log file and loaded the data into the interface tables using SQL*Loader.
• Prepared Deployment documents for moving custom developed reports and forms from the development instance to production after code testing.

Environment: Oracle Apps Release 11i (11.5.9), Oracle Database (9i), SQL*Plus, SQL*Loader, Forms 10g, UNIX, TOAD, Discoverer 10g, Reports 10g, BI Publisher/XML Publisher, SQL DEVELOPER.

Oracle apps Techno Functional Consultant

Responsibilities:

• Team member of development team, involved in customizations of various Oracle manufacturing modules. (Management, Inventory, BOM, PO, AP and AR)
• Developed different extracts and reports related with BOM, AP, PO.AR, and INV.
• Developed PL/SQL components and used standard API’s for BOM Implosion and Explosion.
• Developed Data Extract Queries for BOM Routings and Vendor Extract to capture the miscellaneous data.
• Involved in designing and developing various reusable packages and procedures which were utilized by various programs in INV.
• Involved in the functional aspect of MRP, MPS and ASCP as part of requirement gathering.
• Worked on Miscellaneous transactions to be created through a PL/SQL package associated with a Concurrent program along with appropriate validation through SQL*Loader.
• Handled performance related issue using hints, tkprof and explain plan.
• Effectively handled System Administrator responsibility for creating Users, Responsibilities, Value Sets, Request Groups and Request Set.
• Created Stored Procedures at back-end and integrated them with front-end systems.
• Responsible for developing and customizing reports using Reports (6i) & Oracle XML Publisher generating output in the format of RTF, PDF, HTML and EXCEL as per Client requirement.

Environment: Oracle Forms, Reports, XML Publisher, PL/SQL, Shipping Execution, Drop Shipment, Internal Orders, CTO, ATO, Stored Procedures

Oracle Applications Developer

Responsibilities:

• Team member in development of an in house MRP package to integrate Material Procurement, Inventory Control, Spares Management, Preventive Maintenance Planning Module and Production Control System Projects.
• Developed various reports using Reports Builder and PLSQL: Manpower Forecast and Planning, Daily and Monthly Production, Goods Receipt Note, Inspection Report, Acceptance & Rejection Reports, Issue of Material, Material Utilization.
• Customized the ‘OM: Generate Cost of Goods Sold Account’ Workflow to generate the COGS account that meets the business requirements.
• Developed Various Reports in GL, AP and AR and customized them using XML Publisher.
• Customized existing Dunning Report and Invoice Printing Report in Accounts Receivables using XML/BI Publisher.
• Customized various reports in Order Management, Inventory and Shipping. Some of them are Pack List, Bill of Lading, Sales Acknowledgement Report, Order Holds Report, Delivery Detail Report.
• Involved in writing stored procedures in PL/SQL to validate, select, insert and update data in material procurement module. Material procurement module enables shop floor engineers to requisition and procure items involved in production and maintenance of machinery from central stores as well as from company vendors.
• Designed and developed reports in Oracle Discoverer for tracking Preventive Maintenance of machinery (pumps, motors, heat exchangers, dryers etc.) In day-to-day production activities.

Environment: Oracle Apps Release 11i (11.0.3/11.5.8 ), Oracle Database (8i/9i), SQL*Plus, SQL*Loader, Forms 10g, UNIX, TOAD, Discoverer 10g, Reports 10g, BI Publisher/XML Publisher, SQL DEVELOPER.