Allergan, the makers of Botox, came to Conquent with a complex database problem; they needed a way to track policies regarding the drug, acceptable diagnoses (using ICD9 codes) for which the drug will be beneficial, and the correlating procedure (CPT) code for how the drug is administered.
The resulting program needed to be able to cover every insurance, pharmacy benefits management company and other management companies as well as every condition Botox can be used for. (It's not just cosmetic, by the way, Botox is used for treatment in a wide range of muscular and glandular issues.)
Conquent provided the pieces to the puzzle: light graphics on an intuitive interface with some really complex programming to make it easy for Allergan management to use the system from any web browser.
Because the management team at Allergan is constantly traveling, they wanted a system to allow them to update and review data constantly. In the past they had tracked this information in desktop programs which required an administrator to constantly export data prior to meetings.
Conquent's specialization in web based programs meant we had the tools to get the job done. But, Allergan's legacy system assumed a technical user -- the meant creating a range of automatic reports and simplified forms to let the Allergan managers retrieve and update their information with little to no technical knowledge.
After organizing the data, the team created a series of pages to narrow down a manager's choice -- the system made for quick access to complex information, and saved hours per project for the Allergan management team.