0308. The Space Between Systems-এর সম্পূর্ণ প্রতিলিপি

cost of fragmented systems. 00:03:24.750 --> 00:03:26.909 It's not on any budget line. 00:03:27.549 --> 00:03:29.549 It shows up as late nights. 00:03:29.870 --> 00:03:35.150 And the question I've heard in more conference rooms than I can count what's the right data? 00:03:35.310 --> 00:03:38.030 So let's talk about what happens when the data doesn't flow. 00:03:38.669 --> 00:03:49.789 Lawrence, I think in one of our earlier episodes, perhaps in this season, I don't recall, you you said something to me, and I'm gonna tell you what I believe first, and you can feel free to tell me if something's wrong. 00:03:50.030 --> 00:03:54.109 I don't think anybody owns the space in between these systems. 00:03:54.909 --> 00:04:00.829 And what you've mentioned to me before was that somebody does own them, but they just don't know it yet. 00:04:00.989 --> 00:04:02.349 So where do we go from there? 00:04:02.509 --> 00:04:07.150 Who is responsible to carry this translation burden? 00:04:07.949 --> 00:04:16.430 Who is responsible for connecting these desperate systems that are at that point in time the right choice? 00:04:16.670 --> 00:04:24.030 You know, I think this is something that we have seen time and time again, and it seems like there is no end to it. 00:04:24.189 --> 00:04:31.310 So, Lawrence, you've been a part of these organizations, these large organizations, facilities and manufacturing. 00:04:31.790 --> 00:04:38.110 What's the first thing that tells you that there's an issue with data moving in between systems in your space? 00:04:38.269 --> 00:04:41.470 Uh I think we go many ways about this. 00:04:41.790 --> 00:04:45.069 So not everything needs to be connected, I think, first of all, right? 00:04:45.150 --> 00:04:58.030 I I think as new things or new technologies and new platforms come up, you you as a company will uh integrate them into your company, and you have to kind of figure out where they fit and how they work together. 00:04:58.430 --> 00:05:12.509 And a lot of the times, I I know more so in the you know the last decade or so, because we've had such an acceleration with these uh you know software as a service companies, you you still have enterprise software. 00:05:12.670 --> 00:05:20.589 Uh obviously, all the the the language models now that we use have all been embedded into a lot of the the way that we work. 00:05:21.230 --> 00:05:33.870 But oftentimes what you'll see is like this uh the IT does their work and like, hey, we've offered you this tool, and it's kind of like up to everybody else who is now part of the you know company to kind of figure out how to best use it. 00:05:34.029 --> 00:05:42.269 And it's not uh it depends on where your ownership is of the work that you do, right? 00:05:42.589 --> 00:05:47.389 So if you're in a specific department, like let's say you're in like a maintenance, right? 00:05:47.629 --> 00:05:56.750 You like a very simple example is you want your system that manages your your work activities to connect

with your inventory system, right? 00:05:56.829 --> 00:06:19.069 Because you need to order parts, and you know, sometimes the platform doesn't, it's not connected to your procurement systems, and usually procurement is like its own separate sort of system because it has handles financial data for other departments, but for maintenance, like you have you know one software that you're using to manage activities and all your assets, and so they may not uh talk to one another. 00:06:19.149 --> 00:06:24.509 Um and it's sometimes it's it has to do with both the two pieces that you need to integrate, right? 00:06:24.589 --> 00:06:31.949 So that integration may be very clunky and you have to do a lot of manipulation from you know one source to the other. 00:06:32.509 --> 00:06:45.469 I think the other part of it is um aside from just the the tools integrating with each other, I think the sometimes people want to keep it separate because the departments that handle procurement are not the same people that are doing the work. 00:06:45.550 --> 00:06:53.149 And so they're like, we don't need to connect it because our work has nothing to do with that, except when you do the handoffs, that's when the problem comes, right? 00:06:53.310 --> 00:07:03.949 So if if your role involves both of the systems, obviously you would want the you know those two connected, so you're kind of pulling from the same data source and you're operating interchangeably between the two. 00:07:04.269 --> 00:07:12.110 But what I often find at large companies is that those groups of people that are you know executing the work orders are not the same people that are purchasing the parts. 00:07:12.269 --> 00:07:22.349 And so they have different responsibilities and roles, and so they don't they don't have to necessarily be involved with how the items are being purchased. 00:07:22.430 --> 00:07:26.990 And then on the other end of it, the people purchasing the items don't really care how the items are being used, right? 00:07:27.069 --> 00:07:31.389 So it's this like where are the boundaries and where the handoffs are. 00:07:31.550 --> 00:07:45.310 So I think for a smaller company, when you do have less people, but then there's probably a lot of um different applications you can use, you have to be very aware of what your tech stack looks like. 00:07:45.389 --> 00:07:59.629 Otherwise, it's just gonna balloon and then you end up paying crazy amounts of money for licenses and tokens that you don't even use and becomes a huge waste of money, and then nobody owns anything because as you're growing and scaling, you're just you're adopting these new tools because you're building something, right? 00:07:59.870 --> 00:08:10.990 And so I think you have to have that flexibility of okay, not everything that we sign up for has to have a specific need because we're trying to see where it's gonna fit within the company, and then you grow. 00:08:11.149 --> 00:08:13.550 I mean, just like how we've like grown

the company, right? 00:08:13.629 --> 00:08:20.110 Like there's different tools that we adopt and we're experimenting and we're trying to see what things work and what don't work, and you're piloting it. 00:08:20.189 --> 00:08:26.670 And I think we have gotten to a point where like if we're using something and it really doesn't fit with what we're doing, we get rid of it. 00:08:26.829 --> 00:08:39.149 That's easier to do when you're small at a large company that's not so straightforward because you have these agreements and like IT has signed up for some sort of contract with this company, so you can't just you know cut the cord and get rid of it. 00:08:39.389 --> 00:08:43.950 There's all this like uh data and compliance that you have to adhere to. 00:08:44.110 --> 00:08:49.389 You know, if you've been using the system for a couple years, you can't just yank it out because what do we do with all the data that they have? 00:08:49.550 --> 00:08:50.750 Where does it migrate to? 00:08:50.909 --> 00:08:54.590 Who like what are the permissions and the roles and who else is using it in the company? 00:08:54.750 --> 00:08:58.590 Do we have to ask them if we get rid of it, or do we just pull the plug because it's too expensive, right? 00:08:58.670 --> 00:09:00.830 So there's all these like little questions that come up. 00:09:01.550 --> 00:09:10.670 And it makes it, you know, there are two different scenarios, and um it gets even more complicated when you have multiple sites across the network, right? 00:09:10.750 --> 00:09:14.509 It's not just like one you know physical facility that you have. 00:09:14.670 --> 00:09:25.870 When you have multiple facilities in your company, everybody's using it differently, and you have to kind of figure out, you know, if you're going to adopt the new tool, how does it integrate into all these other sites that are using the same application? 00:09:26.190 --> 00:10:02.670 So yeah, lots of uh different ways to go about this, but I think there's not a single company in the world unless you're maybe like an Uber or like a DoorDash where like all your work is contained within the same system, where you have the the driver to the restaurant, like everything's kind of you can see all that movement and the transactions, but for in pharma, we we just there's there's so many different things that are happening between research and development, product development, manufacturing, and then your shipping and you know all of this that we're using different pieces of technology. 00:10:02.750 --> 00:10:14.190 So it's it would be it wouldn't be wise to connect everything because you don't have to, because sometimes you know separate business units, separate scopes of work, like you don't need to connect all of them. 00:10:14.270 --> 00:10:22.670 Um but you do need to understand what things need to be connected, and for the things that aren't connected, are you gonna live with that, right? 00:10:22.830 --> 00:10:25.150 Are you gonna be okay

with those things not being connected? 00:10:25.390 --> 00:10:30.350 So it's a very long answer to what you just asked, but that's kind of like my opinion on the whole thing. 00:10:30.430 --> 00:10:35.790 It depends on the size of the company and then you know the the the boundaries of the work itself. 00:10:35.950 --> 00:10:38.910 Like where does it end and where does it start and what does it handoff? 00:10:38.990 --> 00:10:39.629 And yeah. 00:10:40.030 --> 00:10:43.150 I'm gonna push back a little bit on on what you said. 00:10:43.390 --> 00:11:00.990 It's not that I believe systems need to be technically integrated, you know, as you would integrate Smartsheet to Excel outputs or Smartsheet into a PowerPoint that delivers a report, etc., through Chat GPT. 00:11:01.310 --> 00:11:07.310 I'm not really looking at that type of integration when I say that these systems should be integrated. 00:11:07.470 --> 00:11:10.750 These these systems, systems should talk to each other. 00:11:11.070 --> 00:11:15.629 I'm looking more at the data itself, the underlying information. 00:11:15.790 --> 00:11:16.430 I agree. 00:11:16.670 --> 00:11:20.910 People do not necessarily care about how things are being conducted in procurement. 00:11:21.070 --> 00:11:35.950 However, they do need to have some understanding of what happens, because what I see often is when folks don't understand that process, they are met with a wall that is going to take them four weeks to get through. 00:11:36.110 --> 00:11:42.510 When I say that these, you know, that our data, you know, or our tool, how does our data flow? 00:11:44.030 --> 00:11:51.470 They sit on a thread, whether it's an asset ID, a project name, a site, a location. 00:11:51.710 --> 00:12:03.710 One of the challenges that I see very often is the translation hurdles that happen from a budget that is designed for uh research operations. 00:12:03.870 --> 00:12:12.350 And about six, nine months later, when you go in to reconcile these were the things you said you were going to do, and here's all the expenses. 00:12:12.510 --> 00:12:28.190 And the finance team is looking at them and saying, these listings of things that we have purchased, whether it's you know materials or support, don't match up to anything that I see on the budget because we're using different languages. 00:12:28.350 --> 00:12:30.110 We're talking about things differently. 00:12:30.830 --> 00:12:37.550 We don't care how this how the procurement goes, you tell me how it needs to go, and I'll try to be I'll try to be in preparation for that. 00:12:37.790 --> 00:12:43.710 But what it's causing is this sort of this is the symptom that I'm referring to, is that human API. 00:12:43.870 --> 00:12:53.870 This is that fragmentation where it's not architecture diagrams, it's a person that has 10 tabs open, reconciling by eye. 00:12:54.030 --> 00:12:55.950 They have a Slack message that comes in. 00:12:56.110 --> 00:12:58.430 Sorry, I have a quick question about the tracker. 00:12:59.150 --> 00:13:04.350 The other spreadsheet that somebody created was the real system, but it's too slow. 00:13:04.670 --> 00:13:08.110 So now it's it's it's not giving us the information we need. 00:13:08.270 --> 00:13:14.750 So we're gonna try to go this other direction to get the information we need, but the information doesn't actually connect. 00:13:14.910 --> 00:13:22.750 I can't look at these line items that are being delivered through this system and mash them with the line items in your system. 00:13:23.070 --> 00:13:35.790 But in order for us to develop a cohesive budget or expense report of what actually we've been expensing, et cetera, I need to understand what of these line items fit into each one of these spaces. 00:13:36.030 --> 00:13:44.910 It is a very, very common challenge that I see in pretty much any of the organizations I have worked for in my career. 00:13:45.230 --> 00:13:48.270 You know, there's I mean, I think you've seen it sometimes. 00:13:48.430 --> 00:13:58.750 I, you know, in reconciling the the budgets and the expenses for Signal Lab Consulting, sometimes you, you know, when I email you and I say, uh, what is this for? 00:13:58.910 --> 00:14:09.470 Because I look at the description, the description doesn't tell me anything because the business names do not necessarily coincide with the name of a transaction. 00:14:09.710 --> 00:14:20.430 So, you know, yeah, we went and had dinner over here, but for some reason I got a transaction in the credit card report that comes out from California that doesn't tell me that this is from a restaurant. 00:14:20.590 --> 00:14:31.790 It doesn't even, you know, QuickBooks is gonna do what it can do, but that language is causing that symptom that requires a human transcriber. 00:14:32.910 --> 00:14:45.710 You know, and then when you start to look at that, and let's say we're talking about two separate people, let's say we're talking about those folks that are in the facilities that are, you know, in the manufacturing facility, they're doing their work, and there's folks in procurement. 00:14:46.590 --> 00:14:56.590 Who is responsible for ensuring that yes, the things that we are asking for, procuring are the things that exist in our budget. 00:14:56.750 --> 00:15:07.070 This is how they're lined up, or vice versa, since this is a financial type of issue, is that finance that has to come and seek you out and say, I need this information from you? 00:15:08.190 --> 00:15:17.629 You know, I think I find some of those challenges that we don't really know who this is supposed to who's supposed to be managing this. 00:15:17.790 --> 00:15:22.030 You know, when did when did copy and paste become part of that job description? 00:15:22.350 --> 00:15:35.710 And how long is it going to sit with that person who decided to raise their hand and say, yeah, I can do it this time, that now they're being asked to do that month over month because the data is not connected. 00:15:35.870

--> 00:15:40.430 Not necessarily the systems themselves, because that can be a challenge. 00:15:40.590 --> 00:15:48.590 Unless you have a master coder, which now you can do a lot of coding, but you need an expert behind any kind of AI coding to make sure that it's sound. 00:15:48.830 --> 00:15:58.030 Creating these APIs to integrate various software that you might be using is really difficult to do and difficult to maintain. 00:15:58.190 --> 00:16:02.990 You're creating a web of connections that is not native to those systems. 00:16:03.230 --> 00:16:07.150 So if that person leaves, there goes the knowledge, right? 00:16:07.310 --> 00:16:16.750 So it's, I think there's a lot of things for us to consider when we're talking about, you know, systems and data fragmentation. 00:16:17.870 --> 00:16:19.550 And then at what cost is that? 00:16:19.710 --> 00:16:21.950 What is the who are we relying on? 00:16:22.110 --> 00:16:27.710 Are we relying on the group that set up the budget, that their budget is still sound? 00:16:28.030 --> 00:16:33.550 Or are we relying on the procurement and the finance group to tell us we're about to be over budget? 00:16:33.710 --> 00:16:39.470 The challenge here is that fragmentation, this type of fragmentation is usually invisible. 00:16:39.629 --> 00:16:45.629 You don't see it until you're asked to deliver something that doesn't exist with the systems that you have right in front of you. 00:16:45.950 --> 00:16:57.629 Until these two systems disagree in front of leadership or someone in hierarchical power at the organization, it's probably not going to get resolved. 00:16:57.790 --> 00:17:01.230 It's going to get resolved through, you know, just one-offs. 00:17:01.470 --> 00:17:03.950 Oh, this person did it last time, this is what they did. 00:17:04.029 --> 00:17:05.470 And you're going to continue to do that. 00:17:05.549 --> 00:17:06.990 But then it becomes a trust problem. 00:17:07.150 --> 00:17:15.710 Now we're creating a new system, a new workflow that involves a translation period that we're sort of creating the rules. 00:17:15.869 --> 00:17:38.509 But then once people stop trusting the information they're receiving, they're going to start carving their own methods, their own procedures, their own process, their own workflow that unfortunately probably does not get documented, does not get discussed to everybody else to say, hey guys, I've had to do this on my project, I've had to do this in my department. 00:17:38.670 --> 00:17:40.990 You should consider doing this as well with that group. 00:17:41.390 --> 00:17:43.069 I don't see that often happening. 00:17:43.470 --> 00:17:53.869 I sort of see it as like everyone sort of creating their own methods to to get around the issues. 00:17:54.430 --> 00:17:54.829 Right. 00:17:55.789 --> 00:17:57.069 And that doesn't scale. 00:17:57.230 --> 00:18:08.269 That's not you you can't have consistency if that's it's everyone is using their own methods to solve the simple challenge

of a dis of a fragmented data. 00:18:08.589 --> 00:18:08.750 Yeah. 00:18:08.829 --> 00:18:18.589 I mean, and going back to your example too, I think it's it's pretty easy, or it should be easy, depending on the size of your company and how mature you are. 00:18:18.909 --> 00:18:38.990 But for things that if if it's transaction-wise, like you're, you know, you need a certain number of bolts for a specific job, like you can forecast that and you can determine, you know, these items are going into this asset or this program, and you can figure out the amount of money that you're going to allocate for this job because you're doing it based on a defined frequency. 00:18:39.149 --> 00:18:45.149 And then you can order ahead of time so that you have that stock level when you actually do need the, you know, that item, right? 00:18:45.470 --> 00:19:00.109 I think you're you're still going like that, that setup you would do initially so that the people that are purchasing it also understand that, okay, the reason why we need this many is because historically we've used, you know, eight, eight, nine, ten of these things, right? 00:19:00.269 --> 00:19:12.750 And so you don't need as much manual manipulation because the the data you know that you're you're going to be seeing is for this transaction, we're expecting to spend this amount of money on these amount of items. 00:19:12.990 --> 00:19:19.789 I think it's very hard to do that same line of thinking when you're trying to do resource allocation, right? 00:19:19.950 --> 00:19:21.069 Then this is the whole thing. 00:19:21.149 --> 00:19:22.509 So how good are your projections? 00:19:22.589 --> 00:19:24.589 It's kind of what are your projections, right? 00:19:24.669 --> 00:19:34.029 Because again, like I've said this before, Sally's time is not worth the same as Bob's because Sally's an A player in terms of how she does her work, right? 00:19:34.109 --> 00:19:42.589 So how are you, you know, no matter what you put in, no matter even if even if your systems are connected, there's still this level of uncertainty around what does this actually mean? 00:19:42.750 --> 00:19:44.349 Do I hire more FTEs? 00:19:44.509 --> 00:19:46.509 Do I hire temporary staff, right? 00:19:46.669 --> 00:19:53.149 Because you you have to really take a look at a lot of things, like what is the bandwidth of said person? 00:19:53.309 --> 00:19:55.710 You know, what is their capacity to do this type of work? 00:19:55.869 --> 00:20:01.069 So it gets a little bit more nuanced when you try to look at these edge cases. 00:20:01.230 --> 00:20:12.189 But I think where you have situations where it's transaction and you know the defined amount of material that you're going to use for a certain activity, there is no reason you should be going into a spreadsheet reconciling things like that. 00:20:12.269 --> 00:20:13.230 Doesn't make any sense. 00:20:13.470 --> 00:20:18.750 Like you know how many, you're not going to use a hundred gaskets for a job

that requires 10. 00:20:18.909 --> 00:20:22.429 And if you are, then obviously you would flag that in your system, right? 00:20:22.589 --> 00:20:30.909 And so for like a facilities group, when you before you go do a work order, what usually happens is you have a kit of parts. 00:20:31.069 --> 00:21:32.259 Within the kit, there's a it's a receipt, basically, it says like X number of items, and you know this is a quantity, and then within the quantity, there's a cost. 00:21:32.339 --> 00:21:36.979 And so you can estimate the amount of cost and then the amount of labor that you would need to actually do the job. 00:21:37.059 --> 00:21:40.339 And then based on the frequency, you have a defined amount you're going to spend every year. 00:21:40.499 --> 00:21:49.459 And that would go back to finance to forecast, okay, your facility is this large, you have X number of jobs, X number of parts, and this is what we're expecting to spend. 00:21:49.699 --> 00:21:59.299 When you go over that or you go under it, then you start to dig into the details of like, okay, why are we like what are these non-routine activities that are coming up that are jacking up our spending? 00:21:59.539 --> 00:22:12.419 When you're trying to staff projects, much more complicated because when you bring in somebody, you don't know what, well, you'd hope to know what their capabilities are in terms of how you know their role impacts certain timelines. 00:22:12.579 --> 00:22:20.659 But then you're there are unexpected things that come up when you do have people come into the project that are dragging the timeline, right? 00:22:20.819 --> 00:22:24.339 So it's it's not it's it's nuanced, right? 00:22:24.419 --> 00:22:26.899 It's the the the end, it's not black and white. 00:22:27.219 --> 00:22:28.339 Yeah, no, no, no. 00:22:28.579 --> 00:22:32.179 You you bring up a I mean let's let's talk about that for a second. 00:22:32.259 --> 00:22:37.539 Uh you know, I I think there's a few issues that we've been sort of dabbling into. 00:22:37.699 --> 00:22:44.179 Um I do want to go back into sort of the space in between that nobody really owns and what that means. 00:22:44.339 --> 00:22:46.499 Uh, you know, we're talking about two separate lenses. 00:22:46.659 --> 00:22:51.699 You know, one is a small company, drug development, and I'll I'll give you this sort of example here. 00:22:51.939 --> 00:22:59.059 30-person biotech runs on ELNs, a couple spreadsheets, they have a CRO portal, and they use Slack. 00:22:59.619 --> 00:23:05.939 Integration comes out as a scientist who remembers where things live. 00:23:06.019 --> 00:23:06.979 Um, and that works. 00:23:07.139 --> 00:23:14.019 That type of stuff works at a small organization because you have those quick touch points essentially with everyone at the company. 00:23:14.179 --> 00:23:15.699 But when does that fail? 00:23:16.019 --> 00:23:24.259 When they go on PTO or the raw data from a CDMO never makes it back into your system. 00:23:24.739 --> 00:23:29.619 You don't actually have a way to sort of thread that into your organization. 00:23:29.939 --> 00:23:35.219 So, you know, the the risk that we're talking about here is more of like future risk. 00:23:35.539 --> 00:23:50.739 Because when you're small, these blips in your in the foundations of your work and the fragmentation of your data, they don't hurt that bad because you don't have such large swaths of data that are coming in in a business in a company that's so small. 00:23:50.979 --> 00:23:54.659 Unless you are 90% outsourced, then yeah, you might have a lot of information. 00:23:55.299 --> 00:24:08.739 Coming externally, that you need to you need to essentially make sure that they are able to integrate into how your data is formatted, how you're going to be able to get the reads that you need in order to make the the right decisions. 00:24:08.979 --> 00:24:26.339 Versus a mature company, these facilities and manufacturing spaces, we have a commercial stage organization running on CMMS, has LIMS, MES, QMS, ERP, each fantastic system, each owned by different functions. 00:24:26.579 --> 00:24:35.139 No one agrees on the source of truth, meaning that maintenance, quality, and production reconcile conflicting records before anybody can act. 00:24:35.539 --> 00:24:50.419 And so this becomes sort of that ownership problem of everyone owns their system, but not a single person is empowered to own the seams between each of those systems. 00:24:50.739 --> 00:24:58.419 So now that fragmentation becomes a compliance or an audit readiness exposure to that business. 00:24:58.659 --> 00:25:08.499 So we have in a smaller organization, we're sort of trying to get ahead of that future risk as the data scales, as the business scales. 00:25:08.659 --> 00:25:26.899 And when we see those very finite ownership across different segments in a manufacturing facility, when there's no one there that owns that threading of the information, it becomes a risk from a compliance and an audit readiness standpoint. 00:25:27.539 --> 00:25:38.659 So two different systems that are or two different sort of lenses that have a different issue stemming from the same fragmentation. 00:25:38.899 --> 00:25:39.059 Yeah. 00:25:39.139 --> 00:25:46.899 And that's that's a like, so what you brought up is more, I think like in the bigger picture of things, like for like a facility, you'll have these different departments. 00:25:46.979 --> 00:25:50.659 Obviously, they're responsible for different uh parts of the operation. 00:25:50.819 --> 00:25:53.699 And then usually there's usually like a site head. 00:25:53.859 --> 00:25:57.299 This is what we refer to as the person who's responsible for the entire thing. 00:25:57.459 --> 00:26:01.459 And then, you know, there are certain things that the site head is responsible for. 00:26:01.619 --> 00:26:04.739 Obviously, it's going to be the output of the facility itself. 00:26:04.899 --> 00:26:11.379 Like, are you dispositioning drug

product at a specific rate and like what you're spending to achieve that? 00:26:11.539 --> 00:26:20.099 If you're having any deviations related to your operations, how much money, how much resources are you spending on reconciling or resolving some of those deviations? 00:26:20.339 --> 00:26:27.219 Obviously, with the perfect scenario, is you have these golden batches, nothing goes wrong, everything goes right, no issues, right? 00:26:27.379 --> 00:26:30.339 But that's not the reality of manufacturing. 00:26:30.419 --> 00:26:43.379 There's going to be problems, there's going to be issues coming up, and you'd want to minimize that as much as possible through whatever means is within the compliance and how the equipment is operating and things like that. 00:26:43.699 --> 00:26:48.819 And so you're you're right that the the data in these systems are often not connected. 00:26:48.899 --> 00:26:57.779 So like the main like the system that you're using to run the equipment, like that will tell you the utilization of the equipment and alarms and things like that. 00:26:57.939 --> 00:27:01.059 Whereas on the maintenance side, it doesn't even talk to that one. 00:27:01.219 --> 00:27:06.339 It it tells you, okay, these are the amount of routine work that we have done. 00:27:06.419 --> 00:27:07.779 This is non-routine work. 00:27:08.019 --> 00:27:14.099 But then you have to take a look at both of those things and go, okay, well, what like how are they related to each other, right? 00:27:14.259 --> 00:27:25.299 Like, okay, we're seeing a lot of issues with the uh alarms and there's lower utilization, but is that caused by be like some of these maintenance issues that we're seeing? 00:27:25.539 --> 00:27:27.219 Or is it the opposite, right? 00:27:27.459 --> 00:27:37.219 Where, okay, they were we clearly have people that are not very good at at troubleshooting these things, and now we're having low low utilization, right? 00:27:37.379 --> 00:27:41.299 You gotta have to figure out like what is it that's who's responsible for those? 00:27:41.459 --> 00:27:58.499 Who's responsible to sort of investigate those things that ultimately when we talk about any of these things, they slow down the productivity, they slow down your output, and they just create these stalls in your work where you know you get momentum and then you stop, you get momentum and then you stop. 00:27:58.579 --> 00:28:01.299 So who's responsible in in in this situation? 00:28:01.459 --> 00:28:03.859 Is this that site head that you were talking about? 00:28:04.179 --> 00:28:14.339 So site head, and then usually if they how depending on how mature your organization is, you should have an opex group that does look at these things, right? 00:28:14.499 --> 00:28:24.739 That looks at how uh not only productivity, but also from a financial point of view, you know, what are the what is the bottom line for the the actual site itself, right? 00:28:24.899 --> 00:28:40.259 You're looking at overhead, you're

looking at um capital expenses, operating expenses, and just basically looking at the balance sheet of this of the site and trying to figure out like where what are things not comparable to other similar sites that are doing the exact same thing? 00:28:40.979 --> 00:28:48.739 Usually there's an OpEx group that will look into that from that lens, but obviously there's stuff that you opEx can be applied to manufacturing specifically. 00:28:48.899 --> 00:28:54.419 You know, when you're moving from you know product from one area to the other, it could be applied to maintenance. 00:28:54.499 --> 00:28:58.899 Like, how are we deciding what items to maintain at what frequency? 00:28:59.059 --> 00:29:00.499 Why are we doing these things, right? 00:29:00.579 --> 00:29:07.619 So you start to there's many ways where you could I don't want to say plant the opex group, but the focus, right? 00:29:07.699 --> 00:29:21.939 You have to decide where you're going to focus these efforts in because it's I've seen models where like you have an OpEx person in each of these groups, but the problem is the way that they go about resolving these things is not consistent. 00:29:22.019 --> 00:29:25.699 And so they're driven by different incentives, and then that doesn't work out. 00:29:25.859 --> 00:29:32.659 You really have to have a it's it's almost a separate function where like you have an opex function that looks at the whole site. 00:29:33.459 --> 00:29:40.019 And with working with the site head and the rest of your site leadership team, okay, where do we feel that we're struggling the most? 00:29:40.259 --> 00:29:43.779 Because to your point before, like these things are not contained, right? 00:29:43.859 --> 00:29:46.019 And it's not like one department suffers and nobody else suffers. 00:29:46.179 --> 00:29:47.619 Like everybody is is kind of dealing with it. 00:29:47.779 --> 00:29:49.779 This is taxing the entire workflow, right? 00:29:50.099 --> 00:30:06.739 However, however, minimal this is creating a tax, there's a there's a an actual cost on the amount of time that people are taking to recognize that there is some disconnection, and then finding that person or finding that group of people. 00:30:06.899 --> 00:30:11.539 I think it's fantastic that there's you know these mature organizations that have OpEx coordinators. 00:30:11.619 --> 00:30:17.379 And I've seen some of those jobs floating around, you know, LinkedIn's always saying, hey, you know, look at this job, look at that job. 00:30:17.459 --> 00:30:18.179 So I've seen those. 00:30:18.259 --> 00:30:22.339 But yeah, that is definitely a marker of more mature businesses. 00:30:22.659 --> 00:30:36.899 So there's there's there's that model where you have a basically a department that kind of you assign and you focus on certain initiatives across the company that will improve productivity, among other things, you know, the operations of your company. 00:30:37.059 --> 00:30:45.059 The other model is what they do, and I've seen this also, is they basically have a bunch of people that are very well trained in these methods on how you would do that. 00:30:45.219 --> 00:30:54.579 And so they hold these training programs and they train a bunch of people across all these groups and incentivize them to, hey, you can get your yellow belt or your green belt by doing a project. 00:30:54.819 --> 00:30:55.619 I've seen that. 00:30:55.859 --> 00:31:03.539 And so what happens is people take these trainings, take these programs, and then they do a project and they say, This is great. 00:31:03.619 --> 00:31:05.459 Now I can go for a promotion somewhere. 00:31:05.619 --> 00:31:14.099 And the the incentives are not there for that to be like a sustainable uh way of really implementing operational excellence at the company. 00:31:14.339 --> 00:31:24.419 And so the other method is obviously you bring in external help and they take a look, consultants like us or other groups will come in and actually focus on those things, right? 00:31:24.579 --> 00:31:40.979 And depending on obviously the size of your company and where you are, you have to determine does my team actually have the capability, the capacity, and the uh I forget what the other C is, but basically, do we have enough time for our team to focus on this or do we need help, right? 00:31:41.139 --> 00:31:49.699 So I think if if you're not thinking about that, there's probably all these gaps that are just ballooning and they just only get worse because these things never get better. 00:31:50.099 --> 00:31:50.419 Yeah. 00:31:50.659 --> 00:32:06.259 And and you know, when you see those things that are ballooning, oftentimes you'll see people that say, you know, not my clown, not my circus, not my horse, not my rodeo, like kind of thing, or just like I've had people tell me straight to my face when I just had a very simple question. 00:32:06.419 --> 00:32:07.939 That's not my job. 00:32:08.419 --> 00:32:09.699 That wasn't my question. 00:32:09.859 --> 00:32:12.339 If you know the answer, I'm looking for the answer. 00:32:12.419 --> 00:32:13.939 I don't care if it's your job or not. 00:32:14.019 --> 00:32:15.859 I'm asking if you have this piece of knowledge. 00:32:16.019 --> 00:32:23.539 I mean, this is something that I experienced, you know, when in the early days where that's where these side quests came in. 00:32:23.699 --> 00:32:31.139 You know, no single function owns this space in between systems, especially when they cross functional boundaries. 00:32:31.459 --> 00:32:35.299 These are things that cannot be really solved inside of business operations. 00:32:35.459 --> 00:32:47.939 The data flow is really a governance question that needs to be answered by unifying that structure, creating that thread that goes all the way from, I don't care if it's HR where you're you know threading. 00:32:48.579 --> 00:33:02.179 For me, it reminds me of this idea of like, you know, uh six degrees of separation or you know, the

the from Kevin Bacon, whatever that separation is, that you can pinpoint people and create those connections. 00:33:02.339 --> 00:33:06.339 That's the way that I look at a system within an organization, even HR. 00:33:06.579 --> 00:33:31.539 HR is probably trying to figure out where are these people positioning themselves in the organization, not necessarily what are they doing, but what are they supposed to be working on, so that you can sort of say, okay, this person is in this department working on this project, specifically working on these types of activities, as this is part of their role, and sort of how that data goes back to feed, you know, resource allocation. 00:33:31.859 --> 00:33:47.939 That's one of the biggest issues that people have is how much money, how many people, how much time is it going to take to execute on a project if we start here, if we start here, if we start here. 00:33:48.179 --> 00:33:56.019 That question goes in virtually every organization that I can think of that has a team more than like 20 or 30. 00:33:56.339 --> 00:34:09.940 And what happens is when you have a weak data structure, there's this constant translation between these pillars that we talk about in Predictably Broken, from research to portfolio, to the portfolio to governance and decision making. 00:34:10.019 --> 00:34:15.699 And when that data cannot move without a human relabeling it, that insight starts to get diminished. 00:34:15.860 --> 00:34:20.340 And every decision starts with a reconciliation instead of a judgment call. 00:34:20.500 --> 00:34:43.139 And so that's a lot of what our 4.1 assessment is looking into is measuring that system-to-system connectivity, the manual data burden that we find often in reporting to management and leadership, ensuring that we have a source of truth, the data to decision flow is there, and data integrity. 00:34:43.300 --> 00:34:47.380 I mean, there's I think we've talked about this before, where we had this experience. 00:34:47.539 --> 00:34:56.179 I had this experience where I um went into an organization and they were using a variety of applications. 00:34:56.340 --> 00:35:06.260 And one of them in particular, I kept getting ping-ponged when I was trying to understand what is the current timeline we are working from in relation to this project. 00:35:06.820 --> 00:35:09.860 I heard from one person, you need to go into JIRA. 00:35:10.020 --> 00:35:11.060 That's where the whole thing is. 00:35:11.140 --> 00:35:14.660 And when I went into JIRA, I saw that nothing was being updated. 00:35:14.900 --> 00:35:28.260 When we discussed this issue with the person whose name was listed in the system as having updated this information, they told us I was only told to update the data. 00:35:28.500 --> 00:35:30.020 So I updated the data. 00:35:30.180 --> 00:35:39.940 So when you looked, every activity had no active status and was dated about two, about three months prior to me arriving. 00:35:40.100 --> 00:35:45.300 And then as I brought that forth, and I said, okay, well, where is the timeline that you're working from? 00:35:45.460 --> 00:35:47.220 Oh, it's in this system. 00:35:47.620 --> 00:35:51.780 So this group didn't even couldn't even agree on the source of truth. 00:35:52.020 --> 00:36:02.340 And this was just and believe me when I tell you, they had money coming in, investors coming in, funding rounds coming in. 00:36:02.900 --> 00:36:10.500 And there was no way to actually take a look at the portfolio and say, where are you with these projects? 00:36:10.740 --> 00:36:13.460 A little bit of research that I found, and this is and this is crazy. 00:36:13.540 --> 00:36:15.780 This is all within the last five years. 00:36:15.940 --> 00:36:22.740 Um, you know, Mule Soft, uh, HBR, and Forrester, 2022 report from HBR. 00:36:23.780 --> 00:36:30.020 12, about 1,200 app switches per worker per day. 00:36:30.820 --> 00:36:31.780 1,200. 00:36:31.940 --> 00:36:34.260 Now that's not 1,200 applications. 00:36:34.580 --> 00:36:44.500 That's going into Outlook, going into PowerPoint, going into Excel, going into Smartsheet, going into Notion, going into Monday, going into Trello, going into CMMS, et cetera, et cetera. 00:36:44.740 --> 00:36:47.220 1,200 app switches per day. 00:36:47.300 --> 00:36:54.260 And they calculated roughly that burns around four hours per week jumping back and forth in and out of systems. 00:36:55.380 --> 00:37:01.940 MuleSoft, this was more of a full industry outlook at people that are using digital systems. 00:37:02.740 --> 00:37:08.020 27% of enterprise applications are actually integrated. 00:37:08.340 --> 00:37:12.660 And companies have, on average, a thousand applications that they're running. 00:37:13.300 --> 00:37:34.100 And it doesn't, and it sounds kind of crazy, but when you start to look at, well, there's a Slack, there's a Teams, there's a Zoom, there's uh there's a there's a ELN, there's uh CMMS, there's LIMS, there's a project management software, there is a financial software, there's two, there's two legal for contracts, etc. 00:37:34.420 --> 00:37:38.020 They all have different purposes, they do, and they all have their own place. 00:37:38.260 --> 00:37:39.060 Absolutely. 00:37:39.220 --> 00:37:45.700 This fragmentation begins to grow and becomes more difficult and more taxing for people throughout their day-to-day. 00:37:45.860 --> 00:38:01.940 And then this one last piece that I wanted to that really hits home for us is Accenture looked at uh this in 2024 and found that only 19% of biopharma RD organizations call their systems fully digital or connected. 00:38:02.180 --> 00:38:09.540 19% and if you think about where the bulk of your money goes into, it's gonna be in that research and development phase. 00:38:09.780 --> 00:38:23.540 It's gonna be right in there where you're trying to find the hits that can land a licensing agreement, selling off the asset, going into clinical trials, something that can generate revenue back

to the organization. 00:38:24.580 --> 00:38:27.700 And there's a cost, and the cost is real. 00:38:28.500 --> 00:38:30.820 It will tax every part of this workflow. 00:38:30.980 --> 00:38:38.660 So Yeah, I think there's a classic like 80-20 um, you know, numbers that you you uh just told us about. 00:38:38.820 --> 00:39:02.020 And it seems like the there's only a minority of actual applications that are connected, and even with this how things are fragmented, you think about like how that impacts productivity overall, and even if you move the number five, ten percent, like what would that do to an entire company or industry? 00:39:02.180 --> 00:39:20.980 Just like if we just didn't have as many applications and if things were connected, it makes you think like I'm like I yeah, I probably do a lot of switching as well because it depends on the the meeting that I'm in and like what they're looking for, and then I gotta switch back and forth, and okay, now I have to go get data and I have to jump into something else. 00:39:21.140 --> 00:39:43.700 And it's um it's a lot for anybody to kind of figure out, and and you're always staring at the screen, and I I can see why people get um overwhelmed by by all of these um applications, and and it gets even more annoying when something gets stuck or something's not there, and that you gotta switch over to Dabigate and you gotta email somebody, and it just It really is. 00:39:43.860 --> 00:40:12.980 I think it puts us all in a position, you know, as professionals in this industry and in other industries that that are using you know swaths of of digital applications and tools that we have to take our ownership of our work, number one, but number two, be vigilant in understanding what is happening before the work gets to you and what is happening with your work when it moves forward. 00:40:13.220 --> 00:40:17.780 I think there's too few of us that really try to bridge those connections. 00:40:18.100 --> 00:40:23.620 And the way that I look at this is, you know, because here's here's the conversation that happens. 00:40:23.860 --> 00:40:30.900 Hey, we want to bring in all of our systems and select a few that are really driving this organization. 00:40:31.460 --> 00:40:32.340 Who wins? 00:40:33.140 --> 00:40:34.740 Is it the leadership? 00:40:35.140 --> 00:40:40.420 Whoever has the best leadership sponsor for their particular system? 00:40:41.140 --> 00:40:43.940 Is it somebody who talks the loudest? 00:40:44.180 --> 00:40:50.980 Is it the one that somebody can justify the best because they have the the best language for what they're justifying? 00:40:51.380 --> 00:40:58.660 Yes, we all need these things, but there are other systems and other ways to manage a lot of the stuff that we have. 00:40:58.820 --> 00:41:01.460 So I think in some cases, you don't really have an option. 00:41:01.540 --> 00:41:11.700 If you have something like, you know, financial systems and and legal systems, I can understand why those are

sort of like Fort Knox and we need this type of setup. 00:41:11.780 --> 00:41:26.020 Uh and then as you talk about these other spaces of like how you're managing projects or you know, managing the the sort of the day-to-day pieces of manufacturing, those might be a little bit more uh loose. 00:41:26.180 --> 00:41:31.540 You can sort of choose different faces to perform the same duty, right? 00:41:32.580 --> 00:41:35.700 But then how do those things connect back to the greater picture? 00:41:35.940 --> 00:41:45.860 Because the question at the top is not gonna be what is give me the data about this specific thing from this specific function. 00:41:46.100 --> 00:41:47.940 They're gonna be looking for insights. 00:41:48.100 --> 00:41:48.980 Are we in trouble? 00:41:49.220 --> 00:41:52.580 Where is the nearest trouble right now in the business? 00:41:53.220 --> 00:41:54.580 Where are we flourishing? 00:41:55.300 --> 00:42:01.860 What is different about that than about this one, than about this project or function? 00:42:02.580 --> 00:42:09.620 They're gonna start to look at the health of the organization from the resource perspective, the money, the people, the time. 00:42:10.500 --> 00:42:18.820 And if we keep those pieces, you know, this is what I've discussed before and what's present in the book related to the biopharma Nexus. 00:42:18.900 --> 00:42:22.900 These are the pieces that leadership is trying to put together. 00:42:23.540 --> 00:42:39.220 That when our systems are separate and then we try to come together to bring an update, we have you know, a risk in this one system on slide seven, and we have resolutions to these same things somewhere on slide 15. 00:42:40.180 --> 00:42:57.540 Well, we need to pull these things into a better light so that people can actually grasp what these things are doing in our business, how they're slowing things down, how we're not these are the these are those quiet handoffs that they don't make their way into a timeline. 00:42:57.620 --> 00:43:00.980 It usually comes as like a slack message or an email. 00:43:01.220 --> 00:43:02.340 Hey, I sent this to you. 00:43:02.660 --> 00:43:04.340 Oh man, I totally missed that. 00:43:04.500 --> 00:43:05.620 And then it continues. 00:43:05.860 --> 00:43:10.020 No one else knows that that happened, except those two people that brought it up. 00:43:10.500 --> 00:43:14.500 So now you have this big gap in your timeline that has never been recorded. 00:43:14.660 --> 00:43:15.620 No one knows what happened. 00:43:15.700 --> 00:43:17.380 You'll just say, Yeah, it just took longer. 00:43:17.620 --> 00:43:26.740 These are those quiet chat, these quiet issues that happen with fragmented tools, with fragmented flow of information, of data. 00:43:27.380 --> 00:43:33.220 And those are the things that our assessment 4.1 is set out to help uncover. 00:43:33.540 --> 00:43:36.180 How does that look like at your organization? 00:43:36.820 --> 00:43:50.900 Is everything connected the way that you can pull out insights into the health of the operations, that you can have enough data to project and have tighter projections like we talked about before? 00:43:51.220 --> 00:43:52.580 I think oftentimes we don't. 00:43:52.740 --> 00:44:07.540 It's important to recognize the utility of creating the thread that builds the fabric of your organization in a way that allows you to make the right decision at the right time. 00:44:07.780 --> 00:44:08.020 Yeah. 00:44:08.180 --> 00:44:21.300 I think uh the the assessment allows uh at least it it's an attempt to enable these organizations and teams to establish a criteria to you know where are we gonna focus, and then what is the prioritization based on the time, money, and resources question, right? 00:44:21.380 --> 00:44:29.060 Because that that that looks different depending on like how big or small you are and you know where you are in in the business cycle, too. 00:44:29.220 --> 00:44:48.740 So it's uh it's I think a lot of companies struggle with this, and it's it's it's this thing that you have to be aware of, or else it really spirals out of control, and then you get to a point where people upset is probably like very under underselling it there. 00:44:49.140 --> 00:45:00.740 Underselling it there, but uh there's there's a real cost to your business, like in terms of thinking about culture and all these things intangibles that you can't even put a value on. 00:45:01.700 --> 00:45:02.980 And we see this all the time. 00:45:03.140 --> 00:45:14.180 I mean, there's there's one here, again, another another report from Neulsoft, where 86% of IT leaders say that the unintegrated tools are adding more complex more complexity than value. 00:45:14.340 --> 00:45:21.300 And the teams are burning about 30% of their technical time hand building integrations. 00:45:21.460 --> 00:45:26.260 I mean, we have to think about that because we want to continue to bring in the newest software, the greatest software. 00:45:26.420 --> 00:45:32.180 We need to find that balance that allows us to retire things and allows us to bring in something new. 00:45:32.340 --> 00:45:45.620 And this is so critical put the support that it requires to have a software, an application actually flourish in your organization. 00:45:46.260 --> 00:45:49.380 Talk to the right people, look at the pros and cons. 00:45:49.620 --> 00:45:54.820 Don't just look at it from one lens, look at it from the stakeholder lens and make sure. 00:45:55.380 --> 00:46:10.100 Sure, there is support for the training and a consistent, I mean, let's be honest, organizations are not immune from people moving in and out of the business, from attrition. 00:46:10.260 --> 00:46:16.100 Like we have to really talk about people coming in, people leaving, coming in, people leaving. 00:46:16.260 --> 00:46:33.300 So if you have these systems that are built within and integrated within your organization that are the requirements for how someone performs their duty, it is

also your responsibility to make sure they have the support that puts them in line for being successful. 00:46:33.540 --> 00:46:41.940 So, Lawrence, today is a very, I would say a somber day in some aspects of it. 00:46:42.260 --> 00:46:49.140 So I I guess do you this is we talked about this at the beginning of our episode that today we had some big news to share. 00:46:49.220 --> 00:46:50.500 Would would you like to share that? 00:46:50.660 --> 00:47:12.500 Yeah, I'm uh at the end of September, I'll be I'll be stepping away from the company and be taking some sort of a sabbatical as I um am approaching the late the second half of my 30s and trying to figure out uh just life and career and everything else that comes along with maturing. 00:47:13.220 --> 00:47:13.860 Yeah. 00:47:14.820 --> 00:47:24.660 So Lawrence is going to be stepping away, and so this is uh our last podcast episode right now that we have planned together. 00:47:24.820 --> 00:47:27.700 Uh next week is actually gonna be a special episode. 00:47:27.860 --> 00:47:30.740 We're gonna have a special farewell episode for Lawrence. 00:47:30.900 --> 00:47:35.380 Um, and he's gonna come here on site, Sigma Lab Consulting Offices. 00:47:35.540 --> 00:48:04.660 I say office is actually just my office, but we have a nice space over there where we're gonna sit down and have a conversation and just reflect and take that time to reflect on you know what this experience has meant to him, you know, thing lessons he's gonna carry, um, perhaps some feedback for me as a co-founder or uh I never looked at myself as being Lawrence's manager, but hell, I will take any any thoughts, you know, from that end as well. 00:48:05.620 --> 00:48:08.260 But it's been an absolute pleasure. 00:48:08.420 --> 00:48:25.220 And I think the one thing that I cannot speak to enough is you chose and you constantly choose every day to stand your ground on things that you understand, that you know, that you're positioning, and I think that has only made our conversations better. 00:48:25.380 --> 00:48:47.460 I think that has made our business better for us to have to really deliver on the data, the information, the resources behind the things that we're promising, behind the things that we are uh holding on to from the business aspect, from the podcast, how we position ourselves. 00:48:47.620 --> 00:49:04.500 It's never been uh you've never been a yes person, and I can't tell you how much I appreciate that, that I had somebody uh who respectfully felt comfortable pushing against or providing another perspective as we built this business. 00:49:04.740 --> 00:49:11.460 So I think I can, you know, saying this along, you know, I think all of the other listeners can agree with me. 00:49:11.620 --> 00:49:20.180 You're gonna be a missed voice here, you know, at lean by design amongst you know, Sigma Lab Consulting, but especially here with Lean by Design and Willa. 00:49:20.900 --> 00:49:34.900 So we still have you for a couple more weeks, and I'm excited to sit down and and reflect on this time, but you are very appreciated in the work that you've done uh and what you what you brought to this podcast, the perspective, the voice. 00:49:35.220 --> 00:49:40.980 So for that, I thank you, and uh, you will surely be missed as a member of this podcast. 00:49:41.140 --> 00:49:47.620 And for for all those out there listening, we will have our farewell episode next week, and then we'll follow up. 00:49:47.780 --> 00:50:14.340 I'll bring this up again next in the next episode, but we will have a couple of uh sort of a mini-series where I'm gonna go into my new book, Predictably Broken, and we're gonna talk about a few themes in there and read a couple of passages to give you a feel for the type of book that it is, and uh end our season three with with that series before coming back in season four. 00:50:14.500 --> 00:50:21.860 We're gonna come back probably in 2027 and have a whole new take on lean by design. 00:50:22.500 --> 00:50:25.780 And so, Lawrence, thank you. 00:50:26.740 --> 00:50:28.420 Yeah, no, it's been uh it's been fun. 00:50:28.580 --> 00:50:29.700 We'll save that for the next episode. 00:50:29.860 --> 00:50:32.100 So thank you guys so much for spending time with us today. 00:50:32.260 --> 00:50:36.020 We truly appreciate you being part of the lean by design community. 00:50:36.260 --> 00:50:56.100 If this conversation resonated with you, we invite you to check out a new book, as I mentioned, that just launched uh Predictably Broken, where it take a candid perspective similar to one that we that we take here on the patterns of operational friction that quietly slow and degrade team progress and what to do about them. 00:50:56.260 --> 00:51:00.340 So if you're ready to take the next step, you can explore our operational risk assessments. 00:51:00.500 --> 00:51:19.140 You can go to Sigmalab Consulting.comslash check and perform a risk check assessment that we will receive directly and can point you in the direction of the right assessment to help uncover these patterns that are showing up that might be quietly eroding the progress of your team. 00:51:19.380 --> 00:51:28.340 So don't forget to follow us on Instagram at SciGuy underscore insights, S-C-I-G-U-Y underscore insights. 00:51:28.500 --> 00:51:36.740 And you can now watch the podcast on YouTube so you can see Lawrence and myself for however long we have at Lean by Design Podcast. 00:51:36.900 --> 00:51:38.740 All the links are in the show notes. 00:51:38.980 --> 00:51:40.020 We'll see you next time.