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

Home / Companies / CELCOM SOFTWARE SOLUTIONS, INC.

CELCOM SOFTWARE SOLUTIONS, INC. 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
CELCOM SOFTWARE SOLUTIONS, INC.
CELCOM SOFTWARE SOLUTIONS INC, CELCOM SOFTWARE SOLUTIONS, INC.
452010FY2016 to FY2018
Latest decision 2018-03-27
16PROGRAMMER ANALYST
11 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings45
Certified LCAs45
Denied LCAs0
Role titles20
Worksites10
Latest decision2018-03-27
USCIS approvals16
USCIS denials10

Aliases and source names

AliasesSource NamesSources
CELCOM SOFTWARE SOLUTIONS INC, CELCOM SOFTWARE SOLUTIONS, INC.CELCOM SOFTWARE SOLUTIONS, INC., CELCOM SOFTWARE SOLUTIONS INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
PROGRAMMER ANALYST15-113111$60,000$0
SENIOR PROGRAMMER ANALYST15-11319$69,000$0
TECHNICAL LEAD15-11315$69,000$0
QA CONSULTANT15-11312$69,000$0
SENIOR CONSULTANT15-11312$85,000$0
AWS DEVOPS ENGINEER15-11311$65,000$0
BILLING CONSULTANT15-11311$75,000$0
BRM ARCHITECT15-11211$85,000$0
BUSINESS ANALYST15-11211$80,000$0
BUSINESS ANALYST(SCRUM MASTER)15-11211$71,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
SuwaneeGA3002420460,00002,0162,017
RidgelandMS391577763,00002,0172,018
San DiegoCA921296568,00002,0172,018
New YorkNY100015460,00002,0172,017
Santa ClaraCA950542290,00002,0162,016
SunnyvaleCA940851185,00002,0182,018
SunnyvaleCA9408611100,00002,0172,017
AlpharettaGA300051174,00002,0172,017
FriscoTX750351185,00002,0182,018
San AntonioTX782181173,10002,0172,017

Full company payload

Company IDcompany:celcom software solutions
NameCELCOM SOFTWARE SOLUTIONS, INC.
Normalized Namecelcom software solutions
Source Company Idscompany_dol_oflc_lca_celcom_software_solutions_inc, company_uscis_h1b_datahub_celcom_software_solutions_inc_tax_0648
Source NamesCELCOM SOFTWARE SOLUTIONS, INC., CELCOM SOFTWARE SOLUTIONS INC
AliasesCELCOM SOFTWARE SOLUTIONS INC, CELCOM SOFTWARE SOLUTIONS, INC.
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "CELCOM SOFTWARE SOLUTIONS, INC.",
    "CELCOM SOFTWARE SOLUTIONS INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "CELCOM SOFTWARE SOLUTIONS INC",
      "filing_count": 28,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CELCOM SOFTWARE SOLUTIONS, INC.",
      "filing_count": 17,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CELCOM SOFTWARE SOLUTIONS INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "CELCOM SOFTWARE SOLUTIONS, INC.",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "0648",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 45,
  "case_count": 45,
  "role_title_count": 20,
  "worksite_count": 10,
  "total_workers": 45,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-30",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2018-03-27",
  "certified_count": 45,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 45,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 45,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 24,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 16,
  "total_denial": 10,
  "fiscal_years": [
    "2016",
    "2017",
    "2018",
    "2019",
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "Suwanee"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30024"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_celcom_software_solutions_inc_tax_0648_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_035970"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Suwanee"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30024"
      ],
      "total_denial": 3,
      "initial_denial": 3,
      "total_approval": 8,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_celcom_software_solutions_inc_tax_0648_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_032704"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Suwanee"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30024"
      ],
      "total_denial": 4,
      "initial_denial": 2,
      "total_approval": 4,
      "initial_approval": 1,
      "continuing_denial": 2,
      "petition_count_id": "petition_count_uscis_h1b_archive_celcom_software_solutions_inc_tax_0648_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_036173"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Suwanee"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30024"
      ],
      "total_denial": 2,
      "initial_denial": 2,
      "total_approval": 3,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_celcom_software_solutions_inc_tax_0648_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_036713"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Suwanee"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30024"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_celcom_software_solutions_inc_tax_0648_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_009086"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "SUWANEE GA 30024",
      "city": "Suwanee",
      "state": "GA",
      "postal_code": "30024",
      "filing_count": 45,
      "case_count": 45,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "RIDGELAND MS 39157",
      "city": "Ridgeland",
      "county": "Madison",
      "state": "MS",
      "postal_code": "39157",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN DIEGO CA 92129",
      "city": "San Diego",
      "county": "San Diego",
      "state": "CA",
      "postal_code": "92129",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SUNNYVALE CA 94085",
      "city": "Sunnyvale",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "94085",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FRISCO TX 75035",
      "city": "Frisco",
      "county": "Collin",
      "state": "TX",
      "postal_code": "75035",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SUWANEE GA 30024",
      "city": "Suwanee",
      "county": "Gwinnett",
      "state": "GA",
      "postal_code": "30024",
      "filing_count": 20,
      "case_count": 20,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10001",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10001",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ALPHARETTA GA 30005",
      "city": "Alpharetta",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30005",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-09-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN ANTONIO TX 78218",
      "city": "San Antonio",
      "county": "Bexar",
      "state": "TX",
      "postal_code": "78218",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SUNNYVALE CA 94086",
      "city": "Sunnyvale",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "94086",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SANTA CLARA CA 95054",
      "city": "Santa Clara",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "95054",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-09-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 10,
    "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",
    "MS",
    "CA",
    "NY",
    "TX"
  ],
  "cities": [
    "Suwanee",
    "Ridgeland",
    "San Diego",
    "New York",
    "Santa Clara",
    "Sunnyvale",
    "Alpharetta",
    "Frisco",
    "San Antonio"
  ],
  "postal_codes": [
    "30024",
    "39157",
    "92129",
    "10001",
    "95054",
    "94085",
    "94086",
    "30005",
    "75035",
    "78218"
  ],
  "top_markets": [
    {
      "city": "Suwanee",
      "state": "GA",
      "postal_code": "30024",
      "lca_count": 20,
      "role_title_count": 4,
      "wage_low_min": 60000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Ridgeland",
      "state": "MS",
      "postal_code": "39157",
      "lca_count": 7,
      "role_title_count": 7,
      "wage_low_min": 63000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "San Diego",
      "state": "CA",
      "postal_code": "92129",
      "lca_count": 6,
      "role_title_count": 5,
      "wage_low_min": 68000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10001",
      "lca_count": 5,
      "role_title_count": 4,
      "wage_low_min": 60000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Santa Clara",
      "state": "CA",
      "postal_code": "95054",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 90000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Sunnyvale",
      "state": "CA",
      "postal_code": "94085",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 85000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Sunnyvale",
      "state": "CA",
      "postal_code": "94086",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 100000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30005",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 74000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Frisco",
      "state": "TX",
      "postal_code": "75035",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 85000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "San Antonio",
      "state": "TX",
      "postal_code": "78218",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 73100,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 24,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 60000,
  "annualized_high_max": 0,
  "annualized_low_avg": 71580
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 21,
    "case_count": 21,
    "role_title_count": 4,
    "worksite_count": 2,
    "wage_low_min": 60000,
    "wage_high_max": 0,
    "wage_low_avg": 67809.5238095238
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 14,
    "case_count": 14,
    "role_title_count": 11,
    "worksite_count": 7,
    "wage_low_min": 60000,
    "wage_high_max": 0,
    "wage_low_avg": 75364.2857142857
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 10,
    "case_count": 10,
    "role_title_count": 7,
    "worksite_count": 4,
    "wage_low_min": 65000,
    "wage_high_max": 0,
    "wage_low_avg": 74200
  }
]
Links
{
  "roles": "/v1/roles?company=CELCOM%20SOFTWARE%20SOLUTIONS%2C%20INC.",
  "wages": "/v1/wages?company=CELCOM%20SOFTWARE%20SOLUTIONS%2C%20INC.",
  "trends": "/v1/trends?company=CELCOM%20SOFTWARE%20SOLUTIONS%2C%20INC."
}
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=celcom+software+solutions+inc&limit=5JSON