Sprint 40 Review (2018-01-17)

Availability

(assume everyone is available for 9 days, except the following):

Alex 2 days

Sprint Priorities

The following list was the prioritisation output from Sprint Planning:

Product Management

Developer Support

Assessments - support to devs to get this released to Prod
Bulk Import for People - UI

Analysis and refinement

Oriel Integration
- Definition of the Oriel Custom report
- Outstanding queries follow up on Recruitment Import template and Oriel to TIS reference data
ESR Integration
- TIS to ESR Reference/LOV mapping refinements
- ESR contextual queries tbd with NE (Wendy Burney)
- Other queries to be followed up with VH
- Review ESR workflow with Victoria
Feedback from SMLs for components - Programmes, Posts, People, Placements, Assessments
Trust UI - who and what do they need
Reporting - next steps to get local offices to test access via Tableau

Development

Assessments - Person list issue, finalise and deploy to production
People - cache refresh solution design and implement
ETL review - what, where, when
ETL - Posts to new ETL structure, Consolidated ETL rationalise and implement scheduled
Bulk upload for People
Delta endpoints for large objects
Revalidation ETL - migrate to Mirror
Defects on People, Posts in particular
Extending E2E testing coverage

DevOps

MVP analysis for DevOps
Elastic Search fixes to support delta endpoints
Pipeline for Intrepid ETL to build Mirror from DR V2
Blue/Green improvements
Azure rolling upgrades to support

Data

Data quality issues with respect to People and Posts

Item	Owner	Link
Production Application releases / updates:	Simon Meredith (Unlicensed) Oladimeji Onalaja (Unlicensed)	Releases TIS-31 TIS-32 (patch release) Issues GMC Outage - Chris Mills (Unlicensed) progress update - any washup?
Product Management	Alistair Pringle (Unlicensed) Joanne Watson (Unlicensed) Former user (Deleted) Ashley Ransoo Matt Leech (Unlicensed) Anupama Roy (Unlicensed)	SML Feedback - Programmes and Curriculum, Posts, People and Placements SMLs have been testing the above four components and sending feedback in via Teams. SMs and BAs evaluated this feedback and then held component review calls with the SMLs to talk through the feedback and explain the next steps. Programmes - Feedback Placements - Feedback Posts - Feedback People - Feedback Next steps to speak to devs (already done for programmes and posts) and create tickets for bugs/developments etc. Assessments Supporting dev team. First interation of assessments released to Prod. Walk through call with SMLs planned for 18th. SMLs need role attached to their profile Oriel Integration Oriel Custom Report created by Claire. Oriel Integration channel created on Microsoft Teams and we are receiving feedback from People SMLs and data leads on the Recruitment Import Template and Reference lists recommendations for TIS. ESR Integration ESR inbound/outbound flows diagram signed off by Victoria. Other contextual queries followed up with Wendy from NE. GMC API Fields reviewed and dev story created. Slack channel created for #esr_collaboration between ESR and TIS teams for managing issues log going forward. APP File generated and currently being tested by ESR. Notifications Export to be worked on next. JW provided confirmation to the ESR Streamlining Programme that the five sites currently not using the ESR interface would not be onboarded to the Intrepid-ESR interface as three of the five are in local offices that have never had the interface implemented in any trust. Explained that the TIS Team will prioritise these teams when the TIS-ESR interface is in place but will do nothing that will be to the detriment of the team's ability to deliver TCS to local ofices and the TIS-ESR interface to the 125 trsyut Rotations Matt: Design work for Rotations is scheduled with Ify after the meeting on Thursday. This will now be worked on in Sprint 41 Approvals Matt: Approvals are complete refer to Admin UI section for design files Permissions Discussion with SMs and Ify around adding more definition to the roles Anupama Roy (Unlicensed) SML Feedback Process Attended Placement & People meeting and looked at these 2 feedbacks The feedbacks are very useful to add to UJ mapping & stories It will be more useful for me to stand back from getting involved in this process at the minute as I do not have full view of the product, design and the process. I would like to use the feedback after they have been analysed on confluence. Mapping TIS Component & User Journey User Journey mock up. To be continued with Matt Leech (Unlicensed) - People Component Interpreting part of people component feedback - People Component Feedback - to be incorporated in UJ mapping Plan of work TIS Components and User Journey mapping: Plan of work for Sprint 4
Intrepid Data Quality	Russell Steel (Unlicensed)BC
TIS Core Services Alpha build	Alex Dobre (Unlicensed) (for 2 days!) Paul Hoang (Unlicensed) Sunil Rochani (Unlicensed) Panos Paralakis (Unlicensed) Oladimeji Onalaja (Unlicensed) Luís Matos (Unlicensed) Suneet Kamath (Unlicensed) Former user (Deleted) Matt Leech (Unlicensed) Shivani Rana (Unlicensed) Merce Bauza (Unlicensed)	Admin UI Matt: Work completed and outstanding work that needed to be moved to Sprint 41 lited below Error states: TIS Admin UI - Form Error States (Desktop) Approvals - Field Validation - Completed and ready for development: TIS Admin UI - Approval (People) Person Record - Field Validation \| Data (by Role) - Completed and ready for development: TIS Admin UI - Person Record - Field Validation \| Data (by Role) Legal Notices - Scenarios: Completed and ready for development: TIS Admin UI - Legal Policy: Privacy & Cookies \| TIS Trainee UI - Mobile - Legal Policy: Privacy and Cookies Audit Trail: TIS Admin UI - Audit Trail Review back journey between Reval/Concerns v rest of components: TIS Admin - Revalidation/Concerns - Navigation link TIS Design to Development Document and process: TIS Design to Development All the tickets below will be completed once the table content/styling & functionality has been signed off in the meeting on 18/01/18 Programmes - Rotations Field Validation & Scenarios: Moved the sprint 41 Programmes - Educational Groups (Trainers) Field Validation & Scenarios: Moved the sprint 41 People - Trainer Record Associations: Moved the sprint 41 Absence management - Field validation - Moved the sprint 41 Bulk uploads? This needs to be briefed and then a ticket created Assessments PP: Assessment create/edit event, create/edit Pre-assessments-details. User journey updated. Oladimeji Onalaja (Unlicensed) - Trainee specific Assessment list in Person record (view/edit) completed with unit testing Paul Hoang (Unlicensed) - backend updates for assessments including outcomes People Sunil Rochani (Unlicensed) reworked the Person List optimisation to make them performant enough in real time removing the need to flatten the data and keep refreshing a copy Posts and Programmes Merce Bauza (Unlicensed) - Local office field changed to Owner Delta Service Delta Service - Paul Hoang (Unlicensed) - progress update Public API Initial choice of endpoints we intend to expose decided and communicated to Hicom via swagger definitions, further design and tasking underway - <page link> End to End Testing Shivani Rana (Unlicensed) update on progress reviewing and resolving existing E2E tests User Management Created bulk admin users in live Extract of live users with roles and local offices for user audit (from KC API and auth DB)
ETLs	Sunil Rochani (Unlicensed)	Intrepid ETL (Intrepid DR - Mirror) has be updated to use DRv2 and is back running nightly - Sunil Rochani (Unlicensed) (when and how long is it taking?) Revalidation ETL - Sunil Rochani (Unlicensed) - migrated to use the Mirror removing dependency on DRv1 - testing on staging now Consolidated ETL - reviewed and action plan tasked. Posts implemented in new Consolidated ETL, run in Production (current status? - Paul Hoang (Unlicensed))
ESR Integration	Former user (Deleted)	Former user (Deleted) All dev related critical issues have been addressed with the latest Applicant file sent to E
DevOps	Chris Mills (Unlicensed) John Simmons (Deactivated) Frederic Randriamora (Unlicensed)	John Locked down ingresses to dev stage and prod to only accept traffic from LB or the bastion Reconfigured all VM's to use Loadbalancers for outbound traffic (GMC) Confirmation of Whitlisted environment Loadbalancers IP's from GMC for Revalidation API Removed public IP addresses from servers that do not need to be internet facing (eg database) Removed all External SSH access (except for the bastion) Frederic Ansible code for development on vagrant
Resource Planning	Reuben Noot (Deactivated) Andy Nash (Unlicensed)	Full Time recruitment No suitable candidates found in the latest round of interviews Agency update Alex left us this Sprint Suneet Kamath (Unlicensed), Former user (Deleted) and Luís Matos (Unlicensed) joined us! still looking for a Front End Developer and an ETL developer (short term for the TIS-NDW ETL)

Sprint 40 Review (2018-01-17)

Availability

Sprint Priorities

Product Management

Developer Support

Analysis and refinement

Development

DevOps

Data

Contents

Releases

Full Time recruitment