20_Solicitation - Attachment 9E - PBGC TPIMS Third Party Vendors.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Transformational Pension Insurance Modeling System (T-PIMS) Federal contract opportunity
- Solicitation number
- 16PBGC21R0010
- Issued by
- Pension Benefit Guaranty Corporation
About this file
This document outlines a solicitation for the Pension Benefit Guaranty Corporation's Transformational Pension Insurance Modeling System project. The PBGC seeks to establish a ten-year Indefinite Delivery Indefinite Quantity contract with task orders to cover the full life cycle of modernization, enhancement, operations and maintenance, and actuarial support services for its new Transformational Pension Insurance Modeling System. The initial task order requires modernization of T-PIMS for Single-Employer plans with a delivery timeline of no more than 27 months from contract award. T-PIMS is intended to be faster, run more simulations, and incorporate a larger footprint of input data than the PBGC's current system. The contractor will be responsible for ongoing systems modernization, enhancement, operations, and maintenance efforts over the life of the ten-year contract.
View the file
Other files for this federal contract opportunity
Show all 15
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Third Party Vendors RFP 16PBGC21R0010, ATTACHMENT 9E - PBGC SE Transformed PIMS (TPIMS) Third Party Vendors
| ID # | Vendor | Service | Open Source? | Subscription Type | Notes | ||
| 1 | Economic forecast generator | Economic Projections | No | Annual | - PRAD will contract with an economic data modeling source; these are or will be contracted with by PBGC; the TPIMS contractor will work with and incorporate these vendor-generated services/data into TPIMS | ||
| 2 | Microsoft Azure | Cloud Service Provider | No | TBD | - A few other native Azure services such as Azure Blob Storage for archival, Data migration services to move data, security services for IAM may be needed. Billing for these services may be part of consolidated billing. | ||
| 3 | Python | Programming Language | Yes | N/A | - Open source programming language | ||
| 4 | Azure Databricks - Data Engineering | Data Analytics Platform | No | - Databricks Unit (DBU)* | |||
| - Environment (Service Account) License | - Databricks is the Enterprise version of Apache Spark and uses its built-in flexible schema storage called "Delta Lake" |
- The Data Engineering package enables use of the Databricks platform for execution jobs (e.g., batch jobs, ETLs, production models) and therefore uses an environmental (service account) license. Developers do not interact directly with this package.
*A DBU is a unit of processing capability per hour, billed on per-second usage. The larger the instance is, the more DBUs you will be consuming on an hourly basis. For example, 1 DBU is the equivalent of Databricks running no a c4.2xlarge machine for an hour.
| 5 | Azure Databricks - Data Analytics | Data Analytics Platform | No | - Databricks Unit (DBU)* | ||
| - Per-User License | - Databricks is the Enterprise version of Apache Spark and uses its built-in flexible schema storage called "Delta Lake" |
- The Data Analytics license is for the collaboration environment and integrates with the IDE, allowing the data scientist/statistical modelers and developers to write, publish, and test code using the Databricks platform. As it is intended for modelers, it requires licenses per-user.
*A DBU is a unit of processing capability per hour, billed on per-second usage. The larger the instance is, the more DBUs you will be consuming on an hourly basis. For example, 1 DBU is the equivalent of Databricks running no a c4.2xlarge machine for an hour.
6 Azure Kubernetes Services Container Management N/A N/A - Kubernetes and Docker are covered as part of Azure Kubernetes services
- AKS could have separate licensing or could be under the unified Azure Billing as it is a native Azure service 7 PowerBI Reporting and Data Visualization No Free or Monthly per User - PowerBI licenses may be included as part of the Azure environment cost depending on PBGC's agreement with Microsoft
- PowerBI "Desktop" is free, while PowerBI "Pro Service" follows a Monthly per User cost structure
- The Pro Service license cost also differs based on other MS licenses the organization procure such as office 365 and SQLserver
- PRAD will likely use PowerBI Desktop (read-only privileges to dashboards) more than Pro Service (full customization and dashboard build privileges), as not every member of PRAD will be creating dashboards vs. viewing results 8 S&P Global Market Intelligence Firm Financial Data No Annual - Subscriptions depends on number of users
- PRAD already has existing licenses and accesses the data through S&P's SFTP site 9 Microsoft Visual Studio Integrated Development Environment (IDE) No Free, Annual, or Monthly per User - On June 18, 2020, Dave Ringle, ITIOD, confirmed that Microsoft Visual Studio is the standard IDE for new development at PBGC
- Visual Studio licenses may be included as part of the Azure environment cost depending on PBGC's agreement with Microsoft
- Visual Studio "Community" is free, but the "Professional" and "Enterprise" versions follow a Monthly or Annual per User cost structure 10 Azure DevOps Code Management No Monthly per User - On June 18, 2020, Dave Ringle, ITIOD, confirmed that Azure DevOps is the standard code management tool for new development at PBGC
- Azure DevOps licenses may be included as part of the Azure environment cost depending on PBGC's agreement with Microsoft
File details come from the government source that posted it. Updated .