CAREER HISTORY

Dennis Charles Walker

2514 SE 113^th Court B.Sc. ( Distinction Mathematics )

Vancouver

WA 98664

Phone : (360) 256-1896 Home

(360) 256-1905 Work

(408) 974-1151 Work

Marital status : Married, no children

PROFILE

A SD consultant with functional and technical expertise. I have 15 years SAP and 23 years Information

Systems experience. I have the ability to resolve complex configuration issues, modify SAP code and

produce quality reports and dialog programs in a very short time frame.

I have extensive experience in pricing, rebates, userexits, dialog programming, function modules and reports.

For the past 15 years I have worked on SAP implementations in the United States and South Africa. I

am totally committed to quality and well suited to analysis, design and development work.

Employment Resume : Clients

Apple Computer 2005-present SD Functional /Technical analyst

Malden Corp. 1999-2004 SD Functional /Technical consultant Apple, Kodak

Softline 1997-99 SD Functional /Technical consultant Kodak

Setac(KPMG) 1995 - 97 SD Functional / Technical consultant Apple, Filenet

Engen SA 1992-95 Business Analyst R/2 project

(ex Mobil) 1991-92 Projects manager

Jaguar Cars UK 1990-91 Contract analyst programmer

Engen SA 1984-90 Project leader from trainee programmer

(ex Mobil)

Teaching 1981-83 Mathematics teacher

Engen SA 1979-81 Sales Representative

(ex Mobil)

Teaching 1978 Mathematics teacher

SAP EXPERIENCE

Apple Computers Jan 05 – Present

I joined Apple as a full time employee in Jan 05. Since then I have been involved with :

› Analysis, design and development ( coding ) of the ‘Postal’ project

· Designed and created the postal eligibility tables which allowed the business to identify the customers and materials eligible for ‘postal’ delivery.

· Designed and changed the Web -> SAP ‘Check out’ RFC to :

· Determine postal eligibility

· Accurately determine the plant ( Std SAP + complex non-standard plant determination )

· Determine shipping and arrival dates based on new ‘postal’ and ‘chargeable std’ shipping conditions

· Performance of the Web -> SAP ‘Check out’ RFC is critical, changes had to be simple, efficient yet meet complex requirements.

· Analysis and applied changes to the sales order userexit, idoc userexit , delivery data

transfer routine and delivery userexit :

· ‘Save_document_prepare’ sales order userexit changed to determine postal eligibility for manually added items or when copying a quotation to an order.

· Postal eligibility fields added to sales order and delivery header and item tables plus the associated idoc and additional data B screen changes

· Delivery data transfer routine changed to re-determine postal eligibility at delivery time and modify the shipping conditions accordingly

› Analysis, design and development ( coding ) of the ‘ODQ’ ( Optimal Delivery Qty ) project

· Designed and created ODQ tables which allowed the business to identify the customer and material combinations which forced the customer to order product in

multiples of the optimum delivery quantity.

· Designed and developed a new RFC called by the Web to display materials and the associated optimum delivery quantities. Performance of the RFC was critical.

· Designed and made the following changes :

· Validation added to the sales order userexit to ensure that the order qty was a multiple of the ODQ

· Changed the delivery copy requirement to ensure that the delivery qty was in a multiple of the ODQ

· Mass change utility which allowed the business to override existing ODQs

· Created and maintained an ODQ log table which tracked any ODQ applied to an item from creation through to delivery – all changes made via sales order and

delivery userexits

· Designed and developed an ODQ log report Determine postal eligibility

› Analysis, design and development ( coding ) of the ‘Global Price Feed’ project

· Replaced 7 existing pricing interfaces with a single global price feed program.

· Custom tables control the addition of a new interface allowing new price feeds to be

created up without any program changes.

· Performance of the global price feed, approximately 1000 items per minute, resulted in drastically reduce run times,

› Analysis, design and development ( coding ) of the ‘Gift Wrap’ project

· Gift wrap + box determination

· Gift wrap validation ( userexit )

· Credit Card authorization split based on gift wrapping

· Gift Wrap Simulator

› Analysis, design, configuration and development of ‘Click 2 Delivery’ functionality

· Requirements were complex and involved enhancing the customer commit system to determine of 4 new ‘delivers by’ dates

· Performance was critical as all customer commit dates are determined and displayed at check out time

· Modified Idoc and sales order userexits/screens to allow for the additional dates

· Modified existing customer commit utilities ( e.g. Requote ) to determine the additional dates

Apple Computers Jan 00 – Dec 04

I returned to Apple at the beginning of 2000 and have been involved with the implementation of

the following :

› Analysis, design and development ( coding ) of the ‘Global Exception Management’ project which involved :

· Exception Identification

· Automatic assignment

· Manual assignment

· Resolution

· Reporting

The requirements were complex, none of which could be met with standard SAP. The solution was complex but very flexible and involved extensive changes to the sales order userexits, 4 complex dialog programs, 8 reports, 3 ‘Mass Change’ utilities and 2 conversion programs.

› Analysis, design and development ( coding ) of the ‘Customer Commitment’ project

· Modify sales order uesrexits to capture and maintain ‘customer commitment quotes’, allowing for multiple ‘quotes’ per line item.

· Modify userexits to automatically generate ‘quotes’ for non-Web orders

· Generate ‘Re-quotes’ as per FTC requirements and communicate ‘Re-quotes’ to the customer ( via e-mail )

· 2 interfaces, one from the ‘Quote Tool’ to SAP, the other from SAP to the Web

· New reports and report changes to display and manage the customer commitment data.

· Global project, implemented in Europe and USA.

› Analysis, design, configuration and development ( coding ) of ‘Coupon’ functionality

· Changed US pricing procedure and other pricing configuration

· Changed 6 customer and 3 internal outputs to identify and display promotion savings

· Coding of all userexits, pricing formulas and requirements needed to transfer a

condition value from the Sales BOM header to the 1^st component of the BOM

· Extended Web to SAP Idoc and modified idoc userexits

· Added coupon data to the Sales ‘Additional Data’ screen via the userexit

· New report identifying ‘promotion savings’ by promotion program and employee

› Web to SAP ‘Order Status’ RFC

· Rewrote the existing Order Status RFC so that :

· Code was more efficient. The RFC is called hundreds of thousands of times per day, performance was critical

· RFC could be called by multiple applications, not only the Web

· To determine and return ‘On line self service’ status

› ITS, developed the following transactions for the ITS project ( Australia )

· Sales order enquiry

· Delivery enquiry

· Credit enquiry

›Analysis, design, configuration and development ( coding ) of Canada Inter-company sales

· Changed Canadian pricing procedure and other pricing configuration

· Coding of new pricing formulas and requirements needed to calculate ‘cost + uplift’

for inter-company sales

· Added new account determination tables, new ‘account determination’ fields and the

related userexit changes

› Analysis, design, configuration and development ( coding ) of the Web incentive discount

· Changed US pricing procedure and other pricing configuration

· Pricing formulas required to store Web incentive discount and apply to CTO options

· Interface program to pass web incentive discount percentages and the related materials to the Web.

› Analysis, design and development of the complex Mass CTO conversion utility.

· Multi step approach provided the business with maximum flexibility

· Utility provides the ability to convert selected CTO items with a specific configuration to an item ( same or different material )

with different configuration

· Utility replaced a manual procedure which was labor intensive and subject to numerous errors

· Utility is used extensively and has saved a lot of time, manual effort and the associated manpower

› Other Development - Analysis, design and development of the following :

· Mass Order Change ( Header ) utility

· Mass order item cancellation utility

· Revenue recognition reconciliation report

· Mass RMA ( returns ) cancellation utility

· Extensive changes to the Apple Order Inquiry

· Good Issue vs Invoice COGS comparison report

· Changed credit card userexit to prevent credit card authorization for

‘ship complete’ orders where not all the product is available

· Pricing determination and download interface

· Program changes required for 4.5 upgrade

Kodak ( New York ) US implementation Sept 97 - Dec 99

› Responsible for the analysis, design and development (coding) of the following on-line transactions :

· Mass Order Change

· Mass Order Creation

· Mass Manual Payment ( Rebates )

· Manual Accrual reversal ( Rebates )

· Single Manual payment ( Rebates )

· Mass Status change ( Rebates )

· Mass payment and accrual upload ( Rebates )

› Responsible for the analysis, design and configuration of Sales BOM pricing

· Modified pricing userexits and created formulas and requirements to do the following

· Prices could be set at the header level but priced at the component level

· Posted cost and revenue at the component level but inventory was at the header level.

· Display a pricing ‘Pop-up’ window which contained the prices of all items

· Applied percentage discounts to the unit price

· Modified sales order and delivery userexits to

· Prevent the component from being deleted without the header

· Protected the component quantity

· Ensure that the delivery group and reject reason of the component matched that of the header

· Ensure that the header quantity/component quantity ratio on the delivery matched that on the sales order

 Responsible for the analysis, design and development ( coding ) of the following :

· Custom delivery due list

· Pricing Simulator

· Rebate Simulator

· Rebate Remittance Advice

· Rebate Program summary by program id , recipient and product

· Special Rebate simulator

· Special Rebate remittance advice

· Dealer Performance report

· Agents Commissions report

· Rebate Realignment report

· Rebate change history report

· Rebate Payment Register

· Customers for a partner report

· Materials by Pac1/Pac2/Pac23

 Responsible for the technical analysis and development ( coding ) of the following

· Account history analysis ( FI - credit )

Apple Computers ( California ) - Canadian implementation July 96 - Aug 97

ÿ Responsible for the analysis, design and configuration of pricing

· Pricing procedures for Standard orders, Apple own use,

Employee sales and Demo orders

· Development and coding of pricing ‘requirements’ and ‘formulas’.

ÿ Responsible for the analysis, design and development ( coding ) of :

· A pricing simulator

· A ‘rounding’ technique which priced at the component level but rounded

at the header level.

· Mass Repricing, a process, which under certain conditions, repriced individual line items.

· Promotion report

· Sales Order Inquiry

· Material Availability report

· Price Override report

· Open deliveries and Revenue report

· Unproportional BOM shipments report

ÿ Modification of order entry, delivery, invoice and EDI user-exits to :

· Maintain custom tables which provided an efficient means of selecting

open orders ( Apple definition ), price overrides and sales orders via the

sales deal number.

· Display a pricing ‘pop-up’ window which contained all header and

component prices.

· Conditionally overwrite IDOC component data with that of the bundle

Filenet ( California ) - Aug 95 – June 96

Assisted in the implementation of SAP R/3, including modules FI, CO, GLX,

AM, PP, MM and SD. Specific responsibilities included:

Ž Specifying and developing reports for Sales and distribution, financials

and materials management

· Sales order history

· Net Sales analysis

· Sales Order register

· Invoice register

· Revenue and cost analysis

· Forecasted revenue by product hierarchy

· Open sales orders and quotes

· Forecasted demand Vs supply

· Pricing, BOM and material exception reports

· Sales order changes and cancellations

· Shipment notification

· Shipments by order reason

· Credit Memo download

· Daily quote, sales order and shipment reports

· Customer & related partners

· Intrastat and VIES reports

Ž Management responsibilities

· Managing 2 analyst/programmers

· Developing and monitoring the ‘Reporting’

schedule

· Developing programming standards

· Conducting all code reviews

 Specifying and developing Filenet specific enhancements.

· Sales order history - design and implementation

of a system which allows the user to view

sales orders from the replaced Legacy system.

· Deleted sales orders - design and implementation

of a method of retaining the details of deleted sales

documents.

· Report distribution - design and implementation

of a facility which splits and downloads reports

to user defined directories.

Ž Resolving configuration issues, modifying user exits and technical enhancements

· Pricing

· Storage location determination

· Create Sales orders