Availability

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

Christmas period - almost everyone had some time off.

Assume this 3 week Sprint equated to a standard 2 week Sprint as a result.

Sprint Priorities

The following list was the prioritisation output from Sprint Planning:

Product Management

Developer Support

Assessments - Outcomes and Reasons, Revalidations
Other - dependent on Dev prioritie

Analysis and refinement

SML/Trainee Review coordination (Assessments, People, Posts, Placements, Trainee UI)
Admin UM - Role definition
PersonAssociated... review
Reporting - review first 10 reports from NDW team, SML's given access to Tableau
Oriel Integration - definition of the Oriel Custom report, Recruitment Import template, data quality issues
Bulk uploads - story refinement
Hicom Procurement review
Supporting Data Leads

Development

Placements - Unit Test coverage and release to Production
Assessments - ETL for Revalidations, Service and UI for Revalidations, Person view of Assessment
People - ETL and data model refactoring for performance and stability, PersonOwner blocked by ProgrammeMembership ETL issue
Bulk Upload - design review on how to plumb in the UI - asynchronous?
ESR Integration - continuing refining the APP file, including DR2 fields, Notification service
Admin UM - change admin user details, complete solution design
TIS-NDW ETL - start development

DevOps

Finalise UAT Environment
Update documentation, code and diagrams for better onboarding
MySQL Managed within Azure

Data

Contents

The following items to be shared by team members during this sprint review

Item	Owner	Link
Production Application releases / updates:		Releases
Product Management	Alistair Pringle (Unlicensed) Joanne Watson (Unlicensed) Former user (Deleted) Ashley Ransoo Russell Steel (Unlicensed) Steven Pettengell (Unlicensed) Matt Leech (Unlicensed)	Bulk uploads - Stories added and refined for Absence, People, NTN Assignment, Posts, Placements. Assessment events and ARCP still need to be reviewed. Assessments - List of outcomes for ARCPs agreed by SMLs and written into story (for action in Sprint 40). Oriel Integration - TIS Recruitment Import template refined with feedback received from Alice and Claire. There are still some outstanding questions on some fields. Definition of the Oriel Custom report meeting kicking off on Thursday 04/01 with Claire. ESR Integration - Analysis of the ESR documentation completed. Followed up queries with VH. Produced the following workflow as an initial understanding of the ESR inbound/outbound flows. Outstanding questions (contextual) to be followed up with Wendy Burney from NE on 03/01. TIS/ESR reference mapping done but still has some outstanding queries sent to VH to be clarified. Some LOV's were not present in the documentation and some with no values to map to. Channel created on Microsoft Teams for the discussion of the ESR interface and the Streamlining programme. Summary of process to be followed to set up a Trust with the interface posted in the channel to support those local offices with new trusts needing to use the interface. Reporting - First batch of required reports forwarded to Alice Brindle and James Harris for creation in the NDW. Trust UI - Proposed familiarisation and roll out plan for trust users forwarded to Angela Fletcher (component lead BM) for review and follow up Absence - MVP Scenarios and Field Validation refined. Dev Stories added to backlog Alistair Pringle (Unlicensed) to review confirm scope of the above. PersonAssociated stories completed w/scenarios and field validation for Trainer Person views still to be finally reviewed with SMLs (post Christmas) Admin UM role definitin and permissions continued, finalisation TBC Misc Update the TIS services to allow clients (Datawarehouse, external services) to retrieve data that have been modified in TIS Initial work to bring in service contracts using Pacts
Intrepid Data Quality	Russell Steel (Unlicensed)
TIS Core Services Alpha build	Alex Dobre (Unlicensed) Paul Hoang (Unlicensed) Sunil Rochani (Unlicensed) Panos Paralakis (Unlicensed) Steven Pettengell (Unlicensed) Oladimeji Onalaja (Unlicensed) Matt Leech (Unlicensed) Shivani Rana (Unlicensed)	Admin UI (Matt) I am following up on outstanding design work created by Steve/myself with Panos and Product Owners (Matt) I have created Admin UI examples for Error states available for development on Confluence TIS Admin UI - Long form (Form R-b example) Error States (Desktop) (Matt) I have created Mandatory and Optional filed examples for Admin UI on Confluence TIS Admin UI - Mandatory and Optional fields (Matt) The People placements for Admin UI is now on Confluence and ready for development TIS Admin UI - People/Placements Programmes People Rewrite People ETL to use the new codebase/approach established for Placements. Implement a refactor of the Person List backend to improve performance Posts Implement a refactor of the Post List backend to improve performance Placements Assessments Assessment List per trainee via a new Assessment section in People View has been implemented - List has been linked to main Assessment entity. Final assessment sub-section 'Revalidation' has been added to the Assessment entity - Create/Update functionality implemented. Tests and hardening on the Assessments Initial work on Service Pacts User Management Roles/Permissions in Dev, Stage and Prod in sync Trainee UI
Intrepid Mirror	Graham O'Regan (Unlicensed) Russell Steel (Unlicensed)
Intrepid DR v2	Graham O'Regan (Unlicensed) Russell Steel (Unlicensed) Sunil Rochani (Unlicensed)	Database structure changes to support DR v2 and sync DR v2 and mirror
Intrepid ETLs	Graham O'Regan (Unlicensed) Chris Mills (Unlicensed) Paul Hoang (Unlicensed) Russell Steel (Unlicensed)	Updates to ETL to bring in Assessment Outcomes and Revalidations
Oriel Integration	Graham O'Regan (Unlicensed) Sunil Rochani (Unlicensed)	Initial Oriel intregration to import Oriel xml files
ESR Integration	Graham O'Regan (Unlicensed)	Initial LOV mappings are done and still there are gaps in the mappings which are being worked out. Incorporated the available LOV code for Applicant File generation. There are still gaps because of the above. Validation Issues related to skipping the records without mandatory fields are fixed. (DOB, address line 1 etc). The data quality should be resolved over time to minimise such records. Code refactoring and code coverage is in progress.
DevOps	Chris Mills (Unlicensed) Graham O'Regan (Unlicensed) John Simmons (Deactivated) Frederic Randriamora (Unlicensed)	Chris UAT Environment Able to run ansible playbooks locally in vagrant Added flight rules Initial Pact Broker implementation Moved to using JDK rather than JRE, gives support for forcing dump etc Minor patches and better control over peroidic security patches Frederic Vagrant box for UIDEV; code needs to be merged John Moving plain text passwords to vault and updating associated playbooks Creating a keycloak admin password rotation playbook Occational user support requests
Resource Planning	Reuben Noot (Deactivated) Andy Nash (Unlicensed)	Full Time recruitment Full Stack Dev and Front End Dev re-advertised. 18 applications through Trac. Simon and Reuben are shortlisting. Agency update Graham, Steve and Russ all left us just before Christmas Alex will be leaving us at the end of this week Reuben was able to source 3 new developers from Transform in place of (not replacements for!) Alex and Graham. Welcome to: Andras Bulla, Luis Matos and Suneet Kamath Andy and Eniola attempting to source 2 more developers through agencies. No joy as of yet. Christmas break has made most agencies totally unresponsive!
User Research	Anupama Roy (Unlicensed)	Planned work with UX List UR questions @ AR & ML Digital accessible stats/list @AR Mapping TIS components and user journeys using Invision @AR &ML Involve Matt in user testing, journey mapping Send mailing lists & slack link to Matt about GDS & UR Planned work with BA on SML feedback processes Take over feedback and responding process to SML from Ify. Arrange weekly meetings to go through the process with BAs, POs & SMLs Report any challenges in the process with managing UR work Familiarising with TIS test environment with Simon Learnt log in process Skimmed through the environment

Browser not supported