L -- Technical Support Services for Executive Information System

The National Institutes of Health, Warren Grant Magnuson Clinical Center research facility of the National Institutes of Health serves the patient care and clinical research needs of the NIH intramural research program. Its mission is to provide patient care services, training, and the environment in which NIH clinician-scientists creatively translate emerging knowledge into better understanding, detection, treatment, and prevention of human diseases. On an annual basis, the Clinical Center admits approximately 7,000 patients and supports over 100,000 outpatient visits. Patients seen at the Clinical Center come from all over the world to participate in research protocols aimed at developing new knowledge of disease processes, new treatments, and expanded comprehension of basic biologic systems. The office of Financial Resources Management (OFRM), CC provides efficient and effective financial management of programs that fully support the CC and the NIH in meeting its goals and objectives. OFRM is responsible for managing all of the CC financial operations to include: developing and monitoring the annual hospital operating budget; identifying Institute cost and volume utilization information; developing impact assessments for new protocols and initiatives; performing financial and workload audit and control functions; defining business requirements for new clinical information systems and supporting modules that document and monitor patient care; and developing presentation and support materials for various NIH and hospital governing bodies. The strategic goal and the continuation of the goal is that the CC/OFRM began the design and development of a hospital Executive Information System (EIS) to allow participating NIH Institutes the ability to quickly access and analyze information across a broad range of hospital functions. The initial phase of the EIS initiative was to develop patient census dashboards for hospital and IC leadership. Each dashboard contains hospital patient statistics including inpatient and outpatient census, admissions, average daily census, etc. This phase of the initiative was achieved in January 2004. Simultaneously a continuation of the development started in the creation of a hospital executive dashboard with key organizational performance indicator which was implemented in April, 2004. The completion of this pilot dashboard primarily focused on maintaining and the current system and dashboards, with some additional evaluation to include clinical service metrics. In 2005, the system underwent a major upgrade to a new software version and the main EIS dashboards were re-engineered for improved speed. Also, the patient census dashboard was expanded to include new content, including Average Length of Stay (ALOS), patient discharge, and new patient count information. In the beginning of 2006, project work included much-needed enhancements to the existing system architecture and database machines; a complete re-design of the system?s ad-hoc reporting module; and training users. In mid 2006, EIS development work included expansion of the system to include Central Hospital Supplies (CHS)/Lawson cost data in both CHS Dashboard and CHS Ad-Hoc Reporting Modules and training users. The current phase of EIS work began in September. This phase includes expansion of the EIS to include new outpatient visit related data elements from Scheduling.com for ad-hoc reporting; expansion of the CHS/Lawson module and deployment to additional users; standardization of hospital locations across projects for consistent reporting; creation of a monitoring project; research into making the system Section 508-compliant; and training users. The next phase of EIS work is slated to begin in February 2007. This phase will include expansion of the EIS to include patient quality performance indicator information, specifically in a dashboard; addition of off-site outpatient visits to the existing census data in the system; standardization of hospital locations in the Census Dashboard and Census Ad-Hoc Modules for consistent reporting; developing and deploying a data dictionary project; and training users. Evaluation Criteria: It is essential that the consultant possess the below certification(s), skills, training, and experience. These are required and essential to the EIS project. The below necessary certification(s) skills training and experience must be possessed by the individual proposed to perform the work. Also, the below must be possessed by an individual currently employed by the company offering the proposal. 1) The consultant must be a MicroStrategy Certified Engineering Principal (MCEP). The certification must be current and not expired. Applicants must provide proof of certification, such as copies of certificates obtained. 2) Five years of experience in the below specialty areas: a) Database Design; b) SQL Optimization Procedures (Must be capable of writing stored procedures in SQL; c) Data Model Design; d) Application/Metadata Design; e) HTML Document Design; f) HTML Document Design; g) Web Customization Using .NET and Changing Application Workflow; h)System Administration, specifically Command Manager, Object Manager, and Enterprise Manager; and i) OLAP services. 3) Knowledge of and experience building ETL scripts using stored procedures in Sybase and Microsoft SQL Server 2000. 4) Also, it is required that the consultant be trained by MicroStrategy in the below skill areas. The training should have been received within the past three (3) years to include Data Model Design, Application/Metadata Design; Advanced Reporting Design & HTML Document Design; Web Customization Using .NET and System Administration, specifically Command Manager, Object Manager, and Enterprise Manager. THIS IS A COMBINED SYNOPSIS/SOLICITATION FOR COMMERCIAL SERVICES PREPARED IN ACCORDANCE WITH THE FORMAT IN FAR SUBPART 12.6 AND FAR PART 13.5 THE REQUEST FOR QUOTE WILL BE IN ACCORDANCE WITH SIMPLIFIED ACQUISITION PROCEDURES AS SUPPLEMENTED WITH ADDITIONAL INFORMATION INCLUDED IN THIS NOTICE. THIS ANNOUNCEMENT CONSTITUTES THE ONLY SOLICITATION: PROPOSALS ARE BEING REQUESTED AND A WRITTEN SOLICITATION WILL NOT BE ISSUED. The contractor shall provide all labor, design tools, equipment, material and other items and services necessary for EIS Enhancements, Development and Training. It is expected that this Request for Quote and the NAICS code for this requirement is 541511. The Government anticipates awarding a firm fixed price Purchase Order for a four month period of performance with (2) successive options. Estimated Start Date of Project February 5, 2007 through May 25, 2007. This period allows for 16 full 40-hour work weeks. Firms responding should indicate whether they are a small business. The services to be procured under this announcement requires that a consultant must be available on-site to attend meetings and work with team members under the following tasks: 1) Research and Implementation of Patient Quality Performance Indicators Dashboard; Expansion and Deployment to Additional Users (Data Model Re-Design ETL Process Development and Changes, Micro Strategy Object Creation, Micro Strategy Report Development, HTML Document Dashboard Creation and Further Modifications to Existing Web Customizations); 2) Expansion of Current Census Dashboard and Census Ad-Hoc Reporting Modules or Implementation of New Modules for Inclusion of Additional Data (Off-Site Census) from Scheduling.com (Data Model Re-Design, ETL, Process Development and Changes, Micro Strategy Object Creation, Micro Strategy Report Development, HTML Document Dashboard Integration/Creation, and Further Modifications to Existing Web Customizations); 3) Implementation of Standardized Hospital Location Dimension to Census Modules (Data Model Re-Design, ETL Process Development and Changes, and Micro Strategy Report Changes/Development); 4) Creation and Implementation of Data Dictionary Project (Data Model Re-Design, ETL, Process Development and Changes, Micro Strategy Object Creation, Micro Strategy Report Development, HTML Document Dashboard Integration, and Further Modifications to Existing Web Customizations). EIS Training ? Teach ?Introductory Web Reporting?, ?CHS Reporting?, and ?Advanced Web Reporting? Classes to Web Professional End Users, as needed; Update All Training Presentations/Manuals to Improve Material. Option A Tasks: Development ? Research and Implementation of Budget Dashboard and Ad-Hoc Reporting Modules (Data Model Re-Design, ETL Process Development/Changes Micro Strategy Object and Report Development, HTML Document Dashboard Creation, and Further Modifications to Existing Web Customizations). Enhancements/Upgrades ? Rework of Central Hospital Supplies (CHS) Data through Hospital Statistics System (HSS) Database. Operational Support ? Maintenance, Troubleshooting, Infrastructure Support/Changes. Training ? Teach All classes; Revise all material. Option B Tasks ? Development ? Research and Implementation of Weighted Outpatient Visits Dashboard and Ad-Hoc Reporting Modules (Data Model Re-Design, ETL Process Development/Changes, Micro Strategy Object and Report Development, HTML Document Dashboard Creation/Changes, and Further Modifications to Existing Web Customizations). Enhancements/Upgrades. Operational Support ? Maintenance, Troubleshooting, Infrastructure Support/Changes. Training- Teach all classes; revise all material. Project Deliverables & Reporting Requirements: 1) Updated Project Plan (Within 5 days of Project Kickoff) 2) Project Design Document Detailing Agreed ? Upon Requirements 3) All Product Deliverables described in Weekly meetings with Project Team; status reports; evaluation of progress compared to the Project Plan; demonstration of Key Tasks Completion (see Key Tasks Above); Summary Document Delivered at Project End; Written notification of any changes to Project Plan Task Completion; and Final payment upon Government Approval of Completion of All Tasks. YOUR QUOTE MUST INCLUDE YOUR BASIC AWARD PRICING ALONG WITH THE 2 OPTION TASKS A AND B PRICING FOR THE NEXT TWO PHASES. The Government reserves the right to make an award on the best-value determination. The closing hours and date for receipt of quotes is 3:00pm local prevailing time, January 31, 2007. All submissions must be transmitted in written form. Electronic mail and/or fax documents are acceptable. All responses and any questions or inquiries you may have regarding this announcement, please direct to Ms. Deborah Britton at the address listed in this synopsis, via email at contact@example.gov, phone 301/594-5914 or fax 301/435-8675.