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

Home / Companies / LEAN ERP SOLUTIONS LLC

LEAN ERP 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
LEAN ERP SOLUTIONS LLC
LEAN ERP SOLUTIONS LLC
1928FY2016 to FY2018
Latest decision 2018-08-31
25PROGRAMMER ANALYST
13 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings19
Certified LCAs17
Denied LCAs2
Role titles2
Worksites8
Latest decision2018-08-31
USCIS approvals25
USCIS denials3

Aliases and source names

AliasesSource NamesSources
LEAN ERP SOLUTIONS LLCLEAN ERP SOLUTIONS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
PROGRAMMER ANALYST15-113213$60,320$0
PROGRAMMER ANALYST15-11315$60,320$0
COMPUTER PROGRAMMER15-11311$66,560$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Camp HillPA170507160,32002,0162,017
PenningtonNJ085343179,04002,0172,018
MechanicsburgPA170503260,32002,0162,018
NewarkNJ08534071052183,20002,0172,018
Camp HillPA170111160,32002,0162,016
EriePA165301160,32002,0162,016
HarrisburgPA171111160,32002,0162,016
MiddletownPA170571166,56002,0182,018

Full company payload

Company IDcompany:lean erp solutions
NameLEAN ERP SOLUTIONS LLC
Normalized Namelean erp solutions
Source Company Idscompany_dol_oflc_lca_lean_erp_solutions_llc, company_uscis_h1b_datahub_lean_erp_solutions_llc_tax_0039
Source NamesLEAN ERP SOLUTIONS LLC
AliasesLEAN ERP SOLUTIONS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "0039",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 19,
  "case_count": 19,
  "role_title_count": 2,
  "worksite_count": 8,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2018-08-31",
  "certified_count": 17,
  "denied_count": 2
}
Petition Activity
{
  "total_approval": 25,
  "total_denial": 3,
  "fiscal_years": [
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017",
    "2018",
    "2019"
  ],
  "year_metrics": [
    {
      "cities": [
        "Mechanicsburg"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "17050"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_lean_erp_solutions_llc_tax_0039_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_025979"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Mechanicsburg"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "17050"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_lean_erp_solutions_llc_tax_0039_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_024342"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Mechanicsburg"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "17050"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_lean_erp_solutions_llc_tax_0039_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_024262"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Camp Hill",
        "Mechanicsburg"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "17011",
        "17050"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_lean_erp_solutions_llc_tax_0039_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_019497",
        "sr_uscis_h1b_datahub_2015_row_019498"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Camp Hill"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "17011"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 6,
      "initial_approval": 5,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_lean_erp_solutions_llc_tax_0039_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_020249"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Camp Hill"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "17011"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_lean_erp_solutions_llc_tax_0039_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_018023"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Camp Hill",
        "Camphill"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "17011"
      ],
      "total_denial": 3,
      "initial_denial": 3,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_lean_erp_solutions_llc_tax_0039_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_019465",
        "sr_uscis_h1b_datahub_2018_row_019466"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Camp Hill"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "17011"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_lean_erp_solutions_llc_tax_0039_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_019280"
      ],
      "continuing_approval": 1
    }
  ]
}
Geography
{
  "states": [
    "PA",
    "NJ"
  ],
  "cities": [
    "Camp Hill",
    "Pennington",
    "Mechanicsburg",
    "Newark",
    "Erie",
    "Harrisburg",
    "Middletown",
    "Camphill"
  ],
  "postal_codes": [
    "17050",
    "08534",
    "0853407105",
    "17011",
    "16530",
    "17111",
    "17057"
  ],
  "top_markets": [
    {
      "city": "Camp Hill",
      "state": "PA",
      "postal_code": "17050",
      "lca_count": 7,
      "role_title_count": 1,
      "wage_low_min": 60320,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Pennington",
      "state": "NJ",
      "postal_code": "08534",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 79040,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Mechanicsburg",
      "state": "PA",
      "postal_code": "17050",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 60320,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Newark",
      "state": "NJ",
      "postal_code": "0853407105",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 83200,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Camp Hill",
      "state": "PA",
      "postal_code": "17011",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 60320,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Erie",
      "state": "PA",
      "postal_code": "16530",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 60320,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Harrisburg",
      "state": "PA",
      "postal_code": "17111",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 60320,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Middletown",
      "state": "PA",
      "postal_code": "17057",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 66560,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "5416",
    "54"
  ]
}
Wage Summary
{
  "annualized_low_min": 60320,
  "annualized_high_max": 0,
  "annualized_low_avg": 67545.2631578947
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 9,
    "case_count": 9,
    "role_title_count": 1,
    "worksite_count": 5,
    "wage_low_min": 60320,
    "wage_high_max": 0,
    "wage_low_avg": 60320
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 1,
    "worksite_count": 4,
    "wage_low_min": 64480,
    "wage_high_max": 0,
    "wage_low_avg": 72453.3333333333
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 2,
    "worksite_count": 4,
    "wage_low_min": 66560,
    "wage_high_max": 0,
    "wage_low_avg": 76440
  }
]
Links
{
  "roles": "/v1/roles?company=LEAN%20ERP%20SOLUTIONS%20LLC",
  "wages": "/v1/wages?company=LEAN%20ERP%20SOLUTIONS%20LLC",
  "trends": "/v1/trends?company=LEAN%20ERP%20SOLUTIONS%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=lean+erp+solutions+llc&limit=5JSON