child welfare digital services sprint review...

Child Welfare Digital Services

Sprint Review Presentation

Sprint Dates: 09/07/17 to 09/20/17

Sprint Review of Iteration 4.2

CALS/TPT2/LDU

Agenda CALS product discussion

Value proposition

Product demonstration

User research and design

Sprint Statistics

TPT2 business review

PI-4 Objectives, Epics, and Roadmap Review

Sprint 4.2 Deliverables Highlights

Sprint Statistics Review

Q&A

Next event

Technical discussion

What makes all this possible, transition to technical discussion

Important links

PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 2

CALS value proposition, PI-4 “RFA Applications”Child Welfare Goals Impact of CALS PI-3 Features to Deliver Value

Child Safety Enforced and evaluated

standards of quality to ensure all

placement facilities are safe for

children

Home search and Facility

Profiles that display compliance

history at a glance

Child Welfare RFA workers have an easier

method of assisting applicants in

creating good homes for children

End to End creation of RFA

01A/B/C

Ability to print As-Is Version of

forms

Workload Management Less time fighting the tool and

more time for social work

Global and Page navigations

across all digital services makes

it easier to operate in the system

Data Quality Reduction in the duplication of

data entry across multiple data

sources

Single point of entry for applicant

information that is reused

throughout RFA forms process

Creation of Facilities in

CWS/CMS


PRODUCT DEMONSTRATION

This is what we have all been waiting for…

Child desired Card

Application References Card

Name card Validation

Required field validations

Date validation

All cards with date fields updated

Driver’s License and State validation

Multiple field conditional validation

Bug fixes in Dashboard and RFA 01A


Design - RFA 01A Applicant's History & Adult Children

5

Design - RFA 01B Design & Validations

6

CALS – sprint metrics as of 9/06/17 at CoBSprint Metrics

Iteration 4.2 4.1 3.6

Planned Capacity % / PTS 77% / 36 74% / 36 80% / 65

Accepted # of Planned Feature Stories / PTS 30 / 53 37 / 47 45 / 70

# of Completed Feature Stories / PTS 25 / 43 17 / 33 30 / 57 *

% Completed (by PTS) 81% 70% 81%

# of Stretch Backlog Features / PTS 0/0 1 / 4 0 / 0

% Completed (including Stretch, by PTS) (Goal

>80%)

81% 79% 81%

Average Velocity over 3 sprints N/A N/A 97

Cycle time for Features (in hrs.) (Goal: <96) 166 160 120


CALS Sprint 4.1 Burnup chart


Child Welfare Digital Services

Sprint Review Presentation

Sprint Dates: 09/07/17 to 09/20/17

Technology Platform Team 2

PI-4 Sprint Iteration 4.2

PI-4 Objectives and Epics

API (CALS) PDF Generation for RFA

RFA 1 A, B, and C

Forms Engine

Generate Manufactured Data

Placement Home Creation in CWS/CMS

CALS Landing Page (Information Architecture)

Create Client in CWS/CMS

RFA Form 02 API

Perry Finish Identity Provider for Public

Sandbox

Create Authorization Service

Promote Improved Perry to Production

Dora Promote Improved Dora to

Production

Role and Attribute Based Security

Neutron Promote Neutron CALS Job to

Production

Other Services Promote Document

Management to Upper Environment

Promote Geo Services to Upper Environment

End User Reporting (Combining CWS/CMS & CWS-NS) POC

PI-4 Sprint 4.2 Review September 7 –September 20, 2017

Primary Objective: Support CALS Digital Service Features & Functions

Secondary Objective: Enhance/Extend Platform Services

TPT2 PI-4 Current Roadmap


Sprint 4.2 Sprint 4.2 Sprint 4.3 Sprint 4.4 Sprint 4.5 Sprint 4.6

API

(CALS)

PDF generation for

RFA

RFA 1 A, B, C

Form engine

Placement Home

creation in

CWS/CMS

CALS landing

page (Information

Architecture)

Create Client in

CWS/CMS

RFA form 02 API

Generate

Manufactured Data

Perry Finish

identity

provider

for public

Sandbox

Logout Feature

authorization service

providing fine-grained

authorization control

(POC)

Create ABAC security

infrastructure and

example code (API)

Update Perry

Development Guide

token re-issue Promote

Improved Perry to

production

Dora Filter

Sealed &

Sensitive

based on

JWT

Promote Dora to

Production with

Sealed & Sensitive

Filtering Support

Role and attribute

based security

Promote

Improved Dora

to production

Neutron Promote

Neutron CALS

jobs to

production

Other End User

Reporting

(CWS/CMS &

CWS-NS) Spike

Promote Geo

Services to Upper

Environment

Promote Document

Management to

Upper Environment

STRETCH:

Session

management

Replacement

Support Cross

Team

Support

Cross Team

Support

Cross Team Support

LDAP for Preview

Cross Team Support Cross Team

Support

Cross Team

Support

SPRINT 4.2 DELIVERABLESTPT2 PI-4 Sprint 4.2


Sprint 4.2 Planned Milestones

PI-4 Milestones Delivered

(Modified) End User Reporting (CWS/CMS &

CWS-NS) Spike

Carryover (by Outside Dependencies)

Logout Feature (and other Perry Enhancements)

Promote Dora to Production with Sealed &

Sensitive Filtering Support


PI-4 Sprint 4.2 Milestone Highlights

Group Deliverable Epic Epic Status Demo

Perry Logout Feature Create Authorization Service In Progress Yes

APIFramework for PDF generation (including RFA

forms generation and printing)PDF Generation for RFA In Progress Yes

APIContinue creating Placement Home in

CWS/CMS based on RFA

Placement Home Creation in

CWS/CMSIn Progress

API Design Forms Engine Forms Engine In Progress

DoraDesign approach to support attribute based

access control for API modules

Role and Attribute Based

SecurityIn Progress


PI-4 Sprint 4.2 Stories Completed - API (CALS)


Story ID Title Type Pts

150725912CALS - API - ID Tab: Age Range - Looks like this should be related to preferred age groups

from RFA applicationfeature 2

150723488 CALS - API - Background check tab: Out of State Child Abuse Registry. State is not filled out; feature 2

150723589CALS - API - Comments tab: if comment is present, submitted by is not specified: Remove

comment since we don't have any yetfeature 2

150493938 CALS - API - design forms engine feature 5

150720776 CALS - API - License Number NULL on ID page of Placement Home looks invalid feature 2

150723817CALS - API - Other Children Tab: Minor children names are required for CMS/CWS but RFA

form does not provide minor children namesfeature 2

150720990 CALS - API - Substitute Care Provider Tab: Annual Income Amount is not set feature 2

150837565 CALS - API - support front-end in case of minor changes in API feature 3

150837713 DMS PDF: develop document generation API feature 5

150837823 DMS PDF: develop mapping management API feature 2

150837799 DMS PDF: develop template management API feature 3

150897778 DMS PDF: implement CMIS 1.1 data access service feature 3

150683537 DMS: document how to configure application feature 1

Total Points: 34

PI-4 Sprint 4.2 Stories Completed –Perry/Dora/Neutron



150524105 Perry SPIKE: design approach to support attribute based access control for API modules feature 5

150894837 Perry: link Perry token with SAF token feature 3

151075693 **Stretch** Perry: add callback URL validation using white list for Login Service feature 2

151070174 **Stretch** Perry: add logging to Perry feature 2

151015196 **Stretch** Perry: add validation for login resource feature 1

151112080 **Stretch** Perry: fix error page feature 2

150758915 Neutron: fix ChangedFacilityService and create unit-test in CALS-API feature 5

Total Points: 20

PI-4 Sprint 4.2 Stories Completed - Other



150837680 **SPIKE** Reporting: Research for an open source software for reporting and BI feature 3

150984002 **Stretch** Performance Login Issue feature 1

151019236 **Stretch** API CORE: move error handling code to api-core from CALS API feature 2

151225871 **Stretch** Automate CWS/CMS DB2 Docker image creation feature 3

150837930 **Stretch** Publish list of dependencies licenses for all TPT2 projects feature 2

150981928 **Stretch** Triage - Preview Bug 431 (Critical) feature 1

150990161 **Stretch** Triage - Preview Bug on login 500 (Critical) feature 1

150989309 **Stretch** Triage - Preview Bug on login Successful Authentication (Critical) feature 1

151060155 **Stretch**: Cross Team Support: Setup Users for Integration feature 3

150493931 DB2: Interrupt Driven DB2 Database Admin Activities 4.2.2 feature 2

150896888 DevOps release

150334210 DevOps: build CI for DMS chore

150333307 DevOps: build CI for IDP chore

151140248 DevOps: integrate New Relic into Perry chore

149951196 DevOps: Neutron CI Sonar scan is not working in DEV Jenkins chore

Total Points: 19

PI-4 Sprint 4.2 Stories NOT Completed

Story # Story Summary Description Comments Points

150723656 CALS - API - Other Adults Tab: relationship to applicant is empty Blocked by Business Requirement 2

150723750 CALS - API - Other Children Tab: relationship to applicant is empty Blocked by Business Requirement 2

148082635 Configure Dora to work with Perry on Pre-Int environment Blocked by Outside Dependencies 3

150533903 Dora: filter field level Sensitive Client information based on JWT Blocked by Outside Dependencies 3

150894576 Perry: token invalidation callback Blocked by Outside Dependencies 3

150896113 Perry: improve validate service to use SAF Blocked by Outside Dependencies 1

150894258 Perry: token invalidation service Blocked by Outside Dependencies 2

150896204 Perry: update shiro security library to call validate service Blocked by Outside Dependencies 2

150896358 **Stretch** Perry: add logout button to Swagger Blocked by Outside Dependencies 2


Total Points: 20

SPRINT STATISTICSTPT2 PI-4 Sprint 4.2


PI-4 Sprint 4.2 Metrics Summary

Sprint Metrics

Capacity** 76%

Planned Backlog Story Points 70

Completed Backlog Story Points 52

Percent of Planned Stories Completed 74.3%

Stretch Backlog Story Points Completed* 21

Percent of Total Stories Completed (including Stretch) 104.3%

Sprint Velocity (The actual + stretch Completed) 73

Average Velocity over last 3 sprints 62

Rework Opportunities 0

Rework Resolutions 0

Defects Incurred 0

Defects Remaining 0

Story Cycle Time (5 iteration Average) 90 Hrs


* High number of stretch points added during this sprint

** Over-time from team was required from team to increase capacity and compensate for stretch demand

PI-4 Sprint 4.2 - Project Trend


PI-4 Sprint 4.2 Burn Up


PI-4 Sprint 4.2 Epic Work Distribution


Impediments

RESOLVED THIS SPRINT

Outside Team Control or Influence

• Intake Dependencies to Dora

Within Team Influence

Within Team Control


Where We’re Headed in Sprint 4.3

PI-4 Milestones In Progress Placement Home creation in CWS/CMS

Generate manufactured Data (CWS/CMS, LIS, FAS, CWS-NS)

RFA 1 A, B, C

Form engine

Role and attribute based security

PI-4 Milestones to be Delivered Logout Feature*

Promote Dora to Production with Sealed & Sensitive Filtering Support*

PDF generation for RFA

authorization service providing fine-grained authorization control (POC)

Promote Geo Services to Upper Environment

LDAP User Management for Preview (Similar to Sandbox)**

Additional Comments Cross Team Support may impact commitments

Reduced capacity in 4.3 due to scheduled time off for team members


* Carryover from previous Sprint

** Milestone not originally in scope from PI-4 Planning

What made all this possible?

Technical discussion begins here

LDU – Licensing Development Unit

Business Rule Extraction (BRE) Use Case Modeling for Child Care Facilities

CBC: Continuation of business rule extraction

DQA: Data Quality Audit report for non-CALS LIS tables.

LIS/FAS CDSSVAPP032 (load test) stood up ready for AWS

Timestamps added to tables in BPR

Started preparing for AWS INT2 environment

CBC Postman integration with Jenkins

7 web methods converted to ConnX

6 web methods completed analysis


28

LDU Environments

PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017

TECHNICAL DEMONSTRATIONTPT2 PI-4 Sprint 4.2


Logout Feature


Framework for PDF generation


Questions?


Important Links CALS

CALS Digital Service

GitHub Wiki: https://github.com/ca-cwds/CALS/wiki

GitHub Repository: https://github.com/ca-cwds/CALS

CALS API

GitHub Wiki: https://github.com/ca-cwds/cals-api/wiki

GitHub Repository: https://github.com/ca-cwds/cals-api

Shared resources

CALS SharePoint (osi email required): Link

CALS Shared Google Drive (request access)

UX Artifacts links :


https://github.com/ca-cwds/CALS/wiki

https://github.com/ca-cwds/CALS

https://github.com/ca-cwds/cals-api/wiki

https://github.com/ca-cwds/cals-api

https://osicagov.sharepoint.com/sites/projects/CWS-NS/Licensing/PublicDocuments/Forms/All Documents Other than BPPs.aspx

Important Links CALS (Cont.)


GitHub Repository https://github.com/ca-cwds/cals-data-model

https://github.com/ca-cwds/dora

https://github.com/ca-cwds/api-core

https://github.com/ca-cwds/perry

https://github.com/ca-cwds/jobs

https://github.com/ca-cwds/jobs/wiki/Facility-Indexer-Job

SharePoint : https://osicagov.sharepoint.com/sites/projects/CWS-NS/ETP2/SitePages/Home.aspx

Pivotal: https://www.pivotaltracker.com/n/projects/2011319



https://github.com/ca-cwds/cals-data-model






https://osicagov.sharepoint.com/sites/projects/CWS-NS/ETP2/SitePages/Home.aspx

https://www.pivotaltracker.com/n/projects/2011319

Important Links TPT2



GitHub Repository https://github.com/ca-cwds/cals-data-model





SharePoint: https://osicagov.sharepoint.com/sites/projects/CWS-NS/ETP2/SitePages/Home.aspx

Pivotal: https://www.pivotaltracker.com/n/projects/2011319




https://github.com/ca-cwds/cals-data-model





https://osicagov.sharepoint.com/sites/projects/CWS-NS/ETP2/SitePages/Home.aspx

https://www.pivotaltracker.com/n/projects/2011319