Dan B. Gamwell
4103 Cypress Lake Drive
Spring, Texas 77388
Home: (281) 353-9319
Cell: (832) 859-8257
E-mail: dbg@ix.netcom.com
Objective
SAP ABAP, SAPScript, Workflow or BW contract position, where techinical
experience with data manipulation and a good knowledge of ABAP and the SAP Data
Dictionary is required.
Recent Studies
My most recent certification comes from the SAP Academy Business Warehouse
Certification courses in Toronto, Canada.
General Profile
Dan is an SAP Consultant with over 25 years of Information Technology Experience
which includes more than 11 years of SAP experience. He has worked on SAP ABAP,
SAPScript, Workflow and BW contract positions. He has a very good knowledge all
SAP technical areas. In fact, he’s written some very useful utilities for
data mining and Data Dictionary searching. His programming experience
gives him a wealth of code to leverage from, which makes him one of the faster
programmers out there. His special strengths, born of his experience,
would be in the area of Report, Interfaces, Data Conversions, complex
Enhancements and both SAPScript and Smartforms. However, he has also spent
years working in the areas of Workflow and Document Management. He is very
familiar with many SAP modules including MM, SD, FI, PM, CO & PP.
Professional Experience
July 1, 2007 to October 31, 2007
Employer: San Diego Unified Port District (San Diego,
California)
This was a PM implementation. I was the only developer on the project, so
it was a busy time with the migration of Task Lists, Work Orders, Equipment,
Maintenance Plans and Functional Locations. There arose the need for
various enhancements that included custom search helps and user exits. I
also wrote a variety of ALVreporting programs. Finally, I wrote several
programs that were published to the Web, to allow for the creation of
Notifications and the checking of Notification statuses from the company
intranet. My knowledge of Workflow proved to be useful also, on this
assignment.
February 10, 2007 to June 30, 2007
Employer: Buckeye, Inc. (Perry, Florida)
This company is installing the PM module of SAP on ECC 5. Responsibilities
include all areas of data migration, cleansing and manipulation . BAPIs,
BADIs, LSMWs and IBIPS as well as BDC and Call Transactions are the tools of
choice here. As on any project, unforeseen needs arise and must be met.
So far these have included User Exits, the creation of new Search Helps
(matchcodes) and other various system enhancements.
Septermber 1, 2006 to January 31, 2007
Employer: Madix, Inc. (Terrell, Texas)
(See Madix, Inc. below) I returned to Madix to assist in their actual
‘go-live’, and complete the upgrade from 4.6C to ECC 5.0.
June 1, 2006 to July 15, 2006
Employer: Haldor Topso, Inc. (Pasadena, Texas)
Since all ABAP areas were ready for go-live at Madix, they asked if I could take
a couple months off, but still return to help them with go-live. I agreed,
and took this short contract at Haldor Topsoe. Although other tasks became
evident, I was originally contracted for several specific needs, including
creating shipping labels using Smart Forms to be printed on Zebra printers.
Other labels were created using SAPScript.
The Basis support was very limited at this site, so the responsibility fell to
me to install and configure (including research and installation of OSS notes)
the Zebra printers in the IMG.
I also made changes, corrections and improvements to a KRONOS to SAP Interface.
I also finished a detailed Work Order History Report that was only 25% completed
when I arrived. It was quite complex, containing information down to the
routing and operation levels, including time card information for both employee
and contract workers.
The client discovered incomplete Notifications and missing Work Orders in their
system. I wrote 3 programs to correct the 15,000 records.
1) Change statuses of Notifications.
2) Create Work Orders
3) Set status of Work Orders
August 18, 2003 May 31, 2006
Employer: Madix, Inc. (Terrell, Texas)
This contract was a new installations of SAP R/3 Enterprise 5.0 of modules FI,
MM, SD, PP,PLM, Workflow and HR, using IBM as the implementation partner.
As often happens, the expanding scope and details made deadlines unattainable
without additions resources. Madix brought me in as an independent
consultant to take up the slack. In the first two weeks I wrote four ABAP
data conversion programs creating BDCs, large LSMW conversions and a special
program to dynamically load a large variant for processing transaction VF04.
That work they had expected would take over a month. I then began the task
of writing 32 SAPScripts; this all while contributing to problem solving
in numerous areas necessary with a team that is conscientious, though new to
SAP. Additionally, it became evident that certain processes could be best done
using Workflow, although they were unfamiliar with it. I helped implement
solutions in this area as well. During the course of this implementation,
there arose the need for RFC connectivity and configuration changes as
well as limited archiving needs. My support of this project extended to
all modules being installed. The last modules to be implemented were
cProjects and PLM, which I also supported. During this phase I developed a
rather extensive interface forDocument Management, that automated and controlled
the process of bringing scanned documents and engineering drawings into the SAP
Content Server from the FI, SD and PLM modules. I also created a number of
Workflows during this phase of the implementation, as well as a robust Workflow
Tracking system. During this period, due to extensive ABAP work in the
area of Workflow, I developed a pretty good understanding of the ‘guts’ of
Workflow.
July 1, 2001 to May 1, 2003
Employer: Solvay America (Houston, Texas)
Due to a joint venture between Solvay America and British Petroleum, the
responsibility fell to Solvay to migrate the necessary SAP data to a new AP 4.7
system, and create and populate a BW system with the new data. Since I had
worked for Solvay before and had recently received BW certification from the SAP
Toronto Academy, they asked me to come back to perform the needed data
migrations, data creations and interfaces as well as develop new reports for FI,
MM & PM. Various migration methods were used, depending on the situation, and
every imaginable data contortion was accomplished to complete the more than 60
migrations. Data Migration methods included IBIP, BAPI, LSMW, direct loads
and custom ABAPs. Since the development team was lean, many other
tasks fell to me including Reporting for various modules and SAPScript.
Solvay had only completed the pilot phase of a BW implementation project.
I created custom extractors for OLTP data being moved to BW, where I had
designed and created necessary Info Objects, Infocubs and Update Rules
etc. for PM and MM data.
May 1, 2001 to June 1, 2001
SAP Business Warehouse Academy - Toronto, Canada
I have gained a solid knowledge and hands-on experience in modeling, extracting
data, and reporting. Following is a list of areas covered with hands-on
exercises:
Created many basic InfoCubes, created InfoSources, created update rules, created
DataSources, replicated DataSources, loaded Master Data from flat files and from
OLTP, loaded hierarchies from flat files, created Remote Cubes, Multi-cubes and
ODS objects. Created ODS update rules and InfoPackage to load data,
installed Business Content, used the BW Statistics InfoCube to analyze system
usage, created aggregate InfoCubes, used Report Monitor to debug queries,
partitioned tables in an InfoCube for faster query execution, created security
authorization objects for InfoObjects, executed a Data Modeling case study,
extracted data from LIS, CO-PA, and FI-SL. Used ABAP Query/Infoset, used
the LO Cockpit, created Business Content Enhancements. Became very familiar with
SAP’s Administrator Workbench (AWB), and Business Explorer Analyzer (BEX),
including an in-depth knowledge of SAP’s extended star schema modeling. I
also created numerous BEX queries, loaded data to the ODS, performed currency
conversions and worked with hierarchies and variables.
Only half of the class passed the certification test. I was pleased to be
one of them.
January 2001 to May 2001
Employer: Chevron Phillips Chemical Company (Houston, Texas)
This company is a joint venture between Phillips and Chevron running on SAP
4.6b. While at Phillips (July 2000 to January 2001), CPC asked me to come
work for them directly on the Reporting Team, much as I had been doing at
Phillips. Much of the work at CPC involved BW, Report Painter, Report
Writer and ABAP Query, and, of course, ABAP. I shared an office with the
BW lead with several years of BW experience, who depended on me heavily forData
Dictionary expertise, since his SAP background was functional instead of
technical. We conferred on Infocube construction. A highlight was one
Friday morning when I was asked to see if I could resolve the problems with a
program that had been in development by other programmers for over a month.
The program was needed by the following Monday in order to save the company 3
million dollars in additional taxes. In 4 hours I was able to
discover a new approach to the data extraction to deliver the desired results.
It was a pretty big deal. Several department heads wanted to buy my lunch.
(Not everyday is so exciting.)
July 2000 to January 2001
Employer: Phillips Petroleum Company (Bartlesville, Oklahoma)
SAP ABAP programming and support. During this period we brought Chevron
Phillips Chemical Company online with 4.6b. This included program
conversions and fixes for code that was effected by the 4.6b upgrade. Data
migrations never seem to go away, and were an element of this implementation as
well. New functionality was built into source code to take advantage of
new features and options within the 4.6b environment. Subsequent to the
go-live, I worked for the reporting team, doing ABAP support for all areas of
reporting. This included writing function modules, user exits etc.
Much of my responsibility during this period, however, has been debugging and
tracking down problems in reporting source code that seems to be inaccurate or
causing problems.
August 96 to July 2000
Employer: Solvay America (Houston, Texas)
When I began as Solvay, they were on version 3.1h. When I left, 4 years
later, they were on version 4.5a. Duties here included program development
of data migrations (both import and export), as well as interfaces and dialogue
transactions. Data import methods included both external flat files as well as
Excel spreadsheets. For one solution, since the client had a fragmented and
incomplete legacy system, I developed an extensive Access database to facilitate
data consolidation into a format acceptable to SAP. Data import methods included
BDC batch processing, UPI, IBIP, BAPI, and direct table updates. SAP modules
migrated included MM, SD, FI , & PM with particular attention to Vendor,
Customer, Functional Locations, Task Lists, Maintenance Items, Info Records &
Work Order migrations as well as Internal Work Order interfaces of various
types. Of course, supporting skills for program development include the use of
all SAP utility transactions such as SE16, SM35, SE80, SE36, SE37, SQ00, SE09,
SHDB, CMOD, & SE71, as well as cross-client transports and OSS note creations as
well as fix implementations. Familiarity with the data dictionary was crucial
for table creations and changes. A major SAP upgrade from 3.1I to 4.6b created
unique demands that were challenging to work through. Job scheduling and
automation, being integral to interfaces, was often an important part of the
solution. Skills with SAPScript, ABAP Query, Logical Databases and the use
of CMOD and User Exits were also developed during this period.
Incidentally, at the beginning of the project, we received proper specifications
for each job. By the end of the project, specifications information was
often extremely limited as we were expected to do much of the analysis work as
well as the programming. During this 18 month period I was emersed in the
46B upgrade and PM installation and reorganization. After the initial PM
installation, different business processed were adopted which demanded a
remigration and reorganization of PM, from Functional Locations, Maintenance
Items, Maintenance Plans and Task lists to BOMs and Equipment. Numerous
reports outside of SAP, such as Labor Costing and Work Schedule Compliance were
developed during this period. I hope to soon completed SAP certification in
Business Warehouse.
August 95 to August 96
Employer: A to Z Windows Solutions (El Paso, Texas)
Installation and database administration of Oracle 7.2
Installation of Developer 2000 toolset
Forms 4.5, Reports 2.5, Procedure Builder 1.5, SQL*Plus training
SQL training and experience using Oracle & Microsoft production
Business solutions in Windows environment with a variety of products including
Microsoft Access and Access SQL, Exchange, Visual Basic, Office and others.
Windows 95 installation, instruction, configuration and networking.
During this period I was self-employed, providing multiple services in the
computer field. Below is a listing of major achievements, activities
and client references.
April 82 to August 95
General computer services (El Paso, Texas)
During this period I did general computer hardware maintenance in addition to
software support and development including the following:
Hundreds of software installations, tutorials and instruction for a myriad of
software products from Microsoft Office to multimedia video and sound
digitization.
Windows 95
networking
El Paso Crane & Rigging
Office Manager: Roberta Cordova
(915) 591-4513
Microsoft Access and SQL programming.
Larico Medical
Owner: Larry Del Olmo
(915) 590-9175
Microsoft Office Integration using SQL functionality
Jubilee Sales
Owner: Joe Foster
(915) 598-1506
Lantastic networking
Law Offices
Contact: Ernesto Pineda
(915) 534-9952
June 1988 to June 1989
Charitable work in Central America
While I have always done, and still do, charitable work, I spent an entire
year working in a charitable capacity in Guatemala and Honduras. (I speak
fluent Spanish.)
May 1984 to June 1988
Software development (El Paso, Texas)
I developed a software package for business schools which maintains student
records, prints grade slips, transcripts, student schedules, class rosters,
class and individual attendance records, etc. Numerous schools use this
software today. International Business Colleges have several schools using
this Student Files Software System.
International Business College
Director: Margie Aquilar
4121 Montana
El Paso, Texas 79903
(915) 566-8644
April, 1982 to May, 1984
Software development (El Paso, Texas)
I developed a software package for advertising agencies and in-house
advertisers, using the Arbitron Ratings statistics to provide the best
cost-per-thousand TV advertising run schedule for any selected demographic, by
simply entering information such as advertising budget, start date, ending date,
excluded days, day parts or stations, etc.
Education
1980 to 1982
University of Texas at El Paso
El Paso, Texas
Junior year
Computer Science Major
3.4 GPA
References
Gary Jones
IT Team Assistant Director
Madix, Inc.
( 972-563-5744
*gjones @madixinc.com
Tammy Hughes
IT Team Director
Madix, Inc.
( 800.633.6282
*thughes@madixinc.com
Kathy Dickerson
Solvay Information Technologies, Inc.
Manager, SAP Applications
( (713) 525-4086
*kathleen.dickerson@solvay.com
Randy Yardley
Reporting Team Lead
Phillips Petroleum
(918-661-0141
Stewart Lane
IT Systems Supervisor
Solvay Information Technologies, Inc.
(713-525-4144
*stewart.lane@solvay.com
Scott Hagy
PM Team Associate
Solvay Information Technologies, Inc.
*scott.hagy@solvay.com