Title:Database Developer
******@********.***
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE:
ZIP:
CANDIDATE ID: 2893576
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 000*******
EMAIL: ******@********.***
HOMEPAGE:
HOTTEST SKILLS: transaction, abap, sap r, r/3, sale, audit, pricing, c++, cobol, unix,
price, germ, computer science, database, lotus notes, os/2, programmer, programming, vms,
communication
REVISION: 08-SEP-02
RESUME:
NAME: TED CHANG
ADDRESS: NO ADDRESS
CITY: CITY
STATE/PROVINCE: ST
ZIP/POSTAL CODE:
COUNTRY: USA
EMAIL:
PHONE: (000-***-****
CANDIDATE ID: NA
CITIZENSHIP: US Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Any
RATE NEEDED: Not Entered
HOMEPAGE:
COMMENTS:
HOTSKILLS:
TED C. CHANG
NO ADDRESS
CITY, ST 00000
******@********.***
Specialize in the modification and extension of SAP functionalities:
Modified and extended SAP SD functionalities - Batch Management (
Automatic Lot Assignment) - to restrict order confirmation to the same
batch, which is one of the critical functionality to pharmaceutical
industries, medical instrument industries as well as sensitive
semiconductor chip industries., which involves SAP transactions VA01,
VA02, VA03.
Modified and extended SAP SD functionalities - Sales Audit.
Modified and extended SAP SD Delivery Creation VL01 - To enforce SAP
Delivery Group.
Modified and extended SAP SD Delivery Transactions VL01, VL02, VL03,
VL04 - To allow Batch Split across different Storage Locations and
automate Picking and delivery process.
Experience on how to handle MSEG, BSEG monster tables and certain
programs to run 10 to 100 times faster.
Education
master of Science
in Computer Science, University of Texas, 1981
Master of Science
in Numerical Analysis, University of Oklahoma, 1979
Summary of Experience
Over three years experience in SAP ABAP/4 development. Over nine years
C, C++, Unix experience in Communication and GUI design.
Responsibilities includes Developing Transactions (includes Screen
Painter, Menu Painter, Import/Export, Parameter ID, Message Class,
Screen Sequence Control, DB Tables), Interactive Reports, BDC
Conversion, SAP Script, Data Dictionary, CPI-C, Event Process, Batch
Job Scheduling and using INDX cluster table and Correction / Transport
System.
Operating Systems: HP-UX, AIX, UNIX, OS/MVS/VSE, VAX/VMS, MS-Windows,
OS/
2 Programming Languages: SAP R/3 ABAP/4, C++, C, COBOL
Applications: SAP R/3 SD, MM, FI, EDI, CPIC, Bar Code. PC
Applications: Lotus Notes, MS Word, MS Excel, cc:Mail
SAP R/3 ABAP/4 Consultant
- Feb 1996 to ...
Gave lectures on how to develope Dialog Transaction, Screen Painter,
Menu Painter, Messages, ...
Physical Inventory Count - developed dialog transaction with full
screen input editor for multi-user to add new tags and modify tags.
Total 5 screens, menus and 7 reports.
Subcontract P.O. receipt - developed dialog transaction to automate
the processing.
Modified and extended SAP SD Delivery Transactions VL01, VL02, VL03,
VL04 - To allow Batch Split across different Storage Locations and
automate Picking and delivery process.
Experience on how to handle MSEG, BSEG monster tables and certain
programs to run 10 to 100 times faster.
Straighten out messy reports by building a common Shipping Activity
Table, other than Backlog Activity table, and building common include
files and subroutine library.
3Com - a networking company
SAP R/3 ABAP/4
Consultant
- May 1995 to Feb 1996
Modified and extended SAP SD functionalities - Honor Delivery Group
(Transaction VL01). Also includes modifications of Screen Sequence
Control tables T180, T185, etc.
New transaction development (ZVXR) - Developeda transaction to do
product hierarchy cross references, which includes screen design, menu
design and pull-down help window for fields.
New function modules - Created get_backlog_line_item and
get_revenue_type function modules.
BDC call transaction reports - Monthly end backlog report before and
after re-pricing which involves getting SAP New Pricing code. Also
daily manual pricing audit report, and etc.
New subroutine library - Set up standard ABAP routines for Data
Warehouse project to extract data from SAP tables and SIS tables.
SYVA
- a subsidiary of German Behring Diagnostics Inc.
SAP R/3 ABAP/4 Consultant
- Jan 1995 to May 1995
Modified and extended SAP SD functionalities - Honor Batch Management(
Also called Automatic Lot Assignment, involves transactions VA01,
VA02, VA03). Which includes screen modifications, menu modifications,
function code additions in SAP module MV45AFZZ, USER_EXITS
modifications, and addition/modifications of Screen Sequence Control
tables T180, T185, etc. Also created a new function module
Z_V_REQ_DELETE_WHEN_BACKORDER to SAP function group SAPLV03V. Merged
existed display and update function modules into one function module
Z_V_GET_BATCHES(SAPLZVSO), consolidated code lines from 2000 to 400.
Because of the completion of this extraordinary complicated task, Syva
manager said: "One of the best ABAP developer in the valley".
Modified and extended SAP SD functionalities - Sales Order Audit,
which to be performed upon saving the new/revised sales order. Audits
include determination of previously completed orders, route carrier
combination check, price override check, batch id check, and
incompletion report. The extended code was added in SAP routine
USEREXIT_SAVE_DOCUMENT_PREPARE when function code is 'SICH'.
New transaction development - Created front end transactions ZV01,
ZV11 to VA01, allows user entering Sold To, Purchase Order, Method of
Ordering, Contact person, etc, other than Order Type, Sales Org.,
Distribution Channel, and Division before the user having to navigate
several screens to do it. Parameter ID's have been set up to carry
forward data to the VA01 transaction. And SAP USEREXIT have been used
to catch input data from the front end transaction.
BDC call transaction interactive reports - Re-assigns batch number
(lot number) and confirmed quantities.
SAP Script - Used SAP Script to generate customer contract agreement,
equipment listing and price listing, etc.
HP
SAP R/3 ABAP/4 Consultant
- Oct 1994 to Mar 1995
Developed BDC conversion programs for MM contract agreement.
Interface program - Data extracted from SAP MRP module and sent to
external system using SAP CPI-C.
Re-wrote a data extract interface program - original code in Cobol
style instead of ABAP/4 control-break style, code checked by HP German
division and later on received a plaque from HP.
SAP Script - MM Purchase Order module.
Prism Solutions and Zion Software Inc
.
SAP R/3 ABAP/4 Programmer
- Aug 1993 to Jan 1995
Developed BDC program - Uploaded ABAP code from Data Warehouse system
to SAP system, then use it to extract data from SAP system.
Developed Interface program - Extracted table field definition from
SAP system, then feed into Data Warehouse system.
Developed Database access strategy - to extract data from Transparent
table, Cluster table, and Pool table.