Skip Navigation Links


© 2017 Ambica
Last Updated:
25 March 2017
Version: 1.3.2


Corporate Systems Data Integration

Client: Institute of Cancer Research

Period: Jan 2015 - Mar 2017

Role(s): Web Development

Developed and tested software and website (collectively known as Pi for People Integration) to integrate person related data across key IT systems using:

  • TDD
  • ASP.NET 4.5
  • MVC 5
  • C# 5.0
  • Entity Framework 6
  • AngularJS
  • Jasmine
  • JavaScript
  • jQuery
  • ReSharper 8.2
  • NUnit 2.6.3
  • Rhino Mocks
  • Log4net
  • ELMAH
  • Visual Studio Professional 2013
  • Visual SVN
  • Subversion
  • SQL Server 2012
  • Active Directory
  • SharePoint
  • Powershell
  • Exchange Server 2007/2013
  • Apsose.Cells
  • TP project management software

Ambica developed the following:

  • Leaver notifications batch job.
  • Core Person Data page within web site for data co-ordinator to use.
  • Agresso HR to SharePoint update batch job (later renamed to Person Cascade).
  • Employee line manager update.
  • Symplectic Elements data feed

As part of preparing for Pi, Ambica developed the following:

  • Added person location initialisation.
  • Changed Person Cascade to get location data from AFM.
  • Added leaver interested parties notification batch job.
  • Added permissions, roles and email maintenance pages to Pi website.
  • Added location cascade.

As part of Active Directory to Pi, Ambica developed the following:

  • Added AD person organisation initialisation.
  • Added AD person location initialisation.
  • Changed Person Cascade to add new employees to AD, Exchange, security group, distribution lists and home drive.
  • Changed Person Cascade to change employee information in AD, including security group and distribution lists.
  • Added building address, distribution list and team setting maintenance pages to Pi website.
  • Added Agresso update batch job.

Ambica developed forms and supporting processes to enable people external to ICR to apply for access, specifically the following:

  • Developed external forms via Model Office sessions (including adding them to Symmetry security card system).
  • Migrated existing externals from Visiting Worker SharePoint forms to Pi.
  • Added externals summary page to Pi website to enable site management to manage externals.

Following release of the externals forms, Ambica developed the following miscellaneous enhancements:

  • Added site down for maintenance page for Pi and externals forms websites.
  • Added external leaver notifications batch job.
  • Added Symmetry clean-up batch job to delete old Symmetry records.
  • Added page to Pi website to maintain profiles (different types of external person).

Ambica made minor changes in order to take account of upgrades to the following ICR systems:

  • Agresso HR system to version Milestone 5.
  • Microsoft Exchange 2013.

Ambica developed forms and supporting processes to enable all people to apply for access to ICR and be added to supporting systems, specifically the following:

  • Developed form to enable new person requests to be added and confirmed.
  • Developed Person Request Cascade to add person requests to HR system, AD, Exchange and security card system.
  • Developed Agresso Cascade to take changes from HR system and update AD, Exchange and security card system.


Previous Next