RxSolutions Portfolio

Prescription Solutions

Pharmacy and Medical Management e-commerce website for prescription and over-the-counter medications

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 Order 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.

Web Analytics

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

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.

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 Replacements

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 Overhaul

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.

AS/400

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 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.

No Insurance / DDP Alternative List

This a list of the most frequently requested high cost medications. It displays to the customer service agent common questions/answers about these drugs. The verbiage is updated using a content administration tool on the company intranet. This application has strict permission levels and can only be modified by an authorized pharmacist.

Prior Authorization Denial Form

Web-enabled form that is used to request backup information for Prior Authorizations reviewed by the Prescription Solutions Prior Authorization department. Before being web-enabled, the client e-mailed Prescription Solutions Appeals Coordinator a request for the original denial letters, on the average of 10 requests per day. Making the form web-enabled allows Prescription Solutions to provide Appeals information to the client in a timely matter, allows Prescription Solutions to be in compliance with Regulatory mandates and meeting the request of clients to have the request form web based. In addition, several statistics are available on the web including market, medication and denial date fields.

Accounting Client Data Form

Developed online data entry form and read-only report(s) for Client Accounting Data. This tool provides an efficient communication of client’s data that is shared amongst the Accounting, Finance, Client Services and Contracting departments. With a “one-stop shopping” approach to the data, personnel in the noted departments can research client data without trying to compile it from various sources. This results in time-savings while researching client data.

OTC Administration Update

Enhanced OTC Product eWebEditPro Administration application to allow administrators to assign a department, category and subcategory to an OTC product. Prior to this enhancement, this application was only capable of adding/editing OTC product verbiage. Categorizing of OTC products had to be done through an MS-Access database. Now, all OTC information can be added and/or edited in one location without MS-Access. This results in a much more streamlined administration process of OTC products and easier input of catalog data for the OTC administrators.

Consumer Survey Results

In the 2nd quarter of 2003, an online survey was placed on RxSolutions.com to elicit feedback from our consumers. This webpage displays the results of the survey data, housed on a MS-SQL Server. The statistics shown include the percentage of surveyers that answered specific questions and their averages. In addition, the survey allowed a user to enter an optional comment which is also displayed using ASP paging methods.

SMART Plan Locator Creation

Developed a web application for SMART that allows customer service agents to search by sub-client and retrieve client/carrier info. Administrative web pages were developed in conjunction with this to allow updates to the sub-client data. The Plan Locator is a quick and easy to use tool that has given agents sub-client search functionality not possible in RxExpress. The plan locator also directly links to the SMART application for retrieving related plan documents.

PBI Newsletter Automation

I developed a process to dynamically create the Pharmacy Benefit Insider (PBI) newsletter. These newsletters were originally created by a user manually updating an HTML web page every other month. The new automation process creates the HTML for the newsletter by retrieving newsletter data stored on our SQL server. As a result, a PBI newsletter is created by simply clicking a link on RxWeb. The newsletter can be generated in either HTML or plain text format and does not require any editing whatsoever. The marketing department has now been able to transition PBI responsibilities from one to multiple users since editing of the newsletter and HTML experience is not required anymore.

Web-Enable Kuian Database

Customer service supervisors can now track, enter and edit attendance, kudos and audit records on the intranet. Prior to being available on the web, this functionality was in an MS-Access database. The new web format gives supervisors a much easier and more user-friendly interface to work with.

Mail Service Prior Authorization Queue

A very extensive intranet web application that allows agents to enter and track the status of prior authorization requests. Prior to this, this process was entirely paper and e-mail based. After being web-enabled, users have reported tremendous time savings by using the new web format by virtually eliminating phone calls that normally had to be made to retrieve the status of a prior authorization.

Local Weather Widget

The Prescription Solutions' intranet displays the current weather conditions using Weather.com's XML web service. This was accomplished by submitting an XML request to Weather.com's web service. Weather.com then returns an XML response with the weather data. An XSLT was then created to parse the XML document and transforms the results to HTML. The end result is being able to display data from an external source that is presented with the look and feel of our intranet.

Stock Ticker Widget

PacifiCare has added an Employee Stock Purchase Plan (ESPP) to our current list of benefits for full-time employees. Even since the stock moved to the NYSE, it has taken off and employees are always curious as to what the stock price is. As a result, I found a way to display stock ticker data using Yahoo! Financial Services. Using techniques similar to the local weather application (see above), I was able to incorporate this into our intranet website. Again, this shows how I was able to retrieve data from an external source and apply a GUI to it that fits with our intranet.

PBI Newsletter Redesign

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.

Management Dashboard

As prescription and OTC orders are processed, the mail service system will update a series of Oracle tables that contain detailed information about the production activities. I developed a series of Oracle packages that contain functions and procedures that query these Oracle tables and return resultsets that are consumed by SQL Server Reporting Services. In addition, administative web forms were developed to populate additional Oracle tables. The Oracle packages and web forms were developed using Visual Studio.NET 2003 with the Oracle developer tools.

Internet Usage Statistics

An internal web page was created to display reverse adjudication statistics for the RxSolutions.com website. The data is inserted and queried with SQL Server 2000 data tables and stored procedures. The tables contains millions of records so a DTS package was created to calculate final usage numbers and is scheduled to execute as a SQL job during non-peak hours. The final usage numbers are used in conjunction with ASP.Net's System.Drawing.Imaging library in order to dynamically generate the pie charts as images.

Intranet Glossary

The glossary on Prescription Solutions' Intranet was updated from a static, HTML-written web page to a dynamic, database-driven web application. The glossary allows users to page through the various terms used in the healthcare industry. Users may also type in search criteria and while doing so, are presented with a dropdown menu with possible matches. This application was written with ASP.Net, VB.Net and ADO.Net. It implements AJAX written in JavaScript and utilizes the XMLHttpRequest object to render the dropdown menu. All data is queried from a SQL Server 2000 database using stored procedures.

Client Information Database

The Client Information Database is an enterprise-wide web application that gives users access to client and patient information. The application contains many input screens that allows client-relation managers to enter the client's data. Once the data is entered, users such as customer service agents access the application via the company intranet in order to lookup user's information and how their client handles various healthcare scenarios. The application was developing with Visual Studio .NET. The backend was written in VB.NET, ASP.NET and ADO.NET. The front-end uses JavaScript, HTML and CSS. SQL Server 2000 acts as the data repository for all the client data. Web services are used to communicate to AS/400 systems to obtain patient-specific information.

Membership Account System (MAS) Helpline

The MAS Helpline is a web-based intranet application that allows helpdesk agents search for and access various FAQ documents pertaining to membership accounting. Users may also type in search criteria and while doing so, are presented with a dropdown menu with possible matches. This application was written with ASP.Net, VB.Net and ADO.Net. It implements AJAX written in JavaScript and utilizes the XMLHttpRequest object to render the dropdown menu. All data is queried from a SQL Server 2000 database using stored procedures.

Content Management System

The Prescription Solutions internet website contains a lot of web pages for our customers, business partners and health professionals. When first implemented, these web pages were static written in pure HTML. Whenever an update had to be made, it was up to me to meet with the content owner to implement the revisions and upload to the website. Now, I have installed and integrated an application called eWebEdit Pro. This is a browser-based WYSIWYG editor allows content owners create and publish web content with a friendly, MS-Word-like interface. With this application integrated with our website, the content owner no longer needs to coordinate with me to makes changes on the website. As you can imagine, this has released a lot of duties that would be normally performed by a webmaster. One of the uses of this application allowing our Clinical Services department to publish an online newsletter on RxSolutions.com without the help of the webmaster whatsoever.

Technologies

Microsoft, Visual Studio, C#, VB.NET, ASP.NET, Classic ASP, ADO, SQL Server, Oracle, AS/400, DHTML, CSS, JavaScript, Crystal Reports, ODBC, XML, UML