RMS Case Study

Hi-Tech
Microsoft Readiness Management System (RMS)

The Client

SMSG (Sales, Marketing & Services Group) Readiness Group, Microsoft Corporation - Redmond, Washington

The Business Challenge

Microsoft Sales, Marketing and Services Group (SMSG) Readiness needed a solution to manage the creation, discovery and delivery of Readiness Training.

The Solution

The Readiness Management System is designed to be the front end tool for all lifecycle phases of training course development. It replaces the existing solutions, which reside in spreadsheets on web sites.

The goals of the RMS project are:

  • Simplify the action of capturing Readiness needs
  • Simplify the creation and tracking of Readiness Solutions
  • Simplify the assignment of Consumption Commitments
  • Reduce and target Readiness Solutions to the field through the successful creation of Learning Road maps displayed in Role Guide

The Readiness Management System consists of

  • Data Tier: Based on SQL Server 2005 and extensively uses SQL XML & 5NF. Federated database structure agility and scalability
  • Middle Tier: SOA based Web Services using ASP.NET 2.0. Talks to other tiers in XML
  • Client Tier: Consisting of Win Forms based Solutions Manager and Requirements Manager SQL Reporting Services 2005 based Reporting component
 
GGK along with partner Qdabra Software was involved in design, development and testing of Data and Client Tiers.

Technologies Involved

.NET Framework, C#, ASP.NET, Web Services, Microsoft Office InfoPath 2007, SQL Server 2005 and Reporting Services