Project Title: eVigilance

The Challenge

Franklin Group Inc. required a web-based application that would solve the complex and legally significant task of controlling and monitoring pharmaceutical industry representatives' access to large quantities of prescription drug samples intended for distribution among licensed practitioners. Additionally the system needed to enable the company to disseminate information about available samples amongst the medical community.

Pharmaceutical companies manufacture the samples while representatives handle the distribution to practitioners. The problem of monitoring and controlling the work of the representatives is central to the web-based application developed by LUXOFT. The application needed to automate the monitoring process: how many samples were received by a representative, how many samples were distributed by this representative in the course of the reporting period, the scheduling of audits, etc. The application should be able to generate the appropriate reports for sending to the manufacturer.

The Solution

LUXOFT developed a web-based application to serve as the platform for an overall suite of software supported by the client company. The platform created, called eVigilance, will replace the client's Sample Accountability applications.

During development the project team relied on the prototype created by the customer. The main stumbling blocks were that the prototype could not provide appropriate system usability and the customer requirements were constantly changing.

Three-tier architecture was employed. BEA WebLogic 7.0 was used as the application server. Oracle 9i was used as the database.

System Functionality

The main functionalities of the eVigilance system are:

• Transaction support (a transaction is marked by the changing status of samples to be distributed)
  • Shipment (transferring samples from a pharmaceutical company to a representative)
    
  • Distribution (transferring samples from representatives to practitioners)
    
  • Inventory (stock accounting)
    
  • Theft/Losses (accounting for possible losses)
    
  • Returns (returning samples from representatives)
    
  • Transfers (transferring samples between representatives)
    
  • System scheduling the audits of representatives
• Reporting system
  
• Alert generation system (an alert is a message generated if conventional business processes are violated)
  
• Reconciliation system (sorting out misplaced samples)
  Loading flat files into the Oracle database (flat files are scanned paper forms filled out by representatives during the distribution process)

LUXOFT's solution is a semi-automatic accounting system monitoring the process of sample distribution to licensed practitioners. Initially, scanned paper forms filled out by representatives are loaded into the system. The system analyses this information and generates the appropriate alerts (if necessary). Users can use the system as a tool for business process monitoring. Appropriate corrections can be made manually. Both system users (client analysts) and the representatives can use the advanced reporting system for gathering needed information. Alert resolution can be done both automatically and manually. A variety of notification messages (generated automatically) provides both the system's owner and their clients (pharmaceutical companies) with up-to-date information. All operations conducted automatically (including accounting operations) can be corrected manually. A security filter provides secure access.

Tools and Technologies

• J2EE platform
  
• JavaScript, JSP - web-based technologies used for the interface
  
• Servlet and JAVA - processing logic creation
  
• Struts - the framework
  
• Borland JBuilder as the RAD tool - program code related to the GUI

Post Your Story, Tell All About Your Success!

If you want the story of your company to appear on the portal please fill out this form and send it to [email protected]. We would also like you to leave contact information (name, e-mail, phone) of a person who is responsible for filling the form to clarify any questions, which could appear.

Available Success Stories From Companies:

Disclaimer

All information contained in this Section is owned by RUSSOFT.org and its Participants and is protected by Russian and international copyright laws. Any reproduction or republication of all or part of this Section has to remain intact and include a notice on the copyright of RUSSOFT.org or the Participants, as applicable.

While the information of this Section has been presented with all due care, RUSSOFT.org does not warrant the accuracy, completeness, usefulness and truth of Section’s information, links and logos derived from third parties. RUSSOFT.org is not liable for any loss or damage occurring from the use of this Section’s materials.