Culturing Relevant Data at Johnson & Johnson

Written by Evan Schuman
November 2nd, 2005

When the CIO of a $3 billion unit of Johnson & Johnson decided to make knowledge management a priority, he knew he was in for a classic corporate battle of the old ways versus the new. In Ethicon CIO Zackarie Lemelle’s case, the old ways won.

While managing the IT needs of some 8,300 employees with a barely $90 million technology budget, Lemelle knew that his having a 118-year-old $47 billion corporate parent in J&J was both a blessing and a curse.

It’s a blessing in the vastness of people and resources that his parent could offer him, but a curse in that mining such an ocean of data is expensive, time-consuming and difficult.

“The good thing about Johnson & Johnson is that, no matter the problem, someone somewhere here has already done it,” Lemelle said. “It’s just a matter of finding it and stealing it shamelessly.”

The classroom version of knowledge management today typically envisions a huge data warehouse where all files, memos and design plans are all stored and analyzed.

All employees, contractors and freelancers are to write debriefing memos on every project and pour it into that database so other employees can benefit from the knowledge.

But like so many technology plans that sound great summarized on a whiteboard, the pharmaceutical giant found it lacking when implemented in the real world of deadlines, P&Ls and overlong TODO lists.

“We used to have a database system called Knowledge Network. It was all about sharing ideas and leveraging concepts” and was similar in scope to those whiteboard concepts, Lemelle said. “It lasted about five years before it died a very slow death on the vine.”

So if the new ways lost to the old ways, what won? The old ways, with the new ways playing a deferential role in the background.

J&J does have a mega-database, but it’s limited to documents and pieces of information that were already in electronic form.

“We do now have a database of all the existing databases that exist within all the different J&J companies,” Lemelle said, which is not trivial given that there are more than 190 J&J companies within the pharmaceutical empire.

“Finding out who has done what today is easier than it has ever been,” the CIO said.

But instead of forcing employees and contractors to meticulously log every change and every discussion, the system listens in at places where those conversations naturally happen.

“We use a series of databases that capture methodologies. It listens in on forums where there is knowledge-sharing all the time and where the knowledge-sharing happens in realtime,” Lemelle said.

“It’s all about the various forums we already have. For example, we have the Medical Devices and Diagnostics [group] that looks at the identification of applications for us to collaborate on. We have actual teams that have formed from these opportunities.”

Sometimes those discussions are about applications, sometimes about business issues and often about personnel.

“You are already providing information to associates in your organizations. What countries should we launch our products in? What countries would be most receptive to our products? There’s a lot of work involved in looking in many different databases. Is there a resource, a person who has knowledge of the local authority’s processes?” Lemelle asked.

“Those things now happen through a myriad of different people. I want to be able to simplify that and to be able to ask questions, to search all different databases that have those answers at once.”

Matt Brown, a senior analyst with Forrester Research who tracks business intelligence issues, including knowledge management, said the Ethicon experience is not atypical.

“It’s a very common thing for a large organization to say it wants one big repository. But the problem with that approach is that it ignores things like who’s contributing what and are they willingly contributing. It waters down the information,” Brown said.

“With the collaborative approach, you see a lot more cooperation and adoption among employees because it’s being deployed on a more local basis. You see more success in the companies that aren’t IP-centric. There’s more success with the specific business unit and collaboration approach.”

Lemelle’s informational challenges are not only about collecting, analyzing and accessing data from people and programs.

Recent portable hardware changes?such as PDAs, cell phones, pagers and some desktops?have given J&J employees the advantages of “information anywhere anytime” while leaving the associated data headaches to Lemelle’s team.

The Ethicon network today is based on a Microsoft Windows NT and Citrix environment, with large doses of Oracle databases and Cognos for data mining.

Lemelle’s top priority (what he dubs his “golden asset”) is that he wants to own the intersections between the major applications that J&J uses.

Deploying or tweaking those apps is a fine job for systems integrators, he said, but making them all share information so the company can have the much-desired single-view of the customer.

Enterprise app consolidation today has delivered a handful full of software companies “that can make 60 to 75 percent of the applications that your business needs,” Lemelle said, citing SAP, Oracle and Siebel Systems as examples. “But in between is what is interesting because they don’t cover end-to-end processes.”

He offered an example: “Let’s say I want to dollarize one of my customers. We have to link our sales systems?probably Siebel?with budgeting systems, to get the cost of the product versus what you’re selling it for. We need to look at the order to cash system and your customer database because that’s where the ordering takes place. We’re looking for the automation of the capability to link all these processes together.”

This is the only way, Lemelle said, to truly identify and understand a company’s best customers and to tell if the customer’s largest customer by revenue might actually be delivering a very small dollar of profit.

“We need to be able to calculate the value of our customers globally, wherever they happen to be,” he said. “The people who need to access that information to make better decisions, they have to have what they need in whatever format they need.”

Ethicon has dedicated intranets for most major process areas, including sales/marketing, research and technology, and Lemelle wants them to all be more integrated. “I need to get all the information I need within two clicks,” he said.


Comments are closed.


StorefrontBacktalk delivers the latest retail technology news & analysis. Join more than 60,000 retail IT leaders who subscribe to our free weekly email. Sign up today!

Most Recent Comments

Why Did Gonzales Hackers Like European Cards So Much Better?

I am still unclear about the core point here-- why higher value of European cards. Supply and demand, yes, makes sense. But the fact that the cards were chip and pin (EMV) should make them less valuable because that demonstrably reduces the ability to use them fraudulently. Did the author mean that the chip and pin cards could be used in a country where EMV is not implemented--the US--and this mis-match make it easier to us them since the issuing banks may not have as robust anti-fraud controls as non-EMV banks because they assumed EMV would do the fraud prevention for them Read more...
Two possible reasons that I can think of and have seen in the past - 1) Cards issued by European banks when used online cross border don't usually support AVS checks. So, when a European card is used with a billing address that's in the US, an ecom merchant wouldn't necessarily know that the shipping zip code doesn't match the billing code. 2) Also, in offline chip countries the card determines whether or not a transaction is approved, not the issuer. In my experience, European issuers haven't developed the same checks on authorization requests as US issuers. So, these cards might be more valuable because they are more likely to get approved. Read more...
A smart card slot in terminals doesn't mean there is a reader or that the reader is activated. Then, activated reader or not, the U.S. processors don't have apps certified or ready to load into those terminals to accept and process smart card transactions just yet. Don't get your card(t) before the terminal (horse). Read more...
The marketplace does speak. More fraud capacity translates to higher value for the stolen data. Because nearly 100% of all US transactions are authorized online in real time, we have less fraud regardless of whether the card is Magstripe only or chip and PIn. Hence, $10 prices for US cards vs $25 for the European counterparts. Read more...
@David True. The European cards have both an EMV chip AND a mag stripe. Europeans may generally use the chip for their transactions, but the insecure stripe remains vulnerable to skimming, whether it be from a false front on an ATM or a dishonest waiter with a handheld skimmer. If their stripe is skimmed, the track data can still be cloned and used fraudulently in the United States. If European banks only detect fraud from 9-5 GMT, that might explain why American criminals prefer them over American bank issued cards, who have fraud detection in place 24x7. Read more...

Our apologies. Due to legal and security copyright issues, we can't facilitate the printing of Premium Content. If you absolutely need a hard copy, please contact customer service.