Dr. Carolyn Hamm is a recognized
expert in Oracle data warehouse technologies, advanced analytics and
Oracle data mining. Dr. Hamm specializes in Oracle Discoverer, Oracle
OLAP and Oracle Data Warehouse Builder, and is an expert in multivariate
statistics using SAS, SPSS and Clementine.
Earning her Ph.D. in Experimental Psychology, Dr. Hamm has spent the
past 8 years developing web-enabled data systems for population
health, accessed by research, clinical and administrative staff.
Rollins College B.A. 1972-1976
University of Texas at Arlington Ph.D. 1976-1984 Experimental Psychology
University of Texas Health Science Center, Dallas NRSA Pre-doc trainee
Southwest Foundation for Biomedical Research NRSA Post-doc trainee 1984-1987
Over the past 15 years Carolyn has
held management positions in biomedical research across several disciplines,
including scientific research, clinical medicine, and information
9i & 10g
software and Oracle data mining tools
Oracle Discoverer and HTMLDB
Walter Reed Army Medical Center (02/01/2003 -
Present) - Chief, Decision Support Center Washington, District of Columbia
Duties: Manage the Decision Support Center.
Recognizing the importance of obtaining publishable scientific reports from
the Outcomes Management initiative, the Decision Support Center (DSC) was
established to advise and support the HealtheForces (formally Outcomes
Management) governing body. Briefs were prepared for management to present
for the Surgeon General of the Army, as well as Walter Reed, AF, VA,
civilian and other military command groups. Utilizing SAS statistical
software and Oracle data mining tools, logistic regression, table analysis,
Chi-Square, attribute importance, association rules, and categorization
models were used to investigate patterns and look for significant trends for
population health. The intensive statistical analysis required a new data
warehouse; assumed overall responsibility for development of the data
warehouse, and management of the staff including a data analyst, data
programmer, web programmer, and database administrator. Designed, built, and
deployed a data warehouse, operational data store, and metadata repository.
Responsible for creating the conceptual, logical, dimensional, and physical
data models. Web pages written in Active Server Pages (ASP), Oracle
Discoverer and HTMLDB provide a customized user interface to reports, charts
and data residing in the data warehouse. Among user specific reports are a
leishmaniasis page for data input, integration, email alerts, and reporting
clinical data from the Armed Forces Institute of Pathology, Walter Reed Army
Research Institute and Walter Reed Army Medical Center. Implemented an
on-line metadata repository for the Uniformed Services University (USUHS),
and established a partnership with the USUHS graduate school of nursing in
support of student and faculty research. Instrumental in reporting data so
that Walter Reed obtained and has maintained six JCAHO Disease-Specific Care
Certifications for two years. Project lead for Oracle database 10G Release 2
Beta program for data mining.
Supported, mentored and assisted principal investigators with approved
research protocols. Served as co-investigator on several research
initiatives, and assisted in writing publications for peer-reviewed
scientific journals. Responsible for project planning, determining
deliverables, and estimating time frames. Planned for the incorporation and
integration of external data sources, including the National Capital Area
Integrated Clinical Database (ICDB) at National Navy Medical Center, WRAMC
ICDB, ICDB at Madigan Army Medical Center, HealtheForces applications
residing on the ICDB and NARMC MTF’s, CHCS1, historical CHCS servers, M2
Bridge and the Air Force COHORT system. Established data warehouse technical
architecture in conjunction with other groups (i.e. HealtheForces IT shop,
other MHS facilities involved in data warehousing). Established security
strategies, designed approaches to security, developed policies, and
implemented security procedures.
Reviewed scientific literature and prepared executive summaries for outcomes
management, population health, and standard of care practices. Collaborated
with nursing research in writing a grant proposal for patient reported
outcomes. Presented the database and Web design at the 17th IEEE Symposium
on Computer-Based Medical Systems: An Operational Data Store for reporting
Clinical Practice Guideline Adherence in Chronic Disease Patients.
Walter Reed Army Medical Center (03/01/1999 - 01/31/2003) - Chief,
Outcomes Management Informatics Washington, District of Columbia United
Duties: Duties included managing a team of up to 12 contractors to design,
build and implement an electronic medical record for outpatient clinic
notes, survey tools, and scorecards for measuring compliance to standard of
practice guidelines for chronically ill patients. The HealtheForces
informatics team was comprised of software engineers, programmers, analysts,
database administrators, and quality assurance experts. Goals were to design
a database for an operational system so that clinicians and patients could
enter data, and create user-friendly Web pages for data entry and reports.
Standards were established for programming, testing, and validation. Served
as a highly specialized military health care system database expert.
Designed, maintained, and utilized the HealtheForces system for evaluating
outcomes data for pediatric asthma, diabetic, congestive heart failure,
chronic obstructive pulmonary disease, hypertensive, hyperlipidemia and
Hepatitis C patients using published HEDIS and established DOD medical
standards of care. Served as the primary source of information to the
HealtheForces team on statistical design of experimental sampling
techniques, Web-based programming, and was responsible for factual accuracy
of the data and for the thoroughness of the analytical research design.
Responsible for generating reports of patient populations and independently
configuring a Web-based internet system for both public and in-house secure
real-time interactive display of the information. As the senior project
analyst, was responsible for development, maintenance and enhancement of
dynamic Web pages, and acted as security manager, monitoring users and file
access. Examined advances in computer technology and software that increased
processing speed, improved efficiency, and provided interactive database
capabilities previously unavailable, and decided how to incorporate these
advances in HealtheForces. Because of the dynamic and complex nature of the
various data systems, demands of the users, and deployment requirements to
other medical treatment facilities, modified the programs and hardware
interface to meet the changing needs of the organization. Responsible for
organizing, planning and designing protocols for outcomes management
projects in conjunction with physicians, department chiefs, nursing staff,
and high to mid-level computer programmers. Conducted studies to provide
rapid response to urgent questions from the command group, as exemplified by
implementing an Anthrax survey tool days after the 9/11 attack. Reported
data on population health of the Walter Reed Health Care System, with
provider profiling and analysis of laboratory results for patient cohorts.
Showed that an outcomes management program has significant impact on the
control of pediatric asthmatics, adult diabetic, and cardiovascular risk
patients. The program won many awards, including recognition by The Emerging
Technology and Healthcare Innovations Congress (“TETHIE”) as the top
performer, winning the “Best in Show” and “Most Innovative Information
Technology in Hospital Community” awards; The Grace Hopper Government
Technology Leadership Award (“The Gracies”) in the award category of
“Leadership in the innovative application of information technology that
contributes to the advancement of scientific knowledge and its
applications;” and the Disease Management Association of America winner of
“Best Disease Management Program in the Military” demonstrating excellence
in the design, development, implementation and operation of disease
management program with success based on favorable outcomes.
Walter Reed Army Medical Center (02/01/1997 - 03/01/1999) - Operations
Research Analyst, Utilization Mgmt. Washington, District of Columbia United
Duties: As operations research analyst, assisted hospital leadership in
determining the impact of managed care practices. Utilization management is
a process by which patterns of health care delivery are analyzed and
modified to improve care and reduce costs. Utilization management is a
constantly evolving process as new ideas and methods are tested, rejected or
refined. Studies were aimed at determining the appropriateness of level of
care at the medical center, utilizing scientific inquiry and analysis to
assist decision-makers at the command level. The impact of managed care
practices were evaluated by examining the relationships among such variables
as case mix index, length of stay, re-admission rates and timeliness of
therapeutic interventions. The medical centers increasingly rely on DOD
information systems to integrate and support their business processes. Data
quality problems lead to bad decisions, monetary losses, and other negative
consequences for the military health care system. These information systems
and the quality of the data they contain affect perceptions of the quality
of care and services, and potentially jeopardize allocation of resources if
not addressed. Anticipated and prevented data problems and continuously
improved data quality by providing system-wide access of information to the
command, providers, and administrators. This work was of major importance to
the programs and operations of not only Walter Reed Army Medical Center,
DeWitt Army Medical Center, and Kimbrough Health Clinic, but also had
significant impact on vital DOD-wide health care information systems. DOD
medicine went through massive changes as congress mandated convergence of
Navy, Army and Air Force hospital resources, as well as adoption of standard
of care practices. Helped gather data to support these missions, as well as
automate the many routine tasks required by clinical providers to maintain
world-class healthcare for the soldiers and their families. Responsible for
designing, building, and implementing a clinical database for Utilization
Management InterQual data. Designed easy to use interfaces using a MS Access
database so that UM nurses could automate clinical information gathering.
Initiated an intranet Web site for Walter Reed by converting my workstation
to a server. Designed Web pages for clinical and administrative staff to
easily find reports, data, graphs, tables and presentations on the intranet.
Integrated several data sources into the database, including the
Retrospective Case-Mix Analysis System (RCMAS), Ambulatory Data System
(ADS), the Corporate Executive Information System (CEIS), and the DOD
Composite Healthcare System (CHCS). Determined the impact of changes in
managed care practices using trend analysis, regression and analysis of
variance. Reviewed the scientific literature and prepared summaries
pertinent to research involving utilization management practices. Published
a paper in Military Medicine (1999) that exemplified use of information
technology to drive change in a military healthcare system.
Walter Reed Army Medical Center (10/01/1996 - 02/01/1997) - Clinical
Research Associate, DCI Washington, District of Columbia United States
Duties: As a supervisory research psychologist, reviewed all addenda to
research protocols submitted to the Department of Clinical Investigation (DCI),
as part of the Research Review Service. Consulted with WRAMC staff on the
regulations and guidelines governing the conduct of research. Reviewed
research protocols, addenda, and related technical documents. Provided
initial written review of documents as part of the Research Review Service
pre-review team, ensuring congruency between the research plan, consent
form, budget, and appendices. Wrote memoranda informing principal
investigators of status from pre-review (forwarding the document to
committee “as is” or requesting revisions to the document prior to
forwarding to committee). Reviewed revised documents to ensure compliance
with the administrative, technical, statistical, scientific, and medical
requirements from review (pre-review, Clinical Investigation Committee,
Human Use Committee, Radiation Control Committee, etc). With this
information, recommended to the Chief, Research Review Service, when
protocols and addenda should be given approval to begin. Maintained weekly
tracking information on actions taken on protocols/addenda for entry into
the Research Review Service database. Compiled, wrote, and edited portions
of the WRAMC Annual Progress Report (APR), which is published each fiscal
year. Performed database search and compiled publication, abstract, and
presentation information for the APR. Supervised staff responsible for
publishing APR. Served as part of an audit team charged with the
responsibility of reviewing protocol files maintained by principal
investigators. Reviewed Human Use Committee minutes to ensure accuracy of
information and clarity of content. Reviewed all documents for the signature
of the Chief, Research Review Service. Served as representative of the
Chief, DCI on the Library Committee. Supervised staff responsible for the
approval and follow-up process for Emergency One-Time Use of an
Investigational New Drug. Automated the addenda process for reviewing,
editing, and approval. Used initiative in importing all research protocol
information into MS Access database for reporting and querying. Taught SPSS
for Data Analysis to researchers.
Walter Reed Army Medical Center (01/13/1992 - 09/30/1996) - Director,
Sleep Disorders and Respiratory Research Washington, District of Columbia
Duties: As director, responsibilities were to oversee both the clinical and
research missions of the laboratory. The clinical aspects involved directing
the diagnostic and therapeutic evaluations of all patients. After
appropriate testing guidelines had been identified for each patient, the
polysomnogram was reviewed for technical accuracy, and physicians contacted
for therapeutic patient management. Training was provided for pulmonary
fellows and staff regarding issues in sleep medicine. Over-saw the
Congressionally mandated evaluation and polysomnographic measurement of
sleep studies performed on Gulf War veterans, as part of the Gulf War
Syndrome included sleeping disorders.
The research aspects included planning and directing of research programs
focusing on the relationship between human sleep and breathing. Tasks
involved assisting, guiding and directing pulmonary fellows with approved
research protocols, as well as designing and implementing independent
research initiatives. Research activities included investigating the
relationship between stages of sleep, respiration, blood pressure,
esophageal and upper airway pressure in patients who snore and/or have
obstructive sleep apnea. Responses of patients to bilevel and continuous
positive airway pressure were evaluated in patients with obstructive sleep
apnea, with regard to improving efficacy of titration and long-term
compliance to treatment. The effects of body position and benzodiazepine
administration on severity of obstructive sleep apnea were examined as part
of a grant through Department of Defense. Initiated use of a catheter to
measure upper airway pressure in the diagnosis of obstructive sleep apnea
and upper respiratory resistance syndrome, a technique that continues as
standard of care in the WRAMC sleep center.
Created a database in DBIV to manage records of sleep disorders patients.
Served as co-investigator on several research grants, and the principal
investigator investigating position and sedative effects on snoring and
obstructive apnea patients. Analyzed several survey tools to collect patient
data about sleep, emotional health, and behavior. Mentored students in all
aspects of research, from experimental design, acquiring data, working with
patients, analyzing results, publishing and presenting abstracts at
scientific meetings. Reviewed literature on sleep disorders, and prepared
summaries of literature search. Prepared manuscripts for scientific
publications in peer-reviewed journals. Performed statistical analysis of
data including analysis of variance, regression, and chi square analysis.
Presented neural network analysis of heart rate variability as predictor of
sleep stage at the Southern Sleep Society annual meeting.
Spohn Hospital, Sleep Disorders Center (06/01/1989 - 09/30/1991) -
Clinical Polysomnographer Corpus Christi, Texas United States
Duties: Clinical coordinator of the 2 bed Sleep Disorders Center included
such duties as patient interviews, polysomnogram review, scoring and
interpretation, and therapeutic follow-up of patients. Assisted the medical
director in diagnosing and implementing various treatments for sleep
disorders, including obstructive sleep apnea, restless legs syndrome,
periodic movement disorder, insomnia, nocturnal seizures, narcolepsy,
idiopathic hypersomnolence, and parasomnias. Analyzed heart rate variability
using time series analysis in patients with obstructive sleep apnea.
Santa Rosa and St. Rose Hospitals (08/01/1988 - 06/01/1989) -
Research/Clinical Coordinator San Antonio, Texas United States
Duties: Responsible for polysomnogram review and analysis in a 4 bed sleep
laboratory. As part of the eligibility requirements for the Board Exam in
Sleep Medicine, interpreted and scored polysomnograms, interviewed patients,
and coordinated patient therapies with an accredited polysomnographer.
Collaborated with faculty from the University of Texas Health Science Center
in performing sleep research studies. Reviewed the scientific literature on
sleeping disorders and prepared summaries of the work. Trained physicians in
the interpretation and recording of polysomnographic records. Assisted the
Director in writing manuscripts for publication in scientific journals.
Analyzed data using statistical methods such as analysis of variance.
Electroneurodiagnostic Sleep Disorders Laboratory (01/01/1987 -
08/01/1988) - Director San Antonio, Texas United States
Duties: Managed the start-up of a 2 bed sleep laboratory with neurologists
in private practice. Developed and wrote software for collating and graphing
polysomnographic clinical data.
NIH Data Mining Multidisciplinary Research Team 2005 Oracle Life Science
User Group (OLSUG) since 2004
Mid Atlantic Oracle User Group since 2004
The Data Warehouse Institute since 2003
Sleep Research Society since 1985
Southern Sleep Society since 1982
Microsoft Certified Professional (SQL Server Administration) 2000
Elected to the Board of Directors, Southern Sleep Society President,
Southern Sleep Society (2000 - 2002) Secretary/Treasurer, Southern Sleep
Society (1997 - 2002)
Certification - Diplomate, American Board of Sleep Medicine (04/29/1991)
Certified as a Polysomnographer specializing in Clinical Sleep Disorders.
Hamm CK, Kennedy MR, Wu T, Phillips JS: An Operational Data Store for
Reporting Clinical Practice Guideline Adherence in Chronic Disease Patients:
17th IEEE Symposium on Computer-Based Medical Systems, 2004 Smith JR, de la
Peña A, Hamm C, Pressman M, Schubert J, Johnson J: Computer-Human Sleep
Stage/Event Scoring Agreement. American Sleep Disorders Association, 1999.
Hamm CK, Pierce JR, Phillips JS: Utilization Management Affects Health Care
Practices at Walter reed Army Medical Center: Analytic Methods Applied to
Decrease Length of Stay and Assign Appropriate Level of Care. Military
Medicine 164, 12:867, 1999.
Hamm CK, Watts JC, Chang AS, Rajagopal KR: Treatment-Dependent Changes in
Esophageal Pressure, Arousals, Apneas and Hypopneas during BiPAP Titration.
The Fourth International Symposium on Sleep and Respiration, 1996.
Hamm CK, Andrada TA, Dollinger TC, Watts JC, Land RD, Rajagopal KR:
Esophageal and Upper Airway Pressure During Nasal BiPAP Titration. Sleep
Research 1995, 24:242.
Hamm CK, Williams EM, Derderian SS, Rajagopal KR: Subjective Assessment of
Mood States in Sleep Apnea Patients. Sleep Research 1994, 23:262.
Derderian SS, Kumke KM, Hamm CK, Phillips YY, Rajagopal KR: Ambient
Ventilatory Response to Flow Restrictive Loading in Asthmatics with Chronic
Air Flow Obstruction. Am. College of Chest Physicians, 1994.
Kumke KM, Derderian SS, Hamm CK, Phillips YY, Rajagopal KR: The Effect of
Buspirone on Sleep in Stable Asthmatics with Severe Air Flow Obstruction.
Am. College of Chest Physicians, 1994.
Hamm CK, Derderian SS, Bates FA, Rayburn DB: Sleep Staging from Respiratory
Patterns Using a Back Propagation Neural Network. Am. Rev. Respir. Dis. (ATS
Hamm CK, Mahoney S. Spectral Analysis of Heart Rate in Patients with
Obstructive Sleep Apnea. Association of Professional Sleep Societies, June
Shade RE, Bishop VS, Haywood JR, Hamm CK: Cardiovascular and Neuroendocrine
Responses to Baroreceptor Denervation in Baboons. American Journal of
Physiology 258: R930-R938, 1990.
Hamm C, Derman S, Russell IJ. Sleep Parameters in Fibrositis (FS) Patients.
American Rheumatism Conference, June 15, 1989.
Bishop VS, Shade RE, Haywood JR , Hamm C: Sinoaortic Denervation in the
Nonhuman Primate. Am. J. Physiology. 1987.
Bishop VS, Haywood JR, Shade RE, Hamm C: Aortic Baroreceptor Deafferentation
in the Baboon. J. Appl. Physiol. 60(3):798-801, 1986.