The Client Profile: Amneal Pharmaceuticals

Amneal Pharmaceuticals, Inc.** **(Nasdaq: AMRX) is a diversified global biopharmaceutical company headquartered in Bridgewater, New Jersey, focused on expanding access to affordable and innovative medicines. Founded in 2002, Amneal has grown into a major pharmaceutical organization with a diverse portfolio spanning complex generics, specialty medicines, injectables, and biosimilars.

Today, Amneal's portfolio includes approximately 300 medicines, with the company delivering more than 160 million prescriptions annually, primarily across the United States. Its Affordable Medicines business spans retail generics, injectables, and biosimilars, while its Specialty business provides branded treatments in areas including neurology and endocrinology. Through AvKARE, Amneal also distributes pharmaceutical and medical products to U.S. federal, retail, and institutional customers.

Operating at this scale requires more than pharmaceutical innovation and it requires accurate, accessible, and scalable product data management. As Amneal's portfolio and operational requirements continued to expand, the company identified an opportunity to modernize how pharmaceutical product information was managed internally and presented digitally to customers and other external users.

The Challenges

Managing Pharmaceutical Product Data Across Disconnected Excel Spreadsheets

Amneal maintained critical product catalog information across multiple Microsoft Excel spreadsheets. While spreadsheets can provide flexibility at a smaller scale, managing a growing pharmaceutical product portfolio across disconnected files created increasing operational challenges; teams faced issues including:

• Multiple versions of pharmaceutical product data

• Manual product information updates

• Limited reporting capabilities

• Data-entry inconsistencies

• Version control challenges

• Difficulty maintaining a single source of truth

• Increased administrative effort

• Limited scalability as the product portfolio expanded

For a pharmaceutical organization operating in a highly regulated environment, **product data accuracy and governance are critical. **Amneal needed to replace disconnected spreadsheets with a more structured and centralized product information management environment and leadership determined that Quickbase could provide the flexible application and database architecture required to consolidate product information into a centralized system; however, internal product data management was only half of the challenge.

Publishing Accurate Pharmaceutical Product Information Online

Amneal also needed a more effective way to make approved pharmaceutical product information available through its public-facing digital experience. The company's existing website was controlled by a third-party provider and this created a significant operational dependency. When product information needed to be changed online, Amneal could not simply update the information internally and publish it, instead, the company needed to submit a request to the third-party website provider and wait for the vendor to implement the change.

For an organization managing a large and evolving pharmaceutical portfolio, that workflow limited agility and that created an unnecessary gap between: Internal Product Data → Website Update Request → Third-Party Action → Published Product Information

Third-Party Website Management Created Product Update Delays

Reliance on an external provider created several challenges:

• Product updates could not be published immediately

• Internal teams lacked direct control over routine catalog changes

• Website information and internal product data could become disconnected

• Updates required additional communication and coordination

• Product catalog enhancements became increasingly resource-intensive

• Advanced search and filtering functionality was difficult to implement

• Scaling the catalog would increase ongoing maintenance requirements

The challenge became even more significant as Amneal considered improving how users searched and navigated its product catalog and adding more product fields, filters, categories, or search capabilities would make the third-party update process increasingly cumbersome; Amneal needed a different architecture.

The Solutions

Quickbase and Workato Pharmaceutical Product Data Automation

Amneal partnered with Quandary Consulting Group to modernize its pharmaceutical product catalog management infrastructure.

Following discovery and technical assessment, Quandary designed a centralized architecture using Quickbase and Workato to manage product information, automate workflows, and connect approved data with the public-facing digital catalog. Quickbase became the centralized application and product data layer and Workato provided integration and workflow automation capabilities, helping connect processes and data between systems.

Together, the technologies created a more scalable pharmaceutical product information management environment and the solution connected: **Product Data → Quickbase → Workato Automation → Approved Public Data → Digital Product Catalog; **this replaced fragmented data management and manual third-party update processes with a more connected architecture.

Quickbase Creates a Centralized Pharmaceutical Product Database

Quandary migrated product information from fragmented sources into a structured Quickbase product management application. Instead of product information being distributed across Excel spreadsheets and other disconnected sources, Amneal gained a centralized environment for managing catalog data. Quickbase became the company's single source of truth for product information used by the solution and this centralization improved the way information could be:

• Entered

• Organized

• Validated

• Updated

• Reported

• Searched

• Published

This provided a more scalable foundation for managing an expanding pharmaceutical portfolio.

Replacing Excel With Structured Product Information Management

Moving product data away from disconnected Excel spreadsheets addressed one of the core operational problems. Rather than employees maintaining separate versions of product information, data could be managed within a structured application and this reduced opportunities for:

• Duplicate records

• Conflicting product information

• Outdated spreadsheets

• Manual transcription errors

• Inconsistent formatting

• Version-control problems

Structured product data also created stronger reporting capabilities and instead of manually compiling information from multiple files, teams could work from a centralized dataset designed specifically around Amneal's product management requirements.

Workato Automates Product Data Workflows

Quandary incorporated Workato automation into the architecture to help connect product information and associated workflows. Workato served as the integration and automation layer surrounding the Quickbase product database, helping reduce repetitive manual processes and improve the movement of information between connected systems.

The combination created a clear division of responsibility:

• Quickbase centralizes and structures the pharmaceutical product data.

• Workato automates integrations and workflows surrounding that data.

This architecture gave Amneal greater flexibility to manage product information while reducing reliance on manual system-to-system processes.

A Custom Public Pharmaceutical Product Catalog Powered by Quickbase Data

Centralizing product data solved the internal management problem and Quandary then addressed the external publishing challenge. The team developed a custom, brand-aligned digital product catalog capable of displaying approved information from Amneal's centralized product database.

Instead of maintaining a separate public catalog dataset that required manual updates, the website could dynamically use information originating from the centralized Quickbase environment and this created a more direct connection between the information Amneal managed internally and the approved product information available externally.

Real-Time Product Catalog Updates

One of the most important improvements was the ability to update online product information without relying on a third-party website vendor for every routine change.

• **Previously: **Amneal identifies update → contacts vendor → vendor processes request → website changes

• **With the redesigned architecture: **Amneal updates approved product data → connected system reflects the change online

This gave Amneal significantly greater control over the accuracy and timeliness of its public product catalog. Product information could remain more closely aligned with the company's centralized data rather than being maintained as a separate, manually updated website dataset.

Advanced Pharmaceutical Product Search and Filtering

The new architecture also created opportunities to improve how users interact with Amneal's product portfolio. Quandary developed a searchable, user-friendly product interface capable of displaying approved product fields from the centralized system.

Users could more efficiently navigate and locate relevant products using structured catalog information and this represented a major improvement over a static or manually maintained product directory and since the public catalog was connected to structured product data, Amneal gained a stronger foundation for:

• Product search

• Filtering

• Product categorization

• Structured product attributes

• More intuitive navigation

• Future catalog enhancements

The result was not simply a better database, it was a much better pharmaceutical product discovery experience.

Protecting Sensitive Pharmaceutical Data

Not every field stored in an internal pharmaceutical product management system should be publicly accessible and the solution therefore needed to distinguish between internal operational information and data approved for external display. Quandary designed the architecture so the public interface displayed only designated product fields and this allowed Amneal to maintain richer internal datasets within Quickbase while controlling which information could appear on the public website.

• **That distinction created an important security boundary: **Internal Product Data ≠ Public Product Data

Only approved information was exposed through the public-facing experience.

Maintaining Brand Standards and Regulatory Requirements

The public catalog also needed to align with Amneal's brand standards and pharmaceutical operating requirements. Rather than delivering a generic Quickbase interface to external users, Quandary created a customized web experience designed around the company's digital presence and this allowed the catalog to combine centralized product data with an experience appropriate for customers and other external users. Security, controlled data exposure, and compliance considerations were incorporated throughout the architecture and implementation.

Eliminating Dependence on Third-Party Website Updates

One of the most important operational changes was organizational control. Previously, routine catalog maintenance required coordination with an outside website provider and after implementation, Amneal's internal teams gained significantly greater control over product information and how quickly approved changes could be reflected online; this reduced:

• Vendor dependency

• Update delays

• Administrative coordination

• Manual website change requests

• Duplicate product maintenance

The organization could manage its product catalog much more directly.

The Results

A Centralized, Real-Time Pharmaceutical Product Catalog

The implementation of the Quickbase and Workato product management solution transformed how Amneal managed and published pharmaceutical product information and instead of maintaining product information across disconnected spreadsheets and separately coordinating public website updates, the organization gained a centralized product data architecture connected to a searchable digital catalog.

Real-Time Website Product Updates

Approved product changes made through the centralized system could be reflected on the public-facing catalog without waiting for routine manual updates from an outside website provider. This gave Amneal greater control over the timeliness of its online product information and internal teams could respond more quickly when catalog information needed to change.

One Source of Truth for Pharmaceutical Product Data

Quickbase established a centralized environment for managing product information and instead of maintaining critical product data across multiple spreadsheets, employees could work from a common dataset. This improved:

• Data consistency

• Data accessibility

• Product information accuracy

• Reporting

• Internal visibility

• Product data governance

The result was a stronger foundation for both internal product management and external publishing.

Reduced Product Data Entry Errors

Eliminating disconnected spreadsheets and redundant website update processes reduced the number of times product information needed to be manually entered or transferred. Every unnecessary manual handoff represents another opportunity for human error and by centralizing information and automating connected workflows, Amneal reduced those opportunities and strengthened product data integrity.

Improved Pharmaceutical Product Reporting

Structured data within Quickbase also provided stronger reporting capabilities than the company's previous spreadsheet-based environment. Employees could access and analyze centralized product information without manually combining multiple Excel files and this improved operational visibility and created a more useful product information resource for internal teams.

Better Digital Product Discovery for Customers

External users also benefited from the new architecture and instead of navigating a catalog limited by a cumbersome third-party maintenance model, customers could interact with a more searchable and user-friendly pharmaceutical product catalog. Structured search and filtering capabilities made it easier to locate relevant information within Amneal's expanding portfolio.

A Scalable Product Data Infrastructure for Amneal's Growing Portfolio

Scalability is particularly important given Amneal's broader business trajectory. The company now maintains a portfolio of approximately 300 complex generic, specialty, and biosimilar medicines and delivers more than 160 million prescriptions annually.

A growing pharmaceutical portfolio requires an information architecture capable of evolving alongside it. The Quickbase and Workato solution established a flexible foundation that could accommodate new products, additional data, expanded reporting requirements, and future digital catalog functionality without returning to fragmented spreadsheet management.

From Excel Spreadsheets to an Integrated Pharmaceutical Product Information Platform

Amneal's challenge wasn't simply maintaining a website. It was managing the relationship between internal pharmaceutical product data and the digital experience through which that information reaches external users.

Quandary Consulting Group used Quickbase application development, Workato integration, workflow automation, structured product data management, and custom web development to connect those two environments. **Quickbase **created a centralized source of structured product information. Workato supported automation and integration surrounding that data. The custom digital experience gave Amneal a controlled way to make approved information searchable and accessible online.

The result was a more accurate, scalable, secure, and agile pharmaceutical product information management system that reduced manual administration while giving Amneal greater control over its growing digital product catalog.

Key Results Delivered:

Quandary Consulting Group's Quickbase and Workato solution enabled Amneal to:

• Centralize pharmaceutical product information in Quickbase

• Replace disconnected Excel-based product management

• Establish a single source of truth for product data

• Connect centralized product information to a public-facing digital catalog

• Enable real-time product catalog updates

• Reduce dependence on third-party website providers

• Reduce manual product data entry

• Reduce opportunities for data-entry errors

• Improve product data accuracy and consistency

• Strengthen product data governance

• Improve product reporting capabilities

• Automate connected workflows with Workato

• Control which product fields are publicly displayed

• Provide advanced product search and filtering

• Improve the external product discovery experience

• Maintain brand alignment across the public catalog

• Create a scalable infrastructure for continued portfolio growth