OBJECT:
Project Leader/Senior Design Analyst/Programmer/Developer contributing in sector leading company with forward-looking IT group.
QUALIFICATIONS:
More than 30 years of diversified and responsible positions in applications development with a variety of companies across several industries. Forte’ are Requirements Definition and Systems Design; functional experience includes:
Managed as many as nine analysts and programmers supporting multiple divisions with annual sales ranging from $3 to $400 million
Developed, implemented and supported various information systems solutions involving an entire company, operating division, departments as well as individual contributors; in the financial, manufacturing, marketing and inventory control areas
Organized and directed educational meetings for professional staff
Improved departmental maintenance man-hour ratio from 65% to 40% by organizing a separate maintenance group
SKILLS SUMMARY
Project Manager/Leader
Active interfacing with Management, Clients and co-workers
Requirements Definition
Senior/Lead/Business/Systems Analyst and Designer
Senior Programmer/Analyst
HARDWARE/OPERATING SYSTEMS
MVS, VM/CMS, DOS, DOS/VSE, UNIX, PC/DOS, VAX/VMS
PROGRAMMING LANGUAGES
COBOL, CICS, COBOL II, FOCUS, APS, DYL260, EASYTRIEVE Plus
DATABASE/FILE STRUCTURES
DB2, FOCUS, ISAM, VSAM FILES, MS ACCESS, BDAM
MAINFRAME DEVELOPMENT TOOLS
TSO/ISPF, IBM UTILITIES, MVS/JCL, SYNCSORT, PANVALET, LIBRARIAN, ENDEVOR, DYL 260, FILEAID, ROSCOE, XPEDITER, CHANGEMAN, CA/RC, Data Defined Systems (SDLC Methodology)
PC/CLIENT SERVER DEVELOPMENT TOOLS:
FOCUS FOR WINDOWS. PC/FOCUS. APS, VISIO. UNIX Scripts. Novel Network Software
BUSINESS APPLICATIONS EXPERIENCE:
ACCOUNTS PAYABLE ACTUAL PRODUCT COST BUDGET PREP & REPORTING COST TRACKING CUSTOMER MANAGEMENT SERVICES DISASTER RECOVERY FIXED ASSETS
INSURANCE INVOICING/ BILLING LOCKBOX COLLECTIONS PAYROLL
PHYSICAL INVENTORY RECONCILIATION PRODUCTION/SHIPPING REPORTING PURCHASING
QUALITY ASSURANCE RAW MATERIALS INVENTORY SALES FORECAST SALES/MARKETING SPARE PARTS INVENTORY STD PRODUCT COST
EXPERIENCE:
Determined to reenter IT field Dec, 2010
Left IT to pursue career in Insurance and Auto Sales Nov, 2007 – Nov, 2010
Maintained Requirements Definition skills while selling both insurance and cars to match the needs of clients.
Northern Kentucky University (NKU) Back fill Legacy team for Conversion
Senior Analyst/Programmer Jun, 2007 – Oct, 2007
NKU was involved in a conversion to SAP and required back fill help on the legacy team. I was ssigned to fill clients continuing needs and “scrub” data bases for conversion to SAP. I
Developed Business Requirements, Program design specs, conducted meetings with users,
interacting with client user/user representatives, IT staff and management for requirements gathering, and generating test data;
Met clients needs and cleaned some 150 files for loading to SAP.
Environment: Requirements Definition, Business and Systems Analysis and Design, FOCUS, Vax Open VMS and FTP.
Wellpoint/Anthem/BC/BS Consumer Driven Health Products (CDHP)
Senior Mainframe Developer/BSA Sep. 2006 – Jun, 2007
CDHP was a new family of products where the funding can be self funded (HSA), Traditional or a combination of both, requiring new GL and data warehouse transaction generation. I was assigned the tasks to convert high level specs to detail program specs, code and test the changes. I was also assigned the tasks of designing, coding and testing the processing of all diverse transactions from non-standard divisions into the standard flow. For both assignments I:
Developed Business Requirements, Systems design specs, conducted meetings with users,
developed program specs, interacting with client user/user representatives, IT staff and management for requirements gathering, generating test data and coordinating test efforts for generating GL transactions for new product line in various divisions.
Coded and tested COBOL II, Easytrive Plus and JCL modules.
Environment: Requirements Definition, Business and Systems Analysis and Design, COBOL II, VSAM, MVS/JCL, SYNCSORT, TSO/ISPF, Endevor, FILEAID, EASYTRIVE PLUS, FTP
Hamilton County – Jobs and Family Services Child Care Compensation Revision (CCCR)
Senior Programmer/Analyst Jul. 2005 – Sep. 2005
The State of Ohio mandated that the calculation of Child Care Compensation be changed from hourly to weekly w/hourly basis. I was assigned to finish the program specs, code and test the new compensation calculation program. I:
Redesigned, coded and tested the complex Child Care Compensation Program.
Environment: Business and Systems Analysis and Design, COBOL II, VSAM, DOS/JCL, DOS VSE/ICCF, FTP
Humana – Operational Data Systems (ODS)
Senior Programmer/Analyst Jan. 2005 – Mar. 2005
ODS supported the Web enabled data systems for both company and client processing. I was assigned the Disaster Recovery Process, QA testing, clean up DB2 Tables and to run certain exis*ting management reports. I:
Revised and Managed the Disaster Recovery Process for the ODS Dept.
Worked Quality Assurance cycles, interacting with client user/user representative, IT staff and management for requirements gathering, generating test data and coordinating test efforts.
Deleted approximately 48% of a production DB2 Table, Ran and documented the management reports process.
Environment: Requirements Definition, Business and Systems Analysis and Design, COBOL II, DB2, VSAM, MVS/JCL, SYNCSORT, TSO/ISPF, PANVALET, FILEAID, EASYTRIVE PLUS, EXCEL, FTP
Ohio National Financial Services – SML (New Company) Integration.
Senior Programmer/Analyst April 2004 – Aug. 2004
The purchase of another insurance company required the Sales and Profitability Reporting system to be expanded to report the new company and roll it up in the corporate reports. I was assigned the task of including the new company in all detail and roll-up reports. I:
Developed Requirements Definition, system design and program specifications as well as Unit and Functional test plans covering online and batch COBOL, FOCUS, PL1, and JCL modules.
Coded and tested programs and JCL.
Environment: Requirements Definition, Business and Systems Analysis and Design, COBOL II, FOCUS, DB2, VSAM, MVS/JCL, SYNCSORT, TSO/ISPF, CHANGEMAN, FILEAID, PL1
Client Lowe’s Home Improvement – Extended Warranty Project (EWP)
Senior Programmer/Analyst January 2004 – April 2004
The EWP provided the ability at the store POS station to sell extended warranty on various products and services. Tying the individual store inventory systems and the Corporate Inventory Systems was made part of the project. I was assigned the task of correcting the local inventories to the Corporate Inventory System. I:
Conducted JAD sessions with Corporate and Store IT groups to define current and future data requirements.
Converted High level change requirements definitions to detail system design and program specifications as well as Unit and Functional test plans covering batch COBOL, JCL and Easytrieve Plus modules.
Designed COBOL/DB2 solutions for providing individual Stores Systems with Table maintenance from Corporate. Generated were: original requirements definition, system design, program design, JCL, Unit and Functional test plans.
Coded and tested programs and JCL.
Environment: Requirements Definition, Business Systems Analysis and Design, COBOL II, DB2, VSAM, MVS/JCL, Easytrieve Plus, SYNCSORT, TSO/ISPF, FTP, FILEAID, XPEDITER, PANVALET
Cinergy – Customer Management System Enhancement Project (CMS).
Senior Design Analyst October 2000 – November 2002
The CMS project combined the expansion of the CG&E Customer Management System to include the merged sister company in the process and 5 years of enhancements that had been on hold since the merger. I was assigned the tasks of generating detail CICS/COBOL program change specs for several of the online entry functions, revise the batch reporting function to drop the Rate Code from the reports (some 350 reports) replacing it with an acceptable combination of up to 5 codes previously built in the Rate Code as well as file layout changes, include the PSI company in the line extension process and recreate a set of reports currently generated from the PSI files using their intelligent Rate Code from the new data bases. I:
Designed COBOL/CICS solutions controlling line extension deposit payments, data entry, changes, refunds and linkage to existing batch processes. Generated were: original requirements definition (CICS, batch, Passport interface and process), system design, program design, Unit and Functional test plans.
Conducted JAD Sessions with users, management and IT to set scope and detail merger and system enhancement projects.
Converted High level change requirements definitions to detail system design and program specifications as well as Unit and Functional test plans covering online and batch COBOL, CICS, Maps, JCL and Easytrieve Plus modules.
Personally reviewed and signed off Unit and Functional test results.
Environment: Requirements Definition, Business and Systems Analysis and Design COBOL II, CICS, DB2, VSAM, MVS/JCL, Easytrieve Plus, DSORT, SYNCSORT, TSO/ISPF, FTP, FILEAID, XPEDITER, Visio, CA/RC and Cinergy’s Software Release Control System
Great American Insurance Company Support Payroll System
Programmer/Analyst March – July, 2000; July - November, 1999
Great American needed back fill support for their Payroll System. I was assigned to the task. I:
Set up new check formats, maintaining COBOL/DB2/VSAM software in APS environment and COBOL II, JCL Jobs and PROC’s.
Redesigned and coded the Tax Reporting sub-system. Also changed machine scanable reports to meet various state’s changing requirements.
Coded and tested JCL to load the Data Warehousing DB2 MIF file tables.
Environment: Requirements Definition, Systems Design, Help Desk Support, COBOLII, VSAM, DB2, MVS/JCL, SYNCSORT, TSO/ISPF, FILEAID, XPEDITER, APS, FOCUS, MS Access, PANVALET
Ohio Casualty Group Support Invoicing
Programmer/Analyst December, 1998 – June, 1999
I was assigned to support the Invoicing System where I:
Coded, changed and tested COBOL/CICS programs, Maps, JCL and Easytrieve Plus modules.
Environment: Programming, MVS, COBOL II, CICS, VSAM, JCL, Easytrieve Plus, DSORT, TSO/ISPF, FILEAID, XPEDITER, BMS
The Kroger Company Support Sales Analysis Warehouse
Senior Analyst/Programmer/DBA February, 1998 - December, 1998
Kroger needed back fill support. I was assigned to supported their client server based Sales Analysis Warehouse System written in FOCUS for Windows. I:
Performed system and program maintenance, help desk support for the end users, application software installation on client workstation, LAN servers and mainframe DB2 tables, as well as FOCUS DBA activities.
Coordinated efforts with users for requirements gathering, scheduling testing/upgrades.
Y2K conversion responsibilities included coded and tested MVS batch as well as MVS/TSO online FOCUS and PL1 application modules.
Environment: Requirements Definition, Business and Systems Analysis and Design, Help Desk Support, FOCUS DBA, Windows 9x, Novel Network software, DB2, FOCUS, FOCUS For Windows, MVS/JCL, TSO/ISPF, PL1
Cincinnati Bell Telephone Support Budget Prep & Reporting
Outsourcing analyst/DBA
I was assigned as Outsourcing analyst/DBA to support two FOCUS systems, the first a Budget Preparation and Reporting system in MVS/VM/CMS and the second a Public Coin Management Information system in the UNIX environment.
Environment: Requirements definition, Business and Systems Analysis and Design, Help Desk Support, VM/CMS, UNIX, UNIX (Bourne Shell) Scripts, VSAM, MVS/JCL, SYNCSORT, TSO/ISPF, FILEAID, FOCUS, FOCUS for UNIX, FOCUS DBA
General Electric Aircraft Engines (GEAE) Develop and Support Cost Tracking
Programmer/Analyst/DBA
GEAE needed development help for a new Cost Tracking Data Warehouse. I was assigned to the task. I helped develop Requirements Definitions, Systems Design, Code, Test and support FOCUS based (MVS/TSO mainframe and MS/DOS) data warehousing applications including Cost Tracking and R&D Cost Tracking. I also developed solutions in Sales, Billing, Business Forecast areas and Inventory and designed user maintained Automatic Scheduling System for standardized reporting.
Earned two Productivity Awards (second after contractors removed from recipient list).
Environment: Requirements Definition, Business and Systems Analysis and Design, Help Desk Support, MVS/JCL, MS/DOS, SYNCSORT, TSO/ISPF, FILEAID, FOCUS, PC FOCUS, FOCUS DBA
Champion International Corp. /St. Regis Corporation,
Project Manager/Leader
Responsible for all application development and support activities for several operational divisions. Supervised 9 analysts and programmers while supporting multiple divisions.
Project management responsibilities included resource allocation, estimating, schedule setting and management, subordinate motivation, client representative interface, issue resolution with client and technical staff.
Top-Down Specialist
Designed, implemented and supported COBOL-CICS, FOCUS and COBOL-CICS/FOCUS based systems in MVS/TSO environment.
Coded COBOL-RDB in VAX/VMS environment.
Environment: Project Management, Requirements Definition, Business and Systems Analysis and Design, COBOL, CICS, VSAM, BDAM, ISAM, MVS/JCL, DSORT, TSO/SPF, DDS, FOCUS, VAX/VMS, DEC Control Language, DEC COBOL, DEC RDB
Nekoosa Papers, Inc., Port Edwards, Wisconsin
Project Manager/Leader
Responsible for applications development and support activities for cost and budgets, accounts payable, procurement, stores inventory, raw material inventory, strategic planning, marketing and order support functions. Managed 5 analyst/programmers including resource allocation, estimating, schedule setting and management, subordinate motivation.
Analyst/Programmer
Designed, implemented and maintained the following systems: standard product costs, stores inventory, raw material inventory, finished goods physical inventory reconciliation, shipment reporting, purchase order, sales reporting, sales forecasting and item code control.
Environment: Project Management, Requirements Definition, Business and Systems Analysis and Design,, Programming, DOS, DOS-VSE, COBOL, BAL, SPS, BDAM, ISAM, JCL(DOS), DYL260
EDUCATION:
Electrical Engineering - Michigan Technological University
Electronic Data Processing - Northern Michigan University Area Training Center
CERTIFICATIONS:
Licensed Life and Health Insurance Agent in the State of Ohio
Systemations’ BASIC Systems Correspondence Course