Our History of Projects And Activities
Integrated Case Management and Waiver Workflow for U.S. Navy
While at CACI, Inc., rearchitected Special Duty Waivers from the ground-up, integrating INCAP and WebWave into a single database driven system. Added a variety of reporting tools, system administration features, and an API for the MedMIDS application at the US Naval Academy. Updated the code to Bootstrap 3.x, added TypeAhead capability, updated jQuery, DataTables and TableTools. Expanded the internal and external notifications and added a user interface for management of reference tables. Application code base is ASP.NET with jQuery deployed under IIS7 with an Oracle 11gR2 backend.
Modernization of WebWave for U.S. Navy
While at CACI, Inc., inherited a legacy .NET application with clear text passwords in database and various known security issues. Introduced hashed passwords while “modernization” efforts (to replace code base) were underway to replace username/password login with common access card (CAC) authentication and fixed a variety of outstanding application issues. WebWave is a case management and workflow system for U.S. Navy organizations to request a variety of waivers. Application code base is ASP.NET with jQuery deployed under IIS7 with an Oracle 11gR2 backend.
Creation of Special Duty Waivers application for U.S. Navy
While at CACI, Inc., forked the INCAP code base and created Special Duty Waivers is a case management and workflow application for U.S. Navy organizations requesting waivers for various Special Duty assignments. Application code base is ASP.NET, Bootstrap, jQuery, DataTables and TableTools deployed under IIS7 with an Oracle 11gR2 back end with CAC based authentication.
Modernization of Incapacitation Waivers for U.S. Navy
While at CACI, Inc., inherited a legacy ASP.NET application for case management and workflow allowing U.S. Navy service members to make requests for medical care of their dependents. Application code base is ASP.NET, Bootstrap, jQuery, DataTables and TablesTools deployed under IIS7 with an Oracle 11gR2 back end with CAC based authentication.
Modernization of Individual and Unit Medical Readiness (IMR) Lite for U.S. Navy
While at CACI, Inc., leveraged NMKMS (see below) data warehouse to capture medical encounter data from multiple disparate data sources replacing a database reporting only current Individual and Unit Medical Readiness for the U.S. Navy Fleet. Struts2 front end with jQuery, DataTables, TableTools, JNDI, Oracle 11gR2 back end deployed under JBoss 7.x with IIS7 as the HTTP listener with the isapi plugin and CAC authentication.
Epidemiological Outbreak Surveillance (EOS) Joint Capability Technology Demonstration (JCTD)
While at ScenPro, leveraged NMKMS (see below) to build an Epidemiological Outbreak Surveillance proof-of-concept system to capture data, analyze ICD codes, and report on possible outbreaks in the shortest amount of time possible.
Operational Workload Reporting (OWR) for U.S. Navy
While at ScenPro, leveraged NMKMS (see below) data warehouse to report workload from various activities performed aboard deployed ships. Struts2 front end, JDBC, jQuery, and an Oracle 11gR2 back end deployed under JBoss 4.x.
Combat Trauma Registry (CTR) Data Collection for U.S. Navy
While at MTS, leveraged NMKMS (see below) to build browser based data collection tools for casualty trauma and psychiatric events. Supported system while deployed under Operation Iraqi Freedom (OIF). System included store-and-forward capability to route encounters from far forward medical treatment facilities (MTFs) to Marine Expeditionary Force (MEF) forward headquarters to principal investigator at Naval Health Research Center (NHRC) in Point Loma, CA. Front end is Java Server Faces (JSF), JDBC, JavaScript, back end is Oracle 11gR2, deployed under Tomcat 5.5.9.
Navy Medicine Knowledge Management System (NMKMS) for U.S. Navy
While at MTS, technical architect and lead developer for the NMKMS data warehouse for U.S. Navy Medicine. The system collects data from multiple disparate data sources employed by the Navy for documenting medical encounters, standardizes the vocabulary through the use of the DROOLS business engine, and reports out through a variety of add-on applications which use views of the data. The system has a custom written Java based extract, transform, and load (ETL) module and sits on an Oracle 11gR2 back end. This was used as the foundation for Navy Combat Trauma Registry (CTR) data collection in-theater. We later used it as the basis for a JCTD investigating Epidemilogical Outbreak Surveillance (EOS), Naval Operational Requirements for Medical Manpower (NORMMan), and Operational Workload Reporting (OWR). Currently, it is being used to modernized Navy Medicine Online (NMO) and became the foundation for Individual and Unit Medical Readiness (IMR) Lite Reporting for the Fleet. See the following articles:
CHIPS
DoN CIO
Free Library
eStatusReports
Developed a commercial product which allows organizations to define reporting structures from the C-level down to the individual staff, set goals which can be specific to the individual and/or inherited, then allow individuals to capture their work progress, output, and products throughout a normal business cycle. The data is automatically formatted into monthly reports visible to their chain of command and co-workers. The product is a Java Servlet based front end with an Oracle back end using JDBC.
Bugs Dashboard
Developed a commercial product using script.aculo.us and prototype JavaScript frameworks to deliver reporting from a Bugzilla database. The end-user can create multiple dashboards with widgets of their choice, restrict the use of each dashboard by product which honors the Bugzilla issue security framework, and extend the application with their own widgets through a software development kit (SDK). The application is delivered as Java Servlets with a wizard for connecting to a MySQL, Oracle or Postgres back end housing Bugzilla. A small schema is installed into the Bugzilla database, however all authentication is managed by Bugzilla which Bugs Dashboard accesses through Bugzilla’s web services.
Consulting at Pharmacia (later sold to Pfizer)
While consulting with Wyoming Software, created Pharmaceutical R&D Projects using Oracle PL/SQL, RDBMS and Oracle Application Server (OAS).
Consulting at Hewlett-Packard
Developed a document management oversight application (not to be confused with a content management system (CMS) or workflow engine). Developed in Oracle PL/SQL and Oracle back end. Developed and served as application Database Administrator (aDBA). This is where we learned the important distinction between an application DBA and an enterprise DBA (eDBA); a lesson we’ve used ever since!
TrueCourse
While at NCompass, architected and developed a full fund based accounting system for use by school districts. Developed with Oracle PL/SQL for an Oracle back end deployed under the Oracle Web Server.