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, where he could use his 11 years of SAP experience that comes from multiple upgrades, heavy conversion, enhancements, reporting and customization requirements from diverse clients from public sector to oil, to mining to manufacturing.

Recent Studies

His 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, Installation, Upgrade, 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 that are useful tools for analytical work for conversion, reports and enhancements. He was also the lead for the RICEF team during his most recent contract. 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 quite familiar with many SAP modules including MM, SD, FI, PM, CO, PLM & PP. He has done multiple SAP upgrades for many versions from 3.1h to ECC 5.0.

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