HomeMy WebLinkAboutResolutions - 2013.08.01 - 20938MISCELLANEOUS RESOLUTION #13190 July 17, 2013
BY: HUMAN RESOURCES COMMITTEE, JOHN SCOTT, CHAIRPERSON
IN RE: HUMAN RESOURCLS DEPARTMF:1 - - INFORMATION TECHNOLOGY DEPARTMENT
AND SALARY STRUCT.7 C` !ANGES
To the Oakland County L.:0 H of Commissior;s
Chairperson, Ladies and Gentlemen:
WHEAS Oakland County has had extreme difficulty rota :ling and r: 1g qualified applicants for
vapancier.i a 13% to 22% (19 - 34 pc ,Itlits) :Acancy rate wit rt: ".•(.l to fill pcons; and
VVHE- 'V-. this difficulty in recruiting I: ',:;-mtion Technolog:: OT) l-:17 an identified as a iT::•'.ilary :it • "--; due to a critical labor shortpvi .:::1,,:::: Jlting in wages thl have increased signifirt;ntly across the
ThAS07----fld County has advertised exter • , used the n. bonus option and m:",-;teted the Coun: / as a desirabH. ;ce to work resulting in qualified .:;p1;ciants no in '.sted in applying or dy:Aning
to accept positions: and
j -"EAS the Human Resources Depa ...:::o retained The Segal Company to evaluate the
compLtiti:.• .6 of Oakland County's IT compensa'.jon and conduct a comprehensive market survey study;
and
WHERE' the results of this salary study concluded that some IT clit • 'Ions are below the market
avertige for the rt.ttoit Metropolitan area; and
WHEalt. -i Human Resourens IT Departments have analyzed the current clas.:,:,ificitions and 1".).nges in relatic.") the market si:::":".t. "2; and
WHEREAS it hac b;:yen determined that there is sufficient . :ort for classification changes and salary
range a.:.:justments; and
VVHFREAS this Jesuits in the cre'-r, deletion, -1, removal of cFications from the
Cc , Sal,:ii"," Administration Plan, and sal : r nge adjust,". organizational r -t;:-.:; and
VVH:;';':[;:::'",S the classification chani,. ; are being recut- t '"d align with induit;Ty standards and
ropriately the way in which these positions will be utiliz(--t, and
it has been determined that there is sufficient funding for the tltion chan t 3 and ty range ..iciju-t-nents.
DW THERH=FORE BE IT RLSOLV;....D that the Oakland .. rd of Comksioners ap:- ."; tho prop - clrssif ion changrts salary range adjustments frt , irlormation Technology "tnt as folio'
1. To create the following new classifications:
Classification Title Salary Grade 1 Overtime Application Architect EXO
EXC
Exempt
Exempt Technical Architect
S stems Engineer EXC Exempt
Systems Administrator II EXC Exempt
S stems Administrator I EXC Exempt
Network Engineer EXC Exempt
Network Administrator II EXC Exempt
Network Administrator I EXO Exempt
Deployment Services Technician EXC Exempt
Multi-Media Specialist EXC
EXC
Exempt
Non-Exempt Computer Operations Supervisor
IT Business Analyst EXC
10
12
Non-Exempt
Non-Exempt
Non-Exempt
IT User Support Specialist I
IT User Support Specialist II
HUMAN RESOURCES COMMITTEE
Motion carried unanimously on a roll call vote.
2. To create the salary ranges as follows:
JOB TITLE Base 1 Year 2 Year 3 Year 4 Year Year 5 Year 6 Year 7
Chf Technology Officer
Manager - Application
Services
Manager - CLEMIS
Manager Deployment
Services
Manager Technical Systems
& Network
$86,615 $91,830 $97,042 $102,252 $107,465 $112,681 $117,517 $122,353
Chief Clemis
Chief Internal Services
Chief Land Management
Chief eGovernment
Chief Technical Services
Enterprise Architect
$76,343 $80,939 $85,533 $90,131 $94,726 $99,321 $105,161 $111,000
Supervisor ll Info Tech
Technical Architect
Application Architect
$72,349 $76,702 $81,061 $85,414 $89,774 $94,134 $99,567 $105,000
Data Base Administrator
Supervisor I Info Tech
$68,560 $72,690 ' $76,822 $80,947 $85,076 $89,204 $95,301 $101,398
Project Manager $68,886 $72,801 $76,716 $80,631 $84,546 $89,197 $93,848 $98,500
Senior Systems Analyst $68,560 $72,690 $76,822 $80,947 $85,076 $89,204 $92,594 $95,983
Network Engineer
Systems Engineer
$68,560 $72,690 $76,822 $80,947 $85,076 $89,204 $92,104 $95,004
Application Analyst Prog III $64,975
$60,920
$68,886 $72,801
$64,763 $68,600
$76,716
$72,440
580.630
576.282
$84,546
$80,121
$87,773 $91,000
$82,651
IT Security Specialist
Systems Administrator II
Network Administrator II
Internal Services Supervisor
Application Analyst Prog II $54,954 $58,343 $61,727 $65,117 $68,504 $71,891 $75,446 579,000
IT Business Analyst $53,039 $56,116 $59,198 $62,277 $65,355 $69,271 $73,188 $77,105
Computer Operations
Supervisor $57,866 $61,471 $65,078 $68,682 $72,288 $75,898
Telecommunication Network
Supv $52,605 $55,882 $59,162 $62,438 $65,717 $68,998 $71,758 $74,931
Multi Media Specialist
Deployment Services Tech $54,954 $58,343 $61,727 $65,117 $68,504 $71,891
Systems Administrator I
Network Administrator I $54,554 $57,281 $60,146 $63,153 $66,310 $69,626
IT User Support Specialist II $47,453 $50,343 $53,236 $56,129 $59,022 $61,913
IT User Support Specialist I $40,988 $43,462 $45,938 $48,413 $50,883 $53,355
Data Processing Equip Oper
II $33,903 $35,948 $37,999 $40,046 $42,097 $44,144 $46,788 $49,432
Data Processing Equip Oper I , $27,803 S29.482 $31,165 S32,847 $34,530 $36,214 $38,357 $40,500
1 1 Production Control Analyst $30,839 S32,705 $34,571 $36,433 $38,302 $40,163
2
Grade Position Title
EXC IT Security Specialist
Grade Overtime Category
EXC Exempt
Position Title
Data Security Specialist
1080201 Application Architect EXC
EXC Technical Architect
Exempt
Exempt 1080601
Position # Position Title Grade Overtime Category
3. To remove from the Salary Administration Plan the following classifications:
From To
Position Title Grade Grade Overtime Category
Telecommunication Network Supervisor 14 EXC Exempt
Data Processing Equipment Operator II 08 EXC Non-Exempt
Data Processing Equipment Operator I 05 EXC Non-Exempt
4. To re-title the following classifications:
From To
5. To delete the following classifications:
Manager e-Government Services
GIS Data Services Supervisor
Senior Database Administrator
Systems Software Specialist
Network Systems Specialist
Network Systems Analyst I
Network Systems Analyst II
Production Control Analyst I
Production Control Analyst II
Production Control Analyst III
Production Control Analyst IV
6. To create the following full-time eligible Proprietary (PR) funded positions:
7. To delete the following FTE Proprietary (PR) funded positions:
Position Title Position Number Current Location Name
Internal Services Supervisor 1080101-03494 Administration
Application Analyst Programmer II 1080201-00220 Application Services
Application Analyst Programmer II 1080201-01341 Application Services
Customer Service Technician II 080601-01260 Technical Systems & Networking i
8. To re-title the following positions:
3
From To
Position # Position Title Grade Position Title Grade
1080601-09520
1080601-08088
Systems Software Specialist EXC Systems Engineer EXC
Systems Software Specialist
Systems Software Specialist
EXC
EXC
Systems Engineer
Systems Engineer
Systems Engineer
EXC
EXC
EXC
1080601-03617
1080601-08087 Systems Software Specialist EXC
1080601-04707 Systems Software Specialist EXC
EXC
EXC
EXC
Systems Engineer
Systems Engineer
EXC
EXC 1080601-09238 Systems Software Specialist
1080601-09239 Systems Software Specialist Systems Engineer
Supervisor II — Information
Technology
EXC
EXC
1080601-05782 Senior Database Administrator
1080601-02746 Network System Specialist EXC Systems Administrator II EXC
1080601-10412 Data Security Specialist EXC Network Engineer EXC
1080601-09241 Data Security Specialist EXC Network Engineer EXC
1080601-09237 Data Security Specialist
Network System Specialist
EXC
EXC
Network Engineer EXC
1080601-10414 Network Administrator II EXC
1080601-01674 Network System Specialist EXC Network Administrator II EXC
1080601-09236 Network System Specialist EXC Network Administrator II EXC
1080601-10413 Network System Specialist EXC Systems Administrator II EXC
1080601-09341 Network Systems Analyst I 12 Network Administrator I EXC
1080601-07997
1080601-03308
Network Systems Analyst I 12 Network Administrator I EXC
Technical Operations Supervisor EXC Computer Operations
Supervisor
EXC
1080601-01778 Production Control Analyst III 07
EXC
EXC
Production Control Analyst
Project Manager
Network Administrator II
07
EXC
EXC
1080601-01409 Application Analyst Programmer III
1080201-07835
1080201-06368
Network System Specialist
Application Analyst Programmer III EXC Project Manager EXC
1080101-01368 User Support Specialist II 12 IT User Support Specialist II 12
1080101-01757 User Support Specialist II 12 IT User Support Specialist II 12
1080201-00204 User Support Specialist II 12 IT User Support Specialist ll 12
1080201-09428 User Support Specialist II 12 IT User Support Specialist II 12
1080301-10251 User Support Specialist II 12 IT User Support Specialist II 12
1080301-10986 User Support Specialist II 12 IT User Support Specialist II 12
1080301 -1 0987 User Support Specialist II 12 IT User Support Specialist II 12
1080101-04729 User Support Specialist I 10 IT User Support Specialist I 10
1080101-09506 User Support Specialist I 10
10
IT User Support Specialist I 10
1080201-00981 User Support Specialist I IT User Support Specialist I 10
9. To reclassify the following positions:
From To
Position # Position Title Grade Position Title Grade
1080201-05418 User Support Specialist III 13 IT Business Analyst EXC
1080201-08082 User Support Specialist III 13 IT Business Anal st EXC
1080201-04695 User Support Specialist III 13 IT Business Analyst EXC
1080201-09754 User Support Specialist III 13
13
IT Business Analyst EXC
IT Business Analyst EXC 1080201-00273 User Support Specialist III
1080301-09582 User Support Specialist III 13 IT Business Analyst EXC
1080301-09233 User Support Specialist III 13 IT Business Analyst EXC
1080301-09234 User Support Specialist III 13 IT Business Analyst EXC
1080301-09581 User Support Specialist III 13 IT Business Analyst EXC
1080301-08135 User Support Specialist III 13 IT Business Analyst EXC
10. To upwardly reclassify the following positions:
4
From
Position Title Grade
09
To
Position Title
Data Processing
Equipment Operator II
Overtime
Category 1
Non-Exempt
Position # 'rade
1080601-00380 08 Data Processing Equipment
Operator III
1080601-10415 Network System Specialist Deployment Services
Technician
EXC Exempt EXC
1080201-06367 Application Analyst Programmer I Multi-Media Specialist EXC Exempt EXC
From 1 To !
Position # Position Title Grade Position Title Grade 1 1 1080601-03480 Customer Services Technician I 08 Customer Services Technician III 12
I 1080301-09231 Application Analyst Programmer II EXC Application Analyst Programmer III EXC
11. To downwardly reclassify the following positions:
Chairperson, on behalf of the Human Resources Committee, I move the adoption of the foregoing resolution.
HUMAN RESOURCES COMMITTEE
5
Resolution #13190 July 17, 2013
The Chairperson referred the resolution to the Finance Committee. There were no objections.
FISCAL NOTE M.R. #13190 August 1, 2013
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: HUMAN RESOURCES DEPARTMENT - INFORMATION TECHNOLOGY
DEPARTMENT POSITION AND SALARY STRUCTURE CHANGES
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-C of this Board, the Finance Committee has reviewed the above
referenced resolution and finds:
1. Information Technology (IT) Department has had extreme difficulty retaining and finding
qualified applicants for vacancies creating a 13% to 22% vacancy rate.
2. The Human Resources Department retained the Segal Company to evaluate Oakland
County's IT compensation and conduct a comprehensive market survey study.
3. The results of the study concluded that some IT classifications are below the market
average for the Detroit Metropolitan area.
4. Human Resources and IT Departments have analyzed the current classifications and
salary ranges in relation to the market survey data. It has been determined that there is
sufficient support for classification changes and salary range adjustments.
5. The reorganization requests the creation, deletion, reclassification, removal of
classifications from the County's Salary Administration Plan, and salary range
adjustments to meet organizational needs.
6. To delete the following FTE Proprietary (PR) funded positions: Internal Services
Supervisor (1080101-03494), Application Analyst Programmer 11 (1080201-00220),
Application Analyst Programmer 11 (1080201-01341) and Customer Service Technician
11 (1080601-01260).
7. To create the following full-time eligible Proprietary (PR) funded positions: Application
Architect (1080201) and Technical Architect (1080601).
8. Upwardly reclassify the following positions: (1080601-03480) Customer Services
Technician I to Customer Services Technician III and (1080301-09231) Application
Analyst Programmer II to Application Analyst Programmer III.
9. To downwardly reclassify the following positions: (1080601-00380) Data Processing
Equipment Operator III to Data Processing Equipment Operator II, (1080601-10415)
Network System Specialist to Deployment Services Technician and (1080201-06367)
Application Analyst Programmer II to Multi-Media Specialist.
10. FY 2013 funding is available from salary and fringe benefit favorability due to vacant
positions. For FY 2014 and beyond, the Information Technology billing rate structure
will be reviewed and updated as needed to cover costs.
11. A budget amendment is recommended as follows:
Information Technology (63600) FY 2013 FY2014 FY 2015
Revenue
63600-1080101-152000-665882 Fund Bal $68,341 441,458 447,637
Total Revenue $68.341 441,458 447 637
Expense
Creation of New Salary Range (Step 6)
63600-1080101-152000-702010 Salaries
63600-1080101-152000-722900 Fringe Adj
63600-1080201-121010-702010 Salaries
63600-1080201-121010-722900 Fringe Adj
63600-1080201-132200-702010Salaries
63600-1080201-132200-722900 Fringe Adj
63600-1080201-152000-702010Salaries
63600-1080201-152000-722900Fringe Adj
63600-1080201-152020-702010Salaries
63600-1080201-152020-722900Fringe Adj
63600-1080201-152030-702010Salaries
63600-1080201-152030-722900 Fringe Adj
3,289
1,576
8,194
3,925
9,823
4,705
3,380
1,619
2,513
1,203
3,035
1,454
21,808
10,119
54,323
25,206
65,128
30,219
22,410
10,398
16,658
7,729
20,123
9,337
22,026
10,337
54,867
25,749
65,779
30,871
22,635
10,623
16,825
7,896
20,324
9,538
63600-1080201-182190-702010 Salaries
63600-1080201-182190-722900Fringe Adj
63600-1080601-152015-702010 Salaries
63600-1080601-152015-722900Fringe Adj
63600-1080601-152090-702010 Salaries
63600-1080601-152090-722900Fringe Adj
3,500
1,676
5,853
2,804
13,279
6,360
23,203
10,766
38,805
18,006
88,037
40,849
(59,510)
(21,654)
23,435
10,998
39,193
18,394
88,917
41,729
(60,105)
(21,930)
Deletion of Internal Services Supervisor
63600-1080101-152000-702010 Salaries (8,976)
63600-1080101-152000-722900 Fringe Adj (3,331)
Deletion of Apo Analyst Programmer II
63600-1080201-121010-702010 Salaries (8,976) (59,510) (60,105)
63600-1080201-121010-722900 Fringe Adj (6,524) (42,411) (42,687)
Deletion of App Analyst Programmer II
63600-1080201-132200-702010 Salaries
63600-1080201-132200-722900 Fringe Adj
Deletion of Customer Service Tech II
63600-1080601-152090-702010 Salaries (7,351)
63600-1080601-152090-722900 Fringe Adj (5,757)
Creation of Two New Positions
63600-1080601-152090-702010 Salaries
63600-1080601-152090-722900 Fringe Adj
63600-1080201-152000-702010 Salaries
63600-1080201-152000-722900 Fringe Adj
Upwardly Reclassify CustTech Ito Cust Tech III
63600-1080601-152090-702010 Salaries 3,195
63600-1080601-152090-722900 Fringe Adj 1,938
(48,738) (49,225)
(37,421) (37,647)
18,124 18,306
8,410 8,494
(8,976) (59,510) (60,105)
(3,331) (21,654) (21,930)
11,800 78,236 79,018
7,939 51,146 51,510
11,800 78,236 79,018
7,939 51,146 51,510
Downwardly Reclassify Data Processing Equip Oper III to Data Processing Equip Oper II
63600-1080601-152090-702010 Salaries (675) ($4,478) ($4,523)
63600-1080601-152090-722900 Fringe Adj (562) ($2,078) ($2,098)
Total Expenses $68341 $441,458 U4LL637
Fire Records Management System (53100)
Revenue
53100-1080325-115100-665882 Fund Bal
Total Revenue
5.156 28,119 28.443
$5 156 $28 119 $28,443
7,990 8,070
3,707 3,787
Expense
Creation of New Salary Range (Step 6)
53100-1080325-115100-702010 Salaries 1,205
53100-1080325-115100-722900 Fringe Adj 577
Upwardly Reclassify App Analyst Proq II to App Analyst Proq III
53100-1080325-152000-702010 Salaries
53100-1080325-152000-722900 Fringe Adj
1,947
1 427
11,217 11,329
5,205 5 257
Total Expenses $5,156 $28.119 $28,443
CLEMIS (53500)
Revenue
53500-1080301-116020-665882 Fund Bal
Total Revenue
7,380
$7,380
48,434 49,096
$48,434 $49,096
Expense
Creation of New Salary Range (Step 6)
53500-1080301-116020-702010 Salaries
53500-1080301-116020-722900 Fringe Adj
Total Expenses
4,990
2,390
S7,380
33,083 33,414
15,351 15,682
$48 4:14 $49,096
Telephone Communications (67500)
Revenue
67500-1080601-152090-665882 Fund Bal
Total Revenue
1.890
$1 890
12,407
$12,407
12,576
$12 576
Expense
Creation of New Salary Range (Step 6)
67500-1080601-152090-702010 Salaries
67500-1080601-152090-722900 Fringe Adj
Total Expenses
1,278 8,475 8,559
612 3,932 4,017
$1 890 $12,407 $12,576
E COpV[IT-Ti_ EE
FINANCE COMMITTEE VOTE:
Motion carried on a roll call vote with Woodward voting no.
v/
Resolution #13190 August 1, 2013
Moved by Scott supported by Hatchett the resolution (with fiscal note attached) be adopted.
AYES: Jackson, Long, Matis, McGillivray, Middleton, Quarles, Runestad, Scott, Spisz, Taub,
Weipert, Zack, Bosnic, Crawford, Dwyer, Gershenson, Gingell, Gosselin, Hatchett, Hoffman. (20)
NAYS: Woodward. (1)
A sufficient majority having voted in favor, the resolution (with fiscal note attached) was adopted.
HEREBY APPROVE THIS RESOLUTION
CHIEF DEPUTY COUNTY EXECUTIVE
ACTING PURSUANT TO MCL 45559A (7)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and
accurate copy of a resolution adopted by the Oakland County Board of Commissioners on August 1,
2013, with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at
Pontiac, Michigan this 1 st day of August, 2013.
Lisa Brown, Oakland County