Lead Developer (SITS)

Period of Employment

14th January 2013 to 27th November 2015

Employer

University of Cumbria

Team / Department

SITS Team, SaMIS (Student and Management Information Service)

Notes

A visual overview of all the projects undertaken throughout this contact can be seen here - https://goo.gl/QESCkW (opens new window).

 Roles and Responsibilities

 Achievements

 Projects

SITS e:Vision Consolidation Project

Project Duration

Begun in January 2015

Project Summary

Complete re-styling and re-branding of the university's SITS e:Vision platform.

Project Details

This project is on-going and concerns the redesign of the university's SITS e:Vision platform in order to introduce a single, unified brand throughout (largely via cascading style sheets) and also ensure compliance with the latest accessibility recommendations. The project also seeks to evaluate all the latest tools available through e:Vision, incorporating these into standard working practice where appropriate.

Key deliverables achieved:

Paperless Admissions Annual Review 2015/2016

Project Duration

April 2015 to October 2015

Project Summary

The Paperless Admissions Portal is a large and complex component within e-Vision, used by support and academic staff during the process of interviewing and accepting students onto a particular course of study. As such, the Paperless Admissions Portal is subject to many changes, both in terms of our course offerings and regulatory requirements (typically from HEFCE).

The annual review is an opportunity to scope all changes required and allocate resources as necessary to implement these changes.

Project Details

The Paperless Admissions portal is the university's most complex area of administration and I am the principal lead for development. I manage the testing (peer and user acceptance), development, implementation, documentation, training and maintenance of all significant changes. Key deliverables achieved during the academic cycle 2015/2016 include:

Clearing Dashboard

Project Duration

June 2015 to August 2015

Project Summary

A small project dedicated to improving the look-and-feel of an area of e-Vision dedicated to providing tools for use during and after the critical Clearing period.

Project Details

Several objectives were defined and achieved, as listed below:

Online Registration Annual Review 2015/2016

Project Duration

June 2015 to July 2015

Project Summary

Annual review of the university's process by which students enrol on a course via SITS e-Vision. The University of Cumbria refer to this system as 'Online Registration'.

Project Details

As part of this annual review, I tested and implemented numerous changes, including:

SITS:Vision Upgrade 2015/2016

Project Duration

January 2015 to March 2015

Project Summary

Upgrade of SITS:Vision and e:Vision to 8.8.0 (via 8.7.1)

Project Details

This was the second major upgrade of our SITS system that I played a key role in. My role was the testing of the whole of e:Vision. Some of the testing was devolved to other team members, but I retained overall responsibility for signing off all testing of e:Vision.

Main areas of responsibility included:

Paperless Admissions Annual Review 2014/2015

Project Duration

April 2014 to August 2014

Project Summary

The Paperless Admissions Portal is a large and complex component within e-Vision, used by support and academic staff during the process of interviewing and accepting students onto a particular course of study. As such, the Paperless Admissions Portal is subject to many changes, both in terms of our course offerings and regulatory requirements (typically from HEFCE).

The annual review is an opportunity to scope all changes required and allocate resources as necessary to implement these changes.

Project Details

The Paperless Admissions portal is the university's most complex area of administration and I am the principal lead for development. I manage the testing (peer and user acceptance), development, implementation, documentation, training and maintenance of all significant changes. Key deliverables achieved during the academic cycle 2014/2015 include:

 Mini projects

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.

SITS Search Tool

Project Duration

June 2014 to October 2015

Project Summary

It's often necessary to search through certain commonly-used areas of SITS, looking for a specific string. This project is a stored procedure to perform this search and return the results.

Project Details

A widely-used stored procedure that allows the user to search throughout SITS, searching for a specific string, ignoring records marked as 'out of use' where required.

The long duration of this project is indicative of the fact that many updates have been made to this project, as more tables are included in the search.

Key features:

IOI Related Documents

Project Duration

November 2014 to July 2015

Project Summary

A suite of stored procedures, functions, tasks, RQHs and SLPs in order to store and retrieve interview questions and feedback.

Project Details

As part of the Paperless Admissions process, it is necessary to store information about a student gathered both during their interview and afterwards (as part of the feedback process). In storing this information, all available fields in IOI were accounted for and it was then necessary to make use of user-defined fields. Prior to this project, a lot of interview-related information was stored as a fixed-width string within IOI_UF20, with specific positions in the string corresponding to answers given to specific interview questions. Taking all of this into account, the project had several aims:

Deliverables achieved as part of this project:

Enable / Disable Photo Upload

Project Duration

January 2015 to April 2015

Project Summary

Creation of two stored procedures to enable / disable the process by which students upload a photograph (for use on their library card) during registration for their course.

Project Details

During busy times of the year (typically from late August through to early September), library staff do not have the resources to pre-print library cards for students, who are able to submit a photograph during registration for their course. To resolve this problem, it is necessary to disable the submission of photographs during this busy period.

Two stored procedures were created, one essentially reversing the actions of the other, both with the aim of either enabling or disabling the photo submission process normally available during course registration.

Key features:

Course Deletion Tool

Project Duration

September 2014 to December 2014

Project Summary

A process created to delete a course record (CRS) and all records associated with that course.

Project Details

Working closely with a colleague who had a detailed knowledge of the university's academic model, I created a stored procedure to go through all records associated with a given course (all the way from PWY to CRS), deleting records marked for deletion.

Key features:

Synchronise Address Records

Project Duration

May 2014 to June 2014

Project Summary

Stored procedure created to synchronise student address details between INS_STU and MEN_ADD records.

Project Details

Ordinarily, the university's instance of SITS is configured in such a way that any changes to a student's address made in the ADD screen are automatically copied over to their main student record (INS_STU). This stored procedure checks that this synchronisation has occurred and, where the INS_STU and MEN_ADD records are inconsistent, data is copied over (i.e. address details synchronised).

Key features: