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

Home / Companies / CPQ SOLUTIONS, LLC

CPQ 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
CPQ SOLUTIONS, LLC
CPQ SOLUTIONS LLC
28106FY2016 to FY2019
Latest decision 2019-01-23
13CONSULTANT
5 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings28
Certified LCAs28
Denied LCAs0
Role titles10
Worksites6
Latest decision2019-01-23
USCIS approvals13
USCIS denials5

Aliases and source names

AliasesSource NamesSources
CPQ SOLUTIONS LLCCPQ SOLUTIONS, LLC, CPQ SOLUTIONS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
CONSULTANT15-11315$65,000$0
TECHNICAL ARCHITECT15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
5$100,000$100,000
IMPLEMENTATION PROJECT MANAGER15-11992$103,000$0
PRACTICE LEAD15-11322$135,000$0
PROGRAMMER ANALYST15-11312$85,000$0
SENIOR CONSULTANT15-11322$110,000$0
SENIOR IMPLEMENTATION CONSULTANT15-11312$110,000$0
SENIOR IMPLEMENTATION CONSULTANT15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
2$122,500$132,000
SOLUTION ARCHITECT15-11322$98,342$0
SOLUTION ARCHITECT15-11331$120,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
San CarlosCA9407017867,97402,0162,018
HoustonTX770406565,000100,0002,0172,019
San JoseCA951132275,00002,0162,016
San DiegoCA9212811132,000132,0002,0192,019
SunnyvaleCA940891198,34202,0162,016
HoustonTX770701185,00002,0162,016

Full company payload

Company IDcompany:cpq solutions
NameCPQ SOLUTIONS, LLC
Normalized Namecpq solutions
Source Company Idscompany_dol_oflc_lca_cpq_solutions_llc, company_uscis_h1b_datahub_cpq_solutions_llc_tax_7286
Source NamesCPQ SOLUTIONS, LLC, CPQ SOLUTIONS LLC
AliasesCPQ SOLUTIONS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "CPQ SOLUTIONS, LLC",
    "CPQ SOLUTIONS LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "CPQ SOLUTIONS, LLC",
      "filing_count": 24,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CPQ SOLUTIONS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7286",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 28,
  "case_count": 28,
  "role_title_count": 10,
  "worksite_count": 6,
  "total_workers": 28,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-10-08",
  "latest_fiscal_year": 2019,
  "latest_decision_date": "2019-01-23",
  "certified_count": 28,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 27,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "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": 28,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 19,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 13,
  "total_denial": 5,
  "fiscal_years": [
    "2015",
    "2016",
    "2017",
    "2018",
    "2019",
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "San Carlos"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94070"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cpq_solutions_llc_tax_7286_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_028314"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "San Carlos"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94070"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_cpq_solutions_llc_tax_7286_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_029877"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "San Carlos"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94070"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 6,
      "initial_approval": 1,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_cpq_solutions_llc_tax_7286_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_026933"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "San Carlos"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94070"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cpq_solutions_llc_tax_7286_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_029415"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Redwood City"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94063"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_cpq_solutions_llc_tax_7286_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_029622"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Redwood City"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94063"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_cpq_solutions_llc_tax_7286_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_012129"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "REDWOOD CITY CA 94063",
      "city": "Redwood City",
      "state": "CA",
      "postal_code": "94063",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-01-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "SAN CARLOS CA 94070",
      "city": "San Carlos",
      "state": "CA",
      "postal_code": "94070",
      "filing_count": 26,
      "case_count": 26,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-08-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "HOUSTON TX 77040",
      "city": "Houston",
      "county": "Harris",
      "state": "TX",
      "postal_code": "77040",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-11-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN DIEGO CA 92128",
      "city": "San Diego",
      "county": "San Diego",
      "state": "CA",
      "postal_code": "92128",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-01-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN CARLOS CA 94070",
      "city": "San Carlos",
      "county": "San Mateo",
      "state": "CA",
      "postal_code": "94070",
      "filing_count": 17,
      "case_count": 17,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-08-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN JOSE CA 95113",
      "city": "San Jose",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "95113",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HOUSTON TX 77070",
      "city": "Houston",
      "county": "Harris",
      "state": "TX",
      "postal_code": "77070",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SUNNYVALE CA 94089",
      "city": "Sunnyvale",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "94089",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 6,
    "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": [
    "San Carlos",
    "Houston",
    "San Jose",
    "San Diego",
    "Sunnyvale",
    "Redwood City"
  ],
  "postal_codes": [
    "94070",
    "77040",
    "95113",
    "92128",
    "94089",
    "77070",
    "94063"
  ],
  "top_markets": [
    {
      "city": "San Carlos",
      "state": "CA",
      "postal_code": "94070",
      "lca_count": 17,
      "role_title_count": 8,
      "wage_low_min": 67974,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Houston",
      "state": "TX",
      "postal_code": "77040",
      "lca_count": 6,
      "role_title_count": 5,
      "wage_low_min": 65000,
      "wage_high_max": 100000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019
    },
    {
      "city": "San Jose",
      "state": "CA",
      "postal_code": "95113",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 75000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "San Diego",
      "state": "CA",
      "postal_code": "92128",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 132000,
      "wage_high_max": 132000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Sunnyvale",
      "state": "CA",
      "postal_code": "94089",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 98342,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Houston",
      "state": "TX",
      "postal_code": "77070",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 85000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "541512",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541512",
      "filing_count": 19,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 65000,
  "annualized_high_max": 132000,
  "annualized_low_avg": 100857.071428571
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 9,
    "case_count": 9,
    "role_title_count": 7,
    "worksite_count": 4,
    "wage_low_min": 75000,
    "wage_high_max": 0,
    "wage_low_avg": 102149.111111111
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 11,
    "case_count": 11,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 65000,
    "wage_high_max": 0,
    "wage_low_avg": 91492.9090909091
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 4,
    "worksite_count": 2,
    "wage_low_min": 90896,
    "wage_high_max": 0,
    "wage_low_avg": 111039
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 100000,
    "wage_high_max": 132000,
    "wage_low_avg": 116000
  }
]
Links
{
  "roles": "/v1/roles?company=CPQ%20SOLUTIONS%2C%20LLC",
  "wages": "/v1/wages?company=CPQ%20SOLUTIONS%2C%20LLC",
  "trends": "/v1/trends?company=CPQ%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=cpq+solutions+llc&limit=5JSON