MSDS Application

Request for Information/Interest for MSDS Application for USDOE/NNSA Pantex Plant Introduction: Babcock & Wilcox Technical Services Pantex, LLC (B&W Pantex) is the managing and operating contractor for the USDOE/NNSA Pantex Plant. B&W Pantex is in the process of conversion of the enterprise software for the site from the Passport platform to the PeopleSoft platform. This RFI requests information regarding an industry standard Material Safety Data Sheet (MSDS)/Chemical Tracking system with improved business processes and a proven track record for supporting large and complex chemical management environments that will interface with Oracle's PeopleSoft Enterprise FSCM 9.0. Description of Service Requirements: B&W Pantex requests information from interested respondents in providing the following technical services: - Configure and install the application for use at the Pantex Plant Site for an unlimited number of users; - Train chemical coordinators, system administrators, technical IT support personnel and other users of the system; - Migrate data contained within the current applications (Passport and dBase) to the selected application. This also includes preservation of historical data; - Provide MSDS processing to support the implementation of the selected application; - Provide the technical support required for the installation, configuration, testing, implementation, and ongoing production maintenance of the application; - Provide the support necessary to perform the data migration and validation, and cut over services for the production implementation. - Provide unlimited use of the selected software, including the license, software enhancements and updates, regulatory list updates, unlimited technical support including on-line and phone-in technical support services, and ongoing MSDS processing for new and/or updated chemicals; - Supply complete user and technical documentation including a written and on-line users manual maintained current with the operating system including Pantex Plant's site modifications, if any. MSDS Application Requirements: Interested respondents should consider the following requirements for the MSDS/Chemical Tracking application: - An industry standard system that will interface with Oracle's PeopleSoft Enterprise FSCM 9.0; - Reside/run on one of the following server platforms, in order of preference: Windows Server 2008, Windows Server 2003, or AIX 5.3; - Utilize one of the following database management platforms in order of preference, Oracle 11G, Oracle 10G, or Microsoft SQL Server 2005; - Be accessible to all site users via TCP/IP based network and capable of functioning behind a secure firewall configuration; - If the application requires an Application Server Environment, then application must support one of the following, in order of preference, Oracle Internet Application Server, Oracle Weblogic, or IBM Websphere; - Compatibility with a Windows Client (XP SP3 and/or Vista SP1) and Microsoft Internet Explorer 6 web browser or higher; - Capable of providing e-mail notification and at a minimum be SMTP compliant. Integration with Exchange 2007 is highly desirable; - Able to support a Service Oriented Architecture (SOA) by being able to, at a minimum, offer up Web Services thus allowing other applications to consume those Web Services; - Utilize an approved directory service for authentication, in order of preference: Microsoft Active Directory, Version 3 Compliant LDAP such as Novell E-Directory or Oracle Internet Directory. Otherwise the application must meet minimum authentication requirements including the ability to enforce complex passwords by utilizing special characters, supporting 8 to 15 character passwords, and supporting uppercase and lowercase characters; and provide a secure (encrypted) means of administering groups and access changes and provide logging of all access additions, deletions, or changes; - Provide Password Aging - the ability to force passwords to change at a pre-determined time, the capability to lock user accounts after 3 consecutive incorrect attempts, and the capability to log/audit all login activity; - Encrypt all passwords that it stores or outsource that function to an approved V3 Compliant LDAP or Directory Service such as Microsoft Active Directory (Note: Pantex standard encryption is FIPS-140-2 compliant); - Transmit passwords in an encrypted fashion; - Store credentials for accessing system services such as DBMS in a secure manner that is encrypted; - Must not show or echo password to the screen as it is typed; - Must not require running the application service with root or admin equivalent access; - Log critical security functions, such as changes to access and logging, into the system; - Provide various levels of security and access regarding who can use identified features within the application and a read-only access for users who need to search and locate information within the application and the capability to manage various levels of access; - Send and receive data to and from PeopleSoft FSCM and incorporate and utilize procurement and human resources data; - Send data to the Emergency Response Application, the Integrated Hazardous Material Information System (IHMIS), on a nightly basis; and to the Pantex Plant Site SARA 311/312 EPCRA Reporting Application. Approximately 50 custom fields. The IHMIS is on an ARCView platform; - Capability to accept electronic data imports and exports including Excel, Access and fixed width ASCII files through a batch process; - Capability to manage chemical authorizations and approval including an electronic chemical request, electronic approval/disapproval capability for chemical requests, and e-mail status and notification reports for requests; - Capability to store and query on chemical composition and physical property information; - Capability to enter composition ranges (e.g., low, high, average) for constituents within a mixture; - Capability to store and maintain regulatory and custom lists of chemicals and related thresholds; - Capability to store NFPA/HMIS/Pantex Specific ratings for each material/mixture and to identify chemicals as being time sensitive; - Capability to store last and /or next inspection due dates and document inspection results (e.g., status of container); - Capability to flag a material as being a pesticide; - Capability to characterize a material according to International Building Code hazard classifications; - Capability to flag a material as containing a carcinogen; - Capability to store percent compositions as less than (<) X % and use the percent to assess thresholds; - Capability to designate materials as Trade Secret; - Capability to flag exempted chemicals for EPCRA reporting purposes; - Capability to store and retrieve Material Safety Data Sheet (MSDS) information; - Capability to store and retrieve information on labeling for each hazardous chemical in the site inventory; - Capability to store and retrieve information on flammability loading; - Capability to identify each flammable chemical with a NFPA Class code; - Capability to allow control areas to be defined for a room; - Capability to allow rooms to be defined for a building; - Capability to ensure that each NFPA Class code volume does not exceed a set Control Area Class Limit for a control area; - Capability to ensure that each NFPA Class code volume does not exceed a set room class limit for a room; - Capability to ensure that the total volume does not exceed a set room total limit for a room; - Capability to ensure that the total volume does not exceed a set building limit for a building; - Capability to record the volume (gallons) on hand for each NFPA Class code; - Capability to manage chemical inventories; - Includes integrated barcode system for container tracking; - Includes a hand held application that can be used in the field to gather inventory data and perform database updates to reflect actual inventory conditions; - Perform single and batch container transfers to new or different storage locations and to show consumption; - Provide notifications when a chemical transfer does not have the proper chemical approvals; - Provide notifications when a transfer exceeds the established limits for an area; - Link and /or store (as applicable) EPCRA Tier 2 data with container data; - Provide EPCRA container information including type, pressure, storage, temperature, EPCRA storage codes and locations; - Capability to designate storage locations at or below the building level; - Capability to track maximum allowable storage quantity for each hazard class by building or control area; - Capability to track container quantity and content quantity separately. - Capability to move the container as a whole. If the whole container is moved, the total quantity must be transferred; - Capability to move container content into another container; - Capability to create inventory items consisting of multiple containers as well as inventory items directly related to a single container; - Capability to set custom EPCRA thresholds for the site; - Capability to automatically sum chemical constituents quantities from inventory information; - Capability to determine whether chemicals exceed custom threshold triggers and automatically flag chemicals that trigger 312 and 313 reporting threshold; - Capability to create inventory items that consist of multiple containers as well as inventory items directly related to a single container; - Capability to distinguish chemical inventory information from multiple sites and locations; - Capability to provide an audit trail that identifies what identified user made a change and the changes taken for containers; - Capability to maintain history of chemical inventory to provide capability to query inventory for a given location on a given historical date; - Capability to query the system for aggregate total quantity of a specific chemical (e.g., TRI or TIH chemicals) on the site by CAS number or Master Parts List ID Number; - Capability to set Ceiling Limits, Threshold Quantities (TQ), Threshold Planning Quantities (TPQ), Reportable Quantities (RQ), and/or warning/notification limits on specific chemicals for specific locations on the site; - Capability to generate standard and customized reports of the data within the application database including the SARA quarterly EPCRA 311 Report and annual EPCRA 312 Report, reports of time sensitive materials, threshold reports that flag chemicals above pre-defined thresholds, and reports that show SARA 313 and Persistent, Bioaccumulative, and Toxic (PBT) materials and quantity by location; - Capability to generate user run ad-hoc reports and storage of custom queries / reports; - The barcode scanning application must run on Symbol PDT 8100 using the Pocket PC operating system. - Capability to manage chemical authorization and approval; - Capability to manage chemical inventories; - Support complete and timely MSDS management including but not limited to MSDS entry, text conversion, reports, location information, search ability, and retention of active and inactive MSDS. Submittal Instructions: Interested respondents should submit responses that include the following information: - Brief description of similar projects completed by company. - Brief description of the technical approach, including development methodology, the ability to include Pantex requirements in the base software product, interface options with PeopleSoft (real-time, web services, etc.), impact to future upgrades of the software product, etc. - High level implementation timeline, including possible number of resources, estimated hours, and duration. - Rough Order of Magnitude Estimate, including cost of the software and potential customizations. - Completed MSDS Application Questionnaire. The - Core Product or Customization column should identify if the requirement specified is part of the core product or if the core product would require customization to meet the requirement. The Notes/Comments column is available on the questionnaire for the respondent to provide responses to questions posed or to provide any additional information of value. Notes may be carried over to additional sheets as necessary. Electronic responses are preferred (use either Adobe PDF or Word format). Requirements may change from those stated in this RFI. B&W Pantex does not intend to award a contract on the basis of this request for information (RFI) and is under no obligation to proceed with a Request for Proposal. The request does not obligate B&W Pantex or the government to the expenditure of funds or to pay for the information solicited. This is as a request for information and interest only. Official Contact Information: Please direct your interest and questions to Lori G. Davis, Contract Specialist at B&W Pantex ldavis@pantex.com.