Wednesday, May 15, 2013

Beyond Microsoft Visio

Microsoft Visio is a commercial diagramming program from Microsoft to create diagrams. This software is mainly used in businesses, architecture, academic institutions, research institutes, and many other fields to create flow charts, process flow, design, and other commercial oriented diagrams. The current version, Microsoft Visio 2010 for Windows, is available in three editions: Standard, Professional and Premium. The Standard and Professional editions both share the same interface, however, the latter has additional templates for more advanced diagrams and layouts as well as unique functionality that intend to make it easy for users to connect their diagrams to a number of data sources and display the information graphically.
I have used the standard version during my graduate studies of Mechanical Engineering to create process flowcharts and several other drawings. It enables to drag and draw in-built shapes and connect the shapes very easily. It is also possible to edit the diagram and save it as different files. It is compatible with windows and hence is ubiquitously accessible. It is a fantastic tool for students and employees as well.
In my job also, I continued using the professional Visio to create engineering drawings and project timelines. I also used it for more practical applications like process flowcharts for the departments to be included in internal documentation. Such documents are needed as a requisite for a regulated company. MS Visio is more of a manual drawing tool enabling the user to place the shapes as desired and connect the shapes with lines. We can select one shape at a time by dragging and dropping. We also need to give the arrows separately in order to show the flow of the process. Adding and deleting shapes is lengthier in MS Visio. We have to add a shape separately along with the connection arrows. This makes MS Visio more tedious and tiresome. Also, we have to adjust the arrangement and alignment of the shapes accordingly. Editing takes a lot of time to give the drawing a professional look.
Recently, I have come across SmartDraw which is the visual processor. I was quite amazed by a library of functions and user friendliness of this program for doing the most tedious drawing jobs. It offers easiest ways of drawing for example, we can double click the shapes and those get connected with the arrows automatically, thus showing the flow of the processes. Also, adding and deleting of new process shapes is much easier with SmartDraw. We can also change the connection arrows or directions of the shapes. It has automatic drawing and editing tools offering much ease in using. Being a visual processor, it automatically corrects and arranges itself much like a word processor. Hence, the time required for creating and editing is drastically reduced with enhanced productivity. They also have a help desk support enabling even a novice for self-learning. SmartDraw also supports MS Visio files to view and edit. In sum, SmartDraw is the one-stop solution for all your drawing and graphical needs. I would always prefer SmartDraw to MS Visio. Additionally if it has to be analyzed on prices basis SmartDraw proves to be a winner on MS Visio. With so much of functions incorporated in SmartDraw, we tend to think it costlier than Microsoft Visio. However, to my surprise SmartDraw retails for $197 for a single user license and they also have deals for multi-user licenses. In contrast, the  MS Visio Standard version retails at $249, the Professional version retails at $559, and the Premium version retails at $999 (they’re available from Amazon for $206, $435, and $632, respectively). So we can equip the entire organization for less than the maintenance cost on the equivalent number of seats of MS Visio thus saving 50% or more. Of course, this is such an incredible stuff to believe. Just have a look at this: http://www.smartdraw.com/specials/visio-vs-smartdraw.htm. This site compares SmartDraw and MS Visio with respect to features and costs.
The transition from MS Visio to SmartDraw can be an economically and time-reducing decision for our company. It would improve productivity at a much faster rate. We can complete more number of diagram assignments in the same period of time and that too with much higher efficiency and accuracy. SmartDraw will also help us to utilize out time for analyzing the diagrams instead of wasting time on its editing and beautification. This way we can harness the analyzing potential of the employees instead of making them work on tedious drawings. We can get professional drawings created easily, much faster and more effectively. If we want to increase our productivity and ultimately our profits, we should definitely go for SmartDraw.

Monday, May 6, 2013

P&G Case Prep/Reflection

Problem/Issue Statement
  • Procter & Gamble’s trial process is very tedious and extensive and results in delayed data locks which could ultimately push back the market entry of a drug.

  • The problem that Procter & Gamble faces is the need to improve the current process. The symptoms associated with P&G’s problem are duplication of efforts which could total up to 25 labor hours during the course of a trial. In addition, there is the possibility of human error related to data entry which could result in further delays and errors.  P&G’s current process also involves frequent and costly sponsor support. 

  • The scope of the problem involves the need to improve the overall trial process at Procter & Gamble.  It is not solely a data entry issue but must also review the entire process to ensure the flow and data gaps and concerns are addressed as appropriate.

Situation Assessment
  • While the most attractive alternative for P&G is the implementation of EDC, P&G must also consider the effect on the overall process.  As mentioned before, the issue is not solely a data entry issue which causes delay in the trial process.  While this lag or delay may be solved with the EDC, it will be necessary to evaluate the entire process.

List of Plausible Alternative Courses of Action
  • The three alternatives that P&G has analyzed as a potential solution to the problem it faces are:
    • Improving the paper based process
    • Digital imaging
    • Web enabled electronic data capture (EDC)

Recommendation

After reading the case, I would recommend that P&G implement the EDC to improve their trial process.  By implementing EDC, the data would be entered to the data management system directly by the investigative sites.  P&G would also be able to establish rules to perform data validation without having to do double data entry.  Querying and data validation can be built within the EDC.  The EDC would also make data available immediately to the sponsor, whereas, with the current paper based process, the sponsor had to wait longer for the data to be available to them.   The EDC would require fewer visits from the sponsors to the sites, hence, providing a cost savings to P&G.

While the implementation of an EDC would potentially reduce the period of time needed to data lock from by half, it is still important to consider the other resources and changes that would be required in order to shift towards the EDC.  This alternative would require upfront investment in development and maintenance of all electronic case report forms (eCRFs) and help desk support for clinical sites.  Additionally, P&G would have to invest in training and change management to roll out the EDC to ensure sponsors, data entry specialists, and all others involved in the trial process would learn the new process.  It may take a longer period of time to adapt to the EDC given potential resistance to change, but in the long run, I would recommend that P&G implement the EDC as it will provide a wider range of benefits which will address the issue at hand which is the need to reduce the length of time it takes to data lock.


Reflection:

After attending Montclair consultant's presentation and listening to their point of view regarding the alternatives to resolve current issue at our hand, I agree with the recommendation of implementing EDC.  The implementation of the EDC is likely to be a rewarding investment for us.   EDC will enable us to be able to reduce the time it takes to data lock and potentially reduce the overall trial process time.
My initial recommendations were also confirmed by Montclair consultants, as implementing an EDC system will not only help us to contain costs and increase efficiencies within an organization, but it will also help with the clinical data management process. An EDC system will be a vehicle for exploiting new drug development opportunities by knowing sooner whether to move forward on or eliminate a drug program. EDC system will help us in managing the clinical data process and capture the information needed to help expedite this process and ultimately bring down the data locks time. Though the risks associated with implementing an EDC system includes investment costs associated with instituting the software, employee training and system maintenance the overall benefits are too lucrative for us and the same inclines my recommendation of implement EDC.

Junk Van Case - Reflection

After considering presentation from 4e consultants, I have concluded that I agree with their recommendation to upgrade our IT infrastructure through a Sage 50.  Ultimately, this solution was preferable to the alternatives because of its ability to solve our operational inefficiency with a modest investment that would be profitable from the time of and also provide more flexibility, and adequate vendor support than alternatives. Through initial research I had strong recommendation on using PaaS custom developed platform for our company but the close analysis conducted by the consultants has entirely changed my initial opinion. Upon further study, I have also reached the understanding that what was suggested in the presentation and the Sage 50(mini ERP) approach is best suitable for small and growing business like us. 

Since the non-hazardous waste collection service has become somewhat of a commodity, it is extremely important that we are able to retain our clients and keep our cost structure low.  Using a Sage 50 option would eliminate the need to rely on an inefficient emailing system that often led to outdated databases and pickup errors.  By utilizing a cloud storage service and giving our employees real time access to the database through this ERP solution, we will best be able to grow in the markets we already exist in and further expand to new ones through franchising. 

Friday, May 3, 2013

Junk Van Case Prep

Problem/Issue Statement

Information handling errors are pervasive

·         Clerks accidentally sent the wrong version of the database to the morning operator, and as a result some jobs that were already booked no longer showed in the database
·         Some did not make their way onto the spreadsheets used by the drivers
·         Fixing the database was extremely time-consuming
·         While fixing the database, no new reservation could be taken as there is only one live copy

Situation Assessments
·         Drivers relied on instructions delivered through an e-mail system, and when this information was incomplete or incorrect, customers suffered the consequences
·         Essential to design a system of information flow that improved the quality of day-to-day operations

Criteria/User Requirements

·         Needed a central database
·         Internal information should no long be transmitted by email
·         Database should be accessible remotely since everybody would be working on it simultaneously from different locations
·         E-mails to customers to be sent automatically from the system in order to avoid mistakes and the resulting delays
·         Solution has to be easy to implement and operate

Evaluation of Alternatives




Alternatives


User Request

M.S Access
Cus.App.
Goo. Docs
PaaS
ERP
Provides Central Database

P
P

P
P
Internal Information not transmitted by email

P

P
P
P
Database accessible remotely


P

P
P
Ability to send E-mails to customers automatically from the system in order.


P
P
P
Solution has to be easy to implement and operate

P


P
P


 Microsoft Access Database

·         Relatively short time and on a small budget
·         Installed on a centralized server to be accessed remotely through internet and VPN
·         Not allow remote access, and so each instance of the database would have to be updated manually, everyday
·         Require to delve into significant amount of technical information
·         Might require user licenses
·         Costs of hosting the shared server
·         Required professional development assistance

Custom Application

·         Web-based system, meets the requirements of a central database and provide remote access
·         $2000 upfront price but did not provide for any changes or adjustments that might be required
·         No way to predict how much maintenance would be needed
·         Custom-made software simply could not be seen beforehand

Google Docs

·         Work simultaneously on the same file
·         Set different user profiles
·         E-mail distribution was also supported
·         Free up to 10 user accounts and cheap for small business users
·         Can’t be cross referenced in the way it usually is in relational databases
·         Lack of formal customer support
·         Users did not own the tools and resources used to store sensitive company data




Platform as a Service

·         Through Internet
·         Users could utilize common applications
·         Build their own unique applications
·         Different providers had slightly different offers
·         Easily built forms and connected tables
·         Long-term contracts were not required
·         Scale the service up or down at any point, or cancel the service with one month’s notice
·         On-site Trial

Enterprise Resource Planning (ERP) System

·         Built around central database
·         Accessible remotely
·         Integrate business process by covering every aspect of the business
·         Very costly

Recommendation

Quality recommendation

·         Custom Application
·         PAAS
·         ERP System

Logical recommendation

·         Considering Kinko’s criteria I believe going with the PAAS is the most logical recommendation.