Sprint 51 Review (2018-06-27)

Simon Meredith (Unlicensed)

Oladimeji Onalaja (Unlicensed)

Jayanta Saha

(and anyone else involved)

Releases

• TIS-49  -  Includes upgrade of Admins-UI to Angular 5
• Inbound ETL retired
  • TIS becomes sole 'owner' of core Trainee Data
  • Hicom now take read only copy overnight
  • TIS External Data Flows are much simpler

Paul

• Knowledge transfer session on the Assessment service, history, complications, reasons and design choices
• TISConf!

Jag

• Knowledge transfer sessions for ESR for the team.
• Documented additional technical/Dev level details on the project.

Jayanta (KR)

• Identified the potential KT areas such as NDW ETL, Document Management, ESR, Bulk upload etc.for collecting knowledge.
• On going KR is going on NDW ETL, ESR, Assessment , Bulk upload and Big picture of TIS.  
• Organising the KT sessions with the respective KD and the permanent team members.
• Documenting knowledge so that team members can act on it when necessary.
• Bulk upload ticket on Placement ID as matching criteria.

Reuben

• TIS external data flows updated in line with the transition to TIS sole ownership of Trainee data
• Simplification of NDW ETLs - design and documentation with John Thompson
• ETL timings rationalised and documented
• Specialties documentation refactored, reviewed and tasks captured

Frederic:

• continued on documenting backup / restore
• focused on multi-region backup

1. Paul Hoang (Unlicensed)
2. Suneet Kamath (Unlicensed)
3. TBC
4. PO Group
5. PO Group
6. Oladimeji Onalaja (Unlicensed)
7. Luís Matos (Unlicensed) / Panos Paralakis (Unlicensed)
8. Paul Hoang (Unlicensed)
9. Frederic Randriamora (Unlicensed) / Former user (Deleted) / Ashley Ransoo
10. John Simmons (Deactivated) / Frederic Randriamora (Unlicensed) / Chris Mills (Unlicensed)

Paul

• With the Reasons ETL complete for Assessment Outcome Reasons, worked with Fred to run it on DEV - waiting the required changes on the FE to release at the same time
• Added support to the Assessments service to allow for the deletion of assessments and all relating entities (Pre/Post assessment - reasons etc - currently backend only)

Ola

•  Assessments - Pre assessment details logic updated in FE to retrieve CurriculumSpecialty and CurriculumSubType data for records that currently have it missing
•  Post - Updated FE logic to ensure the rendering of Funding body name
•  Placements - Tested applied fix for Sub-specialty field issue on Stage with Joanne Watson (Unlicensed), fix pushed  to Prod after success

9. Jag/Fred

• Migration of crontab FTP Sync job to Jenkins job has been tested. The cron job is flexible handling only the required files and factoring the time. MTP pending.
• An additional manual FTP sync Jenkins job has been created giving the flexibility of filtering by individual local office and file types.

Jag: 

Looked in to some issues raised by ESR.

• National Insurance rollout and format issue.
• Site known as instead of VPD code.
• Hicom backlog files processing.
• LOV mismatch warning. (TISDEV-5001)
• few other bau issues

John S:

• Retired consolidated & intrepid ETL's
• Compressed the start times of the existing ETL's
• Blocked the ability of intrepid ETL to be manually run accidentally
• Uploaded final intrepid snapshot to azure cold storage
• Test recover of the MS-SQL backup to make sure it was usable
• service pipeline replacement sketch
• Pipeline proof of concept (WIP - with Frederic Randriamora (Unlicensed))

Reuben Noot (Deactivated)

Andy Nash (Unlicensed)

Agency update

Advert gone out for two BA roles (London-based) to give us a head-start on recruiting TIS Team #2, which will be an outside of London-based team.

Full Time recruitment

No joy with the final FED role as yet.

Other

Ruth left us