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

Home / Companies / KSIT CONSULTING, INC.

KSIT CONSULTING, 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
KSIT CONSULTING, INC.
KSIT CONSULTING INC
332115FY2016 to FY2018
Latest decision 2018-07-02
16SOFTWARE DEVELOPER
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings33
Certified LCAs33
Denied LCAs0
Role titles21
Worksites15
Latest decision2018-07-02
USCIS approvals16
USCIS denials6

Aliases and source names

AliasesSource NamesSources
KSIT CONSULTING INCKSIT CONSULTING, INC., KSIT CONSULTING INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SOFTWARE DEVELOPER15-11324$66,000$0
BUILD ENGINEER15-11323$67,200$0
DATABASE ADMINISTRATOR15-11213$90,000$0
SYSTEMS ADMINISTRATOR15-11423$60,000$0
DATABASE ADMINISTRATOR/DEVELOPER15-11412$83,200$0
DB2 DATABASE ADMINISTRATOR15-11412$117,000$0
ASSOCIATE PROGRAMMER15-11321$64,000$0
BUSINESS/SYSTEM ANALYST15-11211$57,600$0
DATA ANALYST15-11321$58,000$0
DATABASE ADMINISTRATOR15-11411$78,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
ColumbusOH43229151154,00002,0162,017
Greenwood VillageCO801112274,00002,0182,018
WashingtonDC200052264,00002,0172,018
CharlotteNC282172160,00002,0172,017
MemphisTN381252258,00002,0182,018
PhoenixAZ850541178,02102,0182,018
Rancho CordovaCA956701178,00002,0182,018
HartfordCT061051182,00002,0182,018
MonroeLA712031156,00002,0182,018
St.paulMN551121179,00002,0182,018

Full company payload

Company IDcompany:ksit consulting
NameKSIT CONSULTING, INC.
Normalized Nameksit consulting
Source Company Idscompany_dol_oflc_lca_ksit_consulting_inc, company_uscis_h1b_datahub_ksit_consulting_inc_tax_9464
Source NamesKSIT CONSULTING, INC., KSIT CONSULTING INC
AliasesKSIT CONSULTING INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "KSIT CONSULTING, INC.",
    "KSIT CONSULTING INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "KSIT CONSULTING, INC.",
      "filing_count": 22,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "KSIT CONSULTING INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9464",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 33,
  "case_count": 33,
  "role_title_count": 21,
  "worksite_count": 15,
  "total_workers": 33,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-02-12",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2018-07-02",
  "certified_count": 33,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 33,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 33,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 23,
      "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": 6,
  "fiscal_years": [
    "2014",
    "2015",
    "2016",
    "2017",
    "2018",
    "2019"
  ],
  "year_metrics": [
    {
      "cities": [
        "Westerville"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43082"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ksit_consulting_inc_tax_9464_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_026480"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Columbus",
        "Westerville"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43082",
        "43229"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ksit_consulting_inc_tax_9464_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_021441",
        "sr_uscis_h1b_datahub_2015_row_021442"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43229"
      ],
      "total_denial": 2,
      "initial_denial": 2,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ksit_consulting_inc_tax_9464_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_022313"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43229"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 5,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_ksit_consulting_inc_tax_9464_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_019944"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "Columbus",
        "Rockville"
      ],
      "states": [
        "MD",
        "OH"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20850",
        "43229"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ksit_consulting_inc_tax_9464_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_021663",
        "sr_uscis_h1b_datahub_2018_row_021664"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43229"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 4,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ksit_consulting_inc_tax_9464_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_021564"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "COLUMBUS OH 43229",
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43229",
      "filing_count": 32,
      "case_count": 32,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-04-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "ROCKVILLE MD 20850",
      "city": "Rockville",
      "state": "MD",
      "postal_code": "20850",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "WASHINGTON DC 20005",
      "city": "Washington",
      "county": "District Of Columbia",
      "state": "DC",
      "postal_code": "20005",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "GREENWOOD VILLAGE CO 80111",
      "city": "Greenwood Village",
      "county": "Arapahoe",
      "state": "CO",
      "postal_code": "80111",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MEMPHIS TN 38125",
      "city": "Memphis",
      "county": "Shelby",
      "state": "TN",
      "postal_code": "38125",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "RANCHO CORDOVA CA 95670",
      "city": "Rancho Cordova",
      "county": "Sacramento",
      "state": "CA",
      "postal_code": "95670",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "PHOENIX AZ 85054",
      "city": "Phoenix",
      "county": "Maricopa",
      "state": "AZ",
      "postal_code": "85054",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-04-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MARYSVILLE OH 43040",
      "city": "Marysville",
      "county": "Delaware",
      "state": "OH",
      "postal_code": "43040",
      "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": "MONROE LA 71203",
      "city": "Monroe",
      "county": "Ouachita",
      "state": "LA",
      "postal_code": "71203",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HARTFORD CT 06105",
      "city": "Hartford",
      "county": "Hartford",
      "state": "CT",
      "postal_code": "06105",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "PROVIDENCE RI 02904",
      "city": "Providence",
      "county": "Providence",
      "state": "RI",
      "postal_code": "02904",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ST.PAUL MN 55112",
      "city": "St.paul",
      "county": "Ramsey",
      "state": "MN",
      "postal_code": "55112",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBUS OH 43229",
      "city": "Columbus",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43229",
      "filing_count": 15,
      "case_count": 15,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-06-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHARLOTTE NC 28217",
      "city": "Charlotte",
      "county": "Mecklenburg",
      "state": "NC",
      "postal_code": "28217",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BEDMINSTER NJ 07921",
      "city": "Bedminster",
      "county": "Somerset",
      "state": "NJ",
      "postal_code": "07921",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-07-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WARREN NJ 07059",
      "city": "Warren",
      "county": "Somerset",
      "state": "NJ",
      "postal_code": "07059",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "RESTON VA 20190",
      "city": "Reston",
      "county": "Fairfax",
      "state": "VA",
      "postal_code": "20190",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 15,
    "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": [
    "OH",
    "CO",
    "DC",
    "NC",
    "TN",
    "AZ",
    "CA",
    "CT",
    "LA",
    "MN",
    "NJ",
    "RI",
    "VA",
    "MD"
  ],
  "cities": [
    "Columbus",
    "Greenwood Village",
    "Washington",
    "Charlotte",
    "Memphis",
    "Phoenix",
    "Rancho Cordova",
    "Hartford",
    "Monroe",
    "St.paul",
    "Bedminster",
    "Warren",
    "Marysville",
    "Providence",
    "Reston",
    "Rockville",
    "Westerville"
  ],
  "postal_codes": [
    "43229",
    "80111",
    "20005",
    "28217",
    "38125",
    "85054",
    "95670",
    "06105",
    "71203",
    "55112",
    "07921",
    "07059",
    "43040",
    "02904",
    "20190",
    "20850",
    "43082"
  ],
  "top_markets": [
    {
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43229",
      "lca_count": 15,
      "role_title_count": 11,
      "wage_low_min": 54000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Greenwood Village",
      "state": "CO",
      "postal_code": "80111",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 74000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Washington",
      "state": "DC",
      "postal_code": "20005",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 64000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Charlotte",
      "state": "NC",
      "postal_code": "28217",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 60000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Memphis",
      "state": "TN",
      "postal_code": "38125",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 58000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Phoenix",
      "state": "AZ",
      "postal_code": "85054",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 78021,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Rancho Cordova",
      "state": "CA",
      "postal_code": "95670",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 78000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Hartford",
      "state": "CT",
      "postal_code": "06105",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 82000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Monroe",
      "state": "LA",
      "postal_code": "71203",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 56000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "St.paul",
      "state": "MN",
      "postal_code": "55112",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 79000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 23,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 54000,
  "annualized_high_max": 0,
  "annualized_low_avg": 78246.0909090909
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 10,
    "case_count": 10,
    "role_title_count": 8,
    "worksite_count": 1,
    "wage_low_min": 54000,
    "wage_high_max": 0,
    "wage_low_avg": 79800
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 11,
    "case_count": 11,
    "role_title_count": 9,
    "worksite_count": 6,
    "wage_low_min": 60000,
    "wage_high_max": 0,
    "wage_low_avg": 80727.2727272727
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 12,
    "case_count": 12,
    "role_title_count": 12,
    "worksite_count": 10,
    "wage_low_min": 56000,
    "wage_high_max": 0,
    "wage_low_avg": 74676.75
  }
]
Links
{
  "roles": "/v1/roles?company=KSIT%20CONSULTING%2C%20INC.",
  "wages": "/v1/wages?company=KSIT%20CONSULTING%2C%20INC.",
  "trends": "/v1/trends?company=KSIT%20CONSULTING%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=ksit+consulting+inc&limit=5JSON