MLSC Case Study
Music Services
Music Library Service Company (MLSC)
Customer's Quote
GGK was able to take our project outline and develop an excellent solution to our
issues even when our guidelines were vague. Our team and our customers are very
happy with the results. Before beginning this project, communication was our biggest
concern. Our GGK Project Manager quickly gave us confidence with a professional
and detailed follow thru on every issue. Their ability to keep track of all the
details and provide regular updates by phone, email and web conferences was exceptional.
From start to finish, working with GGK has been a delightful experience.
-Dana L. Jaunzemis, President, MLSC Inc .
From start to finish, working with GGK has been a delightful experience.
-Dana L. Jaunzemis, President, MLSC Inc .
The Client
Music Library Service
Company – Wilmington, North Carolina
The Business Challenge
Music Library Service Company is a wholesale provider of recorded music and videos
exclusively to academic and public libraries for eighteen years. MLSC supplies any
CD/DVD in print and manage a database of over 700,000 active titles. Their main
goal was to provide a rich user experience via web application to minimize phone
based orders.
The Solution
GGK built an easy-to-use B2B E-commerce ASP. NET site without credit card processing
that has all the existing functionality and many new features that make the site
more usable and provide more value to MLSC customers. Various functionality that
the MLSC team had to do manually was made easy so that the web site users can create
their own orders easily.
The various parts of this solution are
- Advanced Search Capability: In Classical area the user can search based on composer, conductor, performer, work title etc
- Saved searches Feature: Allows user to save their search criteria so as to retrieve albums they would be interested easily
- Admin searches : where MLSC admins create the common searches that many users would be interested in, so that they are available out of the box to website users
- Rich and personal experience: use the AMG data to provide detail on the Pop/Classical/Video product details data
- Site administration made easy: allowing admins to be able to access/edit customer, order, sales report information
The different parts of the solution are
- Website portal: for online shopping as well as site administration
- Multiple large and complex databases: where all the data about the music and videos is stored
- Access Database: which resides on the customer machine so that they can set the prices and some other information as per their needs
- Automated tool: that picks up music/video data updates from the ftp site and makes appropriate changes to the database data
The Results
- Enhance the customer experience with tools created for their specific industry by allowing the software and database to display information in a unique and customized way
- Improve productivity with the advanced search functionality
- Icons to be able to easily identify additional information about the record, which helps in sorting through records much more easily
- Reduces the amount of time necessary for a customer to search and place an order while providing the customer more information for their purchasing decisions
Technologies Involved
.NET Framework, C#, ASP.NET 2.0, and SQL Server 2005