Data_Archiving_RFI__2-11-16.docx

03.11.2015 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj Request for Information

ATTACHMENT 3

FRANCHISE TAX BOARD

RFI RESPONSE FORMAT

02.11.2016 Request for Information

February 11, 2016

To: INTERESTED PARTICIPANTS

Subject: RFI FTB-1516-Data Archive Solution

A. PURPOSE

The Franchise Tax Board (FTB) is surveying the marketplace for potential vendors that can provide a data archive solution for structured data relating to the Personal Income Tax program.

This RFI contains FTB’s draft requirements for the desired solution. We would also like to request that interested participants with alternatives to the draft requirements provide those alternatives in the additional information area of Attachment 2, RFI Response Format/Additional Information.

If you plan on responding to this RFI, please email your contact information to John.Marengo@ftb.ca.gov by 2:00 PM PT on February 16, 2016.

IMPORTANT INFORMATION – PLEASE READ BEFORE RESPONDING TO THIS RFI

1. FTB will not reimburse Respondents for any costs associated with responding to this RFI.

2. FTB has no obligation to buy or issue a solicitation to any Respondent as a result of this RFI.

3. Information provided in response to this RFI will not be considered when evaluating bidders responding to any future procurement.

4. Responses to this RFI will become public record, upon completion of the RFI process.

5. Information provided in response to this RFI related to any costing should be estimated catalog pricing, only to be used by FTB for informational and planning purposes, and understood by Respondent and FTB not to be represented as a bid from the Respondent.

6. If this RFI results in a future procurement, Respondents will have to agree to the following State terms and conditions and applicable Leveraged Procurement Agreement terms and conditions:

– Revised and Effective 9/5/14

7. FTB may, at its sole discretion, choose to not consider or evaluate any response, or any portion of a response, received as a result of this RFI.

B. SCOPE

FTB intends to implement an enterprise-wide secure data archive solution for personal income tax data that will be scalable to other types of data in the future. The proposed data archive solution must be able to directly interface with FTB's existing infrastructure, must be able to purge the archived data from the archive solution based on predefined rules and predefined schedules, and must have the ability to allow users to search for specific taxpayers, within the taxpayers' folder, in specific tax years.

C. FTB's EXISTING INFRASTRUCTURE The Enterprise Data to Revenue Project lays the foundation for modernizing our tax systems over the long-term and is comprised of four major components: return processing system, enterprise data warehouse, secured online taxpayer folder, and modernized systems. FTB’s mainframe is an IBM Enterprise Class Server that supports all major tax program areas as well as non-tax debt programs, residing on ADABAS and DB2 databases. The mainframe environment utilizes a Virtual Tape Library (VTL).

Server Infrastructure FTB has a large distributed computing environment attached to its enterprise. The distributed environment consists of large client/server applications, web applications, smaller LAN based applications and office automation including electronic mail. UNIX servers include IBM and HP servers, DB2 and Sybase ASE are the common Database Management Systems (DBMS) on these servers. Programming languages for online applications are primarily Visual Studio, Power Builder, or Java, and COBOL or C for batch applications.

Windows servers include Dell, IBM and HP which use Active Directory Services. Microsoft SQL Server and Oracle are the primary DBMS on these servers. Programming languages for applications accessing these servers are primarily Microsoft based. The distributed systems connect to Storage Area Networks (SANS). Backups are maintained on an automated tape library using Tivoli Storage Manager backup utility.

Network Infrastructure The Local Area Network at FTBs campus is the heart of the enterprise network, providing reliability and scalability. There are approximately 6,000 clients supported on the network. The dedicated Virtual Private Network (VPN) gateways provide access for remote users. Remote users’ FTB issued computers are configured with secure clients integrated with personal firewalls. An alternative to an FTB issued computer, is the VPN web portal which provides access to FTB resources via users personal PC.

Storage Infrastructure Mainframe Enterprise Storage Management supports all storage associated with the Mainframe Enterprise Server infrastructure, which includes hardware and software for Direct Access Storage Devices and tapes both virtual and real, used for backup, recovery and batch processing.

Mainframe Infrastructure Systems Supporting FTB Production, Development and Software environments, the Enterprise Class Mainframe Disk Storage devices consists of highly fault tolerate storage primarily for production use. Managed by a Tape Management System and other systems software, the mainframe Tape Storage infrastructure is a VTL consisting of a large high-speed virtual tape subsystem and high-density real tape drives.

Distributed Infrastructure Systems Distributed Tape Storage Infrastructure utilizes software from two different manufacturers in order to accomplish our distributed backup goals. The backup services store data for Windows servers & UNIX servers which host Sybase, DB2, Oracle & MSSQL databases.

D. KEY ACTION DATES

Listed below are the key action dates and times within which actions should be taken or completed. If FTB finds it necessary to change any of these dates, an Addendum to this RFI will be posted on the (Cal eProcure) Webpage at https://www.caleprocure.ca.gov/pages/. Respondents must register with Cal eProcure to submit questions and receive question and answer sets that may be issued.

E. CONTACT OFFICIAL

All correspondence related to this RFI shall be directed to:

Attention: John Marengo Franchise Tax Board EMAIL: John.Marengo@ftb.ca.gov Phone: 916-845-6160 Fax: 916-364-2701

F. RFI RESPONSE AND CONTENT FORMAT

If Respondents are interested in participating in this RFI, please adhere to the action, dates and times included in section D, Key Action Dates. The Respondent shall take the following action:

1. Prepare a cover page to their response that includes the following:

a. Company name;

b. Company mailing address;

c. Point of contact information (name, telephone number, and email address);

d. List the RFI number provided on Page 1 of this RFI.

2. Include responses to: ATTACHMENT 1 – Business and Technical Requirements

a. FTB requests that Respondents specify whether their proposed data archive solution meets each requirement set forth on ATTACHMENT 1 – Business and Technical Requirements by marking "Yes" or "No" next to each requirement description. .

3. Include responses to Request 1 & 2 of ATTACHMENT 2 – RFI Response Format/Additional Information

a. FTB requests that Respondents list in detail all components of their proposed data archive solution and estimated budgetary pricing. Pricing is only for FTB planning purposes, and is an attempt to gauge the estimated cost of a possible implementation of a data archive solution based on the projected volume of 1 terabyte of data. Any pricing provided in a response to this RFI is not an offer and will not be considered an offer on the part of Respondents.

b. FTB requests that the Respondents list all hardware, software, and services that are included in the costing estimate.

4. Include response to Request 3 of ATTACHMENT 2 – RFI Response Format/Additional Information.

Examples of additional information includes:

a. FTB requests that Respondents provide any product specifications, literature, narratives, diagrams, pictures, or any other documentation relating to their data archive solution that meets these requirements as they pertain to the data archive solution being proposed.

b. Lessons learned from other data archive solutions that Respondent has installed containing substantially similar requirements as the data archive solution proposed in response to this RFI.

c. Any training that would be included and provided to the FTB Enterprise Data Warehouse Team in order to support your proposed data archive solution.

d. Information regarding any Leveraged Procurement Agreement’s (LPA) your company has through the Department of General Services (DGS), and the equipment available via that DGS LPA(s). Please include any applicable contract numbers(s).

e. Any alternative requirements to the draft requirements provided in this RFI.

5. Respondents are to submit their responses in soft copy to the Contact Official listed in section E, by email or fax. Microsoft Word 2003 or newer or PDF format are acceptable. RFI responses must be submitted by the deadline identified in Section D, Key Action Dates.

chair Betty T. Yee member Jerome E. Horton member Michael Cohen

00.00.07 Subject / Topic

02.11.2016 Request for Information

Upon RFI Response opening, all documents submitted in response to this RFI will become the property of FTB, and will be regarded as public records under the California Public Records Act (Government Code section 6250 et. Seq.) and subject to review by the public unless it’s deemed proprietary trade secret information. This confidential information must be clearly marked and identified as such on each page of the response on which it appears. Simply marking the entire response as confidential will NOT suffice. If a Public Records Act request is received, the marked information will be independently assessed by FTB as to whether or not the information is indeed exempt. If deemed non-exempt, the respondent will be notified of our intention to disclose it, giving the Respondent an opportunity to intervene.

Procurement Bureau PO Box 2086, MS A-374 Sacramento CA 95741-2086 tel 916.845.6160 fax 916.364-2701 John.Marengo@ftb.ca.gov

G. ATTACHMENTS

1. ATTACHMENT 1 – Business and Technical Requirements

2. ATTACHMENT 2 – RFI Response Format/Additional Information

3. ATTACHMENT 3 – Links to Security Guidelines and Standards Manuals image1.jpeg image10.jpeg