SUMMARY:

Confidential has over twenty two years of strong IT experience; this includes fifteen years as a techno - functional consultant. His expertise includes eight full life cycle implementations, design, migration and testing of applications involving Oracle Applications R12/11i/ 11.0.3/10.7 Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL), Order Management (OM), EDI/E-commerce Gateway, Inventory, WIP, Workflow, Purchasing (PO), Oracle Quality and Oracle Approvals Management (AME) modules. He has extensive functional experience in requirement analysis, design, development, testing, and implementation and production support of various Oracle Application Modules. Confidential has extensive experience in development of Concurrent Programs, GAP analysis, Customization of forms, reports, workflow and stored procedures.

MANAGEMENT SKILLS:

• Change Management
• Business Process Analysis
• System Design
• Upgrade and Implementation Strategies
• Project Management
• Testing Coordination
• Production Transition
• Production Support

FUNCTIONAL SKILLS:

• Oracle General Ledger
• Oracle Payables
• Oracle Receivables
• Oracle Order Management
• Oracle Purchasing
• Oracle Inventory
• Depot Repair
• Oracle iExpense
• Oracle Ecommerce-Gateway

TECHNICAL SKILLS:

Oracle Workflow

Oracle Applications Framework

SQL/SQL*Plus

SQL Loader

PL/SQL

JDeveloper

Workflow Builder

Workflow Setup and Administration

Reports, Discoverer

BI Publisher (formerly XML Publisher)

Oracle Approval Management (AME)

PROFESSIONAL EXPERIENCE;

Oracle Tech Support

Confidential, Cary, NC

Environment: Oracle EBS R12, Custom applications.

Responsibilities:

• Tech Support to EBS and custom applications.

Oracle EBS

Confidential

Environment: Oracle EBS 11i, PL/SQL

Responsibilities:

• Data extracts from 11i for the migration to NetSuite.
• Items, Open POs, Open AP Invoices, Fixed assets, GL balances and entries, Vendors extracts

Oracle EBS

Confidential, Castle Rock, CO

Environment: Oracle EBS R12.2.7, SQL, PL/SQL, SQL*Loader, BI Publisher.

Responsibilities:

• Conversion of SOLARAY’s legacy master data to R12: Customers (Master, contacts, relationships), price lists. Suppliers, Employees, Salesreps from Solaray’s NetSuite to R12.
• Developed programs/API’s to update/create
• Items, Item categories and assignments, approved supplier list assignment, UOM conversion assignment, Cross reference assignment, Price lists, Supplier payment methods, Item attribute updates including planning, order modifiers, Attributes updates on customer/customer sites, pricelists, Customer profile creation and updates, customer bank and receipt method interfaces, creation of customer contacts and assignment.
• Examined and modified reports to make them OU and INV org specific so they do not break after PUGS conversion. Modified Customer statement report. Created payment file report for JP Morgan check processing.

Oracle EBS

Confidential, Castle Rock, CO

Environment: Oracle EBS R12.2.7, 11i, SQL, PL/SQL, Order Management, Receivables, EDI, Shell scripts, SQL*Loader, Oracle reports, BI publisher

Responsibilities:

• Migration/conversion from 11i to R12.
• Migration of EDI OM orders (850), Point of Sales Data (852), outbound 810, 856 and refine EDI related processes.
• Conversion of Customers (Customer, addresses, contacts, relationships), price lists. Suppliers (vendor, sites, contacts), Employees (employee, assignments, assignment criteria), Salesreps (reps, roles, territories) for PUGS 11i to R12 using Interface tables and APIs.

Oracle EBS

Confidential

Environment: Oracle EBS R12 SQL, PL/SQL, AME, iExpense

Responsibilities:

• Approval list customization for iExpense.

Oracle EBS

Confidential

Environment: Oracle EBS R12 SQL, PL/SQL, Order Management

Responsibilities:

• Develop customer specific ASN in XML format. ASN will be generated as soon as delivery is confirmed for the set of customers in XML format.

Oracle EBS

Confidential

Environment: Oracle EBS 11i, SQL, PL/SQL, E-Commerce Gateway, Order Management, Purchasing, Inventory, Legacy OM

Responsibilities:

• Requirement gathering, development, testing and production support.
• Created implementation guidelines/spec for inbound 850, 856, 943, 944, 947 and outbound 850, 940.
• Created X12 to oracle EBS FF mappings for inbound 850/856 and outbound 850 using Transaction layout definitions.
• Created layout/mapping for transactions that are not interfaced thru oracle E - commerce gateway.
• Trading partner, Customer/supplier/Location EDI location, Code conversion setup.
• Worked with Confidential s core EDI team and GXS EDI mapping team for translation maps. Worked with Ingram Micro(3PL) team for mapping and requirements.
• Created sample test files manually for initial testing and requirement analysis using Transaction layout definitions for 850/856 and 810.
• Worked with onsite and offshore development teams for the customization(s) required for the project.

Oracle EBS

Confidential

Environment: Oracle EBS R12, SQL, PL/SQL, Oracle Projects General Ledger, Purchasing

Responsibilities:

• Developed Project accounting to NMDW (New Mexico Data warehouse) feed.
• Developed GL to NMDW feed. Developed PO and supplier conversion programs.

Oracle EBS

Confidential

Environment: Oracle EBS R12, SQL, PL/SQL, BI Publisher, Order Management, Pricing, Receivables

Responsibilities:

• Developed Costing interface to Demantra. Custom Order confirmation program, custom Invoice program, contract pricing using QP CUSTOM package and Pricing attribute functions.

Oracle EBS

Confidential

Environment: Oracle EBS R12, SQL, PL/SQL, Oracle Forms.

Responsibilities:

• Technical support, enhancement.
• Modified and maintained complex custom invoicing system, Changed Load process to handle multiline invoices after Salesforce integration to Oracle.
• Changed custom invoicing system to hold future dated invoices.
• Bug fixes and stabilization of orders load process.

Oracle EBS

Confidential

Environment: Oracle EBS R12, SQL, PL/SQL, Oracle Reports, BI Publisher, Payables, Purchasing

Responsibilities:

• Modified check printing program to change format.
• Developed Invoice register report.
• Requisition approval workflow changes.
• Custom PO mass close and reconciliation program changes.
• Credit card reconciliation program changes.
• AP/PO Accrual write off utility changes.

Oracle EBS R12

Confidential, TX

Environment: Oracle EBS R12, SQL, PL/SQL, Oracle Reports, BI Publisher, Workflow, JDeveloper, Receivables, Depot Repair, Order Management, WIP, Inventory, HRMS

Responsibilities:

• Developed Depot repair and field service pre bills, receivable invoices, warranty only invoice, Discount report, Branch Q report for field services billing.
• Form personalization of OM order, Depot repair order forms.
• Modified expenses workflow, interfaced job related expenses to WIP for iExpense implementation of UE OUs.
• Modified Depot repair hook to default DFF to OM orders.
• Developed preprocessor to modify receivables invoices data. Developed Item price update program.
• Developed custom credit check functionality in Depot repair using form personalization, workflow, and business events.
• Developed employee interface between Ceridian and Oracle.
• Customization of Technician portal using JDeveloper.
• Bug fixes and production support.

Oracle EBS

Confidential, Manitowoc, WI

Environment: Oracle EBS R12, SQL, PL/SQL, Inventory, Order Management, Receivables, Payables

Responsibilities:

• Developed Material alias transactions, Customer item XREF, Sales order credit release and Last price paid interfaces between Oracle and SAP.
• Developed PO and AP reconciliation report.

Oracle EBS 11i Tech support

Confidential, TX

Environment: Oracle EBS 11i, SQL, PL/SQL, Workflow, Purchasing

Responsibilities:

• Modified ‘PO Create Documents’ workflow to populate descriptions and ‘Ship To’ locations from requisition to Purchase order.
• Modified ‘PO Approval’ workflow to add notification to requester after PO is approved.
• Modified ‘PO Account Generator’ and ‘Requisition Account Generator’ workflows to generate custom expense charge account.
• Design, coding and implementation of special ordering involving 850’s with SDQ segment, Distribution center consolidation, store-wise delivery, multiple deliveries but single invoice requirements.
• Customer setup and E-commerce gateway setups.

Oracle EBS R12 Tech Support

Confidential, Schaumburg, IL

Environment: Oracle EBS R12, SQL, PL/SQL, BI/XML Publisher, Order Management, Contracts, Receivables, HRMS

Responsibilities:

• Modification of views used for Hyperion reports and custom reports. Develop reports using BI/XML publisher

Oracle EBS 11i to R12 Conversion

Confidential, Branchburg, NJ

Environment: Oracle EBS 11i and R12(OPM), SQL, PL/SQL

Responsibilities:

• Data conversion from 11i to R12: Source data extraction, validations, target data extraction and validations, coordination with offshore development team, cutover planning
• Conversion objects: Items, Item categories, employees, suppliers, customers, price lists, customer attachments, sales order history, AR open invoices, Lot master, On-Hand quantities, Donor suitability(quality samples) and attachments, lot quality results(quality samples), Routings, Operations, Formulas, Recipes, Process Instructions