SOLICITATION NOTICE
L -- Technical Support Services for Executive Information System
- Notice Date
- 9/8/2006
- Notice Type
- Solicitation Notice
- NAICS
- 541511
— Custom Computer Programming Services
- Contracting Office
- Department of Health and Human Services, National Institutes of Health, Clinical Center/Office of Purchasing & Contracts, 6707 Democracy Blvd, Suite 106, MSC 5480, Bethesda, MD, 20892-5480
- ZIP Code
- 20892-5480
- Solicitation Number
- RFQ-CC-82111
- Response Due
- 9/22/2006
- Archive Date
- 10/7/2006
- Description
- 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. The next phase of EIS work is slated to begin in October 2006. This phase will include 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 (see details below). C) Description of Services The work functions outlined below are essential to the project. The consultant must be available on-site to attend meetings and work with other team members. Services to be performed by the consultant are outlined below. EIS Development V Key Tasks Expansion and Implementation of Census Ad-Hoc Reporting Module to Include Additional Subject Areas/Data Elements (Appointment Type and Resource/Researcher) from Scheduling.com (Data Model Re-Design, ETL Process Development and Changes, and MicroStrategy Object Creation) Expansion of CHS/Lawson Dashboard; Expansion and Deployment of CHS/Lawson Ad-Hoc Reporting Module to Additional Users; Addition of Locations IDs; Evaluation and Possible Implementation of Adding Non-Stock Item Costs to CHS/Lawson Modules (Data Model Re-Design, ETL Process Development and Changes, MicroStrategy Object Creation, MicroStrategy Report Development, HTML Document Dashboard Integration, and Further Modifications to Existing Web Customizations) Research and Implementation of Standardized Hospital Location Dimension (Data Model Re-Design, ETL Process Development and Changes, and MicroStrategy Report Development) Creation and Implementation of Monitoring Project; Creation of Log File Table Across All EIS Data; Project Set-Up; Implement Daily 30-Day Inpatient Day Data Load (Data Model Re-Design, ETL Process Development and Changes, and MicroStrategy Object Creation) Research and Document Level of Effort to Achieve Compliance with Section 508 Standards EIS Training V Key Tasks Teach Introductory Web Reporting and Advanced Web Reporting Class to Web Professional End Users; Update Training Presentation/Manual to Improve Material and Include CHS/Lawson Module Information D) Project Deliverables & Reporting Requirements Project deliverables and reporting requirements are detailed below. Updated Project Plan (Within 5 Days of Project Kickoff) Project Design Document Detailing Agreed-Upon Requirements All Product Deliverables Described in Section C Description of Services 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 Final Payment Upon Government Approval of Completion of All Tasks E) Estimated Period of Performance Estimated Start Date: September 28, 2006 Estimated End Date: February 2, 2007 This period allows for 17 full 40-hour work weeks and includes approximately one week of downtime. F) Technical Requirements 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 Engineer (MCE). 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: Database Design SQL Optimization Procedures (Must be capable of writing stored procedures in SQL) Data Model Design (MicroStrategy 7.0 & 8.0) Application/Metadata Design (MicroStrategy 7.0 & 8.0) HTML Document Design/Upgrade (MicroStrategy 7.0 & 8.0) Web Customization Using .NET and Changing Application Workflow (MicroStrategy 7.5 & 8.0) System Administration, specifically Command Manager, Object Manager, and Enterprise Manager (MicroStrategy 7.0 & 8.0) 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 years. Data Model Design (MicroStrategy 7.0 & 8.0) Application/Metadata Design (MicroStrategy 7.0 & 8.0) Advanced Reporting Design & HTML Document Design (MicroStrategy 7.0 & 8.0) Web Customization Using .NET (MicroStrategy 7.5 & 8.0) System Administration, specifically Command Manager, Object Manager, and Enterprise Manager (MicroStrategy 7.0 & 8.0) Evaluation Criteria: The following evaluation criteria will be used to evaluate offers: a) Technical Support Approach; b) Personnel Experience; c) Corporate experience; d) Price 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 following clauses and provisions Representation and Certification for Offerors (Commercial Services) and ACH Form can be requested prior to submission of proposal to be forwarded to offeror. 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. Firms responding should indicate whether they are a small business. 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 on September 22, 2006. 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 dbritton@cc.nih.gov, phone 301/594-5914 or fax 301/435-8675.
- Place of Performance
- Address: National Institutes of Health, 6707 Democracy Blvd Suite 201, Bethesda, MD
- Zip Code: 20892-5480
- Country: UNITED STATES
- Zip Code: 20892-5480
- Record
- SN01137478-W 20060910/060908220418 (fbodaily.com)
- Source
-
FedBizOpps Link to This Notice
(may not be valid after Archive Date)
| FSG Index | This Issue's Index | Today's FBO Daily Index Page |