Summary of Computer Experience

Titles and Work Experience
Programmer Analyst (and other equivalent titles) 15 to 20 years working in steel processing, insurance, aerospace and automotive, mortgage banking and manufacturing (baby food, furniture, and plumbing) supporting a wide variety of financial applications , inventory control, order entry and shipment, and other applications.
Sr. Systems Analyst (and other equivalent titles) 15 to 20 years working in Aerospace and Automotive, Service Bureau, and manufacturing supporting a wide variety of financial applications from initial package selection through long term maintenance and enhancement.

Programming Tools and operating systems
COBOL and Accucobol, Serena’s Changeman, Endeavor, Panvalet, Librarian,
Oracle, IMS, VSAM, HP image, SQL (Toad, Oracle PS-SQL & Access query)
Several CICS front end programs and Accuate and other 4 GL’s
AIX Unix, HP3000, TSO, CMS, MVS/OS JCL, FTP, Windows.
Hardware
AIX Unix, HP3000 MVS, IBM Mainframes (OS and MVS) , PC’s
Software Packages
Microsoft Office - Access-extensive usage, Excel including Pivot tables and Charts, Word
General Ledger, Payroll and Personnel, Accounts Payable. Fixed Assets, Accounts Receivable and a Tax Preparation package.
A variety of report generation systems.

Professional History
Confidential, Mar 97- Mar 09
South Bend IN
Sr. Programmer Analyst

• Designed, built, and maintained their most critical system (MC). The MC system controlled purchases based on sales estimates, current purchase orders and in-stock material. It also tracked and provided shipment history for sales, material assignment and purchasing. Some customers also accessed the system. It reduced on hand inventory from an average 2-4 month supply to 1 ½ to 3 month range. Normal lead time for delivery of steel coil being 3 months.
• When I started with Steel Warehouse they used an HP3000 and Image database to support 3 operational sites. For the last 3 years we used IBM AIX (Unix) servers and Oracle to support over 10 operational sites. Software was converted from HP to AIX. Code is a mix of Cobol and report writer/ file generator software and PL/SQL.
• As part of the conversion to AIX process I selected and installed the change management software (Serena Changeman) and report generation software(Actuate). I also wrote many of the test scripts used to test the converted code, then later ran them to test the system.
• Prior to conversion, I had set up Access databases and extraction, FTP, and PC processes that automatically refreshed them nightly from the live database. These Access databases contained most of the live data excluding audit files and were then used for ad hoc reports that in some cases became production reports.
• Added fields and tables as needed to Oracle 9i databases. Extracted and modified data on the database with Toad and SQL as well as imbedding SQL in Cobol code via Accucobol options.
• I was also part of the Help Desk rotation for this system. With a department of less than 10 people, this meant covering all levels and often providing support for the problems as they occurred.

Confidential, Jan 96-Dec 96 & Aug 93- Mar 94
South Bend IN
Contract Programmer (two assignments at Nibco + a brief term at Bendix)
Confidential, Mar 94 - Jan 96
, PO Box 167, Elkhart, IN 46515
Senior Programmer Analyst

• Downloaded mainframe data from customer data base, Inventory data base, order history file, and selected mainframe reports into new Access databases. Databases were used by staff and myself for creating production and ad hoc reports and spreadsheets
• Provide support, and enhancement to legacy systems on the corporate mainframe.
• Assisted Nibco’s upgrade of their order entry-inventory system. System converted to CICS/DL1 with source maintained in Endeavor. Much of the work was the conversion of Easytrieve reports to DYL280 report writer.

Confidential, Sept 91- Jun 93
, South Bend IN
Senior Programmer Analyst

• Supported the mortgage payment processing as a Sr. Programmer Analyst.
• Developed nightly jobsteam flowchart that was still in use 15 years later.

Confidential, Jan 91- Sept 91
Muskegon, Michigan
Contract Programmer

Confidential, Jul 78- Dec 90
Fremont, Michigan 49413
Senior Computer Systems Analyst

• Reviewed, selected, installed, maintained, and enhanced General Ledger, Fixed Assets, and Tax Preparation packages. I was the main systems analyst assigned to the project. GL cut two days off closing and revamped the stucture of the chart of Accounts. Ten years after installation, GL and FA were the only systems recommended to be kept when Gerber’s systems were reviewed by Arther Anderson.
• Provided a process that added over $1,000,000 to profit after taxes annually.
• When General Ledger Accountant broke his leg in the middle of year end closing, I filled in for him. We closed on time.
• Designed, developed, and installed CICS IMS database to track training of employees.
• Responsible for installation, maintenance, security, user training, and enhancement of MSA report writer.

Confidential, May 73- July 78
Grand Rapids, Michigan
Titles-Various
Responsibilities included supporting regional staff in installation and maintenance of several financial packages (AP, AR, FA, and GL) and payroll package. This included actual package maintenance, development, vendor contact, and customer consulting and training.

Confidential, Dec 71- May 73
Saginaw, Lansing Michigan
Programmer on a claims reporting system.

Education- B.S. Computer Science Michigan State