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

Home / Companies / MSHANA GROUP LLC

MSHANA GROUP 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
MSHANA GROUP LLC
ARIESPRO, AriesPro, MSHANA GROUP LLC DBA ARIESPRO
1064FY2017 to FY2022
Latest decision 2022-07-18
6INFORMATION SECURITY ANALYST
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings10
Certified LCAs10
Denied LCAs0
Role titles6
Worksites4
Latest decision2022-07-18
USCIS approvals6
USCIS denials1

Aliases and source names

AliasesSource NamesSources
ARIESPRO, AriesPro, MSHANA GROUP LLC DBA ARIESPRO, MSHANA GROUP LLC DBA AREISPROMSHANA GROUP LLC, MSHANA GROUP LLC DBA ARIESPRO, MSHANA GROUP LLC DBA AREISPROdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
INFORMATION SECURITY ANALYST15-11224$47,000$0
COMPUTER PROGRAMMER15-11312$52,478$0
Data Warehouse Specialist15-1243.01
Data Warehousing Specialists
1$60,000$60,000
DATABASE ADMINISTRATOR15-11411$55,000$0
Network Administrator15-1142.00
Network and Computer Systems Administrators
1$58,000$58,000
Network Support Specialist15-1152.00
Computer Network Support Specialists
1$50,500$50,500

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
RochesterNY146116347,00058,0002,0172,022
DunnNC146112152,47802,0172,017
DunnNC283351155,00002,0182,018
Sugar LandTX774791160,00060,0002,0222,022

Full company payload

Company IDcompany:mshana group
NameMSHANA GROUP LLC
Normalized Namemshana group
Source Company Idscompany_dol_oflc_lca_mshana_group_llc, company_uscis_h1b_datahub_mshana_group_llc_dba_ariespro_tax_5718, company_uscis_h1b_datahub_mshana_group_llc_dba_areispro_tax_5718
Source NamesMSHANA GROUP LLC, MSHANA GROUP LLC DBA ARIESPRO, MSHANA GROUP LLC DBA AREISPRO
AliasesARIESPRO, AriesPro, MSHANA GROUP LLC DBA ARIESPRO, MSHANA GROUP LLC DBA AREISPRO
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "MSHANA GROUP LLC",
    "MSHANA GROUP LLC DBA ARIESPRO",
    "MSHANA GROUP LLC DBA AREISPRO"
  ],
  "dba_names": [
    "ARIESPRO",
    "AriesPro"
  ],
  "name_variants": [
    {
      "value": "MSHANA GROUP LLC",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "AriesPro",
      "filing_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "ARIESPRO",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MSHANA GROUP LLC DBA ARIESPRO",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "MSHANA GROUP LLC DBA AREISPRO",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5718",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 10,
  "case_count": 10,
  "role_title_count": 6,
  "worksite_count": 4,
  "total_workers": 16,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-03-13",
  "latest_fiscal_year": 2022,
  "latest_decision_date": "2022-07-18",
  "certified_count": 10,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 6,
  "total_denial": 1,
  "fiscal_years": [
    "2014",
    "2017",
    "2018",
    "2020",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Sugar Land"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "77479"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mshana_group_llc_dba_ariespro_tax_5718_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_033940"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Sugar Land"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "77479"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mshana_group_llc_dba_ariespro_tax_5718_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_026624"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Sugar Land"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "77479"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mshana_group_llc_dba_ariespro_tax_5718_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_029058"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Sugar Land"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "77479"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mshana_group_llc_dba_ariespro_tax_5718_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_032594"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Sugar Land"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "77479"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mshana_group_llc_dba_ariespro_tax_5718_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_019362"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Sugar Land"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "77479"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mshana_group_llc_dba_areispro_tax_5718_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_035177"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "SUGAR LAND TX 77479",
      "city": "Sugar Land",
      "state": "TX",
      "postal_code": "77479",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-07-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ROCHESTER NY 14611",
      "city": "Rochester",
      "county": "Monroe",
      "state": "NY",
      "postal_code": "14611",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-06-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SUGAR LAND TX 77479",
      "city": "Sugar Land",
      "county": "Fort Bend",
      "state": "TX",
      "postal_code": "77479",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-07-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DUNN NC 28335",
      "city": "Dunn",
      "county": "Harnett",
      "state": "NC",
      "postal_code": "28335",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DUNN NC 14611",
      "city": "Dunn",
      "county": "Harnett",
      "state": "NC",
      "postal_code": "14611",
      "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"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "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": [
    "NY",
    "NC",
    "TX"
  ],
  "cities": [
    "Rochester",
    "Dunn",
    "Sugar Land"
  ],
  "postal_codes": [
    "14611",
    "28335",
    "77479"
  ],
  "top_markets": [
    {
      "city": "Rochester",
      "state": "NY",
      "postal_code": "14611",
      "lca_count": 6,
      "role_title_count": 3,
      "wage_low_min": 47000,
      "wage_high_max": 58000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Dunn",
      "state": "NC",
      "postal_code": "14611",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 52478,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Dunn",
      "state": "NC",
      "postal_code": "28335",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 55000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Sugar Land",
      "state": "TX",
      "postal_code": "77479",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 60000,
      "wage_high_max": 60000,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    }
  ]
}
Industry
{
  "naics_codes": [
    "541512",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541512",
      "filing_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 47000,
  "annualized_high_max": 60000,
  "annualized_low_avg": 52695.6
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 47000,
    "wage_high_max": 0,
    "wage_low_avg": 49191.2
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 55000,
    "wage_high_max": 0,
    "wage_low_avg": 56250
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 50500,
    "wage_high_max": 50500,
    "wage_low_avg": 50500
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 58000,
    "wage_high_max": 58000,
    "wage_low_avg": 58000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 60000,
    "wage_low_avg": 60000
  }
]
Links
{
  "roles": "/v1/roles?company=MSHANA%20GROUP%20LLC",
  "wages": "/v1/wages?company=MSHANA%20GROUP%20LLC",
  "trends": "/v1/trends?company=MSHANA%20GROUP%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=mshana+group+llc&limit=5JSON