Attachment 6_Employee Tenure and Retention Table.xlsx

62 KB Posted

Attached to
ECA EX/IT Information Technology Transformation and Operations Support Services (8a set-aside)
Solicitation number
19AQMM21R0302
Issued by

About this file

Written by GovTribe AI ·

This solicitation package requests proposals for information technology transformation and operations support services. The U.S. Department of State seeks to award an 8(a) set-aside contract to provide expertise across a range of IT functions including requirements analysis, application development, data management, and platforms support. Offerors should propose fully burdened labor rates using the attached templates and factor in personnel with experience on the incumbent contract. Questions are due by August 24th and proposals are to be submitted in accordance with the instructions and evaluation criteria defined in the attachments. The scope involves continued support of the Department's enterprise IT infrastructure and initiatives to modernize systems and processes.

View the file

Other files

File Type Posted
Questions and Answers - Amendment 004.xlsx XLSX spreadsheet
19AQMM21R0302-A004.pdf PDF
Attachment 8_Instructions to Offerors_Advisory Down-Select Process_A004.pdf PDF
Attachment 3_Labor Categories_Position Descriptions_A004.pdf PDF
19AQMM21R0302-A003 (Stage 2).pdf PDF
19AQMM21R0302-A002.pdf PDF
Questions and Answers - Amendment 002.xlsx XLSX spreadsheet
Attachment 9_Evaluation Procedures_Evaluation Factors for Award_A002.pdf PDF
Attachment 8_Instructions to Offerors_Advisory Down-Select Process_A002.pdf PDF
Attachment 7_EX-IT Pricing Template_A002.xlsx XLSX spreadsheet
Attachment 5_Past Performance Questionnaire_A002.docx DOCX document
19AQMM21R0302-A0001.pdf PDF
Attachment 5_Past Performance Questionnaire.docx DOCX document
Attachment 2_Platform Technology Tracker.pdf PDF
19AQMM21R0302 - ECA IT Transformation and Operations Support Services.pdf PDF
Attachment 9_Evaluation Procedures_Evaluation Factors for Award.pdf PDF
Attachment 10_Bidders DD-254 - 19AQMM-21-R-0302.pdf PDF
Attachment 4_ECA DIN Infrastructure Diagram.pdf PDF
Attachment 1_Applications Tracker.xlsx XLSX spreadsheet
Attachment 3_Labor Categories_Position Descriptions.pdf PDF
Attachment 7_EX-IT Pricing Template.xlsx XLSX spreadsheet
Attachment 8_Instructions to Offerors_Advisory Down-Select Process.pdf PDF
Show all 22

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Tenure Table

ECA IT TRANSFORMATION & OPERATIONS SERVICES
Employee Tenure Table

Quoters shall provide a count of current employees aligned to current positions held and the duration employed - either less than one year or more than one year. Each employee shall be referenced once in a single position that is currently held by that individual. Please fill in the table separately for each teaming partner / subcontractor as well as for the Prime Contractor. If necessary please add additional columns for additional teaming partners.

Prime ContractorTeaming Partner 1Teaming Partner 2Teaming Partner 3Teaming Partner 4Teaming Partner 5
Labor CategoryFTE < 1 YearFTE > 1 YearFTE < 1 YearFTE > 1 YearFTE < 1 YearFTE > 1 YearFTE < 1 YearFTE > 1 YearFTE < 1 YearFTE > 1 YearFTE < 1 YearFTE > 1 Year
1Program Manager *
Customer Engagement
2Requirements & Business Analysis Lead
3Mid-Level Business Analyst
4Sr Business Analyst
5Training Coordinator
6Trainer
7Jr Customer Support Technician
8Mid-Level Customer Support Technician
9Sr Customer Support Technician
Data & Analytics
10Data Team Functional Lead *
11Data Governance / MDM - Data Architect
12Data Governance / MDM - Senior Data Analyst
13Senior Database Administrator *
14ETL Developer
15Business Intelligence & Visualization - Data Scientist
16Business Intelligence & Visualization - Data Analyst
17Business Intelligence & Visualization - Data Reports Developer
Solutions
18Solutions Technical Lead *
19Solution Architect
20Mid-Level Application Developer
21Senior Application Developer
22Scrum Master
23Configuration Management Specialist
24Q&A Tester
25Q&A Tester - Application / Automation
26Business Process Reengineering Analyst
27SharePoint Developer
Platforms
28Platform Technical Lead *
29Cloud Operations Engineer *
30Mid-Level Network Engineer
31Senior Network Engineer *
32Mid-Level System Administrator
33Senior System Administrator
34Audio Visual Administrator
Security
35Security & Monitoring Analyst
Governance
36Enterprise Architect *
37Technical Writer

* denotes Key Personnel

Attachment E (to be completed by Offeror)

19AQMM18R0183

OT Labor Rates (If Applicable)

ECA PROFESSIONAL STAFFING SERVICES
19AQMM18R0183
Overtime Rates / By Performance Year
(IF APPLICABLE - NOT EXEMPT BY SCA)
Labor Category1,920Annual Cost (1920 Hours Per Year)
FTEBaseFTEOY 1FTEOY 2FTEOY 3FTEOY 4FTETotal
Program Manager1$347,3861$353,9861$360,7121$367,5651$374,5491$1,804,197
Security Analyst1$233,6831$238,1231$242,6481$247,2581$251,9561$1,213,671
Enterprise Architect1$284,1981$289,5981$295,1011$300,7071$306,4211$1,476,029
Technical Writer1$158,0741$161,0771$164,1371$167,2561$170,4341$820,982
Customer Support Technician3$367,0853$374,0593$381,1673$388,4093$395,7883$1,906,520
Requirements & BA Lead1$265,9781$271,0311$276,1811$281,4281$286,7751$1,381,397
Sr Business Analyst2$531,9552$542,0622$552,3622$562,8562$573,5512$2,762,794
Jr Business Analyst1$227,2701$231,5891$235,9891$240,4731$245,0411$1,180,366
Training Coordinator1$175,8141$179,1551$182,5591$186,0271$189,5621$913,121
Trainer1$134,4771$137,0321$139,6351$142,2891$144,9921$698,429
Audio Visual Administrator1$231,2261$235,6191$240,0961$244,6571$249,3061$1,200,908
Platform Technical Lead1$312,2691$318,2021$324,2481$330,4081$336,6861$1,621,817
Cloud Operations Engineer2$462,4512$471,2382$480,1912$489,3152$498,6122$2,401,815
Network Infrastructure Engineer2$388,3392$395,7182$403,2362$410,8982$418,7052$2,016,904
Systems Administrator2$358,2722$365,0792$372,0162$379,0842$386,2872$1,860,745
Solutions Technical Lead1$324,6531$330,8211$337,1071$343,5121$350,0391$1,686,135
Solution Architect1$234,3361$238,7881$243,3251$247,9491$252,6601$1,217,062
Sr Application Developer3$870,2783$886,8143$903,6633$920,8333$938,3293$4,519,929
Jr Application Developer2$502,9252$512,4802$522,2172$532,1402$542,2502$2,612,021
SharePoint Developer1$234,8161$239,2781$243,8241$248,4561$253,1771$1,219,555
Scrum Master2$453,1202$461,7292$470,5022$479,4422$488,5512$2,353,352
Configuration Manager1$249,6001$254,3421$259,1751$264,0991$269,1171$1,296,338
Application/Automation Tester2$245,7602$250,4292$255,1882$260,0362$264,9772$1,276,398
Q&A Tester1$163,2001$166,3011$169,4611$172,6801$175,9611$847,607
BPR Analyst2$531,9552$542,0622$552,3622$562,8562$573,5512$2,762,794
Data Team Technical Lead1$324,6531$330,8211$337,1071$343,5121$350,0391$1,686,135
Database Management Analyst2$433,9582$442,2042$450,6052$459,1672$467,8912$2,253,834
Master Data Management Analyst1$230,4581$234,8361$239,2981$243,8451$248,4781$1,196,919
Data Reports Developer1$238,0801$242,6041$247,2131$251,9101$256,6961$1,236,507
BI Data Analyst1$265,9781$271,0311$276,1811$281,4281$286,7751$1,381,397
BI Data Scientist1$252,9021$257,7081$262,6041$267,5931$272,6781$1,313,489
Data Governance Data Architect1$239,1171$243,6601$248,2901$253,0071$257,8141$1,241,892
Data Governance Senior Data Analyst1$201,6191$205,4501$209,3541$213,3311$217,3851$1,047,142
ETL Developer1$170,8031$174,0481$177,3551$180,7251$184,1591$887,095
47$10,646,68847$10,848,97547$11,055,10647$11,265,15347$11,479,19147$55,295,300

&"Times New Roman,Bold"&12Attachment 6 - Base Year

&"Times New Roman,Bold"19AQMM18R0041

IGCE Summary

EX/IT IGCE Cost Summary
234566
TOTAL 5-YEAR ESTIMATED COSTAnnual
Cost ComponentBaseOY 1OY 2OY 3OY 4TotalFTE
1Total O&M Cost$10,646,688$10,848,975$11,055,106$11,265,153$11,479,191$55,295,11247
2Total Project-Based Cost - Low$4,995,840$5,090,761$5,187,485$5,286,048$5,386,483$25,946,61721.50
3Total Project-Based Cost - High$7,277,194$7,415,460$7,556,354$7,699,925$7,846,223$37,795,15631.25
4TOTAL ESTIMATED COST - LOW$15,642,528$15,939,736$16,242,591$16,551,200$16,865,673$81,241,72868.50
5TOTAL ESTIMATED COST - HIGH$17,923,882$18,264,435$18,611,460$18,965,077$19,325,414$93,090,26878.25

O&M Estimate

Labor Category Rate Table234566
Hours Per Year =1,920Annual Cost (1920 Hours Per Year)
BranchFunctional AreaTask AreaLabor CategoryFTEBaseOY 1OY 2OY 3OY 4Total
1AllAllProgram ManagementProgram Manager1$347,386$353,986$360,712$367,565$374,549$1,804,197
2Security & GovernanceSecuritySecurity MonitoringSecurity Analyst1$233,683$238,123$242,648$247,258$251,956$1,213,667
3Security & GovernanceGovernanceEnterprise ArchitectureEnterprise Architect1$284,198$289,598$295,101$300,707$306,421$1,476,025
4Security & GovernanceGovernanceTechnical WritingTechnical Writer1$158,074$161,077$164,137$167,256$170,434$820,978
5Customer Outreach & PlatformsCustomer EngagementService DeskCustomer Support Technician3$367,085$374,059$381,167$388,409$395,788$1,906,508
6Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisRequirements & BA Lead1$265,978$271,031$276,181$281,428$286,775$1,381,393
7Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisSr Business Analyst2$531,955$542,062$552,362$562,856$573,551$2,762,786
8Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisJr Business Analyst1$227,270$231,589$235,989$240,473$245,041$1,180,362
9Customer Outreach & PlatformsCustomer EngagementTrainingTraining Coordinator1$175,814$179,155$182,559$186,027$189,562$913,117
10Customer Outreach & PlatformsCustomer EngagementTrainingTrainer1$134,477$137,032$139,635$142,289$144,992$698,425
11Customer Outreach & PlatformsCustomer EngagementAudio Visual SupportAudio Visual Administrator1$231,226$235,619$240,096$244,657$249,306$1,200,904
12Customer Outreach & PlatformsPlatformsAllPlatform Technical Lead1$312,269$318,202$324,248$330,408$336,686$1,621,813
13Customer Outreach & PlatformsPlatformsCloud OperationsCloud Operations Engineer2$462,451$471,238$480,191$489,315$498,612$2,401,807
14Customer Outreach & PlatformsPlatformsNetwork InfrastructureNetwork Infrastructure Engineer2$388,339$395,718$403,236$410,898$418,705$2,016,896
15Customer Outreach & PlatformsPlatformsSystems Administration & IntegrationSystems Administrator2$358,272$365,079$372,016$379,084$386,287$1,860,737
16Solutions & DataSolutionsAllSolutions Technical Lead1$324,653$330,821$337,107$343,512$350,039$1,686,131
17Solutions & DataSolutionsTechnology InnovationSolution Architect1$234,336$238,788$243,325$247,949$252,660$1,217,058
18Solutions & DataSolutionsSolutions & Applications DevelopmentSr Application Developer3$870,278$886,814$903,663$920,833$938,329$4,519,917
19Solutions & DataSolutionsSolutions & Applications DevelopmentJr Application Developer2$502,925$512,480$522,217$532,140$542,250$2,612,013
20Solutions & DataSolutionsSolutions & Applications DevelopmentSharePoint Developer1$234,816$239,278$243,824$248,456$253,177$1,219,551
21Solutions & DataSolutionsSolutions & Applications DevelopmentScrum Master2$453,120$461,729$470,502$479,442$488,551$2,353,344
22Solutions & DataSolutionsSolutions & Applications DevelopmentConfiguration Manager1$249,600$254,342$259,175$264,099$269,117$1,296,334
23Solutions & DataSolutionsQuality Assurance & TestingApplication/Automation Tester2$245,760$250,429$255,188$260,036$264,977$1,276,390
24Solutions & DataSolutionsQuality Assurance & TestingQ&A Tester1$163,200$166,301$169,461$172,680$175,961$847,603
25Solutions & DataSolutionsBusiness Process ReengineeringBPR Analyst2$531,955$542,062$552,362$562,856$573,551$2,762,786
26Solutions & DataDataAllData Team Technical Lead1$324,653$330,821$337,107$343,512$350,039$1,686,131
27Solutions & DataDataDatabase Management (DBAs)Database Management Analyst2$433,958$442,204$450,605$459,167$467,891$2,253,826
28Solutions & DataDataMaster Data ManagementMaster Data Management Analyst1$230,458$234,836$239,298$243,845$248,478$1,196,915
29Solutions & DataDataData ReportingData Reports Developer1$238,080$242,604$247,213$251,910$256,696$1,236,503
30Solutions & DataDataBusiness Intelligence & VisualizationBI Data Analyst1$265,978$271,031$276,181$281,428$286,775$1,381,393
31Solutions & DataDataBusiness Intelligence & VisualizationBI Data Scientist1$252,902$257,708$262,604$267,593$272,678$1,313,485
32Solutions & DataDataData GovernanceData Governance Data Architect1$239,117$243,660$248,290$253,007$257,814$1,241,888
33Solutions & DataDataData GovernanceData Governance Senior Data Analyst1$201,619$205,450$209,354$213,331$217,385$1,047,138
34Solutions & DataDataData GovernanceETL Developer1$170,803$174,048$177,355$180,725$184,159$887,091
Total O&M47$10,646,688$10,848,975$11,055,106$11,265,153$11,479,191$55,295,112

Project-Based Estimate

234566
Hours Per Year =1,920Annual Cost (1920 Hours Per Year)Total
Labor CategoryFTEBaseOY 1OY 2OY 3OY 4$FTE
1SMALL PROJECT (3-6 Months)
2Jr Business Analyst0.5$113,635$115,794$117,994$120,236$122,521$590,181
3Sr Application Developer0.5$145,046$147,802$150,611$153,472$156,388$753,319
4Scrum Master0.25$56,640$57,716$58,813$59,930$61,069$294,168
5Application/Automation Tester0.25$30,720$31,304$31,898$32,505$33,122$159,549
6Q&A Tester0.25$40,800$41,575$42,365$43,170$43,990$211,901
7Data Reports Developer0.5$119,040$121,302$123,606$125,955$128,348$618,251
8BI Data Analyst0.5$132,989$135,516$138,090$140,714$143,388$690,697
9TOTAL PER PROJECT2.75$638,870$651,009$663,378$675,982$688,826$3,318,066
10TOTAL SMALL PROJECT COST - LOW2$1,277,741$1,302,018$1,326,756$1,351,965$1,377,652$6,636,1315.50
11TOTAL SMALL PROJECT COST - HIGH3$1,916,611$1,953,027$1,990,134$2,027,947$2,066,478$9,954,1978.25
12MEDIUM PROJECT (6-12 Months)
13Jr Business Analyst1$227,270$231,589$235,989$240,473$245,041$1,180,362
14Jr Application Developer1$251,462$256,240$261,109$266,070$271,125$1,306,006
15Sr Application Developer1$290,093$295,605$301,221$306,944$312,776$1,506,639
16Scrum Master1$226,560$230,865$235,251$239,721$244,276$1,176,672
17Application/Automation Tester0.5$61,440$62,607$63,797$65,009$66,244$319,098
18Q&A Tester0.5$81,600$83,150$84,730$86,340$87,981$423,801
19Data Reports Developer1$238,080$242,604$247,213$251,910$256,696$1,236,503
20BI Data Analyst1$265,978$271,031$276,181$281,428$286,775$1,381,393
21TOTAL PER PROJECT7$1,642,483$1,673,690$1,705,490$1,737,895$1,770,915$8,530,474
22TOTAL MEDIUM PROJECT COST - LOW1$1,642,483$1,673,690$1,705,490$1,737,895$1,770,915$8,530,4747.0
23TOTAL MEDIUM PROJECT COST - HIGH2$3,284,966$3,347,381$3,410,981$3,475,790$3,541,830$17,060,94714.0
24LARGE PROJECT (12+ Months)
25Jr Business Analyst1$227,270$231,589$235,989$240,473$245,041$1,180,362
26Jr Application Developer1$251,462$256,240$261,109$266,070$271,125$1,306,006
27Sr Application Developer2$580,186$591,209$602,442$613,888$625,552$3,013,278
28Scrum Master1$226,560$230,865$235,251$239,721$244,276$1,176,672
29Application/Automation Tester1$122,880$125,215$127,594$130,018$132,488$638,195
30Q&A Tester1$163,200$166,301$169,461$172,680$175,961$847,603
31Data Reports Developer1$238,080$242,604$247,213$251,910$256,696$1,236,503
32BI Data Analyst1$265,978$271,031$276,181$281,428$286,775$1,381,393
33TOTAL PER PROJECT9$2,075,616$2,115,053$2,155,239$2,196,188$2,237,916$10,780,011
34TOTAL LARGE PROJECT COST - LOW1$2,075,616$2,115,053$2,155,239$2,196,188$2,237,916$10,780,0119.0
35TOTAL LARGE PROJECT COST - HIGH1$2,075,616$2,115,053$2,155,239$2,196,188$2,237,916$10,780,0119.0
36TOTAL PROJECT-BASED - LOW$4,995,840$5,090,761$5,187,485$5,286,048$5,386,483$25,946,61721.50
37TOTAL PROJECT-BASED - HIGH$7,277,194$7,415,460$7,556,354$7,699,925$7,846,223$37,795,15631.25

Rate Table

Labor Category Rate TableRate Escalation Assumption =2%
Hourly Rates (1920 Hours per Year)
BranchFunctional AreaTask AreaLabor CategoryBaseOY 1OY 2OY 3OY 4
1AllAllProgram ManagementProgram Manager$180.93184.36767$187.87$191.44$195.08
2Security & GovernanceSecuritySecurity MonitoringSecurity Analyst$121.71$124.02$126.38$128.78$131.23
3Security & GovernanceGovernanceEnterprise ArchitectureEnterprise Architect$148.02$150.83$153.70$156.62$159.59
4Security & GovernanceGovernanceTechnical WritingTechnical Writer$82.33$83.89$85.49$87.11$88.77
5Customer Outreach & PlatformsCustomer EngagementService DeskCustomer Support Technician$63.73$64.94$66.17$67.43$68.71
6Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisRequirements & BA Lead$138.53$141.16$143.84$146.58$149.36
7Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisSr Business Analyst$138.53$141.16$143.84$146.58$149.36
8Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisJr Business Analyst$118.37$120.62$122.91$125.25$127.63
9Customer Outreach & PlatformsCustomer EngagementTrainingTraining Coordinator$91.57$93.31$95.08$96.89$98.73
10Customer Outreach & PlatformsCustomer EngagementTrainingTrainer$70.04$71.37$72.73$74.11$75.52
11Customer Outreach & PlatformsCustomer EngagementAudio Visual SupportAudio Visual Administrator$120.43$122.72$125.05$127.43$129.85
12Customer Outreach & PlatformsPlatformsAllPlatform Technical Lead$162.64$165.73$168.88$172.09$175.36
13Customer Outreach & PlatformsPlatformsCloud OperationsCloud Operations Engineer$120.43$122.72$125.05$127.43$129.85
14Customer Outreach & PlatformsPlatformsNetwork InfrastructureNetwork Infrastructure Engineer$101.13$103.05$105.01$107.00$109.04
15Customer Outreach & PlatformsPlatformsSystems Administration & IntegrationSystems Administrator$93.30$95.07$96.88$98.72$100.60
16Solutions & DataSolutionsAllSolutions Technical Lead$169.09$172.30$175.58$178.91$182.31
17Solutions & DataSolutionsTechnology InnovationSolution Architect$122.05$124.37$126.73$129.14$131.59
18Solutions & DataSolutionsSolutions & Applications DevelopmentSr Application Developer$151.09$153.96$156.89$159.87$162.90
19Solutions & DataSolutionsSolutions & Applications DevelopmentJr Application Developer$130.97$133.46$135.99$138.58$141.21
20Solutions & DataSolutionsSolutions & Applications DevelopmentSharePoint Developer$122.30$124.62$126.99$129.40$131.86
21Solutions & DataSolutionsSolutions & Applications DevelopmentScrum Master$118.00$120.24$122.53$124.85$127.23
22Solutions & DataSolutionsSolutions & Applications DevelopmentConfiguration Manager$130.00

Brian Fischbeck: Brian Fischbeck:

Rate provided by Nirun. This person needs to be a more senior person$132.47$134.99$137.55$140.17
23Solutions & DataSolutionsQuality Assurance & TestingApplication/Automation Tester$64.00$65.22$66.46$67.72$69.00
24Solutions & DataSolutionsQuality Assurance & TestingQ&A Tester$85.00$86.62$88.26$89.94$91.65
25Solutions & DataSolutionsBusiness Process ReengineeringBPR Analyst$138.53$141.16$143.84$146.58$149.36
26Solutions & DataDataAllData Team Technical Lead$169.09$172.30$175.58$178.91$182.31
27Solutions & DataDataDatabase Management (DBAs)Database Management Analyst$113.01$115.16$117.35$119.57$121.85
28Solutions & DataDataMaster Data ManagementMaster Data Management Analyst$120.03$122.31$124.63$127.00$129.42
29Solutions & DataDataData ReportingData Reports Developer$124.00$126.36$128.76$131.20$133.70
30Solutions & DataDataBusiness Intelligence & VisualizationBI Data Analyst$138.53$141.16$143.84$146.58$149.36
31Solutions & DataDataBusiness Intelligence & VisualizationBI Data Scientist$131.72$134.22$136.77$139.37$142.02
32Solutions & DataDataData GovernanceData Governance Data Architect$124.54$126.91$129.32$131.77$134.28
33Solutions & DataDataData GovernanceData Governance Senior Data Analyst$105.01$107.01$109.04$111.11$113.22
34Solutions & DataDataData GovernanceETL Developer$88.96$90.65$92.37$94.13$95.92

Newly adjusted positions

File details come from the government source that posted it. Updated .