SUBSTITUTE ADOPTED - JUNE 8, 1999

Agenda Item No. 22

Introduced by the Administrative Services/Personnel and Finance Committees of the:

INGHAM COUNTY BOARD OF COMMISSIONERS

RESOLUTION AUTHORIZING AN ICEA LETTER OF UNDERSTANDING REGARDING

THE MIS DEPARTMENT

RESOLUTION #99-135

WHEREAS, the COUNTY OF INGHAM, a municipal body corporate of the State of Michigan (hereinafter referred to as the "Employer") and the INGHAM COUNTY EMPLOYEES' ASSOCIATION (hereinafter referred to as the "Union") have agreed to a collective bargaining agreement for the County Professional employees' unit; and

WHEREAS, such collective bargaining agreement references step movement with Article 28, Section 1C; and

WHEREAS, there are recruitment and retention difficulties with some of the County Professional MIS classifications; and

WHEREAS, the parties wish to amend and clarify the step movement for these classifications due to the market conditions.

THEREFORE BE IT RESOLVED, it is hereby agreed by the parties that:

• The Network Administrator be reclassified from a P6 to a P7;



• The Sr. Computer Technician be reclassified from a P5 to a P6. Minimum qualifications will be a CNA with three (3) years of experience as a Computer Technician. Upon completion of a CNE, the employee will be granted a one-step advancement. A new anniversary date will be assigned at that time for future step increases. If the CNE training is funded by the County of Ingham, the employee must sign an agreement whereby he/she agrees to work for Ingham County for one (1) year. If he/she fails to keep that commitment, he/she must repay the County for that expense.

• The following positions will have title changes from: Micro-Computer Programmer, Programmer Analyst and Systems Analyst to Programming Specialist. Current employees would be placed on this scale based on their current assignments and the number of languages in which they are proficient.

Minimum requirements for a Programming Specialist are:

A. Associate's Degree in Business Data Processing or related field and one (1) year experience in a network or mainframe environment; OR a Bachelor's Degree in Business Data Processing or related field and six (6) months experience in a network or mainframe environment;

B. Demonstrated experience or formal training in one programming language; and,

C. Ability to support a minor system.

SUBSTITUTE ADOPTED - JUNE 8, 1999

Agenda Item No. 22

RESOLUTION #99-135

Step movement would be as follows:

A. Original appointment to a Programming Specialist position shall be made pursuant to Article 28 (Salaries and Cost of Living), Section 1B.

B. One step advancement in six (6) months from date of hire if Specialist manifests language and data base competencies, demonstrates basic network knowledge such as drive-mapping and e-mail handling, supports a major system as a primary analyst, and has ability to provide active support for multiple systems. Anniversary date change.

FOR CALCULATION PURPOSES, 4 MINOR SYSTEMS EQUALS 1 MAJOR SYSTEM.

C. Annual one-step advancements will be granted, assuming satisfactory performance, based on the last step increase movement from Step 1 through Step 5. Movement can also be granted based on additional responsibility for major systems or the mastery of additional languages.

D. Steps 6 through Step 9 are only granted upon the mastery and demonstrated proficiency of additional languages* and/or the added responsibility of serving as the primary analyst for major systems.

E. One step advancement if Specialist demonstrates ability to use FTP and other file transfer protocols, database design, and satisfactorily performs the assignment of serving as the primary analyst or the equivalent of at least three (3) Ingham County major systems. Anniversary date change.

F. One step advancement if Specialist satisfactorily performs the assignment of serving as the primary analyst, or the equivalent, of three (3) additional Ingham County major systems (total of six). Anniversary date change.

G. One step advancement if Specialist satisfactorily performs the assignment of serving as the primary analyst, or the equivalent, of three (3) additional Ingham County major systems (total of nine). Anniversary date change.

H. One step advancement if Specialist satisfactorily performs the assignment of serving as the primary analyst, or the equivalent, of three (3) additional Ingham County major systems (total of twelve). Anniversary date change.

I. One step advancement if Specialist completes employer specified certification and demonstrates proficiency in two (2) additional languages* (total of three). Anniversary date change. Examples of languages = COBOL, LINC, Visual Basic, Fox Pro, Paradox, Access Database, Oracle, etc.

J. One step advancement if Specialist completes employer specified certification and demonstrates proficiency in each three (3) additional languages* (total of six) mastered. Anniversary date change.

K. All Programming Specialists must serve as supporting analysts as assigned.

L. If a Programming Specialist is given additional responsibilities based on a temporary assignment, there will not be an anniversary date change.

* If education and/or training is funded by the County of Ingham, the employee must sign an agreement whereby he/she agrees to work for Ingham County. If the training expense is under $5,000 the employee must make a one (1) year employment commitment. If the training expense is $5,000 or over, the employee must make a two (2) year employment commitment. If he/she fails to keep the specified commitment, he/she must repay the County for education / training expense .

SUBSTITUTE ADOPTED - JUNE 8, 1999

Agenda Item No. 22

RESOLUTION #99-135

IN THE EVENT THAT THE RESPONSIBILITY FOR A MAJOR SYSTEM(S) IS LOST, OR THAT THE LANGUAGE IS NO LONGER UTILIZED WITHIN INGHAM COUNTY, HE/SHE WILL BE MOVED BACK TO THE APPROPRIATE STEP BASED ON THE ABOVE CRITERIA.

PROGRAMMING SPECIALIST

STEP 1 STEP 2 STEP 3 STEP 4 STEP 5 STEP 6 STEP 7 STEP 8 STEP 9

32,320 35,530 38,740 41,950 45,160 48,370 51,580 54,790 58,000

STEP 1 STEP 2 STEP 3 STEP 4 STEP 5 STEP 6 STEP 7 STEP 8 STEP 9

33,290 36,596 39,902 43,209 46,515 49,821 53,127 56,434 59,740

STEPS 1 - 5 = Automatic annual progression, assuming satisfactory performance. Can also advance in steps 1- 5 based on additional responsibility for major systems or the mastery of additional languages.

STEPS 6 - 9 = Only granted upon the mastery and demonstrated proficiency of additional languages and/or the added responsibility of serving as the primary analyst for major systems.

Example: DOH = 4-15-99 - Step 1 ($32,320). 10-15-99 = 6-month increase - Step 2 ($35,530). January, 2000 -Completes certification of 2 additional languages = Step 3 ($39,902). June, 2000 - Demonstrates ability of specified criteria, and is serving as the primary analyst for 3 major systems, and supporting analyst for 2 minor systems = Step 4 ($43,209). August, 2000 - 5 major systems and 4 minor systems = Step 5 ($46,515).

BE IT FURTHER RESOLVED, that in the event the market no longer dictates the above outlined step movement as determined by the Employer, the Programming Specialists will revert back to their prior titles and salary grades. They will be placed at the step closest to their current salary to a maximum of their previous grade. They will return to the same procedure for step movement as outlined in Article 28, Section 1C.

BE IT FURTHER RESOLVED, that the Board Chairperson is authorized to sign the Letter of Understanding after review by the County Attorney.

ADMINISTRATIVE SERVICES/PERSONNEL: Yeas: Czarnecki, McDonald, Lynch, Severino, Minter Nays: None Absent: None Approved 6/1/99

FINANCE: Yeas: McDonald, Bernero, Grebner, Lynch, Schafer, Juall, Minter

Nays: None Absent: None Approved 6/2/99