Profile: The External Affairs group within the University of Nebraska's Office of the President is responsible for planning, coordinating, and tracking a large number of special events each year. In order to successfully manage these events, the group uses a database of contacts to send invitations and information to University supports across the State and the nation, and to record details about the event.

Problem/Opportunity: The current database used by the External Affairs group requires a significant amount of manual labor in order to interact with contacts and maintain contact information. This makes it difficult to maintain accurate and complete information for the large number of contacts and the numerous events held each year. The current database also lacks sufficient flexibility to integrate information from other sources.

Solution: The J.D. Edwards Design Studio team is working with the External Affairs group to design and construct a new contact management system. The new "NUContact" system will feature a web-based interface and a new database that will be used to store and manage user, contact and event data.

Benefits: The new "NU Contact" system will provide a central location for collecting and storing contact data and will help in event management, contact management, data mining, and reporting.

The new system will address the needs of the President's Office by providing:

1. Centralized data storage for their information (contacts, NU events, and demographic information)
2. An easy-to-use interface for event planning and contact management.
3. An efficient query and report interface.
4. Better data organization via categorization and standardization.
5. A more flexible design that will support integration with information from other sources.

Technologies:

Microsoft SQL (MSSQL)
Microsoft ASP.NET
C#
HTML