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

Home / Companies / SPL CONSULTING, LLC

SPL CONSULTING, 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
SPL CONSULTING, LLC
SPL CONSULTING LLC
55144FY2016 to FY2017
Latest decision 2017-06-19
54SYSTEMS ANALYST
16 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings55
Certified LCAs55
Denied LCAs0
Role titles14
Worksites4
Latest decision2017-06-19
USCIS approvals54
USCIS denials13

Aliases and source names

AliasesSource NamesSources
SPL CONSULTING LLCSPL CONSULTING, LLC, SPL CONSULTING LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SYSTEMS ANALYST15-112116$61,000$0
BUSINESS SYSTEMS ANALYST15-112113$61,000$0
BUSINESS ANALYST15-11217$61,000$0
IT SYSTEMS ANALYST15-11213$80,000$0
PROGRAMMER ANALYST15-11213$63,000$0
SOFTWARE ENGINEER15-11322$70,000$0
SR. BUSINESS SYSTEMS ANALYST15-11212$80,000$80,000
SYSTEM ANALYST15-11212$75,000$0
BUSINESS ANALYST .15-11211$65,000$0
BUSINESS SYSTEMS ANALYSTS15-11211$90,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
IrvingTX75038421261,00080,0002,0162,017
Farmers BranchTX7523410570,00002,0172,017
Farmers BranchTX753242280,00002,0172,017
RvingTX750381161,00002,0162,016

Full company payload

Company IDcompany:spl consulting
NameSPL CONSULTING, LLC
Normalized Namespl consulting
Source Company Idscompany_dol_oflc_lca_spl_consulting_llc, company_uscis_h1b_datahub_spl_consulting_llc_tax_3780
Source NamesSPL CONSULTING, LLC, SPL CONSULTING LLC
AliasesSPL CONSULTING LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "SPL CONSULTING, LLC",
    "SPL CONSULTING LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "SPL CONSULTING, LLC",
      "filing_count": 51,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPL CONSULTING LLC",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPL CONSULTING LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3780",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 55,
  "case_count": 55,
  "role_title_count": 14,
  "worksite_count": 4,
  "total_workers": 55,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-09-29",
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2017-06-19",
  "certified_count": 55,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 55,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 52,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "E-3 Australian",
      "filing_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 23,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 54,
  "total_denial": 13,
  "fiscal_years": [
    "2014",
    "2015",
    "2016",
    "2017",
    "2018"
  ],
  "year_metrics": [
    {
      "cities": [
        "Irving"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "75038"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 6,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_llc_tax_3780_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_023724"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Irving"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "75038"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 6,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_llc_tax_3780_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_019026"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Irving"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "75038"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 13,
      "initial_approval": 5,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_llc_tax_3780_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_019751"
      ],
      "continuing_approval": 8
    },
    {
      "cities": [
        "Dallas",
        "Farmers Branch",
        "Irving"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "75038",
        "75234"
      ],
      "total_denial": 3,
      "initial_denial": 0,
      "total_approval": 14,
      "initial_approval": 5,
      "continuing_denial": 3,
      "petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_llc_tax_3780_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_017637",
        "sr_uscis_h1b_datahub_2017_row_017638",
        "sr_uscis_h1b_datahub_2017_row_017639"
      ],
      "continuing_approval": 9
    },
    {
      "cities": [
        "Dallas",
        "Farmers Branch"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "75234"
      ],
      "total_denial": 8,
      "initial_denial": 1,
      "total_approval": 15,
      "initial_approval": 3,
      "continuing_denial": 7,
      "petition_count_id": "petition_count_uscis_h1b_archive_spl_consulting_llc_tax_3780_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_018972",
        "sr_uscis_h1b_datahub_2018_row_018973"
      ],
      "continuing_approval": 12
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "IRVING TX 75038",
      "city": "Irving",
      "state": "TX",
      "postal_code": "75038",
      "filing_count": 43,
      "case_count": 43,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "FARMERS BRANCH TX 75234",
      "city": "Farmers Branch",
      "state": "TX",
      "postal_code": "75234",
      "filing_count": 12,
      "case_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-06-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "IRVING TX 75038",
      "city": "Irving",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75038",
      "filing_count": 42,
      "case_count": 42,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FARMERS BRANCH TX 75234",
      "city": "Farmers Branch",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75234",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-06-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FARMERS BRANCH TX 75324",
      "city": "Farmers Branch",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75324",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "RVING TX 75038",
      "city": "Rving",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75038",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "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": [
    "TX"
  ],
  "cities": [
    "Irving",
    "Farmers Branch",
    "Rving",
    "Dallas"
  ],
  "postal_codes": [
    "75038",
    "75234",
    "75324"
  ],
  "top_markets": [
    {
      "city": "Irving",
      "state": "TX",
      "postal_code": "75038",
      "lca_count": 42,
      "role_title_count": 12,
      "wage_low_min": 61000,
      "wage_high_max": 80000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Farmers Branch",
      "state": "TX",
      "postal_code": "75234",
      "lca_count": 10,
      "role_title_count": 5,
      "wage_low_min": 70000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Farmers Branch",
      "state": "TX",
      "postal_code": "75324",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 80000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Rving",
      "state": "TX",
      "postal_code": "75038",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 61000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 23,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 61000,
  "annualized_high_max": 80000,
  "annualized_low_avg": 74745.4545454545
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 32,
    "case_count": 32,
    "role_title_count": 10,
    "worksite_count": 2,
    "wage_low_min": 61000,
    "wage_high_max": 80000,
    "wage_low_avg": 70750
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 23,
    "case_count": 23,
    "role_title_count": 8,
    "worksite_count": 3,
    "wage_low_min": 63000,
    "wage_high_max": 0,
    "wage_low_avg": 80304.347826087
  }
]
Links
{
  "roles": "/v1/roles?company=SPL%20CONSULTING%2C%20LLC",
  "wages": "/v1/wages?company=SPL%20CONSULTING%2C%20LLC",
  "trends": "/v1/trends?company=SPL%20CONSULTING%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=spl+consulting+llc&limit=5JSON