We sat down with a Senior Category Manager in Procurement at a Fortune 50 life sciences company, one of Valdera's customers, to talk through his day-to-day work from the inside and where the Valdera platform fits in. We have given him the pseudonym Shane to maintain his anonymity.
Shane has been with the company for 8 years, and was promoted to lead a team 7 months ago. Before pharma, he ran category strategy in automotive and medical devices. His experience in three distinctive industries gives him insightful comparisons to share on how the same job is organized across different sectors.
We take a deeper look into 5 specific nuances of his role as a category manager in the pharmaceutical industry, and how this impacts a typical week in his job.
The five are more connected than they first appear. How Shane splits a category, how long it takes to build a supplier shortlist, how fast a backup gets approved and how much of his week disappears into manual tasks all come back to one question: can he confidently trust the material data in front of him?
Shane starts every category with the foundation: where the company stands today. He maps the current suppliers, the users of the material and the stakeholders who depend on it. Only then does he look outward at other suppliers and the wider market.
The same thinking shapes how he structures a category. Excipients are one category on paper but too broad to manage as one block, so Shane has carved out key products and product families. Some are small in spend but keep showing up in development requests. A material that ends up in many products carries supply risk whatever its spend, so these materials require at least a foundational strategy.
The strategy then grows as his understanding does, such as when new suppliers enter the market. The principles stay fixed, but the drivers, inputs and metrics change with every category. So Shane doesn't hand his team a template. Having spent years squeezing categories into a manager's preferred deck format, he now shares his vision and instead lets his team decide how their categories best fit.
Shane’s company's ERP system holds most of the material data as the system of record. However, it wasn’t implemented with all modules across all sites, meaning planners default to Excel to calculate safety stock and MOQ (minimum order quantity). One disadvantage that results from this is the number in the ERP and the number the planner uses are not always the same.
The consequences of this appear further downstream. When we asked what slows Shane’s team down, supplier qualification timelines were not at the top of his list.
One theme came up again and again in our conversation: material master and specification data that looks accurate enough, but is not. A report that is completely wrong gets caught quickly. A report that is 80% right gets circulated, presented and acted on. The latter shapes how Shane spends his week more than supplier negotiations or sourcing events do.
Shane explains, "You think you've got good data, and then you realize it wasn't accurate. It might have been 80%, but you still have that 20% to clean up. Data is by far the biggest challenge you could have across the board."
Then there is the master data and taxonomy mismatch. Shane constantly has to be alert for nuances when he asks someone to pull data, having to look in unexpected places to find what he’s looking for. As Shane puts it, "Our data integrity with our taxonomy just sucks. There are products all over the place and that's really not good, clean data. But I know that's kind of like any big company that's done a lot of acquisitions and, you know, brought other people's products and integrated their stuff into their systems."
The same material could be described in 3 or 4 different languages, depending on which site or function created the record. A material master created in Italian or German is lost in translation if a site in the US is searching for it. The language barrier prevents people from finding what they are searching for.
This also decides whether AI helps or hurts. An AI layer on top of an ERP inherits the accuracy of that ERP. Train it on records that are 80% right and its answers will have as many holes as Swiss cheese. It will also present them more confidently than any human would, because a generic LLM cannot spot incomplete data.
For a regulated API, the first filter is regulatory status. Price and capacity do not matter until the supplier has a current DMF (Drug Master File) with the relevant authority. With non-regulated excipients, the process is faster and less formal, where the filter is technical and commercial fit.
Most of Shane’s time goes into the search itself. Unlike Valdera’s supplier matching algorithm built on data science fundamentals, online supplier directories can be false friends. Manufacturers are often inaccurately listed as suppliers for chemicals that may be close to, but not exactly what they really produce. A search will typically return the same supplier name for a long list of products that they should not be matched to. As a result, Shane spends hours vetting suppliers, often manually, by contacting them and asking. "The (sourcing) system we have is built for all procurement, not just chemicals. For indirects it worked really well. But, when we wanted to be nimble and more chemical-related, it was just very clunky and suppliers hated it. Instead, we would do our own RFPs through emails."
Both types of material go through the same three sourcing steps, but the effort behind each step is very different:
The regulatory filter at the front is what stretches the API timeline. Every candidate has to clear it before the commercial conversation can start, and every extra function that needs to sign off adds more time. When the supplier database is padded with companies that were never a fit, each of those weeks includes time spent ruling out suppliers who should not have been on the list in the first place.
Shortlisting an alternative is quick when there is already a qualified backup in the system. It can even be done in days, in Shane’s experience. The information and the approvals already exist; the task is a commercial and operational decision, not a new supplier qualification.
A new supplier validation, on the other hand, is a lengthy process and is not prioritized unless something forces it. Shane described an excipient where the second source was sitting there for 3 years awaiting validation. Then, a quality issue with the incumbent supplier and COVID-related supply chain issues both landed at once. With both of these dictating urgency, that same approval was achieved in 4 months. Shanes advice, "If you have an opportunity, have it teed up, because once there is an episode or scenario, you gotta be ready, because you might not get that window again."
He goes on to say that once a site resolves a problem with an incumbent supplier, the urgency to qualify a second source disappears and the qualification work drops back to the bottom of the queue. "Once you fix the problem, they unfortunately move on to the next fire."
Every category manager relishes the strategic aspects of the job. But some manual, time-intensive tasks are inevitable. Shane recalls the manual research tasks focused around supplier benchmarking, market intelligence, and more generally staying on top of anything that can impact price movements or supply side pressures.
This tends to peak during budget season, when up to 50% of Shane's team's time can be spent on putting together these types of reports.
Initially, a ticketing system was implemented so that report requests would route to junior team members instead of category managers. It was scrapped within 2 years. Writing a request in enough detail for a non-subject matter expert to be able to spot inaccurate or missing data would often take more time than just pulling the data himself.
Shane still hopes that one day junior team members will run and deliver reports on their own. For that to work, he acknowledges the need for a unified request format and, most importantly, to have a reliable data structure underneath them.
For non-regulated materials priced monthly or quarterly, the team can spend around 25% of its time keeping up with market movements, whereas excipients need less because they face fewer cost pressures. He mentions that it can change quickly when the market turns or there are geopolitical conflicts that can drive prices up fast.
For the more mature categories where there are fewer players and it’s more difficult to switch suppliers, Shane cites most of the manual work here as being more SRM-related.
Asked what he would fix if he had one wish, Shane cited data integrity and a standardized taxonomy: a system where no one on his team has to know every item number by heart to run a report.
Building on a poor data foundation fundamentally makes it harder to deliver cost-out and world class supply chain performance.
This explains why data sits at the core of everything that Valdera does. Valdera’s comprehensive market intelligence, supplier database, and specification data act as the foundation upon which each of its core product features is built.
Valdera is the AI platform for raw material buyers and suppliers, built around exactly that problem. Here are 6 ways Shane now relies on the platform to make his day to day easier.
Chat with our team to discover how Valdera is helping raw material buyers and suppliers.