Sql Server Data

Resume for David Byrd

Address:

**** **** ***** *****

Round Rock, TX 78681

United States

Resume on Dice : Resume

[pic]

E-mail: ***********@*****.***

Primary Phone: 512-***-****

[pic]

Facebook Account URL: David Byrd Face Book Page

LinkedIn Account URL: David Byrd Linked IN Page

[pic]

Education: Bachelors

School/Institution: University of West Florida

Authorization: U.S. Citizen

Desired position: Integration Consultant

Tax Terms: FullTime / Contract - W2 / Part-time

Hourly Pay Rate: Negotiable depending upon demand

Years Experience: 20

Recent Employer: QuickArrow / Leprechaun LLC / Toyota

Major Skillsets: Data Analysis and Integration, SQL, Reporting, Data

Junction V7.55 & Pervasive Data Integrator V8.x, V9.x

[pic]

Willing To Relocate: No

Willing To Telecommute: Yes

Willing To Travel: 50%

[pic]

Personal Summary:

[pic]

Business Intelligence Data Analyst / B2B / Data Integration &

Transformation

With over 20 years of systems and data analysis experience I have a proven

track record of managing the implementation of technology solutions to

success and completion. I am a proficient data integrator specializing in

EDI and Saas Webservices integration design with a comprehensive

understanding of complex business processes and a variety of application

development lifecycle methodologies.

Career Summary:

. Redesigned Salesforce to QuickArrow integration to use Webservices, and

then took it a step further to a real time integration between systems.

Designed integration system to be standardized for easy installation and

easy customization, maintenance and support.

. Designed, documented and developed a Pervasive / Data Junction process

scheduler, and file monitor which is the Pervasive / Data Junction

Professional Service team productized into the Data Hub Process.

. Earned SME status as a EDI integrator for the creation of a Enrollment

Processing system for the world's largest Payroll service provider

. Provided Business Intelligence reports for Fund and Broker analysis at

Putnam Investments aiding the company to rise to the top five Investment

company from 1995 to 2002.

. Increased value of integrations sold at QuickArrow from an average of

$2500 to $7500 while providing basically the same service, although

easier to implement, maintain and support, and at the same time the

integration provided the real-time synching between Salesforce and

QuickArrow

. Built packages in Salesforce platform that were certified for AppExchange

Employment History:

April - May 2010, Evariant.com

Senior Consultant

. Loading Healthcare Data into Salesforce.com, using MYSQL to prequalify

the data. Looking to design a repeatable, scalable integration

architecture solution for future customers.

Feb - April 2010, Leprechaun LLC

Senior Integration Consultant

. Reviewed specifications, and collaborated to build detailed

specifications for Phase 1 of the multitenant integration project to load

Member, Provider, Eligibility, Claims, and Pharmacy data from multiple

customers to load into an import system. The key here was a single code

base that use the headers of the file to dynamic map the data

appropriately (Note each customer had their own layout). .

. Worked with some CMS/RAPS data.

. Used Pervasive / Data Junction Integration Tool Suite & SQL Server 2005

Nov 2009 - Present Teksystems, Inc.

Toyota Motor Corporation Senior Integration Consultant

. Reviewed specifications, and collaborated to build detailed

specifications for Phase 1 of the Integration project.

. Designed, and Developed Integration to load data for Job Requests,

Strategies (Programs), and Plans (Projects) into Planview using the

Pervasive / Data Junction Platform to control the load.

. Used Pervasive / Data Junction Integration Tool Suite & SQL Server 2005

Dec 2009 - March 2010 -- Senior Integration Consultant QuickArrow, Austin

Tx

. Building final Integration for Health Strategies Group.

. Also did integration support & maintenance for issues.

. Used Pervasive / Data Junction Integration Tool Suite & SQL Server

2000

2006 - Oct 2009 Senior Integration Consultant QuickArrow, Austin Tx

. Created custom integrations for customers between Salesforce and

QuickArrow first using the SQL Stored Procedures, then using the newly

defined Web-Service layer.

. Design the integration a step further by making it real-time using

Outbound Messages in Salesforce.com.

. Develop and deliver data integration projects from requirements to

implementation; integrate data into a SaaS hosted web application from

front-end CRM systems and into a variety of backend financial

applications

. Initiated standard processes for implementing integrations including

source control, project timelines, task lists, approval processes and

supporting documentation

. Also did daily maintenance for issues, Project manage integrations

designed for our customers by third parties (Pervasive / Data Junction

Software).

. Used Pervasive / Data Junction Integration Tool Suite & SQL Server

2005

Dec 2006 - Aug 2009 Teksystems, Inc.

ADP Totalsource Senior Hipaa SME Consultant May 2006 - April 2007

May 2009 - August 2009

. Managed the requirements gathering, initial designs and testing for three

carriers. This included managing a business analyst brought on the

project specifically referred by me. Achieved June 30 deadline for

requirements and handed off the development team.

. Used Pervasive / Data Junction Integration Tool Suite & Oracle

Residential Credit Solutions, Inc. Senior Integration Consultant Jun

2007 - August 2007

. Specifically assisted with the File Monitor and Content extraction

reports

. Used Pervasive / Data Junction Integration Tool Suite & SQL Server

2005

Saxon Mortgage, Inc. Senior Integration Consultant February 2007 -

April 2007

. Built file monitor, modified Integration Processes and built Content

Extractor processes.

. Used Pervasive / Data Junction Integration Tool Suite & SQL Server

2005

Apr 2003 - Dec 2003 Senior Lead Integration Consultant DataJunction,

Austin TX

Dec 2003 - Dec 2006 Senior Lead Integration Consultant Pervasive / Data

Junction Software, Austin TX

. Development of Proof of Concepts, Database Design for Hipaa Transaction

Storage, ImplementationDevelopment of Proof of Concepts, Database Design

for Hipaa Transaction Storage, Implementation projects for databases

conversions, and Healthcare/HIPAA for the following companies:

. ADP Totalsource - 834 Outbound Project (4 carriers )

. Metlife - Swift transaction Processing

. PHCS - Health care Industry - Project Lead & Architect - Five month

assignment processing 271, 277, & 835 HIPAA Transactions and Claim Status

Loading from 837 data loaded into various systems on Windows & Unix

. California Department of Health Services - Health care Industry - Build

834 Hipaa Files from OS390 files. Run through JCL & Unix Systems

Services. Also Built 820 HIPAA Files from Data loaded into SQL Server

. Alianza Solutions/EDI Health care - Health care Industry - Project 1 -

Transformed 277 (4040) HIPAA files into CSV. Project 2 - Processed

multiple versions of Patient Statement Files to a standard format to send

off to PERSE Technologies.

. Florida Hospital - Health care Industry - Patient File Processing

. DOD Defense Logistics Agency - Govt - Lead major conversion project

. Northrup Grumman - Govt Contractor - Assisted in Architecture for new

internal projects

. Madison Gray LLC - Financial Analysis company - Training & and Initial

porject design

. ARinc - Military & Government contractor - Helped with severe Postgres

processing lag. Did full systems analysis on Database and Application.

System was missing indexes, and had extremely poor SQL calls in the

Application

. Matria - Health care Industry - Training course and System Optimatization

. PostNTrak - 837 Loader to a HIPAA designed Datawarehouse

. Gundersen Lutheran Healthcare Inc. - Design Database Warehouse for 270,

271, 276, 277, 278, 820, 834, 835, 837P, 837I, 837D. Finalized

Loaders to Process HIPAA Files to database

. Commercial Travelers Insurance - 835, 837P, 837I - Finalized Loaders to

Process HIPAA Files to database

. Information House - Built 834 file Builder

. Arrow International - EDI file Proccessing

. Entrieva - XML File Processing to Oracle Database

. CSC - Medical File Processing

. Database development and Integration involved, Oracle, DB2, SQL Server,

Postgres, Pervasive SQL,SQL, Sybase, and MySQL.

. Platform work was done for OS/390, Win NT, and AS-400 environments, as

well as AIX, Linux, and Unix.

. Used Pervasive / Data Junction Integration Tool Suite

. Other tools used: Q-designer, Erwin, ASP-Runner, Access, Excel,

Textpad, DJ 7.55, DJ-Cosmos, XML, ASP, Frontpage

April 1997 - Present Inventor Co-Owner 21st Century Technologies, Inc,

Austin Tx

. Conceived, designed, and invented illuminated Keyboard, keypad, and

illuminated mice technology.

. Specific skills used or acquired are Contract Negotiations, Vendor

Research and Contact, Intellectual Property Concepts and Terms, Project

Management, Marketing, Web Design, Customer Services and Public

Relations

Dec 2002 - Mar 2003 Focus Programmer Smith College, Northampton Ma

. Oracle/FOCUS Contract Programmer ? Responsible for the Maintenance and

execution of daily reporting needs for the Admissions department for

Smith College.

May 1995 - May 2002 DB2/FOCUS Business Intelligence Analyst Putnam

Investments, Franklin MA

. Responsible for the RAPID development of requested user queries.

. Job entails extreme multi-tasking abilities using efficient DB2 queries,

which sometimes had to handle 10-15 hot rush requests.

. For this main reason my knowledge of Relational Database Concepts were

tested thoroughly.

. I headed the implementation of using FOCUS over Easytrieve (with no prior

FOCUS training), and the report CONVERSION from Easytrieve to FOCUS went

very smoothly.

Aug 1994 - May 1995 Kloster Cruise Line, Miami FL CICS/COBOL Programmer

. Responsible for the development of several CICS screens, and the

development of several Client-Server transactions which processed

requests from the Leisure Shopper CRS system thru to Kloster and

eventually back to the CRS system.

. In addition, multiple reports were developed in COBOL. New tools used

include SDF II, File-Aid, Expediter, Elips., JobScan

Mar 1994 - Aug 1994 John Alden Life Insurance, Miami FL Easytrieve Contract

Programmer

. Responsible for developing a CONVERSION process for moving over fifteen

years worth of Easytrieve and SAS report programs into production.

. These programs were developed outside of a systems environment, and were

written by a non- programmer. CONVERSION involved analyzing the file

systems for optimmzation of the jobs, merging related report programs

using the same files, creating an automated date process, thorough

testing, and working with the quality assurance department for the

moviing the programs into production.

. In addition, I was responsible for any request for changes to existing

reports, especially the more complex requests. I also provided

Easytrieve training to a junior programmer.

. I also created a job to read the JCL and Easytrieve code and create a

runbook for computer operations automatically.

Jan 1989 - Apr 1994 Certified Vacations, Fort Lauderdale FL Programmer, &

Change Control Specialist

. Responsible for developing, maintaining GUI systems designed for a user

friendly OS/2 Presentation Manager system, EasyTrieve for reporting

development and support for entire company,

. Responsible for the development of the CICS- COBOL II Host transactions

retrieving data from DB2 necessary for the Agency Contract portion of the

OS/2 Presentation Manager Client-Server Cruise Reservation system.

. Developed a standard messaging system, designed extra screens as needed,

provided support when needed for multiple client "C" programs.

Responsible for the development of the Booking Remarks sub-system.

. Responsible for writing EasyTrieve custom reports for internal

departments as well as outside vendors such as Delta, and Continental

Airlines.

. Assisted users to write and debug their own EasyTrieve report for their

department. This includes providing standards and procedures, as well as

developing and teaching an in-house training program.

. Developed a batch system for a user to request certain price schedules

from the Reservations system, and made this data accessible for a CICS

transaction to run the data through the Reservations to obtain the

package price.

. Responsible for all duties associated with change control standards and

procedures. Provided any kind of support to the Quality Assurance and

Operations staff. Responsible for production scheduling, report

distribution. Converted manual schedule and report distribution to

JOBTRAC Scheduler and Infopac Report Distributor.

. Converted manual in- house tape Management system to CA-1 Tape

Management System. Responsible for testing batch process in a QA

environment. Developed a CICS transaction that took data from the Phone

system and updated the phone call information into the reservation

made.

Aug 1994 - Nov 1994 Bayshore Gallery, Niceville FL Database Programmer

. Responsible for creating a customer database, and provide Mailing Labels

for their annual show

Jan 1988 - Jan 1989 Florida SBDC, State Coordinators Office, Pensacola,

FL Database Programmer

. DBase III+ Programmed and maintained the State Coordinator's Office

Management Information System (SCOMIS). Prepared reports using Lotus and

Ventura.

Dec 1998 - Jan 1989 INACOMP, Fort Walton Beach FL Paradox Database

Programmer

. Completed a Customer Billing system in Paradox for a local newspaper.

October 1988 - January 1989 PC Magazine LAN Labs, Destin, FL

Technical Writer

. Reviewed several Network products and was published in several early

issues in 1989.

Mar 1988 - May 1988 Reichhold Chemical Inc. Pensacola FL Inventory

Control & Production Analyst

. Provided reports, and graphs to better manage the inventory levels of

chemicals stored and used at the Pensacola site.

Aug 1987 - May 1988 Univ of West Florida, Pensacola, FL Student Programming

Consultant

. Student Programming Consultant - Helped students who had problems with

their programs.

Nov 1986 - Jan 1989 Dr. Robert L. Dix, Niceville, FL Systems Consultant

. Assisted in purchase and staff training of a Dental Office billing

package. Also Provided DBASE III programs to support additional needs.

.

Education:

B.S. Business Systems Science, 1987 University of West Florida, Pensacola

Florida

. Graduate Level Coursework:

. Database Design, Artificial Intelligence, CASE Tools, Expert Systems,

Embedded Programming in Ada, Management Information Systems

A.A. Business Data Processing, 1986 Okaloosa Walton Junior College,

Niceville Florida

University of Texas at Austin Computer Science Major

Dean College, Fall 2000, Intro to E-Commerce Fall 1998, HTML & Web

Publishing

Palm Beach Community College, Spring 1991, Programming in C

Broward Community College, Fall 1990, CICS Programming

Florida Atlantic University, Fall 1989, Computer Law

Special Courses:

IBM, May 1989, DB2 and SQL Programming

Pansophic, Nov 1990, Basic EZTrieve Programming

Feb 1991, EZTrieve Programming with SQL

Florida Atlantic University, Spring 1992, Travel Industry Seminars

Caseworks, May 1993, CASE PM:VIP Training

Boston University, Sep 1995, Lotus Notes Basic End User

Sep 1995, Lotus Notes Technical End User

Roaring Mouse Technologies, Jun 1997, Telon Batch

Information Builders Inc., Jun 1998, Basic FOCUS Programming

Jun 1998, FOCUS Reporting Efficiencies for Relational Databases (DB2)

Apr 2001, In-house Introduction to Web-FOCUS

Sep 2001, Planning a FOCUS to WebFOCUS CONVERSION

Feb 2002, WebFOCUS Workshop: Self-Service Reporting & Managed Reporting

Environment

March 2003 - Data Junction Integration Toolset

March 2004 - What to say and when to Say it - Sales Training

November 2006 - Professional Speaking from UT

January 2007 - Salesforce Apex Administration Training

Foreign Language Skills:

Spanish 1, 2, & 3 in High School --- very limited

German ( lived in Germany 4 years) --- very limited

Technical Competencies:

Integration, Web-Services, Salesforce.com, Pervasive / Data Junction

Business Integrator, Database, SQL with SQL-Server, DB2, Oracle, and

Postgres. Mainframe, Cobol, Easytrieve, Focus

Publications:

PC Magazine - March 1989

The Register "Light up my keyboard"

KXAN Video: The Eluminx

Pervasive / Data Junction Articles mentioning my QuickArrow work...

Agile Integration Development:

Email Dev Hack:

Pervasive / Data Junction Case Study on Real Time Salesforce to QuickArrow

Integration forthcoming.

Contact this candidate