Web based Counseling Services Unit for Bureau of Health Services
Re-engineered 15 MS Access databases related to firefighter, EMS and civilian counseling due to situational stress related diagnosis codes to centralized oracle database structure. Replaced all the front end access modules to web oriented oracle architecture so that users can VPN to the centralized network and access the database in real time to perform their duties with utmost accuracy. System was using Oracle 9i, 10G, 9iAS, Java, JSP, Struts, MS Access, Developer 2000 Forms, Reports, Designer 2000, ERWIN, MS Project and Visio.
Web based long–term medical monitoring program – WTC project
A data capture system to integrate annual medical examination area including pulmonary lung function test, vision, hearing, EKG, x-ray for Doctors to review in real-time for diagnosis purposes using the graphical user interface applications. This application had extensive excel data uploading to the centralized database and consolidation of access databases to highly secured centralized database.