Barry DeBruin

919-434-5399

Senior WebSphereTX 8.2 and WMB Developer

Senior WebSphere TX and WMB consultant specializing in WTX, WMB, XML, and XSLT Development with over 10 years of WTX experience as a developer, architect, trainer, and QA.

Experience

WebSphereTX: 11 years

WebSphereMB:1 year

HIPAA:9 years

EDI:12 years

XSLT:6 years

XML:9 years

Healthcare: 10 years

TrainingProjects Summary

Deutsche Bank, Moscow

Rent A Center Dallas

Logica, London

Catholic Health East, Philadelphia

Developer and Architect Projects Summary

Group Health Coop, Seattle

The Home Depot, Atlanta

Rent A Center, Dallas

Technocrats Domain, Atlanta

Principal Financial Group, Des Moines

Synapse Group (Time, Inc.), Stamford

The Home Depot, Atlanta

Principal Financial Group, Des Moines

HMSA (BCBS Hawaii), Honolulu

Blue Cross Blue Shield North Carolina, Chapel Hill

More

Training Projects

Deutsche Bank

Role:WTX Trainer/Developer

Location:Moscow, Russia

Duration:1 week, October 2009

Technology:WTX

Responsibilities:

  • One week class on WebSphere TX 8.2 Type Designer, Map Designer, Database Interface Designer, Integration Flow Designer, Launcher, Management Console, and Resource Registry.

Rent A Center

Role:WTX Trainer/Developer

Location:Dallas, Texas

Duration:1 week, August 2009

Technology:WTX

Responsibilities:

  • One week class on WebSphere TX 8.2 Type Designer and Map Designer with training material, exercises, and examples specific to RAC’s system and maps.

Logica

Role:WTX Trainer/Developer

Location:Cardiff, Wales, United Kingdom

Duration:1 week, April 2009

Technology:WTX

Responsibilities:

  • One week class on WebSphere TX Type Designer, Map Designer, Database Interface Designer, Integration Flow Designer, Launcher, Management Console, and Resource Registry.

Catholic Health East

Role:WTX Trainer/Developer

Location:Philadelphia, PA
Duration:1 week, March 2009
Technology:WTX

Responsibilities:

  • Developed 834 eligibility in WTX 8.1 with copybook input and 834 output.
  • One week class on WebSphere TX 8.1 Type, Map, Database, and Flow Designers as well as HIPAA and UltraEdit.

Architect and Developer Projects

Group Health Coop

Role:WTX and WMB Developer and Architect
Location:Seattle, WA
Duration:November 2009 – Present, June 2009 – August 2009
Technology:WTX 8.0/8.1/8.2, WMB 6.1.0.4, HIPAA, Agile environment

November 2009 – Present

Large migration project migrating all HIPAA transactions from Commerce Manager/ Event Server (Launcher) to WebSphere Message Broker.Responsible for migrating 14 interfaces for both real time and batch including 270/271, 276/277, 278’s, 835, 837i, and 837p. The majority of code we migrated was originally developed in 2003 using IFD and WTX. We used WTX 8.1 & 8.2 on WMB 6.1.0.5.

  • Developed 835 flow on WMB using WTX with capability of processing 2 gigabyte flat files to X12 through WMB in less than 5 minutes.
  • Developed 835 (three flavors) out of balance flow & map that creates a report and sends an email with the body containing the report and X12 as an attachment.
  • Developed 837I/837P (three flavors)inbound & outbound batch flow & maps.
  • Developed 270/271inbound & outbound real time & batch flow & maps.
  • Developed 278 (four flavors) inbound & outbound real time flow & maps.
  • Developed 276/277 inbound & outbound real time & batch flow/maps.
  • Developed encryption PGP common flow & maps.
  • Developed decryption PGP common flow & maps.
  • Developed X12 router and FTP common flow & maps.
  • Developed Remit Splitter flow/maps that split by date as well as Claim ID/CLP01
  • Developed 835 5010 inbound & outbound batch flow/maps.
  • Developed 837I/837P 5010 inbound & outbound batch flow & maps.
  • Developed 270/271 5010 inbound & outbound real time & batch flow & maps.
  • Developed 278 5010 inbound & outbound real time flow & maps.
  • Developed 276/277 5010 inbound & outbound real time & batch flow/maps.

June 2009 – August 2009

GHC’s claim line expansion project called for their 835 and 837 maps to be rewritten in order to allow for more healthcare lines and several expanded fields:

  • Developed new 835 tree based on “expanded” copybook.
  • Developed six 835 WTX version 8.0 maps based on new copybook.
  • Developed new 837 tree based on “expanded” copybook.
  • Developed new 837 WTX version 8.0 map based on new copybook and combined logic from several existing maps.

Home Depot

Role:WTX Developer
Location:Atlanta, GA
Duration:2 months, September 2009 – Present
Technology:WTX 8.0, WMQ, WMS

  • UpdatedWTX maps based on new business requirements and change requests to process ASN’s from MQ as a part of The Home Depot’s aggregation and allocation supply chain solution.

Rent A Center

Role:WTX and WPG Developer
Location:Dallas, TX
Duration:1 month, August 2009
Technology:WTX, WPG

  • Updated 850, 855, 856, 860, and 865 maps in both 4010 and 4030.
  • Knowledge transfer of all maps and RAC WTX processes such as deployment.

Technocrats Domain

Role:XSLT and WTX Developer
Location:Atlanta
Duration:4 months, February 2009 – Present
Technology:XSLT, WTX

Responsibilities:

  • Developed XSLT tool to migrate from WTX trees to BizTalk schemas
  • Developed XSLT tool to convert XML to HTML to document WTX maps
  • Developed XSLT tool to convert XML to HTML to document WTX trees
  • Developed XSLT tool to convert XML to HTML to document WTX systems
  • DevelopedWTX tool to translate 4010 HIPAA datato 5010 data

Principal Financial Group

Role:WTX Architect/Developer

Location:Des Moines
Duration:4 Months, November 2008 – February 2009
Technology:WTX

Responsibilities:

  • Designed, developed, and implemented 2 WTX systems and 10 WTX maps to populate a DB2 Healthcare ODS with XML messages composed of 48 tables.

Synapse Group (Time, Inc.)

Role:WTX Architect/Developer

Location:Connecticut
Duration:2 months, September 2008 – October 2008
Technology:WTX

Responsibilities:

  • Upgraded and redesigned multiple systems comprised of 100 maps from WTX 6.5 to WTX 8.2.0.3

The Home Depot

Role:WTX Architect/Developer

Location:Atlanta
Duration:18 months, February 2007 – August 2008
Technology:WTX, WSDL, XML

Responsibilities:

  • Designed and developed WTX maps based on business requirements to process cobal ASN’s from MQ as a part of The Home Depot’s allocation and aggregation supply chain solution. The process consists of 12 maps and 2 systems that have XML and a copybook representation of the 856 as inputs, transformed to canonical XML, loaded to an allocation database, and sent to Manhattan Associates WMS system.
  • Designed and developed a web service consumption system of maps and IFD’s to process an MQ message, consume a web service, and handle errors/retries.

Principal Financial Group

Role:WTX Developer

Location:Des Moines
Duration:3 weeks, January 2007
Technology:WTX

Responsibilities:

  • Developed DataStage TX 8.0 HIPAA transactions including 271, 277, 835, 837P, and 837I mapped from cobal copybooks to X12.

HMSA (BCBS Hawaii)

Role:WTX Developer

Location:Hawaii
Duration:9 months, May 2006 –January 2007
Technology:WTX, BizTalk 2006

Responsibilities:

  • Worked on a team of WTX and BTS 2004 developers to develop BTS processes for their HIPAA transactions as well as proprietary formats.
  • Developed BTS 2004 process to split ITS SF files using schemas, pipelines, maps, and orchestrations.
  • Developed Migration Pack to automate the process of migrating from WebSphereTX to BizTalk Server.
  • Developed several automated documentation tools in XSLTfor Mercator 6.7+ (trees and maps) as well as BizTalk 2006 R2 (maps, schemas, orchestrations, pipelines)

Blue Cross Blue Shield North Carolina

Role:HIPAA/WTX Developer and QA

Location:ResearchTrianglePark
Duration:3 years, April 2003 – April 2006
Technology:WTX, SeeBeyond, Java, WinRunner

Responsibilities:

  • Used expert knowledge of HIPAA, X12, EDI, CLAREDI, and IG on a SeeBeyond team to test for HIPAA compliance.
  • Responsible for 270, 271, 276, 277, 278-13, 278-11, 835, 837I & 837P compliance, 837 DB2 Repository, and flow of X12 and proprietary data (UNIX, FTP scripts, JCL).
  • Automated test data creation and data submission for all BCBSNC input types (proprietary and HIPAA X12) using Mercury WinRunner and batch files.
  • Responsible for all BCBSNC code set testing for ICD-9, HCPCS, and CPT.
  • Side projects while working at BCBSNC:
Principal Financial Group – September 2005 – December 2005
  • Developed DataStage TX 8.0 map for HL7 2.3.1 as input mapping to cobal copybook output.
Longview Fibre Company (Manufacturing) - March 2004 - May 2004
  • Developed Mercator 6.7 Positive Pay system of maps including 824 X12 Detailed Acknowledgement Transaction, 828 X12 Check Issue Transaction, and 997 X12 File Acknowledgement Transaction
  • Integrated with LFC's JD Edwards System (with Oracle9i) and Bank of America.

Bellsouth (Telecommunications) - September 2002 - March 2003

  • Development of Mercator 6.5.2 maps to/from XML to/from EDI. Responsible for updating 850, 855, 860, 865 maps to/from XML and EDI.
  • Trained development team on XML W3C recommendations including XML Schema, XSL, DTD, XML syntax.
  • Developed XSL style sheets to transform Mercator map exports to HTML for documentation using Saxon's XSLT engine.

Blue Cross Blue Shield of Hawaii/HMSA (Healthcare) - January 2002 - July 2002

  • Used HIPAA expertise on a Mercator team (version 5.0 with HIPAA 2.0) responsible for testing to ensure HIPAA compliancy of all transactions.
  • Writing and documenting test cases designed to ensure HIPAA compliancy.
  • Developing large amounts of test data to test each individual HIPAA field.
  • Answered e-mails and attended meetings where I explained HIPAA Implementation guides and answered questions about HIPAA transactions.
  • Used Commerce Broker components, including Partner Manager and Message Manager, on a daily basis for testing HIPAA transaction compliancy.
  • Wrote XML based spec development map to ensure type tree’s were compliant.
  • Wrote training material to transition project from consultants to employees.

Amisys (Healthcare) - September 2001 - December 2001

  • Development of HIPAA Mercator validation maps to audit HIPAA transactions including 270, 271, 275, 276, 277, 278, 834, 835, 837 I/P/D, and 997 using Mercator 5.0 and HIPAA 1.0 type trees for UNIX environment.
  • The series of maps was designed to process invalid files entirely to determine and report all invalid elements, segments, and loops. A written report with each invalid occurrence, along with summary totals, was produced as well as a 997 with audit information.

Bellsouth (Telecommunications) - June 2001 - September 2001

  • Developed of Mercator 5.0 maps to read inbound feeds, validate data, transform data, and load data into Oracle8i database comprised of over 40 tables.
  • Utilized all components of Mercator including Commerce Broker, Partner Manager, Message Manager, Integration Flow Designer, Map Designer, Type Designer, & and Database Interface Designer and mentoring others on each component.
  • Developed training material and training class on Mercator 5.0, spec development, and XML and provided documentation for Mercator maps.
  • Developed Perl and KSH shell scripts.

Department of Defense (Healthcare) - January 2001 - May 2001

  • Development of Mercator maps for Department of Defense Military Healthcare System using Mercator 5.0, DB2, & IBM’s Retail Interchange on AIX Platform.
  • Maps loaded data to a DB2 repository; was validated against cross-reference tables containing HIPAA compliant codes, valid provider IDs, and Eligibility & Enrollment data; and invalid files were routed to error tables for augmentation.
  • ADP2 security clearance obtained.

First Union (Banking) – January 2001

  • Trained Mercator 1.4.2 concepts and worked with employees to make maps more efficient using control break logic.
  • Outlined migration strategy using new Burst mode functionality available in Mercator 2.0 Map Designer.

Blue Cross Blue Shield of Georgia (Healthcare) - February 2000 & September 2000

  • Developed Mercator 5.0 map that processed inbound 837I X12 data and transformed this data to UB92 5.0 output data on MVS along with a 997.
  • Responsible for updating map to UB92 6.0.

The Boeing Company (Aviation) - May 2000 - August 2000

  • Development and support of 36 Mercator 1.4.2 maps for ECXpert & TradingXpert.
  • Responsible for developing eight Mercator 1.4.2 maps (EDI, HTML, & Oracle8i) to be used in conjunction with ECXpert 3.0 and TradingXpert.
  • Developed training materials on spec writing for Mercator 5.0 maps.

S2 Systems (Healthcare Clearinghouse) - April 2000

  • Gap analysis and documentation of Mercator 1.4.2 mapping of a UB92 version 5.0 to an 837I and from an 837I on MVS.
  • The overall project involved the development of specifications for several formats of both inbound and outbound healthcare transactions.

Progressive (Insurance) - March 2000

  • Trained IS department on Mercator 1.4.2 maps which mapped from/to Oracle8.
  • Training included tutorial on Mercator’s Map Editor, Type Tree Editor, and Database Interface designer and also provided detailed documentation of their Mercator 1.4.2 system of maps.

PGA Human Resources - March 1999 - November 1999

  • Developed Mercator 1.4.2 maps to integrate multiple databases into PGA's database.
  • This was an excellent first project to have as a new Mercator developer since it allowed me to use most of Mercator’s functions in order to extract, transform and load the data from one database to another.

Other Projects and Development

For more information please see:

Web Based NPI Check Digit Calculator – August 2005

Used PHP to develop a web-based, NPI check digit calculating tool. Developed for BCBSNC to find check digit using CMS final rule on National Provider Identifier based on Luhn algorithm.

Web Based Text File Unwrapping Tool – July 2005

Used PHP to develop a web-based, text file unwrapping tool. Developed for BCBSNC to unwrap X12 files with a segment delimiter of a tilde, however, customizable.

XSLT SVG Diagrams from Mercator XML Export – August 2005

Developed XSLT code to visually document Mercator maps in SVG (scalable vector graphics) for Mercator 6.7 using the export map function as the input to the stylesheet.

HTML/XSLT Documentation from Mercator XML Export – November 2004

Developed XSLT code to visually document Mercator maps in HTML (a web page) for Mercator 6.7 using the export map function as the XML for the stylesheet.

Visio Diagrams from Mercator XML Export - January 2003

Developed a system of Mercator maps that builds Visio diagrams using the Mercator export map function as the input to the Mercator maps.

Visio Diagrams from Specifications on Excel - February 2003

Developed a system of Mercator maps that builds Visio diagrams using Specifications on a template Excel spreadsheet as the input to the Mercator maps.

XML Specifications Writer - Jan 2000 (Initial development)

Developed a system of maps that create specifications to document Mercator Type Tree export files in Mercator 1.4.2, 2.0, 5.0, and 6.0. Created a system of maps that document Mercator maps in Mercator 6.0 with the export map function.

XML Type Tree Builder - Jan 2000 (Initial development)

Developed a system of maps that automates the process of building Mercator Type Trees from specifications written on an Excel template. These specifications are extracted and used to create command files that automate Mercator Type Tree building. Benchmark: proprietary Type Tree building time cut from 3 hrs to 30 minutes.

Corporate Training Material Development - Jan 2000 - Feb 2000

Developed training material for Mercator 1.4.2 in PowerPoint that consisted of training manuals and slide presentations. The training material consisted of over 200 PowerPoint slides accompanied with "Notes Page view" handouts for each slide.

SkillsetSummary

Translators & Middleware

  • Expert Knowledge of WebSphere TX 8.2 Design Studio including Map, Tree, Database, and Flow Designers since version 1.4.2 as well as Message Broker.
  • Expert knowledge of WTX in a WebSphere MQ environment
  • Expert knowledge of WTX in a web services environment
  • Intermediate knowledge of BizTalk 2006 R2, SeeBeyond ICAN 5.0.5, Contivo, Gentran, AI, Harbinger, Tibco, WebMethods, WinMap, ECMap

HIPAA/Healthcare

  • Expert knowledge of Washington Publishing Company’s Implementation Guides
  • EDISIM, Edifecs, CLAREDI trained/certified on all HIPAA/EDI web tools
  • Experience with code sets: ICD-9, HCPCS, & CPT
  • Experience in PowerMHS, QCSI QNXT & QMACS

EDI Transactions: X12: 270, 271, 276, 277, 278-13, 278-11, 810, 811, 812, 820, 821, 822, 823,824, 828,830, 831, 832, 834, 835, 837I, 837P, 837D, 846, 850, 852, 855, 856, 857, 860, 861, 862, 864, 865, 870, 871, 888, 997

EDIFact: APERAK, DELFOR, DELJIT, DESADV, INVOIC, ORDCHG, ORDERS

Testing Applications:

Mercury TestDirector, Mercury WinRunner, Mercury LoadRunner, PVCS Tracker

Web:

PHP, HTML, Javascript,ASP, VS.NET, SharePoint, InfoPath

Standards/Formats:

ANSI X12, EDIFact, SAP R/3 IDocs, HIPAA, NSF, UB92, HCFA, HL7, SWIFT

Platforms:

Windows, UNIX, Solaris, AIX, LINUX, Mainframe (TSO, ISPF, IOF, some JCL)

Applications:

Altova XML Suite 2006, Stylus Studio, MS Office, MS Project, MS Visio, UltraEdit

RDBMS & Tools:

DB2, SQL Server, Oracle8i/9i, MySQL, MS Access, SQL*Plus, TeraData, TOAD

Languages:

  • Expert:XML, XSD, XSLT, HTML, SQL, PHP
  • Intermediate:Java, C#, C++, VB, AJAX

Scripting:

UNIX Shell/KSH, Python, Perl, Batch Files, JavaScript, VBS, WinRunner TSL

ERP:

SAP R/3 4.6b

IDocs: DELFOR, DELVRY, ORDERS, MATMAS, ZSTATS, WMIVID, WMMBID, BOMMAT, GSVERF

Security Clearance:

ADP2 security clearance obtained while working for the Department of Defense.

Industries:

Automotive, Aviation, Banking, Energy, Finance, Government, Healthcare, Insurance, Manufacturing, Telecommunications, Technology

Education and Training

Microsoft BizTalk Server 2004 – November 2005

  • Developing E-Business Solutions (MS-2157)
  • Deploying and Managing E-Business Solutions (MS-2158)

Microsoft BizTalk Server 2004 – November 2005

  • Developing HL7 Solutions

WinRunner 7.6 Introduction and Advanced Training - Fall of 2004

Claredi Training – September 2002

Mercator Advanced Training - taught by EDI/EC Services (

Mercator Commerce Broker Training - taught by EDI/EC Services (

PaperFree - Received week long training on PaperFree’s WinMap

Bachelor of Science in Business Administration, University of Wisconsin Stout -1995