Monthly 4 Up Reports COVID Slide MonthYear Slide

Monthly 4 -Up Reports: COVID Slide # Month/Year Slide 2: Slide 3: Slide 4: NOV 2020 DEC 2020 JAN 2021 Overall Status YELLOW GREEN RED YELLOW

Project Name: COVID Reporting (COVID) Project Manager: Mindy Peng Report Date: 11/30/2020 Project Record: PR-878 Progress Since Last Month starting 11/1/2020 • Project was initiated end of October Overall Status Schedule Budget Resource Risk G G G Y G Risk & Issues: • SMEs’ availability • Competing priorities • Lack of knowledge and historical context of main developer Risks: • Data integration complications • Lack of knowledge around source data Current High Level Tasks / Upcoming Milestones Activities for Next Month ending 12/31/2020 • • • Complete BV_Person view Complete Building_Space view Complete wastewater data integration Complete COVID test data integration Legend: G On time, within scope and budget 12/15/2020 - Complete wastewater data integration 12/20/2020 - Complete development work on all base views Y Has deviated slightly (< +/- 10%) from plan but is expected to recover R Fallen significantly behind plan and is forecasted to impact budget, scope and/or schedule

Project Name: COVID Reporting (COVID) Project Manager: Mindy Peng Report Date: 12/23/2020 Project Record: PR-878 Overall Status Schedule Budget Resource Risk R R G R R Progress Since Last Month Risk & Issues • Completed person and wastewater equipment building views. Developed Nifi flow for integrating wastewater data. • • • Incomplete requirements Lack of clarity on source data Main view developer is new to UCSD and has to rely on other SMEs Extremely tight timeline No staff resources for winter break Heavy reliance on other teams’ expertise/knowledge Need to fit this project into other teams’ priorities Sensitive data so additional time needed for vetting and approvals Need to stand up new HIPAA compliant environment in short timeframe Current High Level Tasks / Upcoming Milestones Activities for Next Month ending 12/31/2020 • Complete five data integrations and finish all base, intermediate and curated views. Legend: G On time, within scope and budget Y COVID Dashboard Completion Has deviated slightly (< +/- 10%) from plan but is expected to recover R Jan 22, 2021 Fallen significantly behind plan and is forecasted to impact budget, scope and/or schedule

Project Name: COVID Reporting (COVID) Project Manager: Mindy Peng Report Date: 01/25/2021 Project Record: PR-878 Overall Status Schedule Budget Resource Risk Y R G Y R Progress Since Last Month Risk & Issues • All views that we have source data for have been developed and the team is now making enhancements based on user feedback and new requirements. COVID test data, wastewater, and conduct monitoring integrations are deployed to QA. Completed a couple Tableau dashboards for SMT. • • • Changing requirements Lack of clarity on source data Heavy reliance on other teams’ expertise/knowledge Need to fit this project into other teams’ priorities Sensitive data so additional time needed for vetting and approvals Security/firewall challenges with HIPAA compliant environment so additional time needed for access and permissions Current High Level Tasks / Upcoming Milestones Activities for Next Month ending 12/31/2020 • Continue updating views per CMT needs. Bring in vaccine and sequencing data if available. Legend: G On time, within scope and budget Y COVID Dashboard Completion Has deviated slightly (< +/- 10%) from plan but is expected to recover R Feb 19, 2021 Fallen significantly behind plan and is forecasted to impact budget, scope and/or schedule