Oracle Manager

David C. Lane

Scottsdale, AZ

480-***-**** home

480-***-**** mobile

abmme4@r.postjobfree.com

Oracle Application Developer & Analyst

Oracle Applications Export Compliance Design Setup & Configure

Project Management

Highly motivated, result driven professional with solid experience and

success demonstrated in the implementation, design and support of Oracle E-

Business ERP Application solutions. Reputation for building strong customer

relationships, with excellent organizational and problem solving skills,

delivering complex projects on time, stimulated by fast paced environments

that require energy and dedication.

Areas of Expertise

. Order Management Advanced Pricing Shipping Inventory

Financials Depot Repair Field Service Contracts Install Base

Workflow ISupport

. SQL, PL-SQL, Forms, Reports, Triggers, Stored Procedures

. Oracle upgrades from 10.7SC, 11.5.4 through 11.5.10

. Order Management Shipping Pricing Inventory Agreements

Service

. Configure & Setup of Oracle Service CRM

. Repair Types Business Process Activity Types Service

Request Types

. Contract Templates Define Contract Categories Coverage Types

. Install Base Transaction Sub Types Installation Parameters

Instance Statuses Source Transaction Types Profile Options

. Time Based and Non Time Based Service Items

. SFM Event Manager Install Base Error Correction processing

. Design and Deploy automated interfaces from Oracle ERP to 3rd party

applications and Data Warehouse.

. Export Compliance applications

. Automating Depot Repair processing with repair outsourcing

client

. Mentoring associates.

. Finding solutions to complex problems.

. Oracle functional business knowledge, as backbone to technical

experience.

. Streamline and enhance business processes.

. Simplifying processes to reduce cost.

. Second level application Support

David Lane Page 2

Professional Background

EMERSON, Network Power Embedded Computing, Tempe, AZ 1991 - Present

Formerly MOTOROLA Computer Group (MCG)

Senior Programmer Analyst

Technical Leadership Role Communication Excellence Installation

Guidance Subject Matter Expertise Broad Industry Knowledge Project

Management

Designed and developed custom solutions, gap analysis and mapping

strategies for conversions and interfaces in support of the Oracle ERP

system in a multi-org environment.

Established standards used for naming and coding conventions used by

developers, consultants and DBA's

Project Management in SOX environment, with solid reputation for driving

quality and attention to detail making major contributions, recognition and

awards received from Emerson and several Motorola Bravo Awards for quality

and leadership

Deployment of Oracle Service modules: Configured per business

requirements. Provide subject matter expertise; completed 3 successful

upgrades, and second level support.

Automation of Depot Repair: Company outsourced all product repairs to a 3rd

party vendor (CTDI), which required a series of 9 inbound and 4 outbound

interfaces to send Service Requests, process receipt of customer product,

inventory transactions and process Shipments in Depot Repair, as well as

processing repair charges. This was one of the largest and most challenging

and successful projects completed that resulted in major cost saving to the

business.

Custom Forms: Designed and implemented two custom forms used to enhance the

Oracle shipping process. These forms are used to Pick Release and Ship

Confirm sales orders providing users additional visibility to order and

line holds, shipping notes, manage ship sets, ship early and ship complete

functionality absent in Oracle's seeded shipping transaction screen. This

resulted in major shipping cycle time improvements.

Oracle Install Base: Experience using Oracle API's to migrate customer

entitlement Data into the Oracle Install Base from other systems.

David Lane Page 3

Custom Oracle Module: Designed a custom module within Oracle to track

distributor inventory and Distributor point of sale transactions. This

Distributor Management module is used to manage inbound Point of Sale EDI

867 and EDI 844 Distributor on hand inventory transactions. Loaded credits

to Accounts Receivables for inventory sold by the Distributor per

agreement. The Distributor in turn received an EDI 849 Response

transactions based on the approval of the request for credit.

Export Compliance: As a manufacturer of controlled embedded computing

products for worldwide distribution drove the requirement for integrated

systems for the business from the beginning that resulted in the deployment

of the following solutions.

Management Dynamic's TRADE COLLABORATOR 14.0.x

Successfully designed and deployed an interface for products, customers,

orders and shipments between Management Dynamic's TRADE COLLABORATOR 14.0.x

and Oracle 11.5.10. The automated design provided functionality to apply

and release order and site use holds, as well as the ability to handle ATO

configured product in a multi-org environment. The design provides the

ability to consolidate several Oracle deliveries into a single Commercial

Invoice, as well as Internal Material transfer shipments between factories

in Mexico, Germany, Philippines and China.

Proficient with application Admin role to manage Security Settings -

Creating Groups as roles - Setting Access options on screens - User

Maintenance and Setup - Job Scheduler - Creating Events - Scheduling Events

to email alerts to users.

J.P. Morgan Chase VASTERA GLOBAL PASSPORT (EMS2000) version 6.2 - 6.9

Proficient in the areas of Export Compliance, and business processes and

logistics, providing value in the design of bi-directional interfaces for

products, customers, orders and shipments to the Vastera product. Managing

Order and Site Holds in Oracle determined by the results of Compliance

checks. Utilized Flex Fields and Item Categories to maintain item export

classification in the Oracle Item Master.

Designed regulatory reports required by the Compliance Manager. Developed

customized export documents and windows, using Vastera's internal tools,

'Document Architect', and the 'Windows Architect'. Proficient with

Internal Tools - Admin Maintenance, Data Maps, FORTE script enhancement,

Traffic Manager, Oracle ERP transaction listener.

David Lane Page 4

Technical Foundation

. Technical Leadership Role in several major projects

. ORACLE 10.0.8 Database, PL/SQL, ORACLE Applications from 10.7SC to

11.5.10, SQL-NET, Forms 6i, Oracle Workflow, Alerts, Flex fields,

Value Sets, UTL File functions, Custom Library and JDeveloper

. Oracle Modules - Order Management, Shipping, Inventory, Financials,

Depot Repair, Field Service, Contracts, Install Base, and

ISupport in a multi-org environment

. Expertise building Bi-directional interfaces with third party

applications

. Management Dynamics - Trade Collaborator 14.0.1

. Vastera Global Passport 6.x (EMS2000)

. Project Management, Technical Documentation, SOX and PMO

. UNIX, LINUX, XENIX, AIX, DOS, Windows 95/98/XP & 2000 Microsoft

Office, and Project

Education and Training

University of Missouri, Columbia BS Degree (Archaeology) 141 hours 3.0 GPA

(1969-1972)

Glendale Community College, (Electronics) 13 hours 3.8 GPA (1986-1987)

Informix 4GL - SQL, Altos Corp, San Jose (Informix) (1987)

4GEN Case Tools, Motorola MCG (4GEN) (1992)

AIX 4.1 Motorola (System Administration) (1995)

Oracle Training Center, San Jose (Oracle Manufacturing Technical

Foundation) (1998)

Oracle Training Center, Redwood Shores (Extend Oracle Applications) (1997)

Oracle Training Center, San Jose (Oracle Developer 2000 Foundation) (1997)

Oracle Training Center, San Jose (Oracle Developer 2000 Forms) (1997)

Oracle Training Center, Redwood Shores (Oracle Applications System Admin)

(1997)

Oracle Training Center, Redwood Shores (Oracle SQL and PL/SQL) (1997)

Oracle Training Center, Redwood Shores (Oracle Define Flex fields) (1997)

Oracle Training Center, Redwood Shores (Oracle Receivables) (1996)

Oracle Training Center, Redwood Shores (Oracle Order Entry) (1996)

Global Passport EMS2000 Version 5, Vastera Corp, Washington DC (System

Admin) (1997)

Oracle Training Center, Overland Park, Kansas (Oracle Java) (2004)

http://www.linkedin.com/pub/david-lane/10/146/b21

Contact this candidate