Case Study

AMG Equipment

Details

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

Problem

They were struggling with a 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

Have an idea you’d like to take to market?

Do you have an idea you’d like to take to market? We’d love to hear it.
We’d love to help make it reality.