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

Home / Companies / OPEN SOLUTIONS, LLC

OPEN SOLUTIONS, 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 SOLUTIONS, LLC
OPEN SOLUTIONS LLC
755FY2016 to FY2017
Latest decision 2017-03-23
5IMPLEMENTATION SPECIALIST, SR
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile
OPEN SOLUTIONS LLC A FISERV CO
OPEN SOLUTIONS LLC A FISERV CO
0--FY- to FY-
Latest decision -
9-uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings7
Certified LCAs6
Denied LCAs1
Role titles5
Worksites5
Latest decision2017-03-23
USCIS approvals5
USCIS denials1

Aliases and source names

AliasesSource NamesSources
OPEN SOLUTIONS LLCOPEN SOLUTIONS, LLC, OPEN SOLUTIONS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
IMPLEMENTATION SPECIALIST, SR15-11212$75,400$104,000
SOFTWARE DEVELOPER, TECH LEAD15-11322$91,062$137,540
QUALITY ASSURANCE ANALYST15-11991$70,699$80,474
SENIOR SOFTWARE DEVELOPER15-11321$91,062$123,309
SOFTWARE ARCHITECT, DIRECTOR, OPEN SOLUTIONS15-11321$105,560$214,500

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
EllingtonCT060292291,062214,5002,0162,017
KennesawGA301442175,400104,0002,0172,017
GlastonburyCT060331191,062123,3092,0162,016
South WindsorCT060741193,226137,5402,0172,017
OmahaNE681271170,69980,4742,0162,016

Full company payload

Company IDcompany:open solutions
NameOPEN SOLUTIONS, LLC
Normalized Nameopen solutions
Source Company Idscompany_dol_oflc_lca_open_solutions_llc, company_uscis_h1b_datahub_open_solutions_llc_tax_3050
Source NamesOPEN SOLUTIONS, LLC, OPEN SOLUTIONS LLC
AliasesOPEN SOLUTIONS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3050",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 7,
  "case_count": 7,
  "role_title_count": 5,
  "worksite_count": 5,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2017-03-23",
  "certified_count": 6,
  "denied_count": 1
}
Petition Activity
{
  "total_approval": 5,
  "total_denial": 1,
  "fiscal_years": [
    "2017",
    "2018"
  ],
  "year_metrics": [
    {
      "cities": [
        "Brookfield"
      ],
      "states": [
        "WI"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "51"
      ],
      "postal_codes": [
        "53045"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_solutions_llc_tax_3050_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010906"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "Brookfield"
      ],
      "states": [
        "WI"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "51"
      ],
      "postal_codes": [
        "53045"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_solutions_llc_tax_3050_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_011552"
      ],
      "continuing_approval": 0
    }
  ]
}
Geography
{
  "states": [
    "CT",
    "GA",
    "NE",
    "WI"
  ],
  "cities": [
    "Ellington",
    "Kennesaw",
    "Glastonbury",
    "South Windsor",
    "Omaha",
    "Brookfield"
  ],
  "postal_codes": [
    "06029",
    "30144",
    "06033",
    "06074",
    "68127",
    "53045"
  ],
  "top_markets": [
    {
      "city": "Ellington",
      "state": "CT",
      "postal_code": "06029",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 91062,
      "wage_high_max": 214500,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Kennesaw",
      "state": "GA",
      "postal_code": "30144",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 75400,
      "wage_high_max": 104000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Glastonbury",
      "state": "CT",
      "postal_code": "06033",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 91062,
      "wage_high_max": 123309,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "South Windsor",
      "state": "CT",
      "postal_code": "06074",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 93226,
      "wage_high_max": 137540,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Omaha",
      "state": "NE",
      "postal_code": "68127",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 70699,
      "wage_high_max": 80474,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "518210",
    "51"
  ]
}
Wage Summary
{
  "annualized_low_min": 70699,
  "annualized_high_max": 214500,
  "annualized_low_avg": 86058.4285714286
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 70699,
    "wage_high_max": 133900,
    "wage_low_avg": 84274.3333333333
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 75400,
    "wage_high_max": 214500,
    "wage_low_avg": 87396.5
  }
]
Links
{
  "roles": "/v1/roles?company=OPEN%20SOLUTIONS%2C%20LLC",
  "wages": "/v1/wages?company=OPEN%20SOLUTIONS%2C%20LLC",
  "trends": "/v1/trends?company=OPEN%20SOLUTIONS%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+solutions+llc&limit=5JSON