Analyst Programmer

• 45 new project releases deployed.
• Worked on over 120 JIRA tickets, covering improvements, project deployments and bug fixes.

Attendance Monitoring

Project Duration

March 2018 to June 2018

Project Summary

Lead developer for a project to record and report on student absences and attendance.

Project Details

I was the lead developer on a project with a number of deliverables:

• Record attendance for students on specific events (e.g. lectures, seminars, practicals)
• Allow staff to print attendance sheets for a specific event
• Allow staff to view attendance records based on various search criteria (e.g. module code, student name)
• Given the relevant permissions, allow certain staff the means to amend attendance records

The project was split into five components and I was responsible for packaging these components and producing documentation. I worked closely with the project sponsor, software testers and other developers, tracking all work through JIRA. The components identified were:

• Print Attendance Sheets - basic process to print attendance sheets for a given event
• Event Absence Entry - allow staff to register absence / presence for a given event
• Amend Student Attendance - amend attendance records for a given student
• Amend Event Attendance - amend all attendance records for a given event

A number of distinct 'mini-projects' were identified and listed below.

Timetabling

Project Duration

November 2017 to June 2018

Project Summary

Various developments associated with timetabling

Project Details

I was the lead developer for a series of improvements and developments focused around both staff and students timetables. Further details are provided below.

Not quite a full-blown project, a mini project is a significant piece of work scoped, tested and implemented using normal software development methodology. A mini project will typically be an improvement to a business process, introducing efficiencies and reducing complexity where possible.

Timetabling - resolution of subgroup issue

Project Duration

May 2018

Project Summary

A problem was reported that certain events (in particular, subgroup events) would fail to show on student timetables

Project Details

An investigation established that an SLP embedded within a TPE record was failing on account of a list retrieve operation bringing back more records than was permitted (capped at 250). As a result, certain events were not shown on the student's timetable. The problem was resolved as a result of the following:

• Problem SLP replaced with single RQH
• TPEs referencing old SLP amended to reference new RQH

As a result of the above, an additional ten SLPs were rendered as superfluous. The above RQH also greatly simplified the means by which the student's SPR code was ascertained, as this could be derived from either a system register or a task answer (i.e. whether logged on as student or staff).

RQI (TTADMTTG1_S.sql) in BitBucket

Reference KV-2305

Attendance Monitoring - Package deployment

Project Duration

April 2018 to May 2018

Project Summary

Creation of packages and documentation to deploy Attendance Monitoring components

Project Details

Documentation was prepared detailing all the individual parts of each component as well as any dependencies. SITS projects were then created for each component and moved from the development environment to test. Working closely with the software testers, I then prepared documentation detailing how the actions of the users would impact upon the underlying data.

Timetabling - client-side validation

Project Duration

April 2018 to May 2018

Project Summary

jQuery used to auto-populate fields and perform validation

Project Details

I was tasked with improving e:Vision search tools that allowed staff to view timetables for ANY module, regardless of whether or not that module occurrence was available for timetabling.

I made the following improvements to all tasks designed to allow staff to view timetables:

• Period, occurrence and department drop-down fields set to auto-populate based on existing, timetabled modules for a given module code
• Warning message displayed when no timetabled module could be found
• 'Submit' button disabled by default; enabled when valid course details entered

Attendance Monitoring - Navigation buttons (breadcrumbs)

Project Duration

March 2018 to April 2018

Project Summary

Ensure consistency across all navigation buttons

Project Details

Throughout all of the Attendance Monitoring components, navigation buttons were required to return the user to the main Attendance Monitoring homepage, as well as to the previous screen or other significant steps (such as a search page).

I went through all Attendance Monitoring components and created consistent styling (including colour, placement and labelling) to all navigation buttons as well as ensuring that the user could easily navigate from one section to another in an intuitive manner.

References KD-95 and KD-97

Attendance Monitoring - Re-branding

Project Duration

March 2018 to April 2018

Project Summary

Re-branding and re-styling of all Attendance Monitoring components

Project Details

The following was delivered as part of this project:

• All Attendance Monitoring pages set to fully responsive mode, thereby ensuring maximum compatibility with devices
• All pages redesigned (where necessary) to ensure a look-and-feel consistent throughout Attendance Monitoring and also compliant with university branding

Timetabling - Workshops

Project Duration

January 2018

Project Summary

Performance and functionality improvements to the workshop portal

Project Details

Many improvements and developments were done to the staff and student-facing workshop portals. I was responsible for reducing page-load time from around 30 to 5 seconds; this was achieved by replacing legacy SRLs / SLPs with a single SQL query within an RQH. jQuery was then used to allow the user to alternate between views of past, present and future workshops.

RQI (TTNTSPRSWD1.sql) in BitBucket