www.rxsolutions.com |
Prescription Solutions - InternetPharmacy and Medical Management company website.
|
|
Shopping Cart
| The Prescription Solutions' shopping cart was developed from scratch so it may handle prescription orders that interfaced with internal back-end databases. The shopping cart itself runs on a MS-SQL 2000 Server utilizing complex triggers and stored procedures. |
|
|
|
| |
Username/Password Login
| The Prescription Solutions' website utilizes a username/password login to allow a patient to view his or her medical information. This includes prescription, account and order history details. Displaying this information over the web requires the highest security measures. The login interface ensures that patient information is viewed only by the intended individual. The login process itself interfaces with an internal MS-SQL 2000 Server and other internal databases. |
|
|
|
| |
Formulary
| Developed web interface to display formulary medications based on an individual’s health plan. The formulary displays both formulary and non-formulary prescription drugs with formulary alternatives. Finding formulary drugs can be performed by a user entering a keyword or browsing by brand name, generic name or theraputic class/sub-class. |
|
|
|
|
|
| |
Pharmacy Locator
| As the name indicates, the pharmacy locator allows a member to locate a pharmacy near their desired location. This includes by city/state or zip code. Pharmacy results are listed with address and telephone information. Each pharmacy listed is integrated with MapQuest so a member may retrieve a map and driving directions to the pharmacy. |
|
|
|
|
| |
Prescription Refills
| One of the most used features on RxSolutions.com is allowing a member to refill a prescription. Prescription refill information is housed in an internal VAX database. A .NET remoting object is used retrieve prescription data from this database. Displaying which prescriptions are available for refills involves many calculations including factors dependent on health plan attributes. The website displays all medications a user may or not refill with descriptions as to when they can be refilled. Refilling a prescription is integrated with the site's shopping cart to allow easy purchasing of prescriptions. |
|
|
|
| |
Prescription History
| A user may view their entire prescription history, per year on the RxSolutions.com website. All prescription history is housed on an AS/400 system. A .NET remoting object is used to retrieve this data. Each prescription in the prescription history list is linked to a Patient Education Letter (PEL). A printer-friendly format of the prescription history also exists. |
|
|
|
| |
WebTrends Reporting Suite
| Successfully installed WebTrends Reporting Center application on web server. This new reporting tool was implemented to replace the out-dated WebTrends Reporting. The new application generates reports/statistics on a nightly basis and is accessible via a user's web browser. This allows users to view reports online without having to request a report be generated. |
|
|
|
|
| |
Over-the-Counter (OTC) Sales
| OTC sale prices were successfully implemented on RxSolutions.com. Product listing pages dynamically display sale prices in accordance to sale prices entered by the business.no additional development is needed to display new prices. This allows the business to enter sale price data in a timely matter before a sale actually occurs. After the first month of sale price implementation, record number of OTC sales was reached on the website. |
|
| |
OTC Out-of-Stock Implementation
| Added logic to the website that displays an “Out-of-Stock” message to the user. Prior to this, a user would have to add an item to the shopping cart to see if an item was in stock or not. Now, the stock status is displayed with the OTC item. This implementation removes the frustration for a user attempting to purchase a product that is out-of-stock. The out-of-stock logic is based on a data abstract from RxExpress which eliminates discrepancies that used to occur prior to this implementation. |
|
|
|
| |
Crystal Reports Web Interface
| Created web interface for Crystal Enterprise. The interface allows a user to view all the report types available and then drill-down to a specific report. This application was added to the Client portal on RxSolutions.com behind a login. The application was then modularized to have shared components and run on the company intranet. |
|
|
|
|
| |
Communications Object Replacement
| I was heavily involved in replacing the Java COM object with a .Net Remoting object for the internet website. My key role was updating over 60 web pages to use the new API. The new object can be changed which gives us the flexibility to modify the current RxExpress-RxSolutions.com communication protocol. This was not feasible with the Java COM object. |
|
| |
Consumer Homepage
| Created consumer homepage on RxSolutions.com. After a member logs in, a customized homepage appears displaying information specific to the user. Information displayed includes recent OTC purchases, healthplan messages, easy access to prescription information and more. The homepage also allows a user to select a color theme and font size that persists throughout the site and upon their next visit to the website. |
|
|
|
| |
Prescription Drug Pricing
| Recent reforms in medicare by the U.S. government gave way to prescription drug pricing. The drug pricing application developed in conjunction with a co-worker allows a user to search for a prescription drug to price. Once found, the user can enter dosage and location information to accurately price a prescription drug. The web interface allows the user to compare and contrast prescription drug prices amoungst neighboring pharmacies, thus allowing the user to find the cheaping price for their prescription drugs in their local area. |
|
|
|
|
|
|
| |
Prior Authorization Guidelines
| Prior authorization is required for certain Medicaid covered services before the services are provided to the recipient. The guidelines that dictate this are now available online. This allows both physicians and customers to view exactly what medications need prior authorizations and what their health insurance’s policy is. Being able to view these guidelines online saves the physican’s office time in that they do not have to call the customer’s health plan. |
|
|
|
|
|
| |
RxNews Online Newsletter
| Developed online newsletter for clients and healthcare professionals. This newsletter was designed to provide timely information on drug/drug therapy issues, recent FDA drug safety warnings, drug recalls/voluntary withdrawals and labeling changes, drugs in the pipeline, and clinical studies. All content on RxNews is run through a content management system and written by clinical service professionals. Whenever new material is added, an auto-generated e-mail is sent out with the updated information that contains links back to the website. |
|
|
|
|
|
|
| |
PBI Newsletter Redesign
|
Prescription Solutions' online industry newsletter - Pharmacy Benefit Insider (PBI) - written exclusively for pharmacy benefit consultants and benefit administrators was given a new look and feel. With this came upgrading the existing PBI Newsletter generator from ASP 3.0 to the .Net framework written in ASP.Net, VB.Net, ADO.Net using SQL Server 2000.
|
|
|
|
|
| |
Search Engine
|
Implemented search functionality on RxSolutions.com using a combination of the Microsoft Indexing Service and a SQL Server database search. Verified proper inclusion of name, keywords and description meta tags on all searchable web pages.
|
|
| |
Web Services
|
Designed, developed and implemented a web service architecture for Prescription Solutions. The web services were written in C# using Visual Studio.Net 2003. The architecture includes utilizing SOAP extensions that validates incoming SOAP requests using XML Schema (XSD) validation.
|
|
| |
RxSolutions.com Facelift
|
Updated the look and feel to Prescription Solutions' internet website. Updates include using new brand colors and images, DHTML dropdown site navigation, flash animation and dynamic font-resizing using CSS.
|
|
|
|
| |
Microsoft .Net Web Architecture
|
Created a web architecture for the development of .Net web applications for Prescription Solutions' intranet. The architecture includes the creation of a class library written in VB.Net, class and package UML diagrams depicted the class library, documentation for the setup of a developer's localhost to support the .Net architecture and a Visual Studio.Net Add-in for custom deployment of web applications.
|
|
| |
Web Server to AS/400 Communications
|
Enhanced the Temporary ID web application to communicate with an AS/400. The web application queries a web service on an application server. The application server then executes a stored procedure on the AS/400 using the IBM iSeries Access ODBC driver. The stored procedure then returns a recordset back to the application server which then returns a XML response back to the web server. This process was developed in conjunction with Prescription Solutions' AS400 development team.
|
|
| |
PrescriptionSolutions.com
|
The new Medicare Prescription Drug Program - Medicare Part D - is making prescription drug coverage available to more than 40 million people across the country. My role in this historic reform was developing the Consumer portal of the Medicare Part D website, PrescriptionSolutions.com. Various functions for this portal were developed including requesting a refill or ordering a new prescription. This portion of the website was written in ASP/JScript and consumes both SQL stored procedures and web service calls.
|
|
|
|
| |
