Child Welfare Digital Services Sprint Review Presentation Sprint - - PowerPoint PPT Presentation
Child Welfare Digital Services Sprint Review Presentation Sprint Review of Iteration 4.2 CALS/TPT2/LDU Sprint Dates: 09/07/17 to 09/20/17 Agenda CALS product discussion Value proposition Product demonstration User research
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
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
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
Sprint 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
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 8
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
Finish Identity Provider for Public Sandbox
Create Authorization Service
Promote Improved Perry to Production
Promote Improved Dora to Production
Role and Attribute Based Security
Promote Neutron CALS Job to Production
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
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
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
PI-4 Milestones Delivered
(Modified) End User Reporting (CWS/CMS &
Carryover (by Outside Dependencies)
Logout Feature (and other Perry Enhancements) Promote Dora to Production with Sealed &
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
Group Deliverable Epic Epic Status Demo Perry Logout Feature Create Authorization Service In Progress Yes API Framework for PDF generation (including RFA forms generation and printing) PDF Generation for RFA In Progress Yes API Continue creating Placement Home in CWS/CMS based on RFA Placement Home Creation in CWS/CMS In Progress API Design Forms Engine Forms Engine In Progress Dora Design approach to support attribute based access control for API modules Role and Attribute Based Security In Progress PI-4 Sprint 4.2 Review September 7 – September 20, 2017
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
Story ID Title Type Pts 150725912 CALS - API - ID Tab: Age Range - Looks like this should be related to preferred age groups from RFA application feature 2 150723488 CALS - API - Background check tab: Out of State Child Abuse Registry. State is not filled out; feature 2 150723589 CALS - API - Comments tab: if comment is present, submitted by is not specified: Remove comment since we don't have any yet feature 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 150723817 CALS - API - Other Children Tab: Minor children names are required for CMS/CWS but RFA form does not provide minor children names feature 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 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 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
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
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
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 Rework Resolutions Defects Incurred Defects Remaining 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 Review September 7 – September 20, 2017
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
RESOLVED THIS SPRINT Outside Team Control or Influence
Dependencies to Dora Within Team Influence Within Team Control
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
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
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
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
PI-4 Sprint 4.2 Review September 7 – September 20, 2017
GitHub Wiki: https://github.com/ca-cwds/CALS/wiki GitHub Repository: https://github.com/ca-cwds/CALS
GitHub Wiki: https://github.com/ca-cwds/cals-api/wiki GitHub Repository: https://github.com/ca-cwds/cals-api
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
GitHub Wiki: https://github.com/ca-cwds/cals-api/wiki GitHub Repository
SharePoint :
Pivotal:
PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 34
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-
Pivotal: https://www.pivotaltracker.com/n/projects/2011319 PI-4 Sprint 4.2 Review September 7, 2017 to September 20th, 2017 35