Barry DeBruin



Barry DeBruin

barry@

919-434-5399

Senior HIPAA QA tester, SME, and BA

Senior QA tester, SME, and BA specializing in test data creation, test case automation, WinRunner, HIPAA, EDI, XML, and SQL. Also have over 10 years of WTX experience as a developer, architect, trainer, and QA.

Experience

QA Tester: 4 years on 3 projects

HIPAA: 9 years (February 2000)

Healthcare: 9 years on 7 projects

WebSphere TX: 10 years (February 1999)

EDI: 11 years (February 1998)

XSLT: 5 years (November 2004)

XML: 9 years (January 2000)

Training Projects

Logica

Role: WTX Trainer/Developer

Location: Cardiff, Wales, United Kingdom

Duration: 1 week, April 2009

Technology: WTX

Responsibilities:

• Gave a 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

Duration: 1 week, March 2009

Technology: WTX, HIPAA, Test Director, WinRunner

Responsibilities:

• Developed 834 eligibility in WTX 8.1 with copybook input and 834 output.

• Gave a one week class on WebSphere TX 8.1 Type, Map, Database, and Flow Designers as well as HIPAA, Test Director, and WinRunner.

Architect and Developer Projects

Group Health Coop

Role: WTX and WMB Developer

Location: Seattle, WA

Duration: 2 months, June 2009 – Present

Technology: WTX, WMB, HIPAA, Agile environment

Responsibilities (below):

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. My responsibilities included:

• 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.

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

• Developed WTX tool to translate 4010 HIPAA data to 5010 data

Principal Financial Group

Role: WTX Architect/Developer

Location: Des Moines

Duration: 4 Months, November 2008 – February 2009

Technology: WTX, Test Director

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, Test Director, WinRunner

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, Test Director

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, Test Director

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 WebSphere TX to BizTalk Server.

• Developed several automated documentation tools in XSLT for Mercator 6.7+ (trees and maps) as well as BizTalk 2006 R2 (maps, schemas, orchestrations, pipelines)

Blue Cross Blue Shield North Carolina

Role: HIPAA QA Tester and BA

Location: Research Triangle Park

Duration: 3 years, April 2003 – April 2006

Technology: WinRunner, QTP, Test Director

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.

Visteon / Ford (Automotive)

September 2000 - December 2000 - Supported migration efforts from Mercator to Harbinger when Visteon determined the need to replace ECXpert/Mercator with Harbinger.

Oct 1999 - March 2000 - Integrated Mercator 1.4.2 and Netscape’s ECXpert tool for SAP R/3 4.6b. Developed 42 EDI/IDoc Mercator maps for the integration of SAP R/3 and Mercator. Used SAP on a daily basis to extract IDoc parse files to build trees.

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 a complete list 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.

Skillset Summary

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, , 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

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download