SAP Programmer/Analyst

	Doug Allard 2870 Pine Knoll Drive #300a Auburn Hills, Michigan, 48326 cellular - (816) 255-9877
	eMail: [email protected]

Experience:
- Environments
  - Assembly Manufacturing
  - Process Manufacturing
- Systems
  - 3.1h - 4.7(6.20)
- Modules
  - FI/CO,SD,MM,WM,PP,PS,PM,TR,QM,CRM
- XI/PI (Exchange Infrastructure)
  - SLD configuration with technical & business system setup
  - Software Component setup
  - 2 full implementations using File Adapter
  - User Defined Functions using JAVA
  - ccBPM using remote RFC calls to R/3
- ActiiveX
  - Remote communication to R/3 using Visual Basic & Visual Basic for Applications
  - Remote communication to R/3 using Vbscript & DHTML
- BADI's
  - Implementation & modifications using SE18 & SE19
  - Process Manufacturing
- BAPI's
  - Creation of custom RFC's to wrap BAPI calls
  - Direct remote calls to BAPI's
- IDOC's
  - Outbound 850
  - Inbound 810 with mapping
  - Creation of
- SAPSCRIPTS and SMARTFORMS

Languages:

9 years 10 years 3 years 2 years 2 years 1 year 1 year 1 year 6 months 8 years	- - - - - - - - - -	Visual Basic & VBA ABAP/4 HTML/DHTML/CSS VBScript Delphi JavaScript XI/PI XML/XSL VB.Net IBM/390, CSP, REXX, DB2/ISQL		<---<< Old School Stuff

History: TekSystems 01/2008 - Present
Senior ABAP Consultant: AM General, South Bend, Indiana
- R/3
  - MM - Purchase Requisition Report ALV showing the number of days between the creation of a purchase requisition,
    the number of days till release, and the number of days till creation of the subsequent
    item on a schedule line of a PO.
    Uses SAP business graphics function GRAPH_MATRIX_3D to display variances
  - MM - VL10BATCH Modification to user exit LV50R_VEWG15 & V50R_USEREXIT_TRANSF
    Restricts delivery creation to exclude line items within a specific product hierarchy
    when using a particular profile while running VL10BATCH
  - MM - Purchasing Forecast Report ALV displaying a cross reference of scheduled goods receipts, unpaid goods receipts and
    unpaid invoices with totals by date, vendor or document number for any given due date range
  - SD - Quotation pricing scales upload Import of Excel file that calls ME47 using a BDC session to update item pricing scales on Quotations
  - PP - Material Lead Time Analysis Report ALV showing a material's usage for a set of 5 sliding 12 month historical periods
    Also shows average usage, material on hand, material on order, safety stock & minimum stock level
    Months of Material Left is calculated and shown to alert user to forecasted future material requirements
  - PM - Functional Location Upload Import of Excel file
    Creation of functional location using function module 'BAPI_FUNCLOC_CREATE'
  - PM - Equipment Record Upload Import of Excel file
    Functional location validation by retrieval from table IFLOT
    New equipment validation by cross checking table EQKT
    Equipment record creation using function module 'BAPI_EQUI_CREATE'
    Addition of long text for equipment using function module 'SAVE_TEXT'
  - PM - Equipment BOM Upload Import of Excel file
    Equipment record existance check
    Duplicate component cross check
    BOM creation using function module 'CSAI_BOM_CREATE'
    BOM read using function module 'CSAI_BOM_READ'
    BOM component additions using function module 'CSAI_BOM_MAINTAIN
- SAPSCRIPTS and SMARTFORMS:
  - MM - Purchase Order Installation and implementation of /SMB40/MMPO_A
  - SD - Certificate of Compliance Installation and implementation of /SMB40/SDDLN_A
  - PM - PM Work Order SAPSCRIPT copy & modification of PM_COMMON
    Control program copy & modification of RIPRJT01
    Customizing setup for Work Order output type

History: TekSystems 05/2006 - 01/2008
Senior ABAP Consultant: Chrysler Corporation, Auburn Hills, Michigan
- Exchange Infrastructure (XI/PI):
  - Sales Orders (Miscellaneous) ccBPM: Complete Order to Cash implementation
    Inbound file adapter with scheduled pickup by XI
    User Defined Functions to split inbound file into multiple sets of sales orders
    Multiple simultaneous calls to custom RFC wrapper to process each set through BAPI_SALESORDER_CREATEFROMDAT2
    Continued processing using RV_INVOICE_CREATE for billing invoices and corresponding FI postings
    Export of complete document set created and all relevant BAPI messages by RFC wrapper to audit log file
    Pickup & scan of audit log with R/3 email send on errors
  - Purchase Orders (SIRIUS Satellite Radio) ccBPM: Complete Purchase to Pay implementation
    XI mappings & substitutions from inbound file to PO BAPI structures
    Calls RFC wrapper for BAPI_PO_CREATE1
    Continued processing using BAPI_INCOMINGINVOICE_CREATE for logistics invoice
    Export of complete document set created to audit log file
    Export of all returned BAPI messages to audit log file
    Pickup & scan of audit log with R/3 email send on errors
- R/3:
  - BADI - IF_EX_CTS_REQUEST_CHECK - BADI implementation of CTS_REQUEST_CHECK definition
    Does scan of transport table during transport creation to find & display
    Prerequiste transports not in Production for any workbench object
  - ALV - FI Intercompany balancing report ALV to display current days charges against an account(s)
    Color coding in ALV used to differentiate positve & negative postings
    Subtotals are displayed by material, company code and G/L account
    User drills into subtotal to execute call to FB01 which picks up various posting values using an account assignment model
    Corresponding amount offsetting the subtotals from ALV are then posted
  - EXIT_SAPLV61A_001(ZXFYTU01) - Vertex user exit Swaps pricing date from orders or debit/credit memos into tax date for back dating documents during Vertex call
  - EXIT_SAPLV60B_008(ZXVVFU08) - FI postings Addition of offsetting vendor posting during Order to Cash for intercompany transactions
    Also fills various fields based on document type, Posting key G/L account etc.
  - EXIT_SAPMM06E_017(ZXM06U42) - Purchase Orders Force override of defaulting statistical date on schedule lines with values from BAPI during purchase order creation
  - SAPMV60A(RV60B613) - Billing invoice Swap payer into partner table during invoice creation

History: Capgemini, 08/2003 - 05/2006
Senior Technical Consultant - Kansas City Service Center
- WebAS Business Server Pages:(BSP)
  - Complete HTML Product Catalog and R/3 Sales Order creation - Creation of custom table type definitions for use on WAS
    Implementation of link between WAS and backend R/3 system
    Web design of customer's product catalog
    Material data retrieval using BAPI_MATERIAL_GET_ALL
    Web design of customer's on-line ordering system
    Sales order creation using BAPI_SALESORDER_CREATEFROM_DAT2
  - Sales Order Listing by Customer/Period - custom Table Type Definition
    Retrieval from SAP/R3 Sales Tables onto BSP
    ABAP Script and DHTML for page display
- EDI:
  - Inbound Sales Orders - Upgrade to 4.7
    Correction in EXIT_SAPLVEDA_002 to set document status to EDI blocked
    Correction in EXIT_SAPLVEDA_002 to read earliest schedule line date from E2EDP03 and promote to requested delivery date at header
- ALE:
  - Intercompany Billing Documents - Modification of process codes to 4.7
    Modification of partners and logical destinations
    Creation of RFC destinations for logical systems
    User Exit ZXEDFU01 to reassign outbound/inbound partners
    User Exit LZICCF01 modification to intercompany G/L posting
    User Exit ZUSD9974 modification for invoice processing log update
    User Exit ZUSD9974 modification for IDOC status update
- Visual Basic:
  - Visual Basic SAS/70 User Identity Verification - Visual Basic application linking to all systems in workstation's saplogon.ini for User Id searches on multiple systems by UserId or first/last name.
    Allows use of wildcards in names and Id during search.
    Tested and deployed for Windows 2000 and Windows XP.
  - Visual Basic Interface to extract & compare 3.1I & 4.7 objects - Retrieved & compared the following
    - Program Source with Include expansion
    - Function Modules
    - Screen Source & Text
    - CUA Definitions
- R/3:
  - CRM - Contact Person Upload - ABAP/4 to upload excel file & call BAPI's to create contacts and create partner relationships between contacts and organizations
  - Outbound Check creation - Copy and modification of RFFOUS_C to create outbound text images of checks for input into external check printing application
  - Inbound Cashed Check posting - Copy and modification of RFECBK00 to load inbound cashed check file from bank and trigger posting and check encashment events in TR module
  - Gui version check at logon - User Exit to download sapver.exe from application server and execute on workstations at user logon to determine workstations gui version and save listing of all workstation results back onto server
  - Purchase Price Variance Report - Copy and extensive modification of transaction FBL3N
    Added coding for retrieval of purchasing information
    Created appends and data elements and added to ALV grid
  - Project Turn Time report Z_CN41 - Copy & provided specific customer enhancements to CN41 (PS)
    Additional fields added to fieldcatalog & data table for ALV
    Calculation of turn-time and total number of projects
    Addition of further ALV tree elements for report & display
  - Production Yield Report - ALV list showing total quantity, scrap, & yield%
    Based on work center/material/order number
    With removal of cancelled inspection lots from totals
  - User Profile Report - ALV grid showing UserId & assigned profile groups
    Drill down into SUIM on userid or assigned profile name
    Dynmaic ALV fieldcatalog
  - Journal Entry Error Report - ALV to display manual journal entries missing key fields
    Shows erred entries, reversals and corrected entries linked to original erred entries, color coded for debit/credit
  - Vendor Payment Report - ALV to display vendor payments by company code and account
  - BDC to Update TVARVC - Rewrite of update to selection screen variables to change from TVARV to TVARVC for 4.7 standards
  - MV50AFZ1 & SDREPA01 - User Exit to auto-create service notifications with task lists during returns of repair order items
  - MV45AFZB - User Exit to popup standard text and insert standard text into orders' header text during VA01
- SAPscripts and SMARTFORMS:
  - Billing Invoices (US/DE/DK/FR) -
  - Plant Maintenance Work Orders/Job Tickets (DK) -
  - Purchase Order/Service Agreement modifications (US) -
  - Dunning Notices (US) -
  - kanban JIT summary sheet (US) -
  - Shipping labels using Zebra Printer (US) -

History: Robert Half Technologies, 06/2002 - 12/2002
SAP Consultant: Heidelberg Web Systems - Dover, New Hampshire

EDI:

Inbound Logistics Invoices - Defined Translation for Inovis for 810 to Inbound Logistics Invoice IDOC.
Created front end ABAP application to read valid IDOCS and trigger posting application.
Integrated status notification into external MAPI compliant email system. Created and administered required Partner profiles.
Created and administered required EDI Ports

Outbound Purchase Orders - Created and administered required Partner profiles.
Created and administered required EDI Ports.
Created output determination and configuration to trigger export of Purchase Order IDOCS

Reports:

MRBR - Copied transaction MRBR to ZMRBR and added Modifications for additional columns and calculated fields

Empty Bin listing - Rewrite of RLS10010 to add required columns

Stock Transfer - Rewrite of RLS10034 to provide for transfer of partial bin amounts between storage locations

Interfaces and Customizations:

Bank Reconciliation - Custom RFC to export checks from PAYR table for SAP side of external Bank Recon

RSINFDAT - Mass Update to Material Master to change MARC-LGPRO in 250,000 records

Customization - Changed/Added MRP Controllers in SPRO

Dialogs and User Exits:

RV50B901 - Modification to ATP check to include various order types

MV50AFZ1 - Created code to lock modifications to outbound deliveries when being processed by external warehousing system with notification popup to users in VL02

EXIT_SAPLMEREQ_007 - User exit to write production order information to purchase requisitions for historical orders

EXIT_SAPLCOZF_001 - User exit to write production order information to purchase requisitions during production order creation

SAPscripts and SMARTFORMS: Creation or Redesign of all the following

Customer Statements (US) -

Order Confirmations (US) -

Credit Notes (US/NL/DE) -

Commercial Invoices (US) -

Service and Parts Invoices (US/NL/DE) -

Proforma Invoices (US/NL/DE) -

Purchase Orders (US) -

Shop Floor Papers -

Quotations -

Packing list (US/NL) -

Goods receipts -

History: Fleming Companies Inc., 03/2000 - 01/2002
Employed as Chief Programmer

Reports/Interfaces:

A/R Customer Aging Report - Rewrite to disconnect from logical database and improve performance
Restructured ledger entry retrievals for open items

Special Ledger Report - Rewrite to optimize performance during monthly rollup

Lockbox preprocessor - JES/2 to transmit data from mainframe to Unix
Unix script to trigger SAP event
ABAP/4 to retrieve files and parse into fields then call to RFBBL010 with job submission monitoring and SAP email notification of job status

OLE2 link to external email (groupwise) - Use of object creation and use in ABAP/4
Created as work around for not having mail connection

Security application to auto-create userid's - ABAP/4 to auto create SAP support Id's with default privileges and then link to external email to send notification to support personnel of Id

Journal ledger posting upload from Excel - A distributed copy of an Excel file with embedded VB code to create SAP logon and call to transaction F-02
BDC data is sent from entries of Excel file and SAP messages are returned to Excel
SM35 session is created for manual error correction

Special ledger posting upload from Excel - Very similar to above however transaction name is
GB01 and errors are corrected in the Excel file not
in SM35 and retransmitted

RFQ Export to Excel - During RFQ create or print a custom popup executes to query the user for export.
Data is loaded into internal tables and passed to a custom function call containing download coding.
N.T. filename controls are included in function call to prevent inadvertent file overwrites

SAP Spool Request extraction to Internet Explorer - VBScript embedded on client page logs onto S.A.P. and
retrieves S.A.P. spool numbers for a user or range.
Spool numbers are dynamically placed onto client page as
buttons and when user clicks a spool number a call back to S.A.P. is
executed to retrieve the spool item and display onto new client page

Dialogs/User Exits:

SAPLMGD1 - Created additional domains and data elements
Extended Material Master Tables with appends
Copied SAPMLGD1 for modification, added screen tabs and PBO/PAI processing for the new fields
Modified screen sequences for Material Master in IMG to process new screen tabs

SAPMV45A - Created additional domains and data elements
Appended elements to Order Entry Tables
Added elements to existing screen tabs
Added PBO/PAI processing for the new fields

SAPMV50A - Added elements to existing screen tabs
Added PBO/PAI processing for the new fields

SAPMV60A - Added elements to existing screen tabs
Added PBO/PAI processing for the new fields

EXIT_SAPLFYTX_USER_001 - Tax Calculation call to Vertex
Added coding to correct field extraction rounding errors

EXIT_RFEBBU10_001 - Added account determinations coding for incoming cash payments

SAPscripts:

Purchase Orders - Correction of addressing and company code determination and display

Checks - Creation of SAPscript variables to hold federal and state sales tax amounts

Check Remittance Advice - Same as Checks to complete the documents for check printing

History: Millennium Special Chemicals 06/1992 - 03/2000
Employed as Programmer Analyst for 8 years

Did Legacy extraction of Material Master

Was Lead SAP programmer after implementation

SAP Reports and Interfaces:

Profitability Report - Heavy rewrite for corrections and performance optimization

Agent Commissions Due Report - Agent commissions due based on % of sales order paid

Purchase Requisition Report - Monthly Report of Purchase amounts with purchasing agent

SAP Gateway installation - Gateway Installation onto NT Network
Created SM59 settings for remote destination of Gateway on SAP side

Check Reconciliation - Creation of SAP Logon and RFC objects in VB
Creation of current and history tables for data storage in Access
Retrieval of SAP written check information using VB Automatic dialup, logon and retrieval of Bank cleared check information using VB
Autobalance of both sets of data with movement to history tables
VB form for user to correct variances between SAP data and Bank Data also with movement to history
Check Reconciliation report listing in V.B. printable to any available network printer

Customer Invoice export to Word - Mirror image of SAP customer invoices transferred to Word for email to outlying Sales offices

ATP Report w/export to Access - Extraction of inventories on hand with corrections for returns and inventories in transit between plants

Foreign Sales Commission Report - Sales data by export region transferred to Access and merged with Paradox histories
Recipe extraction to Access - Recipes with superior activities extracted with external call to trigger load to Access

SAPscripts:
Creation or Redesign of all the following

Certificates of Analysis -

Purchase Orders -

Sales Invoices -

Bills of Materials -

Education:

4 years United States Navy

BSCIS University of North Florida 1991

Hosted by www.Geocities.ws