Tuesday, February 19, 2013

P&G Follow Up

Hi Greg,

I wanted to follow up with you after meeting with the consultants yesterday.  The key meeting takeaways from my perspective are as follows:
·         Options for improving the paper-based system are limited, there is no solution that allows us to keep the paper-based system while simultaneously cutting down time spent managing data
·         Digital imaging allows for papers to be transferred faster but does nothing to improve the double data entry situation
·         Web-Enabled EDC seems to be the only option for significantly cutting down time spent in the data lock period
o   The double data entry process will be eliminated
o   Data entry and validations become completely automated
o   Human error in regards to data entry becomes less of a threat
o   Data is verified much faster allowing information to become available quicker
o   Data is available for multiple departments and easily accessible through the internet
·         Phase Forward
o   They offer both software and service solutions including maintenance of e-CRF’s
o   Seems to best fit our needs


I stay firm in my initial recommendation to implement an EDC system in place of our current paper based system.   While it may seem risky; I believe it to be the only option to reduce time spent in data lock and get us on the market faster.  We need change in order to stay competitive and gain market share in our industry.  Please let me know your thoughts ASAP so I can provide you with a more detailed launch strategy.

As always, please let me know if you require any further information from myself or from the consultants.

Megan Healey

Tuesday, February 12, 2013

Visio

Hi Greg,
You asked me to do some research on Visio and whether this would be a worthwhile investment for our company.  Our recent transition over to SAP has become a key theme in our discussions.  I believe you will agree with me when I say that the company wasn’t quite as ready as we would have liked when the Go-Live date came around for our SAP implementation.  We were still in the midst of identifying how processes would change and which employees these changes would affect on a day-to-day basis.  We used PowerPoint to create flow charts outlining old vs. new processes as well as updated organizational charts for human resource purposes, these documents became the starting and end points of reference on a daily basis.  After using Visio for less than ten minutes, I see how much time could have been saved using this program as opposed to Microsoft PowerPoint and Excel.
Now that we have made it through the transition, we no longer refer back to these flow charts or organization charts on a consistent basis.  While the functionality and features of Visio could have saved a good amount of time last year, at this point in time I do not see a need for the program.   Our sales, inventory and financial reporting systems already allow for graph and chart output.  These can be customized to our liking both in the software and after exported to Excel or PowerPoint.  HR is now required to use our Intracom and HR portal to update organizational charts therefore eliminating their need for such a program as well.  For nearly $250 per license, I do not see sufficient return on investment.
Please let me know if you do not agree with my analysis or if you would like more detail regarding the features of Visio.  
Thank you,
Megan Healey

Procter & Gamble: EDC



Problem/Issue Statement
·         They currently utilize a paper-based process which requires each site coordinator to transfer updates from patient’s medical records over to CRF binders after each patient visit.  A CRA visits each site on a monthly basis to manually error check the CRF’s to ensure they matched patient records exactly.  Once a CRF page was verified, it would be sent to the Clinical Operations Department for data entry when it would be entered manually into a data base not once but twice to check for errors in data entry.  If there were discrepancies, it would need to be entered a third or forth time until the data was confirmed.  If a “query” was identified, the CRA would be informed and would then work with the investigator site to resolve the error, further delaying the actual verification of data. Once all the CRF pages were verified, the data would become “unblinded” allowing for several departments begin their analysis of the data.
·         As you can see, P&G’s clinical trial process is both very time consuming and labor intensive.  They need to find ways to streamline the process without comprising the accuracy of data.  As noted in the case study; each day the average prescription drug is delayed represents a loss of $1M dollars.
·         Ray D’Alonzo has been tasked to identify ways P&G’s can shorten then length of time spent on clinical trial process while still allowing for accurate data and thorough analysis.

Situation Assessment
After doing his initial research, D’Alonzo determined that the solution to their problem would come with the implementation of EDC.  It looked as if the use of EDC could likely cut the “data lock” period in half while still ensuring accurate data.  While eager to learn more about the EDC process, he was also hesitant as he realized P&G would be one of the first large pharmaceutical companies to adopt this new process.  He wondered why other larger companies had not yet jumped on board; he wondered if he was missing something.   

List of Alternative Courses of Action
D’Alonzo identified three potential solutions to their problem:
·         Improving the paper-based process:  P&G could make small changes to the process such as using express mail and increased staffing to allow for faster data entry and source-data verification
·         Digital Imaging:  Data could be electronically transmitted from the investigator to P&G.  CRFs could be faxed and digitally scanned for data retrieval.  The double entry system would still exist but employees would enter the data using a split screen allowing the document image to be visible during data entry.  All documents which were now stored as images would need to be archived and labeled properly.  The rest of the process would remain unchanged.
·         Web-enabled electronic data capture (EDC): CRF data would be entered into a web-based data collection tool directly by the investigator.  The double-entry data method would be eliminated; potential queries could be addressed and corrected much sooner due to an automated validation process.  This seemed like the only way to truly influence the current process.



Evaluation of Alternatives
·         Improving the paper-based process:  I see no true improvement with this approach.  Both Express Mail and increased staffing will cost P&G more money and will only cut down on the total process by a few days. 
·         Digital Imaging:  Although this approach does allow for a faster transmission of data from investigators to P&G, it does not affect the process in any other way.  Documents which would be stored as images need proper labeling and archiving required more time.  P&G would also need to significantly increase their storage memory in order to support all of the CRF images. 
·         Web-enabled electronic data capture (EDC): This appears to be the only way to actually improve the process and significantly reduce time spent in the data lock period.  Data entry and validation becomes completely automated.  Human error is no longer a factor in data entry ensuring the data remains accurate.  Trial specific validation processes will be put in place allowing queries to be corrected much faster.  Validated data also becomes available for analysis much faster and is more accessible to the multiple departments who utilize it.  After researching several different EDC options and comparing Features/Benefits vs. cost of implementation for each option, D’Alonzo decided Phase Forward would best improve their process.  Not only does Phase Forward offer EDC software, but they also provide services such as maintenance of e-CRF’s and a help desk.

Final Recommendation
For all of the reasons mentioned above, my recommendation will be to move forward with Phase Forward.   Trials which have already begun using the paper-based system should be finished using the paper-based system.  All future trials should utilize Phase Forward.  A formal training system needs to be in place for the P&G employees as well as the investigator sites.  Investigator sites also may need to be provided with computers, internet access and Live Help to ensure they are using the site correctly.  There should be a change management team in place to identify all of the ways the process change will affect employees and their responsibilities. While these costs add up rather quickly, so does $1M for each day P&G delays a prescription drug launch.  P&G paid anywhere from $250-450K per trial.  Even if Phase Forward eliminated only one day from the trial period, it represents $1M worth of sales that P&G would have otherwise lost.

Monday, February 11, 2013

Blogging About Blogging

Hi Greg:  Last week you asked me if our 2013 Communications/Media platform was missing anything and I mentioned the concept of company blogging.  While our current website is user friendly and pretty interactive, we do not provide a place for consumers to be heard.  We know from our experience with certain retailers such as HSN or Amazon.com, that when an item has a large number of high reviews, the product sells exceptionally well.  Why not give all consumers a place to interact with us and with others? I have developed a three-fold plan to integrate blogging into our organization. 
The first aspect of this initiative, and most important, is to develop a blog where our consumers can communicate with us and with others.  The blog should be managed by our PR/Communications team and should feature the following: new product launches and interactive product stories, any big PR stories, events we are hosting/participating in, recipes for our small kitchen appliances, product giveaways, coupons/product rebates, etc.   This blog will help us get our name out there as a company, will help us establish credibility in our new product categories, and will maintain communication directly with our consumers. The initial costs to launch this blog include Domain Name acquisition (which can range anywhere from $50 to +$5000 depending on current owner of the domain) and the layout/theme of the blog (which can range from $100 to  +$1,000).  The reoccurring costs associated with the blog are of course employing someone to maintain it.  Luckily, this could be a great project for one of our PR interns.  How do we get people to our blog?  We can provide the link to our blog through our Company Website, our Facebook page and through all of our marketing mailing lists.  We should feature several product giveaways and sweepstakes in the first few months to help boost our traffic.  Another idea is to ask readers to provide 5 peoples email addresses in exchange for a coupon or rebate. Besides for increased PR and media, will we ever see a true return on our investment? Yes! I suggest that our blog be linked to a site where the blog subscriber can buy our products directly from us rather then sending them to their nearest retailer.  Our profit margin on sales via the blog will be doubled vs. selling to our retailers.   The only disadvantage I see is that is while consumers can write great product reviews, they can also give negative feedback.  How we handle the negative feedback is key, we could reach out directly to the unhappy consumer and find a way to fix their issue in hopes that they come back and write about what great customer service we provided. 
The second aspect of this blog should be intercompany.  You can think of it as more of a place for our internal Sales & Marketing team to share best practices, success stores, consumer insight, future marketing initiatives, etc.  This should be an informal “discussion board” of sorts.  This blog will help to keep our account managers in contact more often and on a more casual basis.  There will be no costs associated as we do not need a special domain name, nor do we need an employee to manage the blog. 
The third and final aspect of my plan does not include blogging on our part.  Rather, I think we should find some of the top food/coffee bloggers and reach out to them directly.  We can educate them on one of our featured products and send them a free coffee maker or kitchen appliance.  In return, we will ask that they feature us on their blog, along with a link to our blog and company website. 
While this may seem time consuming and ineffective to you, I can assure you that business blogging will one day be a key component to all companies’ social media platforms.  To put this in perspective for you, I provided the below chart on WordPress which is a blog publishing tool used by companies such as CNN and NFL. 

Please reach out to me for next steps. 
Megan Healey

Google Docs vs. Microsoft Office

Hi Greg,

As per your request, I have compared Microsoft Office to Google Docs and provided a brief recap of the pros/cons as well as my final recommendation.  Since we are currently using Microsoft Office, you are already familiar with the features and benefits.  Google Drive has many of the same features only with added ease of use and increased accessibility.  A few main examples of where Google Drive can help us become more efficient are as follows:
·         File Sharing & Collaboration:  Rather than emailing large files back and forth to multiple people for editing, Google Docs provides a place for multiple people to revise docuements and tracks these revisions for others to see.  It also allows for real-time editing  allowing others to see what is being worked on at that exact moment in time. 
·         Accessibility: Currently, we must connect to our network in order to access the majority of our shared files.  As you know, we often have connectivity issues when traveling or working off-site preventing access to our network.  Google Docs prevents this situation and allows for you to access/edit documents anywhere you can connect to the internet.
·         Cost Effectiveness: Our licensing costs for Microsoft Office 2007 were close to $45,000 ($300 per person  x 150 employees).  Google Docs ranges anywhere from $5 to around $15  per person depending on which version we chose to utilize.  Assuming we want the most functional version, we are looking at a total cost of $2,250 which represents a savings of $42,750.
·         Training: Google offers free training via WebEx and online seminars. 

As with any business decision, there are pros and cons to transitioning to a new system.   While I listed free training as an advantage, it is important to remember that nothing is truly free.  Since we have been operating on Microsoft Office for years, there are many employees who know ONLY this system.  Their learning curve may be more significant and therefore take more time completing day to day tasks.   I believe that the cost of the man hours spent learning the new system will far exceed our savings of $42,750.
Another major disadvantage is the questionable securities risks.  In my opinion, the three departments which would most often utilize Google Docs for sharing and collaborating  are Finance, Marketing and Human Resources.  These are also our three departments with the most confidential information.  There is no way to put a price a price on a potential security lapse.
As a final note, over the past year we have invested millions of dollars to transition to SAP.  Our main reasoning for the SAP implementation was to get all subsidiaries on one GLOBAL system.  Because all of our local and international subsidiaries (plus our parent company in France) operate using Microsoft, I don’t believe switching to Google docs is beneficial in the long-run.  Yes, it will allow us to more effectively collaborate but only with those who also utilize Google Docs, and unless we initiated a global change it really does not help us much.  From a human resources standpoint, employees are just now feeling 100% adjusted to SAP and all of the changes that came along with it.  Asking them to learn another system after finally becoming comfortable with SAP is asking too much. 
Please let me know if you require further analysis or would like me to dive deeper into the Features & Benefits of Google Docs.
Megan Healey