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

Home / Companies / Ramsell Corporation

Ramsell Corporation H-1B company data

Summary

Ramsell Corporation filed 9 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2016-FY2024.

Of those, 9 were certified (a 100% certification rate among adjudicated filings).

The filings span 3 distinct role titles across 3 worksites.

The most-sponsored role was Senior Database Administrator (3 filings), with offered wages from $102,502 to $120,000.

Separately, USCIS H-1B Employer Data Hub records show 7 approved and 0 denied H-1B petitions for this employer.

LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
Ramsell Corporation
RAMSELL CORPORATION
933FY2016 to FY2024
Latest decision 2024-07-17
7SENIOR DATABASE ADMINISTRATOR
3 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings9
Certified LCAs9
Denied LCAs0
Role titles3
Worksites3
Latest decision2024-07-17
USCIS approvals7
USCIS denials0

Aliases and source names

AliasesSource NamesSources
RAMSELL CORPORATIONRamsell Corporation, RAMSELL CORPORATIONdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SENIOR DATABASE ADMINISTRATOR15-1141
DATABASE ADMINISTRATORS
3$102,502$120,000
Senior Software Developer15-1252.00
Software Developers
3$113,443$155,000
SENIOR SOFTWARE DEVELOPER15-11322$109,325$135,000
Sr. Database Administrator15-1242.00
Database Administrators
1$110,531$130,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
OaklandCA9460772102,502155,0002,0162,024
ConcordCA9452011113,443150,0002,0242,024
MelissaTX7545411110,531130,0002,0242,024

Full company payload

Company IDcompany:ramsell
NameRamsell Corporation
Normalized Nameramsell
Source Company Idscompany_dol_oflc_lca_ramsell_corporation, company_uscis_h1b_datahub_ramsell_corporation_tax_4229
Source NamesRamsell Corporation, RAMSELL CORPORATION
AliasesRAMSELL CORPORATION
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Ramsell Corporation",
    "RAMSELL CORPORATION"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "RAMSELL CORPORATION",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Ramsell Corporation",
      "filing_count": 4,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "RAMSELL CORPORATION",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4229",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 9,
  "case_count": 9,
  "role_title_count": 3,
  "worksite_count": 3,
  "total_workers": 9,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-02-24",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-07-17",
  "certified_count": 9,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 8,
      "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": 7,
  "total_denial": 0,
  "fiscal_years": [
    "2016",
    "2018",
    "2019",
    "2020",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Oakland"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94607"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ramsell_corporation_tax_4229_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_050263"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Oakland"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94607"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ramsell_corporation_tax_4229_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_053095"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Oakland"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "94607"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ramsell_corporation_tax_4229_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_056632"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Oakland"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94607"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ramsell_corporation_tax_4229_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_039718"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Oakland"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94607"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ramsell_corporation_tax_4229_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_042953"
      ],
      "continuing_approval": 2
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "OAKLAND CA 94607",
      "city": "Oakland",
      "state": "CA",
      "postal_code": "94607",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-11-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CONCORD CA 94520",
      "city": "Concord",
      "state": "CA",
      "postal_code": "94520",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-07-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "OAKLAND CA 94607",
      "city": "Oakland",
      "county": "Alameda",
      "state": "CA",
      "postal_code": "94607",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-11-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MELISSA TX 75454",
      "city": "Melissa",
      "county": "Collin",
      "state": "TX",
      "postal_code": "75454",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-07-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CONCORD CA 94520",
      "city": "Concord",
      "county": "Contra Costa",
      "state": "CA",
      "postal_code": "94520",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-12-12",
      "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": [
    "CA",
    "TX"
  ],
  "cities": [
    "Oakland",
    "Concord",
    "Melissa"
  ],
  "postal_codes": [
    "94607",
    "94520",
    "75454"
  ],
  "top_markets": [
    {
      "city": "Oakland",
      "state": "CA",
      "postal_code": "94607",
      "lca_count": 7,
      "role_title_count": 2,
      "wage_low_min": 102502,
      "wage_high_max": 155000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Concord",
      "state": "CA",
      "postal_code": "94520",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 113443,
      "wage_high_max": 150000,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Melissa",
      "state": "TX",
      "postal_code": "75454",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 110531,
      "wage_high_max": 130000,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024
    }
  ]
}
Industry
{
  "naics_codes": [
    "54151",
    "54",
    "99"
  ],
  "naics_breakdown": [
    {
      "value": "54151",
      "filing_count": 8,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 102502,
  "annualized_high_max": 155000,
  "annualized_low_avg": 109443.555555556
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 109803,
    "wage_high_max": 120000,
    "wage_low_avg": 109803
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 110000,
    "wage_high_max": 0,
    "wage_low_avg": 110000
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 109325,
    "wage_high_max": 135000,
    "wage_low_avg": 109325
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 102502,
    "wage_high_max": 120000,
    "wage_low_avg": 102502
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 113443,
    "wage_high_max": 155000,
    "wage_low_avg": 113443
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 110531,
    "wage_high_max": 130000,
    "wage_low_avg": 110531
  }
]
Links
{
  "roles": "/v1/roles?company=Ramsell%20Corporation",
  "wages": "/v1/wages?company=Ramsell%20Corporation",
  "trends": "/v1/trends?company=Ramsell%20Corporation"
}

Frequently asked questions

Does Ramsell Corporation sponsor H-1B visas?
Yes. Ramsell Corporation filed 9 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2024), of which 9 were certified. LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.
How many H-1B applications has Ramsell Corporation filed?
Ramsell Corporation has 9 H-1B LCA filings on record spanning FY2016-FY2024 across 3 role titles and 3 worksites.
What roles does Ramsell Corporation sponsor for H-1B?
The most common H-1B role at Ramsell Corporation is Senior Database Administrator (3 filings). Other frequent roles include Senior Software Developer, Sr. Database Administrator.
What wages does Ramsell Corporation offer H-1B workers?
For its most-sponsored role (Senior Database Administrator), Ramsell Corporation reported offered wages ranging from $102,502 to $120,000 in DOL LCA filings.
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=ramsell+corporation&limit=5JSON