For visitors, travel, student and other international travel medical insurance.

Visit insubuy.com or call +1 (866) INSUBUY or +1 (972) 985-4400

Greencard Sponsors

Greencard Sponsors Case Details

Certified-Expired
AON CONSULTING INC (Chicago, IL)
Job Title: H&B Consultant II
Wage Rate: $105,269.00
Employer Business Identification
Employer Name
AON CONSULTING INC
Fiscar Year
2020
Case Status
Certified-Expired
Case Number
A-19246-52414
Received Date
9/27/19
2007 NAICS US Code
524210
Job Title
H&B Consultant II
Country of Citizenship
INDIA
Prevailing Wage Information
SOC Code
15-1121
Level
Level IV
Wage Rate
105269.0
SOC Title
Computer Systems Analysts
Source
OES
Wage Rate & Work Location
Wage Rate
$105,269.00 per year
City
Chicago
State
IL
Contact & Attorney Information
Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Attorney Name
Jenny Nieves
Attorney Location
New York, NEW YORK
Others
Decision Date
1/3/20
Refile
N
Scheduled A Sheepherder
N
Employer Phone
312-381-1000
Employer Number of Employees
50000
Employer Year of Commenced Business
1988
FW Ownership Interest
N
Employer Contact Name
Elizabeth McAdams
Employer Contact Address 1
200 East Randolph Street
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Postal Code
60601
Employer Contact Phone
312-381-4979
Employer Contact Email
[email protected]
Agent Attorney Phone
2122302877
Agent Attorney Email
[email protected]
Prevailing Wage Tracking Number
P10018254952268
Prevailing Wage Determination Date
1/15/19
Prevailing Wage Expiration Date
6/30/19
Minimum Education
Master's
Major Field Of Study
Computer Science, Information Technology, Engineering any or related field
Required Training
N
Required Expirence
N
Acceptable Alternate Field Of Study
N
Acceptable Alternate Combination
Y
Acceptable Alternate Level of Education
Bachelor's
Acceptable Alternate Education Years
7
Foreign Education Acceptable
Y
Alternate Occupation Experience Acceptable
Y
Alternate Occupation Experience Months
48
Alternate Occupation Job Title
Experience in a technical role.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Must have experience with 1 advanced SQL programming; 2 database design and optimization; 3 project management; 4 health care data, such as medical and prescription claims and health risk appraisals; 5 ETL extraction, Transformation, Loading processing; 6 employee benefits plan designs; and 7 building MS Excel or MS Access modelstoolsprocesses. Employer will accept any amount of professional experience with the required skills.br br br All positions require an applicant who has accepted an offer to undergo a background check.
Combination of Occupations
N
Offered To Foreign Worker
Y
Foreign Worker live in Employer Premises
N
Live-in Domestic Service Worker
N
Professional Occupation
Y
College or University Teacher
N
SWA Job Order Start Date
6/19/19
SWA Job Order End Date
7/20/19
Sunday Edition News Paper
Y
First News Paper Name
Chicago Tribune
First Advertisement Start Date
6/23/19
Second News Paper Ad Name
Chicago Tribune
Second Advertisement Type
Newspaper
Second Ad Start Date
6/30/19
Job Search Website From Date
6/24/19
Job Search Webiste To Date
7/1/19
Employee Referral Program From Date
6/20/19
Employee Referral Program To Date
7/9/19
Local Ethnic Paper From Date
6/26/19
Local Ethnic Paper To Date
6/26/19
Employer Received Payment
N
Bargaining Representative Notified
N/A
Posted Notice At Worksite
Y
Layoff In Past Six Months
N
Foreign Worker Birth Country
INDIA
Class Of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker INFO Major
STRATFORD UNIVERSITY
Foreign Worker Education Completed
2011
Foreign Worker Educational Institution
SOFTWARE ENGINEERING
Foreign Worker Educational Institution Address 1
7777 LEESBURG PIKE
Foreign Worker Educational Institution City
FALLS CHURCH
Foreign Worker Educational Institution State
VA
Foreign Worker Educational Institution Country
UNITED STATES OF AMERICA
Foreign Worker Educational Institution Postal Code
22043
Foreign Worker Training Completed
N/A
Foreign Worker Has Required Work Experience
N/A
Foreign Worker Alternate Education/Experience
N/A
Foreign Worker Has Experience in Alternate Occupation
Y
Foreign Worker Experience With Employer
N
Employer Paid For Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Jenny Nieves
Preparer Email
[email protected]
Name Of Person Signing Employer Declaration
Elizabeth McAdams
Title of Person Signing Employer Declaration
Senior Manager, Global Immigration

Insurance