ASM case study

ASM
case study

TIMELINE
~2 year

INDUSTRY
Pharmaceutical

CLIENT
A-S Medical Solutions

A-S Medication
Solutions

A-S Medical Solutions (formerly Allscripts Medication Services Group) (“ASM”) has been in business since 1988. ASM is the industry leader in providing turnkey, end-to-end, on-site medication dispensing solutions.

ASM’s FDA/DEA approved automated repackaging facility spans over 165,000 square feet, and they are also a VAWD accredited wholesaler located in both Illinois and Nebraska.

ASM has created the most efficient and user-friendly, web-based dispensing system in the industry.

ASM operates as a pharmaceutical depot that purchases medications in large quantities, repackages them, and subsequently distributes them to customers such as pharmacies and physicians.

The main objective

& problem

ASM requested a modernization of their conventional flat-file
format database. To accomplish this, Mexicode was hired to
continue work initiated by ASM’s team and develop a database
that fulfills contemporary needs.

The main goal was to integrate Mexicode’s team of developers
into ASM’s existing technical team for required deliverables.

The solution

During the course of the project, Mexicode provided the following deliverables:

Updated the ETL (Extract, Transform, Load) process to convert data from the legacy database to a modern MS-SQL server.

Updated the modern database to bring additional
data from the legacy system.

Updated the API layer to improve ASM client communication with the modern database.

Led an initiative to create automated testing for all parts of the API to create a baseline for future projects.

Created an invoice generator for dynamic creation and printing receipts for shipped products.

Created an automation system for communicating with customers affected by drug recalls.

Designed new web pages for interaction with the API:
user permission management, reports of purchase history to guide future buying decisions, and control of drug recalls.

Project growth

ASM was looking for a straightforward approach to expanding the development team. We promptly presented ASM with five skilled developers who were well-suited for the project’s requirements. Following this, our team expanded from an initial 5 members to over 15 within a span of six months.

Communication

Mexicode swiftly adjusted to ASM’s initial team timelines and schedule, and within a month, we took the lead and began working autonomously
with minimal supervision.

This allowed us to handle tasks and resolve issues efficiently, saving ASM’s developers a considerable amount of time.
We proactively addressed challenges and responsibilities, actively engaged in meetings, and had autonomy in determining our tasks to attain the primary project goals.

Client Testimonial

“Mexicode has delivered incredible value for the cost. In the first two quarters of 2022, the firm helped us develop automated data analytic capabilities that have saved us over 400 hours in analytics labor and counting.

Today, they are developing a new invoicing system, which involves implementation of some of the most burdensome healthcare regulations in the country. They have quickly learned the fundamentals. Today, they move so quickly, they exceed our ability to define and manage future projects. Working with Mexicode has been the most effective investment in developer talent we have made.“

Brandon Jackson

Director of Technology, A-S Medication Solutions

@brandon-r-jackson

We used

Mexicode did not make any decisions regarding the technology stack used for these projects. Instead, we adapted to the customer’s requirements based on their established database and system.