Resume

Dr. Carolyn Hamm, Ph.D.

 

 

 

We only do consulting. 

No permanent job inquiries please.

 

Click here for Consulting rates.

 

 

BIOGRAPHY

 

 

 

 

 

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.

 

 

 


EDUCATION

Rollins College B.A. 1972-1976 Pre-med
University of Texas at Arlington Ph.D. 1976-1984 Experimental Psychology
University of Texas Health Science Center, Dallas NRSA Pre-doc trainee 1981-1983 Physiology
Southwest Foundation for Biomedical Research NRSA Post-doc trainee 1984-1987 Behavioral Medicine

 

WORK SUMMARY

 

Over the past 15 years Carolyn has held management positions in biomedical research across several disciplines, including scientific research, clinical medicine, and information technology.


COMPUTER PROFICIENCY


 

Databases               Oracle  9i & 10g
 

Tools                         SAS statistical software and Oracle data mining tools

                                    Oracle Discoverer and HTMLDB



PROFESSIONAL EXPERIENCE

 

Walter Reed Army Medical Center (02/01/2003 - Present) - Chief, Decision Support Center Washington, District of Columbia United States

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 States

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 States

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 United States

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.
 

ADDITIONAL INFORMATION:

Memberships:
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.



Publications:
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 1993).

Hamm CK, Mahoney S. Spectral Analysis of Heart Rate in Patients with Obstructive Sleep Apnea. Association of Professional Sleep Societies, June 27, 1990.

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.