Array Science Logo

Array Science

Laboratory Management System

Web AppBiotech / PathologyFileMaker Migration
Array Science dashboard showing key metrics, monthly activity charts, and sample breakdowns

The Challenge

Array Science manufactures tissue microarrays (TMAs) -- precision laboratory products used in cancer research and diagnostic testing. Their entire operation ran on a legacy FileMaker database that limited them to single-user access, had no remote capabilities, and forced quality control tracking into separate spreadsheets. As the business grew, the platform could not keep up with their manufacturing workflows, compliance requirements, or multi-user needs.

What We Built

I built a full-stack web application that replaced the FileMaker system entirely, covering every part of their operation -- from tissue sample intake and storage tracking, through TMA block design and multi-stage manufacturing, to quality control testing across six laboratory methodologies (IHC, FISH, CISH, PSR, image analysis, and flow cytometry). The system includes sales pipeline management, equipment maintenance logging, SOP document control with version management, and personnel training records. A one-way sync engine bridges the transition by pulling data from the existing FileMaker system, allowing both platforms to run in parallel until the team is fully migrated. The interface replicates FileMaker's familiar search patterns to eliminate the learning curve.

Key Outcomes

Replaced a legacy single-user desktop database with a modern multi-user web platform

Consolidated quality control tracking from separate spreadsheets into the core application

Enabled remote access for staff -- no longer required to be on-site to use the system

Full audit trail on every data change for regulatory compliance

Parallel migration path with live FileMaker sync -- zero downtime during transition

Built-in bug reporting on every page for continuous feedback from lab staff

Inside the Application

TMA block design grid with tissue sample mapping and project details

Block Design

Quality control detail view with IHC, FISH, and CISH testing panels

Quality Control

Anchored slab request form with well configuration parameters

Manufacturing Requests

Donor sample detail with processing, storage, and lineage tracking

Sample Tracking

Built With

ReactTypeScriptMaterial UIFastAPIPostgreSQLRedisDocker

Need a Custom Solution Like This?

Whether you're replacing a legacy system or building something new, let's talk about what your business needs.

Start a Conversation