Statement_of_Work_PEPC_Final.doc

Statement of Work

National Park Service – Natural Resource Program Center

National Park Service, NRSS, EQD, Planning, Environment and Public Comment Support Performance Work Statement

Software Engineering Staff to support the Environmental Quality Division’s Planning, Environment and Public Comment (PEPC) system.

Peformance Work Statement

Independently and not as an agent of the Government, the contractor shall provide the NPS with all labor and services necessary to implement the following.

A General Information A.1

Introduction This requirement is for two full-time ONSITE development support positions to support the U.S. Department of Interior, National Park Service, Natural Resource Stewardship and Science, Environmental Quality Division, Planning, Environment and Public Comment (PEPC) system. These services comprise the ongoing maintenance, design, development, implementation, operation, documentation of the existing database, and web-based solutions for the management of natural resource, environmental related data and information. Work is assigned and reviewed by the NPS PEPC Program Lead. Please see 52.222-17 – Nondisplacement of Qualified Workers on page 38 of the solicitation. The two current contractors on-site are: Matthew Hunnell 970-331-1357 matthunnell@gmail.com Patrick Mackay 303.877.9978 - pmackay@frii.com A.2

Background

The Natural Resource NRSS Stewardship and Science (NRSS) Directorate provides leadership, expertise, and scientific information to ensure that the natural resources of the lands managed by the National Park Service (NPS) remain unimpaired for future generations. NRSS coordinates natural resource inventory and monitoring activities; implements technical natural resource management solutions; acts as a national clearinghouse for natural resource management information; and informs NPS staff and the public about natural resource management programs and activities. NRSS has a multi-disciplinary staff that includes scientists, natural resource managers, information technology specialists, policy and regulatory compliance experts, and educators. Natural resource topics addressed by components of NRSS include: water resources, geology, soils, air resources, natural sounds, biological resources, and compliance with environmental regulations. The Environmental Information Management Branch is responsible for the oversight of the environmental applications including the PEPC System.

A.3

Scope of Work

The purpose of the support services described in this statement of work is to provide daily onsite technical expertise for the ongoing application maintenance, design, development, testing and deployment of the Planning, Environment and Public Comment (PEPC) system managed by NRSS-EQD. This system is used to manage compliance with the National Environmental Policy Act (NEPA) on all park projects, public review of NPS documents, plans, and projects, as well as the public comment and comment analysis. Additionally, technical expertise is needed to facilitate interaction/integration with current hardware and network infrastructure, (whether hosted by NPS or by Cloud provider), other department or bureau systems as well as serve as technical advisors for the NPS as needed. Work is assigned and reviewed by the NPS PEPC Program Lead.

B.

Technical Requirements

B.1

The contracted personnel shall maintain existing tools and services, and research, design, develop, implement and improve tools and services to manage and share natural resource information in both secure and public internet environments. The contractor shall, as requested, facilitate interaction/integration with other systems as well as serve as technical advisors representing the NPS as needed. For instance, the contracted personnel may serve as technical experts on integration efforts with other NPS or DOI systems, perform demonstrations of the system, represent the NPS in meetings, etc. Contracted personnel may be responsible for ensuring software is patched, security issues are addressed according to DOI requirements, software is migrated to new versions as directed, and application is properly configured with current hardware and network infrastructure (whether hosted by NPS or by Cloud provider).

B.1.1 The NPS Planning, Environment and Public Comment (PEPC) System PEPC is a web-based environmental management system designed for compliance planning, project collaboration and review, and public involvement. It is used to promote the project management process in conservation planning and environmental impact analysis. It assists NPS employees in making informed decisions with regard to compliance issues throughout the planning, design, and construction process. PEPC allows park staff to: track and manage projects, collaborate as interdisciplinary team members on projects, post plans and related documents to the public, review and analyze the public comments and respond to public concerns. PEPC assists with protecting the environment of national parks by: helping NPS employees prepare Environmental Screening and Assessment of Effect forms, simplifying the scheduling of site visits as well as the tracking of tasks and mitigations, tracking environmental consultations, and helping everyone involved in the process to make better decisions. PEPC assists with public comment to the National Park Service by: allowing NPS employees to communicate plans, meetings, and the status of projects via the Internet, making information available to the public in a single, easily-accessible location and providing a unified portal for public consultation and comment analysis. The PEPC system currently contains approximately 47,000 project records in the production database. Approximately 5,000 new projects are documented in PEPC each year.

Technical requirements include onsite services to:

· Maintain and update existing tools, using ColdFusion and Oracle for both the secure and the public Internet applications.

· Use ColdFusion administrator to monitor and configure ColdFusion applications, data sources, logs, and web services.

· Develop and demonstrate the use of integrated decision-support technologies that use a wide variety of state-of-the-art technical hardware and software for both the secure and the public Internet PEPC applications.

· Develop, maintain, and implement tools, procedures, and services in line with the NRSS architecture, and NPS web standards.

· Write, debug, and maintain code and technical documentation for all applications, including versioning software such as Subversion or Visual Source Safe.

· Translate system requirements into application prototypes.

· Plan and design systems architecture and user interfaces.

· Integrate hardware and software components, and work with customers to test applications and troubleshoot errors.

· Write complex SQL and PL/SQL queries to access Oracle databases and create data objects for use in web applications, including Oracle packages/stored procedures and ColdFusion cfcs.

· Use Oracle Enterprise Manager (EM), Toad, and other database tools to maintain and modify the tables, views, triggers, constraints and packages.

· Facilitate consistent data management techniques, technologies and integration with other NPS applications and information systems.

· Document data structure, data dictionary, metadata, and table relationships.

· Maintain data integrity via data input constraints, review and correction.

· Resolve constantly emergent security issues to address increasing requirements, new threats, and evolving software configurations, according to DOI requirements.

· Monitor and oversee public interface to maximize up-time as well as to monitor and address security issues, browser compatibility, and general functionality for the public facing parkplanning.nps.gov.

· As requested, interact with other Federal or State agencies, or private organizations interested in NRSS software applications and seeking assistance or guidance in operational data processing and end user training as it relates to the specified software.

· Provide support for other planning and workflow software applications as requested.

· Investigate and plan integration with other NRSS, NPS, or DOI systems and architecture.

· Provide technical support to end users.

· The contracted personnel will serve as technical subject matter expert capable of explaining complex software design and functionality to help NPS, DOI, and others understand how PEPC operates behind the software interface and to provide guidance necessary to achieve system integration objectives.

· The contracted personnel may be responsible for ensuring software is patched, migrated to new versions as directed, and application is properly configured with current hardware and network infrastructure (whether hosted by NPS or by Cloud provider).

B.1.2 The contracted personnel shall implement NRSS IT application standards.

· Establish, implement, and maintain business modeling, requirements, analysis and design, implementation, testing, deployment, and configuration/change management procedures to meet DOI and NPS standards. Software tools to be used are: ColdFusion 10, 11, Adobe Design (Dreamweaver, Flash) .NET; Visual Studio Suite; Oracle 11g, 12c, SQL Server, C#, Java, Ajax and other technology as it becomes available.

· In conjunction with NRSS IT support staff, design and deploy development, QA, staging, and production environments;

· Ensure code,procedures and configurations are in accordance with NPS and U.S. Department of Interior security standards and other U.S. Government policies or procedures.

· Design, develop, deploy, and maintain NPS units service; notification service; web services to/from other NPS systems,authentication and access control services. Other supporting or related services may be required or requested.

· Ensure best programming practices to prevent security vulnerabilities.

B.1.3 All deliverables must comply with Section 508 of the Rehabilitation Act OF 1973, (29 U.S.C. 794d) as amended in 1998.

· The activity to be performed relates to or requires the use of Electronic and Information Technology (EIT). Section 508 must be considered as a requirement for Software Development service outputs/deliverables to ensure that it considers specific Section 508 accessibility requirements. Further, Software Development outputs/deliverables should not adversely affect accessibility features of existing EIT technologies.

· Technical standards from 36 CFR part 1194 Subpart B have been determined to apply to this acquisition. Solicitation respondents must describe how their background and experience will enable them to at least meet those technical provisions identified as applicable in the attached Government Product/Service Accessibility Template (GPAT).

· Software Development outputs/deliverables should meet applicable accessibility requirements and should not adversely affect accessibility features of existing EIT technologies.

· Functional performance criteria from 36 CFR part 1194 Subpart C have been determined to apply to this acquisition. Solicitation respondents must describe how their background and experience will enable them to at least meet those functional performance criteria identified as applicable in the attached Government Product/Service Accessibility Template (GPAT).

· Information, documentation, and support requirements from 36 CFR part 1194 Subpart D have been determined to apply to this acquisition. Solicitation respondents must describe how the information, documentation, and support proposed for Software Development outputs/deliverables will meet at least those information, documentation, and support requirements identified as applicable in the attached Government Product/Service Accessibility Template (GPAT).

C.

Supporting Information C.1

Place of Performance

All tasks shall be performed at the NRSS facility in Fort Collins, Colroado. Note the works hours for non-NPS personnel listed below.

Core hours are 9-3. Building locations, access, and maintenance are covered in the NRSS employee handbook which states the following:

“The NRSS Fort Collins Office is located at 1201 Oakridge Drive, Fort Collins, Colorado, 80525. Access cards to the building are issued by the Administrative Officer upon notification by the Denver Administrative Program Center (APC) that an employee’s preliminary background checks have been completed. Access cards issued to Federal employees have different access privileges than cards issued to contractors. Federal employees have access to all doors at all times: 7 days a week, 24 hours a day. Building access cards issued to non-NPS personnel are active only Monday – Friday, 6 a.m. to 6 p.m., but not active on Federal holidays. If an employee needs for a contractor to have to access the building outside of these times, the employee must be present while the non-Federal person is in the building.”

C.2

Period of Performance

The desired period of performance would be August 1, 2015 through July 31, 2016 base year with (2) options: Option 1 August 1, 2016 through July 31, 2017, Option 2 August 1, 2017 to July 31, 2018 C.3

Qualifications of Key Personnel

C.3.1 All services under this contract are required to be conducted by trained personnel who have the knowledge, skills, and abilities to provide services immediately and with no unnecessary delays. Key personnel are expected to have the appropriate computer science or information technology background in addition to natural resource education, training or experience with natural resource systems in order to successfully complete the work under this contract.

C.3.2 The contractor shall present resumes of all personnel who are proposed to work under this contract. Resumes shall contain contact information for professional references, and information on work that candidates have performed on similar projects. NRSS reserves the right to judge the qualifications and previous work history of any individual proposed by the contractor for any position. Upon written notification, NRSS may require the contractor to replace an individual whose qualifications or work performance are judged deficient.

Certain skilled and experienced professional and/or technical personnel are essential for accomplishing the work to be performed. The general qualifications and number of these positions recommended by NRSS are provided in Table 1.

Must have experience as team leader or project manager in order to provide direction to other IT specialists and ensure required benchmarks are met for multiple projects.

Bachelor’s degree in computer science, business, biological sciences, natural resource discipline, or closely related field, 10 or more years developing in a ColdFusion environment, 8 or more years of work-related experience or an equivalent combination of a graduate degree and additional experience desired. Postgraduate training or certifications usually required to achieve and maintain competence in computer programming, database management, and systems administration.

Senior Software Engineer

1full-time

Senior Software Engineer position, proficient in developing and maintaining applications in the ColdFusion environments including ColdFusion, C#, Ajax, and Web development tools such as Dreamweaver. Experience with Oracle and SQL Server databases required. Experience building Web Services in an SSL environment preferred. Experience with Java/J2EE and object oriented programming preferred. Experience administering IIS and ColdFusion servers preferred.

Experience providing support for internal clients.

Bachelor’s degree in computer science, biological sciences, natural resource discipline, or closely related field, 8 or more years developing in a ColdFusion environment, 6 or more years of work-related experience or an equivalent combination of a graduate degree and additional experience. Postgraduate training or certifications preferred to maintain competence in computer programming, database management, and/or systems administration.

Table 1.

C.4

Special Considerations

C.4.1 Staffing Notification Process

The contractor will present detailed resumes of key personnel who are proposed to work under this contract. Resumes will contain contact information for professional references, and information on work that candidates have performed on similar projects. NRSS reserves the right to review the qualifications and previous work history of any individual proposed by the contractor for any position.

Upon written notification, NRSS may require the contractor to replace an individual whose qualifications or work performance are judged deficient during performance and after contractor remedial actions.

C.4.2 Contractor Project Management The contractor shall provide on-site (monthly) oversight for contract, personnel, and staff performance management. Monthly status reports of work accomplished are required. Information, direction or requests will be filtered through the Contracting Officer or Contracting Officer Representative to the Contractor point of contact or lead to the Contractor(s) on-site.

C.4.3 Government-furnished Materials and Services

C.4.3.1 NRSS will furnish all materials necessary for services to be performed, including hardware, software, telecommunications, Internet and e-mail, office space, and office supplies. As determined by mutual agreement, NRSS will provide additional property that may be required in the performance of this effort.

C.4.3.2 NRSS will furnish all information, directives, and policies related to practices and procedures required by the U.S. Department of the Interior, the National Park Service, and any other government oversight offices.

C.4.4 Security

All contractor personnel providing services related to this statement of work must submit to U.S. Government background checks, including fingerprinting, and receive approval rating. Fingerprinting expense will be paid by the government. All contractor personnel must comply with the terms of use of U.S. Department of Interior computers and information systems, and complete computer security training and other related training as required. Access to NRSS facilities is controlled and identification and access cards are required by all contractor staff.

C.4.5 Travel Occasional travel may be required of contractor personnel. All travel will be conducted in accordance with federal travel regulations; government vehicles will not be provided. Travel costs will be negotiated and included by modification when the occasional travel occurs.

C.4.6 Professional Development

Professional development funds will be paid by the Contractor.

C.4.7 Limited Use of Data Information made available to the contractor by NRSS for the performance or administration of this effort shall be used only for those purposes and not be used in any other way without the written agreement of the Contracting Officer.

Performance of this effort may require the contractor to access and use sensitive or commercially valuable data and information proprietary to NRSS and/or NPS; the dissemination or use of these data, other than in performance of this effort, would be adverse to the interests of the Government and/or others. The contractor and/or contractor personnel shall not divulge or release data or information developed or obtained in performance of this effort until made public by NRSS and/or NPS, except to authorized NRSS personnel or upon written approval of the Contracting Officer. The contractor shall not use, disclose, or reproduce proprietary data that bears a restrictive legend, other than as required in the performance of this effort.

C.4.8 Ownership of Data and Products All data, materials, and products collected, created, or generated in the course of performance of this contract become the property of the National Park Service. The National Park Service reserves the right to obtain, reproduce, publish, or otherwise use products produced under this contract, and to authorize others to receive, reproduce, publish, or otherwise use such products for Federal Government purposes.

C.4.9 Subcontracting

The contractor may subcontract up to 20% of the proposed contract value. The contractor shall present resumes of all personnel who are proposed to work under this subcontract. Resumes shall contain contact information for professional references, and information on work that candidates have performed on similar projects. NRSS reserves the right to judge the qualifications and previous work history of any individual proposed by the subcontractor for any position. Upon written notification, NRSS may require the contractor to replace an individual whose qualifications or work performance are judged deficient.

C.4.10 Term of Contract The initial term of contract is for one base year. There are two one year option periods that maybe exercised by the Government in accordance with FAR paragraph 52.217-09. The Government reserves the right to award without discussions. Evaluation factors, other than cost or price, when combined are approximately equal.

PAGE