|
Prescription Solutions - IntranetPharmacy and Medical Management intranet website.
|
|
Administrator Tools
| 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. |
|
|
|
|
| |
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. |
|
|
|
| |
Content Management Implementation and Upgrade
| Implemented parent to child relationship for documents created on eWebEdit Pro. This allows business users to publish articles that are associated with a particular issue. This in turn led to the creation of the online newsletters RxNews and Pharmacy Benefit Insider. In addition, an upgrade to the eWebEdit Pro application on RxWeb was completed successfully. The upgrade fixed Windows 2000 issues with the previous version and added more GUI functionality. The upgrade also involved utilizing FTP for image uploads. This is a much faster and efficient file distribution mechanism and compensated for the intranet and internet load balanced web servers. |
|
| |
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
|
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
|
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
|
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.
|
|
|
|
|
| |
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.
|
|
|
|
| |
