CAREER HISTORY
Dennis Charles Walker
2514 SE 113th Court B.Sc. ( Distinction Mathematics )
Vancouver
WA 98664
Phone : (360) 256-1896 Home
(360) 256-1905 Work
Marital status : Married, no children
PROFILE
A SD consultant with functional and technical expertise. I have 19 years SAP and 27 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 19 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. I have been involved with the following :
› Nostradamus Project
Consolidated the ‘delivers by’ date calculations to a single tool which uses origin, destination, shipping conditions, carrier and product information to calculate an accurate number of transit days and the associated delivers by dates.
· Analysis, co-design and programming of the ‘Delivers by Date’ Forecasting functionality i.e.
Delivers by dates determined and displayed to the customer whilst browsing and at check out
on the Online Store.
Apple’s ‘delivers by date ‘ range was very broad. The forecasted transit days had to be
reduced from a range to a single value based on origin, destination, shipping conditions,
carrier and product information.
The requirements were complex, the project was global and performance/response time was
critical.
· Analysis, design and programming of the ‘Sales Order Userexit’ changes required to
determine the ‘delivers by dates’ for manually created orders/order changes.
.
· Analysis, design and programming of the ‘Customer Commit Simulator’, a tool which
enabled the business to analyze how the ‘Ships by’ and ‘Delivers by’ dates were determined.
› Campaign Management SAP CRM
· Analysis, design and programming of the ‘Dependency Discounts’ functionality e.g.
Generate a discount when buying both Product A and Product B
· Analysis, design and programming of the ‘Deal Closer’ functionality which determined
the permissible percentage/dollar value available for offer by telesales agents.
· Analysis, design and programming of the R3 ‘Campaign Redetermination’ functionality
which called CRM to re-determine and re-apply the campaign value upon specific order
changes.
› Extended Block project
· Co-designed the functional and technical aspects of the ‘Extended Block’ functionality
which allowed the business to place an order on delivery block based on the value of a
specific field on the order e.g. Block all orders with a specific product .
· Programmed the following :
- Sales order userexit changes to identify orders to be placed on ‘Extended Block’
- GEM ( General Exception Management ) changes to capture the ‘Extended Block’
order in GEM thereby taking advantage of GEM workflow and functionality
› Postal project
· Designed configurable postal eligibility rules ( functional and technical ) which allowed the
business to identify 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 standard’
shipping conditions
- Performance of the Web -> SAP ‘Check out’ RFC was critical so changes had to be
simple and efficient yet meet complex requirements.
· Analysis and 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
- Save_document_prepare’ delivery userexit changed to identify and monitor any
manually changed deliveries which resulted in a delivery being changed from
ineligible for postal to eligible for postal.
› Optimal Delivery Qty ( ODQ ) project
· Designed and created the 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
› 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 resulted in drastically reduced run times,
› Gift Wrap project
· Analysis, design and programming of Gift wrap + box determination
· Analysis, design and programming of Gift wrap validation ( userexit )
· Analysis, design and programming of Credit Card authorization split based on gift wrapping
· Analysis, design and programming of the Gift Wrap Simulator
Ÿ Click 2 Delivery project
· Enhanced the custom customer commit system to determine delivery dates based on customer, plant, shipping point and shipping conditions
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 :
› Global Exception Management ( GEM ) project
Apple required the ability to identify, capture, assign and resolve ‘exceptions’ i.e Suspected fraud orders, incomplete orders and orders on delivery block. I was responsible for the analysis, design and programming of the following :
· Exception Identification
· Exception Assignment ( Automatic and Manual )
· Exception 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.
› Customer Commitment project
The ‘Ships by’ dates displayed to the customer on the Web was previously calculated outside of
SAP. The Customer Commitment project involved making SAP the system of record for
‘customer commitment quotes’. I was responsible for the analysis, design and programming of
the following :
· Developed RFC ( called from Web ) to determine and return ‘Ships by’ dates ( Customer commitment quotes )
· Modifide sales order uesrexits to capture and maintain ‘customer commitment quotes’, allowing for multiple ‘quotes’ per line item.
· Modified userexits to automatically generate ‘customer commitment quotes’ for non-Web orders
· Generated ‘Re-quotes’ as per FTC requirements and communicated ‘Re-quotes’ to the customer ( via e-mail )
· ‘Quote Tool’ to SAP interface
· New reports and report changes to display and manage the customer commitment data.
Ÿ Coupon functionality
I was responsible for the analysis, design and programming of the following :
· 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 1st 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
š ITS, developed the following transactions for the ITS project ( Australia )
· Sales order enquiry
· Delivery enquiry
· Credit enquiry
˜ Inter-company sales ( Canada )
· 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
™ 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.
™ Other Development
I was responsible for the analysis, design and programming of the following :
· Mass Order Change ( Header ) utility
· Mass CTO change 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
ÿ Mass Change Utilities
· 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 )
› 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
-
Other Development
· 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
ÿ Pricing
· Pricing procedures for Standard orders, Apple own use,
Employee sales and Demo orders
· Development and coding of pricing ‘requirements’ and ‘formulas’.
ÿ Pricing and other Tools
· 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
· Create Accounting document
· Developing new and changing existing matchcodes
Charlotte Pipe and Steel (North Carolina) Mar 95 – July 95
Specific responsibilities on this assignment included:
· Configuration of SD test area
· Design of SD high level structures, i.e., sales
organization to sales office
· Investigation of client's pricing, rebate and shipping requirements sales and distribution implementation
· Modification of SAP code to use the reference
distribution channel for the material master only
Engen Petroleum Limited (Cape Town, South Africa, formerly Mobil
Oil ), one of the country’s major oil companies, implemented all modules of R/2.
Specific responsibilities included:
ÿ Volume based rebates - Design and development of a system
to meet the specific requirements of volume based rebates.
· Modification of SAP code
· Conversion of existing rebates
· Design and development of a complex on-line inquiry
· Payment and exception reports
· Remittance advice
· Development of training manuals
· All user training
ÿ Engen Diesel Club - Engen’s credit card system, replaced the
existing card system. Involved :
· Interfacing to pricing, customer and material masters
· Conversion of existing transaction and master data
· Implementation of an early warning system
· Monthly reports
ÿ EDI Creation of a rail tank car dispatch program as part of
Engen’s total EDI effort, that allowed the company to inform a customer and
the rail company when a rail tank car had been sent to one of their plants