Project Sap

Phone 952-***-****

E-mail *******@*****.***

Steve DeBettignies

Professional 3/2003 - Current Ecolab Inc.

Experience Sr. Tech Consultant

*/**** - *******

. SAP PI 7.0 / ECC - Working in Italy on EBS Wave II SAP

turn-on project. Responsible for 3PL and PLC interface

design and development.

. 3PL - Designed, developed and configured all interfaces

to 3PL(GEODIS) in Italy. Interface development work

included outbound OBDLV, IBDLV, MATMAS, Dangerousgoods,

BATMAS IDOC's. Inbound interfaces included OBDLV

confirm, IBDLV confirm, Goodsmovement, and Stocklevel

reporting interfaces. Helped develop delivery note

specifications with the 3PL. Made updates for

Dangerousgoods revision management as well to include

multiple versions of Dangerousgoods and worked with 3PL

to incorporate this change.

. PLC - Designed, developed and configured the PLC

interface in Italy. Extended existing BAPI to include

requirements for PLC in Italy for control recipes for

SCADA PLC software. Tested and implemented PLC for 6

mixers in Italy. Designed and developed interface to

receive consumption and status records from PLC into

IDOC's in ECC for updates.

10/2008 - 7/2009

. SAP PI 7.0/ABAP - Designed, developed and configured PI

IDOC to file interfaces for invoice enhancement project

and process via EDI. Extended the INVOIC02 IDOC with

an additional 25 fields. Designed and developed ABAP

BAPI in ERP to retrieve the needed information for the

25 fields. Added code to user exit in ECC to populate

the extended INVOIC02 IDOC extensions.

9/2005 - 9/2008

. SAP PI 7.0 - Developed an Interface for updating

material in the St Paul planning system (CAS mainframe)

from EPIC.

. SAP ERP 6.0 / PI 7.0 - Helped design and develop ERP to

CAS and CAS to ERP interfaces from legacy systems to new

SAP ERP system. The systems maintain inventory for all

plants for planning and forecasting needs.

. SAP ERP 6.0 / PI 7.0 - helped design and build interface

for daily updates of foreign exchange currency rates in

SAP ERP system. Designed and built daily feed from

Bloomberg for currency rates.

. Perform SAP CRM 5.0/ERP 6.0 Middleware configuration for

client copies.

. SAP GCS - Maintain and support ServicePower /

ServiceManager / ServicePlanner / ServiceAnalytics /

Jumpstart Wireless. They are 3rd party applications

that interface with SAP ERP 6.0 with underlying sql

server 2000 databases / stored procs etc.

. SAP EBS project - Designed and built file pre-processor

in Perl which manages all inbound files to the Ecolab

SAP environment. Runs on unix server and backends to a

SQL Server 2005 database for auditing, reporting and

configuration information. Designed and architected

database and all stored procs required for the

application. Process automatically alerts service desk

to support 7/24 applications to provide real time

support needs.

. SAP EBS project - wrote all supporting unix scripts in

ksh and/or perl for all interfaces related to EBS.

. SAP PI 7.0 - Developed data/message types, mapping for

Inbound /Outbound interfaces in Integration Repository.

. SAP PI 7.0 - Defined message mappings extensively using

Mapping Editor in XI also using XSLT and Java.

. SAP PI 7.0 - Developed new interface objects using the

File, SOAP and XI adapters

. SAP XI 3.0 / PI 7.0 - Performed sender/ receiver

determinations and sender / receiver agreements in

Integration Directory.

. SAP XI 3.0 / PI 7.0 - Message monitoring in Integration

Server and Runtime Workbench.

. Completed XI training on 10/2006 and ABAP training on

8/2007.

Environment: SAP XI 3.0 / PI 7.0, SAP ERP/CRM 6.0, SAP CRM

middleware, Perl, SQL2005, Java, AIX Unix, UC4

04/2003 - 9/2005

. Tech Lead/Project Lead for ESM (Ecolab Service

Management) Institutional project which is a mobile

platform that services 3000 service reps throughout the

globe. The application includes mobile, web based,

database and backend processes. Responsibilities

included reviews and approvals of all designs, standards

related to all development platforms and technical

designs, mentor and help develop young talent,

responsible for all technical deliverables and timelines

associated with the deliverables.

. Tech Lead for the ESM Ecosure Industrial project which

is web application that runs in a Java Websphere

environment.

. Designed and developed C# applications for the Ecosure

project that interfaces with Java applications in an

enterprise Websphere environment.

. Designed and developed C# application for Risk

Management that included data collection at all plants

and divisions. Also designed and developed OSHA reports

for the company to meet yearly reporting requirements to

the government.

. Designed and developed C# application that incorporated

3rd party monitoring software of restaurant equipment to

feed into sql server database for alerting problems back

to the service tech and restaurant (example: cooler

temperature for hi's and low's). Designed database and

stored procs as well.

. Lead both Java and .Net coding and development standards

for the company and a member of the standards committee

for both languages.

. Designed and developed SQL stored procedures and DTS

packages for several projects.

. Lead on Tools Team for several projects.

Environment: .NET, C#, Java, SQL 2000 & 2005, C++, Access,

UML, UC4

1/99 - 3/2003 Ecolab Inc. through broker contract

Consultant

. Designed and developed a 3-Tier VB application with a

SQL7 database that automatically creates Remedy cases.

The application creates cases via a command line EXE,

implementation of a COM component, or implementation of

a generic error handling DLL.

. Designed and mentored the initial development of a 3-

Tier VB laptop application with data synchronization

from a SQL7 database to a MSDE database on laptops for

District and Territory Managers. UML and Use Case

Models were used in the initial design process.

. Converted the LIMS application from ACC97 to ACC2000.

Also upgraded Crystal Reports from 6.0 to 8.0. The

application consisted of 25 Crystal Reports and about 40

forms. When completed I also created a new setup for

the application using InstallShield.

. Designed and implemented a generic error handling DLL

with a COM interface. The component incorporates ADO

error handling, BJS (Batch Job Scheduler) options, and

Remedy case creations. This component was implemented

into several different application programs.

. Programmed and provided support/mentoring for the Edge

Advisor application. The application consists of 1900

users in the field with Windows CE devices.

. Mentored several people on other projects involving VB,

SQL7, synchronization, COM, and reports.

. Designed and developed an application for 150 TCD

service representatives throughout the country. The

project had 3 main parts. The laptop application, data

conversion, and synchronization of data from the laptop

back to the mainframe.

Developed the original phase of the laptop application.

Designed, coordinated, analyzed, and developed the WES

and Tunnel Washer features which were add-ons to the

project. Both the WES and Tunnel Washer phases were

completed on time with exceptionally few errors given

the complexity of the projects.

Aided in the development of the data conversion process

and in the selection of a synchronization package,

installation, and testing. I also installed and used

Visual SourceSafe for the project. The initial lack of

design documents, standards, and problems with

synchronization created several challenges. This

project had been attempted once in 1997 and again in

1998 and failed both times.

Environment: WIN98, WINNT, VB6, SQL7, MSDE, COM, Visual

Interdev, VBScript, ACC97, ACC97 Replication, ACC2000, BJS,

Remedy, Synchrologic(synchronization software), Visual

SourceSafe, e-Changeman

9/99 - 3/00 (part time) Health Partners Inc.

Consultant

. Designed and developed a phase II release of the Cost

Modeling Application that is used in negotiations of union

contracts. Several reports and added functionality was

incorporated in the new release.

Environment: WIN95, VB6, and ACC97

9/98 - 2/99 (part time) Health Partners Inc.

Consultant

. Designed a Cost Modeling Application that is used in

negotiations of Union Contracts.

Environment: WIN95, VB5, and ACC97

8/98 - 12/98 Biffs Inc. through broker contract

Consultant

. Completed, resolved outstanding issues, and added new

functionality to their Billing and Scheduling Application.

Environment: WIN95, VB5, and ACC97

4/98 - 12/98 Best Buy Corp. through broker contract

Consultant

. I was brought in to help on a Phase II conversion of MDF

COOP application from CICS to VB5. The MDF COOP application

tracks advertising dollars given to Best Buy by its

Vendors. These funds total 40% of Best Buys revenue. I

shortly learned the original Phase I was 3+ months behind

schedule and several key members had left the company.

Even though I was brought in to do VB work, I got involved

and ended up being one of the main analysts and programmer

on the MDF COOP project for Phase I. The MDF COOP

application went into Production in August. When I

originally started, all CICS transactions were not working

and the batch process was a mess. I had no prior

experience with CICS but learned it quickly and ended up in

charge of all the CICS transactions and fixed all the

problems that existed at the time and completed testing. I

also rewrote about 70% of the batch process that had to be

redesigned.

Environment: WinNT, CICS, Cobol, and DB2

2/98 - 3/98 MEANS, Inc. through broker contract

Consultant

. Converted the Rate-Of-Return spreadsheet from Lotus 123 to

Excel 97. The Rate-Of-Return model is a method by which

Minnesota Equal Access Network Services calculates and

analyzes the rate of return and profitability of its

regulated subsidiary. The spreadsheet consisted of several

worksheets and macros. All macros were converted to VBA

code.

Environment: WIN95, Lotus 123, and Excel97

5/97 - 3/98 Air Force through broker contract

Consultant

. Designed VB5 application with Access97 database and Crystal

6.0 for U.S. Air Force Family Advocacy Program. This

program provides for the capture and storage of all

maltreatment data needed by FAP headquarters and DOD. The

program provides easy to use menus that the new database

design only requires data to be entered once. The program

automated the FMCMT, agendas, and minutes used at all bases

worldwide. The program also automated the reporting

processes: high interest worksheets, incident notes, status

letters, FAP and OPR notes, 2486 and 2522 forms, intake

form, letters to squadrons, and several other printed

reports. The program also automated the transfer of open

incidents from base to base and automated the archiving

process.

Environment: WIN95, VB5, ACC97, and Crystal 6.0

Education 1986 - 1991 University of Minnesota Minneapolis MN.

BS Mechanical Engineering, Design and Control

Community Apple Valley Jaycees, 1991 - 1994

Activities Positions held: Community VP, 91 - 93

Awards: Bronze award 93 - 94 East Metro Dream Team

Achievement award, May 92

Jaycee-of-the-month, Dec 91

Languages/Skills Years

SAP XI/PI 4

SAP ABAP 3

.NET C# 3

SQL Server 2000/2005 12

VB6 12

C++ 2

Perl 1

Unix 4

Java 2

MS Access 12

UC4 (scheduling 4

software)

Cobol 5

Contact this candidate