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

Home / Companies / Stellar Consulting Solutions, LLC

Stellar Consulting 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
Stellar Consulting Solutions, LLC
NOT APPLICABLE, STELLAR CONSULTING SOLUTIONS LLC
642FY2018 to FY2021
Latest decision 2020-12-17
3Senior Applications Developer
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings6
Certified LCAs6
Denied LCAs0
Role titles4
Worksites2
Latest decision2020-12-17
USCIS approvals3
USCIS denials0

Aliases and source names

AliasesSource NamesSources
NOT APPLICABLE, STELLAR CONSULTING SOLUTIONS LLCStellar Consulting Solutions, LLC, STELLAR CONSULTING SOLUTIONS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Senior Applications Developer15-1132.00
Software Developers, Applications
2$68,203$75,000
IT PROJECT MANAGER15-1199.09
Information Technology Project Managers
1$111,966$111,967
SENIOR APPLICATION DEVELOPER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
1$75,000$75,000
Senior Applications Developer15-1132
Software Developers, Applications
1$68,203$75,000
SR. PROGRAMMER ANALYST15-11211$100,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
DuluthGA300975368,203111,9672,0192,021
AlpharettaGA3000911100,00002,0182,018

Full company payload

Company IDcompany:stellar consulting solutions
NameStellar Consulting Solutions, LLC
Normalized Namestellar consulting solutions
Source Company Idscompany_dol_oflc_lca_stellar_consulting_solutions_llc, company_uscis_h1b_datahub_stellar_consulting_solutions_llc_tax_5502
Source NamesStellar Consulting Solutions, LLC, STELLAR CONSULTING SOLUTIONS LLC
AliasesNOT APPLICABLE, STELLAR CONSULTING SOLUTIONS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Stellar Consulting Solutions, LLC",
    "STELLAR CONSULTING SOLUTIONS LLC"
  ],
  "dba_names": [
    "NOT APPLICABLE"
  ],
  "name_variants": [
    {
      "value": "Stellar Consulting Solutions, LLC",
      "filing_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "NOT APPLICABLE",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "STELLAR CONSULTING SOLUTIONS, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "STELLAR CONSULTING SOLUTIONS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5502",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 6,
  "case_count": 6,
  "role_title_count": 4,
  "worksite_count": 2,
  "total_workers": 6,
  "first_fiscal_year": 2018,
  "first_received_date": "2018-07-10",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2020-12-17",
  "certified_count": 6,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 6,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 6,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 3,
  "total_denial": 0,
  "fiscal_years": [
    "2020",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Duluth"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30097"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellar_consulting_solutions_llc_tax_5502_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_045664"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Duluth"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30097"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellar_consulting_solutions_llc_tax_5502_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_049816"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "DULUTH, GA 30097",
      "city": "Duluth",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2020-12-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "DULUTH GA 30097",
      "city": "Duluth",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "ALPHARETTA GA 30009",
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30009",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "DULUTH GA 30097",
      "city": "Duluth",
      "county": "Forsyth",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2020-12-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DULUTH GA 30097",
      "city": "Duluth",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ALPHARETTA GA 30009",
      "city": "Alpharetta",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30009",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "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": [
    "GA"
  ],
  "cities": [
    "Duluth",
    "Alpharetta"
  ],
  "postal_codes": [
    "30097",
    "30009"
  ],
  "top_markets": [
    {
      "city": "Duluth",
      "state": "GA",
      "postal_code": "30097",
      "lca_count": 5,
      "role_title_count": 3,
      "wage_low_min": 68203,
      "wage_high_max": 111967,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30009",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 100000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "541612",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541612",
      "filing_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 68203,
  "annualized_high_max": 111967,
  "annualized_low_avg": 81929.1666666667
}
Trend
[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 100000,
    "wage_high_max": 0,
    "wage_low_avg": 100000
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 75000,
    "wage_high_max": 75000,
    "wage_low_avg": 75000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 111966,
    "wage_high_max": 111967,
    "wage_low_avg": 111966
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 68203,
    "wage_high_max": 75000,
    "wage_low_avg": 68203
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 68203,
    "wage_high_max": 75000,
    "wage_low_avg": 68203
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 68203,
    "wage_high_max": 75000,
    "wage_low_avg": 68203
  }
]
Links
{
  "roles": "/v1/roles?company=Stellar%20Consulting%20Solutions%2C%20LLC",
  "wages": "/v1/wages?company=Stellar%20Consulting%20Solutions%2C%20LLC",
  "trends": "/v1/trends?company=Stellar%20Consulting%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=stellar+consulting+solutions+llc&limit=5JSON