Summary

• Over 35 years experience in Information Systems specializing in analysis, development and support of applications. Have a thorough knowledge of the Systems Development Life Cycle SDLC which includes analysis, design, programming, testing, and implementations of systems utilizing EDI, DB2, CICS, JCL, and COBOL. Possess excellent communication, analytical and problem solving skills.
• SYNOPSIS: Senior EDI Developer/Maintenance System Development Senior Specialist Senior Programmer Senior Analyst Developer DB2 Manager/DB2 Database Administrator Systems Analyst Project Leader
• Software: Access, SQL Server, Oracle, Harvard Graphics, Word, Excel, Project, Oracle, PowerPoint, Visio, WordPerfect, Oracle Designer 2000, Oracle Developer 2000, Oracle Import/Export, Platinum Explain, Oracle WebServer, SDLC, SYBASE EDI Mapping Translation tools
• Hardware: Honeywell Mainframes, IBM mainframes, IBM Compatible PC's
• Operating Systems: 30XX, OS390, Z/OS, DOS, MS Windows95/NT/98/ME/2000/XP, ANSI X12
• Programming APS, COBOL, COBOL II, CICS, Easytrieve, Focus, DB2, IMS DB-DC,
• Languages: Oracle PL/SQL, Oracle SQL Plus, Quickjob, SAS, VSAM, HTML, FrontPage
• Other: CASE Tools AEW, IEW , CEDF, CEMT, DB2 Utilities, EDI ANSI Translator Sybase ECMap Paperfree , Edit, Expediter, MS Edlin, Omegamon for DB2, SQL Loader, TOAD, LU6.2, ProComm Plus Scripting, M D package

Employment History

Confidential

System Development Senior Specialist

• Performed data repository analysis for the retention of EDI data.
• Developed documentation for the retention of ANSI X12 EDI data both on and off-site.
• Ensured the company met the SLA's Service Level Agreements on receiving, processing, and delivering EDI message between the State of VA DMAS Department of Medical Assistance Services and ACS and back.
• Monitored the health of both the production and test EDI servers.
• Responsible for keeping management informed of issues/concerns of the EDI operating system and platform infrastructure.
• Advised users and customers on interpretation of EDI Implementation and Companion guides.
• Developed and maintained DB2 COBOL, COBOL II, and CICS programs to update and query proprietary databases. Created JCL and PROC's.
• Presented Status Reports to management on a regular basis.

Environment: Windows Server, Sybase proprietary software, Mainframe Z/OS, CICS.

Confidential

Senior Programmer

• Tested new releases of the runtimes on desktop prior to rollout to the various development / production environments.
• Designed, developed, tested, and installed the Sybase ECMap Paper Free maps for 270, 271, 276, 277, 835, 837, and the Pre-Adjudication edits. Added home grown HIPAA Code Set logic to all the 837 maps.
• Participated in JAD sessions, and was the point person between Anthem and Sybase.
• Responsible for keeping management informed of upcoming releases from Sybase whether it was runtimes or HIPAA Accelerator.
• Presented Status Reports to management on a regular basis. Worked on both the McKesson and Unique Identifier projects. Supported the GA mainframe systems 835/837.
• Wrote and maintained DB2 CICS COBOL programs that interfaced with the EDI data.

Environment: Windows Server, Sybase proprietary software, Mainframe Z/OS, CICS.

Confidential

Senior Analyst Developer/Consultant

• Participated in Joint Application Development JAD sessions with the DEQ user community staff. Presented status reports to IT management on a regularly scheduled basis.
• Converted Oracle Forms 5.0 to 6i, and Oracle Reports from 3.0 to 6i.
• Using System Development Lifecycle methodology, modified, developed and tested form modules in both 5.0 and 6i using Designer 2000, and Developer 2000.
• Wrote Packages and Stored Procedures for use by Oracle Forms and Oracle WebServer.
• Utilized MS FrontPage wrote HTML code for the Domestic Sewage Discharge Registration System.
• Wrote and maintained DB2 CICS COBOL programs that interfaced with the EDI data.

Environment: Oracle Designer 2000, Oracle Developer 2000, Oracle PL/SQL, Oracle SQL Loader, Oracle SQL Plus, Oracle WebServer, Windows NT, Mainframe Z/OS, CICS.

Joseph C. Goldsby page 3

Confidential

Senior Analyst Developer/Consultant

Modified and developed Oracle programs in support of the Juvenile Justice Systems utilizing Oracle SQL and PL/SQL.

Used Visio to document the process flow for management.

Environment: Oracle SQL, PL-SQL, Visio

Confidential

Project leader for the AccuRay, and Equipment Manager Systems

• Responsible for analyzing, documenting and converting flat files, programs, Focus files, SAS programs, Easytrieve files, IMS files and DB2 tables to make them century compliant for an entire system which was comprised of over 200 IMS MPP programs, and over 450 SAS-SAS/AF programs. Presented status reports to IT management on a regularly scheduled basis.
• Analyzed user requirements and made enhancements to SAS, SAS/AF, APS IMS MPP DB2 COBOL, COBOL II, and Focus programs for the Quality Assurance System for over twenty-five customers in the U.S. and Asia.

Environment: COBOL, COBOL II, DB2, EasyTrieve, Focus, IMS DB/DC, Access, Project, SAS

Confidential

EDI Analyst / DB2 Manager / DB2 DBA / Senior Programmer / Systems Analyst

EDI Analyst

• Responsible for evaluating various mapping tools as well as for the design and setup of communication protocols and scripts.
• Mapped ANSI 270, 271, 276, 277, 278, 835, 837, 864, and 997 transaction sets to trading partner specifications.
• Built, tested/debugged and supported all ANSI maps for all trading partners.
• Wrote ProComm Plus scripts to dial in to the customer's networks to upload and download data.
• Attended EDI DISA conferences.

Database Administrator

Administered twelve DB2 databases for medical claims clearinghouse using DB2 releases 2.2, 2.3, and 3.1.

• Responsible for debugging, administrating and tuning 400 tables which heavily used Referential Integrity RI . Successfully designed and implemented a database archiving system.
• Designed and implemented a disaster recovery system.
• Wrote SAS jobs to monitor and report on the status of databases and table spaces.
• Joseph C. Goldsby page 4
• Developed QMF queries for end users that could run in a real-time or batch environment.
• Tuned Application Programmers SQL using DB2 Explain and Platinum Explain.
• Attended IDUG conferences. President of the Richmond DB2 Users Group RICDUG .
• Trained and managed one other DBA.
• Presented status reports to user and upper management on a regularly scheduled basis.
• Systems Analyst, Programmer Analyst
• Designed the Data Reporting System using CASE tools.
• Developed and programmed using COBOL, COBOL II, and used DB2 as the platform.

Environment: CASE Tools, COBOL, COBOL II, CICS, DB2 DBA, DB2 SQL, DB2 Utilities, EDI ANSI Translator Sybase ECMap Paper free , Project, Omegamon for DB2, Platinum Explain, ProComm Plus, SAS

Confidential

Project Leader / Programmer/Analyst

• Server on various projects of increasing complexity.
• Utilized SDM and CASE tools for designing systems, resulting in a substantial cost savings to the company.
• Due to intense and thorough analysis, several major production file update run times were reduced by 67 by utilizing a more efficient VSAM access method.
• Supported the Accounts Payable M D package in an ever changing retail environment.

Environment: Project Leader, CASE Tools, M D Accounts Payable Package, COBOL, CICS, QuickJob, Focus, Project