AWARD
R -- To provide technical and analytical support services for the continuation of the transition from two lock data input methods into a single standard lock data input system
- Notice Date
- 11/7/2011
- Notice Type
- Award Notice
- NAICS
- 541511
— Custom Computer Programming Services
- Contracting Office
- USACE HEC, Ft. Belvoir, ATTN: CEHEC-CT, 7701 Telegraph Road, Alexandria, VA 22315-3860
- ZIP Code
- 22315-3860
- Solicitation Number
- W912HQ-11-T-0038
- Response Due
- 9/23/2011
- Archive Date
- 12/7/2011
- Point of Contact
- Susan Tolliver, 703-428-6117
- E-Mail Address
-
USACE HEC, Ft. Belvoir
(susan.tolliver@usace.army.mil)
- Small Business Set-Aside
- N/A
- Award Number
- W912HQ-11-P-0215
- Award Date
- 9/23/2011
- Awardee
- RJP CONSULTING SERVICES (785684346) <br> 1105 TILDEN AVE<br> UTICA, NY 13501-3341
- Award Amount
- $149,000.00
- Line Number
- CLINs 0001-0011
- Description
- 1. BACKGROUND. The U.S. Army Corps of Engineers has the mission to operate and maintain the Congressionally authorized navigation channels in a safe, efficient and environmentally responsible manner. Robust navigation data are the foundation of good information, analysis and decisions and the Corps has relied on the Lock Performance Monitoring System to supply the fundamental data to support these navigation decisions. To meet the increasing data needs of the Corps and other Federal agencies the Corps Institute for Water Resources, Navigation Data Center (CEIWR-NDC) has identified the need to secure applications analyst, non-personal professional services for assistance in the technology development of the Lock Performance Monitoring System (LPMS). These services will be provided to the NDC, Alexandria, VA. This work is a follow up to the recent merger of two data input methods into a single standard data input system. The merger work is being executed by RJP Consulting Services, Utica, NY. LPMS is a web based 10gR2 Oracle application. Data is entered locally by lock personnel via the web and edited online via PL/SQL and Javascript programs. Online reports are also available. More complex reports using larger data sets need are available thru the Oracle data warehouse (LPMSW) and pre-2000 archived data (EXWS). The database is housed in a Corps data processing center and is subject to all DoD, Army, and Corps security requirements. All personnel working on the database are required to meet DoD, Army, and Corps security requirements and clearances. 2. SCOPE The scope of this work is to provide technical and analytical support services for the continuation of the transition from two lock data input methods into a single standard lock data input system. This work focuses on the ability to provide data throughout the Corps and federal agencies as well as the navigation industry and public. The work requires knowledge of the employment of all hardware, software and services in the area of Oracle database configuration and design, to both Intranet/Internet and screens for both data entry and reporting across the Corps of Engineers network backbone. The knowledge shall include: Oracle versions 10gAS/10gDS, 11gR2 and 12g for Solaris and Linux; Windows XP/Windows 2007 desktop and Linux; SQL; Analytical SQL, Oracle Web tools including the Apache Listener; current versions of Oracle Developer and Designer; Oracle PL/SQL; Oracle Spatial; Oracle Map-viewer; Oracle APEX; Oracle Text; Oracle JVM; Oracle XDB; Oracle APEX; HTML; HTML 5; XML; XSL; XSLT; KML; Javascript, Java; PERL, PERL DBI, MYSQL, PHP, AJAX and wireless protocol access; MS Access 2007; Location mapping services; Google/Earth mapping service and client. In addition, knowledge about RFID, TCP/IP, capture and transmission of NMEA data and integration with an Oracle application is required. 3. APPLICABLE DOCUMENTS. AR 25-1 Army Knowledge Management and Information Technology AR 380-380 Automation Security\ TB 18-100 Army Automation Life Cycle Management Section 508 amendment to the United States Workforce Rehabilitation Act of 1973 4. TASKS The contractor personnel shall execute the following tasks as specified below. The percentage for each task is an estimate of resources required for the task. 4 a) Maintain development and test environments for/accessible by the Government in a Solaris 10/Linux hardware environment for LPMS and DIS in ORACLE versions 9i, 10gR2/10gAS, 11gR2 and 12g; Oracle packages APEX, Spatial, Open Source (i.e. Perl, PHP, MySQL, AJAX, Wiki etc. ), OraTweet. Provide additional development environment to support mobile applications development. (10%) b) Develop and deploy applications for distribution of LPMS data through Mobile Media sites such as Twitter, Facebook, RSS, iOS, Android etc. (10%) c) Develop and deployment Android-based voice-enabled applications for access to LPMS data. (3%) d) Support outward-facing computer to support tasks B and C. (10%) e) Stage OMNI data for LRD, MVR1 and MVR2 into the LPMS data warehouse or EXWS and provide an adhoc query capability. (20%) f) Upgrade the current LPMS data warehouse reports to run under APEX (10%) g) Provide a drill-down capability from existing LPMS data warehouse reports to provide reconciliation analysis for data variances. (10%) h) Investigate Oracle technology to support availability of LPMS on a 24/7 basis. (2%) i) Develop screens and reports to support the collection of Navigation Notices. This includes development of the appropriate software for data distribution to the USCG. (20%) j) Investigate and prototype emerging technologies to use tablets for LPMS data entry. (5%) 5. ACCEPTANCE CRITERIA. Services provided will be evaluated on the contractor's completion of the tasks outlined above. 6. PROGRESS REPORTING. The contractor shall inform the Contracting Officer's Technical Representative (COTR) of any problems that cannot be resolved within (1) business day. The contractor must provide the COTR with alternatives to reach resolution for problems of the magnitude stated above. The contractor shall report monthly on the number of hours of effort expended, and description of each task completed. 7. PLACE OF DELIVERY. Upon request local services may be required on site. Otherwise connection software (VPN), secure shell telenet software and instructions, if available, will be provided to the contractor. The production system is on WPC21 and WPC56 in Portland, OR and production work must be done in this environment. Development and test environments are maintained by the contractor. 8. DELIVERY SCHEDULE. The total period of performance shall be 365 days from the notice to proceed. Tasks A thru J total 100% for the project. Each task is weighted percentage of the total project and maybe invoiced as tasks are accepted as complete.. As some of these tasks can be done in parallel, a monthly invoice of work performed may be submitted. 9. GOVERNMENT FURNISHED EQUIPMENT. Not applicable. 5 10. SECURITY REQUIREMENTS. It is required that the mandatory security clearance and access approvals for all contract personnel be in place the day of award. 11. CDRLs and DIDs. Not applicable. 12. PERIOD OF PERFORMANCE. 12 MONTHS FROM DATE OF AWARD.
- Web Link
-
FBO.gov Permalink
(https://www.fbo.gov/spg/USA/COE/DACA72/W912HQ-11-T-0038/listing.html)
- Record
- SN02619595-W 20111109/111107234857-f00530f72f0951aa99fdba62d350fcbc (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 |