Enterprise TDM Pricing Workbook Version 2.xlsx
XLSX spreadsheet 38 KB Posted
- Attached to
- Enterprise Test Data Management Federal contract opportunity
- Solicitation number
- CORHQ-24-R-0686
- Issued by
- Federal Deposit Insurance Corporation
About this file
This is a pricing workbook template for an FDIC Enterprise Test Data Management solicitation that contains multiple tabs for offerors to submit their pricing. The workbook requires vendors to provide biweekly sprint pricing for three project complexity levels (Small, Medium, and Large) across a base period and four option periods, along with hourly labor rates for nine specified labor categories including Project Manager/Scrum Master, Data Architect, Data Modeler, and others.
The pricing structure includes both Firm-Fixed-Price (FFP) CLINs 1-4 and optional Time & Materials (T&M) components, with predefined FTE staffing levels ranging from 0.75 FTE for small projects to 5.0 FTE for large projects. The base period includes 19.5 biweekly sprints while each option period contains 26 sprints. The workbook includes detailed labor category descriptions with minimum experience requirements, such as seven years of experience for Project Managers and Data Architects, and five years for most other roles. All pricing will be evaluated as part of the overall evaluated price (OEP), including both the base CLINs and optional future work.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| CORHQ-24-R-0686 Amendment 0005.pdf | ||
| CORHQ-24-R-0686 Amendment 0004.pdf | ||
| CORHQ-24-R-0686 Amendment 0003.pdf | ||
| Summary of Changes Amendment 0003.pdf | ||
| CORHQ-24-R-0686 Amendment 0002.pdf | ||
| ETDM Live Session Presentation Slides.pdf | ||
| BISS SOO Attachment C 2027 Target State Architecture v1.1updated.pdf | ||
| BISS SOO Attachment C - 2027 Target State Architecture v1.1 updated.pdf | ||
| CORHQ-24-R-0686 Amendment 0001.pdf | ||
| BISS SOO Attachment B - Sample BISS Portfolio Data Sets.xlsx | XLSX spreadsheet | |
| Enterprise TDM Pricing Workbook.xlsx | XLSX spreadsheet | |
| CORHQ-24-R-0686.pdf | ||
| BISS SOO Attachment D - ETDM Accomplishments to Date.docx | DOCX document | |
| Questions and Answers Sheet.xlsx | XLSX spreadsheet | |
| BISS SOO Attachment A - Software Tools Inventory.xlsx | XLSX spreadsheet | |
| BISS SOO Attachment C - 2027 Target State Architecture v1.1.pdf |
Show all 16
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
Instructions
| 1. General Instructions |
| Do not modify the structure of this Excel file. |
| Offeror shall only enter data in the green-shaded cells. All other cells and tabs have calculated fields or contain data entered by FDIC. |
| 2. "FFP Project Pricing" Tab |
| This tab requests charges for the three Project Complexity levels that can be ordered under this Task Order. |
| The FDIC has pre-populated suggested roles and FTE counts based on historical usage. Offeror may change the roles and corresponding FTE estimates as they see fit. |
| Rows 4-6: Offeror shall enter biweekly sprint charges per Project Complexity level for the Base Period and Option Periods. |
| Rows 13-19: Offeror shall also enter anticipated roles per Project Complexity level along with full-time equivalent (FTE) counts. Roles may be part-time. |
| 3. "LCAT Descriptions" Tab |
| No input is necessary on this tab. |
| It includes a comprehensive list of labor categories available on the ETDM contract, along with corresponding descriptions. |
| 4. "T&M Rate Card" Tab |
| Offeror shall enter hourly labor rates for each labor category. |
| An Offeror failing to propose a price for all labor categories may receive no further consideration and may be eliminated. |
| 5. "ETDM Pricing Model" Tab |
| No input is necessary on this tab. |
| CLINs 1-4: Pricing is calculated by taking the biweekly sprint charges entered by Offeror on the "FFP Project Pricing" tab and mulitplying them against the anticipated number of sprints in the Base and Option Periods. |
| Optional Future CLINs: The FDIC may procure future services under this contract using either an FFP or T&M model. Because the exact scope of these optional future services is not currently defined, Offerors are not required to provide estimates. |
| In order to determine the potential total cost of awarding this contract, the FDIC will use a model. The project complexity, sprint count, labor categories, and hours are for evaluation purposes only and are the same for all Offerors. |
| 6. "ETDM Pricing Summary" Tab |
| This tab displays the summary charges for each CLIN and contract period. |
| The proposed pricing for CLINs 1-4, along with the Optional Future CLIN model, will constitute the overall evaluated price (OEP). This computation will be for evaluation purposes only. |
&"Source Sans Pro SemiBold"&12&K000000CONTROLLED//FDIC BUSINESS&1#_x000D_&"Calibri"&11&K000000
LCAT Descriptions ETDM Labor Categories
| Labor Category | Description |
| Project Manager / Scrum Master | · Shall have at least seven (7) years of experience managing and orchestrating Agile teams delivering business intelligence and data services |
· Shall be proficient in the use of tools and methods to efficiently manage product releases, sprints, and development cycles
· Shall have experience utilizing program and project management tools, including GitHub, ServiceNow, and Microsoft Teams to plan, execute, and measure projects
· Shall have demonstrated experience overseeing an enterprise data management, data analytics, or cloud migration efforts similar in scope and size to this contract
· Certification in Agile methods, Microsoft Azure, Oracle, and GitHub are highly desired Data Architect • Shall have at least seven (7) years of experience managing enterprise data management infrastructure, to include managing on-premises systems and cloud migration efforts, data base administration, including referential/data integrity, point in time recovery, and custom coding
• Shall be proficient in database technologies to include but not limited to Oracle, SQLServer, Postgres, MariaDB, MySQL and Azure Database services
• Shall have demonstrated experience in leading transformation projects related to establishing an enterprise-wide data layer and establishing mature DataOps practices
Data Modeler • Shall have at least five (5) years of experience as a Data Modeler.
• Shall have experience leveraging advanced knowledge of networking concepts, object-oriented technology, data warehousing, and relational database engines.
Data Orchestration SME • Requires at least 15 years of related work experience and specialized expertise in at least one of the following fields: data management, data analysis, product development, rapid prototyping, software develop, cloud engineering, information security, intelligent automation, data analytics, or data science.
• Shall have significant demonstrated experience establishing system information requirements, developing prototypes, writing software, establishing configuration management best practices for a development team, developing advanced analytic techniques, transitioning prototypes to a production environment, and leading user centered innovation or change management initiatives.
Test Engineer • Shall have at least ten (10) years of experience managing enterprise data management infrastructure, to include managing on premises systems and cloud migration efforts
• Shall be familiar with in configuration and administration of enterprise level data stores, ETL/ELT methods, batch and streaming data transport, and API development.
• Shall have at least three (3) years of experience in test data management, including test data generation and production data obfuscation.
• Shall have an understanding of database technologies to include but not limited to Oracle, SQLServer, Postgres, MariaDB, MySQL, and Azure Database services.
• Shall have experience utilizing program and project management tools, such as Microsoft Team Foundation Server, Git, JIRA, or Microsoft Project to plan, execute, and measure projects.
• Shall have demonstrated experience overseeing enterprise level data operations of similar size and scope to this contract.
System Administrator • Shall have at least five (5) years of experience as a System Administrator or in a similar role
• Advanced technical proficiency in using a wide range of software applications and products.
• Advanced knowledge of internets, intranet, and extranet systems design, database design, and network architecture.
• Certification in system and/or data management desired.
Emerging Technology Engineer • Shall have at least five (5) years of experience as a Solution Architect along with 5 years’ experience in other technical roles such as developer or systems analyst.
• Shall have demonstrated experience developing analysis-level UML, activity diagrams, business use cases, business rules, and system level features.
• Shall have demsontrated knowledge in enterprise architecture frameworks (TOGAF is preferred).
• Shall have strong consultative skills at a cross functional level.
Data Warehouse Specialist • Shall have at least five (5) years of experience in designing complex, integrated application solutions and in developing frameworks for the implementation of data warehouses, data marts, or data webs.
Shall have demonstrated experience with data extraction, manipulation, and cleansing tools.
Shall have demsontrated knowledge of database design, with an emphasis on data warehousing, OLAP, star schemas, or reporting cubes.
Cloud Engineer • Shall have at least five (5) years of experience designing, implementing, and managing cloud infrastructure and solutions leveraging Azure services (compute, storage, networking, security, and IAM).
• Shall have demonstrated experience planing, designing, testing, and delivering pipelines and infrastructure using CI/CD model.
• Shall have experience augmenting CI/CD frameowrk with DevSecOps and standardized security tools and controls.
• Shall demonstrate stong knowledge of modern Software Configuration Management and Infrastructure-as-Code concepts in a Git-based environment, including code repositories, pull requests, automation tools, and orchestration tools.
&"Source Sans Pro SemiBold"&12&K000000CONTROLLED//FDIC BUSINESS&1#
FFP Project Pricing FFP Project Biweekly Sprint Pricing
| Project Complexity | Base | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 |
| Small | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Medium | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Large | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Anticipated Roles per Project Complexity
| Small | Medium | Large | |||
| Role | FTE | Role | FTE | Role | FTE |
| Project Manager / Scrum Master | 0.25 | Project Manager / Scrum Master | 0.50 | Project Manager / Scrum Master | 1.0 |
| Data Architect | 0.25 | Data Architect | 0.50 | Data Architect | 1.0 |
| Test Engineer | 0.25 | Test Engineer | 0.50 | Test Engineer | 1.0 |
| System Administrator | 0.25 | System Administrator | 0.5 | ||
| Data Warehouse Specialist | 0.25 | Data Warehouse Specialist | 0.3 | ||
| Data Modeler | 0.25 | Data Modeler | 0.5 | ||
| Cloud Engineer | 0.125 | Cloud Engineer | 0.5 | ||
| Emerging Technology Engineer | 0.3 | ||||
| Total FTEs | 0.75 | Total FTEs | 2.38 | Total FTEs | 5.0 |
&"Source Sans Pro SemiBold"&12&K000000CONTROLLED//FDIC BUSINESS&1#_x000D_&"Calibri"&11&K000000
T&M Rate Card Optional T&M Labor Hour Rates
| Role | Base Period | OP1 | OP2 | OP3 | OP4 |
| Project Manager / Scrum Master | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Data Architect | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Data Modeler | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Data Orchestration SME | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Test Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| System Administrator | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Emerging Technology Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Data Warehouse Specialist | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Cloud Engineer | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
&"Source Sans Pro SemiBold"&12&K000000CONTROLLED//FDIC BUSINESS&1#_x000D_&"Calibri"&11&K000000&"Calibri"&11&K000000
ETDM Pricing Model
| Enterprise Test Data Management - Pricing Model | |||
| CLIN 1 - Small Project | |||
| Biweekly Sprints in Period | Price per Sprint | Price for Period | |
| Base Period | 19.5 | $ - 0 | $ - 0 |
| Option Period 1 | 26 | $ - 0 | $ - 0 |
| Option Period 2 | 26 | $ - 0 | $ - 0 |
| Option Period 3 | 26 | $ - 0 | $ - 0 |
| Option Period 4 | 26 | $ - 0 | $ - 0 |
| CLIN 1 Total | $ - 0 | ||
| CLIN 2 - Small Project | |||
| Biweekly Sprints in Period | Price per Sprint | Price for Period | |
| Base Period | 19.5 | $ - 0 | $ - 0 |
| Option Period 1 | 26 | $ - 0 | $ - 0 |
| Option Period 2 | 26 | $ - 0 | $ - 0 |
| Option Period 3 | 26 | $ - 0 | $ - 0 |
| Option Period 4 | 26 | $ - 0 | $ - 0 |
| CLIN 2 Total | $ - 0 | ||
| CLIN 3 - Medium Project | |||
| Biweekly Sprints in Period | Price per Sprint | Price for Period | |
| Base Period | 19.5 | $ - 0 | $ - 0 |
| Option Period 1 | 26 | $ - 0 | $ - 0 |
| Option Period 2 | 26 | $ - 0 | $ - 0 |
| Option Period 3 | 26 | $ - 0 | $ - 0 |
| Option Period 4 | 26 | $ - 0 | $ - 0 |
| CLIN 3 Total | $ - 0 | ||
| CLIN 4 - Large Project | |||
| Biweekly Sprints in Period | Price per Sprint | Price for Period | |
| Base Period | 19.5 | $ - 0 | $ - 0 |
| Option Period 1 | 26 | $ - 0 | $ - 0 |
| Option Period 2 | 26 | $ - 0 | $ - 0 |
| Option Period 3 | 26 | $ - 0 | $ - 0 |
| Option Period 4 | 26 | $ - 0 | $ - 0 |
| CLIN 4 Total | $ - 0 | ||
| Optional Future FFP CLIN - Small Project | |||
| Biweekly Sprints in Period | Price per Sprint | Price for Period | |
| Base Period | n/a | n/a | n/a |
| Option Period 1 | 26 | $ - 0 | $ - 0 |
| Option Period 2 | 26 | $ - 0 | $ - 0 |
| Option Period 3 | 26 | $ - 0 | $ - 0 |
| Option Period 4 | 26 | $ - 0 | $ - 0 |
| Total | $ - 0 |
| Optional Future FFP CLIN - Medium Project | |||
| Biweekly Sprints in Period | Price per Sprint | Price for Period | |
| Base Period | n/a | n/a | n/a |
| Option Period 1 | 26 | $ - 0 | $ - 0 |
| Option Period 2 | 26 | $ - 0 | $ - 0 |
| Option Period 3 | 26 | $ - 0 | $ - 0 |
| Option Period 4 | 26 | $ - 0 | $ - 0 |
| Total | $ - 0 |
| Optional Future T&M CLIN | ||
| Hours | Charges | |
| Base Period | 640 | $ - 0 |
| Option Period 1 | 800 | $ - 0 |
| Option Period 2 | 800 | $ - 0 |
| Option Period 3 | 800 | $ - 0 |
| Option Period 4 | 800 | $ - 0 |
| Total | $ - 0 |
&"Source Sans Pro SemiBold"&12&K000000CONTROLLED//FDIC BUSINESS&1#_x000D_&"Calibri"&11&K000000&"Calibri"&11&K000000
ETDM Pricing Summary
| ETDM Pricing Summary | ||||||
| CLIN | Base Period | OP1 | OP2 | OP3 | OP4 | Total PoP |
| CLIN 1 - Small | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| CLIN 2 - Small | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| CLIN 3 - Medium | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| CLIN 4 - Large | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Optional Future FFP CLIN - Small | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Optional Future FFP CLIN - Medium | n/a | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Optional Future T&M CLIN | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total for all CLINs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
&"Source Sans Pro SemiBold"&12&K000000CONTROLLED//FDIC BUSINESS&1#
File details come from the government source that posted it. Updated .