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
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 3
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
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 4
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
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 7
CALS Sprint 4.1 Burnup chart
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 8
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
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
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
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
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 Review September 7 –September 20, 2017
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 Review September 7 –September 20, 2017
PI-4 Sprint 4.2 Stories Completed - API (CALS)
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
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
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
Story ID Title Type Pts
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
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
Story ID Title Type Pts
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
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
Total Points: 20
SPRINT STATISTICSTPT2 PI-4 Sprint 4.2
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
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
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
* 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 Review September 7 –September 20, 2017
PI-4 Sprint 4.2 Burn Up
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
PI-4 Sprint 4.2 Epic Work Distribution
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
Impediments
RESOLVED THIS SPRINT
Outside Team Control or Influence
• Intake Dependencies to Dora
Within Team Influence
Within Team Control
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
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
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
* 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
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 27
28
LDU Environments
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017
TECHNICAL DEMONSTRATIONTPT2 PI-4 Sprint 4.2
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
Logout Feature
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
Framework for PDF generation
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
Questions?
PI-4 Sprint 4.2 Review September 7 –September 20, 2017
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 :
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 33
Important Links CALS (Cont.)
GitHub Wiki: https://github.com/ca-cwds/cals-api/wiki
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
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 34
Important Links TPT2
GitHub Wiki: https://github.com/ca-cwds/cals-api/wiki
https://github.com/ca-cwds/jobs/wiki/Facility-Indexer-Job
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
SharePoint: https://osicagov.sharepoint.com/sites/projects/CWS-NS/ETP2/SitePages/Home.aspx
Pivotal: https://www.pivotaltracker.com/n/projects/2011319
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 35