Home / Companies / OpenERP

OpenERP 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.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
OpenERP OpenERP, OPENERP INC	203	59	10	FY2016 to FY2026 Latest decision 2026-03-23	2	Channel Account Manager 19 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	203
Certified LCAs	201
Denied LCAs	0
Role titles	59
Worksites	10
Latest decision	2026-03-23
USCIS approvals	2
USCIS denials	2

Aliases and source names

Aliases	Source Names	Sources
OpenERP, OPENERP INC	OpenERP, OPENERP, INC., OPENERP INC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
Channel Account Manager	13-1161.00 Market Research Analysts and Marketing Specialists	19	$55,453	$93,000
Business Systems Analyst	15-1199.02 Computer Systems Engineers/Architects	11	$71,500	$114,000
BUSINESS ANALYST	15-1199	9	$56,555	$110,000
Business Systems Analyst	15-1299.08 Computer Systems Engineers/Architects	9	$79,000	$131,000
Channel Account Executive	13-1161.00 Market Research Analysts and Marketing Specialists	9	$55,453	$100,000
Full Stack Engineer	15-1252.00 Software Developers	9	$78,500	$103,000
Fullstack Engineer	15-1132.00 Software Developers, Applications	7	$70,000	$102,000
Partnership Executive	13-1161.00 Market Research Analysts and Marketing Specialists	7	$59,000	$96,000
Business Systems Analyst	13-1111.00 Management Analysts	7	$68,000	$119,805
Customer Success Manager	13-1161.00 Market Research Analysts and Marketing Specialists	6	$54,000	$65,000

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
San Francisco	CA	94134	126	37	53,955	210,000	2,018	2,024
Brisbane	CA	94005	30	14	67,700	176,000	2,024	2,026
San Francisco	CA	94124	21	12	53,955	110,000	2,017	2,018
Buffalo	NY	14202	9	5	63,000	118,000	2,024	2,026
Buffalo	NY	14203	8	3	70,000	100,000	2,021	2,023
San Francisco	CA	94107	3	2	56,555	75,000	2,016	2,018
Austin	TX	78703	2	2	131,000	131,000	2,024	2,024
Austin	TX	78704	2	2	88,000	88,000	2,022	2,025
San Diego	CA	92101	1	1	88,000	88,000	2,025	2,025
Redwood City	CA	94063	1	1	57,470	75,000	2,016	2,016

Full company payload

Company ID	company:openerp
Name	OpenERP
Normalized Name	openerp
Source Company Ids	company_dol_oflc_lca_odoo_inc, company_dol_oflc_lca_openerp_inc, company_uscis_h1b_datahub_openerp_inc_tax_1707
Source Names	OpenERP, OPENERP, INC., OPENERP INC
Aliases	OpenERP, OPENERP INC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1707",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 203,
  "case_count": 203,
  "role_title_count": 59,
  "worksite_count": 10,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2026,
  "latest_decision_date": "2026-03-23",
  "certified_count": 201,
  "denied_count": 0
}

Petition Activity

{
  "total_approval": 2,
  "total_denial": 2,
  "fiscal_years": [
    "2011",
    "2013",
    "2014"
  ],
  "year_metrics": [
    {
      "cities": [
        "San Jose"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "95113"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_openerp_inc_tax_1707_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_054667"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Redwood City"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94063"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_openerp_inc_tax_1707_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_048903"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Redwood City"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94063"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_openerp_inc_tax_1707_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_049965"
      ],
      "continuing_approval": 0
    }
  ]
}

Geography

{
  "states": [
    "CA",
    "NY",
    "TX"
  ],
  "cities": [
    "San Francisco",
    "Brisbane",
    "Buffalo",
    "Austin",
    "San Diego",
    "Redwood City",
    "San Jose"
  ],
  "postal_codes": [
    "94134",
    "94005",
    "94124",
    "14202",
    "14203",
    "94107",
    "78703",
    "78704",
    "92101",
    "94063",
    "95113"
  ],
  "top_markets": [
    {
      "city": "San Francisco",
      "state": "CA",
      "postal_code": "94134",
      "lca_count": 126,
      "role_title_count": 37,
      "wage_low_min": 53955,
      "wage_high_max": 210000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Brisbane",
      "state": "CA",
      "postal_code": "94005",
      "lca_count": 30,
      "role_title_count": 14,
      "wage_low_min": 67700,
      "wage_high_max": 176000,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2026
    },
    {
      "city": "San Francisco",
      "state": "CA",
      "postal_code": "94124",
      "lca_count": 21,
      "role_title_count": 12,
      "wage_low_min": 53955,
      "wage_high_max": 110000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Buffalo",
      "state": "NY",
      "postal_code": "14202",
      "lca_count": 9,
      "role_title_count": 5,
      "wage_low_min": 63000,
      "wage_high_max": 118000,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Buffalo",
      "state": "NY",
      "postal_code": "14203",
      "lca_count": 8,
      "role_title_count": 3,
      "wage_low_min": 70000,
      "wage_high_max": 100000,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2023
    },
    {
      "city": "San Francisco",
      "state": "CA",
      "postal_code": "94107",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 56555,
      "wage_high_max": 75000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Austin",
      "state": "TX",
      "postal_code": "78703",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 131000,
      "wage_high_max": 131000,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Austin",
      "state": "TX",
      "postal_code": "78704",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 88000,
      "wage_high_max": 88000,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2025
    },
    {
      "city": "San Diego",
      "state": "CA",
      "postal_code": "92101",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 88000,
      "wage_high_max": 88000,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Redwood City",
      "state": "CA",
      "postal_code": "94063",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 57470,
      "wage_high_max": 75000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}

Industry

{
  "naics_codes": [
    "541519",
    "54"
  ]
}

Wage Summary

{
  "annualized_low_min": 53955,
  "annualized_high_max": 210000,
  "annualized_low_avg": 73446.27722772275
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 2,
    "wage_low_min": 56555,
    "wage_high_max": 75000,
    "wage_low_avg": 65373.75
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 65042,
    "wage_high_max": 85000,
    "wage_low_avg": 65042
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 19,
    "case_count": 19,
    "role_title_count": 11,
    "worksite_count": 3,
    "wage_low_min": 53955,
    "wage_high_max": 110000,
    "wage_low_avg": 66702.3684210526
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 11,
    "case_count": 11,
    "role_title_count": 9,
    "worksite_count": 1,
    "wage_low_min": 66718,
    "wage_high_max": 168000,
    "wage_low_avg": 90206.1818181818
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 16,
    "case_count": 16,
    "role_title_count": 12,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 113000,
    "wage_low_avg": 76766.5625
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 68000,
    "wage_high_max": 78000,
    "wage_low_avg": 74666.6666666667
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 73000,
    "wage_high_max": 93000,
    "wage_low_avg": 73000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 13,
    "case_count": 13,
    "role_title_count": 8,
    "worksite_count": 1,
    "wage_low_min": 54000,
    "wage_high_max": 111000,
    "wage_low_avg": 82124.3076923077
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 18,
    "case_count": 18,
    "role_title_count": 12,
    "worksite_count": 2,
    "wage_low_min": 54000,
    "wage_high_max": 128000,
    "wage_low_avg": 82249.2222222222
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 80000,
    "wage_high_max": 180000,
    "wage_low_avg": 109333.333333333
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 18,
    "case_count": 18,
    "role_title_count": 8,
    "worksite_count": 2,
    "wage_low_min": 55453,
    "wage_high_max": 140500,
    "wage_low_avg": 87569.7222222222
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 1,
    "wage_low_min": 55453,
    "wage_high_max": 139000,
    "wage_low_avg": 112290.6
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 60278,
    "wage_high_max": 100000,
    "wage_low_avg": 83828
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 60278,
    "wage_high_max": 115000,
    "wage_low_avg": 80989.25
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 9,
    "case_count": 9,
    "role_title_count": 6,
    "worksite_count": 1,
    "wage_low_min": 60278,
    "wage_high_max": 122000,
    "wage_low_avg": 87381.6666666667
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 10,
    "case_count": 10,
    "role_title_count": 6,
    "worksite_count": 2,
    "wage_low_min": 66900,
    "wage_high_max": 135000,
    "wage_low_avg": 94360
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 90000,
    "wage_high_max": 100000,
    "wage_low_avg": 94000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 3,
    "wage_low_min": 71100,
    "wage_high_max": 155000,
    "wage_low_avg": 105420
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q2",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 1,
    "wage_low_min": 76200,
    "wage_high_max": 210000,
    "wage_low_avg": 114500.2
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 10,
    "case_count": 10,
    "role_title_count": 9,
    "worksite_count": 3,
    "wage_low_min": 58000,
    "wage_high_max": 131000,
    "wage_low_avg": 87468
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 116280,
    "wage_high_max": 116280,
    "wage_low_avg": 116280
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 67700,
    "wage_high_max": 67700,
    "wage_low_avg": 67700
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 98900,
    "wage_high_max": 176000,
    "wage_low_avg": 127450
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 18,
    "case_count": 18,
    "role_title_count": 10,
    "worksite_count": 3,
    "wage_low_min": 68300,
    "wage_high_max": 174574,
    "wage_low_avg": 108121.222222222
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 6,
    "worksite_count": 3,
    "wage_low_min": 73100,
    "wage_high_max": 139900,
    "wage_low_avg": 106328.571428571
  },
  {
    "fiscal_year": 2026,
    "quarter": "Q2",
    "lca_count": 9,
    "case_count": 9,
    "role_title_count": 4,
    "worksite_count": 2,
    "wage_low_min": 67808,
    "wage_high_max": 140000,
    "wage_low_avg": 111018.888888889
  }
]

Links

{
  "roles": "/v1/roles?company=OpenERP",
  "wages": "/v1/wages?company=OpenERP",
  "trends": "/v1/trends?company=OpenERP"
}

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=openerp&limit=5JSON

Docs · Get an API key