Colin Mcconnell Email and Phone Number

Collaborate with systems analysts, subject-matter experts, DBAs, business partners, and managers to implement business solutions. Build new and modify existing modules, batch and on-line programs, on-line CICS panels, on-line CTG programs, PROCs, and JCL jobs using COBOL, DB2, IDMS, and CICS. Create test cases; conduct unit, regression, user acceptance, and integration testing of new and updated components. Daily use of Abend-Aid, Expeditor, SPUFI, Platinum, CICS, File-Aid, ISPF TSO, SDSF, and PDS libraries. Frequent use of VSAM files, TDQs, $AVRS, HP Service Center, HP Quality Center, CA7 job scheduler, JOBDOC, and MKS Integrity.

Collaborate with systems analysts, business analysts, business partners, and managers to define requirements, outline specifications, and implement business solutions. Build new and modify existing modules and programs using COBOL and Easytrieve Plus. Create new and maintain existing JCL jobs. Create test cases; conduct unit, regression, and integration testing of new and updated components. Daily use of Abend-Aid, Expeditor, SPUFI, File-Aid, Easytrieve Plus, VSAM files, ISPF TSO, PDS libraries, and CA Endevor SCM. October 2010 - December 2010 - Horace Mann: HoraceMann.com rewrite. Integrate legacy mainframe Auto billing data from disparate legacy sub-systems with the new Horace Mann.com website. Conduct unit, regression, and user acceptance testing. Create new production exception report. 

January 2011 - April 2011 - Horace Mann: 2011 New Life Insurance products. Update existing mainframe Life system with new 2011 Life insurance products. Conduct unit, regression, and user acceptance testing. Developed new Assembler module for Group Enterprise COBOL conversion project.

Work with business units and fellow IT members on the design, analysis, and requirements gathering for system changes and new business functionality. Responsible for analysis, development, testing, long-term maintenance, and rotating on-call duties for Barge, Truck, and Rail Transportation systems (February 2001 - May 2004); and Truck and Rail Grain systems (May 2004 - August 2010). Handle project change requests as well as problem resolution (ABENDs and Infra tickets). Developed IT General Control documents for eADM, Edible Bean, and Grain; conducted an IT self-assessment for the e-ADM platform in conjunction with Internal Audit. Problem resolution often involved on-the-fly changes to COBOL programs and JCL; involving the use of Abend-Aid / Fault Analyzer, IBM Debug Tool / Expeditor, SPUFI, File-Aid, and DataVantage. Develop new and maintain existing batch and on-line IMS and CICS and DB2 COBOL programs, QuickJobs, and Easytrieve Plus members. Develop new and maintain existing JCL jobs. Daily use of ISFP TSO, PDS libraries, VSAM files, IMS, and DB2; including SPUFI and Explain. Tune IMS and DB2 applications to use efficient access paths.

Collaborate with systems analysts, business analysts, business partners, and managers to define requirements, outline specifications, and implement business solutions. Analyze business and system requirements in order to develop detailed specifications using full SDLC life cycle development. Build new and modify existing modules and programs using PL/I and DB2. Maintain existing JCL jobs. Use Panvalet to manage mainframe components and track version control. Create test cases; conduct unit, regression, and integration testing of new and updated components. Participate in walkthroughs and reviews. Develop and maintain documentation; such as design specifications, user manuals, and methodology documents. Design and conduct user acceptance testing and training. Daily use of ISFP TSO, PDS libraries, VSAM files, Panvalet, and DB2; including SPUFI and Explain.

Primary Duty: Patriot Missile CrewmemberResponsible for operation and care of vehicle and weapons system.Secondary Duty: Unit Logistics / Maintenance SpecialistMaintain database of unit vehicles, equipment, and weaponry.Daily reporting to unit and higher level commanders. Secret level security clearance. Honorably discharged September 1995.