A lab's chemical and noise exposure studies in one system, with an Excel file per measurement
An industrial-hygiene reporting system built in-house at an occupational-health lab in Mexico, for chemical-agent (NOM-010) and noise (NOM-011) studies. I was promoted from data validation to developer and was principal developer of the four-person team that built it.

The problem
Grupo Microanálisis runs workplace exposure studies under two standards from Mexico's labor ministry (STPS): NOM-010 for chemical agents and NOM-011 for noise. Samplings are filed under a work order, and each sampling holds its measurements. The lab needed both kinds of study in one system that flags missing required fields and gives each measurement its own Excel file.
What I built
- We built the forms for chemical-agent and noise samplings and their measurements. Each measurement records the personal protective equipment in use.
- We added a catalog of NIOSH analytical methods for chemical-agent samplings.
- Forms flag empty required fields, and each measurement downloads as its own Excel file.
- I deployed the front end and the API, and presented the system on site.
Screens
Presenting the system on site to the laboratory team. Catalog of chemical sampling methods (public NIOSH methods). Field validation against the ranges each standard allows.
How it works
A React single-page app built with Material UI calls a Django REST Framework API. Zustand holds client state and Axios makes the HTTP calls. Each half deployed on its own: the front end as a static build on Vercel, the API as a web service on Render.
The data model follows the study: work order, then sampling, then measurement. Chemical-agent and noise samplings are separate REST resources.
The public demo no longer lets anyone sign in, because its API on Render is suspended. Screenshots stay private until the lab approves them, since several show its client records.
Results
- 2
- STPS standards covered: NOM-010 (chemical agents) and NOM-011 (noise)
- 4
- Developers on the team, with me as principal developer
Who else worked on it
SIGEM was a team project at Grupo Microanálisis, where I worked. Three other developers built it with me. The system and its data belong to the lab.
Full stack
React, Material UI, Zustand, Axios, Django REST Framework, Python, Vercel, Render