RFP CFP-12-R-00001 CCD Services FINAL_Redacted.pdf

SEE ADDENDUMIS CHECKED

CODE 18a. PAYMENT WILL BE MADE BY

CODE

FACILITYCODE

17b. CHECK IF REMITTANCE IS DIFFERENT AND PUT SUCH ADDRESS IN OFFER

OFFEROR

CFP

1801 L Street, NW Office of Procurement Office of Procurement Consumer Financial Protection Burea

CODE 16. ADMINISTERED BYCODE

X

X

518210

SIZE STANDARD:

% FOR:SET ASIDE:UNRESTRICTED OR

CFPB PROCUREMENT

RFPIFB

10. THIS ACQUISITION ISCODE

RFQ

14. METHOD OF SOLICITATION

13b. RATING

NAICS:

SMALL BUSINESS

02/10/2012 1600 ET

01/27/2012

LAURENT PICHET

(No collect calls)

INFORMATION CALL:

FOR SOLICITATION 8. OFFER DUE DATE/LOCAL TIMEb. TELEPHONE NUMBER a. NAME

4. ORDER NUMBER3. AWARD/ 6. SOLICITATION

CFP-12-R-00001

5. SOLICITATION NUMBER

SOLICITATION/CONTRACT/ORDER FOR COMMERCIAL ITEM 1. REQUISITION NUMBER PAGE OF

1 168 OFFEROR TO COMPLETE BLOCKS 12, 17, 23, 24, & 30

Washington DC 20036

TELEPHONE NO.

17a. CONTRACTOR/

15. DELIVER TO

WASHINGTON DC 20036

1801 L STREET, NW

BUREAU

9. ISSUED BY

7.

2. CONTRACT NO.

EFFECTIVE DATE

$25.00

18b. SUBMIT INVOICES TO ADDRESS SHOWN IN BLOCK 18a UNLESS BLOCK BELOW

ISSUE DATE

DELIVERY FOR FOB DESTINA-

TION UNLESS BLOCK IS

MARKED

11.

SEE SCHEDULE

12. DISCOUNT TERMS

THIS CONTRACT IS A

RATED ORDER UNDER

DPAS (15 CFR 700)

13a.

SERVICE-DISABLED VETERAN-

OWNED SMALL BUSINESS

HUBZONE SMALL

BUSINESS

EMERGING SMALL

BUSINESS

8(A)

CONSUMER PROTECTION FINANCIAL

SOLE SOURCE

24.

AMOUNT

23.

UNIT PRICE

22.

UNIT

21.

QUANTITY

20.

SCHEDULE OF SUPPLIES/SERVICES

19.

ITEM NO.

(Use Reverse and/or Attach Additional Sheets as Necessary)

HEREIN, IS ACCEPTED AS TO ITEMS:

XX

DATED

LAURENT E. PICHET

. YOUR OFFER ON SOLICITATION (BLOCK 5),

INCLUDING ANY ADDITIONS OR CHANGES WHICH ARE SET FORTH

COPIES TO ISSUING OFFICE. CONTRACTOR AGREES TO FURNISH AND DELIVER

ARE

ARE

31c. DATE SIGNED

27b. CONTRACT/PURCHASE ORDER INCORPORATES BY REFERENCE FAR 52.212-4. FAR 52.212-5 IS ATTACHED. ADDENDA

31a. UNITED STATES OF AMERICA (SIGNATURE OF CONTRACTING OFFICER)

30c. DATE SIGNED 31b. NAME OF CONTRACTING OFFICER (Type or print)

ALL ITEMS SET FORTH OR OTHERWISE IDENTIFIED ABOVE AND ON ANY ADDITIONAL

SHEETS SUBJECT TO THE TERMS AND CONDITIONS SPECIFIED HEREIN.

27a. SOLICITATION INCORPORATES BY REFERENCE FAR 52.212-1, 52.212-4. FAR 52.212-3 AND 52.212-5 ARE ATTACHED. ADDENDA

26. TOTAL AWARD AMOUNT (For Govt. Use Only)

OFFER

STANDARD FORM 1449 (REV. 3/2005)

Prescribed by GSA - FAR (48 CFR) 53.212

ARE NOT ATTACHED.

ARE NOT ATTACHED.

AUTHORIZED FOR LOCAL REPRODUCTION

PREVIOUS EDITION IS NOT USABLE

30b. NAME AND TITLE OF SIGNER (Type or print)

30a. SIGNATURE OF OFFEROR/CONTRACTOR

28. CONTRACTOR IS REQUIRED TO SIGN THIS DOCUMENT AND RETURN

25. ACCOUNTING AND APPROPRIATION DATA

29. AWARD OF CONTRACT REF.

32e. MAILING ADDRESS OF AUTHORIZED GOVERNMENT REPRESENTATIVE

32c. DATE 32b. SIGNATURE OF AUTHORIZED GOVERNMENT REPRESENTATIVE

ACCEPTED, AND CONFORMS TO THE CONTRACT, EXCEPT AS

NOTED:

32a. QUANTITY IN COLUMN 21 HAS BEEN

RECEIVED INSPECTED

40. PAID BY39. S/R VOUCHER NUMBER38. S/R ACCOUNT NUMBER

37. CHECK NUMBER

FINALPARTIAL

36. PAYMENT

FINALPARTIAL

35. AMOUNT VERIFIED

CORRECT FOR

34. VOUCHER NUMBER33. SHIP NUMBER

COMPLETE

32g. E-MAIL OF AUTHORIZED GOVERNMENT REPRESENTATIVE

42d. TOTAL CONTAINERS42c. DATE REC'D (YY/MM/DD)

42b. RECEIVED AT (Location)

42a. RECEIVED BY (Print)

41c. DATE41b. SIGNATURE AND TITLE OF CERTIFYING OFFICER

41a. I CERTIFY THIS ACCOUNT IS CORRECT AND PROPER FOR PAYMENT

STANDARD FORM 1449 (REV. 3/2005) BACK

24.

AMOUNT

23.

UNIT PRICE

22.

UNIT

21.

QUANTITY

20.

SCHEDULE OF SUPPLIES/SERVICES

19.

ITEM NO.

32f. TELEPHONE NUMBER OF AUTHORIZED GOVERNMENT REPRESENTATIVE

32d. PRINTED NAME AND TITLE OF AUTHORIZED GOVERNMENT REPRESENTATIVE

168 2 of

CONSUMER FINANCIAL PROTECTION BUREAU

WASHINGTON, D.C. 20006

January 27, 2012

TO: Contractors

SUBJECT: Request for Proposals; RFP # CFP-12-R-00001, Collection, Transmission, Validation, Aggregation, Reporting, Storage, and Analysis of Credit Card Data (CCD Services)

Dear Contractors:

The purpose of this Request for Proposals (RFP) is to acquire contractor support, for the Office of Research, Markets & Regulations (RMR) Card Market Team within the Consumer Financial Protection Bureau (CFPB), with the collection, transmission, validation, aggregation, reporting, storage, and analysis of credit card data (CCD Services). The CFPB is requesting a proposal in compliance with the attached Performance Work Statement detailing how the contactor will support the CFPB in this regard.

The CFPB hereby issues a combined synopsis/solicitation for commercial items issued on FedBizOpps using the policies contained in FAR Part 12 - Acquisition of Commercial Items and the evaluation and award procedures of FAR Part 15 - Contracting by Negotiation to obtain contractor support services in the collection, transmission, validation, aggregation, reporting, storage, and analysis of credit card data submitted periodically by federally regulated banks.

Offerors are strongly encouraged to carefully read this entire RFP to include the proposal submission instructions. This RFP is similar yet distinct from a solicitation for a related need recently issued by The Department of the Treasury’s Office of the Comptroller of the Currency (OCC).

IMPORTANT: Please ensure your proposal is sent via e-mail with enough time before the deadline to reach the Points of Contact by the response deadline. In addition, please ensure that your proposal includes: 1) a completed version of the “Pricing Table” set forth in Section 11.0 of the attached, and 2) the items set forth in paragraphs (b)(1) through (b)(10) in the 52.212-1 Instructions To Offerors— Commercial Items (JUN 2008) clause set forth in the attached.

The following is the point of contact for this RFP:

CFPB Contracting Officer:

LAURENT E. PICHET

CONSUMER FINANCIAL PROTECTION BUREAU (CFPB)

1700 G Street, N.W.

WASHINGTON, DC 20006

(202) 435-7571

E-mail Address: Laurent.Pichet@cfpb.gov

Questions concerning this RFP must be submitted via e-mail by 2:00 p.m. Eastern Time on Friday February 3, 2012. The non-price section of your proposal shall not exceed 12 pages, excluding the cover page, table of contents, completed pricing template, Subcontracting Plan, Non-Disclosure Agreement, Small Business Participation Plan, and the Organizational Conflict Of Interest Disclosure/Representation Statement. The font size for the text in your proposal must be 12 point font or larger. All responses to this request are due no later than 4:00 p.m., Eastern Time, on Friday February 10, 2012.

The CFPB greatly appreciates your attention to this requirement.

Sincerely, /Signed/

Laurent E. Pichet Contracting Officer

Enclosures mailto:Laurent.Pichet@cfpb.gov

REQUEST FOR PROPOSALS

Background Section 1.0

Purpose Section 2.0

Scope Section 3.0

Data Elements Section 4.0

Tasks Section 5.0

Government Furnished Information, Property, and Section 6.0 Services

Performance Requirements Summary Section 7.0

Milestones and Deliverables Section 8.0

Pricing Template Section 9.0

SOLICITATION PROVISIONS Section A

52.212-1, Instructions to Offerors – Commercial Items Section A1

52.212-2, Evaluation – Commercial Items Section A2

52.212-3, Offeror Representations and Certifications – Commercial Items Section A3

CONTRACT CLAUSES Section B

52.212-4, Contract Terms and Conditions – Commercial Items Section B1

52.212-5 Contract Terms and Conditions Required To Implement Statutes and Executive Orders Section B2

Additional Clauses, Terms, and Conditions Section B3

ATTACHMENTS Section C

ATTACHMENT 1, Sample Subcontracting Plan

ATTACHMENT 2, Non Disclosure Agreement

ATTACHMENT 3, Sample Small Business Participation Plan

ATTACHMENT 4, Field Definitions

ATTACHMENT 5, Data Dictionary

ATTACHMENT 6, Schedule E Profit and Loss Statement

ATTACHMENT 7, Measures, Dimensions, and Definitions

ATTACHMENT 8, Report Examples

ATTACHMENT 9, Performance Requirements Summary Table

ATTACHMENT 10, Organizational Conflict of Interest Disclosure/ Representation Statement

ATTACHMENT 11, Past Performance Questionnaire

1.0 Background

On July 21, 2010, President Obama signed the Dodd-Frank Wall Street Reform and Consumer Protection Act (Act), which created the Consumer Financial Protection Bureau (CFPB). The CFPB is responsible for implementing and enforcing federal consumer protection laws. The CFPB also supervises large banks and non-depository institutions to ensure compliance with federal consumer law.

Comprehensive credit card data is needed by the CFPB for conducting market analysis across the credit card industry. By utilizing a standard set of data elements and definitions, sound conclusions can be drawn regarding the credit card industry. This data is important and required to support CFPB’s supervisory activities to ensure consumer protections laws are followed.

Under the Act and other federal consumer financial laws, the CFPB is authorized to collect, research, and monitor information relevant to the functioning of markets for consumer financial products. The general purpose of such research activities is to identify both risks to consumers and to ensure the proper functioning of consumer financial markets. These research activities will also support the CFPB’s general regulatory regime, ensuring that any rulemaking will reflect an understanding of the markets. Further, as the Act also requires the CFPB to issue reports on various consumer protection issues, the dataset gained from such research will also support these required reports.

Loan level data is the critical enabler in the CFPB’s efforts to analyze and understand consumer behavior and the credit card marketplace. Account-level information provides unique insight into understanding changes in the credit card market. This information can be used to support research into fees, charge-offs, rate increases, and balances. Such information maintained in a database can be used to create both present-day snapshots and historical trend data and help the CFPB understand the cost of credit and how the costs are realized by consumers. The highly granular information available through such a database will allow the CFPB to disaggregate the data in order to look at credit availability by customer group.

2.0 Purpose

The CFPB seeks to acquire support services for the collection, transmission, validation, aggregation, reporting, storage, and analysis of a distinct set of credit card data submitted periodically by and collected from nine (9) certain federally regulated banks (collectively referred to as the “Banks”). The purpose of this effort is to support the CFPB’s analysis of the credit card industry.

3.0 Scope

The selected firm will be required to provide services for the collection, transmission, validation, aggregation, reporting, storage, and analysis of credit card data on the behalf of the CFPB Card Market Team. The CFPB requires contractor expertise in working with large complex bank companies in regards to risk based analysis, benchmarking, and risk reporting for revolving credit card exposures. The credit card data sets will compliment already existing data sets currently collected by a third-party aggregator for the Department of the Treasury’s Office of the Comptroller of the Currency (OCC). The OCC currently collects comprehensive credit card data from nine (9) of the largest credit card issuing national banks based on standard data and definitions on a monthly basis.

The Banks that provide the CFPB with credit card data are different from the banks that currently provide data to the OCC.

The Contractor shall provide an electronic interface for filing or uploading of periodic reports for credit card data. The quality and reliability of the data shall be checked as part of the contractor’s and the Banks’ data validation processes.

The services include but are not limited to:

• providing direct assistance to the Banks to resolve data quality issues and make recommendations to the CFPB for further improving data quality;

• providing data to be stored on CFPB servers, which is conducive to the generation of reports and analytical analysis;

• creating the technical capability for the data collected from the Banks to be shared with the OCC, and for integrating bank data that is provided by the OCC pursuant to an existing Memorandum of Understanding (MOU) between the OCC and

CFPB;

• providing expertise in data aggregation and report design; and

• providing a secure web-based portal from which government agency users may generate previously defined reports, execute ad-hoc queries and define and/or download data extracts against previously submitted data, as content available from the web-based portal will be accessed by government agency users to conduct ongoing supervision and risk based analysis.

The Contractor may be required by the CFPB to share credit card data collected from the Banks with additional government entities as directed by the Contracting Officer’s Representative (COR). No other government entities will have the authority to request services or deliverables under the contract to be awarded.

At the CFPB’s discretion, one or more of the entities that comprise the Banks, as defined herein, may be replaced by another bank. In such cases, historical data collections may be required for reporting periods earlier than the contract award date from these banks.

All of the Contractor’s work product related to the contract awarded will belong to the CFPB. All communications with, and work performed for, the CFPB will remain confidential and can only be disclosed with prior written permission from the CFPB. The Contractor will perform all work in its own facilities.

4.0 Data Elements

The credit card data element definitions are described in Attachment 4. A data dictionary documenting the data types of the elements as currently stored is available in Attachment

5. Account level metrics will be submitted to the CFPB by nine (9) regulated participating banks on a monthly basis using data from the previous month end (the “As of Date”). On a monthly basis thereafter, the Banks have until the last day of the next month after the previous month’s end to submit the data - the “Reporting Date.” The Banks may file the data for the previous month any time during the following month. As needed, the Banks may resubmit their filing, either of their own accord or at the direction of the CFPB.

The Contractor shall submit portfolio level data to the CFPB quarterly by the month end date following the date of the public release of the Banks’ quarterly earnings statements.

The definitions and structure of portfolio level metrics are described in Attachments 4 and 5. The Contractor shall submit portfolio data current as of month end for each month in the quarter.

5.0 Tasks

The following performance requirements address the minimum required results to collect, aggregate, validate, store, retrieve and report on data series discussed herein. The Contractor’s system shall be available and ready to collect, aggregate, validate, store, retrieve and report credit card data in accordance with the requirement herein no later than thirty (30) calendar days after contract award.

The Contractor shall gather and store data elements identified in Attachments 4 and 5.

Where appropriate, and with the prior approval of the COR, the Contractor may derive certain items in order to ensure common definitions and consistency across the Banks (e.g. average daily balance, the mapping of credit scores to a score with a common definition). All accounts (pre-charge-off) will be reported by the Banks as well as all accounts charged-off within past 12 months. As additional supervisory requirements are defined, additional data elements or portfolio types may be added to the scope of data collection and validation. Any additional data elements and portfolio types added to the data collection and valuation by the request of the COR will be considered within the scope of this requirement and included in the proposed fixed unit prices.

In the event existing definitions need to be changed or data elements need to be added, the CFPB may consult with the Contractor, but final decisions on any definition language reside with the CFPB.

As part of the reporting requirements, the Contractor shall provide the portfolio level data in the reporting schedule format provided (Attachment 6).

The Contractor shall follow the elements as described in the data definitions and data dictionary.

The Contractor shall provide or perform each of the tasks listed below.

5.1 Task 1 - Data Collection and Transmission

The Contractor shall:

• Collect loan level and portfolio credit card servicing data from the Banks based on the prior month-end on a monthly basis.

• Be available and ready to receive data starting no later than thirty (30) calendar days after contract award.

• The Contractor’s system should aggregate this data with the related data provided to the OCC by other banks. The datasets should be able to be aggregated and treated as a single set when needed.

• Receive monthly filings from the Banks beginning the first of every month for the previous month’s data.

• Develop and assemble the structured formats (e.g. delimited text files) that will be utilized for data collection and transmission from the Banks based on the data elements provided in Attachments 4 and 5.

• Collect, transmit and receive credit card bank data files from the Banks.

• Coordinate monthly period end data submission with the Banks.

• Resolve any bank compliance issues of data based upon format, structure, transmission, and quality of the data from the Banks based on the CFPB templates and data definitions.

• Work with the Banks to achieve data submission compliance based on any additions, modifications, and clarifications to the data elements, schedules or definitions, when requested by the COR.

• Work with the Banks to facilitate data mapping or transformation of elements from single and/or disparate systems to comply with the Contractor’s data collection compliance and processes.

• Collect credit card data from single and/or disparate information systems based on the Banks’ information systems.

• Obtain COR approval to request a resubmission of data by a given bank and provide the appropriate supporting documentation to justify the need for the resubmission.

• Assist the Banks with the preparation and submission of filings immediately upon contract award.

• Work with the Banks to develop the strategy and plan of action for collecting required data elements that are not readily available from the Banks’ systems.

The Contractor will not be responsible for developing, modifying or fixing any deficiencies noted in the Banks’ systems. However, the Contractor shall notify the CFPB of such findings through status reports discussed in Section 5.9.4.

• Collect and leverage account level credit bureau attributes for expanded data analysis capabilities. The Contractor shall be responsible for safeguarding the privacy of account information to ensure that no social security numbers, names, addresses, bank account numbers or other personally identifiable information will be obtained under this Contract. (Given the sensitive nature of this information, account-level credit bureau attributes to be collected by the Contractor will be provided as government-furnished information at time of contract award).

5.2 Task 2 - Data Validation/Verification and Quality Control

The Contractor shall conduct a quality verification process covering all data before submitting such data to the CFPB. The Contractor shall conduct the initial validation process within three (3) business days of the reporting date. The Contractor shall validate the data submitted from the Banks in terms of data element compliance based on the lists of data elements and definitions in Attachments 4 and 5 and mandatory field requirements and constraints. The Contractor shall list all data elements and definitions (Attachments 4 and 5), mandatory field requirements and constraints, and quality review mechanism based on the following criteria for the generation of the Validation reports:

o Field specific data distributions including counts and percentages of loans with valid data;

o Identification of data that is not available for reporting because data is not maintained or collected;

o Edit check reports identifying on loan level and portfolio data that is corrupt and/or failed;

o Data trend reports to track improvements in data contributions; and o Data quality benchmarking reports – Bank comparisons.

The Contractor shall provide the edit and data quality reports to the CFPB within three

(3) business days after the reporting date. Thereafter, progress reports on the remediation of edit and data quality issues shall be submitted weekly. When no filings have been submitted, the report shall reflect this fact. The Contractor shall:

Perform analysis on individual and aggregate metrics and on benchmark analysis metrics.

Implement an initial set of edit and data quality rules based on the

Contractor’s knowledge and experience. The rules shall be interoperable with processes currently in use with existing credit card data collection systems.

Make recommendations to the CFPB for the implementation of additional automated edit and data quality rules based on the Contractor’s expertise and lessons learned from assisting the Banks.

Support the addition of new automated edit and data quality rules as well as the modification or deletion of existing rules.

Incorporate any additional edit and data quality rules provided by the CFPB on an ongoing basis. All additional rules shall be implemented into the Contractor’s system within ten (10) business days after the request from the

CFPB.

Remove any existing edit and data quality rule from the Contractor’s system within ten (10) business days after receiving a request for removal from the

Provide a quarterly report listing all edit and data quality rules, which have been implemented, modified or removed from the Contractor’s system as well as the date of their implementation, modification or removal.

The Contractor shall submit the first quarterly report of all edit and data quality rules no later than sixty (60) calendar days after contract award. Thereafter, the quarterly report shall be due at the beginning of each calendar quarter. The Contractor shall utilize any pre-existing business relationships with the Banks in order to facilitate data submission compliance. The Contractor shall be responsible for informing the COR of any necessary remediation of failed validity or data quality rules.

The Contractor shall work with the CFPB to define the data collection and analytical details for collecting and reporting the credit card metrics based on the definitions provided by the CFPB. The Contractor shall complete quality verification and assist with any required resubmissions in order to have the data ready for the generation of analytical reports or data extracts within ten (10) business days after the reporting date.

The Contractor shall update reports previously received or otherwise due (as defined by schedules detailed herein) within four (4) business days if resubmissions occur after the initial ten (10) business days.

• The Contractor shall provide a Data Quality Management Plan, which will document the processes by which the requirements for Data Validation and Verification will be met. Describe the methodology for conducting a quality verification process. The Data Quality Management Plan shall describe the implementation and maintenance of automated validation of the data. The Contract shall also incorporate the processes by which the objectives for Data Validation and Verification will be met into the Data Quality Management Plan. The Data Quality Management shall also include the methodology which will be executed to obtain complete data submissions and to ensure acceptable quality assurance levels for all deliverables. Proposed changes to the Data Quality Management Plan shall be submitted to the COR for approval prior to implementation.

5.3 Task 3 - Secure Data Transmission, Storage and Technology Infrastructure

The Contractor shall provide and maintain the technology needed to complete the tasks as set forth by the Performance Work Statement (PWS), which is contained in Sections 2.0-

5.0 herein. The Contractor shall add both the historical credit card data and the historical credit bureau attributes to the CFPB’s system repository no later than thirty (30) calendar days after contract award. This previously collected or compiled data (historical credit card data and credit bureau attributes) will be provided to the Contractor by the COR within ten (10) calendar days of contract award as Government-Furnished Information.

The Contractor shall incorporate and maintain this historical credit card data into the CFPB's system repository. The historical data is of a structure described in the CFPB's list of data elements (see Attachments 4 and 5) dating from a reporting period of January 2008 to the present. The quarterly credit bureau data attributes dating from the first quarter of 2009 to the present will be provided as Government-Furnished Information.

The raw historical data as submitted by the Banks for account-level and portfolio-level data combined requires a total of approximately 21 terabytes of uncompressed disk space storage. Historical resubmitted data requires an additional 500 gigabytes of uncompressed disk space storage. The growth rate of the raw monthly data submitted by the Banks requires about 502 gigabytes of uncompressed disk space storage. The system functionality described by all other requirements in the PWS shall apply to the historical credit card data, the historical credit bureau attributes as well as any new data collected in the future. The Contractor shall retain all submissions and resubmissions of the Banks for reference purposes.

All loan level and portfolio level data as well as all data aggregations (inclusive of historical data dating back to January 2008, supplemental data provided by the CFPB, and data provided by the Banks) must be retained by the Contractor for the life of the contract. All loan level and portfolio level data and all data aggregations shall be available for the life of the contract for use in reports, ad hoc queries and extracts as described throughout the PWS. Loan level data and historical loan level data from specific reporting periods (submissions or resubmissions) collected under the current contract, ad hoc queries and extracts, as described throughout the PWS, may be archived, but shall not be destroyed without prior written approval from the COR.

The Contractor shall provide the CFPB with a full extract of all data (loan level submissions and resubmissions, portfolio level, and aggregations), inclusive of historical data dating back to January 2008, supplemental data provided by the CFPB, and data provided by the Banks at the end of the contract performance period The extract shall be provided to the CFPB in a file format mutually agreed upon by both the Contractor and the CFPB. The Contractor shall be responsible for coordinating, assisting and responding to the Banks’ points of contact on the setup and configuration of any software required for data storage and transmission.

The Contractor shall provide a Data Management Plan (DMP) that documents all facets of the Contractor’s processing and storage of CFPB data. The DMP shall include the storage schema and details of the logical and physical database model, including the SQL statement (or equivalent for the technology used) to create the table structure, of the Contractor’s underlying database(s) for this system. The Contractor shall maintain and provide updates to the DMP when management and/or storage requirements change.

Any update or change to the DMP shall be submitted to the CFPB within seven (7) business days after the Contractor implements any new management or storage procedure.

If needed for reporting purposes, the CFPB reserves the right to provide additional data to the Contractor for storage and inclusion in reports. Such data shall be transmitted in a format and manner approved by the CFPB.

• The Contractor shall obtain credit card data collected by the OCC from other banks and incorporate into the CFPB system repository any of the items defined in the CFPB’s list of data elements (see Attachments 4 and 5) as well as previously collected credit bureau data attributes from the period beginning in January 2008.

This data shall be added to the CFPB’s system repository no later than thirty (30) calendar days after contract award and shall be available, along with data collected by the Contractor, for use in all other requirements included in the PWS.

5.4 Task 4 - Data Aggregation

• The Contractor shall be responsible for data aggregation, providing and aggregating bank loan level and portfolio data based on the CFPB Credit Card Metrics data definitions and the lists of data elements (Attachments 4 and 5).

• The Contractor shall be responsible for performing computations based on the

CFPB Credit Card Metrics Data Definitions.

• The Contractor shall be responsible for working with the individual bank teams of each of the Banks for the aggregation and validation of data from single and/or disparate systems.

• The Contractor shall be responsible for creating and maintaining a multi-dimensional data cube(s) of aggregated loan level data collected from the Banks.

• The CFPB may provide supplemental data which must be joined to the loan level data for inclusion in the data cube(s).

• The data cube shall include, but not be limited to, all dimensions and measures listed in Attachment 7 and is production ready no later than thirty

(30) calendar days after contract award. The Contractor shall ensure that the data cube(s) are production ready no later than thirty (30) calendar days after contract award.

• On a monthly basis, loan level data shall be loaded into the data cube(s) within ten (10) business days after the Reporting Date.

• The Contractor shall be responsible for refreshing the data cube(s) with resubmitted loan level or supplemental data. Pending resubmitted data shall be loaded into the data cube(s) by a deadline mutually agreed upon by both the CFPB and the Contractor, but shall not exceed three (3) months from the date of receipt of the data from the Banks or the CFPB.

• The Contractor shall be responsible for modifying the data cube by adding or removing any measure or dimension at the request of the COR. Such modifications shall be applied in a timeframe mutually agreed upon by both the CFPB and the Contractor. Said deadline shall not exceed three (3) months from the date of the request by the COR.

• The Contractor shall be responsible for documenting and maintaining a list of all production measures and dimensions to include, but not limited to, cross references to the list of collected data elements, definitions, and formulas used to derive each item.

• Report definitions for all current measures and dimensions shall be available on the web-based portal (see section 5.5.1) within thirty (30) calendar days of

5.5 Task 5 - Reporting

The Contractor shall provide a definition of a single report template. This definition should be clearly outlined in the successful offeror’s proposal.

5.5.1 Reporting Interface

• The Contractor shall provide secure internet access to a web-based portal for accessing previously defined reports, an ad-hoc query capability and data extracts.

• The website shall be production ready no later than thirty (30) calendar days after

• The website shall be accessible to CFPB-approved personnel.

• Access to the website shall be provided to CFPB approved personnel no later than thirty (30) calendar days after contract award.

• The website shall support a minimum of fifty (50) concurrent users.

• The website and its associated functionality shall be compatible with Microsoft

Internet Explorer 7 and above.

• The website and its associated functionality shall be Section 508 Compliant within five (5) calendar days of contract award.

5.5.2 Reporting CFPB Schedule E and Standardized Reports

• The Contractor shall provide the report(s) based on the CFPB Credit Card Metrics

Data Definitions.

• The Contractor shall provide Schedule E (Attachment 6) to the CFPB within seven (7) business days after the Reporting Date for end of quarter data.

• Schedule E must be downloadable into a MS Excel format based on the CFPB metric dimensions and presentation as depicted in Attachment 6 for the purpose of data analytics, pivot table creation and user designed reports.

• CFPB Schedule E shall be production ready no later than thirty (30) calendar days after contract award.

• The reports shall be printable to a printer defined on the user’s local machine.

• The Contractor shall be responsible for working with the CFPB to develop up to thirty (30) standardized recurring report templates, formatted as defined by the CFPB. Standardized recurring reporting shall include credit card metrics. This reporting capability shall include at a minimum:

o Providing and maintaining the definition of a report template, including, at a minimum, all formulas used to generate report content and the definitions of the population(s) represented;

o Identifying and customizing periodic (monthly or quarterly) report deliverable;

o Providing up to thirty (30) report templates on a recurring basis for credit card data. Templates shall support data reporting across the multiple reporting sources, and reporting templates may be substituted for another and/or updated reports; and o Delivering periodic and/or ad hoc market research analysis.

• Report definitions for all current report templates shall be available on the web-based portal (see section 5.5.1) within thirty (30) calendar days of contract award.

• The Contractor shall be responsible for designing, constructing and deploying the standardized reports, within ten (10) business days of receiving a request for creating said reports from the CFPB.

• On a monthly basis, previously deployed standardized reports shall be provided to the CFPB within ten (10) business days after the Reporting Date.

• Representative examples of the twenty-six (26) report templates to be maintained, populated and posted on a monthly basis are provided in Attachment 8.

• All standard reports required by this Contract must be production ready no later than thirty (30) days after contract award. A complete list of current reports and designs will be provided at the time of contract award as government-furnished information.

Logical names for data elements shall be vetted by the COR and changed at the request of the COR. The logical (or short business names) shall be required for use when rendering reports.

5.5.3 Gap Analysis Report

The Contractor shall develop and submit a GAP analysis report depicting the elements on the submission from each of the Banks no later than three (3) business days after the Reporting date. The report shall include, but is not limited to the following metrics:

o Detail information of the elements provided and not provided by a given Bank;

o Percentage of elements provided by all of the Banks both individually and in aggregate;

o Conformity of the data submitted based on the CFPB Metric definitions; and o Quality of data compared to the submission of the other Banks.

5.5.4 Additional Reports

• The Contractor shall assist and provide recommendations to the CFPB on additional analytical reports based on their expertise in data aggregation and analytics. The CFPB reserves the right to have the Contractor standardize these reports, and include or replace, existing standardize recurring reports as described in Section 5.5.2 Reporting CFPB Schedule E and Standardized Reports.

• The Contractor shall develop on demand analysis and reports when requested by

COR. The Contractor shall be responsible for designing, constructing and deploying additional reports, including the demand analysis and reports, within ten (10) business days of receiving a request for creating said reports from the

COR.

5.5.5 Ad-hoc Queries and Reporting

• The Contractor shall be responsible for providing a secure online ad-hoc query capability via the web based portal against loan level and portfolio credit card records and display the query results based on the measures specified in the query.

• The ad-hoc query tool shall allow the user to filter data in the database according to any number of parameters.

• The ad-hoc query tool shall allow the user to select what data elements from the database to include in the result set.

• Logical names for data elements shall be vetted by the COR and changed at the request of the COR. The logical (or short business names) shall be required for use when executing ad-hoc queries.

• The ad-hoc query tool shall allow the user to view the results of the search securely online.

• The ad-hoc query tool shall allow for the download of the result set to the user’s local machine in various file formats (e.g. a delimitated file, Microsoft Excel or

SAS).

• For large results where downloading the result set to a local machine would be performance prohibitive, the Contractor shall provide alternative methods for transferring the data securely to the CFPB (e.g. utilizing secure file transfer protocol, encrypted hard drive).

• The Contractors shall identify and address all restrictions placed on its services with regard to downloading materials.

• The ad-hoc query tool functionally shall be production ready no later than thirty

(30) calendar days after contract award.

5.5.6 Aggregated Data Analysis

• The Contractor shall be responsible for providing a secure online data analysis tool as a front end interface to the multi-dimensional data cube(s).

• The analysis tool shall allow the user to create pivot tables based on all dimensions and measures included, but not limited to, those listed in Attachment 7.

• The analysis tool shall allow the user to download the result set to user’s local machine in a, at a minimum, Microsoft Excel format.

• The analysis tool shall support, at a minimum, one-hundred (100) named (not concurrent) users, and shall also allow for additional users as requested by the

COR.

• The Contractor shall be responsible for tuning the analysis tool and the underlying data cube(s) to meet levels of functional performance deemed acceptable by the

• The analysis tool functionally shall be production ready no later than thirty (30) calendar days after contract award.

5.6 Task 6 - Data Extract Capabilities

• The Contractor shall be responsible for extracting and delivering loan level and portfolio bank data by means of a compatible file format (e.g., delimitated file type, Microsoft Excel, SAS) to the CFPB. The extract shall include validated credit card metrics loan level and/or portfolio data.

• The Contractor shall work with the CFPB to define the preferred secure method for delivery of the data (e.g. utilizing secure file transfer protocol, encrypted hard drive).

• The Contractor shall be responsible for extracting the data based on the specific on demand data query requests by the CFPB. (i.e., aggregate, loan level or portfolio extractions).

• The Contractor’s system shall have data extract capabilities to meet these requirements no later than 30 calendar days after contract award.

• The Contractor shall provide full or partial data extracts of database content upon request from by the CFPB.

• Ad-hoc data extracts shall be due no later than one (1) business day after a request by the CFPB.

• Data extracts which are to be executed on a monthly basis shall be provided to the CFPB within twelve (12) business days after the Reporting Date.

5.7 Task 7 - Technical and Analytical Support

• The Contractor shall be responsible for providing technical and analytical support, Monday through Friday, 8am – 5pm ET.

• The Contractor shall be responsible for providing remediation to the CFPB within twenty four (24) hours of the initial support call from the CFPB to the Contractor.

• The Contractor shall provide the direct contact information for Contractor support personnel.

• The Contractor shall be prepared to provide technical and analytical support beginning the day of contract award.

5. 8 Task 8 - System Testing, Training and Documentation

• The Contractor shall be responsible for providing a test environment to perform acceptance testing for the CFPB requirements referenced in the bullet below.

• The Contractor shall develop and submit to the CFPB for approval a Test

Plan, which details the process for, and facilitation of acceptance testing of CFPB requirements referenced below. Topics shall include, but are not limited to, testing and acceptance of the following areas along with a proposed schedule for each. Where appropriate, the Test Plan should solicit the participation of CFPB personnel in the acceptance testing process (e.g. testing of standardized reports). For the CFPB requirements, reference is made to:

o Schedule E and Standardized Reports as described in Section 5.5.2;

o Gap analysis report as described in Section 5.5.3;

o Ad-hoc queries and reporting as described in Section 5.5.5;

o Aggregated Data Analysis in Section 5.5.6; and o Data extracts as described in Section 5.6.

• The Contractor shall facilitate acceptance testing through the implementation of the test plan.

• The Contractor shall develop a user-training plan for the system.

The Contractor shall be responsible for delivery of a system user manual and training documentation within sixty (60) calendar days of contract award.

• The Contractor shall provide training on the secure online reporting and querying capabilities in accordance with the training plan. Up to ten (10) training sessions shall be performed at two or more of the CFPB Training Centers located in Washington, DC.

• The Contractor shall be prepared to begin conducting training sessions no later than sixty (60) days after contract award. Exact dates for initial session(s) shall be approved by the CFPB after contract award.

5.9 Task 9 - General Management, Resources, Decision Making

5.9.1 Relationships with the Participants

The Contractor shall take a collaborative approach with the CFPB and the Banks in providing data management assistance. The Contractor shall keep the CFPB well informed of project activities, timelines and status to facilitate rapid resolution of any problems or issues that may arise.

The Contractor shall be responsible for maintaining a log of any issues (open and closed) which have arisen with each of the Banks. The Contractor shall provide the CFPB with an updated copy of the log at least every week.

The Contractor shall schedule and coordinate a weekly status conference call at a time mutually agreeable between the Contractor and the CFPB to discuss progress of the performance requirements identified, the first of which shall be held no later than seven (7) calendar days after the date of contract award. The CFPB reserves the right to change the frequency and occurrence of this conference call.

The COR will notify the Contractor at least twenty four (24) hours in advance of any date change and seven (7) calendar days in advance of any changes in frequency.

5.9.2 Resources

The Contractor shall provide the necessary resources to effectively accept data transfers from the Banks; provide support to the Banks and support validation, storage, and reporting services on behalf of the CFPB as described in the PWS.

5.9.3 Decision Making

The Contractor shall obtain CFPB input and approval on project activities and timelines. The Contractor shall provide the CFPB with recommendations and obtain CFPB approval prior to making requests of the Banks.

5.9.4 Management Reports

The Contractor shall be responsible for meeting summaries, issues and actions based on meetings held with the participating banking institutions pertaining to data quality, validation, verification and resubmission as specified by the CFPB and provide this information to the CFPB as part of the weekly report. This report shall include a brief summary of the meeting, participants, location and date time of the meeting.

The Contractor shall provide a Project Plan identifying key milestones and completion dates for each requirement. The final version is due no later than ten

(10) business days after contract award.

The Contractor shall provide weekly written status reports to the COR. The report at a minimum shall consist of:

o Updates to the Project Plan;

o Performance requirements completed;

o Performance requirements to be addressed over the next period;

o Issues or risks surrounding performance requirements and mitigation strategies per reporting bank;

o Issues requiring CFPB assistance;

o Critical deficiencies discovered to date per each of the Banks, even if preliminarily assessed;

o Project activities;

o Timelines; and o Status of issues that have arisen in the execution of this contract.

6.0 Government Furnished Information, Property, and Services

• Account level credit bureau attributes to be collected by the Contractor will be provided by the CFPB at time of award.

• Credit card data collected as well as previously collected credit bureau data attributes from the period beginning in January 2008, which will be provided by the OCC.

• A complete list of current reports and designs will be provided by the CFPB at time of award.

• Training facilities, government furnished equipment and telecommunications services for the training sessions (reference to Section 5.8, Task 8) will be provided by the CFPB.

• A list of authorized users for the system will be provided by the CFPB after award.

7.0 Performance Requirements Summary

The contractor service requirements are summarized into performance objectives that relate directly to mission essential items. The Performance Requirements Deliverable Summary below briefly describes the thresholds or minimum acceptable levels of service required for each performance requirement. These thresholds are critical to mission success. Performance Objectives, Performance Standards, and Acceptable Quality Levels are provided as “Attachment 9” of this solicitation.

8.0 Milestones and Deliverables

Table 1 – Performance Requirements Deliverable Summary

PWS Reference Scheduled Delivery

TASK 1 - 5.1 Data Collection / Transmission

Data Collection The Contractor’s system shall be available and ready to collect, aggregate, validate, store, retrieve and report credit card data within thirty (30) calendar days after contract award.

The Contractor’s system shall have the ability to receive data within thirty (30) calendar days after contract award.

Resubmissions In the event of resubmission, the Contractor shall update reports previously received or otherwise due (as defined by schedules detailed herein) within four (4) business days.

Bank Assistance The Contractor shall begin assisting the Banks with the preparation and submission of filings immediately upon contract award.

TASK 2 - 5.2 Data Validation /Verification and Quality Control

Data Verification The initial verification process shall be completed within three (3) business days after the Reporting Date.

Data Ready for Reporting All data validation, resubmission, etc. shall be completed so that the Contractor can release the data to the CFPB as verified and shall be completed within ten (10) business days of the Reporting Date.

Additional Edit and Quality Checks Additional rules shall be implemented into the Contractor’s system within ten (10) business days after the request from the CFPB.

The Contractor shall remove any existing edit and data quality rule from the Contractor’s system within ten (10) business days after receiving a request for removal from the CFPB.

Edit and Data Quality Reports Edit and data quality reports shall be submitted to the CFPB within three (3) business days after the Reporting Date. Thereafter, progress reports on the remediation of edit and data quality issues shall be submitted weekly. When no filings have been submitted, the report shall reflect this fact.

Data Edit and Quality Rules List Shall be submitted quarterly with the first version due no later than sixty (60) calendar days after contract award. Thereafter, the quarterly report shall be due at the beginning of each calendar quarter.

Recommendations for additional Data Edit and Quality Rules Shall be submitted to the CFPB at weekly status meetings.

Data Quality Management Plan Proposed changes to the Data Quality Management Plan shall be submitted to the COR for approval prior to implementation.

TASK 3 - 5.3 Secure Data Transmission, Storage and Technology Infrastructure

Provide 24x7 access to the data with the exception of agreed upon maintenance periods. The system shall be available at least 99 % of the time.

Both the historical credit card data and the historical credit bureau attributes shall be added to the CFPB’s system repository no later than thirty (30) calendar days after contract award.

The Contractor shall incorporate and maintain historical credit card data and credit bureau attributes into the CFPB's system repository.

The historical data is of a structure described in the CFPB's list of data elements (see Attachments 4 and 5) dating from a reporting period of January 2008 to the present. Additionally, within ten (10) calendar days after contact award, the Contractor shall be provided quarterly credit bureau data attributes dating from the first quarter of

2009 to the present.

System functionality described by all other requirements in the PWS shall apply to the historical credit card data, the historical credit bureau attributes as well as any new data collected in the future.

At the end of the contract performance period, the Contractor shall provide the CFPB with a full extract of all data (loan level submissions and resubmissions, portfolio level, and aggregations), be it historical data from 2008, supplemental data provided by the CFPB, or data provided by the Banks.

Data Management Plan (DMP) Updates to the DMP shall be submitted to the COR within seven (7) business days after the Contractor implements any new management or storage procedure.

TASK 4 - 5.4 Data Aggregation

Aggregation of data to create reports and data extract as identified in…