The URL can be used to link to this page

Home My WebLink AboutResolutions - 1999.02.25 - 25717Personnel Committee Vote: February 25, 1999 REPORT (Mi sc. #99044) BY: PERSONNEL COMMITTEE, THOMAS A. LAW, CHAIRPERSON IN RE: SHERIFF'S DEPARTMENT/DEPARTMENT OF INFORMATION TECHNOLOGY - COMMUNITY ORIENTED POLICING SERVICES - MAKING OFFICER REDEPLOYMENT EFFECTIVE (COPS-MORE) GRANT ACCEPTANCE AND PERSONNEL ALLOCATION TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: The Personnel Committee, having reviewed the above-referenced resolution on February 17, 1999, reports with the recommendation that the resolution be adopted. Chairperson, on behalf of the Personnel Committee, I move acceptance of the foregoing Report. PERSONNEL COMMITTEE Motion carried unanimously on a roll call vote with Gregory, Moffitt and Colasanti absent. ' MISCELLANEOUS RESOLUTION #99044 February 25, 1999 BY: PUBLIC SERVICES COMMITTEE, FRANK MILLARD, CHAIRPERSON IN RE: SHERIFF'S DEPARTMENT/DEPARTMENT OF INFORMATION TECHNOLOGY - COMMUNITY ORIENTED POLICING SERVICES - MAKING OFFICER REDEPLOYMENT EFFECTIVE (COPS-MORE) GRANT ACCEPTANCE AND PERSONNEL ALLOCATION TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: WHEREAS pursuant to M.R. #98115, Oakland County applied to the United States Department of Justice (DOJ) for $26,323,540 in Community Oriented Policing Services - Making Officer Redeployment Effective (COPS-MORE) funding, of which $19,122,807 (73%) was to reflect federal dollars and the balance (27%)to reflect non-federal sources; and WHEREAS final submission of the grant application revised the total request to $28,096,540, of which $20,898,576 (74%) reflected federal funds and $7,197,964 (26%) reflected non-federal sources; and WHEREAS the United States Department of Justice has awarded Oakland County a COPS-MORE grant in the amount of $23,151,974, 82.4% of the final application amount. Of the total, $17,132,461 (74%) reflects federal dollars and $6,019,513 (26%) reflects non-federal sources; and WHEREAS the non-federal sources can be covered by a non-departmental grant match appropriation authorized by the Board of Commissioners, no additional County appropriation is required; and WHEREAS although the final grant budget details have yet to be finalized, it is important to move the process forward, accepting the grant, allocating personnel, and authorizing expenditures from grant sources; and WHEREAS implementation of the grant entails establishment of a new Special Revenue Fund, creation of a new division within the Department of Information Technology entitled CLEMIS & Public Safety with units of Administration, Product Support, Emergency Operations and Emergency Management; and WHEREAS staffing of the aforementioned division involves creation of twelve (12) positions, including creation/deletion of appropriate classifications and reclassification and transfers of existing positions; and WHEREAS once final budget details are complete, a separate resolution authorizing final budget parameters will be sent to the appropriate Board of Commissioners' committees. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners accepts the Community Oriented Policing Services - Making Officer Redeployment Effective Grant, from the United States Department of Justice, in the amount of $23,151,974, of which $17,132,461 (74%) reflects federal dollars and $6,019,513 (26%) reflects County match. BE IT FURTHER RESOLVED that a new Special Revenue Fund entitled COPS-MORE GRANT be created, and creation of a new division within the Department of Information Technology entitled CLEMIS & Public Safety is authorized with units of Administration, Product Support, Emergency Operations and Emergency Management. BE IT FURTHER RESOLVED that creation of the following classifications is authorized: Manager-CLEMIS & Public Safety (Salary Range $70,475 -91,684, 0/T Exempt), Administrator - Emergency Operations (Grade 18, 0/T Exempt), Data Security Specialist (Salary Range- $49,568 - $65,190, 0/T Exempt), Installation Coordinator (Grade 13, 0/T Non-Exempt), and deletion of the following classification: Supv.-CLEMIS Support Services. PUBLIC SERVICES COMMITTEE VOTE: Motion carried unanimously on a roll call vote with Causey-Mitchell absent. c PUBLIC SERVICES BE IT FURTHER RESOLVED that the following twelve (12) positions be created: 2 SR Application Analyst/Programmers II (Product Support Unit) 1 SR User Support Specialist III (Product Support Unit) 1 SR User Support Specialist II (Product Support Unit) 1 SR Systems Software Specialists (Technical Systems & Networking Div) 2 SR Network Systems Specialists (Technical Systems & Networking Div) 2 SR Network Systems Analysts II (Technical Systems & Networking Div) 1 SR Data Base Administrator (Technical Systems & Networking Div) 1 PR Data Security Specialist (Administration Division) 1 SR Customer Service Technician II (Data Center Operations Division) BE IT FURTHER RESOLVED that the following reclassifications are authorized consistent with the attached recommended organizational charts and staffing schedule: Current Title Proposed Title Supv II-Info Tech Mgr-CLEMIS & Public Safety Supv-CLEMIS Support Services Administrator - Emergency Operations User Support Specialist III Supv I-Info Tech Systems Software Specialist Data Base Administrator Customer Services Tech III Installation Coordinator BE IT FURTHER RESOLVED that the following reorganization is authorized consistent with the attached recommended organizational charts and staffing schedule: Title Position Number New Location Mgr-CLEMIS & Public Safety 18201-02886 CLEMIS & PS/Administration Project Support Specialist 18201-04693 CLEMIS & PS/Administration Typist II 18230-04724 CLEMIS & PS/Administration Typist I 18230-06893 CLEMIS & PS/Administration Supv I-Info Tech 18201-02278 CLEMIS & PS/Product Support User Support Specialist III 18201-08135 CLEMIS & PS/Product Support User Support Specialist III 18201-04730 CLEMIS & PS/Product Support User Support Specialist III 18201-06370 CLEMIS & PS/Product Support Application Analyst/Prog. III 18201-01957 CLEMIS & PS/Product Support Application Analyst/Prog. II 18201-01700 CLEMIS & PS/Product Support Application Analyst/Prog. II 18201-02852 CLEMIS & PS/Product Support Application Analyst/Prog. I 18201-02592 CLEMIS & PS/Product Support Admin.-Emergency Operations 18201-08134 CLEMIS & PS/Emergency Oprtns Disaster Contl & Civil Def Dir Chief-Emergency Management Emergency Mgt. Specialist Emergency Mgt. Coordinator Technical Assistant Data Base Administrator Installation Coordinator Student Engineer 18230-06771 18230-00764 18230-00737 18230-03412 18230-03438 18201-00513 18401-04696 18201-07572 CLEMIS & PS/Emergency Mgt. CLEMIS & PS/Emergency Mgt. CLEMIS & PS/Emergency Mgt. CLEMIS & PS/Emergency Mgt. CLEMIS & PS/Emergency Mgt. Tech. Systems/Data Base Data Center/Customer Support Technical Systems/Netwk. Tech. BE IT FURTHER RESOLVED that the Chairperson of the Board is authorized to execute the grant agreement and to approve grant modifications and extensions, up to a fifteen (15) percent variance, consistent with the grant as originally approved. BE IT FURTHER RESOLVED that continuation of these services including personnel, are dependent upon continued federal funding. Chairperson, on behalf of the Public Services Comm,ieftee, I imove the adoption of the foregoing resolution. U.S. Dapartmant at Jsodos Of3ea at Communly °denied Padre &Waft A 12/01/11 TVS , 14: 314 pa 1. vo 3500420 MASAI S S g 1101 DOS C.0 .10 . . nn•nn•• r 12/01/08 TES 13:80 FAX 20211.136041 Tu2 ism PAX 20211,3608 . n=l1••n•• • OM= ef Convarmadons 111:0 VannentAva.. Waatiraam OG WSW Embargoed Until 9:00 , A.M. Contact: Dan Pfeiffer Tuesday, December 1,1998 202-616-1728 OAICLAND COUNTY LAW ENFORCEMENT CONSORTIUM TO RECEIVE INNOVATIVE GRANT $ 17 Million in Grants for Tedutolov and Civilian Hires to Pia MOPC Officers on the Beat WASHINOTC IN, D.C. — The Department of Justice's Office of Community Osionted Polidng Services (Cal) today announced a $17 million grant to the Oaldand County Law Enforcement Canso:than mder the,COPS MORE '98 (Making Officer Redeployment Effective) program. CA :IPS MORE '98 grants allow law enforcanent agencies to move officers out of adminis !relive tasks and put them on the streets by funding the acquisition of time-saving tec.hnolog; and equipment, or the hiring of civilians. "COPS MORE '98 is a cost effective way of getting more officers into communities to better serve our citizims, "said Joseph E. Erwin, Director of the COPS Office. mkt program is eXtemely i,cpular because police chiefs and sheriffs recognize that technology and redeploying officers C: a greatly enhance an agency's community policing efforts." The Oakland County I:Aw Enforcement Consortium is a collection of law enforcement agencies in Oakland C 'runty that caine together to apply for COPS MORE '98 funds. Congressman Sanderl.evin (D-Sterling Heights) was responsible for the stetutory language that allow smaller dep utments to work together to apply for COPS funds. This grant progam is authorized under the 1994 Crime Art to promote community policing To receive a pant, law enforcement agencies must demonstrate thf technology, equiment, or nrciport ataff funded will increase the number of officers deplbyed in community policing. 7:oday's grants will produce time-sringsequivalent to adding more then 685 full-tizne caws thesUoots in one Yea. - Vice President Gore announced the first round of MORE '98 recipients in October. To date, more than $240 million has been awarded to over 600 law enforcement agencies , nationwide Imder Cal MORE '98. The demand $:c COPS MORE 498 grants was overwhelming. More than 3,000 applications, requestir .; more than $700 million, poured into the COPS Office. 0## ;.1/01/1p11 TO11,14:33,7,411 1$10 310 0410 411111111'11 1.11. • ..111/03,111.7011 13:0? 2010111101 DIU nnn•nn••• •••• G1 COPS MORE Nowak" Kt IN Jarbettiss time AO 7.7.= State 1stinstad Itesikkag aeon Ibises! Award 1112 • -,====.. 141i1Passat on. ••••• ra. Oak 100 Cagey Law Bahriamett Camay= •••••• • 61•nn•n MI $17.172,461.00 4125.3 NMI •0=1111n•••.•••nn • $0.00 317,132,461.00 okk. - U.S. Department el &sees Office of Cenesrey Orbited PeMeg Savior . • iloo vermise hie, NW wasNixesn. DC 20100 CarimunicalonsOkisior $2/01/#$ TU11 ,14:33,41 1 $10 330 0420 SEN. ABRAHAA 12/01/9$ TUI 13:01 PAZ 202$14$$$$ DOJ C.O.P.S. FACT SHEET: Kay Points on COPS MORE ▪ The COPS Off o3 has two main programs to fulfill President Clinton's pledge to add 100,000 officers to the beat — hiring (Universal Hiring Program) and • redeployment (lVIsidrig Officer Redeployment Effective). While some jurisdictions simply need to h me more officers, others have the officers but need the ceps* to use them MOM efficiently. • Local law enforcement agencies can choose to apply for hiAng grants. redeployment grants. or both dependirg what they feel is the best way to meet their public safist,r needs. • A recent study oi cities and towns participating in the program showed that officers are speniing 53 percent mon: time on the stmet than had been Proiected. • MORE is one of COPS most popular programs. This year. COPS received three times as many requests as it could fund. • More than.25 pecant of COPS MORE grants are for •thillanizettiore — the hiring of civilians to free sworn officers from administrative tasks and put them on the street • It is less expensive for many communities to use technology and hire civilians to put an aiready-tried officer on the street than to hire a new one. • To receive COP. MORE funds, communities must demonstrate that using technok:gyer hinig civilians Is as efficient -and itet-effeclive as hiring new officers. • Because the COC'S Office believes that local jurisdictions know their communities. their public safety needs, and their personnel best, they tell the COPS Office how much additional time the requested technology and dvilen hires will allow officers to spend in. community. • Agencies awarde:I COPS MORE•grants are required to calculate and track redeployment tea fized from the technology and civilian hires. This information is collected through quarterly surveys of all COPS grantees, site visits, and required progress repons. 12/01/.93 11.1E,14:33 FA.1 810 350 0421_ 12/0 1/9 g TV E 13:0? FAX 20211165151 ACIAAAAA 0.4. •nn,,41., DOS) C.O.P.S. teral" UAL Dtperintont Of idea= , Ofrom of Community °dotted Policing Serviois COPS MORE '98 COPS MORRIS (Making OS Air Redeployment Effective) is one of ',vend rot pageants developed by the U.S. Department artistica under the 1994 Crime Act to increase the laptop:tad of cominunity policing oases to America's streets. Ibis program. which is apt to all qua .1ffed law adornment agendas, is designed to expand the tints available for community policing by current la., enforcement officers. These grants will be used to puregnue technology and equipment and to hire support sty!, including dvilian personnel. This allows law enforcement agencies to redeploy officers so more of their time is spoil pounding the pavement instead of pounding a typewriter. Funding Provisions State, kcal and other public law s ltarant agendas are eligible for grants under COPS M DRS 18. Applications we reviewed competitively Over:1200 ufl1on b evadable in funding under COPS MORS It This program was ocizernely coutpevo OOPS recemed dues ems as many applicatbos a could be fuelled. -- Applicents were required to dem mutate how COPS MORE 18 hinds win result in act: :al increases in the nontbar of officers deployed in a immunity polidng. Some examples of Loans that wit be funded under COPS MORE '98 include snob& data computers, mapping software, complaint aid ad dispatch Miaow booking clerks, dispatchers, and other dvilian postdate. Grans arrer up to 75 pencent of don total COSt Oi the tedirtoLoiry, equipment or dvdiert 'glades for cne yoga Therefore, agenda recetving gent am required to melds a minimum 25 patent local cuh sr latch. Waivers of the local cash match eequirement are granb:d only in as of annum Ica! fiscal hardship. It may be possible, Feeding amgressional appropdadoos, to mew grants for civilian hiring for two additional rms. COPS MORS 16 funds must not be used to replace funds that agenda' odorwitte would have divvied behoolegy equipment or dvilian hiring. In other words, any use of COPS MORE '98 NMI must be in addition to, and not In lieu of, previous funding cottunitments for law enforcement. In addiiion, the applicantr are required to include a plan for coati:wink the proposes:I activity Alter the COPS MORE '98 grant ends. An award under COPS MORE '98 will not affect the eligibility of an agency for other COPS program Siznilady, agenda teceiviffig funding under other COPS plogranut we= ingibli to apply for COPS MORE '98. funds. For more information, plasm call the U.S. Department of Justice Response Canter at 14004214770. a., Wets& h., weber 2L 0 REQUEST: To reorganize the Information Technology department, including the following actions: I. To create a new division of CLEMIS & Public Safety with units of Administration, Product Support, Emergency Operations. and Emergency Management. 2. To create the following new classifications: Base 1 Year 2 Year 3 Year 4 Year 5 Year Oir Manager-CLEMIS & Public Safety $ 70,475 74,719 78,959 83,198 87,440 91,684 exempt Data Security Specialist $ 49,568 52,695 55,817 58,942 62,068 65,191 exempt Administrator-Emergency Operations at salary grade 18, over-time exempt Installation Coordinator at salary grade 13, over-time non-exempt. 3. To create 1 PR and 11 SR positions: Class 2 SR Application/Analyst Programmers H 1 SR User Support Specialist III 1 SR User Support Specialist II 1 SR Systems Software Specialist 2 SR Network Systems Specialists 2 SR Network Systems Analysts II 1 SR Data Base Administrator 1 PR Data Security Specialist J. SR Customer Service Technician II 12 Location CLEMIS&PS / Product Support CLEMIS&PS / Product Support CLEMIS&PS / Product Support Technical Systems/Technical Services Technical Systems/Technical Services Technical Systems/Technical Services Technical Systems/Data Base Administration division Data Center Operations/Customer Services 4. To reclassify positions. (Cost information provided in the following materials.) Current Title Supv II - InfoTech Supv-CLEMIS Support Svcs. User Support Specialist III Systems Software Specialist Customer Services Tech III Proposed Title Mgr-CLEMIS & Public Safety Administrator:pmergency Operations Supv I - InfoTeat Oita Base Administrator Installation Coordinator 5. To transfer positions as follows to CLEMIS & Public Safety as reflected on the attached proposed organizational charts. Title Mgr.-CLENHS & PS (reclass) Admin-Emergency Op.(reclass) Supv I - InfoTech. (reclass) Chief- Emergency Mgt. Position Number Proposed New Location CLEMIS & PS/Administration CLEMIS & PS/Emergency Operations CLEMIS & PS/Product Support CLEMIS & PS/Emergency Mgt. 18201-02886 18201-08134 18201-02278 18230-00764 User Support SpcIst.III User Support SpcIst.III User Support SpcIst.111 Application Analyst/Prog. III Application Analyst/Prog. II Application Analyst/Prog. II Application Analyst/Prog. I Emergency Mgt. Specialist Emergency Mgt. Coord. Technical Assistant Project Support Specialist Typist II Typist I Disaster Cntl & Civil Def. Dir. Data Base Administrator (reclass) Installation Coordinator (reclass) Student Engineer 18201- 08135 18201-04730 18201- 06370 18201- 01957 18201- 01700 18201-02852 18201-02592 18230-00737 18230-03412 18230-03438 18201-04693 18230-04724 18230-06893 18230-06771 18201-00513 18401-04696 18201-07572 CLEMIS & PS/Product Support CLEMIS & PS/ Product Support CLEMIS & PS/Product Support CLEMIS & PS/ Product Support CLEMIS & PS/Product Support CLEMIS & PS/ Product Support .CLEMIS & PS/Product Support CLEMIS & PS/Emergency Mgt. CLEMIS & PS/Emergency Mgt. CLEMIS & PS/Emergency Mgt. CLEMIS & PS/Admin. CLEMIS & PS/Admin. CLEMIS & PS/Admin. CLEMIS & PS/Emergency Mgt. Tech. Systems/Data Base Data Center/Customer Support Technical Systems/Netwk. Tecluilgy. 6. To delete the classification titled Supv-CLEMIS Support Svcs. from the Salary Schedule. BOARD/COMMITTEE ACTION 2/16/99 2/17/99 2/18/99 2/25/99 Public Services Personnel Committee Finance Committee Final Board of Commissioners PROPOSED FUNDING t. 6 New position requests will be paid from the COPS MORE federal grant. Position upgrades and one new PR position .are proposed to be funded from_CLE4115 and 'Information Technology proprietary funds. .16 OVERVIEW Oakland County was awarded a $17 million federal demonstration grant in December, 1998, to update and expand the present CLEMIS (Court and Law Enforcement Management Information System). The new Windows based system is proposed to expand the data available to officers in Southeast Michigan. including criminal histories, mug shots, photos of crime scenes and interactive maps. Increased communication among dispatchers and officers is also expected. The departments of Information Technology. Management & Budget and Personnel have reviewed the personnel resources needed for this project. By utilizing existing positions and functions currently within Information Technology, the original list of additional resources required was reduced to the present request as an interim change. A new Information Technology division is proposed, with additional technical positions and upgrades requested for three existing InfoTech divisions. A new division of CLEMIS&Pubfic Safety is proposed, with units of Administration, Product Support, Emergency Operations and Emergency Management. Division staffing would primarily be obtained by transferring existing positions from the Law Enforcement and Emergency Management units of the Systems Development & Support division. The existing Supv II - InfoTech position assigned to CLEMIS would be reclassified to Manager - CLEMIS & Public Safety, and the current Supv-CLEMIS Support Services would be reclassified to Administrator- Emergency Operations. The Manager - C & PS would have project planning and implementation responsibility, would coordinate staff needs with other division managers, and direct contractual and County staff. The Administrator-Emergency Operations would be responsible for specific upgrades in dispatcher software and communications, for coordinating related training, and for the Emergency Management function. The Product Support unit would contain the division's dedicated software programmer and customer training staff. To address the expanded scope of CLEMIS, two additional Application Analyst/ Programmers II, one User Support Specialist III, and one User Support Specia,Ost II is requested. A reclassification of an existing User Support Specialist III position to Supervisor I - IT is requested to provide unit supervision.- . • The Emergency Management unit would consist entirely of existing staff, providing a plan for response and recovery services for natural and emergency disaster situations within the Cgunty. The upgrade and replacement of County-wide E911 communication system equipment is a significant part of this package. The Technical Systems & Networking division is committed to providing the extensive operating system. data base. and client/server networking expertise that is essential to an expanded CLEMIS program. An existing Systems Software Specialist position is requested to be transferred from CLENIIS to the Data Base unit, and reclassified to Data Base Administrator. This position will primarily address existing CLEMIS needs. One additional Data Base Administrator position is requested to focus on the expanded data base needs for the upgraded system. Salary & Fringe Benefits $65,986 ea. x2 = $131,972 $ 59,987 $ 56,937 $ 82,242 $73,246ea. x2 = $146,492 $65 C18 • 6 ea x2 = $131,972 $ 82,212 $ 73,246 $ 54.040 $ 819,070 One position of System Software Specialist, two positions of Network Systems Specialist and two positions of Network Systems Analyst II are requested for the Technical Services unit, and will be dedicated to the expanded CLEMIS/Public Safety system, with the Systems Software Specialist providing supervision. One Network Systems Specialist will be assigned over the new MicroSoft NT system file server (CLEMIS), and one will be assigned over the Tandem system file server (computer aided dispatch). Due to the 24 hour nature of the operation, each of these lead workers will be assisted by the requested Network System Analysts II. Flexible, cross. trained staff is anticipated to maximize efficiency. The Data Center Operations division currently addresses Information Technology related data line connectivity and trouble-shooting issues through its Customer Services unit. It is proposed that an experienced Customer Service Technician III be reclassified to Installation Coordinator, and assigned the connectivity related responsibilities of the proposed CLEMIS metropolitan area network (MAN). A new position of Customer Service Tech. II is requested to provide installation and trouble-shooting assistance. Finally, it is proposed to create a position of Data Security Specialist within the Administration division of the Information Technology Department to protect information system assets from intentional or inadvertent modification, disclosure, or destruction. While the security of electronic data is always a concern, the expanded role of the proposed CLEMIS & Public Safety system increases the importance of establishing this position. Incumbent would report directly to the department director, and have enterprise-wide responsibility. Salary & Fringe Benefit Costs New positions, salaries @ 1 yr. step, fringes @ 39%: Requested Position(s) 2 SRApplication/Analyst Programmers II 1 SRUser Support Specialist III 1 SRUser Support Specialist II 1 SR Systems Software Specialist 2 SR Network Systems Specialist 2 SR Network Systems Analysts II 1 SR Data Base Administrator 16` 1 PR Data Security Specialist (new class) J. SR Customer Service Tech. II 12 Salary & Fringe Benefit Costs. cant, Position reclassifications: Current Title. salary Proposed Title. salary Cost with Fringe@26 6% Supv II - InfoTech. $ 76,593 Supv-CLEMIS Suprt Svcs. $56,746 User Support Specialist III $53,177 Systems Software Specialist $76,937 Customer Services Tech III $55,413 Mgr-CLEMIS & Public Sfty $78,959 Admin- Emergency Oper. $59,960 Supv I - InfoTech $55,785 Data Base Administrator $ 76,937 Installation Coordinator $58,495 $2,995 $4,069 $3,302 -0- $3.90Z $14,268 Total Estimated Costs: New Positions Position reclassifications $ 819,070 $ 14.268 $ 833,338 COUNTY EXECUTIVE RECOMMENDATION: Recommended as Requested .0 , N REO FY 99 FY.00 C.P )27 INFORMATION TECHNOLOGY ADMINISTRATION REC 1 TOT TDIRECTOR – INFORMATION FY 99 PI 00 CP REO Y90 FY 00 2 2 FY 99 FY 00 2 2 2 2 TECHNOLOGY On Fund/Gan Purposo Special-Revenue Tote! Positions REO FY 99 FY CO DATA C REC FY 99 FY 00 CP 30 30 REO FY 90 FY 03 Totsifi=— NTER OPERATIONS TOT MANAGER – FY 99 FY 00 DATA CENTER OPERATIONS GNI Fund/Gen FtspOse Spedal Revenue 30 30 31 Pro41,148 • 30 Total Positions SYSTEMS DEVELOPMENT S SUPPORT FY 99 FY 00 FY 60 FY 00 DEVELOPMENT & SUPPORT TOT IMAGER – SYSTEMS REC 69 69 86 86 7 7 Oen Funren CURRENT INFORMATION TE REC FY 99 FY 00 CHNOLOGY DEPARTMENT TOT DIRECTOR – INFORMATION FY 99 FY 00 TECHNOLOGY 7 7 Girt FulidGen Purpose Special Rivenue 127 127 Total Positions 120 120 Proprietary 1201 120 1271 127 ' nentamapel^ OY-IUM if ZEIC=TraiCAC r SYSTEMS NETWORKING T DIGITAL INFORMATION SERVICE CENTER REO AEC TOT LUANAGER ---TblOiTAL INFORMATION-- FY 99 FY 00 FY 99 FY 00 FY 99 FY 00 SERYCE CENTER 12 TECHNICAL SYSTEMS REC I1 FY 99 FY 00 FY 99 CP FY 99 FY 00 CP 17 12 — 17 _ Oen FunrYGen Purpose Spiciat Revenue SERVICE CENTER Oen Fund/Gen Purpose Spiciat Revenue Propdehry Tots' PoeMone 12 12 121 12 - FY 00 FY 00 FY 99 FY 00 _ 1 ---- ---17 ----1-7 Note: Positions may work in venous functional teams to achieve Toilet Quality Objectives. Prepared by Persomel Dept 12a12195 REQ FY 99 FY 00 INFORMATION TE REC FY 99 FY 00 CHNOLOGY ADMI TOT FY 99 FY 00 CP • "IP CURRENT NISTRATION _ DIRECTOR — INFORMATION TECHNOLOGY _ Gen Fund/Gen Purpose Special Revenue __ _ Proprietary Total Positions GF/GP PR REQ REC FY 99 FY 00 ADMINISTRATION )1 1 1' 1 Director - Information Technology — - . ___ _ , _ _ 1 1 1 Secretary III .....__ _ 2 2 2 Total Positions • FY 99 " FY 00 Prepared by Personnel Dept. 9/24/98 cc .,1 1 i a „ 5.. tl . • • 5,1-e; 2 11 g. 8: • SI , 01 ai r' .1 If ; i 81 • Si b I ! , itil ••• ,fiiii 411 II1111 - -7 4.) Mi Mi f 101 taa ild In I El I I 8 -- I t tr , 8 - - ' - r- ; „ r, I I Me - I I i 'iiiit.t i ,I,,,,,.,,_,?... ,...., II,1:11,tii-i .,2_! 1 : *4 = 3:111 1 1w i ;DI, 4 11 % 5 e j 3 Is ...... _ 2Ht t I H ' . Ma f _ 5 IL 1. I* 111 ill tg sis • CP REG FY 99 FY 00 17 r" CURRENT TECHNICAL SYSTEMS & NETWORKING REC TOT MANAGER - TECHNICAL SYSTEMS FY 99 FY 00 FY 99 FY 00 a NETWORKING . Gen Fund/Gen Purpose Special Revenue 17 17 Proprietary . _ 17 17 Total Positions GF/GP I. PR REG REC FY 99 FY 00 ADMINISTRATION -- 1 1 1 Mansper2 Technical Systems S. Matra:kink _ _ 1 1 1 Total Positions GF/GP PR i REO REC FY 99 FY ocr TECHNICAL SERVICES I I I -reiirs(7-- Yealieirliiivicali 41 " 4 . —4 itii-leitii-Solliiiii asiiirdalist- 1 I 7 1 - - - T iiiiiToifSiiiimi Specialist 1 1 —1 NitiairkaystemiAnel. Analyst II (a) 7Tatel 7 Positions - itions GF/GP PR REO REC , FY 99 FY 00 NETWORK TECHNOLOGY 1 1 t Supv. - Dtsvibuted-Computing Technology — 1 1 I ApplocitiOni AniFyil/PrOgrammirT 2 2 2 Network SWOTS Analyst 0 (a) 1 I I Student 5 5 5 Total Positions s GF/OrP PR REO REC FY 99 FY 00 DATA BASE ADMINISTRATION (b) 1 1 1 Supervisor II- Inicaniatiii Technology (c) 3' 3 3 Data Base AdmInistrelor 4 . 4 4:Total Positions I 1 1. a : PositIzZieretitlefdr fror4Nsrtwork System Analyst. . Ras. #97258. 7Iffeesclvo:81122/10/9eff . ;dive 5/21198. ic Position retitled from Supv II - Systems Dev. per 1999 eudget. Prepared by Personnel Dept. 9 nues REO FY 99 FY00 DATA CENTER OPERATIONS REC TOT FY 99 FY 00 1 FY 99 FY 00 30 30 MANAGER - DATA CENTER OPERATIONS Gen FundlGen Purpiesi - PtoPrigIaCY _ . . Toler Positions CP CURRENT 11 I_OFIOP PR REO REC FY 99 FY 00 ADMINISTRATION . . _ 1 1 1 Manager - Data Center inerislions _ 1 Total Passions v IPR REO . 1 AEC FY 99 FY 00 HELP DESK 1 Customer Service Technkien II I 1 1 Total PosNons OF/GP PR REO 'AEC FY 99 FY 00 COMPUTER OPERATIONS I 1 1 Darresinjavient Operator 8upervisor _ _ _ 2 2 2 Oats PiIiu EnioM Omator III 4 Ms ii - --7----r GF/GP PR REO REC FY 99 FY 00 DATA ENTRY _ 1 Data Eon," Optima/ III 1 1 Data Entry_Ostor II 2 2 Total Positions GF/GP PR REO AEC FY 99 FY 00 PRODUCTION SERVICES i 1 1 Suprviscir Production Services 1 1 1 Produciion Scheduler 2 2 2 Produclion Control Analyst III 2 2 2 Production Control Analyst II 1 - -1 Clerk-- II /beim— eryper- son— - -- 1 1 1 Sludent 8 8 Total Positions • FY 99 •• FY 00 OF/OP PR REO REC FY 99 FY 00 CUSTOMER SERVICES -1 . -1 i Customer Service Supervisor 2 Customer Service Tethnician III 3 Customer Service Technician II ---1 I 1 CUilithii-SenriariTiciii- iiirii - 7 -- — la 3 3 3 Custorner Service Technician Trainee - Pi' 1 1 1 Student. Engineer (a) _ _ _ 11 11 11 Total Positions (a) Position funded 1,000 hr./yr. PINE. Prepared by Personnel Dept 9/24/98 REQ CP 1 FY 99 FY 00 7 • I - 120 12 REO FY 99 FY 00 TOT FY 99 FY 00 REO FY99 FY 00 CP 3101 3i 31 31 REC FY 99 FY 00 I SYSTEMS DEVELOPMENT IL SUPPORT REC TOT MANAGER - SYSTEMS FY 99 FY 00 FY 99 FY 00 DEVELOPMENT SUPPORT . . . Gan Fund/Gen Purpose 46 1-14.Cba 461 46 Total Positions DATA CENTER OPERATIONS FY 00 FY 99 FY 00 'DATA CENTER OPERATIONS TOT 'MANAGER- DATA - Gen Fund/Gen Purpose SLiecial Revenue Proprietary Total Positions ? CP CP - 19 19 FY 99 FY 00 1 SERVICE CENTER FT-in-Cl/Gen Purpose Specie? Revenue Proprietary Total Positions 12 12 12 121 12 TECHNICAL SYSTEMS I NE - - REO 1 REC— - tor R---7-rtattirc-Ai FY 99 FY 00 1 FY 99 FY 00 FY 99 FY 00 SYSE4S a NETWORKING I 61 I __.5 . _ 61 6 Gin iiFFE4T I 8 25 25 YEW Posirons 18 19 r16--C-oo detary -gi ---vanue 6 i I DIGITAL INFORMATION SERVICE CENTER FY 99 FY 99 FY 00 1 FY 00 1 FY 99 FY 00 SERVICE CENTER ' I Y-K* RED AEC TOT MANAGER- DIGITAL NFORMA 121 12 12 Note: Positions may work in various functional teams to achkwe Total Quality Objectives. Draft Prepared by Personnel Dept 1/13199 PROPOSED INFORMATION TECHNOLOGY DEPARTMENT REC j TOT DIRECTOR INFORMATION — FY 99 FY 00 FY 99 FY CO TECHNOLOGY 7 7 Gen Fund/Gen Purpose 11 11 11 Special Revenue 1 121 121 Proprietary 12 139 139 Total Positions INFORMATION TECHNOLOGY ADMINISTRATION gEo REC TOT IDIRECTOR - INFORMATION FY 99 FY 00 FY 99 FY 00 FY 99 FY 00 . 1 I 1 31 3 3 TECHNOLOGY Gen Fund/Gen Purpose Spectel Revenue Proprietary Total Positrons -REG EIiiT CLEMIS It PUBLIC SAFETY (a) REC TOT FY 99 FY 00 1 -V 4 • 4 4 11 11 1 4 22 - 22 /AMAGER--; CLEMIS - — PUBLIC SAFETY Gen Ftindevin Purpose _ Special Revenue Proptiltaty Total Positions-- CP PROPOSED INFORMATION TECHNOLOGY ADMINISTRATION REG rREC TOT DIRECTOR – INFORMATION FY 99 FY 00 I FY 99 FY 00 FY 99 FY 00 TECHNOLOGY _ _ Gen Fund/Gen Purpose _ Special Revenue 1 31 3 Proprietary 1 3 3 Total Positions. GF/GP PR REC) REC FY 99 FY 00 ADMINISTRATION 1 1 1 Director – Information Technology . . _ 1. . 1 . 1 Data Security Specialist .. . . - —1 Secretary III 2- i — i - - - - - ----1 Taal Pistons I J. I % FY 99 " FY 00 Draft Prepared by Personnel Dept. 1/13199 CP REO FY 99 FY 00 I PROJECT OFFICE, SOFTWARE TRAINING & GF/GP PR REO REC FY 99 i FY 00 ADMINISTRATIVE SUPPORT t 1 , 1 Supd-Protect Once It Saivism Supped 1 1 . t I Teml Positions GF/GP PR REO REC FY 99 FY 00 ADMINISTRATIVE SERVICES 1 1 I 1 Supervisor - IT Admin. Services 1 1 , 1 Procurement Tech 1 I II 1 Clerk III 1 1 Typist II 41 4 Total Positions GF1GP PR REO REC FY 99 FY 00 TRAMING/1 SUPPORT 1 1 , 1 War Support Specialisi III 2 2 2 WM': SuiPort SOecialist II 3 _ 3 3 Total Positions GF/GP ' PR REO REC FY 99 FY 00 ILAND SYSTEMS 1 1 1 !Supervisor II - Info Technology _ 2 2 2 Applications Analyst / Programmer III _ ..._ 1 1 1 Usor Support Spocislisl II 2 2 2 Applications Analyst/Programmer I 6 -6 6 Tots/ Positions — PROPOSED SYSTEMS DEVELOPMENT & SUPPORT REC TOT MANAGER -; -SYSTEMS - FY 99 FY 00 FY 99 FY 00 DEVELOPMENT SUPPORT - Gin 46 Sped-al Revenue 46 Proprietary 46 46 Total Positions OFIGP PR REO REC FY 99 FY 00 ADMINISTRATION 1 1 1 Manager - Sy111•1118 DeyeioPment & Support 1 1 1 SePv II - MN Technology . _ _ .... 2 2 2 Tidal Positions GF1GP PR REO n REC FY 99 FY 00 SYSTEMS DEVELOPMENT i I 1 ChNI - Systems Development I. 1 1 Total Poialloni Of/GP PR REG) . REC I FY 99 FY 00 SUPPORT . _ . _ _ _ .. _ _ - _ _ . _ 1 , - -1 1 Ulm i"----irpicieil-ii 0 - - - - - -1- .-- ---i User Support Si-:•Mielist I 1 . 2 2 Total Position; .. OF/GP PR REO 1 REC FY 99 FY 00 ADMINISTRATNE SYSTEMS 1 1 Supervisor I - Ho Techology — - - — 1 _ - - --.5 — "--3. Ace-T-IceliWi-A-niTyro-1-1Frogr-7-enerielll - — 3 .. _ 1 — - - --1' ---3-Appleitiit7Piciogii--mrieft 1 : tPlii=_ _ _ _A/witit.!_i'mr. _limn . 4! ! A OF/GP PR REO i REC FY 99 FY 00 HEALTH SYSTEMS 1 1 1 SUP-eivrecilfAto Technology 1 1Applioetione Anoka I Programmer III 5 . . 5 S Applications Analyst / Programmer II 2 2 2 ApPlir.-line Maya I rtscsitnnwit I 9 9 9 Total Piiilo-ii-- "f— p 43F/GP' PR REG REC FY 99 FY 00 COURTS TEAM _ .. 1 Iii --1----Ekfiniiiigi--- - -- - 2 2 A-eiii ----AiiiWiii-niii ill 6-r 6 icallorre Anetyst-nrfogiern-iiiii II - - 1 1 User Support Spedellit II 1 1 ' 1 Appicellone Anekst/Pro-it -------- 10' 10 10 Tali Pulliam • FY 99 •• FY 00 Draft Prepared by Possanni Dept 1113121 CP 30 31 • FY 99 ** FY 00 (s) Position funded 1,000 hrJyr. PTNE. (b) Proposed reclassification from Customer Service Tech Ill. Prepared by Personnel Dept 219199 PROPOSED REO FY 99 FY00 DATA CENTER REC FY99 FY00 OPERATIONS TOT FY 99 FY00 00 31 MANAGER - DATA CENTER OPERATIONS Gen Fund/Gen Purpose Special Reveritie — et.srif4 • Total Positions GF/GP PR - REC FY 99 FY 00 ADMINISTRATION _ 1 "1--• 1 Manager - Dela Center Operations _ 1 I , 1 Total Positions GF/GP PR REO i REC FY 90 FY CO HELP DESK 1- -diatomic Sento* Technkian II - I . _ 1-TotelPositions I GF/GP PR REG REC FY 99 FY 00 COMPTER OPERATIONS 1 1 1 Data EquIpment_Aierator Supervisor 2 2 _ 2 Clate=g= III 4 4 1 bila _ _ 7 - - 2 GF/GP PR REO REC FY 99 FY 00 DATA ENTRY _ 1 1 Data Entry Operator III 1 1 _ _ _1 Data Envy Oator H - 2. 2 2 Total Positirms CF/OP PR - REO - REC FY 99 FY 00 -PRODUCTION SERVICES . ._ . 1 I I Suiwino; Production Services - 1 - I 1 Production Scheduler 2 2 Production Control Ansdyst ill - - _ -2 — 2 2 Pro áiCarlini Analyst ii -- --- - -- 1 1 1 Cleft II / Delovervperson _. _ _ 1 1 1 Student - . . _.._ • 8 8 Total Poiiilions OFIGP PR REO REC FY 99 FY 00 CUSTOMER SERVICES 11 Customer Service Supervisor - - - -i . _ 1 _ 1 Installation Coordinator (0) --- - . - i I i Oilikiimi-Seivice Tecti-niCi-in-ill---- — - 4 Customer Service Technicien II • 1 1 I Customer Service Technicien I FF -3 ,..-- 3 3 Customer Service Technician Trainee 1 1 1 Student Engineer (a) 11 _ -12 ---i2 Te--Ail-P-o-iitiiiis- - PROPOSED CP j RECI — 6 6 TECHNICAL SY REC STEMS a NETWORKING TOT MANAGER - TECHNICAL SYSTEMS FY 99 FY 00 & NETWORKING Gen Fund/Gen Purpose 6 Special Revenue 19 19 Proprietary 25 25 Total Positions GFIGP I PR - REO REC FY 99 FY 00 ADMINISTRATION .._ 1 1 Manager- - Technical Systems IL Networidni 1 . .__ ... _._ .... _ . _ . _____ _ _. .. _. _ .iii_ I 1 1 1 Total Positions OF/GP PR: REO . .. _RES ........FY 99 Y ......f F_ 001'TECHNICAL vaeitSER_simei _VICES .. _ . 1 4 1 - - - . -1 ----6 '_-_----6-Siiiteits tar-vire Speciiiiist 1 2 - - 2 3 3 Netwootk Sylltel_n9 SPOthaest . 1 2 . 2 — 3 -- - 3 Network *Mame Analyst H 7 5 5 • — 12 — .11 liiiiiiiiiiion-s- - GF/GP PR . _. REG.REC FY 99 FY 00 NETWORK TECHNOLOGY _ i ' --1 tuPv =1:1119Wied-C-o-mputing Tedvuttogy 1 1 1 Applications AnslysUProgrammer I — _— 2 2 2 Network Systems Analyst II 1 1 I Student Engineer (a) 1 1 1 Student _ 8 a 13 Total Positions- - - - - - - — OF/GP PR REO REC FY 99 FY 00 DATA BASE ADMINISTRATION , ---- i - -- 1 1 Supervisor II - InlommtIon 'fedi/mew — 1 1 5 - 6 Dela Base Administrator (b) r• •• -- 5 1 1 6 6 Total Positions , ! '5. , (a) Position funded 1,000 hr./yr. PTNE. and transferred Korn system Development/Law Enforcement Unit. (b) Includes one (1) Systems Software Specialist position transferred from Systems Development/Law Enforcement and reclassified to Data Base Administrator. Draft Prepared by Pmsonnel Dept 1 /13/99 CP 4 PROPOSED 4 T - REO 11 18 CLEMIS a PUBLIC REC 4 4 SAFETY (a) TOT FY99 FY00 7 7 4 4 11 11 22 22 MANAGER - CLEMIS PUBLIC SAFETY Gen Fund/Gen Purpose Smdal Rev/in-US Prcpdsly - Total Positioiai — GFIGP PR REO REC FY 99 FY 00 ADMINISTRATION . _ . 1 -1 - 1 Maiii9114 --CLEMIS -a itublie-liiiiii(bi " I - 1 . . - 1 Prefeci Sup-port-Sireaillif - - --- - - . - I 1 1 Tycilst II (c) I 1 1 Typist I (c, g) . _ _ 2 _ 4 4 Total Positions OF !GP PR REG REC FY 09 FY 00 PRODUCT SUPPORT 1 1 1 Supervisor I - info Tectmology (d) 1 - 1 1 Analyst / Programmer III ' , 1 2! 2 3 3 _ Analyst / Programmer II 3 1 ! t 4 4 Ueir Cupport Specialist III 1 1 1 1 USit—S-V-p-ii—ort Spiel-11111i-- - -- 2 41 2 2 Applesions Analyst / Programmer I ' 8 4 ' 12 12 Total Positions GF/GP PR REO REC FY 99 FY 00 EMERGENCY OPERATIONS (e) 1 1 1 Administrator-Emergency Operations (I) Total Positions GF/GP PR REO REC FY 99 FY 00 , EIAERGENCY MANAGEMENT & E911 (a) 1 1 1 Chief-Emergency Management I 1 1 EmerVisncY Mardeorlyini Siwiakm 1 I 1 Emergency Management Coordinator 1 Technical Assailer* 1 Disaster Control a CD. Director (h) 5 Total Positions . (a) NI poellons transferred from Systems Development It Support °Melon acept km User Swat SpedaNst III positions and Iwo Application Analyst/Programmer N positions which are new requests. (b) Requested reclassification from Supv. N InloTechnology. p p (e) Funded by Health Fund. ; (d) Requested reclassification from User Support Specialist III. % • (e) Unit trenstessed from Ridges. Mgt/Admin. per MR. 808298, efts+, 12/10/98. Funded Isaiah Heads Fund. (I) Requested reclassification from Supv:CLEMIS Support Services. (g) Podium funded 1.000 ht/yr. PTNE. (h) Non-funded position. Prepared by Personnel Dept 2/10/99 et. • el t • ne • FISCAL NOTE (Misc. #99044) February 25, 1999 BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON IN RE: SHERIFF'S DEPARTMENT/DEPARTMENT OF INFORMATION TECHNOLOGY - COMMUNITY ORIENTED POLICING SERVICES - MAKING OFFICER REDEPLOYMENT EFFECTIVE (COPS-MORE) GRANT ACCEPTANCE 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. The United States Department of Justice has awarded Oakland County a Community Oriented Policing Services - Making Officer Redeployment Effective (COPS-MORE) grant in the amount of $23,151,974, of which $17,132,461 (74%) is federal funds and $6,019,513 (26%) is County match. 2. A special revenue fund shall be created to track all revenues and expenditures related to this COPS-MORE grant. 3. The County match is located in the non-departmental Grant Match account, these funds are to be transferred to the new special revenue fund. 4. New position and reclassification costs are summarized as follows: Special Revenue Funded Positions Salary/fringe 2 Application Analyst/Programmers $131,972 1 User Support Specialist III 59,987 1 User Support Specialist II 56,937 1 Systems Software Specialist 82,212 2 Network Systems Specialists 146,492 2 Network Systems Analysts II 131,972 1 Data Base Administrator 82,212 1 Customer Service Tech. II 54,040 11 Total Special Revenue Positions $745,824 Proprietary Funded Position 1 Data Security Specialist S 73,246 12 Total New Positions $819,070 Reclassifications Supv-Info Tech to Mgr.-CLEMIS& Public Sfty$ 2,995 Supv. CLEMIS Sppt to Emergency Oper. Admin. 4,069 User Sppt. Spec III to Supv I-Infor Tech 3,302 System Sftwre Spec to Data Base Admin. -0- Custmr Sys Tech III to Installation Coordinator 3,082 Total Reclassifications $ 13.448 Total Salary/Fringe Cost $832.518 5. The FY 1999 Budget is amended, as specified below, to reflect the preliminary grant budget: General Fund 90-210000-21000-2872 90-310000-21000-8001 Grant Match Operating Transfer $( 6,019,513) 6.019,513 0 FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote with Palmer absent. I y a a lb oil COPS-MORE GRANT Revenue 18-xxxxxx-xxxxx-0113 18-xxxxxx-xxxxx-1701 Grants - Federal Operating Transfer $17,132,461 6,019.513 $23,151,974 Expenditures 18-xxxxxx-xxxxx-2304 Accounting Services 500,000 18-xxxxxx-xxxxx-2001/2074 Salaries/Fringes 759,272 18-xxxxxx-xxxxx-3348 Professional Services 1,000,000 18-xxxxxx-xxxxx-3756 Travel and Conference 1,000 18-xxxxxx-xxxxx-4100 Expendable Equipment 20,891.702 $23.151,974 0 Information Technology Fund 18-636142-15000-2001/2074 Salaries/Fringes 73,246 18-636113-10000-8005 Changes in Fund Equity( 73,246) Total -0- 6. After final budget details are complete, including the allocation of personnel, a revised grant budget will be presented for the Board's approval. 7. The Plante & Moran contract will be extended 45 days while the competitive bid process goes forward so as not to impede transition between the design and implementation phases of COPS MORE project. FINANCE COMMITTEE 1 FEREBY4PPROVE OE FOREGOING RF L. Brooks Pete/ion, County Executive D G. William Caddell, County Clerk • 1 y n I • I • • • Resolution #99044 February 25, 1999 Moved by Millard supported by Moffitt the Personnel Committee Report be accepted. A sufficient majority having voted therefor, the report was accepted. Moved by Millard supported by Moffitt the resolution be adopted. AYES: Moffitt, Obrecht, Patterson, Sever, Suarez, Taub, Amos, Appel, Causey-Mitchell, Colasanti, Coleman, Devine, Dingeldey, Galloway, Garfield, Gregory, Jensen, McPherson, Millard. (19) NAYS: None. (0) A sufficient majority having voted therefor, the resolution was adopted. STATE OF MICHIGAN) COUNTY OF OAKLAND) I, G. William Caddell, 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 February 25, 1999 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 2.0th d4fr of February, 1999.