RxSolutions Portfolio

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.