SOLICITATION NOTICE
70 -- ALBHDB based Crystal Reports Support
- Notice Date
- 9/2/2009
- Notice Type
- Combined Synopsis/Solicitation
- Contracting Office
- Bureau of Reclamation - UC - Albuquerque Area Office 555 Broadway NE Suite 100 Albuquerque NM 87102
- ZIP Code
- 87102
- Solicitation Number
- R09PS43078
- Response Due
- 9/11/2009
- Archive Date
- 9/2/2010
- Point of Contact
- Albert J Richard Purchasing Agent 5054623568 arichard@usbr.gov;
- E-Mail Address
-
Point of Contact above, or if none listed, contact the IDEAS EC HELP DESK for assistance
(EC_helpdesk@NBC.GOV)
- Small Business Set-Aside
- Total Small Business
- Description
- This is a combined synopsis/solicitation for commercial items prepared in accordance with the format in Subpart 12.6, as supplemented with additional information included in this notice. This announcement constitutes the only solicitation; offers are being requested and a written solicitation will not be issued. Solicitation number R09PS43078 is issued as a request for quotation (RFQ). The solicitation document and incorporated provisions and clauses are those in effect through Federal Acquisition Circular 05-36. This is a total small business set-aside under NAICS 541511 with an associated small business size standard of $25M. ALBHDB based Crystal Reports Support Contract Statement of Work (SOW) Rio Grande and Pecos River operations have grown far too complex to be managed simply on the basis of operator knowledge and experience. Computer models are required to simulate water management options effects, by simultaneously considering all relevant resources and constraints (data), and provide optimized management scenarios for implementation. Reclamation does not have sufficient internal resources (personnel) to both utilize the current state of models for water management, and manage and report the data generated. Reclamation has responsibility for water accounting for the Rio Grande Compact. This and other data must be stored and reported according to the law. The Pecos River basin operations is also becoming complex, with many agreements and portions of water to account for, including ESA water. Data management and reporting is considered a short term specialized part-time need that does not warrant recruitment of a permanent position within Reclamation. Reclamation has concentrated on use of existing models and relies upon experienced contractors for ongoing data storage, manipulation and reporting support. This contract requirement is a solicitation for a contractor with significant experience using RiverWare? / URGWOM to provide HDB based Crystal Reports? custom report design, development and use support. Task 1 (125 hours) -Continue water accounting report development: Contractor will support continued development of paper based, electronic file (pdf), and web-based accounting reports for customers and annual reporting requirements using the Crystal Reports? software package and the existing Oracle Hydrologic Database (HDB). This work may include any or all of the following components: oCoding complex database queries within custom designed Crystal Reports? reports, using the current version of Crystal Reports? (Crystal Reports? 2008)oFinalize Contractor Status report per Reclamation requirementsoCause or allow existing / historic data to be stored in HDB for use in URGWOM oFinalize Notes report per Reclamation requirements oContinue to assist Reclamation as needed to use Crystal Reports? Task 2 (180 hours) -Data Storage - Work with Reclamation to begin integrating Rio Grande River basin operations data into ALBHDB: Contractor will support Reclamation personnel from the Upper Colorado Regional Office in creating computations for DECODED Rio Grande basin data. This work may include any or all of the following components: oCause or allow existing / historic data to be stored in HDB for use in URGWOM oCause or allow new daily data to be stored in HDB for use in URGWOMoImplement a mapping from HDB sites and datatypes to RiverWare? objects and slots using ALBHDB's generic mapping facilityoBased on inventory of operations data, begin creating computations, using HDB's Computation Processor protocol, to aggregate and calculate needed data points Task 3 (65 hours) - Data Storage and Reporting - Work with Reclamation to begin integrating Pecos River basin operations data into ALBHDB: Contractor will support Reclamation personnel from the Upper Colorado Regional Office in creating computations for DECODED Pecos River and reservoir data. This work may include any or all of the following components: oCause or allow existing / historic data to be stored in HDB for use in a Pecos RiverWare? modeloCause or allow new daily data to be stored in HDB for use in a Pecos RiverWare? modeloDraft conceptual Crystal Reports? reports for the Pecos basin per Reclamation requirements Task 4 (30 hours) - Provide training on reporting tools: The Contractor will provide one hands-on training, including individual assistance with connections to HDB Oracle database, on use of custom Crystal Reports? developed in Task 1, including use of Crystal Reports? automated web reporting capability - date and time to be mutually acceptable. Contractor must be able to successfully access (query) and modify, as needed, ALBHDB database structure, tables, views, metadata, and be knowledgeable of and capable of successfully using appropriate database utilities, including the Computation Processor. The provision at 52.212-1, Instructions to Offerors-Commercial applies to this acquisition. By the provision at 52.212-2, Evaluation-Commercial Items, technical capability of equipment and labor to meet the described government need, and price will be evaluated equally. It is advised that a completed copy of the provision at 52.212-3, Offeror Representations and Certifications-Commercial Items be submitted along with the offer; the provision may also be completed online by accessing http://orca.bpn.gov. The clause at 52.212-4, Contract Terms and Conditions-Commercial Items applies. No addenda are enclosed. The clause at 52.212-5, Contract Terms and Conditions Required to Implement Statutes or Executive Orders-Commercial Items, applies to this acquisition. The following additional FAR clauses also apply: 52.204-06, Data Universal Numbering System (DUNS) Number; 52.204-07, Central Contractor Registration; 52.219-6, Notice of Total Small Business Set-Aside; 52.222-3, Convict Labor; 52.222-19, Child Labor-Cooperation with Authorities and Remedies; 52.222-21, Prohibition of Segregated Facilities; 52.222-26, Equal Opportunity; 2.222-35, Equal Opportunity for Special Disabled Veterans, Veterans of the Vietnam Era, and Other Eligible Veterans; 52.222-36, Affirmative Action for Workers with Disabilities; 52.222-41, Service Contract Act of 1965, as Amended (USDOL WD No. 1969-0115, Revision No. 33 applies); 52.222-44, Fair Labor Standards Act and Service Contract Act-Price Adjustment; and 52.237-01 Written offers on a company letterhead with contact information are due no later than 09/11/2009 1600 hrs. by mail to or in person at Bureau of Reclamation, 555 Broadway Blvd. NE, Albuquerque, NM 87102, by facsimile at 505-462-3796, or by electronic mail to arichard@usbr.gov. For information regarding this Request for Quotation, please contact enter Albert Richard phone 505-462-3568.
- Web Link
-
FBO.gov Permalink
(https://www.fbo.gov/notices/7935749fe1033ee817be83ee6dcfb1c8)
- Record
- SN01937345-W 20090904/090903000304-7935749fe1033ee817be83ee6dcfb1c8 (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 |