Per a request from my department director one morning, I found and downloaded a suitable C# API for processing PDF data. I then incorporated classes and methods this library into code I wrote over the course of 1 to 2 days to burst, by patient, a PDF file containing legacy medical system documents into patient-specific documents, and to create metadata files to index these documents which I then loaded into OnBase, thus allowing Bronson to release millions of dollars in funds which were being held in lieu of these documents being stored in our ECMS repository.

Wrote a C# OnBase EDI pre-processor to read in EDI 810 data, extract certain data segments, evaluate the segments via a set of conditions provided by our Finance department, and append new values to an unused EDI 810 segment within the data stream. This newly processed data was then read stored as metadata for the corresponding invoice document when loaded into OnBase.

Created an XSLT overlay document used to present the EDI data in a format easily interpreted by our Finance staff.

Wrote an application using the OnBase v15.0 C# Unity API that allows our HIM (Medical Records) staff to search for patient records in OnBase and to click on an icon that extracts each of the selected documents to a file in a path containing the username of the user running the task. After the code extracts all the documents, it posts to an external C# web application that executes 7zip (as the OnBase Unity API cannot execute external code) against the extracted documents to place these into a self-extracting, encrypted, password-protected, zip file that can be burned to a CD and provided to a customer presenting an ROI form (Release of Information).

Wrote an application to allow our medical providers to submit timesheets electronically. This application queries a Sharepoint list of position information, maintained by our administrative staff, presents the correct list of positions to the physician (based upon the user’s Active Directory ID) and allows the user to fill out a timesheet. Each position object includes information regarding approvers for the timesheet entry (which determines to whom my program routes the submission), pay rate, mailing address, and various other pertinent information. After the user has built up his/her timesheet, the user clicks a button and e-signs the timesheet. Once this is done, the application generates separate output files for each position and sends this data to our enterprise content management system (OnBase).

Wrote a web application to automate our Human Resources Position Control Process. This application handled requests to create new positions, delete positions, make changes to positions, etc. The application (originally written in Java/javascript--with AJAX functionality using Java Servlets for server-side processing; later ported to C# Silverlight using a C# SOA, C# Core Class Library, and a C# data access layer which queried a MSSql database via coded queries and coded –in C#- stored procedure calls) generated

html and index data files (containing metadata information) that were then loaded into our enterprise content management system (OnBase).

Wrote a web application to provide our medical staff with a way to access legacy medical data. The application, written in C#, takes an argument passed to it from our current Hospital Information System—a patient ID number--and queries our OnBase database, which is MSSql,(OnBase is the new repository for these documents). The application then presents the user with a tree of links categorized by document type (lab results, HnP, Radiology, etc.) ordered by date. These links take the user to our OnBase web client which loads the desired document and presents it to the user.

Wrote a web application to allow our users to order supplies to stock medical units. This application, written in C# Silverlight with MVVM, queries our Materials Management System (vendor written) database (MSSql) for all items and presents the user with an autocomplete drop down list of items the user can search. The user can then add an item to a table, specifying quantity. Once the user has selected all items desired, a click of a button sends a printout to our Materials Management department (printer information pulled from a sql table I created) and also writes an index file and an html file to a location that OnBase scans, so that the orders can be retained there. This application also queries a Sharepoint list for additional items that are not stored in our Materials Management system, as well as a Sharepoint list of aliases (maintained by the heads of our nursing units), so that users can search by the name an item has in our Materials Management system or by an alias they are more familiar with—assuming the nursing manager has entered this alias into the Sharepoint list.

Wrote a web application to allow users in our Purchasing department at a recently acquired site, to submit returns to their Materials Management staff. This application, written in C# with MVVM, queries our Materials Management system so that the users can enter a PO number or an item number and select the item they wish to return. The application also supports wild cards in PO numbers. This application also writes data files to OnBase. The application also queries Active Directory to retrieve user information following authentication.

Wrote an application in C# Silverlight that was launched via our Nursing Information System, our Clinical Portal System, and our NeoNatal I.S. to allow our physicians to perform medication reconciliation for patients prior to discharge from the hospital. This application queried our Medication Management database, retrieving a list of patient medications that a physician could continue, stop, write prescriptions for, etc. This application also wrote to a database in order to store the current state of the application, so that a physician could come back to it later and finish his/her work. I also wrote Cache’ object script code to query a Cache’ database (as the original version of this application was written in Cache’ before we brought its development in house), and pass patient context information to the various vendor created applications that the Medication Reconciliation application I created was launched from.

Wrote an application that allows managers to enter an employee’s employee ID number. The application then queries our Human Resources I/S database and populates a table with the employee’s name, department, job title, etc. The application then loads a tree view of locations for which the manager can order to be added to an access control card for the employee. The data source for this list of locations is an XML file I created of n-deep hierarchical data that was recursively parsed and bound to a Silverlight TreeView control. Once the manager has specified all the locations the employee should have access to and has submitted a form, the application creates and HTML and an index file that are loaded into OnBase for archival.

Wrote various other applications, as well as troubleshooting, debugging, and enhancing many other pre-existing applications (Java web applications—using JSP, javascript, and Java servlets; asp applications, and C# applications). Also created and maintained many OnBase HTML/javascript Overlay files. These contained javascript that would process ampersand delimited data to display html pages to a user.