James H. Winstead

Dallas, TX *****

972-***-**** – Home

214-***-**** - Cell

add168@r.postjobfree.com

SUMMARY

20+ years business analysis and implementation

Multiple databases – IMS/DB2

15 Years DB2 including stored procedures (Cobol/Procedural Language)

DB2 SQL Performance Tools (Visual Explain, Quest)

Multiple versions of Cobol

ALC (Assembler)

10+ years CICS

IBM utilities and JCL

20+ years VSAM

Librarian, Panvalet and Changman

Mainframe de-bugging tools – Intertest, File-Aid, Abend-Aid, Expediter, IStrobe

20+ years experience designing, implementing and maintaining computerized systems

Strong background managing multiple projects concurrently

Ability to meet deadlines within budget

Integrity, dedication, detail oriented, strong work ethic

ACCOMPLISHMENTS

Provided interfaces from DB2 mainframe tables to web applications using stored procedures (Cobol and Procedural Language)in a z/OS environment

Managed both large and small projects to develop and implement various types of applications

Implement and maintained Database Physical Model from a Logical Module

Enhance performance of SQL statements for both batch and web processes using Visual Explain, QUEST.

Created audit entries and ensured table validity for DB2 tables using triggers and foreign keys

Part of a team which provided income and savings of several million dollars a year for company

Enhanced Journal entry processing to provide expenses base upon fiscal date processing

Provided summary transaction information in DB2 tables for reporting

Set up EDI processing to send files to third party for processing of credit card transactions

Added capability to statement printing to dynamically include AFP page segment at execution time

Designed, coded, tested and implemented a new billing statement using AFP capabilities

Managed a team of analysts and users to design over 130 online screens for a utility company field service order system

PROFESSIONAL HISTORY

Programmer/Analyst

Health Management Systems 2016 - 2020

Researched, identified and corrected errors in production system modules have to do with the posting of medical cases and claims (COBOL/ and COBOL/DB2 modules).

Coded and install changes for processing requirements requested by clients.

Coded and install processing enhancements requested by clients.

Consultant

Burlington Northern Santa Fe Railroad 2012 - 2015

Reviewed errors with the posting of purchase orders, receipts, issues, and invoices and determine the cause to facilitate the posting of these documents.

Research and identify coding errors in production systems such as Travel Card and Safety Boots in COBOL modules.

Research problems that users are having with the production (COBOL/DB2 or COBOL/VSAM) environment.

Verify application software upgrades using DB2/SQL using SPUFI.

Consultant

Computer Saints 2010 - 2012

Review clients environment and made recommendations for changes to better support their environment

Evaluated PC problem for individuals and gave estimates and/or fixed identified problems.

Consultant

Texas Department of Public Safety 2006-2009

Implemented physical model from a logical model for a database of over 100 table which will contain approximately 2 terabytes of data (new Texas Driver’s License Database) after conversion for multiple environments (Development, Q/A, Migration, Stress Testing) in a DB2, z/OS environment

Kept both Logical and Physical modules in sync during concurrent design and development

Worked with the clients (ran JAD sessions and taught them how to run JAD Sessions) to produce the requirement documentation for migration all history information into the new database format

Wrote migration module using COBOL/DB2 to convert data from old environments into the new database environment

Provided support for the web and batch developers with performance tuning of their SQL statements using Visual Explain and Quest.

Consultant

JCPenney 2003 – 2005

Working in a z/OS environment wrote multiple stored in COBOL procedures to provide interfaces from web application to mainframe DB2 tables for both queries and updates

Worked with users to produce documentation for the employee benefits application

Created triggers on DB2 tables for table integrity and to create audit entries for all table update activity

Provided support for new functionality (stored procedures) for existing CICS modules and supporting batch modules

Senior Consultant

JCPenney. 1992 - 2002

Provided support for a large (JCPenney) private label credit card company

Part of a team which provided savings and income of several million dollars a year

Worked with JCPenney employees and outside vender to produce the requirements for the conversion of the JCPenney private label transactions into the format required for the outside vendor

Provided interface file of daily credit card transactions for sending to third party using EDI for processing

Provided summary files for determination of daily processing totals

Provided enhancements and modifications to support credit processing system including changes to support imbedded SQL processing

Changed customer statement processing to support dynamically include AFP page segments at execution time

Worked with various sections of the JCPenney Credit Department to document and implement required and requested changes to the JCPenney credit system

EDUCATION

The Atlantic Systems Guild

Modern Structured Design

TECHSKILLS, Inc.

Microsoft Certified Applications Developer

Microsoft Certified Solution Developer

Microsoft Certified Database Administrator

Contact this candidate