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.
Reporteq tackled the problems with 3 key deliverables.
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
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.
Finally, all of this was wrapped up in user friendly portal complete with reporting, user management and responsive interface.
Microsoft SQL Server
ASP.NET Entity Framework 4.7.2
Hosted on Microsoft Azure