

Project At a Glance |
|---|
RDA developed a customized intranet solution that provides project scheduling and task management capabilities to store operations for a leading retailer. The solution dramatically reduces operational costs and improves the company's process efficiency. |
RDA's client is a specialty retailer with 300 stores nationwide.
As part of their overall goal of extending automation into their stores, RDA's client was looking to increase the functionality and value of their existing intranet task management capabilities. Specifically, they sought to implement task delegation capabilities to people, groups or stores.
In addition, they wanted the ability to provide schedule estimates for assigned tasks and store actual completion data. This would enable them to build metrics and provide dashboards to management for monitoring task completions by region, district, and store.
Tasks include activities such as inventories, seasonal merchandising refreshes, and sales. For example, during a seasonal promotion the management team defines the promotion, designs the displays and signs associated with the promotion, and defines the ordered tasks that the store employees need to perform. Stores receive packages of materials, and they use the project management system to go through the steps of setting up their store for the promotion.
RDA developed an intranet solution that provides project scheduling and task management capabilities to retail store operations.
The solution:
The solution dramatically improved communication between operational headquarters and store personnel. This enhanced communication allows leaders to know if a project has logistical issues when store personnel attempt to complete the project. As the system gathers data on project completion, leaders are equipped with the necessary data to report on and analyze this information, which improves future project cost estimating and scheduling. This decreases the cost of implementing projects, improving efficiency at the store level.
The application was built using ASP.NET and SQL Server 2005. It is hosted in Microsoft Office SharePoint Server (MOSS) 2007, which hosts the client's intranet.
The ASP.NET web application was constructed using a layered architecture:

Of particular note, LINQ to SQL was used to implement the Business/Data Access Layer, and the application integrated MOSS 2007 functionality when appropriate.
