Edwin M. Kirby

192 Adams street Warwick, RI 02888 Telephone: (401) 369-0088

E-mail – edwin.kirby@me.com

Profile: President and owner of ADC Systems Inc. and senior EDI/Integration systems engineer with strong knowledge in providing integration development for the enterprise. By utilizing IBMs WebSphere Transformation Extender product together with Oracle, DB2 or SQL Server I can design and implement custom EDI and data integration solutions. I have the ability to communicate with users at all knowledge levels, solve problems and think strategically.

EDI Certifications: Mercator Certified Consultant (MCC)

EDI Applications: WebSphere Transformation Extender, WTX Trading Manager, Partner Manager, WTX Design Studio, iPlanet ECXpert, Oracle, Intelligent Network Gateway by Momentum Systems.

Languages: I now have or have had experience in the following: HTML, XML, XLST, SQL, T_SQL, C, C++, UNIX Shell Scripts and limited exposure to JCL. Ive worked with Objective-C and Cocoa (Apples Application Framework).

Operating Systems: All current and past Windows environments, UNIX - Sun Solaris, CENTOS, IBM AIX/6000, Mac OS X and MVS OS/390 (Limited TSO and RACF access).

Other/Tools: Eclipse, Xcode, iPlanet ECXpert, SQLPlus and SQL Worksheet, MySQL, Apache Web Server, IIS and SQL Server, Microsoft Word, Excel, Outlook, Lotus Notes, PowerPoint, MS Access, Novell Netware 3.12 and Intranetware 4.11.

Professional IT Experience

11/1998 thru Present ADC Systems, Inc. (Formerly Edwin M. Kirby Consulting)

President / Senior Consultant

Independent Consulting Company providing both EDI/Integration services utilizing WebSphere Transformation Extender setup and configuration services, EDI/Integration mapping using Websphere TX Design Studio, Application development using the Websphere TX suite of tools and Mac development utilizing Cocoa and related technologies.

7/2010-9/30/2011 Maine Judicial Branch

Cocoa Engineer

Support existing Macintosh applications within MJB. Develop new applications to support the migration/integration from their current legacy system MEJIS to the new environment MEJIS2. MEJIS2 is an all Cocoa solution running on the Mac and is supported by an Oracle backend.

4/19/04-6/30/10 Covenant Health/PHP

WTX Integration Consultant-HIPAA

Architected complete WebSphere TX 8.1 EDI/Integration solution. Developed and improved current EDI/integration maps and related processes with the WTX Design Studio and other applications in the WTX tool set. Improve existing map performance and execution. Responsible for creating integration maps for processing inbound and outbound data and integrating that data into the clients back end solution. Mentor existing EDI department resources in the development of WTX maps and processes. Ran classes on mapping with WTX and Trading Manager setup and management.

Environment: Windows Server 2000, SQL Server 7.0, and Mercator Design Studio for Windows.

6/26/08-1/31/09 Eaton Corporation – Electrical Division

Integration/WTX Consultant-SCM

Develop new EDI/integration maps and related processes with the WTX Design Studio and other applications in the Websphere Transformation Extender tool set. Improve existing map performance and execution. Responsible for creating maps for processing inbound and outbound data and integrating that data into the clients back end solution. Mentor existing EDI/Data Integration department resources in the development of WTX maps and processes.

Environment: UNIX AIX 6000, Oracle, WTX Design Studio for Windows and ECXpert.

3/5/04-4/16/04 PHCS (Private Health Care Systems)

WTX Integration Consultant-HIPAA

Responsible for developing/improving EDI maps and related processes with the WTX Design Studio and other applications in the WTX tool set. Responsible for creating maps for processing inbound and outbound data and integrating that data into the clients back end solution. Mentoring of existing EDI department resources in the development of Websphere Transformation Extender integration maps and processes.

Environment: IBM AIX6000 O/S, DB2, and WTX Design Studio for Windows.

9/2/03-12/19/03 ACS EDI Gateway

EDI/WTX Integration Consultant-HIPAA

Developed EDI/Integration maps and related processes with the WTX Design Studio and other applications in the WTX tool set. Responsible for creating maps for processing inbound and outbound HIPAA data and integrating that data into the clients back end solution. Analyzed current architecture together with other resources to determine the best integration strategy based on the clients needs. Created transaction sets in various HIPAA X12 EDI and IRL flat file formats.

Environment: IBM AIX6000 O/S, Windows 2000 O/S, DB2 to support WTX and back end processes, WTX Design Studio, Mainframe O/S 390, WTX Trading Manager.

6/15/01-8/29/03 Blue Cross and Blue Shield of Rhode Island

EDI/WTX Integration Consultant-HIPAA

Analyzed current architecture to determine the best integration strategy based on the clients needs. Worked with client to develop a new architecture that was subsequently implemented. Responsible for developing integration maps and related processes with the WTX Design Studio and other applications in the Websphere TX tool set. Responsible for creating maps for processing inbound and outbound Medicare data and integrating that data into the clients back end solution. Created transaction sets in various HIPAA X12 EDI and HCFA flat file formats. Implemented WTX Trading Manager and performed several upgrades during my tenure.

Environment: IBM AIX6000 O/S on IBM Winter Hawk Nodes, Windows 2000 O/S, Oracle 8 RDBMS to support WTX, WTX Design Studio for Windows v6.5, Mainframe O/S 390, WTX Trading/Commerce Manager 5.0 and 6.1.

8/14/00-6/15/01 Eventra

Integration Consultant-Supply Chain Management

Developed Integration/EDI maps and related processes with the WTX Design Studio and other applications in the WTX tool set. Responsible for creating integration maps for processing inbound and outbound data and integrating that data into the clients supply chain management solution. Analyzed current architecture along with other onsite resources to determine the best integration strategy based on the clients needs. Created transaction sets in various ANSI X12 EDI/Integration formats:

#820s (Remittance Advice) inbound

#824s (Application Advice) inbound

#830s (Planning Schedules) inbound

#850s (Purchase Orders) inbound

#860s (Purchase Order Changes) inbound

#861s (Material Receipt) inbound

#862s (Material Release) inbound

#856s (Shipping Notices) outbound

#810s (Invoices) Outbound

The data communication was handled by utilizing a Virtual Private Network set up with Nortel Networks. The data transmission and map execution environment was handled by iPlanets ECXpert. After determining the mapping/integration strategy, set out to create the maps as follows:

Review client ICs (Implementation Conventions) and Logical Maps prior to the creation of type trees and physical maps.

Created a pruned type trees to define and describe the incoming data. Inserted clients specific business related logic into maps.

Next, the inbound data was mapped to an SQL text file. At this point the data is ready for the next stage of processing.

The following stage of processing entails loading the SQL text files and then mapping the data to the Oracle holding tables.

Environment: Sun Solaris O/S on various Sun machines, Windows NT 4.0 O/S, Oracle 8 RDBMS for Sun Solaris, WTX (formerly known as Mercator) Design Studio for Windows, iPlanet ECXpert on Unix (Solaris)

5/00 – 8/14/00 Veritas

WTX Integration/EDI Consultant

Responsible for developing EDI/Integration maps and related processes with the WTX Design Studio and other applications in the WTX tool set. Responsible for automating the inbound reception and processing of their Software licensing and licensing renewals and integrating that information into their ERP system as well as outbound purchase orders and invoices would have to be generated based on data in ERP system. Analyzed current architecture together with other resources to determine the best EDI strategy based on the clients needs. Created transaction sets in the ANSI X12 v4010 EDI format:

#850s (Purchase Orders) inbound

#867s (Rebate and Sales Tracing Reports) inbound

#856s (Shipping Notices) inbound

#810s (Invoices) Outbound

#850 (Purchase Orders) Outbound

The data communication was handled by utilizing a Virtual Private Network set up with GE Information Services (GEIS). The data transmission and map execution environment was handled by Mercators Commerce Broker (Today, known as WTX Trading Manager). After determining mapping strategy, we set out to create the maps as follows:

Created a pruned type trees to define and describe the incoming data. Next, mapping the inbound data to an intermediate file. A header was mapped along with its corresponding line items. Inserted business related rules as needed. A report file was created to notify (by Email) the users of any errors at this stage of processing. At this point the data is ready for the next stage of processing.

The following stage of processing entails reading the intermediate files and then mapping the data to the Oracle staging tables.

Create the type tree to describe the data in the intermediate file. Map the data into the database (Headers and Lines) based on business specific rules. Create type trees based on the tables using the Mercator database interface designer.

Environment: Windows NT 4.0 O/S, Oracle 8 RDBMS on UNIX, Mercator (WTX) Design Studio for NT, Mercator (WTX) Commerce Manager Design Client, Mercator Commerce Manager Server and Mercator Commerce Broker

01/99 thru 05/00 Med-Ecom

EDI/Integration Analyst

Responsible for developing EDI maps with TSIsoft Mercator to re-engineer existing in-house processes interfacing with an Oracle8 and UNIX environment. Interface with Oracle environment through SQLplus and SQL Navigator. Development and maintenance of EDI infrastructure. Utilizing knowledge of ANSI standard for X12 documents as they relate to 867 and 844 transaction sets. Install and configure communications hardware and software. Maintain Async, Bisync and FTP communications between end-points with Momentum Systems Automatic File Director and Mercators Trading Partner PC/32. Create custom sign on and sign off scripts. Assist Value Added Networks to set up new trading partners and solve data and/or communications related issues.