John R Hanrahan

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

Chesterfield Missouri 63017

636-***-****

314-***-**** cell

h9uds1@r.postjobfree.com

Summary

Experience as a manager of software engineers.

Experience as a Consultant in Project Management, Analysis, Coding, Design, Development, Documentation and Testing of application systems.

Experience in selling computer software and hardware to retail pharmacies.

Highly competent in designing and developing Database Applications.

Expert in designing applications.

Effective in communicating with users and management, and in supervision.

Technical Skills

Languages: COBOL-II, COBOL 390, Microfocus Cobol, SQL, JCL, VISUAL

BASIC ,and IBM 360/Assembly Language, C#

Environment: Windows 98/NT/XT, MVS, DOS, IBM ES/9000, IBM 3090,IBM,Z/Series CICS, and Unix

Databases: SQL Server,ORACLE, DB2, ACCESS, IDMS

Tools/Applications: CICS, JCL PROCS, VSAM, TSO/ISPF, QMF, SPUFI, FILE-AID, VIASOFT, XPEDITER, ENDEVOR CA-InterTest, Panvalet Roscoe, Vollie, SYSD, CLIST, ABEND-AID, FILE AID, DMLO, OLQ, PL-SQL, EDI

Professional Experience in Consulting

Client: EPC

Period: March 2008 - Present

Description: Made modifications to order entry system which included creating sales orders, keeping track of inventory and creating reports for new orders.Tools used were C#,SQL Server, SQL .

Client: Humana, Kentucky

Period: Sept 2007 - Mar 2008

Description: Made modifications to CMS new enrollment system which included changing reply codes transaction status, and reason codes. Added a new db2 table that will be used to hold the information. Changed CICS programs to show new information that is being captured. Help clean up problem tickets that had accumulated over the current year.

Client: Edward Jones, St Louis Missouri

Period: July 2006- July 2007

Description: Work on modifications to the Mutual Funs/Surpass project. Work on

writing a program to alert the on call and user when a file is been rejected

from NSCC. Created a CICS program for annuities to interface with java

front end and not return to the green screens. Used cobol, idms, db2 CICS

and jcl.

Client: USDA, St Louis Missouri

Period: May 2006- July 2006

Description: Reviewed over 160 programs that needed to be looked at to determine if modification were

needed. Made changes to over 40 programs and tested. Used cobol, idms, vsam, jcl..

Client: Media Services a division of Southern Living, Alabama

Period: Oct 2004 - March 2006

Description: Supported the Accounting systems for Southern Living at Home. Included working with SQL-Server, Visual Basic, Stored Procedures. Made enhancements to their current system and solved current problems to the system.

Client: Yum Brands, Kentucky

Period: Nov 2003 - June 2004

Description: Developing and testing a General Ledge conversion of GEACT files to a new format that will be fed into the People Soft system. Also fine tuning sql code to better execution of processes that load their Teradata warehousing system.

Client: Apollo Express, St Louis, MO

Period: Oct 2002 - Oct 2003

Description: Design and developed a distributing system for a small Trucking Company using visual basic and access. This system interfaced with their Quick Books accounting system.

Client: Missouri Department of Revenue, Jefferson City, MO

Period: Oct 1999 - Oct 2002

Description: Assisted team members in the design and development of a MotorFuelTax System. The

design consisted of documenting a manual system and developing a new Motor Fuel

Tax System. The Application used was Visual Basic, and Oracle on a Novell Server with

Crystal Reports. Grids were used with Visual Basic for data entry to utilize Excel’s

functions and capabilities. Developed the requirements and design document for the EDI

application. EDI standards were used to transmit the tax data from the Oil Companies to

the State Government. Developed the consumer credits processing and the screens that

allowed editing of the EDI data.

Client: Boeing, St. Louis, MO

Period: Oct 1994 - Oct 1999

Description: Work with the following software Cobol II, Cobol 370, EDI, DB2, 4GL, ISPF panels, DXT’s, QMF, ORACLE, IMS, Access, Excel, Word, and FTP. Designed and developed QMF query’s to pull data off the Mainframe and load data into access database file. Developed sub systems for the Scheduling system, Tooling system, Costing system, Shop floor system, and developed interfaces for a client/server MRP system. Converted two of their systems from Cobol II to Cobol 370. Developed the interfaces and edits for scheduling system that enabled communicate using EDI standards and Gentran Translator. Responsible for the requirements, specifications and implementation of EDI.

Client: Mooreman’s Manufacturing, Quincy, IL

Period: June 1994- Oct 1994

Description: Work with DB2, Cobol II, CICS. Coded, tested installed over 50 CICS and batch programs. Worked on CICS programs that interfaced with their PC software using DB2 files.

Client: BACG, Chicago, IL

Period: April 1994- June 1994

Description: Coded/tested/installed CICS programs to process new enhancements for discount systems. Lead the efforts for this project with two other members.

Client: Sigma Chemical, St. Louis, MO

Period: Jan 1994- April 1994

Description: Coded/tested/installed a new pricing system

Client: Enloes Drug, Decatur, IL

Period: Jan1993- Jan 1994

Description: Converted Microfocus Cobol programs, from a Unix Pharmacy system to MS-DOS using a Novell network. This conversion consisted of over 100 programs.

Client: Fashion Windows, Madison, WI

Period: Oct 1992- Jan 1993

Description: Coded, tested, and installed several modules to convert an inventory system.

Client: CSI Corp, St. Louis, MO

Period: June 1991 - Oct 1992

Description: Coded, tested, and installed a year-end summary system. Also work on a large conversion to install a large bank from the East coast. This project had 3 team members and issued over two million statements that year.

Client: Citicorp Mortage, St. Louis, MO

Period: Jan1991 - June 1991

Description: Evaluated and recommend solutions to a communications problem that Citicorp Mortgage had encountered. The communications that was being used was PC to mainframe. Citicorp was trying to evaluate mortgage loans on line and approve or reject these loans within two minutes.

Client: Edward Jones Co, St. Louis, MO

Period: Jan 1990 -Jan 1991

Description: Coded, and tested several modules for an on-line branch commissions system using CICS/IDMS.

Coded, and tested several modules for an on-line investments system using CICS/IDMS. This project team contained 15 people that designed this online system. This system tracks Client’s Securities from over 1500 brokerage offices.

Client: Bank of Louisville, St. Louis, MO

Period: Feb1989 - Jan 1990

Description: Served as project manager for the development of an automated money order system. Designed, and implemented this system, with 60+ programs and CICS for the online portion. Also wrote the documentation manual and user’s guide.

Client: Mastercard, St. Louis, MO

Period: Oct 1987 - Feb 1989

Description: Developed, and implemented a message switching applications, using a x.25 packet switching network. This effort included modifying an SNA, X.25, BTAM, ICSS and Series 1 operating system. Also rewrote a bulk tape processing system to feed the network and data from large banks. The mainframe modules were written in COBOL/CICS.

Coded/tested year-end summary report programs.

Client: Enloes Drug, St. Louis, MO

Period: Oct 1984 - Oct 1987

Description: Designed/implemented a specialized pharmacy system, a payroll system, and a medical records system for nursing homes for Enloe Drug Stores. The pharmacy system included label preparation, pricing inventory, and billing. The systems ran under UNIX 3.5 on DEC VAX and AT&T 3B1’s using Microfocus Cobol,

Client: Professional Computer Systems, St. Louis, MO

Period: Oct 1976 - Oct 1984

Description: Designed, implemented, marketed, maintained a complete pharmacy system using Microfocus Cobol. Comprised of 400 to 500 modules, the system ran on VAX and AT&T hardware and addressed all major business functions, including order entry, inventory control, AR, AP, and Payroll.

Education/Training/Certification:

BS in Information Systems at Washington University, St. Louis, MO

Contact this candidate