201408_04_Entity_Resolution_SOW_v5.pdf

ang

Recovery Accountability and Transparency Board

Entity Resolution Integration Support Services

For The Recovery Accountability and

Transparency Board

Statement of Work

Solicitation Number: RATB2014-S-0001

Dated 08/04/2014

Entity Resolution Integration Support Services

1.0 PURPOSE AND BACKGROUND

The Recovery Accountability and Transparency Board (Recovery Board) has a need for a large-scale entity resolution integration support services capability that can improve the efficiency of the agency’s analytics and database services.

This solution will: (1) identify and consolidate pairs of records or references within the same information sources that are duplicates and (2) minimize data integration issues by improving resolution accuracy.

These analytics and database improvements will greatly enhance the Recovery Board’s analysis and reporting activities by reconciling large volumes of database references that correspond to the same real-world entities.

2.0 OBJECTIVES

The objective of utilizing entity resolution integration support services is to:

• Link critical data,

• Process and integrate large volumes of unstructured and structured data, and

• Improve integration of information quality processes.

It is expected that the Recovery Board will meet the demands of accountability and transparency more readily and efficiently by successfully utilizing innovative information technology enhancements that serve agency-wide information processes.

The goal of this tool is to enhance the Recovery Board’s analytics and database services to enable analysts to retrieve large volumes of centrally located data for further analysis in support of Offices of Inspectors General (OIGs) investigations.

3.0 IT ENVIRONMENT

3.1 Server Infrastructure

The Recovery Board uses Microsoft Active Directory for authentication and authorization and SharePoint for document and content management. The Recovery Board is standardized on Microsoft SQL Server for database services and Microsoft Internet Information Server as the standard web server.

3.2 Data Analysis

The Recovery Board uses a variety of tools such as SAS, Business Objects, Microsoft Reporting Services, Environment Systems Research Institute (ESRI), and Palantir.

3.3 Network

The Recovery Board’s infrastructure uses CISCO technology. The Recovery Board network supports 70 current users. The Recovery Board focuses heavily on security, providing public access for visitors as well as private access for Recovery Board personnel.

3.4 Desktop

The Recovery Board has standardized on Dell desktop and laptop systems. All systems are running Microsoft Windows 7. The Recovery Board runs a variety of software for office automation, publishing, and analysis.

4.0 SCOPE OF WORK

The Recovery Board is seeking a qualified offeror to provide an integrated entity resolution solution support services. The offeror shall integrate this technology into production by providing software and services. To accomplish this goal:

1. The offeror shall provide entity resolution software and process all production data sets to:

• Determine the ambiguities present within Recovery Board data sources;

• Provide extract, transform, and load (ETL) operations such as cleansing, standardization, and formatting of data provided by the Recovery Board to prepare for entity resolution processing;

• Customize the entity resolution technology configuration to group records by persons, organizations, and locations to compensate for ambiguity;

• Customize the entity resolution technology configuration to identify relationships between persons, organizations, and locations entities based on the presence of common information;

• Provide statistics that enable analysts to understand the strength of individual entity record groupings;

• Deliver mission relevant summarizations of entity resolved data; and

• Deploy entity resolved data products for ingestion into program databases, legacy, Commercial Off the Shelf (COTS) analytic tools, and web services to support uReveal, Endeca, and SQL.

2. The offeror shall automate the data integration processing operations.

3. The offeror shall develop advanced data products to support analytic discovery operations.

The entity resolution software must perform the following:

• Operate on Recovery Board provided 80 core, 512GB RAM, 3TB of disk storage server using the SUSE (Linux based) operating system;

• Provide a flexible configuration language that enables resolution of persons, their locations, and organizations; in addition to the identification of their relationships;

• Process (load, resolve, identify relationships, and publish results) 300 million records per day initially, with the ability to scale to up to one billion records per day;

• Provide procedures and tools for measuring the quality of the resolved entities;

and

• Provide the ability to explain the reasons for an entity record grouping.

4.1 Testing and Implementation

Within the first month of award, the offeror shall:

• Install entity resolution software on Recovery Board provided hardware;

• Establish a first version of the entity resolution rules;

• Develop plans for entity resolution-based data products and reports for use by the

Recovery Board’s analysts and provide a summarized entity content; and

• Produce an entity resolved data product for integration testing purposes.

Within the first two months of award, the offeror shall:

• Create an integration plan and data flow for entity resolution support services within the Recovery Board data processing infrastructure, which would also include any relationships between entities;

• Develop lists of data sources to be used for the first release of entity resolved data product in conjunction with the Recovery Board;

• Develop plans for integration into production operations for web services for legacy tools, and the content for data marts; and

• Provide metrics for describing entity quality to Recovery Board analysts.

Within four months of award, the offeror shall:

• Integrate the entity resolution engine into production operations;

• Refine entity resolution rules, provide improved results monthly, which would include any entity resolve persons, organizations, locations, and resolve relationships between entities;

• Integrate new data source into the entity resolution process;

• Create a Prototype entity resolved data products and integrate into productions operations appropriate by the Recovery Board; and

• Develop web services and data marts for integration into the tools used by the

Recovery Board analysts.

4.2 Reporting

The offeror shall provide a plan that outlines how this entity resolution support services solution will conform to the Recovery Board environment.

The document shall include the following:

• A report which summarizes the performance of the entity resolution engine, specifically:

o Number of records processed;

o Time to process records;

o Number of entities produced;

o Quality summary of the resolved entities; and o Data sources processed.

The report must summarize the entity resolved data products and demonstrate how the solution will:

• Perform entity resolution across 300 million records within one business day and up to 1 billion as required by the Recovery Board;

• Deliver entity resolution data refreshed on a weekly basis;

• Visualize entity resolved data products within legacy (custom and COTS) analytic tools; and

• Provide entity summarizations and other resolved data products to support the entity resolution service.

The report must be provided within one month after award. The report will be reviewed by the Chief Information Officer (CIO) and accepted by the Contracting Officer’s Representative (COR).

4.3 Performance Standards & Levels

The offeror shall provide a performance report and validate that this entity resolution support services solution meets the following acceptable levels of performance:

• Process 300 million records per day with the ability to scale to up to one billion per day;

• Demonstrate ability to measure the accuracy of resolved entities;

• Prepare data for entity resolution processing; and

• Run a process similar to SAP HANA which is the tool that the Recovery Board uses for computing performance and capacity.

5.0 REQUIREMENTS

5.1 Training

The offeror shall provide a two-week training period and training manuals to the Recovery Board’s Accountability and ITD teams. This training shall include areas of integration, and analytic skills to support entity resolution configurations and shall develop entity-based analysis algorithms with exploitation methodologies.

The training schedule shall be a part of the project schedule delivered by the offeror. The training shall include system administration, all business rules, and configurations to operate and maintain the system.

5.2 Kickoff Meeting

Within seven (7) calendar days of contract award, the Contracting Officer shall conduct a kickoff meeting with the offerors and the key stakeholders. The kickoff meeting shall be hosted at the Recovery Board facility at 1717 Pennsylvania Avenue, NW, Suite 700, Washington, D.C.

5.3 Travel

The Recovery Board anticipates that there will be no travel on the part of the offeror during the performance of the contract. The Recovery Board will specify and define travel, if and when it is required. Local commuting expenses will not be reimbursed. All offeror travel and per diem expenses are subject to the Government travel management policy and Federal Travel Regulation (FTR), and reimbursable in accordance with current allowances. Only actual travel expenses (with receipts) will be reimbursed in accordance with FTR.

Teleconferences may be acceptable for some meetings, provided there is mutual agreement between the offeror and the Recovery Board.

5.4 Reports

Weekly Status Reports: The offeror must provide weekly status reports that shall be emailed to the COR by 5 PM EST on Monday of each week. The status report must include, as appropriate: significant accomplishments, problems and difficulties encountered, and issues needing resolution. The status reports at a minimum must cover:

1. Overall status;

2. Work that was accomplished for the previous weekly period with an issue log with items that were not accomplished during each week and with explanations or justifications on why work was not completed;

3. Outstanding issues and incident logs; and

4. An outline of the major goals for the coming reporting period.

5.5 Meetings

Weekly Project Status Meetings: The offeror shall conduct weekly project status meetings with the Recovery Board to discuss project status and issues. Meetings will be held at the Recovery Board facility on each Tuesday of the week. The offeror shall provide the COR with Meeting Decision/Action Item Notes within (2) two business days following each weekly meeting.

5.6 Place of Performance

The place of performance for delivery of all work products is in government facilities located at the Recovery Board, 1717 Pennsylvania Avenue, NW, Suite 700, Washington, D.C.

5.7 Period of Performance

Base: One Year from date of award. Option period: end of the base year through September 30, 2015. This contract ends on September 30, 2015.

5.8 Physical Security

Offeror’s custody of sensitive information must be in accordance with the Privacy Act of 1974, 5 U.S.C. § 552a -- as amended. The Offeror shall be responsible for safeguarding Personally Identifiable Information (PII) data against unauthorized disclosure, dissemination, or modification. Such data shall include, but is not limited to PII data located in IT Systems, software, research data / information, personnel, and buildings/offices. The contractor shall never remove Recovery Board data used on the entity resolution support services solution from premises of the Recovery Board’s facility.

5.9 Release of Information

No Recovery Board data shall be divulged to any unauthorized person, for any purpose.

The offeror shall submit drafts of any public releases of information to the Contracting Officer through the COR for approval. Information includes news stories, articles, sales and marketing information, advertisements, etc.

5.10 Contract Type

This is a Firm Fixed Price contract. This is a commercial item acquisition.

http://www.usdoj.gov/oip/privstat.htm http://www.usdoj.gov/oip/privstat.htm

5.11 Protection of Information

For Official Use Only. All Recovery Board government information used by the offeror in performance of this contract shall only be disclosed to authorized personnel on a need-to-know basis. The offeror shall ensure that appropriate administrative, technical, and physical safeguards are established to ensure the security and confidentiality of this information and that related equipment is properly protected. When no longer required, this information and equipment shall be returned to Recovery Board control, destroyed, or held until otherwise directed. All sensitive information contained on offeror computers shall be either degaussed or deleted using the Department of Defense method of a three time overwrite of the sensitive data.

5.12 Inspection and Acceptance

In the absence of other agreements negotiated with respect to time provided for government review, deliverables shall be inspected and the offeror notified of the government’s findings within five (5) workdays after receipt of a deliverable. If the government does not respond to the deliverable within the five (5) workday period the deliverable shall be deemed to be accepted. The project manager and the offeror shall meet on a monthly basis to review performance and inspect work for compliance with the SOW and the contract and all modifications thereto.

5.13 Procedures for Payment

Offerors shall propose a billing schedule based upon the total cost of the contract, and the period of performance. Invoices shall be emailed to hank.hardy@ratb.gov or mailed to:

Recovery Accountability and Transparency Board, Attention: Henry Hardy, Contracting Officer, 1717 Pennsylvania Avenue Suite, NW, 700, Washington D.C., 20006. Failure to comply with these procedures may result in your payment being delayed.

6.0 Submission of Offers:

Each offer shall be in two parts.

Part I is the written Price Proposal and shall contain the following:

a. Services and Prices/Costs

b. Cost/Price Supporting Documentation

c. Organizational Conflict of Interest Statement

Part II is the written Technical Proposal and shall contain the following:

a. Technical Approach mailto:hank.hardy@ratb.gov

The technical portion shall not contain any pricing information whatsoever.

6.1 Submission of the Written Price Proposal, Part I:

Price Proposals will be evaluated (but not scored) based on a price analysis. Offeror written Price Proposals shall be submitted as an electronic copy to the Contracting Officer. The offeror shall submit all proposed costs using Microsoft Excel software utilizing the formats without cells locked and include all formulas. The offeror shall include adequate information, which will allow the Recovery Board to perform the required price analysis review. The maximum page length for the written Price Proposal shall not exceed ten double sided sheets of paper, inclusive of text and graphics.

6.2 Submission of the Written Technical Proposal, Part II:

Each offeror shall submit all information described in the following paragraphs. The offeror shall provide an electronic copy submitted to the Contracting Officer, containing all required sections of this Part.

The Technical Proposal must not exceed 50 double-sided sheets of paper inclusive of text and graphics. Text must be in a font equivalent to Times New Roman, Font 12. Graphics may be in a format as selected by the Contractor. One double-sided sheet of paper is equivalent to 2 single-sided sheets of paper of printed material.

Pages in the Contractor’s response that exceed the maximum number of pages identified in this solicitation will be disregarded and not considered or evaluated for award.

Attached, incorporated, or referenced documents in the proposal are included in the maximum page count.

Electronic copies of the proposals shall be submitted to the Contracting Officer, Hank Hardy at hank.hardy@ratb.gov. Order number and compatible with MS Office 2007.

6.2.1 Technical Assumptions:

No assumptions, conditions, or exceptions are permitted. Any response containing assumptions, conditions, or exceptions will be rejected and is ineligible for award.

6.3 Method of Award:

Award will be made based on price reasonableness and technical acceptability. The factors that will be evaluated are Price, Technical Approach, and Past Performance. The Recovery Board may make award based on initial offers received, without discussion of such offers in accordance with FAR clause 52.215-1.

mailto:hank.hardy@ratb.gov

The Recovery Board may make award after clarifications of some aspects of the proposal relative to price only.

Proposals shall set forth full, accurate, and complete information as required by this solicitation package (including Attachments). The penalty for making false statements in proposals is reflected in 18 U.S.C. 1001.

6.4 Price Proposal Evaluation:

The offeror’s written Price Proposals will be evaluated to determine price reasonableness.

Prices that are excessively high or low (without sufficient justification) may be considered unrealistic and unreasonable and may receive no further consideration. A determination of price reasonableness will include a determination by the Contracting Officer that proper discounts have been offered commensurate with maximum order thresholds.

6.5 Organizational Conflict of Interest (OCI)

Organizational Conflict of Interest Statement will be evaluated to assess whether or not an actual or potential OCI exists as defined by FAR Part 9.5. If an actual or potential conflict of interest is identified that cannot be feasibly mitigated, avoided, or resolved in accordance with FAR Part 9.5, that offeror may be ineligible for award.

6.6 Technical Evaluation Factor(s):

The Recovery Board will evaluate the Technical Proposal on the completeness of the approach and the degree to which the approach and methodology utilized to ensure that the Recovery Board’s requirements are satisfied. The clarity of the rationale for each task and subtask listed in the Technical Proposal, and the degree to which the Recovery Board’s outcomes/objectives will be achieved through those tasks.

6.7 Technical Evaluation Factor(s) – Past Performance:

Past Performance Factor: The Past Performance Factor evaluation will assess the relevance and breadth of the offeror’s experience and the quality of the offeror’s past performance. The Recovery Board is seeking to determine whether the offeror has experience that will enhance its technical capability to perform and whether the offeror consistently delivers quality services in a timely and cost effective manner. When evaluating past performance, the Recovery Board will only take into consideration the relevant experience and past performance assessments from the offeror's customers.

However, the Recovery Board reserves the right to use other relevant past performance information it obtains through other sources including other agency databases and information contained in trade literature.

Past Performance will receive one of the adjectival ratings defined below. It will be the overall subjective conclusion of the Recovery Board as to how the proposals will be rated.

ADJECTIVAL DEFINITION

Excellent

Offeror’s performance was very current and very relevant to the requirements requested. Relevant defined as performing the same services. Performance was accomplished with no problems for which any required corrective actions taken were highly effective.

Good

Offeror’s performance was current and relevant to the requirements requested. Relevant defined as performing similar services. Performance was accomplished with no or some minor problems for which any required corrective actions taken were effective.

Satisfactory

Offeror’s performance met contractual requirements.

Performance was accomplished with some minor problems for which any required corrective actions taken were satisfactory.

Unknown/Neutral No relevant past performance record is identifiable upon which to base a meaningful past performance risk prediction. A search was unable to identify any relevant past performance information for the contractor or their key personnel. This is neither a positive or negative assessment.

Marginal

Offeror’s performance did not meet all of the contractual requirements. Performance was accomplished with serious problems for which any required corrective actions were marginally effective or not fully implemented.

Unsatisfactory Offeror’s performance did not meet most of the contractual requirements. Performance was accomplished with serious problems for which any required corrective actions were ineffective or non-existent.

6.8 Clauses

This solicitation incorporates one or more solicitation provisions by reference, with the same force and effect as if they were given in full text. Upon request, the Contracting Officer will make their full text available. The offeror is cautioned that the listed provisions may include blocks that must be completed by the offeror and submitted with this quotation or offer. In lieu of submitting the full text of those provisions, the offeror may identify the provision by paragraph identifier and provide the appropriate information with its quotation or offer. Also, the full text of a solicitation provision may be accessed electronically at this address: https://www.acquisition.gov/far/.

https://www.acquisition.gov/far/

Clause No Clause Title Date 52.212-1 Instructions to the Offerors – Commercial Items APR 2014 52.212-3 Offeror Representations and Certifications –

Commercial Items

MAY 2014

52.212-4 Contract Terms and Conditions – Commercial Items MAY 2014 52.213-2 Invoices APR 1984 52.215-1 Instructions to Offerors-Competitive Acquisition JAN 2004 52.215-20 Requirements for Cost or Pricing Data or

Information Other Than Cost or Pricing Data – Alternate IV

OCT 2010

52.232-38 Submission of Electronic Funds Transfer Information with Offer

MAY 1999

52.217-8 Option to Extend Services (Nov 1999)

The Government may require continued performance of any services within the limits and at the rates specified in the contract. These rates may be adjusted only as a result of revisions to prevailing labor rates provided by the Secretary of Labor. The option provision may be exercised more than once, but the total extension of performance hereunder shall not exceed 6 months. The Contracting Officer may exercise the option by written notice to the Contractor within 30 days before the expiration of any contract period.

52.217-9 Option to Extend the Term of the Contract (Mar 2000)

(a) The Government may extend the term of this contract by written notice to the Contractor upon expiration of this contract; provided that the Government shall give the Contractor a preliminary written notice of its intent to extend at least 30 days before the contract expires. The preliminary notice does not commit the Government to an extension.

(b) If the Government exercises this option, the extended contract shall be considered to include this option clause.

(c) The total duration of this contract, including the exercise of any options under this clause, shall not exceed 18 months.

(End of clause)

52.237-3 Continuity of Services (Jan 1991)

(a) The Offeror recognizes that the services under this contract are vital to the Government and must be continued without interruption and that, upon contract expiration, a successor, either the Government or another Offeror, may continue them.

The Offeror agrees to—

(1) Furnish phase-in training; and

(2) Exercise its best efforts and cooperation to effect an orderly and efficient transition to a successor.

(b) The Offeror shall, upon the Contracting Officer’s written notice, (1) furnish phase-in, phase-out services for up to 90 days after this contract expires and (2) negotiate in good faith a plan with a successor to determine the nature and extent of phase-in, phase-out services required. The plan shall specify a training program and a date for transferring responsibilities for each division of work described in the plan, and shall be subject to the Contracting Officer’s approval. The Offeror shall provide sufficient experienced personnel during the phase-in, phase-out period to ensure that the services called for by this contract are maintained at the required level of proficiency.

(c) The Offeror shall allow as many personnel as practicable to remain on the job to help the successor maintain the continuity and consistency of the services required by this contract. The Offeror also shall disclose necessary personnel records and allow the successor to conduct on-site interviews with these employees. If selected employees are agreeable to the change, the Offeror shall release them at a mutually agreeable date and negotiate transfer of their earned fringe benefits to the successor.

(d) The Offeror shall be reimbursed for all reasonable phase-in, phase-out costs (i.e., costs incurred within the agreed period after contract expiration that result from phase-in, phase-out operations) and a fee (profit) not to exceed a pro rata portion of the fee (profit) under this contract.

(End of clause)