Projects

Websites
The website below was written using HTML, CSS, the Macromedia Dreamweaver MX program, and ASP.

Creation and support of the website for the Ft. Detrick U.S. Army Medical Research and Materiel Command, Human Research Protections Office. This website was created for use by medical researchers and research support staff to access policy documents, regulatory documents, and information about the Army's human research approval process.
Creation and support of the website for the Walter Reed Army Institute of Research, Clinical Trials Center. This website was created for use by clinical trials recruiters and volunteers.

Client-server applications
Client-server applications are thick-client programs (programs run primarily on the client's machine) that access a database server to retrieve and store data. These programs may be multi-user and may require multi-table updates. The programs below were written using Visual Basic .NET, Delphi 5, SQL Server 2000 and 2005's T-SQL language, and MS Access.

Medical research data entry applications.
Custom report generation application, and volunteer scheduling tools.
Application to process daily transaction posting to internal accounts
Windows 2000 system service to automatically send text messages to cell phones using a web-based service.
Object-oriented application to track the progress of drug research studies from concept phase through FDA approval.

Research study application support
Supporting a medical research group involves not only hardware and software skills, but knowledge of government regulations concerning patient privacy ( HIPAA), computer system validation, and security ( 21 CFR Part 11 and other regulations).

Installation and maintenance software used to support the scheduling, tracking, and budget needs of a clinical trial group.
Participated in the development of business requirements for electronic document management systems and clinical data management systems.
Assisted users with MS Access programming problems.
Provided hardware and software support for the clinical trials group.

SQL Server Database Projects
These projects involved the creation of T-SQL scripts and stored procedures:

Data import/cleaning procedures for medical claim insurance data.
Merge process to merge 5 separate databases into a master database. The challenge for this project was in working with the users about the actual meanings of data items in the source databases, and the meanings of the data items after the import in the resulting single database.
Database administrator on SQL Server versions 6.5, 7.0, 2000, and 2005.
Development of Extract, Transformation, and Load (ETL) projects in SQL Server Integration Services in SQL Server 2005.
Development of reporting data mart of clinical information used for reporting to senior leadership and extraction of data for research purposes.

Silent Auction Application Program
Created a silent auction program to record donors, attendees, donations, and purchases for the auction. The application is also used to print invoices on the night of the auction and record table seating arrangements.