Attachment 6 - Technical Exhibit OFR Census.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
OCC Group Life Insurance (OGLI) Services (RFP)
Solicitation number
2031JW26R00001
Issued by

About this file

This Excel file is an attachment (Attachment 6) containing detailed personnel life insurance information for employees, likely related to the Office of the Comptroller of the Currency (OCC) Group Life Insurance (OGLI) Services solicitation. The spreadsheet includes comprehensive employee data across multiple columns: Pay Period, Full Name, Grade, Adjusted Base Salary, Life Insurance Deduction Amount, Life Insurance Coverage Code, Gender, State, and Age Group.

Key observations include 200+ employees predominantly located in Virginia, Maryland, and Washington DC, with salary ranges from approximately $101,741 to $316,600. The life insurance coverage varies significantly, with many employees having no coverage, while others have basic, employee, spouse, or family coverage with different multipliers (1X, 2X, 3X, 4X, 5X). Employees span various age groups from "Under 35" to "60 and over", with grade levels ranging from 51 to 80. This detailed spreadsheet appears to be a critical supporting document for the OCC's group life insurance solicitation, providing potential bidders with comprehensive workforce demographic and insurance preference data.

View the file

Other files

File Type Posted
Attachment 5 - Technical Exhibit OCC Life Claims-Supplement-R.xlsx XLSX spreadsheet
SF 30_2031JW26R00001 A00003_Revised Attachment 5.pdf PDF
SF 30_2031JW26R00001 A00002_Revised Attachment 3.pdf PDF
Attachment 3 - Technical Exhibit Retiree Census Data-Supplement-R.xlsx XLSX spreadsheet
Attachment 3 - Technical Exhibit Retiree Census Data-Supplement.xlsx XLSX spreadsheet
Attachment 13 - QandA Worksheet-GOVT.xlsx XLSX spreadsheet
Attachment 1B - OGLI Design Plan_Schedule of Benefits.pdf PDF
SF 30_2031JW26R00001 A00001_Q-A Worksheet and Attachments.pdf PDF
Attachment 5 - Technical Exhibit OCC Life Claims-Supplement.xlsx XLSX spreadsheet
Attachment 1C - OCC-OFR GLI Memorandum of Understanding.pdf PDF
Attachment 6 - Technical Exhibit OFR Census-Supplement.xlsx XLSX spreadsheet
Attachment 2 -Technical Exhibit Active Employee Census Data-Supplement.xlsx XLSX spreadsheet
Attachment 13 - QandA Worksheet.xlsx XLSX spreadsheet
Attachment 4 - Technical Exhibt Affidavit of Domestic Partnership.pdf PDF
Attachment 1 - Price Proposal Template.xlsx XLSX spreadsheet
Attachment 3 - Technical Exhibit Retiree Census Data.xlsx XLSX spreadsheet
Attachment 9 - Security Compliance Requirements Questionnaire.docx DOCX document
SF 33_2031JW26R00001_RFP OGLI_FAR 15.pdf PDF
Attachment 8 - Past Performance Questionnaire.docx DOCX document
Attachment 5 - Technical Exhibit OCC Life Claims.xlsx XLSX spreadsheet
Attachment 7 - Technical Capability Questionnire.pdf PDF
Attachment 2 -Technical Exhibit Active Employee Census Data.xlsx XLSX spreadsheet
Attachment 1A - OGLI Pricing Structure Template.docx DOCX document
Show all 23

On GovTribe

Work with this file

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

Text version

Sheet1

Pay PeriodCurrent NameGradeAdjusted Base SalaryOFR Life Basic Deduction AmountOFR Life Age Coverage CodeOFR Life Age Coverage DescriptionGender CodeStateOFR Life Age Group Desc
2025-11ABEYSEKERA, MANASHANTHA WALIMUNI60237,910.000.000NONEMVA60 and over
2025-11ANDERSON, EMILY ROSE70255,624.000.000NONEFMD40 to 44
2025-11ANDREWS, SPENCER BROWN53175,801.0011.3511BASIC/EMPLOYEE/SPOUSE 100MVAUnder 35
2025-11ANDRIAMANANJARA, MIALY TIANA60221,680.0027.859BASIC/SPOUSE 100FDC50 to 54
2025-11ARBEITER, TIMOTHY JAMES53141,199.006.819BASIC/SPOUSE 100MFL40 to 44
2025-11ARNOLD, ROBERT LEE60143,881.000.000NONEMTX40 to 44
2025-11ARRAYA, MARIAH C60193,559.0011.855BASIC/EMPLOYEEFVA45 to 49
2025-11BECKER, JONATHAN EDWARD53170,925.000.000NONEMDCUnder 35
2025-11BECRAFT, LAURA ANN53154,708.003.501BASIC ONLYFKY60 and over
2025-11BEJARANO, JEREMIAH MANUEL53193,411.009.279BASIC/SPOUSE 100MDC35 to 39
2025-11BELL JR, RICHARD CARL60191,171.006.3631BASIC/FAMILY 5XMPA50 to 54
2025-11BERG, THEODORE60249,384.000.000NONEMVA55 to 59
2025-11BILLIOT, ANDREA PIERCE60174,573.000.000NONEFLA55 to 59
2025-11BRIGHT, STEVE WESLEY60195,184.0059.1621BASIC/EMPLOYEE/FAMILY 3XMVA55 to 59
2025-11BROWE, BRYAN EVERETT60248,406.000.000NONEMVA50 to 54
2025-11BROWN JR., THOMAS70305,189.0045.222BASIC/SPOUSE 50MMA60 and over
2025-11BROWN, WILLIE HAROLD53212,710.0010.179BASIC/SPOUSE 100MNJ35 to 39
2025-11BRUNO, CANDICE T60209,784.000.000NONEFDC40 to 44
2025-11BUCKLEY, AMANDA LEE60183,355.0015.3536BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XFMD35 to 39
2025-11BURNWORTH, BRANDON DOUGLAS60164,571.003.721BASIC ONLYMOH40 to 44
2025-11CALAHAN, LYNN MARIE60204,295.000.000NONEFVA50 to 54
2025-11CALLWOOD, DION60193,521.000.000NONEMDC55 to 59
2025-11CANTONE III, JOHN MICHAEL53142,678.003.231BASIC ONLYMNH35 to 39
2025-11CARATELLI, DANIELE53177,480.000.000NONEMVAUnder 35
2025-11CAREY, MARK STEVEN70308,300.000.000NONEMVA60 and over
2025-11CARR, DENNIS WESLEY53150,954.000.000NONEMNE45 to 49
2025-11CASWELL, JENNIFER BOND60217,332.004.911BASIC ONLYFVA50 to 54
2025-11CENICOLA, ASHLYN BEA51109,275.000.000NONEFVAUnder 35
2025-11CERA, JENNIFER SUE60203,701.004.591BASIC ONLYFFL50 to 54
2025-11CHAO, JEFFERSON60210,328.004.751BASIC ONLYMVA45 to 49
2025-11CHERIAN, MONSON CHERIAN60246,937.0047.1511BASIC/EMPLOYEE/SPOUSE 100MVA50 to 54
2025-11CHIELLA, DAGMAR SILVA60285,289.006.421BASIC ONLYFNJ55 to 59
2025-11CHUN, SUSAN M60224,303.0044.4111BASIC/EMPLOYEE/SPOUSE 100FMD50 to 54
2025-11COLEMAN, LORA YVONNE60213,724.000.000NONEFMD50 to 54
2025-11COMAN, ROXANA53182,294.0019.635BASIC/EMPLOYEEFVA45 to 49
2025-11CONTRERAS, JORGE LIONEL53179,775.000.000NONEMNJ55 to 59
2025-11COOK, JOHN ADAM60170,741.000.000NONEMIN35 to 39
2025-11CRAIG, LAURA ALEXIS MILLE70266,218.00101.8112BASIC/EMPLOYEE/SPOUSE 100/FAMILY 1XFMD55 to 59
2025-11CRIDER, TAYLOR MARIE60132,863.006.3730BASIC/EMPLOYEE/SPOUSE 100/FAMILY 4XFNYUnder 35
2025-11CURLEY, ANDREW ERIC60188,542.0017.3311BASIC/EMPLOYEE/SPOUSE 100MVA40 to 44
2025-11D AMICO, PAUL E60202,584.0036.769BASIC/SPOUSE 100MDC55 to 59
2025-11DASS, BHARAT BHUSHAN60226,262.0014.4633BASIC/EMPLOYEE/FAMILY 5XMVA50 to 54
2025-11DAWSON, LAURA ELLEN60173,529.0014.489BASIC/SPOUSE 100FCO45 to 49
2025-11DE GRAEF, ERWIN M60137,290.0025.109BASIC/SPOUSE 100MWV55 to 59
2025-11DEMASSI, NICHOLAS JOHN53101,741.000.000NONEMLAUnder 35
2025-11DICARLO, DAVID FRANCIS53148,124.000.000NONEMVA35 to 39
2025-11DINGEMAN, JOHN FISHER60212,531.004.791BASIC ONLYMVA45 to 49
2025-11DOHN, KRISTIN ANNE60199,772.000.000NONEFMD45 to 49
2025-11DOOLITTLE, THOMAS FRANCIS60218,061.0057.935BASIC/EMPLOYEEMDC55 to 59
2025-11DOUGLAS, REED ANTHONY53177,480.000.000NONEMVAUnder 35
2025-11DRIVER, PATRICIA H60253,289.000.000NONEFMD55 to 59
2025-11EGAN, EMILY MICHELLE52126,211.000.000NONEFOH40 to 44
2025-11ELHASSAN, HUDA MOHAMED60215,449.0066.665BASIC/EMPLOYEEFMD60 and over
2025-11EMMET, LILIYA FAY53186,694.000.000NONEFMD35 to 39
2025-11EVANS, THOMAS C60143,492.0019.9136BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMWV40 to 44
2025-11FAN, LIJU60224,372.000.000NONEFMD60 and over
2025-11FLIEGELMAN, ARTHUR MICHAEL60285,289.006.421BASIC ONLYMNJ60 and over
2025-11FOLEY, KRISTY LYN53183,928.000.000NONEFMD40 to 44
2025-11FRIEDRICHS, MELANIE RUTH53170,925.006.255BASIC/EMPLOYEEFDCUnder 35
2025-11FULTON, THOMAS ANTHONY53115,959.000.000NONEMOHUnder 35
2025-11GADGIL, SALIL UDAY53174,255.000.000NONEMDCUnder 35
2025-11GARRIOTT, COREY OWEN60194,471.000.000NONEMDC40 to 44
2025-11GEDDADA, RAMASHANKER SRINIVAS60249,384.000.000NONEMVA55 to 59
2025-11GEISHECKER, TIMOTHY A60226,288.000.000NONEMDC55 to 59
2025-11GILL, CHRISTOPHER MANSELL60237,921.005.351BASIC ONLYMMD40 to 44
2025-11GONZALEZ, AVIANA NICOLE53144,032.000.000NONEFAZUnder 35
2025-11GORADIA, NARENDRA RAMANIKLAL60244,974.0037.315BASIC/EMPLOYEEMNJ55 to 59
2025-11GRAHAM, MATTHEW THOMAS70257,083.000.000NONEMKY50 to 54
2025-11GREENE, CHELSEA AMANDA60185,745.000.000NONEFNH35 to 39
2025-11GRIFFIN, JIMMY ANTHONY GERA60229,032.000.000NONEMMD40 to 44
2025-11GRUNFELDER-MCCRAN, DERREK JUSTIN51130,093.000.000NONEMPAUnder 35
2025-11HAMANDI, HASHIM WADIE60249,384.0018.472BASIC/SPOUSE 50MVA50 to 54
2025-11HANIF, TARIQ60249,384.000.000NONEMVA45 to 49
2025-11HARDY, RAY70273,537.00157.2711BASIC/EMPLOYEE/SPOUSE 100MMD60 and over
2025-11HATA-TANZER, JOSHUA LANDON53187,284.000.000NONEMNY35 to 39
2025-11HE, WEIPING60205,408.0010.882BASIC/SPOUSE 50MVA45 to 49
2025-11HEILBRON, JOHN WENDELL53174,255.000.000NONEMDCUnder 35
2025-11HELLWIG, TRACI LEE70308,300.006.941BASIC ONLYFVA55 to 59
2025-11HERLACH, BROOK DAYTON60196,562.000.000NONEMVA40 to 44
2025-11HERMAN, JASON ANDREW60236,283.000.000NONEMDC50 to 54
2025-11HIA, SONG CHI YOUNG53212,710.004.791BASIC ONLYMNY40 to 44
2025-11HURST, JESSICA ASHLEY60210,783.000.000NONEFNJ40 to 44
2025-11ILABACA, FRANCISCO ELIAS53193,411.009.279BASIC/SPOUSE 100MVA35 to 39
2025-11JAYASIMHA, PRABHU53159,055.0013.339BASIC/SPOUSE 100MOH45 to 49
2025-11JIBILIAN, MATTHEW ROBERT60163,098.000.000NONEMWA35 to 39
2025-11JOHNSON, DOLLY LOUCHE51145,951.003.301BASIC ONLYFVA55 to 59
2025-11JOHNSON, RACHEL IONE70218,444.004.931BASIC ONLYFVA40 to 44
2025-11JOHNSON, STEFANIE ANNE60204,924.000.000NONEFVA55 to 59
2025-11KARUNAMUNI, NETH PRAJEEVA53140,849.000.000NONEMVAUnder 35
2025-11KEMBLE, JEFFREY ALAN60234,807.0021.495BASIC/EMPLOYEEMVA50 to 54
2025-11KIM, DASOL70303,900.0010.825BASIC/EMPLOYEEMMD45 to 49
2025-11KING, KUOWINTA' DAMARIUS60201,715.002.651BASIC ONLYMMD40 to 44
2025-11KOSTKA, KEVIN THOMAS60278,661.000.000NONEMNY45 to 49
2025-11KRAUSE, JOHN CHARLES60202,791.0064.475BASIC/EMPLOYEEMVA60 and over
2025-11LARIMORE, MATTHEW LEE70269,247.0027.3836BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMVA40 to 44
2025-11LARSON, WILLIAM DURRETT60240,442.0024.4111BASIC/EMPLOYEE/SPOUSE 100MDC40 to 44
2025-11LE, PHONG DO60201,252.000.000NONEMCA45 to 49
2025-11LEE, JUNG HOON60231,796.005.221BASIC ONLYMMD45 to 49
2025-11LERNER, JASON53193,196.000.000NONEMVA55 to 59
2025-11LEUNG, RUTH60249,384.005.621BASIC ONLYFVA60 and over
2025-11LIU, NANSHYONG DAVID60249,384.000.000NONEMMD60 and over
2025-11LOCKWOOD, JACOB CHRISTOPHER51110,581.000.000NONEMDCUnder 35
2025-11LY, KIET T60246,312.000.000NONEMVA55 to 59
2025-11MALCOLM, JENNIFER LAURELI60193,885.002.551BASIC ONLYFCO40 to 44
2025-11MANN, ROBERT ALFORD53177,919.000.000NONEMDCUnder 35
2025-11MARSHALL, ALICIA LYNNE70297,442.000.000NONEFDC50 to 54
2025-11MARTIN, JAMES DONALD80316,600.0047.0736BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMVA45 to 49
2025-11MARTIN, SEAN THOMAS60166,579.000.000NONEMDC40 to 44
2025-11MAUTZ, DAVID RYAN60168,063.000.000NONEMLA40 to 44
2025-11MAYERS, CYNTHIA PORTERFIELD51109,278.002.501BASIC ONLYFMD60 and over
2025-11MCGARITY, RYAN THOMAS60216,867.000.000NONEMMD40 to 44
2025-11MCGOWAN, KURT KRISTIAN60269,924.0023.6011BASIC/EMPLOYEE/SPOUSE 100MNY40 to 44
2025-11MEEHL, APRIL ISABELLE53170,925.000.000NONEFDCUnder 35
2025-11MILLER, WENDY JOAN60189,025.000.000NONEFVA50 to 54
2025-11MOHAMMED, UMAR NAJEEB53165,619.008.056BASIC/EMPLOYEE/SPOUSE 50MVA35 to 39
2025-11MORAN, THOMAS PATRICK60213,633.004.821BASIC ONLYMNJ40 to 44
2025-11MORENO, DAVID IVAN60225,842.0020.585BASIC/EMPLOYEEMVA45 to 49
2025-11MUHAMMAD, SAIFFELDEEN53155,034.000.000NONEMMD60 and over
2025-11MYRTHIL, CHARLENE DENICE51219,355.000.000NONEFMD55 to 59
2025-11NARDONI, MARIO ALBERTO80316,600.0082.856BASIC/EMPLOYEE/SPOUSE 50MVA60 and over
2025-11NASEER, HUMAYUN BIN60206,241.004.661BASIC ONLYMVA50 to 54
2025-11NEFF, STEVEN RAY53144,437.003.281BASIC ONLYMIN40 to 44
2025-11NGO, LAN QUANG52150,864.000.000NONEMTX35 to 39
2025-11NGUYEN, BINH HOA60209,490.004.731BASIC ONLYMVA50 to 54
2025-11NGUYEN, VICTORIA53150,341.0020.3236BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XFNC40 to 44
2025-11NICHOLS, WILLIAM MANCILL60304,848.0098.4116BASIC/EMPLOYEE/SPOUSE 50/FAMILY 2XMMD60 and over
2025-11OJEDA, HECTOR ANTONIO53136,321.000.000NONEMFL45 to 49
2025-11OLSON, LUKE MARSHALL53187,176.004.241BASIC ONLYMDC45 to 49
2025-11PADDRIK, MARK ENDEL70292,019.000.000NONEMDC35 to 39
2025-11PANDHER, GURKIRAT SINGH60212,888.0014.0035BASIC/SPOUSE 100/FAMILY 5XMMD40 to 44
2025-11PASSANTE, MICHAEL JAMES70265,821.000.000NONEMVA45 to 49
2025-11PETERSON, ROBERT JOSEPH70308,300.004.041BASIC ONLYMMD55 to 59
2025-11PISANI, DANIELLE DOHERTY53154,686.000.000NONEFPA40 to 44
2025-11PLATER, BRIAN DOUGLAS60235,677.0012.6523BASIC/SPOUSE 100/FAMILY 3XMVA40 to 44
2025-11POLLARD SR, MICHAEL BRIAN70273,021.000.000NONEMMD45 to 49
2025-11POTAPOV, KSENIA51108,010.000.000NONEFMAUnder 35
2025-11PREUSSER SR., JOSEPH ALEXANDER53150,559.000.000NONEMTX55 to 59
2025-11PURNELL JR., DAREN LEE70236,563.0014.179BASIC/SPOUSE 100MVT40 to 44
2025-11RAJAEE, JILL E60249,384.000.000NONEFMD45 to 49
2025-11RAJAN, SRIRAM70308,300.000.000NONEMMD45 to 49
2025-11RAKOWSKY, DANYLO STEFAN60283,948.0016.969BASIC/SPOUSE 100MNJ40 to 44
2025-11RANDERIA, PARESH60225,481.005.081BASIC ONLYMMD60 and over
2025-11READ, ADRIENNE MARIE60145,567.0014.666BASIC/EMPLOYEE/SPOUSE 50FFL40 to 44
2025-11REED, NAA MARTEKI60191,346.0012.525BASIC/EMPLOYEEFIL40 to 44
2025-11RIORDAN, JOHN PATRICK60216,206.000.000NONEMCO50 to 54
2025-11ROBINSON, JEFFREY FRANCIS60213,724.000.000NONEMMD40 to 44
2025-11ROGERS, KARA ROSE53168,870.000.000NONEFCA40 to 44
2025-11ROUST, TAMARA LYNN70283,485.0030.725BASIC/EMPLOYEEFIL50 to 54
2025-11RUCHTI, THOMAS GORDEN70308,300.0021.2736BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMVA35 to 39
2025-11RUDDY, JUSTIN LAWRENCE60248,772.005.601BASIC ONLYMVA50 to 54
2025-11RUSNAK, ELVIS J60205,460.0093.2036BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMNJ55 to 59
2025-11SACHAR, KSHITIJ52150,864.000.000NONEMMD35 to 39
2025-11SCHWARTZ, NICHOLAS ANDREW53135,984.000.000NONEMDCUnder 35
2025-11SHULTZ, MARC WILLIAM60215,746.004.861BASIC ONLYMNY40 to 44
2025-11SIMMONS, COLIN DANIEL60249,384.000.000NONEMVA40 to 44
2025-11STANLEY, LISA RENEE60178,519.000.000NONEFWV60 and over
2025-11STEFAN, SARA MICHELLE51106,226.000.000NONEFDCUnder 35
2025-11STEMP, DANIEL SCOTT60251,465.000.000NONEMNY35 to 39
2025-11STERLING III, BOBBY GENE53135,110.000.000NONEMMOUnder 35
2025-11STODDARD, CHANTELLE LETITIA53190,441.000.000NONEFMD45 to 49
2025-11STOKES, VERONICA52158,504.003.595BASIC/EMPLOYEEFDC50 to 54
2025-11SUQI, ASSEM MUSTAFA60219,740.000.000NONEMVA45 to 49
2025-11TAPIA, JOSE MARIA UY51109,573.000.000NONEMMDUnder 35
2025-11TOUCH, LISA ANN60181,961.006.105BASIC/EMPLOYEEFVA40 to 44
2025-11VAZQUEZ ROSADO, ANJA SIOBHAN60172,880.000.000NONEFTX45 to 49
2025-11WALTERS, RICHARD SLADE53173,702.003.921BASIC ONLYMWV55 to 59
2025-11WARNER, MICHAEL STANLEY60186,950.000.000NONEMWI55 to 59
2025-11WEAVER, JEFFREY SCOTT60227,847.005.131BASIC ONLYMPA55 to 59
2025-11WEGENER, GARREN MICHAEL53141,429.004.619BASIC/SPOUSE 100MVAUnder 35
2025-11WELLS, VALERIE CHARISSE70257,350.000.000NONEFMD60 and over
2025-11WESLEY, CALEB JAMES60214,019.004.841BASIC ONLYMMD45 to 49
2025-11XIE, BIQIN60232,914.005.241BASIC ONLYFMD45 to 49
2025-11XU, YAN60214,855.000.000NONEFMD60 and over
2025-11YOMMER, CHRISTOPHER PAUL53142,657.000.000NONEMTN45 to 49
2025-11ZHAO, KEVIN LIANG53187,005.002.471BASIC ONLYMVAUnder 35
2025-11ZITKO, JOHN ROBERT70308,300.0038.745BASIC/EMPLOYEEMMD55 to 59
2025-11ZOU, GUANGWEI60211,866.002.781BASIC ONLYMVA50 to 54
2025-11ZUNIGA JR., JOSE ALBERTO60213,200.0034.8536BASIC/EMPLOYEE/SPOUSE 100/FAMILY 5XMNY45 to 49

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