Corporate Information Systems and Data Mapping (York St John University)

  1. As-Is Healthceck: identified the total range of Corporate Information Systems (CIS) in use in the University, how they are hosted and managed; identified where business processes occur that involve workflow and data storage/manipulation outside of a CIS; identified for each system its primary business function; identified for each system its core data entities and interfaces; identified key areas of concern, including weak systems, duplication of effort or data integrity risks.
  2. To-Be Mapping: proposed how each of the identified issues should be addressed and where systems should be joined together; identified opportunities for consolidation and combination of existing systems and where the functionality of manual processes could be subsumed into core CIS; developed an overarching systems roadmap for update or replacement, which outlines the size, sequencing and interdependency of proposals; recommended a technology direction to achieve the above.

Selection of Previous Projects

  • Research Data Management Project: As part of the national JISC-funded Digital Curation Centre Institutional Engagement Project, drove the development of research data storage and management services within the University. Contributed to the data policies and governance, and produced the University’s roadmap for the implementation of RDM services to achieve compliance with new research funder and publisher policies.
  • Digital Collections Repository: Drove the entire project lifecycle from requirements gathering to roll out of the new Islandora-based repository as a service for the University Library. This included the implementation of standardised digitisation procedures for repository content and the introduction of a uniform format for resource discovery metadata. See: http://arts.st-andrews.ac.uk/digitalhumanities
  • Publishing the Philosophical Transactions: the social, cultural & economic history of a learned journal, 1665-2015: Developed the technical component for the bid to secure public funding for this AHRC-funded project, involving WordPress, XML, PHP and PostgreSQL. Worked with the research team to implement consistent processes for data capture from Royal Society Manuscripts and with the application developer to ensure that the data that is being produced is compatible with the developed software and that this software is able to deal with structural and semantic inconsistencies contained in historical records spanning over four centuries.
  • University of St Andrews Image Database: Led the project to rationalise methods for delivering digital images as part of research and teaching. Drove the requirements gathering, options appraisal, production of user requirements and project documentation including technical specifications. Post implementation, led the migration of image data and metadata from legacy systems into the new database. Introduced the Visual Resources Association Core 4 resource discovery metadata standard and Master Data Management. https://imagedatabase.st-andrews.ac.uk.
  • A Corpus of Scottish Medieval Parish Churches: Developed the technical components for two successful bids for AHRC funding and managed the technical implementation of the project using WordPress, PHP, XML and the University of St Andrews Image Database as a platform for Master Data Management and content delivery to the project’s website: https://arts.st-andrews.ac.uk/corpusofscottishchurches
  • Records of the Parliaments of Scotland: Critical project to retrieve transcribed texts (c 16.5m words) relating to Scottish Parliaments until 1707 which were contained in Folio Views, an obsolete software package without meaningful export function. Drove the migration of project data from Folio Views, including the elimination of inconsistent markup originating from editorial procedures within the academic project team. Headed the introduction of a consistent XML database solution and complex online retrieval capability. Ensured the deadline for the launch of the electronic resource in the Scottish Parliament was met. http://www.rps.ac.uk
  • Digital Archiving: Delivered a pilot project investigating the feasibility of setting up a digital archive for the long-term storage of and access to digital research data in numerous file formats within the University. Lead the requirements gathering process across the University and with third parties (e.g. software vendors, research funders, Digital Preservation Coalition), options appraisal, and production of user requirements and technical specifications along with project documentation. Investigated of automatic extraction of metadata (resource discovery, technical, archival), archival data standards and relevant procedural and security standards, e.g. Open Archival Information System (ISO14721), Trustworthy Repositories Audit and Certification (TRAC), Information Security Management (IMIS, ISO27001). Drove the development of the prototype digital archive based on the Fedora Commons, Alfresco and RDF technologies.
  • School of Modern Languages Multi Media Centre: Headed-up supplier management, requirements, options appraisal and user training that led to the implementation of a technical solution provided by Televic.
  • Software Asset Management: Key role in working alongside supplier Phoenix Software Ltd to drive the end-to-end lifecycle delivery of a new dashboard and centralised procedures for software licensing.