Not-for-Sale (NFS) Compliance Dashboard
Designed and operated a compliance monitoring system for medicines flagged as Not-for-Sale across Tata 1MG's national network of fulfillment centres (FCs) and large format centres (LFCs).
The system used metabase queries to identify new NFS SKUs, generate monthly reports, and trigger removal across relevant inventory locations.
Collaborated with warehouse operations, catalog, and compliance teams.
The Challenge
- NFS medicines were being added to the platform through normal SKU onboarding flows with no dedicated compliance gate.
- National scale: flagged SKUs needed to be communicated to and removed from multiple fulfillment centres and retail locations simultaneously.
The Approach & Solution
- Built a metabase query to automatically flag NFS SKUs from the platform database on a monthly basis.
- Designed a structured report and communication workflow to distribute flags to all relevant fulfillment centres and LFCs.
- Established a monthly review cadence with the compliance team.
Key Results & Commercial Impact
Technology Stack & Tools
Have a similar project in mind?
We specialize in custom AI systems, clinical data licensing pipelines, and scalable web apps. Let's build something exceptional together.
Explore More Projects
Google Health Partnership
Packaged clinical content as LLM training data, including drug monographs, DDI data, disease content, and regulatory safety data, in a B2B monetization deal.
Samsung Health API Integration
Real-time API integration spanning 600K+ SKUs, 50+ attributes, and a 200K-interaction DDI tool, enabling in-app discovery and routing cart/checkout to Tata 1mg.
Elsevier Clinical Monograph API Partnership
Tata 1mg's first clinical content licensing deal. Delivered 1,500 structured drug monographs over 9 months and built the CMS & API infrastructure.