MARS PROJECT UPDATE_DRAFT ASSESSOR.PPTX

Board of Supervisors
Status Update
November 27, 2017

Overview
•Project Schedule & Budget
•Functionality Roadmap
•Q3 Highlights and R-03 Metrics
•Q4 Outlook
11/27/2017 Maricopa County Office of the Assessor 2

Schedule & Budget

Schedule
Releases at end of every Quarter
Invoicing at end of every Quarter tied to Completed Milestones (4/15)
completion of Deliverables:
• Project Management Planned Milestones
• Software Subscription
• Release Package (Deliverables)
Project Status Reports every 3 weeks (end of every Sprint and Release)
R-00 R-01 R-02 R-03 R-04 R-05 R-06 R-07 R-08 R-09 R-10 R-11 R-12 Go-Live UAT &
2016 Dec 2017 2018 2019 2020
11/27/2017 Maricopa County Office of the Assessor 4

Delivery & Acceptance to Date
Release Status Planned Actual Release Delivery Acceptance
Release Date Delivery Date (Sign-off)
R-00 Dec 29, 2016 Dec 29, 2016 Jan 17, 2017
R-01 Mar 31, 2017 Mar 31, 2017 Apr 24, 2017
R-02 Jun 30, 2017 Jun 30, 2017 Jul 27, 2017
R-03 Sep 29, 2017 Sep 29, 2017 Oct 26, 2017
R-04 Dec 20, 2017
11/27/2017 Maricopa County Office of the Assessor 5

Contractor Budget
Paid to
Category Allocated Retainage Remaining
Date
Project Mgmt. $845,124 $45,682 $182,729 $616,713
Deliverables $5,224,986 $298,884 $1,195,537 $3,730,565
Travel $376,834 0 $31,671 $345,163
Software $834,870 0 $225,641 $609,229
TOTAL $7,281,814 $344,566 $1,635,578 $5,301,670
Amounts are rounded to the nearest whole dollar and current as of Nov 20, 2017
11/27/2017 Maricopa County Office of the Assessor 6

Functionality Roadmap

From Themes to Features
21 Themes
900+ Features
11/27/2017 Maricopa County Office of the Assessor 8

From Features to User Stories
900+ Features
1,150+ Detailed User Stories
Development & Test Cases
11/27/2017 Maricopa County Office of the Assessor 9

User Stories with Story Points
Next Steps
• Balance story points across releases (Total 7,000+ Story Points)
• Continue to refine requirements by updating user stories and test cases
11/27/2017 Maricopa County Office of the Assessor 10

Q3 Highlights & R-03 Metrics

Q3 2017 – Activities
üBusiness Rules and User Stories reviewed and
refined
üData modelled and migrated
üSoftware developed
üTesting materials developed in Target Process
11/27/2017 Maricopa County Office of the Assessor 12

Metrics: Measuring Quality
üTotal Software Score measuring defects (number x
severity value) is within allowed limits
11/27/2017 Maricopa County Office of the Assessor 13

Metrics: Measuring Capacity
11/27/2017 Maricopa County Office of the Assessor 14

Metrics: Measuring Velocity
•R-03 Story Points delivered
In Sprint 4, new tool
(Target Process) to manage
Requirements and Testing
was introduced
11/27/2017 Maricopa County Office of the Assessor 15

Metrics: Measuring Progress
•R-03 Planned Development (Story Points) vs
Actual
• 867 story points planned
• 797 story points delivered
• 728 story points successfully tested by Maricopa County
R-03 Functionality Overview:
 Ownership and Address Data Modelling & Loading
 Ownership Transfer
 Mailing Address
 Situs Address Update
 Multiple Parcels with Different Situs Addresses Update
 Sketching Synopsis Prototype
 Land Characteristics
 Improvements Characteristics
11/27/2017 Maricopa County Office of the Assessor 16

Metrics: Measuring Progress
•R-03 Features vs Fixes
95% of effort on new
feature development,
including solution
architecture (back-end)
11/27/2017 Maricopa County Office of the Assessor 17

Metrics: Measuring Overall Progress
•# of Features successfully tested (4%)
•# of Story Points successfully tested (11%)
11/27/2017 Maricopa County Office of the Assessor 18

Q4 Outlook

Q4 2017 Outlook
•Continued development of User Stories and
Test Plans/Cases
•Release 04 Delivery Package (Dec 20)
• Release Release 04 04 Software Software & & Supporting Supporting
Documentation Documentation
• Project Project Schedule Schedule (Baseline (Baseline Plan) Plan)
• Data Data Migration Migration Plan Plan (Final) (Final)
• Development Development Plan Plan (Final) (Final)
• Testing Testing Plan Plan (Final) (Final)
• Training Training Plan Plan (Initial (Initial Q4, Q4, Final Final Q5) Q5)
11/27/2017 Maricopa County Office of the Assessor 20

Q4 2017 Outlook
11/27/2017 Maricopa County Office of the Assessor 21

Questions?
11/27/2017 Maricopa County Office of the Assessor 22