I. GENERAL INFORMATION The U.S. Department of Transportation's (DOT) Maritime Administration (MARAD) intends to award a contract to Management Systems Consulting LLC (MSC). MSC has developed a NS5 data extraction tool for their commercial clients that meets all MARAD requirements cited in the Statement of Work, including the critical requirements to segregate data visibility by site as well as to prevent access to other Ship Manager's data from unauthorized users. MSC owns the source code and is the only entity that can make changes in the software. This product is a proprietary application with the source code wholly owned by MSC and is in use with many clients for varied purposes. II. TOTAL ESTIMATED VALUE The total estimated value is Not-to-Exceed one hundred thousand and 00/100 dollars ($100,000.00). III. STATEMENT OF WORK Refer to ATTACHMENT 1. IV. JUSTIFICATION FOR OTHER THAN FULL AND OPEN COMPETITION Refer to ATTACHMENT 2. V. ADDITIONAL INFORMATION The contract action is for services for which the Government has solicited and negotiated with only one source under the authority of FAR 6.302. Interested persons may identify their interest and capability to respond to the requirement or submit proposals. This notice of intent is not a request for competitive proposals. However, all proposals received within fourteen (14) days after date of publication of this synopsis will be considered by the Government. A determination by the Government not to compete with this proposed contract based upon responses to this notice is solely within the discretion of the Government. Information received will normally be considered solely for the purpose of determining whether to conduct a competitive procurement. Interested persons should identify their interest and capability to perform these services or submit proposals to Ms. Vonetta Davis or Frank Bajowski via e-mail at
[email protected] or
[email protected] by 3:30 pm on Thursday, 7 February 2008. ATTENTION: Minority, Women-owned, and Disadvantaged Business Enterprises (DBEs)! The Department of Transportation (DOT), Short-Term Lending Program (STLP) offers working capital financing in the form of lines of credit to finance accounts receivable for transportation related contracts. Maximum line of credit is $750,000 with interest at the prime rate, as published daily in the Wall Street Journal, plus 1.75 percent. For further information, call (800) 532-1169. Internet address: http://osdbuweb.dot.gov/. Notes: This request makes no implication of future work and does not represent a commitment by MARAD. ATTACHMENT 1 STATEMENT OF WORK STATEMENT OF WORK Item 1. Ship Manager NS5 Data Extraction Tool. As used in this SOW, the term "ship manager" includes MARAD's Logistics Support Contractor's two databases. The contractor will provide a software application which translates the site's (ship manager or logistics contractor site specific) NS5 database into a simplified data structure for use by ship managers in developing reports. Basic flow of the application should be as follows: " Extract Data from the 40+ purchasing tables in NS5 " Assemble the data from NS5 into a Reporting Application Database for ease of use in the generation of reports. This simplified schema will include all elements necessary to generate reports used in the conduct of day-to day business by the ship managers. This schema will include all project-related data for each and every purchase transaction, including line items. " The application will be able to be run on demand, or via a scheduler, to provide an update to the data resident in the reporting database. The following specific business rules relate to this application: " Application will only extract and assemble data from the projects/vendors/purchases under the cognizance of the ship manager. The application will preclude a ship manager from accessing projects, RFQs, and Vendors of any other ship managers. " Application will not expose in any form or fashion the plain text version of the database access password. (ODBC password). " The application will not write to or edit the production database of the ship manager. " Any components used by the application for data transformation services must be secured in such a way as to prevent unauthorized access to production data. " Application must be compatible with the current Windows operating platform environment of the ship manager. Within 30 days of contract award, the contractor will provide the following deliverables in electronic format for the data extraction application: " Application executables " Blank database file (SQL Server) " User's Manual (including Database Schema) " Installation Routine " Data Dictionary outlining the schema for the database, defining each data element, and defining the relationships between each table/element (Note: This information may be included in the User's Manual). The contractor is solely responsible for quality assurance testing of the product and of subsequent releases. MARAD is granted a license to the executable binaries for use by the current ship managers and any new ship managers awarded contracts by MARAD within the period of performance of this contract. Ship Managers shall be entitled to use the application only on their copy of the MARAD NS5 database. Source code for the application will be provided to MARAD in the event that the contractor chooses to, or is not able to, provide maintenance of the application. STATEMENT OF WORK Item 2. Installation and Training Assistance. The contractor will provide software installation setup assistance and training for two days at each ship manager site in support of the reporting application. This on-site support will include the following: " Assisting the ship manager's IT staff in the installation of the application in the ship manager environment. " Configuration of the database and application scheduling in the ship manager environment. " Training of the ship manager's staff in usage of the application and how to develop reports from the database. " The contractor is not required to develop reports for ship managers. Within 20 days of contact award, the contractor will submit a travel schedule for MARAD approval. Unless authorized in advance by MARAD, on-site visits will be concluded within 120 days of contract award. For planning purposes, the following is a tentative list of sites to be visited: " MARAD Headquarters Washington, DC (2 visits) " PCS Walnut Creek, CA " Matson Oakland, CA or Long Beach, CA " ODI Houston, TX " PGM Gretna, LA " CLS Jacksonville, FL " MTL Jacksonville, FL or Charleston, SC " Keystone Bala Cynwyd, PA " IAS Vorhees, NJ " MLL Norfolk, VA " ProLog Arlington, VA and/or Virginia Beach, VA STATEMENT OF WORK Item 3. Follow-on Support. Ship managers will document and report problems encountered with the application to the MARAD RMS Helpdesk (
[email protected]). The contractor will provide second-tier technical support to resolve data or procedural issues that cannot be resolved by the Helpdesk. The contractor will provide an e-mail address and phone number (if different from the contractor's normal business phone number(s)) to support submission of technical support requests by the Helpdesk. Within two business days of receiving a request, the contractor will either resolve the issue or inform the MARAD RMS Helpdesk of the projected timeframe for resolution. In the event an issue cannot be resolved within 10 working days, the contractor will advise the COTR in writing and provide the specific cause(s) for the delay and a detailed plan of action for doing so. In all instances, the contractor will inform the MARAD RMS Helpdesk when the issue has been resolved. MARAD reserves the right to penalize the contractor up to ý portion of the monthly maintenance fee in the event the contractor's efforts in resolving support issues are determined to be unsatisfactory. The contractor is responsible for maintaining the application's compatibility with the latest release of NS5 being used by MARAD. The contractor will also maintain and provide an updated Data Dictionary, and User's Manual to reflect NS5 changes that impact the reporting database. Software Release Notes for subsequent versions are to be provided concurrent with the associated software release. On an annual basis, MARAD will evaluate contractor performance prior to exercising the option for maintenance. Unsatisfactory performance may result in renegotiating or cancelling follow-on maintenance support. STATEMENT OF WORK Item 4. Period of Performance " Item 1 and 2: Contract award plus 120 days. " Item 3: Four one-year options for maintenance commencing 121 days after contract award. Attachment 2 Justification for Other than Full and Open Competition SOLE SOURCE JUSTIFICATION Management Systems Consulting LLC (MSC) has developed a NS5 data extraction tool for their commercial clients that meets all MARAD requirements cited in the Statement of Work, including the critical requirements to segregate data visibility by site as well as to prevent access to other Ship Manager's data from unauthorized users. This product is a proprietary application with the source code wholly owned by MSC and is in use with many clients for varied purposes. There is no other comparable program available on the market. The current NS5 database, consisting of 574 tables, is very complex in terms of data relationships. This degree of complexity inhibits the process of creating custom reports and extracts to such an extent that this functionality is out of reach for all typical users. The currently available MSC product normalizes this complexity and allows for custom reports and extracts to be easily created by MARAD ship managers. Any effort expended by MARAD to build, or to contract to build, such a customized application involves a very high risk as compared to using one that is already developed, tested, and operationally deployed at a number of large commercial maritime companies. Furthermore, should MARAD choose to build, or contract to build the subject application, MARAD would be required to support and modify this application as the NS5 software is updated by ABS. MSC is currently providing this support, as well as being obligated to do so, with their available commercial product. The use of a commercial software package makes the maximum use of commercial services and off-the-shelf technology required by the Section 5202: Incremental Acquisition of Information Technology of the Clinger-Cohen Act of 1996 (Public Law 104-106), Federal Acquisition Streamlining Act of 1994 (FASA Title V), E-Gov Act implementation, and DOT's modernization efforts. The issue of custom database reporting and exports was recently identified by MARAD Ship Managers as their most critical need in terms of using NS5 to support MARAD and execution of their performance-based contracts. The anticipated payback from acquiring and deploying this tool is considered paramount towards helping meet MAR-610 business objectives and further the agency's push towards becoming the premier Government ship manager.