Robert Rosofsky Health Information Systems Consulting
29 Waldo Road Milton, MA 02186	Home/Office: Mobile:	617-696-9415 617-680-1149
RRosofsky@HealthInfoSys.net	www.HealthInfoSys.net

SUMMARY

· Information technology project management · Software and system selection

· Requirements and systems analysis · Data management and analysis

CONSULTING ENGAGEMENTS

Massachusetts Health Quality Partners September, 2006 to Present

Watertown, MA

Consultant for development of systems to calculate health quality measure statistics in ambulatory care practices that install electronic medical record systems. Includes provision of expertise and guidance in the design and development of the reporting system, rules engine, and calculation and reporting database. Developed functional specifications for health care quality measures and technical specifications for generation of measure statistics from a health care data warehouse.

Delaware Health Information Network September, 2006 to Present

Dover, DE

Project Manager: Quality assurance management to oversee implementation of health record exchange utility among Delaware hospitals and health care providers. Responsibilities include monitoring of implementation vendor tasks and activities, review of implementation vendor deliverables (e.g. project plans, reports, technical documentation), providing guidance to project, and project risk management.

Masspro, Inc. June, 2006 to Present

Waltham, DE

Development, analysis, and production of data products and reports on healthcare quality improvement for Medicaid and Medicare beneficiaries. Topics include health quality measures for hospitalized pneumonia patients, comparative hospital profiles, improvement of discharge planning for hospitalized asthma and diabetes patients, assessment of Massachusetts’ Uncompensated Care Pool utilization, perinatal care improvement project, analysis of DOQ-IT Office Systems Survey on use of electronic medical records in physician offices, and generating health care quality measures for physician groups nationwide. Additional deliverables include project plans, reports, and technical specifications for computations and reporting.

National Center for Family Homelessness June, 2007 to October, 2007

Newton, MA

Data analysis and SAS programming for production of person-level summary statistics of state government-supplied medical services to recipients. This was part of a state government research study, to compare the cost and utilization of state services between recipients of housing assistance and a control group of beneficiaries without housing assistance. Summary statistics were generated from the following types of claims: inpatient, outpatient, professional services, dental, long term care, residential treatment centers, pharmacy, and durable medical equipment.

State of Maine Bureau of Health October, 2003 to July, 2007

Augusta, ME

- Contract management and quality assurance for development of an Integrated Public Health Information System. System integrates the National Electronic Disease Surveillance System, the Health Alert Network, an immunization registry, laboratory results reporting, and legacy systems. Project tasks include development of functional requirements and software specifications, writing Request for Proposals, vendor review, vendor selection, and vendor work activities monitoring

- Project manager for feasibility study of multiple potential systems for electronic birth and death registration. Conducted sessions to prioritize functional requirements, analyzed systems for functional capabilities, technical infrastructure, staffing, costs, and operations. Developed recommendations and reports for procurement strategy and a business plan for stakeholders.

- Project manager for requirements analysis of electronic birth and death registration system. Conducted Joint Application Development sessions, wrote specifications, surveyed systems from commercial software vendors and other states, and developed statement of work for request for proposal.

- Project lead in developing a Request for Proposals and a Proposals Evaluation Plan for modifying and enhancing an immunization registry system for use in Maine. Reviewed functional requirements documentation, wrote Statement of Work for RFP, reviewed and enhanced Proposals Evaluation Plan

Integrated Health Care Information Systems December, 2005 to March, 2006

Waltham, MA

Development of health care financial statistics based on summarization of health care claims, to enable a health insurer to respond to bids for insurance products and services.

Harvard Pilgrim Health Care August, 2005 to February, 2006

Wellesley, MA

Process improvement, SAS system enhancements, and documentation to improve performance efficiencies and functionality, for multiple financial analysis systems that are based on health care claims experience. Improvements have resulted in better than halving the time for generating statistical products.

John Snow, Inc.September, 2006 to Present December, 2004 to October, 2005

Boston, MA

- For the Wyoming Health Care Commission, researched Regional Health Information Organizations and health care community record exchange projects nationwide. Reported on scope of geographic area, institutional participation, health care data exchanged, technology utilized, organization and financing. Developed reports on health information technology standards.

- Evaluated process for selecting electronic medical records (EMR) systems by a physician’s health organization in rural part of New York State. Conducted key informant interviews, reviewed EMR selection methods and criteria, and wrote summary report of findings.

Pharmetrics, Inc. November, 2003 to July, 2005

Watertown, MA

SAS development in multiple projects, to analyze health care resource utilization and outcomes for selected studies. Projects include identification of health care events through claims and enrollment files, development of utilization and outcomes statistics, and reporting for decision-makers.

Massachusetts Health Assessment Partnership March, 2003 to April, 2004

Massachusetts Department of Public Health Boston, MA

Analysis of hospital discharge and birth certificate data to assess variation in birth outcomes by race and ethnicity between an HMO and a non-HMO population and among individual HMOs

Comprehensive Neuroscience January, 2003 to November, 2003

Waltham, MA

Process improvement, SAS system enhancements, and documentation to improve staff productivity, performance efficiencies, and system functionality, for a product that generates statistics and prescriber reports on behavioral pharmacy utilization. Improvements included increased system flexibility and performance. Customers are managed care, insurer, and Medicaid organizations.

Navin Associates June, 2003

Boston, MA

Survey instruments development, data analysis, and reports production, for survey of providers and policy makers of programs providing English instruction in Boston community settings, for English Speakers of Other Languages

University of Massachusetts Medical School April, 2002 to April, 2003

Worcester, MA

Conducted analysis to determine feasibility of establishing a state health workforce data center:

- Inventoried national and state agencies, licensing boards, professional organizations, and commercial resources to identify and evaluate health workforce data

- Conducted key informant interviews with selected personnel representing government, education, and health care industry groups within Massachusetts.

- Reviewed all other states’ systems for acquiring and managing health workforce information.

- Produced report summarizing data sources, gaps in information, and project plans for center implementation

Public Health Informatics Institute December, 2002

The Task Force for Child Survival & Development Decatur, GA

For the benefit of public health laboratories, created project plans to:

- Develop laboratory information management system evaluation criteria, evaluate software products, and publish results on the web

- Identify laboratory information management systems appropriate for evaluation

- Identify state procurement rules and regulations for procuring software products and services of laboratory information management systems

Vaccine Safety Datalink Project Department of Ambulatory Care and Prevention January, 2001 to November, 2002

Harvard Medical School and Harvard Pilgrim Health Care Boston, MA

- Data management and development using SAS:

- Extracted immunization, outpatient visit and laboratory records from electronic patient record system, clean data, and prepare analytical datasets for use by the Project and the Centers for Disease Control and Prevention

- Matched patient records to death certificate and birth certificate records

- Developed and implement quality assurance procedures for datasets

- Completed applications and justifications for researcher access to confidential birth certificate data from the Massachusetts Department of Public Health

- Analyzed HIPAA Privacy Rule for applicability to Project

Senior Business Systems Analyst February, 2002 to April, 2002

Executive Office of Environmental Affairs Boston, MA

For development of Children’s Pesticide Act Database:

- Develop and implement survey of private pesticide applicators, analyze data, and write report on findings

Training Specialist May, 2001 to December, 2001

CY Associates, Inc. Huntington, VT

Taught multi-day introductory and intermediate workshops in SAS software products

Systems Consultation April, 2001 to October, 2001

Massachusetts Public Health Association Boston, MA

- Developed RFP for new data network, Internet access, and telephone services, solicited and evaluated proposals, negotiated contracts with vendors, oversaw installations and configurations

Family Planning Program May, 2001 to July, 2001

Massachusetts Department of Public Health Boston, MA

- Developed system requirements and design specifications for billing and data reporting systems, managing information on client visits, education, outreach, and training activities

WORK EXPERIENCE

Director, Massachusetts Immunization Information System
July, 1994 to January, 2001	Bureau of Communicable Disease Control Department of Public Health, Boston, Massachusetts

Project manager for the development and implementation of a statewide system to track and manage childhood immunization records from primary health care provider sites

- Supervised technical contractors, programmer/analysts, data analysts, and technical support staff

- Developed functional and technical specifications for system and Requests for Proposals

- Developed budgets, cost analyses, and wrote grant applications to finance project

- Developed policy, procedures, and regulations for system

- Coordinated multiple relationships with health care providers, state and local public health agencies, and school health representatives, to promote system and obtain input into system design and implementation

- Investigated electronic data interchange technologies and medical practice management software products

- Promoted regulations in medical and public health professional organizations

- Chair, Program Managers Immunization Registry Workgroup: national committee of immunization program managers, to provide the Centers for Disease Control (CDC) input on national development of immunization registries and develop national standards for immunization registries

- Participant, Vaccine Identification Standards Initiative: national committee led by CDC, including immunization registry developers, FDA, and vaccine manufacturers, to standardize the coding and transfer of vaccine identification information from vaccine containers to electronic and paper information systems

Director of Data Systems
August, 1987 to July, 1994	Bureau of Family and Community Health Department of Public Health, Boston, Massachusetts

Manager for the development and maintenance of all information systems for government health agency

- Analyzed user needs, designed, and implemented complex systems in SAS for: data warehousing, paying health care claims, tracking clients in numerous health services programs, developing summary statistics, needs assessment, and program evaluation

- Developed new information system for breast and cervical cancer screening program

- Provided introductory and intermediate training sessions in SAS and coordinated training programs for users

- Served as Department’s SAS Software Representative

- Supervised seven programmer/analysts developing in SAS and FoxPro

- Developed programming standards, documentation standards, and technical policy for PCs and mainframe systems

- Developed Requests for Proposals and oversaw the installation, support, and use of PCS and networks

- Member of statewide board for procuring: (1) distributed WIC supplemental food voucher system combining PCs in community agencies and centralized database on mainframe system and (2) blanket microcomputer software contracts

- Investigated reproductive hazards practices in Massachusetts industries through survey project; developed instrument, sampling plan, data collection protocols and data analysis; co‑authored reports on survey results

Project Manager
December, 1986 to July, 1987	Bureau of Family and Community Health Department of Public Health, Boston, Massachusetts

Developed data systems, research protocols, and evaluation plans for public health programs

- Analyzed user needs, designed, programmed, and installed systems for public health service programs and, surveillance systems, including health programs in family day care programs and sexual assault counseling centers

- Analyzed data, reviewed, wrote reports, user and technical documentation

- Developed software utilities for data transfer from micro database to statistical systems

Data Systems Manager
February, 1983 to March, 1986	Registry of Vital Records and Statistics Department of Public Health, Boston, Massachusetts

Analyzed, designed, and programmed computer and microfilm systems for vital records and statistics agency

- Systems and feasibility analysis, software specifications development, and computer programs for multiple systems

- Coordinated tasks of multiple vendors, agency and physical plant personnel to install and configure systems

- Supervised computer programming and microfilm staff and trained users in software systems

- Wrote user manuals, handbooks for data providers, and technical documentation

- Analyzed, edited, and publicized statistical reports on health status

PUBLICATIONS & PRESENTATIONS

Rosofsky, R. “Look Me Up Baby: The whys and wherefores of table lookup.” Boston, MA: Presentation at Boston Area SAS Users Group Meeting, March, 2007.

Rosofsky, R. “All Programming is Local: Successfully Managing Local and Remote SAS Sessions.” Boston, MA: Presentation at Boston Area SAS Users Group Meeting, March, 2006.

Rosofsky, R. “Comparing SAS steps and PROC SQL: Coding and Performance.” Boston, MA: Presentation at Boston Area SAS Users Group Meeting, December, 2003.

Rosofsky, R. “Make Your Match and Capture the Data.” Boston, MA: Presentation at Boston Area SAS Users Group Meeting, March, 2002.

Rosofsky, R. “Managing parent consent in an immunization registry.” Saint Paul, MN: Presentation at All Kids Count Annual Immunization Registry Conference, April, 1999 and at Dallas, TX: National Immunization Conference, June, 1999.

Rosofsky, R. “Selecting records, maintaining uniqueness, and minimizing duplication in an immunization registry.” Saint Paul, MN: Presentation at All Kids Count Annual Immunization Registry Conference. April, 1999.

Rosofsky, R. “Elements of the core data set.” Atlanta: Centers for Disease Control and Prevention, State-based Immunization Information Systems Developer’s Workshop, 1995.

Rosofsky, R. “Identifier fields: Selection and matching of records.” Atlanta: Centers for Disease Control and Prevention, State-based Immunization Information Systems Developer’s Workshop, 1995.

Rosofsky, R. “Batch use of the EDITOR procedure to update SAS datasets.” San Francisco: 14th SAS User’s Group International Meeting, 1989.

Paul, M., Daniels, C., and Rosofsky, R. “Corporate response to reproductive hazards in the workplace: Results of the family, work and health survey.” American Journal of Industrial Medicine, 1989, 16, 267‑280.

Daniels, C., Paul, M., and Rosofsky, R. “Family, Work and Health: Survey Report.” Boston, Massachusetts, Department of Public Health, 1988.

EDUCATION

Master of Arts ‑ Psychology University of Michigan

Bachelor of Arts ‑ Psychology S.U.N.Y. at Buffalo