SPECIAL NOTICE
R -- APPLICATIONS ANALYST AND DATABASE SUPPORT FOR LPMS AND DIS
- Notice Date
- 9/13/2010
- Notice Type
- Special 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-SN-10-0018
- Archive Date
- 12/12/2010
- Point of Contact
- Eileen Spears, 703-428-6384
- E-Mail Address
-
USACE HEC, Ft. Belvoir
(eileen.m.spears@usace.army.mil)
- Small Business Set-Aside
- N/A
- Description
- 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 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 10 days from 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 Corps of Engineers will proceed with awarding a firm-fixed price contract to RJP Consulting Services for Professional Services to provide technical support for applications analyst and database support for Dredging Information System (DIS), the Lock Performance Monitoring System (LPMMS) and the Oracle Lock data warehouse. These services will be provided to the Institute of Water Resources, Alexandria, VA. The Point of Contact for this requirement is Eileen Spears at Eileen.M.Spears@usace.army.mil, 7701 Telegraph Road, Alexandria, VA 22315. SCOPE OF WORK 1.BACKGROUND. The U.S. Army Corps of Engineers has the need to secure an applications analyst, non-personal professional services for assistance in the technology maintenance of the Navigation Data Centers (CEIWR-NDC) current Dredging Information System (DIS) and the Lock Performance Monitoring System (LPMS). In addition, the need extends to the requirement to have services for maintenance of a historical Oracle data instance and an Oracle data warehouse. These services will be provided to the NDC, Alexandria, VA. The Lock Performance Monitoring System (LPMS) and the Dredging Information System (DIS) are national databases maintained by the Corps of Engineers to provide data and information necessary for the efficient management of Congressionally authorized navigation projects, to meet performance requirements of the Presidents Management Agenda (PMA) and the Program Assessment Rating Tool (PART), and to respond to specific public laws. It is essential that the database be maintained and upgraded to meet user needs for data entry as well as data and information output for decisions and budget considerations. 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, Business Object and MS Access queries and reports. The database resides on WPC21 in Oracle 10gAS/10gR2. LPMS is currently a web based 9i 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 data warehouse (LPMSW). 2. SCOPE The scope of this work is to provide technical and analytical support services to operate and maintain the navigation databases of LPMS, DIS and the lock data warehouse. 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 9iAS/9iDS, Oracle versions 10gAS/10gDS, 11gR2 and 12g for Solaris and Linux; Windows XP/Vista/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, Business Objects 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. The required security clearances and access approvals for contract personnel must be in place the day of award. The testing of all database and interface modifications will be performed on hardware and software provided by the contractor with access provided to the Corps. 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. 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 (12%). b.Continue rewriting LPMS/DIS applications to eliminate Oracle Designer API generated packages dependencies to native dynamic SQL to include traffic flow and record duplication. Convert Designer generated forms, reports and screens to Oracle APEX forms, reports and screens with a web 2.0 look and feel. (15%) c.Optimize LPMS data entry performance including reducing online data to current and last 2 years of data, providing multiple backup sources of archived data. (3%) d.Modify constraints and triggers to align and enforce data integrity rules as required by the business lines to load all data into the LPMS data warehouse. (1%) e.Maintain data quality console tools application for data quality assurance for all ten data schemas. (15%) f.Provide technical support to maintain the load programs and automated routines to add Omni Data to the warehouse summary files. (1%) g.Provide technical support to maintain, modify and enhance the data feeds to the OMBIL OLAP application, including adjustments to summary table calculations and any ancillary reports. (10%) h.Modify DIS screens, reports and data sources as needed. (3%) i.Add selection criteria as needed for identified LPMS wareehouse reports for quarterly and annual report periods. (5%) j.Develop new data reports as needed including Entry/Exit Types, Social Media (Twitter, Facebook etc). (10%) k.Update LPMS data entry screens so data can be changed while maintaining the key field integrity and implement deferred constraints. (5%) l.Refine job process scheduling so that all jobs complete successfully and seamlessly for the warehouse. (4%) m.Support for CAC authentication per USACE security policy. (1%) n.Develop.pdf file generation and export to Excel spreadsheets from all warehouse reports using Oracle APEX. (5%) o.Provide technical support to upgrade all LPMS applications to Oracle 10g and 11g including support for Oracle APEX. (5%) p.Be available for conference calls regarding problems submitted by the field for DIS and LPMS; make corrections to each system 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 telenet 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 P total 100% for the project. Each task is weighted percentage of the total project and maybe invoiced as tasks are accepted as complete by the COTR as listed in paragraph 9. As many of these tasks can be done in parallel, a monthly invoice of work performed may be submitted. 9. GOVERNMENT FURNISHED EQUIPMENT. Not applicable. 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-SN-10-0018/listing.html)
- Record
- SN02279506-W 20100915/100913235706-4d54d393d8dab21a3f1e8027a0d9c8b2 (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 |