SUMMARY:

More than 40 years experience in systems development, systems design, project leadership, systems analysis, teaching, personnel development, software and hardware selection and systems implementation. Broad application experience includes Law Enforcement, Accounts Payable/Receivable, Bill of materials, Human Resources (Personal/Payroll, Health Care & Workers Compensation), Nuclear Plant Admittance, Purchasing, Warehousing, Inventory Control, Production Control, Order Entry, MRP, Insurance, Financial and Word Processing. I have used SDLC stages for many of my projects and I am an expert using TSO/ISPF, IDMS, IMS, DB2, Confidential, Confidential, WebFocus and Mainframe Focus.

TECHNICAL SKILLS:

Hardware: IBM Mainframes, IBM 8100, AS400, HONEYWELL Mainframe 6600, IBM Compatible PCs

Software: ZOS, OS/MVS, MVS/XA, MVS/ESA, DOS/VSE, DPPX, WINDOWS, JES2/JES3, HASP, POWER, ACCESS, MSOS, GCOS, CDC 3300, UNIX, COBOL, Confidential, RPG II, ISAM, ADS/O, Confidential, BDAM, Confidential, STROBE, FILEAID, ABENDAID, OMEGAMON, SDSF, IBM UTILITIES, IDMS, DB/DC, IMS, DB/DC, DB2, ACF2, RACF, TSO/ISPF, LIBRARIAN, PANVALET, ENDEVOR, XPEDITER, SCLM, VOLLIE, TONE4, ROSCOE, FOCUS, MS Office, WebFocus Developer Studio, VISIO, Teradata SQL

EMPLOYMENT HISTORY:

Confidential

Team Lead

Responsibilities:

• Mainframe performance engineering.
• Scripted Mainframe applications using Confidential and Loadrunner.
• Created and maintained a production like environment for application performance testing.
• Executed multiple levels of tests, Load, Endurance, Breakpoint and others as required.
• Maintained system JCL and Cobol Programs.
• Apprentice with Visual Studio Performance testing and reporting.

Confidential

Consultant

Responsibilities:

• Performance and Stress testing team.
• Responsible for environment setup.
• IDMS, DB2, Confidential, Confidential scripts.
• Testing time allocations.
• Execution of Confidential scripts and Statistical reports.
• Movement of code to be tested.
• Database restores. Mass binds of DB2 libraries.
• Confidential regions and MQ Queues

Confidential

Consultant

Responsibilities:

• On a project for Confidential utilized Teradata SQL, Cobol, Confidential, and DB2 for the Confidential merchandising requirement.

Confidential

Consultant

Responsibilities:

• On a project for General Motors, utilized WebFocus Developer Studio 5.3.2 to convert a Mainframe Reporting system to WebFocus

Confidential

Consultant

Responsibilities:

• Enhancements to Oakland County Circuit and Family Courts systems.
• The State of Michigan mandated an expansion to the Oakland County Court systems Case Number.
• This involved a complete re - write of the Family Practice Juvenile Sub-System.
• System was written in Cobol, Online portion was Confidential, File structure was Confidential .
• As a Programmer Analyst, was responsible for Coding. Unit, QA, and integration testing.
• Mainframe environment is IBM, AS400, DOS, Vollie, Confidential, IDMS, Confidential .

Confidential

Consultant

Responsibilities:

• As a Business Analyst, was responsible for the Business Systems
• Design and Technical Specifications performing requirement gathering, analysis and client interaction, while utilizing the SDLC process.
• Confidential has not been awarded the contract but has retained my services as a Programmer and Mainframe
• Developer for the Guarantor Split, utilizing Confidential, ADS/O and the World’s largest IDMS/DB2, ENDEVOR, application environment.
• Worked as a member of a very large team, 120+ employees. COBOL II, DB2/IDMS, File-Aid, Abend-Aid.
• Several States are now processing their own loans.
• Confidential is splitting this data and all associated programs for their use.

Confidential

Consultant

Responsibilities:

• Converted Mainframe Focus Programs to use Smart dates and be Confidential compliant.
• Helped in the installations and report generation from the Site Manager Product.
• Converted and tested the Focus programs.
• Met with the Focus user community for weekly status updates.

Confidential

Mainframe Developer

Responsibilities:

• Interfaced with Confidential Systems technicians, tested new software releases and performed software acceptance testing. Subject Matter Expert on the Joint Program appendices of the UAW/ Confidential /Visteon National Labor Agreements for the Contract years of 1993, 1996, 1999 and 2003.
• Maintained the COBOL, XPEDITER used for testing, front-end program and JCL for receipt of Human Resource(Personell/Payroll, Health Care claims, Workers compensation) interface data.
• Responsible for all aspects of the Guaranteed Employment Number System, a contractually required UAW/ Confidential /Visteon Joint Programs System.
• Production support, Analysis, Design, UAW/ Confidential contract interpretation and review.
• Communications with the UAW National Confidential Department and Confidential Management.
• Programming support for the HTML, WebFocus and Mainframe Focus Programs.
• Power Point presentations to Focus Users groups
• Mentoring of team members and system users
• User & Security Administration for UAW/ Confidential /Visteon Job security representatives.
• Project Orange. Knowledge transfer from Confidential to Visteon
• Project Manager for the Guaranteed Employment Number System Re-Engineering Project.
• Converted a legacy Focus 4.5 System to a Relational Focus 7.0 System.
• Utilized Data Modeling, Normalization and Extended Relational Analysis. Written in Focus 7.0 and COBOL.
• Production Support for 1,000+ Users. System contains both Salaried and Hourly data. For Personnel, Payroll, Pension, Worker Compensation, Retirement, Health Care, Guaranteed Employment, Wage Determination, Work Force Profile, Preferential Placement, Protect Employee Surveys, Demands Tracking, Merit Planning, FMLA, ETC.
• Supported the 1996 Confidential /UAW National and Local Negotiations.
• Mainframe Payroll data Download to Excel and back up to the Mainframe for Payroll Processing.
• Mainframe Focus to MS Access Database.

Confidential

Senior Consultant

Responsibilities:

• Converted the existing IDMS database files into a new relational Confidential file structure. This involved a complete extract of all data from the database, restructuring, and loading.
• Designed, coded and tested all new search programs for Crime Classes, Property types, Addresses and Arrest charges.
• Wrote the program in COBOL and Confidential as well as created several online screen presentations of the revisions of the CLEMIS system for the end users.

Confidential

Consultant

Responsibilities:

• Wrote the system using COBOL, IDMS and ADS/O.
• Provided technical assistance to the corporate help desk and was on 24-hour call to solve production problems.

Confidential

Senior Consultant

Responsibilities:

• Performed as the technical advisor for the system acceptance and testing group as well as worked on the Central Inventory Distribution system.
• Analyzed and proposed solutions to problems, as well as suggested modifications for improved system efficiencies.
• Studied as a DB2 DBA for the conversion from IDMS to DB2.
• Utilized IBM's Teleprocessing Network Simulator to stress test the system while monitoring the mainframe and software environments.
• Wrote the system in COBOL, IDMS and ADS/O.
• Assisted in the project management of the Accounting Financial System.
• Training new staff members in TSO.ISPF, Confidential, ADS/O and IDMS DB/DC.

Confidential

Database Consultant/Operation Manager

Responsibilities:

• Analyzed the general and functional design of the Attendance Reporting subsystem.
• Participated in the database design and installation.
• Calculated and presented to management the manpower estimate for the completion of the online requirements.
• Prototyped a test version of the Attendance system using OLM, ADSG and ADSA to user specifications.
• Analyzed the CHRS database elements and those in the county system.
• Specified conversion criteria and programming necessary to convert the existing county files to the CHRS database.
• Wrote and compiled several Confidential maps to be used in the continuing development of the health system.
• Programmer analyst on Card System Reporting. Utilized Cobol, IMS DB to extract data from the PCS System database and generate requested reports.
• Converted the Corporate Parts Master, Sales Order Master and Customer Master files.
• Created new corporate Availability Files, which were changes required by the Customer Spirit Project. COBOL, IMS DB/DC, Confidential, Confidential, Strobe, File-Aid, Abend-Aid,
• Responsible for a pilot conversion of program testing specification from a flat file Culprit based system to a Focus database and reporting system.
• Designed, coded and tested the Configured Products project. This modification allowed system users to specify and track configured products. These were products composed of other company products and sold as a complete package.
• Acted as a lead ADS/O, ADSIA Programmer/Analyst.
• Designed, prototyped and coded an ADS/O application. This included utilizing IDD sign-ons and security levels in customized menus and dialogs.
• Coded and tested both the IDMS batch and DC COBOL Database I/O programs necessary for the operation of the system.

Confidential

Consultant

Responsibilities:

• Assisted in a quote on a fixed price bid for a client utilizing IDMS software.
• As a field manager, I had direct responsibility for performance appraisals and salary administration for those consultants assigned to me.
• Acted as a company technical representative on sales and marketing calls.
• As an analyst and database administrator utilizing FOCUS, I was responsible for data analysis of the hourly and salary payroll/personnel files.
• Performed data base design, implementation and load of extracted data for ad-hoc reporting.
• Conducted analysis of file access security and the implementation using FOCUS file security.
• Designed and wrote user sign-on procedures utilizing TSO Clist, Focexecs, system/user profiles, FIDEL, menus and CRTFORMs.
• Assisted in user FOCUS and TSO training.
• Extracted data from converted Honeywell files of sixteen plants. The FOCUS database design, implementation and loading of intelligent user ID's so that a plant would be connected to the proper files and remote printer destinations.
• Provided technical assistance to the company help desk, Troubleshooting, problem definition, resolution, production maintenance, and access to new software releases.
• Acted as the HRIMS Data security administrator and evaluated ISI & IDMS data security software, identified and resolved how to best satisfy HRIMS security requirements.
• While working as the online design coordinator my tasks included walk-through and review of the status and outputs of the Systems Design, Technical and Implementation groups. Designed and coded screens required within HRIMS.
• Developed documentation of the system.
• Assisted in the development of new and revised coding structures.
• Participated in the analysis of HRIMS requirements for a mainframe word processing system and the AMDAHL Design Review Conference.
• Helped develop a manpower estimating process for ADS/O Dialogs and estimated the manpower requirements for the HRIMS project.
• Developed a lock Clist for TSO users that when executed, prevents unauthorized terminal use. The company Security Administrator had it installed for company wide use.
• Helped design the schema and subschema for the HRIMS transaction translation process. Also documented it by drawing the Bachman diagrams required.
• Designed and wrote numerous ADS/O screens and dialogs for HRIMS internal use.
• Involved in the Data Base Design, online high level and detail design for a system designed to meet government regulations for the control of nuclear power plants.
• Responsible for project control of the online portion of the system in the Radiological Services Area and the creation of project control documents.
• Developed a Documentation Standards Tool to be used with ADS/O, which shows the relationship of processes within dialogs. This tool, greatly improved efficiency and was used by all applicable project members.
• Designed utilized Cullinet's Data Base Software and were highly structured. Nassi-Schneiderman techniques were used to insure top down design. There was heavy user interface and structured walk through.
• Functioned as a Programmer Analyst on the 'EUROSTAR' project team. This project's efforts were directed towards modifying the company's major Sales Tracking and Reporting System (STAR) for inclusion of local European currencies and/or U.S. dollars.
• Re-designed and re-wrote the major online table file processor as well as several report programs.
• Setup the ACF2 security access system rules for the project and administered the security system.
• Worked on the purchased package program update freeze library. This project coordinated the installation or cancellation of over 200 updates to the STAR system from the package system vendor, using COBOL, IMS DB, Confidential .
• Functioned as a Programmer Analyst on the product substitution team. This effort involved system wide changes to the STAR system to allow for the substitution of products on customer orders.