The U.S. Army Corps of Engineers intends to award a sole source contract to RJP Consulting Services. This is a special notice for commercial items prepared in accordance with the format in Federal Acquisition Regulation (FAR) Subpart 12.6, as supplemented with additional information included in the notice 6.302-1 Only one reasonable source available, and no other supplies or services will satisfy agency requirements and FAR Subpart 19.1306 HUBZone Sole Source Awards. However, any firm that believes it can meet this requirement may give written notification to the Contracting Officer within 7 days form the date of publication of this announcement. Supporting evidence must be in sufficient detail to demonstrate the ability to comply with the requirement. Responses received will be evaluated; however, a determination by the Government to compete the proposed procurement based on the responses to this notice is solely within the discretion of the Government. If no responses are received, the U.S. Army Corp of Engineers will proceed with awarding a firm-fixed price contract to RJP Consulting Services for applications analyst, non-personal professional services for assistance in the technology enhancement of the Navigation Data Centers (CEIWR-NDC) current Dredging Information System (DIS) and Lock Performance System (LPMS). These services will be provided to the NDC, Alexandria, VA. Point of Contact for this requirement is Damon Moore at
contact@example.gov, 7701 Telegraph Road, Alexandria, VA, 22315. STATEMENT OF WORK FOR APPLICATIONS ANNALYST AND DATABASE SUPPORT FOR LPMS AND DIS IS AS FOLLOWS: SCOPE OF WORK STATEMENT OF WORK FOR APPLICATIONS ANALYST AND DATABASE SUPPORT FOR LPMS AND DIS IS AS FOLLOWS: 1. BACKGROUND. The U.S. Army Corps of Engineers has the need to secure an applications analyst, non-personal professional services for assistance in handling help desk calls from lock and district personnel regarding data entry, data corrections, report requests and data requests; update system and user documentation as enhancements are made to the Data Quality Console, the Ad Hoc Builder Tool, the Schema Analyzer Tool and the Warehouse (LPMSW) tools of the Navigation Data Centers (CEIWR-NDC) current Dredging Information System (DIS) and the Lock Performance Monitoring System (LPMS, EXWS, LPMSW). In addition, the need extends to the requirement to have services for development and deployment of the LPMSW Oracle data warehouse. These services will be provided to the NDC, Alexandria, VA. DIS is currently a web based Oracle application. Data is entered into the database via a web browser by district dredging personnel. The program manager reviews the data for inconsistencies via web based reports, SQL queries and MS Access queries and reports. The database resides on WPC21 in Oracle 9iAS/9iDS. LPMS is currently a web based 9iAS/9iDS Oracle application. There are COBOL report programs that need to be converted to run in the data warehouse environment due to complexity and data set size. 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 to be made available thru the data warehouse. OMNI is currently a fat client based parallel data collection system that uses an Oracle database engine. The Rock Island and Huntington Districts are the operations bases for the districts that use the OMNI system. 2. SCOPE 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 CEEIS backbone. The knowledge shall include: Oracle 9iAS/9iDS and Oracle 10gAS/10gDS for Solaris and Linux; Windows 2k/XP/Vista desktop and Linux; SQL; Windows 2003 server; 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 Oracle APEX; HTML; XML; XSL; XSLT; KML; JavaScript, Java; PERL, PERL DBI, MYSQL, PHP and wireless protocol access; MS Access 2000; 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 AR 380-380 TB 18-100 Section 508 4. TASKS: The contractor personnel shall execute the following tasks as specified below: a. Respond to problems and questions submitted via email or phone regarding entering data (mechanics and rules), running reports and system access. (20%). b. Update both system and user documentation as required. Documentation is all electronic however, some of it is in a word processor and some other is in html, as required. (10%) c. Enter data from Navigation Notices into new table.(10%) d. Respond to Ad Hoc data requests from Corps offices, other government agencies and the public as required. (20%) e. Monthly, run the quality assurance reports and post them on the LPMS online News site. (5%) f. Provide technical support to diagnose and discover data discrepancies among the different data sources to include LPMS, EXWS, LPMSW, OMBIL, and OMNI; document the reason and offer recommendations for resolution. (20%) g. Provide technical support as needed to support the LPMS-OMNI merger. (10%) h. Be available for conference calls as required. (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 Officers 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. The contractor is not required to provide services on-site. Remote connection software (VPN), secure shell telnet software and instructions, if available, will be provided to the contractor. The production systems are 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 H total 100% for the project. As many tasks are run in parallel, a monthly invoice of work performed may be submitted for acceptance by the COTR as listed in paragraph 9. Due to unforeseen circumstances and requirements from HQ, the weighting of some tasks may be changed or deleted by the COTR with no consequence to the contractor. 9. POINTS OF CONTACT. The COTR for the execution of this task order is Donna Wood, CEIWR-NDC, 703/428-6154 and the administrative point-of-contact is Ms. Virginia Pankow, CEIWR-NDC, 703/428-9047. 10. GOVERNMENT FURNISHED EQUIPMENT. Not applicable. 11. SECURITY REQUIREMENTS. It is required that the mandatory security clearance and access approvals for all contract personnel be in place the day of award. 12. CDRLs and DIDs. Not applicable. 13. PERIOD OF PERFORMANCE: 365 DAYS FROM DATE OF AWARD.
