AMG Equipment

AMG Equipment needed the ability to consume 2 Million plus records of device and item data from the GUDID government website.

Additionally, they were struggling with a very manual process for shipping/receiving and overall managing inventory.

Solution:

Reporteq tackled the problems with 3 key deliverables.

  1. Creating two-fold approach for consuming the massive dataset that included building a database with the automated processing via provided flat files and augmenting the data with creating an integration through the provided API
     

  2. The next problem tackled was the ability to use a barcode scanner to be able to receive product and to search and pull up item records. Logic was established to read the GS1 standard barcode and consume key data points such as Lot Number, Expiration Date and Serial Number.
     

  3. Finally, all of this was wrapped up in user friendly portal complete with reporting, user management and responsive interface.
     

Technologies Used:

Microsoft SQL Server

ASP.NET Entity Framework 4.7.2
Antlr
Bootstrap
jQuery

Hosted on Microsoft Azure

CONTACT

admin@reporteq.com

Tel: 888-818-9533

1434 Village View Rd

Encinitas, CA 92024.