HR Operational Dashboard FY 17 Quarter 3 Workforce

HR Operational Dashboard: FY 17 Quarter 3 Workforce Demographics Employee Count by Service Delivery Area Overall Employee Count: 658 180 140 180 160 140 120 100 80 60 40 20 0 160 120 140 IO UC es 80 100 60 80 40 60 40 20 51 53 54 Su pp or t. S er vic rit y cu ry Se ra e Lib ru ct ur e on In fra st d Ph vic es rv ar t. S Ha gm M ta 120 55 56 57 Female Da Ad er &E ng IT ch Ar in ist ra de m tiv e ic IT 100 m Ac a Employee Count by Grade & Ethnicity Employee Count by Grade & Gender 58 59 60 61 62 Male 0 51 53 54 American Indian 55 White 56 Asian 57 58 Black 59 Hispanic 60 61 62 Bi/Multi Racial Recruitment Time to Fill Hiring & Promotions Open Positions as of May 26, 2017 120 FY 17 Jobs Filled: 59 FYTD Hire/Rehires/Transfers: 43 FYTD Promotions: 19 100 80 60 40 20 0 Contractors: 96 Jul 16 Aug 16 Sep 16 Oct 16 Nov 16 Dec 16 Jan 17 Feb 17 Mar 17 HUIT University Harvard IT Average Bill Rate: $76 Avg TTF (Grade <57) 65 days Operational Support: 50 Avg TTF (Grades 57 -58) 80 days Project Support: 46 Avg TTF (Grades 59+) 73 days % of Jobs w/TTF > 90 days 32% % of Jobs w/TTF < 30 days 24% Unit Academic ATS Position Humanities & Research Comp. Application Developer (PS) Posted Manager 4/25/17 Singhal, Rashmi 2/7/17 Ramakrishnan, P ATS Admin CTO CTO Infra Infra SS Technical Project Manager Sr Software Engineer HR Coordinator Sr. Technical Project Manager Dev. Ops Engineer QA Engineer Dev. Ops Engineer Cost Engineering Lead People. Soft Dev. Ops Engineer IT Support Assistant II 4/28/17 5/5/17 5/25/17 3/23/17 5/1817 4/4/17 3/23/17 12/20/16 3/24/17 Pfeifer, Jean Sonnenschein, A Breen, Nicole Bradshaw, Erica Covelle, Greg Hardin, Joe Mc. Carty, Sean Mundanchery, G Fanton, Joel Zeller, Matthew Fanton, Joel Alix-Garth, Louis

HR Operational Dashboard: FY 17 Quarter 3 Retention Performance Management Departures by Grade 61 60 59 58 57 56 55 54 53 52 3 Relocation 4 18 7 5 13 4 20 Mid Year Annual Academic Technology 100% 94% 60% 5 Administrative Technology 100% 96% 97% Term Exp. 5 Architecture & Engineering 100% 95% 97% Infrastructure 100% 98% Library Technology 100% Security 100% Support Services 100% UCIO 100% 9 Other 10 Goals Transfer Retirement 1 1 1 Unit 21 New Job 6 0 FY 16 Performance Management Departures by Reason 15 0 10 20 HUIT FY 17 Total Departures: 59 Harvard FY 16 Voluntary Turnover: 9. 6% HUIT FY 17 Total Turnover: 8. 9% HUIT FY 16 Voluntary IT Turnover: 8. 5% HUIT FY 17 Voluntary Turnover: 5. 9% Harvard FY 16 Voluntary IT Turnover: 8. 9% 30 FY 17 Performance Management Unit Goals Mid Year Annual Academic Technology 97% 81% 0% Administrative Technology 100% 92% 1% CTO 97% 88% 3% Data Management Services 100% 96% 0% Harvard Phone 100% 0% Infrastructure 89% 81% 4% Library Technology 100% 11% Security 100% 0% Support Services 99% 90% 23% UCIO 96% 0%