| Program Summary |
 |
| Title: |
R -- Database Managment |
| GovCB Opps ID : |
ADP11968238950000952 |
| Document Type: |
Amendment to Combined Synopsis/Solicitation |
| FSC Code: |
R - Professional, Administrative and Management Support Services
|
| Solicitation No.: |
08-RFQ-04 |
| Source: |
http://www2.fbo.gov/spg/FCA/OCAO/FCAASD/08%2DRFQ%2D04/Amendment%20to%20Combined%20Synops... |
Place of
Performance: |
Address: 1501 Farm Credit Drive McLean, VA Postal Code: 22102-5090 Country: UNITED STATES
|
Posted Date:
|
Dec 04, 2007 |
| Last Update: |
Feb 25, 2008 |
| Due Date: |
Dec 12, 2007 |
|
| Description |
|
General Information
| Document Type: |
Amendment to Combined Synopsis/Solicitation |
| Solicitation Number: |
08-RFQ-04 |
| Posted Date: |
Dec 04, 2007 |
| Original Response Date: |
Dec 12, 2007 |
| Current Response Date: |
Dec 12, 2007 |
| Original Archive Date: |
Dec 27, 2007 |
| Current Archive Date: |
Dec 27, 2007 |
| Classification Code: |
R -- Professional, administrative, and management support services |
| Naics Code: |
541511 -- Custom Computer Programming Services |
Contracting Office Address
Farm Credit Administration, Office of Management Services, Personnel and Purchasing Team, 1501 Farm Credit Drive, Mclean, VA, 22102-5090, UNITED STATES
Description
Amendment 3 - questions/answers
26. Is it expected that the current delivery method will suffice, or should a standard delivery method be included as part of the proposed effort? FCA expects that contractor will develop an application that will automatically load the received datasets into SQL Server and that any errors will be logged and sent to appropriate FCA staff for their action.
27. What is the preferred method for handling errors in uploaded data? Do we have to develop any workflow process to handle data validation errors? If so, can you describe the process that needs to be developed? FCA expects that the contractor will develop an application that will automatically load the datasets into SQL Server and that any errors will be logged and sent to appropriate FCA staff for their action.
28. What kind of technology infrastructure exists today for the different agencies to upload the files? Is it .NET based or java based? Does the agency have any preference to which technology should be used for building the web interface to upload the data? The SOW does not request that a web interface be developed to upload the data. This application should be built using Microsoft Visual Studio.
29. The SOW states that data files are in various formats (Access, Excel, and delimited text); however, there is a later statement in the SOW that states "the contractor will automate the process that takes the submitted XML files from the FCA's web site and loads them into the target database." I am confused as to whether the data files are in raw formats (Access, Excel, text delimited) or if the files are already in a standard XML format. FCA currently receives files in Access, Excel and comma-delimited format. The institutions may choose to submit the files in XML in the future.
30. Can you please clarify the format of the data files?
? If the files are in raw format, is it required to first turn the raw format into XML, and then load the XML file into the database? No.
? Is there a reason that raw formatted files cannot be directly loaded into the database? No.
31. The FCA will continue to accept new data elements. Is there a change control policy in place for modifying the XML schema? No, FCA accepts any format. Are there any constraints on the type of software for building the user interface? FCA is not requesting that a user interface to the institutions be built. FCA wants an application to be developed that will automate the loading the files received from the institutions. This application should be built using Microsoft Visual Studio.
32. Under the project background section there is a desire to continue to accept new data elements from institutions when they want to provide more information to FCA while under the Scope section there is a requirement to develop an xml schema to replace the current ad-hoc method of data submission. Is there a change control policy in place for modifying the xml schema? Can there be a freeze on the XML schema while development is taking place? No, FCA will continue to accept new data elements during the duration of this contract.
33. In the introduction paragraph under SCOPE, it says ?The database structures will be populated with data using XML and also using the current methods described above.? Does FCA want to continue to be able to receive data transfers from the district offices or other providers in MS Access, MS Excel and text files? Yes. Does FCA want the contractor?s DBA to manage ongoing loading of such data? No.
34. In the introduction paragraph under SCOPE - Is there a specific reason that FCA prefers XML-format? Does FCA plan to use this data for other purposes, or do they simply favor XML for other reasons? An XML format can affect performance on large uploads and requires larger storage space than other formats. XML is vendor neutral and provides maximum flexibility to the institutions in the generation of their data sets.
35. In Task 2 - Does FCA want to make the upload user-interface available to all of the 95 offices, or just the 5 district offices? FCA has developed a method for the institutions to submit the datasets on FCA?s web site. As Task 2 is defined in the SOW: The Contractor will automate the process that takes the submitted files and loads them into the target database. The Contractor will also automate the process of identifying new data fields that are submitted by the institutions. Additionally, the Contractor will work with FCA to develop checks between this new data system and FCA's Call Report System (CRS) to ensure the data in this new data system are reasonable before the data are made available to FCA's users.
36. In Task 2 ? ?the Contractor will work with FCA to develop checks between this new data system and FCA's Call Report System.? Does each upload to the central db at OE need to be checked against the CRS each time or is the check against the CRS a one-time check to verify the data from the new solution is coming in correctly? Each upload needs to be error checked and validated.
37. In Task 2 ? What would FCA like to check in relation to the Call Report System (CRS) and will the CRS continue to operate after the implementation of the new system? Can we get a description of what the CRS is and how the data is verified currently? The total book volume received in the datasets for an institution is compared to the total loan volume for the institution in CRS. This is done with a simple query of CRS and the two values should be within 10% of each other. FCA may want to add several other simple validations.
38. In Task 2 ?Where/When is the CRS currently run (in the main database, through another program?)? It would be helpful to get the specifications on how this system runs and what it does to check the data so that we can write a program that will be compatible. See answer to question 37.
Tasks 3 & 4 - Data Collection/Storage/Mapping
39. Data Collection, Mapping, Views ? Does FCA have an estimate of the amount of data? For example, the number of records overall? The number of records uploaded monthly?
AgFirst District data set is provided in a zipped MS Access database for each institution. The total district data is approximately 150MB zipped and includes over 150,000 data rows.
The Texas District provides data for its 20 affiliated associations. The submission includes active and inactive loans as well as informational records on gross participation credits. A typical monthly submission from this district is about 3Gs and includes around 70,000 data rows.
The Agribank District provides two databases. Total size is approximately 600MB and includes around 355,000 data rows.
The Wichita submission is approximately 20MB and includes almost 50,000 data rows.
There are approximately 23 other institutions that do not use one of the above service providers. We refer to these as the Independents.
40. In Task 3 - Is the focus of the data to monitor banks and banking activities, or to monitor the performance of the loan portfolio in relation to timely payments and performance? Or both? FCA wants to measure credit quality and mission performance. However, Task 3 is about data collection and storage.
41. In Task 3 - Does FCA need any reports that would calculate functions relative to mortgage repayment schedules or amortizations? No.
42. In Task 4 ? FCA has outlined a requirement to automate the mapping of new data sets: ?The data maps, related look-up tables and scripts will be automated to the maximum extent possible?. What is the expectation for this requirement since new data fields can be added by any of the 95 contributing offices without giving FCA prior warning? FCA would like the data load system that the contractor will develop to alert selected staff when new data elements are received from the institutions. FCA will then determine whether the new data elements fit an existing column or whether a new column will be added to the SQL Server table.
43. Can you provide the details of the current mapping that has been identified so far as described in the task 4? See Question 39 above.
Task 5 ? Data Views
44. Can you specify the approximate number of views need to be created for task 5? 12 views or less.
45. Do you require that the views created in task 5, be accessible via a web browser? If not, how do you envision that users/offices view the data? FCA users do not require a web browser to access the views. They will use MS Office tools to query the data.
46. Please advise what reporting tool FCA plans to use. Will it simply be custom views created in Oracle/SQL Query or is there a different COTS product that will be utilized? FCA will query the tables as well as the custom views.
47. How many standard views are being requested under this fixed price portion of the contract? 12 views or less. Can these be determined before the data model is finalized? Are there some existing today that can be shared before submission? One of the evaluation criteria is "Understanding of the desired data warehouse and related views." Is there a description of the desired views available? No.
48. Project task #5 requires the contractor to "develop a collection of standard data views based on user requirements."
? Do user requirements already exist? No.
? If not, does the requirement gathering effort need to be accounted for in the proposal cost? No.
? If requirements do exist, is there an approximate number of known views that need to be created? 12 views or less.
? If requirements do exist, what are the views that need to be created? Details will be provided once the contract is awarded.
? Is there a standard format/tool/technology that FCA uses for data views? No.
49. In Task 5 - Will the end users for the central database be only the "Offices" (OE, ORP and OMS)? Only FCA staff will access the views.
50. In Task 5 - Does each Office have a list of the data and concept of how they want to see the data displayed in the final product? If so, can they give more details about what type of information they would like to see in their individual reports, or would FCA prefer to wait until the contract has been awarded to address the particulars of the reports? The contract does not call for the development of reporting tools.
51. In Task 5 ? Each office (OE, ORP and OMS) would like to see segregated data views. Do they require entirely different screens to view the data or just an ability to see the data differently? Does each office require a web-based interface that is accessible from various locations, or will access to the database be restricted to use at OE? Or is a different type of access required? FCA will provide more detailed specifications on the views after the contract is awarded.
52. In Task 5 - If each "Office" (OE, ORP and OMS) needs different data views, would these screens or views be accessible only by the office requesting them, or should the screens be available to all three Offices (i.e., should OE have access to the customized screens requested by ORP?). The views will be available to all FCA staff with access to the database.
The Farm Credit Administration (FCA) has an immediate need for services from a qualified person(s) who is knowledgeable of and experienced in relational database management design and development, as well as data loading and mining operations. The Contractor will assist FCA in developing a database to accumulate and store the loan portfolio data submitted by FArm Credit System institutions to the FCA. The database will enhance the data interrogation capabilities of the FCA's examination and regulation and policy development staff by consolidating System data into a single database with comparable data fields. The data tables will facilitate macro analysis of oversight of the System.
Interested parties should contact Reevest@fca.gov for a complete Statement of Work.
Questions will be received through November 30, 2007, at 2:00 PM EST. An amendment will be posted answering questions December 4, 2007.
Proposals should be sent to Reevest@FCA.gov no later than 3:00 PM EST, Wednesday, December 12, 2007.
CLAIMS FOR RELIEF
The FCA is a nonappropriated fund activity not subject to GAO's bid protest provisions. Any claim for relief filed by an offeror shall be adjudicated by the FCA Contracting Officer. If the parties cannot reach an agreement mutually satisfactory after diligently pursuing a solution through discussions and negotiations, the FCA Contracting Officer shall make a final decision. The FCA Contracting Officer's decision shall prevail unless the offeror submits an appeal to the FCA Chief Financial Officer (CFO) Stephen G. Smith. The decision of the CFO shall be final and binding on the parties.
Original Point of Contact
Tracy Reeves, Purchasing Agent, Phone 703-883-4111, Fax 703-883-4151, Email reevest@fca.gov - Philip Shebest, FCA Agency Administrator, Phone 703-883-4135, Fax 703-893-2608, Email shebestp@fca.gov
Current Point of Contact
Tracy Reeves, Contracting Specialist, Phone 703-883-4111, Fax 703-883-4151, Email reevest@fca.gov
Place of Performance
| Address: |
1501 Farm Credit Drive
McLean, VA |
| Postal Code: |
22102-5090 |
| Country: |
UNITED STATES |
|
|
