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

Home / Companies / Open Dealer Exchange, LLC

Open Dealer Exchange, LLC 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
Open Dealer Exchange, LLC
OPEN DEALER EXCHANGE LLC
24133FY2016 to FY2024
Latest decision 2024-05-28
16JAVA DEVELOPER
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings24
Certified LCAs24
Denied LCAs0
Role titles13
Worksites3
Latest decision2024-05-28
USCIS approvals16
USCIS denials0

Aliases and source names

AliasesSource NamesSources
OPEN DEALER EXCHANGE LLCOpen Dealer Exchange, LLC, OPEN DEALER EXCHANGE LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
JAVA DEVELOPER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
4$56,534$95,000
Computer Systems Analyst15-1121.00
Computer Systems Analysts
2$81,370$81,370
Computer Systems Analyst15-1121
Computer Systems Analysts
1$81,370$81,370
Java Developer15-1132.00
Software Developers, Applications
1$76,000$76,000
Lead Dotnet Developer15-1252.00
Software Developers
1$130,000$130,000
LEAD JAVA DEVELOPER15-11321$116,000$0
Lead Java Developer15-1132.00
Software Developers, Applications
1$127,890$127,890
Lead Java Developer15-1252.00
Software Developers
1$152,962$152,962
LEAD QUALITY ASSURANCE ANALYST15-11991$85,816$0
LEAD QUALITY ASSURANCE ENGINEER15-11991$85,816$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Farmington HillsMI4833415968,250152,9622,0192,024
SouthfieldMI480347556,53495,0002,0162,020
Farmington HillsMI48334-23162285,81602,0182,018

Full company payload

Company IDcompany:open dealer exchange
NameOpen Dealer Exchange, LLC
Normalized Nameopen dealer exchange
Source Company Idscompany_dol_oflc_lca_open_dealer_exchange_llc, company_uscis_h1b_datahub_open_dealer_exchange_llc_tax_1512
Source NamesOpen Dealer Exchange, LLC, OPEN DEALER EXCHANGE LLC
AliasesOPEN DEALER EXCHANGE LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Open Dealer Exchange, LLC",
    "OPEN DEALER EXCHANGE LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "OPEN DEALER EXCHANGE, LLC",
      "filing_count": 17,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Open Dealer Exchange, LLC",
      "filing_count": 7,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "OPEN DEALER EXCHANGE LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1512",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 24,
  "case_count": 24,
  "role_title_count": 13,
  "worksite_count": 3,
  "total_workers": 24,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-07-14",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-05-28",
  "certified_count": 24,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 12,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 10,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 24,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 23,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 16,
  "total_denial": 0,
  "fiscal_years": [
    "2012",
    "2013",
    "2014",
    "2015",
    "2017",
    "2018",
    "2019",
    "2020",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Southfield"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48034"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_dealer_exchange_llc_tax_1512_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_021183"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Southfield"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48034"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_dealer_exchange_llc_tax_1512_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_019849"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Southfield"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48034"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_dealer_exchange_llc_tax_1512_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_019457"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Southfield"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48034"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_dealer_exchange_llc_tax_1512_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_015631"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Southfield"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48034"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_dealer_exchange_llc_tax_1512_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_014522"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Southfield"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "52",
        "54"
      ],
      "postal_codes": [
        "48034"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_dealer_exchange_llc_tax_1512_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_015565",
        "sr_uscis_h1b_datahub_2018_row_015566"
      ],
      "continuing_approval": 4
    },
    {
      "cities": [
        "Farmington"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "48334"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_dealer_exchange_llc_tax_1512_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_015428"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "48334"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_dealer_exchange_llc_tax_1512_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_035560"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "52",
        "54"
      ],
      "postal_codes": [
        "48334",
        "48335"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_dealer_exchange_llc_tax_1512_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_038512",
        "sr_uscis_h1b_datahub_2021_row_038513",
        "sr_uscis_h1b_datahub_2021_row_038514"
      ],
      "continuing_approval": 2
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "FARMINGTON HILLS MI 48334",
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48334",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-05-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "FARMINGTON HILLS MI 48334-2316",
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48334-2316",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-10-05",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "SOUTHFIELD MI 48034",
      "city": "Southfield",
      "state": "MI",
      "postal_code": "48034",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2019-10-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "FARMINGTON HILLS MI 48334",
      "city": "Farmington Hills",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48334",
      "filing_count": 15,
      "case_count": 15,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-05-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SOUTHFIELD MI 48034",
      "city": "Southfield",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48034",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2019-10-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FARMINGTON HILLS MI 48334-2316",
      "city": "Farmington Hills",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48334-2316",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-08-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SOUTHFIELD MI 48034",
      "city": "Southfield",
      "county": "Michigan",
      "state": "MI",
      "postal_code": "48034",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-10-05",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "worksite_address_count": 4,
    "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": [
    "MI"
  ],
  "cities": [
    "Farmington Hills",
    "Southfield",
    "Farmington"
  ],
  "postal_codes": [
    "48334",
    "48034",
    "48334-2316",
    "48335"
  ],
  "top_markets": [
    {
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48334",
      "lca_count": 15,
      "role_title_count": 9,
      "wage_low_min": 68250,
      "wage_high_max": 152962,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Southfield",
      "state": "MI",
      "postal_code": "48034",
      "lca_count": 7,
      "role_title_count": 5,
      "wage_low_min": 56534,
      "wage_high_max": 95000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48334-2316",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 85816,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "52",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 13,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "523930",
      "filing_count": 9,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "54151",
      "filing_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 56534,
  "annualized_high_max": 152962,
  "annualized_low_avg": 96495.7916666667
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 74844,
    "wage_high_max": 0,
    "wage_low_avg": 74844
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 78000,
    "wage_high_max": 0,
    "wage_low_avg": 78000
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 56534,
    "wage_high_max": 0,
    "wage_low_avg": 90650.6666666667
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 68250,
    "wage_high_max": 110000,
    "wage_low_avg": 88938.6666666667
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 95000,
    "wage_high_max": 95000,
    "wage_low_avg": 95000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 76000,
    "wage_high_max": 90780,
    "wage_low_avg": 83390
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 97041,
    "wage_high_max": 127890,
    "wage_low_avg": 112465.5
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 81370,
    "wage_high_max": 81370,
    "wage_low_avg": 81370
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 81370,
    "wage_high_max": 81370,
    "wage_low_avg": 81370
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 81370,
    "wage_high_max": 118404,
    "wage_low_avg": 97234
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 152962,
    "wage_high_max": 152962,
    "wage_low_avg": 152962
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 130000,
    "wage_high_max": 130000,
    "wage_low_avg": 130000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 128220,
    "wage_high_max": 128220,
    "wage_low_avg": 128220
  }
]
Links
{
  "roles": "/v1/roles?company=Open%20Dealer%20Exchange%2C%20LLC",
  "wages": "/v1/wages?company=Open%20Dealer%20Exchange%2C%20LLC",
  "trends": "/v1/trends?company=Open%20Dealer%20Exchange%2C%20LLC"
}
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=open+dealer+exchange+llc&limit=5JSON