SOW for 2020 HHGMS Procurement DS-JW.docx

DOCX document 47 KB Posted

Attached to
Maintenance of Healthy Homes Grant Management System
Solicitation number
RCS-L-0001
Issued by

View the file

Other files

File Type Posted
86615320Q00013.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Enhancement and Support of OLHCHH Grants Management System HUD Office of Lead Hazard Control and Healthy Homes Statement of Work

1.0 BACKGROUND STATEMENT AND NEED FOR SERVICES

The mission of the Office of Lead Hazard Control and Healthy Homes (OLHCHH) is to provide safe and healthy homes for all families and children by addressing housing conditions that threaten the health of residents, coordinating disparate health and housing agendas, supporting key research, targeting enforcement efforts, and providing tools to build sustainable local programs that mitigate housing-related health hazards. OLHCHH supports this mission by assisting States and local governments to identify and remedy unsafe housing conditions and the acute shortage of decent and safe housing for low income residents.

The OLHCHH has a grants management system using the SalesForce platform that provides application processing, document management, grant tracking, and quarterly progress reporting for its users. The OLHCHH needs ongoing support to continue maintaining this system and will require enhancements and expanded functionality as described in section 2.0 below.

2.0 PURPOSE/SCOPE

The purpose of this Statement of Work is to maintain and enhance an existing Web-based system, provide system maintenance and operational support to the OLHCHH grant application (pre-award cycles), and support the grants management and reporting systems (post-award cycles). The Contractor shall provide ongoing support, adaptive maintenance, consolidation and integration of new requirements, system requirement analysis, configuration management, user support, technical and user training, user documentation, and shall develop/maintain up-to-date system documentation.

3.0 ANALYSIS AND COORDINATION

The Contractor shall conduct any necessary analysis and coordinate with appropriate personnel to ensure a complete understanding of requirements functionality to support business requirements. Detailed tasks are described under the section titled “4.0 Detailed Task Requirements”.

The Contractor shall assimilate the related business rules and requirements in order to understand how the system will support the user. The Contractor shall work with and coordinate with: various OLHCHH staff, other HUD staff, Contractors, and OLHCHH end users to ensure the proper and effective integration of systems.

4.0 DETAILED TASK REQUIREMENTS

It is essential that the Contractor research and analyze the business rules and requirements to ensure that proper and relevant functional requirements are correctly incorporated into all system integration development and maintenance releases. The Contractor shall ensure that the functionality of new code is properly integrated into the system, is operating per requirements, and performs as expected by OLHCHH. The Contractor shall allow stakeholders to comment on and approve changes before modifications are made to ensure capability with business practices.

Task 1: Provide support to current HUD and Grantee HHGMS Users, to include support for the existing HHGMS system for all OLHCHH staff and OLHCHH Grantee users.

Task 2: Continued development of HHGMS, to address:

1. Specific enhancements identified by OLHCHH staff members during this period of performance (see attached)

2. Small to moderate modifications to functionality (e.g., changes to drop down menus, redefining fields, adapting user access profiles, etc.)

3. Test system functions and provide support user acceptance testing

4. Migrate changes and features into the HHGMS production environment Task 3: Develop HHGMS training materials including training materials (with screen shots and/or recorded application functionality demos) that cover basic HHGMS activities, including:

1. Basic HHGMS navigation

2. Attaching notes and documents

3. Grantee Case Creation and Submission

4. Units Entry, Monitoring, and Submission to Quarterly Report

5. Quarterly Report Creation and Submission

6. Creating and Accessing Reports

7. Make the training materials accessible from the HHGMS home page

5.0 OTHER SPECIAL REQUIREMENTS

5.1 Place of Performance

The Contractor shall furnish all facilities and equipment used during the performance of this contract (except Salesforce licenses). No permanent Government facilities or equipment will be provided other than HUD’s technical environments accessed by the contractor through a Virtual Private Network (VPN). The contractor shall develop and test the system on a Contractor-furnished system similar to HUD’s environment. The Contractor shall conduct User Acceptance Testing (UAT) and meetings at HUD’s facility at the direction of the PM/COR.

5.2 Period of Performance and Deliverables

The Period of Performance is for 12 months

5.3 Government Contacts

The following personnel are the Contractor’s primary contacts during the performance of these requirements:

(a) The Contracting Officer Representative, Jim Williams (202)-402-7171; james.williams@hud.gov The COR will be the primary Government contact on a day-to-day basis. However, the Contractor is hereby informed that only the Contracting Officer can change the contract or direct the Contractor to perform work outside the scope of the contract.

ATTACHMENT 1

SYSTEM UPGRADES FOR CURRENT CONTRACT PROCUREMENT

Task by Tab
Description

New TAB – NEW FLOW for Policy Development and Research (PD&R) - Grants Management and University Partnerships Division

NOFA SET UP

NOFA Tab Edit of fields or tab template- Work Flow
Update tab to include fields from Tech studies grants. Triggers for work flows, score sheets and reports must be formatted to fit their review process steps and fields of collection
Conflict of Interest Form for outside reviewers-CONGA FORM
Shall be a form instantiated using CONGA to generate the NOFA Tab fields. Form shall be imported back into the system once signed as an attachment
PD&R-GMS ARP Report Set up- Work Flow
This Arp report functionality is very similar to the existing Tech Studies ARP report format. Shall provide a selection of ARP report template to be generated as an option or triggered by the Tech Type Code in the NOFA TAB field.

Application Page PD&R-GMS Review Step 1

Application page set up
Cloned from existing Tech Studies pages and shall fully include all areas of the NOFA requirements for division/opportunity including reporting fields in CONGA for ARP, CIR, 1044, 718, etc..
PD&R-GMS Review Template- - Modified Working Page or Add template Potential heavy formula and carry of info into page view and reports.
“Step 1/Part 1” review form formatted like the Tech Studies grantee review form. Shall include two review steps /related scores/including notes.
Pre-App Scoring – Work Flow
Additional fields shall be merged into the threshold tab of the current application page with confirmation of scoring (manual or drop down), shall include note fields for selected boxes.
Invitation to submit full APP Letter- Workflow- CONGA FORM
Conga Form instantiated from the application page then saved as an attachment with date sent on application page when generated. Shall incorporate a trigger or status code such as: (Selected for Full Review) that prompts the full review form to be available with this letter.
Letter to request debriefing- not selected letter – Work Flow – CONGA FORM
Conga Form to instantiate from the application page then saved as an attachment with date sent on application page when generated. Shall incorporate a trigger or status code that prompts a STOP to the application or (Denied- Debriefing) Status with use of this letter. See below the debriefing templates to be implemented as work flow pages.

Application Page PD&R-GMS Review Step 2

Full App Review template/Scoring tool - - Modified Working Page or Add template- Heavy formula and carry of info into page view and reports.
“Step 2/Part 2” This template shall have a review form formatted like the Lead grantee review form/HH grantee review form. Shall behave like the existing lead grantee form but shall include all scoring in all parts of a cumulative total which shall incorporate all reportable fields like current lead scoring report.
QA/QC Checklist Template- Modified Working Page or Add template
Shall have a tab generated by the module similar to the current QA/QC but tailored to Tech Studies requirements and review sections.
PD&R-GMS ARP et al- CONGA FORM
Instantiated like current ARP report, data shall import into new tab fields for PD&R division; data sources shall include report templates based on the NOFA field selected for program type.
PD&R-GMS Award FRN Info Sheet – Conga Form Report
Report shall be auto filled in CONGA from data collected on NOFA Tab. Ensure all info on this template is part of the NOFA tab fields added or developed in new tab for this program type code.
Full App Unsuccessful Letter – Work Flow
Conga Form instantiated from the application page then saved as an attachment with date sent on application page when generated. Shall incorporate a trigger or status code that prompts a STOP to the application or (Denied- Debriefing) Status with use of this letter. Shall include a “Denied” status that triggers a debriefing form page.
CIR Report – CONGA FORM REPORT
Report shall be auto filled in CONGA from data collected from NOFA Tab. Ensure all info on this template is part of the NOFA tab fields added or developed in new tab for the Tech Studies type code. Very similar to fields in Tech Studies ARP. Ensure all fields are captured in NOFA tab or application page fields from template provided. *Includes table of awardee info as well as the abstract summary’s by awardee, by state.
GTR Eval PD&R-GMS - Modified WORK FLOW
Duplicated from existing Tech Studies GTR triggered by final scoring… shall have data fields modified to meet requirements of program review for this division
Pre App debriefing template – CONGA FORM
Template provided shall pull data from the application page and specific elements for this stage of the application to debrief on. Shall pull info from the scoring template part 1 only and only selected fields.
Full App debriefing template – CONGA FORM
Template provided shall pull info from the application page and specific elements for this stage of the application to debrief on. Shall pull info from the scoring template part 1 and part 2 and only selected fields.

Award Page Award Page for PD&R-GMS Division

Award Page by Program Type- Work flow
Work flow shall to resolve the issue of customizing the pages to be more focused and clearer to reflect the individual program needs without multiple fields of data not related to Tech Studies. Design shall ensure that elements included are user friendly for HUD and Grantee users.

The following CONGA form options shall be available on new award page

· Quarterly Letter

· 1044

· Closeout Report

· Oversite and Evaluation

Award Page sections – Modified working page to be used as template
Multiple data fields shall be imported from current Tech Studies award page at the benchmark level: Additional fields shall be added or retitled for this division for clarity, e.g., POC and title.
Benchmarks- Add fields
Benchmarks similar to Tech Studies, heavy narrative format and options for notes. Selected data shall be imported into Quarterly reports and work plan documents and shall include letter generation.
Work Plan Template- Add fields
Work plan template in which several section of the template approved shall be included in the award page as a summary of work and project goals for overall performance review.
Fiscal Reporting PART 3 and Budget Info- Connect existing work flow formulas to modified working page/template
Shall ensure a standardized protocol exists for paying LOCCS and using HHGMS to track expenditure details and budget line items. Currently using email for all transactions. Process must be established in HHGSMS to match current pages for LOCCS through Grantee requests and tied/carried to the quarterly report. Shall be connected to the fiscal control pages linked to current grantee pages when setting up the modified award pages and the corresponding amended quarterly report.

Quarterly Report for PD&R-GMS Division

QR template modification – Modified work page as template
Template shall be similar to Tech Studies to meet the needs of the division
LOCCS reporting roll up- connect existing work flow to modified template
Shall be included in QR
Match Reporting roll up- connect existing work flow to modified template
Shall be included in QR
Attachments/notes- connect existing work flow to modified template
Shall be included in QR

Existing Research and Policy Division Grants

NOFA SET UP

NOFA Tab Edit of fields or tab template- Work Flow
Adaptive Maintenance

Application Page Technical Grants Review Step 1

Application page
Adaptive Maintenance
Technical Review Template- - Modified Working Page or Add template Potential heavy formula and carry of info into page view and reports.
Adaptive Maintenance
Pre-App Scoring – Work Flow
Adaptive Maintenance
Invitation to submit full APP Letter- Workflow- CONGA FORM
Adaptive Maintenance

Application Page Technical Grants Review Step 2

Full App Review template/Scoring tool - - Modified Working Page or Add template- Heavy formula and carry of info into page view and reports.
Adaptive Maintenance
QA/QC Checklist Template
Adaptive Maintenance
HHTS ARP and LTS ARP, et al- CONGA FORM
Adaptive Maintenance
LHHTS Award FRN Info Sheet – Conga Form Report
Adaptive Maintenance
Full App Unsuccessful Letter – Work Flow
Adaptive Maintenance
CIR Report – CONGA FORM REPORT
Adaptive Maintenance
GTR Eval LHHTS Grants- WORK FLOW
Adaptive Maintenance
Pre App debriefing template – CONGA FORM
Adaptive Maintenance
Full App debriefing template – CONGA FORM
Adaptive Maintenance

Award Page Modified Award Page for Technical Studies Division

Award Page by Program Type- Work flow
Adaptive Maintenance
Work Plan Template
Adaptive Maintenance
Fiscal Reporting PART 3 and Budget Info- Connect existing work flow formulas to modified working page/template
Adaptive Maintenance

Quarterly Report for Technical Studies Division

QR template modification – Modified work page as template
Template shall be modified to meet the needs of the division

Existing Lead and HH Award Pages Development

Grant Awards Page

Add Triggers – Workflow
Add triggers for (ERR-RROF) to the Owner 4 year and 6 months after the Start Date
Modify Working Page
Add Lookups in Project Information section for Key Personnel
Work Plan Template- Add fields
Add work plan template in which several section of the template approved will include the award page as a summary of work and project goals for overall performance review.

Home Page

Update and Add instructional documents; Add Regional sharing settings

Grant Closeout Section

General Workflow
Workflow and triggers shall be reviewed and updated for changes shall include active history workflow and a required form with triggers; Add Assigned To feature

NOFA SET UP

NOFA Tab Edit of fields or tab template- Work Flow
Update tab to include fields from Weatherization program and Older Adult Home Modification program grants. Triggers for workflows, score sheets and reports shall be formatted to fit their review process steps and fields of collection
Weatherization program and Older Adult Home Modification program ARP Report Set up- Work Flow
This Arp report functionality is very similar to the existing Programs ARP report format. There is enough difference that a selection of ARP report template to be generated shall be an option or triggered by the Programs Type Code in the NOFA TAB field.

Grant Application Page

Weatherization program and Older Adult Home Modification Program Application page set up
This page shall be cloned from existing Programs pages and shall fully include all areas of the NOFA requirements for this division/opportunity as well as fields that are part of reporting in CONGA for ARP, CIR, 1044, 718, etc...
Debriefing Template-Form and Work flow
Adaptive Maintenance
Debriefing Notification Letter
Adaptive Maintenance
Reporting Tabs
Adaptive Maintenance

General Clean up

Synaptic field removal
Items that are coded synaptic in report variables when building a report or customizing a report and other areas. General Scrub for these fields with removal of those points is required result.

File details come from the government source that posted it. Updated .