H-1B Labor Condition Applications: Number Received by Status H-1B Labor Condition Applications: Worker Positions by Status

H-1B Labor Condition Applications: 2001-2013

                  H-1B Labor Condition Applications: Number Received by Status

          Grand            Certified-
Year      Total  Certified  Withdrawn     Denied  Withdrawn    Voided      Hold   Pending  Debarred  Rejected   (other)
----  ---------  ---------  ---------  ---------  ---------  --------  --------  --------  --------  --------  --------
2001    286,876    244,680                42,196
2002    269,147    248,991                20,156
2003    268,374    260,020                 8,351                                        2                             1
2004    340,016    332,778                 6,451                            782         1         2                   2
2005    317,617    314,487                 3,124                                                                      6
2006    385,804    377,651                 1,529                          6,464       160
2007    426,573    418,041                 1,095                          7,248       189
2008    405,641    404,436                 1,205
2009    356,219    326,506      5,272     20,025      4,416
2010    342,546    262,690     27,805     40,452     11,584        14                                       1
2011    358,816    307,936     11,596     29,171     10,113
2012    415,706    352,668     31,118     21,147     10,773
2013    442,164    382,951     35,432     12,169     11,597                            15

=======================================================================================================================
                  H-1B Labor Condition Applications: Worker Positions by Status

          Grand            Certified-
Year      Total  Certified  Withdrawn     Denied  Withdrawn    Voided      Hold   Pending  Debarred  Rejected   (other)
----  ---------  ---------  ---------  ---------  ---------  --------  --------  --------  --------  --------  --------
2001  1,687,444  1,434,410               253,034
2002    716,853    645,741                71,112
2003    540,378    515,348                25,028                                        2
2004    651,102    628,593                21,604                            900         3         2
2005    694,839    683,356                11,477                                                                      6
2006    652,310    630,883                 6,470                         14,628       329
2007    768,692    748,205                 3,682                         16,489       316
2008    713,414    706,660                 6,754
2009    597,603    560,532      5,453     26,215      5,403
2010    585,338    489,179     29,513     52,171     14,319       155                                       1
2011    743,095    671,837     15,667     39,983     15,608
2012    904,097    820,431     34,861     31,167     17,638
2013    994,926    882,643     71,716     23,695     16,856                            16

Note: Values of TOTAL_WORKERS over 1,000 are not counted in the number of worker positions.  This includes 16 values
      listed in red type in the table below for years 2010 to 2013.
Sources: Foreign Labor Certification Data Center (2001-2007); U.S. Department of Labor:
         Spreadsheet for 2008, 2009, 2009 (continued), 2010, 2011, 2012, 2013

APPLICATIONS REQUESTING THE HIGHEST NUMBER OF TOTAL_WORKERS FROM EACH YEAR

(for each year, number selected to include all values of TOTAL_WORKERS over 1,000 and selected questionable entries)

    YEAR  STATUS      TOTAL_WORKERS  LCA_CASE_EMPLOYER_NAME                  LCA_CASE_EMPLOYER_ADDRESS     (ADDRESS2)          EMPLOYER_CITY  STATE       POSTAL_CODE
--------  ----------  -------------  --------------------------------------  ------------------------------------------------  -------------  ----------  -----------
    2013  DENIED          2,031,308  LONG DIVISION DESIGN COMPANY INC.       151 1ST AVE SUITE 40                              NEW YORK       NY          10003
          DENIED            793,172  SOUTH EAST ASIA PRAYER CENTER           432 ALLEGHENY RIVER BLD STE 203                   OAKMONT        PA          15139
          WITHDRAWN          60,000  PULSE ADVISORY LLC                      79 MADISON                                        NEW YORK       NY          10016
          DENIED             58,500  MDM WORLDWIDE SOLUTIONS INC.            264 WEST 40TH STREET SUITE 602                    NEW YORK       NY          10018
          DENIED              2,012  SYNTEL INC                              525 EAST BIG BEAVER ROAD                          TROY           MI          48083
          DENIED              2,012  MUSIGMA INC                             3400 DUNDEE RD                                    NORTHBROOK     IL          60062
          CERTIFIED             400  SYNTEL CONSULTING INC.                  525 EAST BIG BEAVER ROAD                          TROY           MI          48083
    2012  DENIED             43,555  ONESOURCE VIRTUAL HR, INC.              204 NORTH ECTOR DRIVE                             EULESS         TX          76039
          DENIED              2,011  IBM COORPORATION                        3039 CORNWALLIS RD                                RTP            NC          27709
          CERTIFIED             300  SYNTEL CONSULTING INC                   525 EAST. BIG BEAVER ROAD                         TROY           MI          48083
    2011  DENIED          1,132,014  HEWLETT-PACKARD COMPANY                 19483 PRUNERIDGE AVE.                             CUPERTINO      CA          95014
          DENIED             10,000  FARM SOLARENERGY INTL INC               450 NW 34TH STREET APT  113                       POMPANO BEACH  FL          33064
          DENIED              2,010  COGNIZANT TECHNOLOGY SOLUTIONS U.S. CORP500 FRANK W BURR BLVD, 7TH FLOOR                  TEANECK        NJ          07666
          DENIED                200  FARM AND SOLARENERGY INTL INC           450 NW 34TH STREET APT  113                       POMPANO BEACH  FL          33064
          DENIED                200  FARM AND SOLARENERGY INTL INC           450 NW 34TH STREET APT  113                       POMPANO BEACH  FL          33064
          CERTIFIED             175  WIPRO LIMITED                           2 TOWER CENTER BLVD.                              EAST BRUNSWICK NJ          08816
    2010  DENIED          7,000,000  MINEBRAIN SOLUTIONS INC                 13620 NE 20TH ST, SUITE G2,                       BELLEVUE       WA          98005
          DENIED             53,000  SUPERIOR TECH INC                       24383                                             NOVI           MI          48375
          DENIED             53,000  UNIVERSITY OF CALIFORNIA, SAN DIEGO     9500 GILMAN DRIVE                                 LA JOLLA       CA          92093
          DENIED             52,000  SUPERIOR TECH INC                       24383                                             NOVI           MI          48375
          VOIDED              5,464  BANJARA                                 34, AIRPORT ROAD                                  MUMBAI                     201002
          WITHDRAWN             485  PARK CENTRAL MANAGEMENT LLC.            870 7TH AVENUE                                    NEW YORK       NY          10019
          CERTIFIED             200  DETROIT MEDICAL CENTER                  4201 ST. ANTOINE                                  DETROIT        MI          48201
    2009  DENIED                999  MINORITY DIRECTED SMALL BUSINESS LLC    9520 JAMES A REED RD          SUITE F OFFICE B    KANSAS CITY    MO          64138
          CERTIFIED             995  BCG CONSULTING INC.                     111 W SAINT JOHN STREET       SUITE 610F          SAN JOSE       CA          95113
          CERTIFIED             991  NOVANTAS, LLC.                          485 LEXINGTON AVENUE                              NEW YORK       NY          10017
          CERTIFIED             901  AIRLINE INTELLIGENCE SYSTEMS INC.       3500 CARILLON POINT                               KIRKLAND       WA          98033
          CERTIFIED             901  AIRLINE INTELLIGENCE SYSTEMS INC.       3500 CARILLON POINT                               KIRKLAND       WA          98033
          CERTIFIED             464  TEGRITY                                 3412 NW 41 TER                                    SALT LAKERS    AS          55654
          CERTIFIED             464  TEGRITY                                 3412 NW 41 TER                                    SALT LAKERS    AS          55654
          DENIED                345  SHIVARAJ SUPER SPECIALITY HOSPITAL      ADDRESS                                           CITY           CA          34534-3453
          CERTIFIED             305  BETHEL CHURCH                           933 COLLEGE VIEW DR.                              REDDING        CA          96003
          DENIED                234  GURURAJ CORPORATIONS                    SDFSDF                                            SDFSDF         CA          23423-2342
          DENIED                234  GURURAJ CORPORATIONS                    SDFSDF                                            SDFSDF         CA          23423-2342
          DENIED                234  GURURAJ CORPORATIONS                    SDFSDF                                            SDFSDF         CA          23423-2342
          DENIED                222  SHIVARAJ SUPER SPECIALITY HOSPITAL      ADDRESS                                           CITY           CA          34534-3453
          CERTIFIED             200  SEMAFOR TECHNOLOGIES, INC.              5655 PEACHTREE PKWY.          SUITE 200           NORCROSS       GA          30092
    2008  CERTIFIED             839  KPFF, Inc.                              2800 N Central Ave            Suite 1010          Phoenix        AZ          85004
          CERTIFIED             839  KPFF, Inc.                              2800 N Central Ave            Suite 1010          Phoenix        AZ          85004
          DENIED                678  aaaaaaaaaaaaa                           ghfghfgh                                          fghfghfgh      CA          67867
          DENIED                678  aaaaaaaaaaaaa                           ghfghfgh                                          fghfghfgh      CA          67867
          CERTIFIED             630  The Regents of the University of Minneso207 Pleasant Street S.E.                          Minneapolis    MN          55455
          CERTIFIED             602  Consumers Union                         101 Truman Avenue                                 Yonkers        NY          10703
          CERTIFIED             565  fhfghfg                                 gggtghfgfgfg                                      fgbfg          AR          56756
          CERTIFIED             546  fhfghfg                                 ggg                                               fgbfg          AR          56756
          DENIED                546  Sun Microsystem                         bollinger street canyon                           sfd            AR          45353
          CERTIFIED             500  The Firm Group & Associates             4090 Truxel Road Ste #109                         Sacramento     CA          95835
          CERTIFIED             500  The Firm Group & Associates             4090 Truxel Road Ste #109                         Sacramento     CA          95835
          CERTIFIED             474  CRAZYONDIGITAL                          5750 Sonoma Drive,            Suite C             Pleasanton     CA          94566
          CERTIFIED             463  Large Company                           US                                                US             UT          54879
          CERTIFIED             463  Large Company                           US                                                US             UT          54879
          CERTIFIED             463  547457                                  57547                                             54754          AK          75786
          CERTIFIED             463  Large Company                           US                                                US             UT          54879
          CERTIFIED             463  Large Company                           US                                                US             UT          54879
          CERTIFIED             463  Large Company                           US                                                US             UT          54879
          CERTIFIED             463  Large Company                           US                                                US             UT          54879
          CERTIFIED             463  Large Company                           US                                                US             UT          54879
          CERTIFIED             456  INSZOOM                                 Address:999999                                    City           CA          99999
          DENIED                435  Sun Microsystem                         bollinger street canyon                           san ramon      CA          34345
    2007  Certified             991  CONSTELLATION ENERGY GROUP              750 EAST PRATT STREET                             BALTIMORE      MD          21202
          Certified             647  567                                     6.57E+59                                          7e67e567       KS          56775-7577
          Denied                423  1324134134                              14123C45                                          RWEF           TN          41342-4151
          Certified             400  Wafer Staffing                          P.O. Box 503                                      Ambridge       PA          15003
          Certified             400  Versi Tech                              100 Alexander Drive                               Monaca         PA          15061
          Denied                345  TEST                                    123 EAST LOWER                                    PHOENIX        AZ          85033
          Certified             325  Solaris Health System                   65 James Street                                   Edison         NJ          8818
          Denied                323  inszoom                                 Address:*                                         Banglore       KY          43243-3444
          Certified             297  Orb Model Management                    130 W. 56th St                                    New York       NY          10019
          Hold                  246  COFFEE LOVERS OF AMERICA                123 EAST LOWER BRANCH                             LEXINGTON      KY          75121
          Certified             244  UNBRIDLED TESTING                       12345 WEST REED                                   PHOENIX        AZ          85301
          Certified             232  ABC COMPANY                             123 N CENTRAL ST                                  GLENDALE       AZ          85005
          Certified             232  ABC COMPANY                             123 N CENTRAL ST                                  GLENDALE       AZ          85005
          Certified             232  ABC COMPANY                             123 N CENTRAL ST                                  GLENDALE       AZ          85005
          Certified             231  DAIHATSU AUTOMOBILE''S                  PRIMARY STREET                STREET 2            CITY           AZ          85004
          Certified             221  DAIHATSU AUTOMOBILE''S                  PRIMARY STREET                STREET 2            CITY           AZ          85004
          Certified             221  WIZDOM MICROSYSTEMS INCS.               201 E. FOREST HILLS DR                            PHOENIX        AZ          85022
          Certified             221  DAIHATSU AUTOMOBILE''S                  PRIMARY STREET                STREET 2            CITY           AZ          85004
          Certified             211  LCA COMPANY                             260 COFFEE POT DR. #3                             SEDONA         AZ          86336
    2006  Denied                999  TimKin Pvt. Ltd.1245                    address123                    address134          Orchard Park   NY          11111-1111
          Certified             786  TimKin Pvt. Ltd.1245                    address123                    address134          Orchard Park   NY          11111-1111
          Certified             666  Oracle27                                Address                                           City           AR          23421-2341
          Certified             643  KITTY KELLY SHOE CORP.                  275 PARK AVENUE SOUTH                             NEW YORK       NY          10003
          Certified             603  Cannon Cochran Management Services, Inc.2 E. Main St.                 Towne Centre BuildinDanville       IL          61832
          Certified             576  TimKin Pvt. Ltd.1245                    address123                    address134          Orchard Park   NY          11111-1111
          Denied                565  TimKin Pvt. Ltd.1245                    address123                    address134          Orchard Park   NY          11111-1111
          Certified             555  kfkzdgdrkjk;SGo[sdio                    111111                                            Putnam         CO          25454
          Certified             445  TimKin Pvt. Ltd.1245                    address123                    address134          Orchard Park   NY          11111-1111
          Certified             343  TimKin Pvt. Ltd.1245                    address123                    address134          Orchard Park   NY          11111-1111
          Certified             343  Oracle27                                Address                                           City           AR          23421-2341
          Certified             333  TimKin Pvt. Ltd.1245                    address123                    address134          Orchard Park   NY          11111-1111
          Certified             332  Oracle27                                Address                                           City           AR          23421-2341
          Denied                322  shiva                                   vaidyamath house ,Bel layout                      bangalore      NH          12333-3232
          Certified             321  TimKin Pvt. Ltd.1245                    address123                    address134          Orchard Park   NY          11111-1111
          Certified             313  TimKin Pvt. Ltd.1245                    address123                    address134          Orchard Park   NY          11111-1111
          Certified             300  New York City Public Schools            65 Court Street, Room 301                         Brooklyn       NY          11201
    2005^ Certified             999  Alabama Environmental Council           2717 7th Avenue South, Suite 207                  Birmingham     AL          35233
          Denied                903  miloye gracia                           p.o.box 46752                                     tampa          FL          33647
          Denied                787  PI Tech                                 weqe                                              weq            AK          34233-3444
          Certified             478  City of Enid                            401 W. Garriott                                   Enid           OK          73701
          Certified             300  New York City Public Schools            65 Court Street, Room 301                         Brooklyn       NY          11201
          Certified             250  APPLIED CARD SYSTEMS OF PA              50 APPLIED CARD WAY                               GLEN MILLS     PA          19342
          Certified             250  New York City Public Schools            65 Court Street, Room 301                         Brooklyn       NY          11201
          Denied                246  MMOTORVILAS                             C/O ADDRESS LINE 1            C/O ADDRESS 2       CITY CO        CA          86336
          Denied                233  PI Tech                                 weqe                                              weq            AK          34233-3444
          Certified             200  AZULAY HORN & SEIDEN LLC                205 N Michigan Avenue                             Chicago        IL          60601
    2004             Postdoctoral r  Manhattan                               KS                            66506               1              12/1/2003   6/4/2005
                     Architectural   New York                                NY                            10007               1              5/1/2004    4/30/2007
          Certified             991  Blue Frog Solutions, Inc.               555 South Andrews Avenue      Suite 202           Pompano Beach  FL          33069
          Certified             991  UW MADISON  Department of Medicine.     INTL FAC  AND STAFF SERVICES  174 BASCOM HALL 500 MADISON        WI          53706
          Certified             350  Neeti Khaitan                           E-Telequest                   1401 S 52nd Street -Tempe          AZ          85281
          Certified             350  IBM Global Services India Pvt. Ltd.     29000 Highway 98              Summit Building, SuiDaphne         AL          36526
    2003  32000      Postdoctoral r  Manhattan                               KS                            66506               1              10/15/2003  10/14/2006
          Certified             950  WorkForce Consultants, Inc.             4351 Gautier-Vancleave Road   Suite C-1           Gautier        MS          39553
          Certified             900  WorkForce Consultants, Inc.             4351 Gautier-Vancleave Road   Suite C-1           Gautier        MS          39553
          Certified             900  Workforce Consultants, Inc.             4351 Gautier/Vancleave Road   Suite C-1           Gautier        MS          39553
          Certified             297  Elite Model Managment Corp.             111 E 22nd St                                     New York       NY          10010
fax 2003  Certified             999  GE CAPITAL CORPORATIONIIIIIII           260 LONG RIDGE RD                                 STAMFORD       CT          6927
          Certified             995  EPIC SYSTEMS CORPORATION                5301 TOKAY BOULEVARD                              MADISON        WI          53711
          Certified             991  DIGITAL WAVES CORPORATION               7432 PRINCE DRIVE                              HUNTINGTON BEACH  CA          92647
    2002  Certified             999  Workforce Consultants, Inc.             2801 Bienville,                                   Ocean Springs  MS          39564
          Denied                888  Georgi Menteshashvili                   Republic Georgia. Tbilisi, Muk4a, mic/eria apartmeTbilisi        GA          38000-0000
          Denied                777  Mihkeal Kobakhidze                      Republic Georgia. Tbilisi, Khosharauli str. 24    Tbilisi        DC          38000-0000
          Certified             511  LENOX HILL HOSPITAL                     116 E. 76 STREET                                  NEW YORK       NY          10021
          Certified             300  LOVING HEARTS, INC.                     1151 NE 139 Street                                North Maimi    FL          33161
fax 2002  Certified             994  SYNYGY INC                              555 NORTH LANE                SUITE 6000          CONSHOHOCKEN   PA          194281
          Certified             993  GENERAL ELECTRIC COMPANY                60 LONG RIDGE RD                                  STAMFORD       CT          6927
          Certified             993  PENPOWER POWER ENERGY PROFESS           60 LONG RIDGE ROAD                                STAMFORD       CT          69271
          Certified             991  UNITED PRESS INT'L, INC.                1510 H STREET                                     WASHINGTON     DC          20005
fax 2001  Denied                997  INSCI                                   TWO WESTBOROUGHIBUSINISS PARK                     WESTBOROUGH    MA          16811
          Certified             996  IMAGESOFT TECHNOLOGIES SUBSID           100 MARINE PARKWAY                                REDWOOD SHORES CA          94065
          Certified             995  ICONIX PHARMACEUTICALS INC              850 MAUDE AVENUE                                  MOUNTAIN VIEW  CA          940431
          Certified             995  SUN MICROSYSTEMS INC                    901 SAN ANTONIO ROAD01 445                        PALO ALTO      CA          94303
          Certified             995  NVIDIA CORPORATION                      3535 MONROE STREET                                SANTA CLARA    CA          950511
          Certified             995  ICONIX PHARMACEUTICALS INC              850 MAUDE AVENUE                                  MOUNTAIN VIEW  CA          94043
          Certified             995  INARA NETWORKS INC                      3031 TISCH WAY SUITE 100                          SAN JOSE       CA          95128
          Denied                995  INFONET SERVICES CORPORATION            2160 EAST GRAND AVENUE                            EL SEGUNDO     CA          90245
          Certified             995  GENERAL ELECTRIC COMANY                 60 LONG RIDGE RD                                  STAMFORD       CT          6827
          Certified             995  ACUSON                                  1220 CHARLESTON ROAD393                           MOUNTAIN VIEW  CA          94039
          Denied                995  RINAT NEUROSCIENCE CORPORATIO           150 NORMANDY LANE                                 WOODSIDE       CA          94602
          Denied                995  OFFSHORE DIGITAL SERVICES INC           14798 WICKS BOULEVARD                             SAN LEANDRO    CA          94577
          Certified             995  CENTER FOR TRIBOLOGY INC                1711 DELL AVENUE                                  CAMPBELL       CA          95008
          Certified             994  APN SOFTWARE SERVICES INC.              39899 BALENTINE DRIVE, #385                       NEWARK         CA          4456
          Certified             993  GE CAPITAL CORPORATION                  60 LONG RIDGE RD                                  STAMFORD       CT          69271
          Certified             993  GRANITE PROF SERVICES GE                60 LONG RIDGE RD                                  STAMFORD       CT          6927

Note: Values in green are certified values that appear to be incorrect.
      Values in red are non-certified values that appear to be incorrect.
      Values in blue appear to be incomplete or possibly incorrect.
Sources: Foreign Labor Certification Data Center (2001-2007); U.S. Department of Labor:
         Spreadsheet for 2008, 2009, 2009 (continued), 2010, 2011, 2012, 2013

DATA ERRORS

As can be seen, the Labor Condition Applications contained a number of data errors. The above table shows many of those which occurred in the applications requesting the most total workers. Following are some of the basic types:

TOTAL_WORKERS: From 2010 to 2013, there were 16 applications which requested more than 2,000 total workers. In fact, the four lowest were equal to one less than the year of the application suggesting that they were errors possibly aided by the layout of the application. The next lowest request was 5,464 (which was VOIDED) and the other 11 were all over 43,000 each. All 16 requests were obvious errors and 14 were denied, one was withdrawn, and one was voided. Because these total worker numbers would distort the graph and table showing worker positions by status, they were counted as zero in those items. However, the applications themselves were still counted in the graph and table showing the number of applications.

It should be noted that many application did request just under 1,000 worker positions. I would assume that requests of 999 and slightly less often served as placeholders when large numbers of positions were desired but the exact number was unknown. The relatively large number of such requests in 2001 caused the total number of work positions to be over 1.6 million.

Errors in Employer Name and Address in Denied Applications: As can be seen in denied applications above, errors in the Employer Address can be seen from 2005 through 2009 and errors in the Employer Name can be seen in 2007 and 2008. These errors may have contributed to their denial.

Errors in Employer Name and Address in Certified Applications: As can be seen in certified applications above, errors in the Employer Name and Address can be seen from 2006 through 2008. These are perhaps the most disturbing errors as they may represent invalid applications which were certified. The only other possibility that I can think of is that some of them may be test data which was not properly removed. This would also be troubling.

Miscellaneous Errors: The data in blue font above represent other errors ranging from possibly missing street numbers to data that appears to be in the wrong columns (at the start of 2003 and 2004). Another minor error was that file H1B_FY05_Efile.txt in the zip file at http://www.flcdatacenter.com/download/H1B_fax_FY2005_text.zip was missing a header.

Other Errors: The data in red font in the following tables represent errors found in certified applications. Notes on the specific errors are following each table.


CERTIFIED APPLICATIONS CONTAINING ERRONEOUS INPUT FOR WORK LOCATION CITY

(for state other than the employer state)

 TOTAL_                                                                      POSTAL
WORKERS  LCA_CASE_EMPLOYER_NAME                     EMPLOYER_CITY     STATE  _CODE   LCA_CASE_WORKLOC1_CITY        STATE  STATUS     YEAR
-------  -----------------------------------------  ----------------  -----  -----   ----------------------------  -----  ---------  ----
     30  PATNI AMERICAS INC.                        CAMBRIDGE         MA     02142   1 LILLEHEI PLZ                MN     CERTIFIED  2013
      1  EVEREST CONSULTING GROUP, INC              EDISON            NJ     08820   101 EAST  GAINES ST.          FL
      1  DVR SOFTEK, INC                            EDISON            NJ     08817   110 FRANKLIN ROAD SOUTHEAST   VA
      1  MITCHELL/MARTIN, INC.                      NEW YORK          NJ     10018   1111 POLARIS PARKWAY,         OH
      1  SAGE GROUP CONSULTING, INC.                HAZLET            NJ     07730   1201 SOUTH 2ND STREET         WI
      1  ASTIR IT SOLUTIONS INC.                    SOUTH PLAINFIELD  NJ     07080   1380 EMERYVILLE               CA
      1  MINDLANCE, INC.                            HOBOKEN           NJ     07030   2 HANSON PLAZA, EIGHTH FLOOR  NY
      1  AMZUR TECHNOLOGIES, INC                    TAMPA             FL     33602   219 EAST 42ND STREET          NY
      1  LOGIC BRIDGE INC.                          FARMINGTON HILLS  MI     48335   225 LIBERTY STREET            NY
     10  GUARDIAN HEALTHCARE PROVIDERS, INC.        BRENTWOOD         TN     37027   2530 GREENHILL ROAD           TX
      1  3I INFOTECH, INC                           EDISON            NJ     08837   2702 LOVE FIELD DRIVE         TX
      1  ALLTECH CONSULTING SERVICES INC            PRINCETON         NJ     08540   27TH FLOOR                    NY
      1  EQUITY GUARD LLC                           HOUSTON           TX     77072   3850 DEPAUW BOULEVARD         IN
      1  SUPERNOVA INFOTECHNOLOGIES, INC            FORT LEE          NJ     07024   450 NEWPORT CENTER DRIVE      CA
      1  MINDLANCE, INC.                            HOBOKEN           NJ     07030   5775 MOREHOUSE DRIVE          CA
      1  GLOBAL TEACHERS RESEARCH & RESOURCES, INC  MORROW            GA     30260   600 PARKWAY AVE               MS
      1  TENAZX INC.                                TARRYTOWN         NY     10591   600 WASHINGTON BLVD           CT
      1  SEVEN SEAS TECHNOLOGIES, INC.              CHESTERFIELD      MO     63005   666 GRAND AVE.                IA
      1  SAGE GROUP CONSULTING, INC.                HAZLET            NJ     07730   701 SW 158TH AVE              OR
      1  INDU, LLC                                  DULUTH            GA     30097   7668 WARREN PARKWAY           TX
      1  BAHA INDUSTRIES CORP.                      NEW YORK          NY     10018   95 GREEN STREET               NJ
      1  R3 TECHNOLOGY, INC                         EDISON            NJ     08817   SUITE 150                     FL
      1  ULAB INC                                   CARY              NC     27511   SUITE 210                     VA
      1  NEXAGE TECHNOLOGIES, USA, INC              ISELIN            NJ     08830   SUITE 102                     CA
      1  ASPEN INSURANCE US SERVICES, INC.          ROCKY HILL        CT     06067   SUITE 840                     FL
      1  3I INFOTECH, INC                           EDISON            NJ     08837   SUITE 1                       MA
      1  VIRTUE GROUP, LLC                          ALPHARETTA        GA     30022   SUITE 1500                    AL
      1  RD DATA SOLUTIONS, LLC                     LEWISVILLE        TX     75056   SUITE 800                     CA

Note: The above table lists certified applications in 2013 for which LCA_CASE_WORKLOC1_CITY was set to an apparent address
      (in red) instead of the work location city as requested.  In addition, the work location state was different in these
      cases than the employer city.  Hence, there is no apparent way to determine the work location city, a critical item
      in validating an application.  For that reason, it would appear that these applications may not have been processed
      properly.
Sources: U.S. Department of Labor, Spreadsheet for 2013

CERTIFIED APPLICATIONS CONTAINING HIGHEST WAGE_RATE_FROM TO PREVAILING WAGE MULTIPLES

(all applications were for a single worker)
                                                                                            LCA_CASE_   PREVAILING     WAGE
LCA_CASE_EMPLOYER_NAME                          LCA_CASE_JOB_TITLE                     WAGE_RATE_FROM       WAGE_1   / PW_1  STATUS     YEAR
----------------------------------------------  -------------------------------------  --------------  -----------  -------  ---------  ----
WYSE TECHNOLOGY, INC.                           PRODUCT CONSULTANT                         11,404,057       84,344    135.2  CERTIFIED  2013
COMMUNITY HEALTH SERVICES, INC.                 STAFF DENTIST                              15,500,004      136,864    113.3
EVEREST CONSULTING GROUP, INC                   BUSINESS ANALYST                            6,500,000       58,136    111.8
ESYSTEMS, INC.                                  PROGRAMMER ANALYST                          5,600,000       53,914    103.9
COWEN AND COMPANY, LLC                          FINANCIAL MATHEMATICIAN (VP)                1,250,000       77,522     16.1
THE UNIVERISTY OF SOUTHERN MISSISIPPI           ASSISTANT PROFESSOR                           580,000       36,480     15.9
WEST VIRGINIA UNIVERSITY                        ASSISTANT PROFESSOR                           473,282       30,877     15.3
HARTFORD PUBLIC SCHOOLS                         MATH TEACHER                                  701,199       45,820     15.3
THINKBRQ                                        PROGRAMMER ANALYST                            900,000       59,550     15.1
TEXAS TECH UNIVERSITY HEALTH SCIENCES CENTER    ASSOCIATE PROFESSOR                           350,000       23,300     15.0
JPMORGAN CHASE & CO.                            ASSOCIATE, ENGINEER                         1,000,000       66,581     15.0
BAKER & MCKENZIE PC                             CHAIRMAN OF THE EXECUTIVE COMMITTEE         3,150,000      216,549     14.5
MODULAR MINING SYSTEMS, INC.                    PROJECT ENGINEER                              740,888       51,189     14.5
TEXAS TECH UNIVERSITY HEALTH SCIENCES CENTER    ASSISTANT PROFESSOR - NEUROSURGERY            350,000       24,860     14.1
TEXAS TECH UNIVERSITY HEALTH SCIENCES CENTER    ASSISTANT PROFESSOR- NEUROSURGERY             350,000       24,860     14.1
TATA CONSULTANCY SERVICES LIMITED               DATABASE ADMINISTRATOR                        607,000       43,555     13.9
KPI PARTNERS, INC.                              SENIOR SOFTWARE ENGINEER                    1,400,000      101,462     13.8
ESOLUTIONS AMERICA, INC.                        PROGRAMMER ANALYST                            868,500       67,371     12.9
HUGHES HUBBARD & REED LLP                       ATTORNEY                                    2,400,000      188,053     12.8
CAMERON COMPRESSION SYSTEMS                     ENGINEER (AERO)                               673,000       52,770     12.8
314E CORPORATION                                EPIC SPECIALIST                               800,000       62,733     12.8
HULU, LLC                                       SOFTWARE DEVELOPER                          1,400,000      109,970     12.7
SMARTADVOCATE LLC                               DATABASE ADMINISTRATOR/ DEVELOPER             897,610       71,219     12.6
SETI INSTITUTE                                  RESEARCH SCIENTIST                            954,000       76,461     12.5
DELOITTE & TOUCHE LLP                           AUDIT ASSISTANT                               570,000       45,739     12.5
M-I LLC AKA M-I SWACO                           MANAGER PROJECT I                             890,004       72,592     12.3
SPARTA CONSULTING INC.                          PRINCIPAL CONSULTANT                        1,116,000       91,520     12.2
KALVEN TECHNOLOGIES INC                         BUSINESS SYSTEMS ANALYST                      575,000       47,216     12.2
ANU SOFTWARE CONSULTANTS, INC.                  COMPUTER SYSTEMS ANALYST                      700,000       57,554     12.2
THE PENNSYLVANIA STATE UNIVERSITY               ASSISTANT PROFESSOR                           670,320       55,170     12.2
AIR WORLDWIDE CORPORATION                       RISK ANALYST                                  612,000       50,898     12.0
ESALON.COM LLC                                  DIRECTOR OF SALES & MARKETING                 195,000       16,261     12.0
STATE STREET BANK AND TRUST COMPANY             SENIOR ASSOCIATE GLOBAL MARKETS PDP           600,000       50,710     11.8
NXTECH INCORPORATED                             SOFTWARE DEVELOPER                            650,000       55,390     11.7
FROSTBURG STATE UNIVERSITY                      COMPUTER SCIENCE TEACHER POST SECONDARY       690,000       58,820     11.7
HUGHES HUBBARD & REED LLP                       ATTORNEY                                    2,400,000      207,106     11.6
USM BUSINESS SYSTEMS, INC.                      JAVA DEVELOPER                                750,000       65,000     11.5
WEST VIRGINIA UNIVERSITY                        ASSISTANT PROFESSOR                           473,282       42,123     11.2
ALIASWIRE, INC.                                 SOFTWARE ENGINEER                             960,000       85,446     11.2
SOUTHWEST MISSISSIPPI REGIONAL MEDICAL CENTER   INTERVENTIONAL CARDIOLOGIST (PHYSICIAN)       575,000       51,376     11.2
JUMPTAP, INC.                                   SOFTWARE ENGINEER                             800,000       72,093     11.1
DININGIN.COM                                    DIRECTOR OF FINANCE & PLANNING                800,000       73,070     10.9
NOKIA SIEMENS NETWORKS US LLC                   3G RADIO ACCESS NETWORK ENGINEER              875,947.75    80,700     10.9
BLUEWATER FUNDING LLC                           STAFF ACCOUNTANT                              550,000       50,710     10.8
MALVERN INSTRUMENTS, INC.                       SENIOR PRODUCT DEVELOMENT ENGINEER            800,000       73,986     10.8
HILL-ROM MANUFACTURING, INC.                    SENIOR COMMODITY SPECIALIST                   961,115       88,899     10.8
WEST VIRGINIA UNIVERSITY                        ASSISTANT PROFESSOR                           291,863       27,090     10.8
AIR WORLDWIDE CORP.                             SOFTWARE ENGINEER III                         915,000       85,446     10.7
DANA-FARBER CANCER INSTITUTE                    RESEARCHER (GRADUATE STUDENT)                 322,616       30,326     10.6
COALITION FOR THE HOMELESS                      SOCIAL SERVICES SUPERVISOR, FIRST STEP PROG/  465,000       44,075     10.6
TWIN CITIES GERMAN IMMERSION SCHOOL             IMMERSION TEACHER                             310,000       29,423     10.5
CENTAURUS PROPERTY MANAGEMENT, LLC              STAFF ACCOUNTANT                              420,000       39,957     10.5
MICROEXCEL, INC                                 PROGRAMMER ANALYST                            600,000       57,595     10.4
GROUPM WORLDWIDE INC. - MINDSHARE WORLDWIDE     MANAGER, MEDIA SUPERVISOR                     625,000       60,445     10.3
TEXAS TECH UNIVERSITY HEALTH SCIENCES CENTER    ASSISTANT PROFESSOR (RADIOLOGY)               275,000       26,740     10.3
BAPTIST MEMORIAL HEALTHCARE - TIPTON            MEDICAL SCIENTISTS, EXCEPT EPIDEMIOLOGISTS    520,000       51,085     10.2
NETRONOME SYSTEMS, INC.                         SILICON DESIGN ENGINEER                       900,000       88,712     10.1
AKVELON, INC.                                   SOFTWARE ENGINEER                             740,000       73,112     10.1
MAYO CLINIC                                     CLINICAL RESIDENT                             606,626       59,970     10.1
CONSILIUM1                                      SOFTWARE ENGINEER                             870,000       86,258     10.1
REPORTGRID, INC. D/B/A PRECOG                   SENIOR INFRASTRUCTURE ENGINEER              1,000,000       99,174     10.1
EMBEDUR SYSTEMS, INC                            COMPUTER PRGROAMMER                           630,000       62,546     10.1
FUSION SOLUTIONS, LLC                           FIELD INTERGRATION ENGINEER                   468,000       46,488     10.1
FORMULA PR INC.                                 PUBLIC RELATIONS SPECIALIST                   415,000       41,371     10.0
CWMA NEVADA LLC IT                              SOFTWARE ENGINEER                             695,000       69,347     10.0
PRICOL TECHNOLOGIES, INC.                       EMBEDDED SOFTWARE ENGINEER                    787,800       78,707     10.0
UNIVERSITY OF CHICAGO-BOOTH SCHOOL OF BUSINESS  ASSOCIATE PROFESSOR                           225,000       24,270      9.3
CHATTANOOGA-HAMILTON COUNTY HOSPITAL AUTHORITY  PULMONARY, CRITICAL CARE & SLEEP MEDICINE/    350,000       39,874      8.8
CINCINNATI CHILDREN'S HOSPITAL MEDICAL CENTER   CLINICAL ASSISTANT PROFESSOR                  264,555       30,389      8.7
THE UNIVERSITY OF TEXAS AT AUSTIN               PROFESSOR                                     240,000       27,690      8.7
VANDERBILT UNIVERSITY                           ASSISTANT PROFESSOR                           210,000       24,290      8.6
SOUTHERN CROSS GROUP, LLC                       FINANCIAL ANALYST                             400,000       47,382      8.4
FLORIDA JOINT AND SPINE INSTITUTE               SPINE SURGEON                                 600,000       71,323      8.4
UNIVERSITY OF UTAH                              ASSOCIATE PROFESSOR                           420,619       51,077      8.2
UNIVERSITY OF CHICAGO-BOOTH SCHOOL OF BUSINESS  ASSISTANT PROFESSOR                           204,000       25,160      8.1
CINCINNATI CHILDREN'S HOSPITAL MEDICAL CENTER   CLINICAL ASSISTANT PROFESSOR                  342,076       42,827      8.0
TEXAS TECH UNIVERSITY HEALTH SCIENCES CENTER    ASSISTANT PROFESSOR                           185,000       23,300      7.9
TEXAS TECH UNIVERSITY HEALTH SCIENCES CENTER    ASSISTANT PROFESSOR                           185,000       23,300      7.9
CINCINNATI CHILDREN'S HOSPITAL MEDICAL CENTER   CLINICAL ASSOCIATE PROFESSOR                  400,000       50,898      7.9
  :                                               :                                             :            :            :
MOUNT CARMEL SCHOOL, INC.                       STUDENT SERVICES OFFICER                       17,000       17,000      1.0
APPLE INC.                                      PROCUREMENT ANALYST                           108,888      108,888.88   0.99999
VIGILANT TECHNOLOGIES LLC                       ORACLE APPLICATION DEVELOPER                   76,831       77,000      0.99781
EASTON COUNTRY DAY SCHOOL                       MUSIC TEACHER                                  32,000       32,530      0.98371
MOLOKAI OHANA HEALTH CARE INC                   PHYSICIAN                                     110,000      128,357      0.85698

Note: The above table lists certified applications in 2013 for which the ratio of the starting wage rate to the reported
      prevailing wage was greater than 7.9.  It would appear that the starting wage rate and/or the prevailing wage are
      in error in these applications.  The job title is also listed to help determine which of the two is most likely in
      error.  It would appear that it is the starting wage rate that is in error in the most, if not all, of the applications.

      Also listed are those certified applications with the lowest ratios.  As can be seen, only 4 were less than one
      (indicating a starting wage rate less than the prevailing wage) and all were fairly close to one.  This would
      suggest the possibility that the applications were checked for too low of a starting wage rate but not for one
      that was so high as to be an obvious error.  Hence, it would appear that these applications may not have been
      processed properly.
Sources: U.S. Department of Labor, Spreadsheet for 2013

ANALYZING LARGE DATA FILES USING EXCEL 2010

STEPS TO REPRODUCE THE TOTAL_WORKERS COUNTS AND SUMS PER STATUS
  1. Open the original spreadsheet file (for example, LCA_FY2013.xlsx)
  2. Click "Enable Editing" button at top
  3. Highlight all data cells (e.g., A1:AI442276)
  4. Click Insert, then Pivot Table
  5. Leave the default for "Table/Range", leave "New Worksheet" checked, and click OK
  6. Switch to the newly-created pivot table tab
  7. Drag STATUS into Row Labels
  8. Drag TOTAL_WORKERS into Values
  9. If necessary, change to "Count of TOTAL_WORKERS" by clicking on it, selecting "Value Field Setting...", then "Count"
  10. Drag TOTAL_WORKERS into Values
  11. If necessary, change to "Sum of TOTAL_WORKERS" by clicking on it, selecting "Value Field Setting...", then "Sum"
  12. If necessary, repeat for second file (for 2002-2006 and 2009) and add those numbers
  13. Subtract the 16 invalid values of TOTAL_WORKERS (those greater than 2,000) from the appropriate totals.
  14. The resultant values should be equal to those in the table.
STEPS TO DETERMINE THE HIGHEST NUMBER OF TOTAL_WORKERS
  1. Place cursor in TOTAL_WORKERS column.
  2. Select Data tab and click on the descending sort icon (down arrow to the right of a Z above an A).
  3. Select any columns that you don't want to see, right-click and click on Hide.
STEPS TO FIND CERTIFIED APPLICATIONS WITH ERRONEOUS VALUES FOR LCA_CASE_WORKLOC1_CITY
  1. Select Data tab and click on Filter icon (the funnel).
  2. Verify that each column header now contains a filter arrow on the right. If missing, deselect and reselect the filter.
  3. Click the filter arrow for STATUS and click (Select All) to clear all of the checkboxes.
  4. Check the box next to CERTIFIED and click OK.
  5. Click the filter arrow for LCA_CASE_WORKLOC1_CITY and click (Select All) to clear all of the checkboxes.
  6. Check the box next to all values that look erroneous (like those that begin with a number or "SUITE") and click OK.
  7. Select any columns that you don't want to see, right-click and click on Hide.
  8. Manually compare the employer state and the work location state to find those that differ, if desired.
STEPS TO FIND CERTIFIED APPLICATIONS WITH HIGHEST WAGE_RATE_FROM TO PREVAILING WAGE MULTIPLES
  1. Select Data tab and click on Filter icon (the funnel).
  2. Verify that each column header now contains a filter arrow on the right. If missing, deselect and reselect the filter.
  3. Click the filter arrow for STATUS and click (Select All) to clear all of the checkboxes.
  4. Check the box next to CERTIFIED and click OK.
  5. Click the filter arrow for LCA_CASE_WAGE_RATE_UNIT and click (Select All) to clear all of the checkboxes.
  6. Check the box next to Year and click OK.
  7. Click the filter arrow for PW_UNIT_1 and click (Select All) to clear all of the checkboxes.
  8. Check the box next to Year and click OK.
  9. In the first empty column on the right, enter the formula of that row's LCA_CASE_WAGE_RATE_FROM divided PW_1 (e.g. =P417/W417).
  10. Place cursor in the newly created column.
  11. Select Data tab and click on the descending sort icon (down arrow to the right of a Z above an A).
  12. Select any columns that you don't want to see, right-click and click on Hide.

Information on H-1B Visas
Commentary on the Skills Gap
Go to Budget Home Page