Client Profile

The client is a research-intensive university with globally acknowledged strength in science and engineering. The university has roots that go back to 1955. To date, the university has four colleges with 12 schools and is ranked among the top 25 technology universities in the world.

Client Requirements

The University was using emails and unformatted Excel and Word templates to manually consolidate KPI. They needed a system that would automate KPI data gathering and consolidation processes, improve information sharing and enhance reporting of data for the Ministry of Education (MOE).

Solution Overview

Automated work cycle from creating to archiving KPI documents

• System provides a platform to report departmental KPIs
• Monitoring of departmental submissions
• Workflow driven approach
• Automated merging, splitting and distribution of excel based KPIs
• Automated consolidation of MS Word based qualitative KPIs from various departments into a single document
• Approval of requests for publication
• Archival of saved documents
• Setting of permissions for lists/departments

Technology

• SharePoint Portal 2007
• .NET 3.0 Framework with ASP.NET and C#
• Office programming
• SQL Server 2005 Database