Vally Proteins, Inc.

Valley Proteins required a revamp of their existing desktop based (VB) CRM system for their sales team who enter lead/sales data. Existing system was built over a long period with tight coupling between application and data layer.

The system was unable to deliver reports due to the database design which was not normalised. Also the application was only accessible through a VPN, making it difficult to track leads in real-time.

Challenge:

Valley Proteins required a revamp of their existing desktop based (VB) CRM system for their sales team who enter lead/sales data. Existing system was built over a long period with tight coupling between application and data layer.

The system was unable to deliver reports due to the database design which was not normalized. Also the application was only accessible through a VPN, making it difficult to track leads in realtime.

Solution:

The project involved understanding existing system a and leveraging the functional knowledge to build a Restful API layer and a responsive web based application accessible on an iPad.

The database schema was architected to help the application scale to other core business areas beyond CRM for Valley Proteins.

Impact:

Valley Proteins was able to bring their large pool of sales representatives online where they could update/inquire critical CRM data in real-time – aiding them in sales decisions. The top management at Valley Proteins is able to generate various reports to measure and track their Sales, Driver and Customer information.