SJDeffer Consulting, Inc.

IBM Websphere TX, DataStage TX (Mercator) Specialist

Scott J. Deffer

5 Dodge Street Suite 222

Beverly, MA 01915

scott@sjdefferconsulting.com

(home office) 978-927-8177

(cell) 978-821-9039

EDUCATION: B.A. in Business management from Hartwick College in Oneonta NY 1981.

HARDWARE/SOFTWARE: IBM Websphere TX 8.0, DataStage TX 8.0, DataStage TX 7.5, Mercator 6.7.1, Commerce Manager 7.0, Mercator 6.5.2, Commerce Manager 6.1, Mercator 5.0 sp3, Commerce Manager 6.0, Mercator 1.4.2, Websphere MQ 5.3, MQ Series, Oracle 9.2, Oracle 8.1.7, Windows XP, Windows 2000, AIX Unix 4.3.3, Windows NT Server 4.0, MS SQL Server for NT 6.5, SWIFT, EDI, XML, EDIFACT, SAP R/3, VAX Workstation 4000, IBM AS/400, IBM370, MSDOS 6.2, Microsoft Windows for Workgroups 3.11, OS/2 2.1, OS/400, Ansii C, Microsoft Visual C++ 1.5 IDE, Novell Netware 3.12, Microsoft Visual Source Safe, PVCS 5.2, Sybase SQL 4.22, Desktop DBA for Sybase, MS Access1.1 and 2.0, TSO, ODBC 2.0 Drivers, Micro Focus COBOL, Realia COBOL, AS/400 COBOL, IBM COBOL, OS/JCL, Microsoft Pascal.

EXPERIENCE: 11 years experience with IBM Websphere TX, DataStage TX, Mercator

February 2007 to Present:

Wyeth Pharmaceutical, Andover, MA

Responsible for maintaining, troubleshooting and enhancing existing DataStage TX 7.5 interfaces interfacing between SAP IDOCs and Oracle Database, Database to database and database to flat file. Involved in creating and revising FDA regulated documentation and system support. Authored a DataStage TX Best Practices SOP. Redesigned SAP to MCAS Interface using Best Practices SOP.

October 2006 to February 2007:

McKesson, Newton, MA

I was brought in to analyze and optimize an existing set of maps using WebSphere DataStage TX 8.0. These maps extract healthcare questionnaire answers from MS SQL Server database tables and transform them into a pipe delimited flat file formats to be loaded to another set of MS SQL Server tables. My job was to make these maps less cumbersome, more automated and easier to maintain.

November 2005 thru September 2006:

Wyeth Pharmaceutical, Andover, MA

Wyeth BioPharma developed a Datastage TX 7.5.1 system to map XML data from a Websphere Queue to Oracle database tables and visa versa on a Windows 2003 Server environment. I was brought in to analyze this system and write a troubleshooting document as well as recommend enhancements to improve deployment strategy, increase performance, optimize installation configuration and overall mapping best practices. Converted existing 6.7 to 7.5.1 and added best practices. Involved in writing Configuration Specification and Installation Qualification documentation.

Sept 2005 to Sept 2005:

Liberty Health Advantage, Uniondale, NY

I was brought in to architect and build a process using Datastage TX 8.0 to translate membership data to a HIPAA compliant 834 to be provided to vendors for enrollment. This was a 40 hour assignment.

July 2005 to Sept 2005:

Blue Cross Blue Shield of Rhode Island, Providence, RI

I was asked to architect a system of Datastage TX maps to interact with multiple middleware products to translate HIPAA EDI transactions 270,271,276,277 and 278 from x12 to xml for inbound and back to x12 for outbound on a Unix platform in real time. The requirement was to complete the flow that originated from the provider and responded back to the provider within 60 second. The DataStage TX process was given 20 seconds to complete both inbound and outbound. I was able to get the process down to under a second combined for one transaction. The process used DataStage Event Server and IBM Websphere Queues on unix.

May 2005 thru June 2005:

PHCS of Waltham, MA

I was brought it to architect and develop a series of maps and trees using DataStage TX version 7.5.1 that would interact with other middleware processes to translate proprietary flat data to hipaa x12 837 and back again. Also required to build systems of maps to run under Event Server on Unix in real time.

February 2005 to April 2005:

The Bank of New York West Paterson New Jersey

This was a continuation of a previous engagement in 2004. I worked with SWIFT converting MVS maps from SWIFT 2003 to SWIFT 2005 format using Datastage TX 6.7.1 and 7.5. I also developed new maps for MVS using proprietary formats.

December 2004 thru January 2005:

GM Powertrain Pontiac MI:

I worked on a series of maps and trees reading binary data and writing flat text. The maps were ported to SUN UNIX and used Oracle 9i for database queries. Datastage TX 6.7.1 was the version used. My responsibility was to tweak the maps and trees to read more of the binary data successfully and produce more output.

November 2004 to November 2004 (2 wks):

Organon Inc. Roseland New Jersey:

I was brought in to get edi 4010 transactions 810, 180, 844, 852, 850 and 849 working with Commerce Manager 7.0 on a Windows 2000 Test Server. I reconfigured an Email system for error notifications and report emailing. Went through their resource registry files and cleaned them up. Made suggestions to improve the performance of the production server. Helped migrate changes made to the test server to the production server.

May 2004 to October 2004:

The Bank of New York West Paterson New Jersey:

I worked as a member of a team of Mercator (v6.7) mappers at the Bank of New York in New Jersey responsible for the maintenance and development of maps using SWIFT. Maps are ported the MVS. Message types worked with include MT304, MT564, MT566, MT568, MT540-548.

March 2004 to April 2004:

Battelle Richland WA:

I worked as a third party contractor with Ascential Software on a contract in Richland Washington. I was part of a development team required to build a system of maps for the 4030 813 transaction set. My responsibilities included refining a 4030 813 EDI implementation type tree to spec. When that was complete I had to relax the edits in the tree to be used by Commerce manager which would allow all but ansi non-compliant data to pass through. I wrote a map system that would read this good data from commerce manager using the EDI implementation of the tree and produce a 997 showing any errors that existed in the data. Some types of errors generated an AK501=R (reject), others an AK501=E (errors) and if all data was compliant then an AK501=A (accepted). I was also responsible for incorporating all of the developed maps into a system and deploy to UNIX and unit testing on UNIX. The environment was Data Stage TX (aka mercator) 6.7 and Commerce Manager 7.0, Oracle 9i and Sun Unix.

November 2001 to January 2004:

Blue Cross Blue Shield of Rhode Island:

I worked with a team of Mercator mappers developing maps and systems for the HIPAA initiative. I was responsible, in part or in whole, for developing systems for 837, 835, 837cob ,834, 820, 276, 277, 270, 271, and 278 as well as many other infrastructure maps and systems to support these transaction sets. Systems ported to four zones, dev, uat, partner test and prod on UNIX. Was responsible for upgrade from 5.0 sp3 to 6.5.2 Commerce Manager 6.1 on all workstations and all zones on unix as well as database conversions on four zones with oracle 8.1.7.

I was responsible for creating seven event servers on each of the four zones, two of which were commerce manager event servers. One for real time processing and one for batch processing. I was responsible for getting real time transactions processed in 40 seconds down from an initial 2 minutes to meet CMS requirements.

I also mentored Blue Cross employees on Mercator product.

May 1997 to September 2001:

All work performed for the following companies was acquired through Mercator Professional Services as an independent third party contractor.

Defense Logistics Agency (DLA) Philadelphia PA, Richmond VA and Columbus OH:

Built Mercator maps to replace Sterling maps on the mainframe. Mapped EDI

transaction sets 810, 511, 855, 850, 840, 836, 856, 865, 843 to and from

flat files. Integrated maps into a Mercator for EC environment on NT. Designed and developed an entire ecommerce application system using Commerce Manager on the Unix platform with Oracle 8i.

HBOC Rockville MD:

HBOC is a software company catering to the Insurance industry. On-site

with development team on a new project. Created 40+ maps mapping flat

file to flat file.

American Family Insurance Company of Madison WI:

Worked on site assisting American Family employees, on an EDI team, use the Mercator data mapping tool. Mapped application data to and from EDI 811 transaction sets and from EDI 811 to a report file.

MSAS Cargo International in California:

Designed and developed a series of maps to read Links protocol versions 4, 5 and 6 data packets and mapped to MS SQL Server 6.5, EDI 856, 214 and EDIFACT IFTMAN. Mapped EDI 858 to proprietary formats, EDI 997 and MS SQL Server 6.5. Mapped proprietary format to EDIFACT CUSDEC. All maps for multiple trading partners in the Windows NT environment.

Bell Atlantic in New York City:

Maintained and enhanced existing maps translating EDI 850 and 860 transaction sets to a proprietary format and proprietary format to EDI 855 and 865 transaction sets. Most recent release of maps were to EDI version 3072 for Y2K compliance.

Lucent Technologies in New Jersey:

Enhancements to existing production map for payroll system for a new release. Added new functionality to the existing map and created a new map to handle payroll check printing. Worked closely with members of the development team. Mapped SAP Idoc packets to multiple proprietary formats.

Kohler Co. in Kohler, Wisconsin:

Made enhancements and corrections to a map built in-house that read in EDI 823 Lockbox data and wrote out SAP R/3 PEXR2001 Idoc packets. Was able to fix there problems in a timely fashion.

LitleNet in Lowell MA:

Worked with LitleNet to create new maps to map Merchant formats to internal proprietary formats and from the internal proprietary format to a Payment Processors format. These maps were used on an Internet Commerce system for the purpose of validating credit card information.

Allenbrook in Lowell MA:

Light consulting work helping internal mapping team with problems they were having with maps translating data for Insurance software.

Blue Cross Blue Shield in Boston MA:

Asked to make enhancements to existing maps for record format changes within proprietary formats.

SULLIVAN & COGLIANO: Technical Specialist

June 1996 to May 1997:

Brought on as a member of a new division as a salaried consultant. This new division was a Solutions provider to the data processing industry. Self taught on TSI's Mercator and placed on sight with a company whose software development was geared toward electronic commerce on the internet. Promoted to team lead position where my duties included mapping customer data formats to a proprietary internal format and then mapping the internal format to another customs proprietary format. Also managed three other data mappers on the team. Worked on a new project for a Cargo shipment company in California. This project required mapping text inbound data to a MS SQL database and mapping from the database to EDI 856 and 214 transactions.

ISI SYSTEMS, INC. Senior Programmer

August 1985 to June 1996:

Worked my way up from the production department packing boxes to senior programmer involved in new software development. I had the opportunity to work on many different platforms using varied programming languages and database systems. I also was part of a technical support team dealing with clients and their software problems.

References furnished upon request.