SUMMARY

Results orientated Oracle Applications Techno - Functional Developer and Development Lead with over 15 years of increasing consulting responsibilities with integrated Global Oracle ERP systems. Experience is industrial and distribution centric spanning several industries including printing, package delivery, chemical, construction, discrete and process manufacturing and metals.

TECHNICAL SKILLS

• Applications: Oracle Applications V10.7, V11.0, 11I, Ross Financial Accounts Payable and General Ledger,
• Database Products: Oracle V7.0, V7.1, V7.3, and V8.0, V8i, V9i, 10g,
• Database Tools: Oracle*Forms V4.5, V6.0, SQL*PLUS, TOAD, SQL Navigator, Oracle Reports V2.5,V6.0,V6I, SQL*REPEORTWRITER, SQL*Loader, Crystal Reports,
• Languages: SQL, PL/SQL, DCL, UNIX (AIX), SHELL SCRIPTING, COBOL, PRO COBOL,
• Network Products: PC/TCP, DEC NET, SQL NET V1 AND V2, ODBC,
• Operating Systems: VMS, UNIX(AIX), Novell NetWare, Windows 95, Windows 98, Windows 2000,Windows NT,
• Hardware: UNIX SUN SOLARIS, IBM RS600, DEC UNIX, VAX 3900, VAX 10000,

PROFESSIONAL EXPERIENCE

Oracle Applications - Technical,

Confidential, Athens, Ohio,

Responsibilities:

• Upgrade of Chart of Accounts project
• Remediated custom objects addressing changes for COA assignments.
• Developed multiple conversions for pay cost allocation keyflex, per people extra info and hr positions.
• Developed install scripts for database, fndload and server side objects.
• Financial modules: Payables, General Ledger, Receivables, Cash Management, HR module.

Multiple Clients

Confidential,

Responsibilities:

• Developed enhancements to existing custom interfaces.
• Provided quidance to junior developers.
• Developed multiple BI publisher reports for Property Manager, Service contracts and Financial modules.
• Developed and implemented a custom process to end date suppliers based on activity against invoices and purchase orders.
• Financial modules: Payables and Receivables.

Senior Oracle Applications - Technical

Confidential, Miami, Fl.

Responsibilities:

• Duties includes the remediation and testing of existing CEMLI objects to R12 functionality
• Implemented R12 payable check utilizing advanced BI publisher techniques.
• Provided guidance to other developers in the use of BI publisher data templates and other technical aspects.
• Conducted design meetings for custom initiatives.
• Financial modules: Payables, General Ledger and Payments module

Senior Oracle Applications - Technical

Confidential, Naperville, Il

Responsibilities:

• Served as a technical lead for an r12 upgrade. Duties include managing the CEMLI’s upgrade and other custom initiatives including:
• Design and development of a custom XML publisher payroll check
• Provided guidance to other technical resources for the development of custom payable checks.
• Design and implement CEMLI migration scripts including FNDLOAD object installation
• Manage work load distribution.
• Meeting with end users to finalize custom requirements
• Participated in r12 implementation performing a number of technical activities.
• Conversions for Customers and AR invoices.
• BI publisher purchase order templates for two business units.
• Custom Oracle forms for client crosswalk applications. Included forms personalization for the dynamic creation of LOV’s.
• Assisted DBA with the FNDLOAD utility for the purposes of migrating printer definitions.
• Led knowledge transfer sessions with the client technical team.
• Performed production support developing multiple BI publisher reports addressing performance related issues and any ad-hoc requests.
• Testing and migration of CEMLI objects from the 11.5.10 environment to R12 environment. Including the design and development of migration scripts and the testing of all database and server side objects.
• Modules: Payables, General Ledger, Payments, Receivables, Purchasing, Order Management and Manufacturing. Also HR / Payroll modules.

Senior Oracle Applications - Technical,

Confidential,Tampa, Fl,

• Migrating Oracle reports, PLSQL, HOST and SQLLDR processes from 11.5.10 environment to R12 environment.
• Extensive performance tuning on existing processes invoking parallelism address and resolving tuning issues.
• Designing and developing automated migration process utilizing a series of shell and sql scripts.
• Serving as a mentor to a number of team members regarding R12 migration issues.
• Designed and developed outbound interface utilizing XML publisher functionality with ETEXT template, data template and bursting control file.
• Financial modules: Payables, General Ledger, Cash Management and Payments

Senior Oracle Applications

Confidential, El Paso, Tx.

Responsibilities:

• Developed multiple Bi Publisher reports for sales analysis utilizing BI Publisher Enterprise edition.
• Designed and developed materialized views for data warehouse reporting applications.
• Served as performance turning resource assisting other developers with performance tuning techniques.
• Designed and developed Oracle applications to data warehouse profitability reporting process.
• Modules: Trade Management, Payables

Senior Oracle BI Developer,

Jacksonville, Fl.

Responsibilities:

• Implementing Oracle R12 Payables, Cash Management and Fixed Assets
• Performing conversion of existing legacy data into Oracle utilizing standard API's, interface table and import processes.
• Design, development and implementation of 37 BI publisher payment check templates.
• Assisted in the implementation of BAI file import and EDI 820 export for payment manager implementation.
• Developed forms personalization for implementation of Oracle PMI for invoice image access and viewing.
• Performed functional setups in Payments module for onsite check printing.
• Financial Modules: Payables, General Ledger, Purchasing and Payments

Senior Oracle BI Developer

Confidential, Vienna, Va.

Responsibilities:

• Designed and developing Materialized views for non real time reporting applications
• Assisted DBA team in performance tuning enhancements. Duties including the analyzing of sql statements, evaluating query costing and recommending tuning enhancements.
• Developed multiple XML / BI publisher reports utilizing data template developmental methodology 10g .
• Designed and developed automated materialized view refresh process utilizing KORN shell and PLSQL functionality.