Data Developer

P.O. Box ****, Conyers GA *****•404-***-****•********.*******@*****.***

Terrance Casteal

Lead Integration Architect\Analyst providing middleware solutions with WTX and WMB.

Summary

Lead WTX development

WMB development

Lead EDI Integration & Implementation

ERP Integration

Lead Data Transformation & Development

Lead EAI Support and Resolution

Knowledgeable with EDI Standards (Edifact & ANSI)

HIPAA EDI Development (4010, 5010, and other standards)

Knowledgeable with Unix and Windows environment

Knowledgeable with Oracle, Sybase, DB2, and SQL databases.

Experience

Lead WTX Consultant\Analyst at CareCore National

August 2009 – March 2012 (2 years 7 months)

Designed ESB for integrating customer with enterprise backend systems

Developed maps in Websphere Transformation Extender 8.1

Lead development tasks with customer integration and understanding of system mapped elements for both XML and EDI efforts

Architected WTX infrastructure for maps with SOA design principles with SOAP\XML request and response

Configured WTX to integrate maps as a service for payer\provider relationships

XML to Java mapping to support internal applications

Architected database logging system for data recovery and error handling

Developed WTX maps to insert log records to database via stored proc

Designed EDI 278 request \ 278 response map for Americhoice integration

Designed EDI 270 request \ 271 response map for Harvard Pilgrim integration

Architected SOAP with XML package and DB lookup maps for Kaiser 270 integration

Designed EDI 270 request \ 271 response map to run as a Web Service for MVP integration

Enhanced and simplified maps for United 270 & 274 EDI process to act as a Web Service

Developed Wellcare DB to XML map to retrieve 278 data over SOAP

Implemented Resource Registry, advised of best practices and correct implementation uses

Installed and setup new server with WTX 8.3 software for new migration environment

Enhanced Blue Cross Blue Shield of Alabama 270 & 271 EDI maps for new requirements and Database logging.

Developed FTP map to retrieve files from Americhoice FTP site

Direct customer support to assist with customer integration needs and standards

Provided gap analysis for internal formats to provider EDI and XML formats

Extensively worked on 837,270, 278, 276, 834 both Batch and Real Time HIPAA X12 EDI Transactions

Lead WTX Consultant\Analyst at Encode (IBM Consulting Services)

October 2011 (2 weeks)

Belk (Charlotte, NC)

Installed and configured WTX 8.3 on AIX to integrate with Websphere Message Broker 7.0

Configured and verified WTX connectivity with DB2 database

Documented install configuration and map connectivity

Documented design aspects for use of WTX with WMB

Lead the effort to understand WTX integration role and fit into Websphere product sphere

April 2011 – June 2011

Blue Cross Blue Shield of Michigan (Novi, MI)

Tested and Corrected WTX audit maps for HIPAA transactions

Lead efforts for WTX error handling for 997 and 999 implementation

Adjusted Websphere Message Broker flows for new WTX mapping tasks

Corrected HIPAA 277 5010 map

Analyzed 277 map and implemented process to cut map run time from over an hour to minutes

Created HIPAA 837 5010 map

Integrated WTX maps with Websphere Message Broker

November 2010 - April 2011

Bank of New York – Mellon (Wayne, NJ)

SWIFT / FpML implementations across international markets utilizing WTX in a MVS/CICS environment.

SDLC processing for DEV/QA/Production within international banking guidelines of SWIFT.

Database SQL to FpML via Websphere Transformation Extender in a CICS environment.

Cross Platform integration of data via MQ series queues.

Lead efforts to simplify WTX rules that were reusable in current architecture

September 2010 – October 2010

Massachusetts Department of Public Health (Boston, MA)

Architected audit infrastructure to alert team of HL7 errors

Configured Audit Log to capture all incoming HL7 formatted data

Map audit log info for invalid HL7 data fields to customer specified error message

Designed maps to generically reject all other messages that do not represent HL7 format

Mapped HL7 2.51 QBP, RSP, VXU messages to internal XML format

Provided Training session to go over developed EMH solution and show DPH developers how to extend solution

August 2010 – OCT 2010

Blue Cross of Southeastern Pennsylvania (Wilkes-Barre, PA)

Supported Install of WTX 8.3 on Linux

Lead conversion of HIPPAA 4010 to 5010 EDI standard in WTX

Developed HIPPAA 5010 277CA

Advised of best practices to shorten map conversion lifecycle.

Daily support and resolution for defect EDI transactions

May 2010

Prescription Solutions (Irvine, CA)

Lead WTX 8.2 Beginners and Advanced Training Class

Designed WTX map for integration into WPS that would split data at user defined point for handling of large files.

April 2010

Ingenix (Atlanta, GA)

Helped design and implement HL7 auditing system

Tested HL7 auditing system for bugs

Assisted with WTX coding for HL7 audit system.

Analyzed WMB flows for message pickup and data delivery

Lead EDI Developer\Analyst at Matrix Resources\ Carquest

June 2008 - December 2008 (7 months)

Developed maps in Websphere Partner Gateway

Developed mapping from Oracle Flat File to EDI 850

Corrected mappings from XML to EDI 850

Contacted suppliers to help guide through successful EDI 850 & 856 testing

Supported infrastructure in a Windows environment

Facilitated certification testing from development to production

Assisted with requested map changes

Mentored junior developers to transfer knowledge base and help them come up to speed on Websphere Partner Gateway

EDI lead for integration efforts with new suppliers to define onboarding timelines

Provided gap analysis for internal formats to provider EDI and XML formats

Configured Websphere Partner Gateway for the use of certificates with FTPS

Assisted users with administration and configuration issues of Websphere Partner Gateway

Senior Websphere TX\Datatstage TX Consultant at B2B Workforce\ IBM

January 2008 - May 2008 (5 months)

Architected WTX design to deliver extracted database data to business partner

Developed maps using Websphere TX versions 8.1 & 8.2

Developed mapping from Sybase to SAP IDOC

Provided gap analysis for DB to SAP IDOC format

Designed queries for specific customer information

Supported WTX infrastructure for term project

Provided after hours support for client maps in Unix environment

Developed mapping for Datastage process to use.

Installed product for both development and production use.

Data Integration Developer at Ultramatics\IBM\CareCore National

December 2007 - December 2007 (1 month)

Provided both in-house and off site support for WTX infrastructure and administration.

Advised configuration of Event Server\Launcher process along with the Launcher Agent as a

web service.

Configured Blue Cross Blue Shield of Alabama mapping to run as a webservice within the WTX architecture

Tutored developers on the use of WTX and advised of best practices

Provided Documented project specifics along with updated specifications

Data Integration Developer at Staffing Technologies\Home Depot

April 2007 - November 2007 (8 months)

Mapped data from proprietary flat file to proprietary XML

Provided gap analysis for internal formats to EDI, XML and SAP formats

Provided both in-house and off site support for WTX infrastructure in AIX environment.

Created WTX mapping that used various adapters efficiently

Provided DB2 queries for WTX map to run more efficiently

Documented project specifics along with updated specifications

Added development projects to Clearcase\Clearquest.

Worked with teams to provide timelines for mapping development to provide more realistic timelines

Converted SAP data to internal XML format.

Developed shell and perl scripts to generate error reports for internal teams.

Directly worked with suppliers to integrate into HD environment

Senior WTX Developer at IDR\ACS

September 2006 - April 2007 (8 months)

Mapped data from EDI HIPAA 837 to proprietary Cobol copybook format

Tested and verified data compliance of both the EDI HIPAA 835 and EDI HIPAA 837 transaction set

Designed maps to alert support teams when invalid data or technical issues occur

Configured and troubleshoot Event Server

Created WTX maps that mapped data from EDI HIPAA 837 format to internal layout

Created WTX maps for EDI HIPAA 824 to be sent to customer

Created WTX maps to convert NCPDP to flat file

Modified current maps to be more efficient for database lookups

Provided in house support for legacy maps in AIX environment.

Tutored developers on the use of WTX and advised of best practices

Architect/Developer at S3 Technologies

July 2006 - March 2007 (9 months)

Architected and designed integration solution to enter and retrieve SAP info

Mapped data from Oracle database to INVOIC01 IDOCS into SAP R/3

Manage IFD deployments, and batch script execution

Manage SAP gateway issues for outbound communication from R/3

Architect - Lead WTX Developer at Evergreen Investments

October 2005 - June 2006 (9 months)

Supported Sys*Admiral (Tidal Software) processes for daily trading activity.

Made database (Sybase, SQL 2000, Oracle) changes as requested

Supported Sun Unix with its data collecting scripts

Adjusted Mercator\Datastage TX mappings as specifications requested

Configured and troubleshoot Event Server and Launcher issues

Rotated on-call support within team for nightly processes.

Developed & changed stored procedures per requested specifications.

Lead Implementations Analyst at MDI Staffing\Ceridian Corporation

August 2005 - October 2005 (3 months)

Contract to provide expert analysis and support for software migration from Mercator 5.0 to

Datastage TX 7.5.1.

Documented processes to support migration that could be used in later migrations.

Wrote scripts to batch data and ensure successful testing.

Converted typetrees & maps from Mercator 5.0 to Datastage TX 7.5.1

Gave developers tips on what changes are in the new software along with "best practices" to

ensure efficiency in future implementations.

Provided certification documents on new environment.

Sr. EDI Analyst at UPS Supply Chain Solutions

December 2002 - August 2005 (2 years 9 months)

Designed ESB with Mercator maps to integrate customers with service level warehouses

Lead Mercator developer on projects

Support for other developers implementations

Lead support Analyst

Installs for Mercator (Ascential) software on HP-UX

Lead on map design and code implementations

Configuration of RMI Server with Weblogic 8.1 (Ascential 6.7 & 7.5)

Configured maps that connected to Java API’s

Developed testing plans for new architecture

Certified environments for architectures

Lead on project to convert maps from Mercator 5.0 to Datastage TX 7.5.1.

Lead on project to integrate transportation\warehouse info (EDI 110, 210, 214, 310, 410, 846, 850, 856, 940, 945, 997).

Integration project to insert customer data sent in Rosettanet XML into Oracle database.

Implemented batch scripts to pull data from Oracle database via Mercator and convert to XML format.

Commerce Manager setup and Maintenance.

Integration project to insert customer data sent in BOD OAG XML into Oracle database.

Tuned maps and environmental settings faster processing, and efficiency.

Implemented audit log process for error handling and map tracking.

Tester for Websphere Datastage TX 8.0 (Hawk) for IBM\Ascential.

EAI\EDI Implementations Analyst at Transportation Solutions

June 2000 - November 2002 (2 years 6 months)

Managed the entire EDI process from implementation to maintenance.

Assisted development of flat file format for internal use in logistics and procurement of external

customers.

Developed standards for processing information through EDI process.

Served as internal link for Carriers\Customer EDI integration .

Project management for data mapping and assisted development for logistics software.

Installs for Mercator on Windows 2000 environments.

Administrator for Event Server\Launcher

Developed Mercator EDI mapping of Flat File to EDI (ANSI X12), and EDI to Flat File, EDI to

Database (SQL 2000), Database to EDI, and Database to SAP IDOC.

Developed Mercator Maps to support customer’s Proprietary format to Flat File format.

Developed event driven maps.

Batch scripted maps to process data (1.42).

Fundamentals of Data Transformation class Jan 2001

Worked with EDI 110, 210, 211, 214, 310, 410, 850, 856, 997

Converted maps from Mercator 1.42 to Mercator 2.1

Converted maps from Mercator 2.1 to Mercator 5.0

Converted maps from Mercator 5.0 to Mercator 6.5

Software Analyst at Randstad Staffing Services

November 1999 - June 2000 (8 months)

Contractor for Harbinger EDI helpdesk

Certified EDI analyst (Harbinger).

Supported customers for internal link for software and supply chain.

Corrected EDI data for customers within ANSI standards.

Vantive case logging and problem tracking.

Provided quality solutions for software management and user support.

Personal Computer Telephone Service Engineer/ Call Specialist at ASI Services Corporation

July 1999 - November 1999 (5 months)

Contractor for BellSouth Internet Service helpdesk.

Lead call specialist.

Troubleshoot browsers (Netscape Navigator, Internet Explorer).

Supported Dial up Networking on Windows P.C.'s and RAS on NT.

Supported Apple internet connectivity.

Education

University of South Carolina-Columbia

Biology, 1994 – 1999

Contact this candidate