bluedoor data·H-1B Jobs API·bluedoor.sh ->

Home / Companies / VIVEK TANDON

VIVEK TANDON H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
VIVEK TANDON
VIVEK TANDON
433FY2019 to FY2020
Latest decision 2019-11-21
0Administrative Assistant
2 filings
dol_oflc_lcaProfile

Activity summary

LCA filings4
Certified LCAs2
Denied LCAs2
Role titles3
Worksites3
Latest decision2019-11-21
USCIS approvals0
USCIS denials0

Aliases and source names

AliasesSource NamesSources
VIVEK TANDONVIVEK TANDONdol_oflc_lca

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Administrative Assistant13-1161.00
Market Research Analysts and Marketing Specialists
2$14,560$52,000
ASSISTANT11-3011
ADMINISTRATIVE SERVICES MANAGERS
1$60,923$60,923
ADMISTRATIVE ASSISANT13-1199
BUSINESS OPERATIONS SPECIALISTS, ALL OTHER
1$53,269$53,269

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
FayettevilleNC283032235,36060,9232,0192,020
FayettevilleNC283021114,56014,5602,0202,020
FayettevilleNC283031153,26953,2692,0192,019

Full company payload

Company IDcompany:vivek tandon
NameVIVEK TANDON
Normalized Namevivek tandon
Source Company Idscompany_dol_oflc_lca_trinity_hospitality_llc, company_dol_oflc_lca_trinity_hospitality
Source NamesVIVEK TANDON
AliasesVIVEK TANDON
Identifiers-
Sourcesdol_oflc_lca
Names
{
  "source_names": [
    "VIVEK TANDON"
  ],
  "dba_names": [
    "VIVEK TANDON"
  ],
  "name_variants": [
    {
      "value": "Trinity Hospitality LLC",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "VIVEK TANDON",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "VIVEK TANDON",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
LCA Activity
{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 3,
  "worksite_count": 3,
  "total_workers": 4,
  "first_fiscal_year": 2019,
  "first_received_date": "2019-03-13",
  "latest_fiscal_year": 2020,
  "latest_decision_date": "2019-11-21",
  "certified_count": 2,
  "denied_count": 2,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Denied",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Y",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 0,
  "total_denial": 0,
  "fiscal_years": [],
  "year_metrics": []
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "FAYETTEVILLE NC 28303",
      "city": "Fayetteville",
      "state": "NC",
      "postal_code": "28303",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2019-11-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "FAYETTEVILLE NC 28303",
      "city": "Fayetteville",
      "state": "NC",
      "postal_code": "28303",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "FAYETTEVILLE NC 28303",
      "city": "Fayetteville",
      "county": "Cumberland",
      "state": "NC",
      "postal_code": "28303",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2019-11-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FAYETTEVILLE NC 28302",
      "city": "Fayetteville",
      "county": "Cumberland",
      "state": "NC",
      "postal_code": "28302",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2019-11-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FAYETTEVILLE NC 28303",
      "city": "Fayetteville",
      "county": "Cumberland",
      "state": "NC",
      "postal_code": "28303",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 3,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}
Geography
{
  "states": [
    "NC"
  ],
  "cities": [
    "Fayetteville"
  ],
  "postal_codes": [
    "28303",
    "28302"
  ],
  "top_markets": [
    {
      "city": "Fayetteville",
      "state": "NC",
      "postal_code": "28303",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 35360,
      "wage_high_max": 60923,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Fayetteville",
      "state": "NC",
      "postal_code": "28302",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 14560,
      "wage_high_max": 14560,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Fayetteville",
      "state": "NC",
      "postal_code": "28303",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 53269,
      "wage_high_max": 53269,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    }
  ]
}
Industry
{
  "naics_codes": [
    "72111"
  ],
  "naics_breakdown": [
    {
      "value": "72111",
      "filing_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "72111",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 14560,
  "annualized_high_max": 60923,
  "annualized_low_avg": 45108.33333333335
}
Trend
[
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 53269,
    "wage_high_max": 60923,
    "wage_low_avg": 57096
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 14560,
    "wage_high_max": 52000,
    "wage_low_avg": 24960
  }
]
Links
{
  "roles": "/v1/roles?company=VIVEK%20TANDON",
  "wages": "/v1/wages?company=VIVEK%20TANDON",
  "trends": "/v1/trends?company=VIVEK%20TANDON"
}
Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=vivek+tandon&limit=5JSON