H-1B VISA Explorer Shiny App

Posted on Aug 7, 2016

Disclaimer for Featured Image

This article is not a social commentary on US H-1B immigration visa as the featured image of the article might prelude .The image is an "attempt" at humor about concerns of outsourcing jobs among some sections of US population to Indians by the author who himself is of Indian origin and like the  character  "Apu"  from Simpsons in the image came to US from India on a student visa to do his PhD and as it would happen to be made this app to showcase skill-sets to potential future US employers.

Contents

  1. Background to H-1B Visa
  2. All about the Data
  3. H-1B Visa Explorer  App
  4. Time series of submitted and processed applications
  5. Processing Time
  6. Statewise Analysis of number of Applications
  7. State wise Average Salary
  8. Approval  Percentage
  9. Top of the Bunch
  10. Conclusions

 

1. H-1B Visa

Unlike Apu who  didn't want to go home after finishing education and had to live in US illegally for US not having an H-1B visa program at that time , the author wanted to explore  the chances of an application getting approved,  how long it takes for an application to be processed , which profession , job title , employer has high volume for applications and the success rate for applications.

The US H1B visa is a non-immigrant visa that allows US companies to employ foreign workers in specialty occupations that require theoretical or technical expertise in specialized fields such as in architecture, engineering, mathematics, science, and medicine. The job must meet certain criteria to qualify as a specialty occupation. Under this visa a US company can employ a foreign worker for up to six years. Individuals are not able to apply for an H1B visa to allow them to work in the US. The employer must make the petition for the employee. H1B visas are subject to annual numerical limits. Current immigration law allows for a total of 85,000 new H-1B visas to be made available each year. This number includes 65,000 new H-1B visas issued for overseas workers in professional or specialty occupation positions, and an additional 20,000 visas available for those with an advanced degree from a US academic institution.For details you can follow the link below:

U.S. Citizenship and Immigration Services (USCIS)

 

2. All about the Data

The case disclosure file covers VISA determinations issued between October 1, 2015 through June 30, 2016.Link to the data is below.

Office of Foreign Labor Certification (OFLC) Performance Data

3. Shiny App

The web app's basic layout is designed with a principle of being simplistic, intuitive and easy to use. It provides three types of data exploration: “Temporal”, “Statewise”, and “Top of the Bunch”.  The Temporal analysis explores the question of how long it takes for applications to be processed, as well as how many applications are submitted on a daily basis.   and time series of applications submitted and processed . Statewise analysis allows the user a to choose a number of different visualizations to dig into statewise data.  Top of the bunch answers which states , jobs ,  job titles and employers have the most  applications and highest salaries.

Main

 

4. Time Series 

In a typical work week two thousands applications are submitted and processed. The data shows a pretty big spike in the month of March for both submitted and processed applications. As it turns out, April 1st is the last day to submit and process applications for year 2016 H-1B visa cap.

 

TimeSeries

5. Processing Time

Most applications seem to be processed within a week's time frame as is evident from the plot, with the mode being on day 6.

ProcessingTime

6. State-wise number of Applications 

California , Texas , NY - NJ area dominate in term of bulk of applications submitted .

MapApplication

 

The app allows different visualizations for the data . Below is a way to look at total certified applications on a pie chart. The number of applications approved and denied are proportional to applications submitted so this pie chart for applications approved follows a similar trend as the map where California and Texas had the most applications submitted.

 

PieChartCertifiedApplications

7. State-wise Average Salary 

Average salary for H-1B Visa is more or less uniformly distributed with 45 states within 60k-80k range.

 

HistogramSalary

 

8. Approval Percentage

Approval percentage for applications is quite high with a minimum of 88 % to as much as 98 % in a few states. It indicates that once an application gets selected via lottery it has a very high chance of being approved in all states.

BarChartApproval

9. Top of the Bunch 

The app lets the user explore up to top 20 results of by  states, occupations, job titles and  employers in terms of number of applications being approved for H-1B visa and salary ( Average salary for top states) . Below are some interesting features .
Bar chart below shows California , Texas , New Jersey and Illinois have the most applications approved .

 

States_Application

IT jobs and Financial analysts jobs account for bulk of H-1B visas approved .

 

Occ_Appl

 

IT and consultancy companies from India are the top beneficiaries of the the program. Google and Microsoft are among the US companies that stand out.

 

Empl_Appl

 

Job titles are related to occupation category so the same result of software professionals and financial analysts getting most approved applications still shows here.

 

Titles_Appl

The app also lets users explore top states, occupations , job titles and employers in term of salary .  Though number of applications are dominated by software professionals .  Top salary occupation and job titles are ones belonging to medical field .

 

Occ_Sal

 

Titl_Sal

 

If one is interested in knowing which specific employer offers the highest salaries here is a graph.

 

Empl_Sal

 

Surprisingly, North Dakota , Washington and Maine are the top three states in terms of average salary.

 

Stat_Sal

10. Conclusions

  • Most applications are processed within a week.
  • IT and financial analyst companies from India benefit the most
  • Correspondingly California, New York and Texas have the highest number of  applications
  • Medical profession jobs have top salaries

 

 

 

 

 

 

About Author

Deepak Khurana

Deepak holds a Masters Degree in Physics from the Indian Institute of Technology Kharagpur, one of the top engineering school in India. He was then awarded the Henry M. MacCracken fellowship at New York University to pursue a...
View all posts by Deepak Khurana >

Leave a Comment

No comments found.

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI