Loading...
HomeMy WebLinkAboutReports - 2023.07.20 - 40264 AGENDA ITEM: Creation of Application & Client Services Director, Infrastructure Services Director, (3) Business Relationship Managers and Deletion of (2) Application Development Directors, Deputy CIO, IT Supervisor, IT Project Manager DEPARTMENT: Information Technology MEETING: Board of Commissioners DATE: Thursday, July 20, 2023 8:35 PM - Click to View Agenda ITEM SUMMARY SHEET COMMITTEE REPORT TO BOARD Resolution #2023-3129 Motion to amend the FY 2023 – FY 2025 Budgets as reflected in the attached Schedule A – Budget Amendment and approve the organizational restructuring proposed by Information Technology as identified in Schedule B. ITEM CATEGORY SPONSORED BY Staffing Modification Gwen Markham INTRODUCTION AND BACKGROUND A new role of Business Relationship Manager will be created within the Department of Information Technology (“IT”). This role will enhance the relationship with the customer, enable the business to drive technology initiatives, build a trusted partnership between IT, and the business and provide a single point of contact for services. Additionally, IT is proposing to upwardly reclassify a vacant IT Supervisor II position to an Infrastructure Services Director to manage the County’s technology, and services related to Network Engineering and Administration, Telecommunications, Server Administration, Database Administration, Data Center Operations, Workstation, End User Device Management and End User Support (Service Center). Lastly, the current structure within IT for application services is separated into two separate organizations. IT is proposing to combine both organizations into one, titled Application & Client Services, and to create a singular Application & Client Services Director to lead all Application & Client Services Functions. This will allow IT to expand technical expertise and skill sets across the enterprise, better leverage technical resources across business priorities, increase overall throughput, improve projects being delivered on budget, on time and on quality, standardize system development lifecycle, improves quality and testing capabilities, improve organizational accountability, and improve overall customer satisfaction. This proposal is funded by eliminating five (5) FTE positions. The Information Technology Department has proposed a structural realignment of positions to provide best in class and industry standard system development and technology services. This proposal will allow Oakland County to be competitive in attracting high quality talent to drive the technology goals and objectives. The financial impact of this proposal will be $19,518 in 2023. BUDGET AMENDMENT REQUIRED: Yes Committee members can contact Michael Andrews, Policy and Fiscal Analysis Supervisor at 248.425.5572 or andrewsmb@oakgov.com, or the department contact persons listed for additional information. CONTACT Rod Davenport, Chief Information Officer ITEM REVIEW TRACKING Aaron Snover, Board of Commissioners Created/Initiated - 7/20/2023 AGENDA DEADLINE: 07/30/2023 8:35 PM ATTACHMENTS 1. PowerPoint - BRM's and IT Organizational Realignment 2. FY23 IT Reorganization - Schedule A Budget Amendment 3. FY23 IT Reorganization - Schedule B Organizational Changes 4. Schedule C - Illustrative Costing 5. FY23 IT Reorganization - Schedule D Draft Job Desc COMMITTEE TRACKING 2023-07-12 Finance - Recommend to Board 2023-07-20 Full Board - Adopt Motioned by: Commissioner Robert Hoffman Seconded by: Commissioner Angela Powell Yes: David Woodward, Michael Spisz, Michael Gingell, Penny Luebs, Karen Joliat, Kristen Nelson, Christine Long, Robert Hoffman, Philip Weipert, Gwen Markham, Angela Powell, Marcia Gershenson, Janet Jackson, Charles Cavell, Brendan Johnson, Ajay Raman (16) No: None (0) Abstain: None (0) Absent: Gary McGillivray, William Miller III, Yolanda Smith Charles (3) Passed Information Technology - Business Relationship Managers & Organizational Realignment •Creation of the Business Relationship Manager (BRM) Role •Consolidate Application Services Organizations •Recreate Director of Infrastructure Services Position •Cost Neutral Recommendation OUTLINE County Executive Economic Development Human Resources Health & Human Services Public Services Management & Budget GIS / Mapping / Access Oakland / Property Gateway Special Projects (COVID, Vaccine Hub, Strategic Framework, etc.) TechnologyAlignment, Integration & Accountability Board of Commissioners Clerk / Register of Deeds Courts – District, Circuit, Probate Sheriff’s Office Treasurer’s Office Water Resources Commissioner’s Office Parks & Recreation Internal Clients External Stakeholders CLEMIS Users CJIS Users Radio Users G2G Cooperative Arrangements First Responders OAKLAND COUNTY CUSTOMER LANDSCAPE Business Owner Technology Owner Business Relationship Manager CUSTOMER RELATIONSHIP MODEL The Business Relationship Manager (BRM) Role •Enhances the relationship with the customer •Enables the business to drive the initiatives •Builds a trusted partnership between IT and the business •Provides a single point of contact for IT services Assign BRM’s by the following strategic business areas: •Internal Customers •External Stakeholders •First Responders BRMs are accountable for all IT services and deliverables to the business THE BUSINESS RELATIONSHIP MANGER ROLE Internal Customers External Stakeholders First Responders Customer Relationship Model Infrastructure Services Director Applications (Core) Dev. & Main Director Office of the CIO Manager Applications (CLEMIS) Dev. & Main Director CURRENT APPLICATION DEVELOPMENT & MAINTENANCE ORGANIZATIONAL STRUCTURE Internal Customers External Stakeholders First Responders Customer Relationship Model Infrastructure Services Director Application & Client Services Director Office of the CIO Manager FUTURE APPLICATION DEVELOPMENT & MAINTENANCE ORGANIZATIONAL STRUCTURE Core Systems Division CLEMIS Division ORGANIZATIONAL REALIGNMENT Consolidate Applications Services Organizations •Expands Technical Skill Sets across the enterprise •Better Leverages Technical Resources across business priorities •Increases IT Throughput •Improves Projects being delivered on budget, on time and on quality •Standardizes System Development Lifecycle •Improves Quality and Testing Capabilities •Improves Organizational Accountability •Improves Customer Satisfaction ORGANIZTIONAL REALIGNMENT Recreate Director of Infrastructure Services Position •Improves IT Leadership across the compute, storage, network and helpdesk platforms, teams and resources •Increases IT Throughput •Improves Projects being delivered on budget, on time and on quality •Improves Organizational Accountability •Improve Customer Satisfaction Internal Customers External Stakeholders First Responders Customer Relationship Model Chief Information Officer Chief Information Security Officer Application & Client Services Director Chief Technology Officer Infrastructure Services Director FUTURE ORGANIZATIONAL STRUCTURE Office of the CIO Manager Core Systems Division CLEMIS Division RECOMMENDATION RECAP •Recommendation •Create •Create New Application & Client Services Director Position •Recreate Infrastructure Services Director Position •Create (3) new Business Relationship Manager Positions •Eliminate •Eliminate both Application Development Director Positions •Eliminate Deputy CIO Role •Eliminate IT Supervisor Role •Eliminate IT Project Manager Role •Fill all (3) Business Relationship Managers from within IT organization •Budget Impact •Total Cost for Remainder FY23 - $31,959 •Organizational Changes will be cost neutral Oakland County, Michigan INFORMATON TECHNOLOGY REORGANIZATION Schedule "A" DETAIL R/E Fund Name Division Name Fund # (FND)Cost Center (CCN) # Account # (RC/SC) Program # (PRG) Grant ID (GRN) # Project ID # (PROJ) Region (REG) Budget Fund Affiliate (BFA) Ledger Account Summar y Account Title FY 2023 Amendment FY 2024 Amendment FY 2025 Amendment R Information Technology IT Administration FND63600 CCN1080101 RC665882 PRG152000 665882 Planned Use of Fund Balance $19,518 $84,577 $84,577 Total Revenue $19,518 $84,577 $84,577 E Information Technology IT Administration FND63600 CCN1080101 SC702010 PRG152000 702000 Salaries $94,474 $409,385 $409,385 E Information Technology IT Administration FND63600 CCN1080101 SC722790 PRG152000 722000 Social Security $7,227 $31,318 $31,318 E Information Technology IT Administration FND63600 CCN1080101 SC722770 PRG152000 702000 Retirement $23,439 $101,568 $101,568 E Information Technology IT Administration FND63600 CCN1080101 SC722810 PRG152000 722000 Disability $1,512 $6,550 $6,550 E Information Technology IT Administration FND63600 CCN1080101 SC722820 PRG152000 702000 Unemployment Insurance (Personnel)$94 $409 $409 E Information Technology IT Administration FND63600 CCN1080101 SC722760 PRG152000 702000 Group Life $246 $1,064 $1,064 E Information Technology IT Administration FND63600 CCN1080101 SC722750 PRG152000 702000 Workers Compensation $1,001 $4,339 $4,339 E Information Technology IT Administration FND63600 CCN1080101 SC722780 PRG152000 702000 Hospitalization (Personnel)$12,592 $12,592 $12,592 E Information Technology IT Administration FND63600 CCN1080101 SC722800 PRG152000 702000 Dental $857 $857 $857 E Information Technology IT Administration FND63600 CCN1080101 SC722850 PRG152000 702000 Optical $125 $125 $125 E Information Technology IT Application Services FND63600 CCN1080201 SC702010 PRG152010 702000 Salaries $(80,067)$(346,958)$(346,958) E Information Technology IT Application Services FND63600 CCN1080201 SC722790 PRG152010 702000 Social Security $(6,125)$(26,542)$(26,542) E Information Technology IT Application Services FND63600 CCN1080201 SC722770 PRG152010 702000 Retirement $(19,865)$(86,080)$(86,080) E Information Technology IT Application Services FND63600 CCN1080201 SC722810 PRG152010 702000 Disability $(1,281)$(5,551)$(5,551) E Information Technology IT Application Services FND63600 CCN1080201 SC722820 PRG152010 722000 Unemployment Insurance (Personnel)$(80)$(347)$(347) E Information Technology IT Application Services FND63600 CCN1080201 SC722760 PRG152010 702000 Group Life $(208)$(902)$(902) E Information Technology IT Application Services FND63600 CCN1080201 SC722750 PRG152010 722000 Workers Compensation $(849)$(3,678)$(3,678) E Information Technology IT Application Services FND63600 CCN1080201 SC722780 PRG152010 702000 Hospitalization (Personnel)$(12,592)$(12,592)$(12,592) E Information Technology IT Application Services FND63600 CCN1080201 SC722800 PRG152010 722000 Dental $(857)$(857)$(857) E Information Technology IT Application Services FND63600 CCN1080201 SC722850 PRG152010 702000 Optical $(125)$(125)$(125) Total Expenses $19,518 $84,577 $84,577 SCHEDULE B – ORGANIZATIONAL CHANGES CREATE CLASSIFICATIONS Classification Title Salary Plan Grade FLSA Status Application & Client Services Director UNI 141 Exempt Merit Infrastructure Services Director UNI 141 Exempt Merit Business Relationship Manager UNI 134 Exempt Merit CREATE POSITIONS Cost Center/Program Classification Unit # Positions 1080101-152000 Application & Client Services Director Administration 1 1080101-15200 Infrastructure Services Director Administration 1 1080101-152000 Business Relationship Manager Administration 3 DELETE CLASSIFICATIONS Classification Title Job Code Salary Plan Grade FLSA Status Deputy Chief Information Officer J000574 APP 341 Exempt Appointed Application Services Director (Criminal Justice)J001879 UNI 137 Exempt Merit Application Services Director (Core Systems)J001878 UNI 137 Exempt Merit DELETE POSITIONS Position Number Classification Cost Center/ Program P00000892 Deputy Chief Information Officer 1080101-152000 P00002886 Applications Services Director (Criminal Justice)1080301-116020 P00005791 Applications Services Director (Core Systems)1080201-152000 P00004694 IT Project Manager 1080201-132200 P00015802 IT Supervisor II 1080101-152000 RETITLE DIVISION Division # From To 1080601 Technical Systems & Networking Application & Client Services CURRENT CLASSIFICATIONS Deputy CIO Base Step 12 Step 24 Step 36 Step 48 Step 60 Step 72 Step 84 Grade 341 Annual 176,577$ 185,149$ 193,721$ 202,292$ 210,863$ 219,435$ 228,006$ 236,578$ Bi-weekly 2,207.21$ 2,314.36$ 2,421.51$ 2,528.65$ 2,635.79$ 2,742.94$ 2,850.08$ 2,957.23$ Hourly 84.89$ 89.01$ 93.14$ 97.26$ 101.38$ 105.50$ 109.62$ 113.74$ Applications Services Director *Base Step 12 Step 24 Step 36 Step 48 Step 60 Step 72 Step 84 Grade 137 Annual 145,270$ 152,323$ 159,374$ 166,427$ 173,479$ 180,531$ 187,583$ 194,635$ Bi-weekly 5,587.32$ 5,858.56$ 6,129.78$ 6,401.02$ 6,672.26$ 6,943.49$ 7,214.72$ 7,485.95$ Hourly 69.84$ 73.23$ 76.62$ 80.01$ 83.40$ 86.79$ 90.18$ 93.57$ IT Supervisor II Base Step 12 Step 24 Step 36 Step 48 Step 60 Step 72 Step 84 Grade 131 Annual 108,403$ 113,666$ 118,928$ 124,190$ 129,452$ 134,715$ 139,978$ 145,239$ Bi-weekly 1,355.04$ 1,420.83$ 1,486.60$ 1,552.38$ 1,618.15$ 1,683.94$ 1,749.73$ 1,815.49$ Hourly 52.12$ 54.65$ 57.18$ 59.71$ 62.24$ 64.77$ 67.30$ 69.83$ IT Project Manager-UNI Grade 129 Base Step 12 Step 24 Step 36 Step 48 Step 60 Step 72 Step 84 Annual 98,325$ 103,099$ 107,871$ 112,644$ 117,417$ 122,190$ 126,964$ 131,736$ Bi-weekly 3,781.73$ 3,965.33$ 4,148.88$ 4,332.48$ 4,516.03$ 4,699.63$ 4,883.22$ 5,066.78$ Hourly 47.27$ 49.57$ 51.86$ 54.16$ 56.45$ 58.75$ 61.04$ 63.33$ NEW CLASSIFICATIONS Application & Client Services Director Base Step 12 Step 24 Step 36 Step 48 Step 60 Step 72 Step 84 Grade 141 Annual 176,578$ 185,150$ 193,721$ 202,293$ 210,865$ 219,437$ 228,008$ 236,579$ Bi-weekly 6,791.45$ 7,121.14$ 7,450.82$ 7,780.51$ 8,110.19$ 8,439.88$ 8,769.52$ 9,099.21$ Hourly 84.89$ 89.01$ 93.14$ 97.26$ 101.38$ 105.50$ 109.62$ 113.74$ Infrastructure Services Director Base Step 12 Step 24 Step 36 Step 48 Step 60 Step 72 Step 84 Grade 141 Annual 176,578$ 185,150$ 193,721$ 202,293$ 210,865$ 219,437$ 228,008$ 236,579$ Bi-weekly 6,791.45$ 7,121.14$ 7,450.82$ 7,780.51$ 8,110.19$ 8,439.88$ 8,769.52$ 9,099.21$ Hourly 84.89$ 89.01$ 93.14$ 97.26$ 101.38$ 105.50$ 109.62$ 113.74$ Busines Relationship Manager Base Step 12 Step 24 Step 36 Step 48 Step 60 Step 72 Step 84 Grade 134 Annual 125,490$ 131,582$ 137,674$ 143,765$ 149,857$ 155,949$ 162,041$ 168,133$ Bi-weekly 1,568.63$ 1,644.78$ 1,720.93$ 1,797.06$ 1,873.21$ 1,949.36$ 2,025.51$ 2,101.66$ Hourly 60.33$ 63.26$ 66.19$ 69.12$ 72.05$ 74.98$ 77.90$ 80.83$ Prepared by Human Resources Dept. 06/26/23 PERTINENT SALARIES - FY2023 Delete one (1) Deputy CIO position Salary grade 341 at Step 24 (193,721)$ Fringes At 35.48%(68,732) Direct Contract Charge (13,574) Savings (276,027)$ Delete two (2) Application Services Director Salary grade 137 at Step 48 (173,479)$ Fringes At 35.48%(61,550) Direct Contract Charge (13,574) Savings - 1 position (248,603)$ Savings - 2 positions (497,206)$ Delete one (1) IT Project Manager Salary grade 129 at Step 12 (103,098.58)$ Fringes At 35.48%(36,579)$ Direct Contract Charge (13,574)$ Savings (153,252)$ Delete one (1) IT Supervisor II Salary grade 132 at Step 12 (113,666)$ Fringes At 35.48%(40,329)$ Direct Contract Charge (13,574)$ Savings (167,569)$ Create one (1) Application & Client Services Director Salary grade 141 at Step 12 185,150$ Fringes At 35.48%65,691 Direct Contract Charge 13,574 Cost 264,415$ Create one (1) Infrastructure Services Director Salary grade 141 at Step 12 185,150$ Fringes At 35.48%65,691 Direct Contract Charge 13,574 Cost 264,415$ Create three (3) Business Relationship Manager Salary grade 134 at Step 48 149,857$ Fringes At 35.48%53,169 Direct Contract Charge 13,574 Cost - 1 position 216,600$ Cost - 3 Positions 649,801$ TOTAL PROPOSAL COST 84,577$ Total Cost for Remainder FY23 (4 Pay Periods)21,144$ Prepared by Human Resources Dept. 06/26/23 ILLUSTRATIVE PROPOSAL COSTING