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
A T KEARNEY INC (Chicago, IL)
Job Title: Associate
Wage Rate: $158,000.00
Employer Business Identification
Employer Name
A T KEARNEY INC
Fiscar Year
2020
Case Status
Certified
Case Number
A-19360-99846
Received Date
1/16/20
2007 NAICS US Code
541611
Job Title
Associate
Country of Citizenship
CHINA
Prevailing Wage Information
SOC Code
13-1111
Level
Level III
Wage Rate
96304.0
SOC Title
Management Analysts
Source
OES
Wage Rate & Work Location
Wage Rate
$158,000.00 to 167,000.00 per year
City
Chicago
State
IL
Contact & Attorney Information
Attorney Firm Name
Berry Appleman Leiden LLP
Attorney Name
Bilal B Sultan
Attorney Location
Richardson, TEXAS
Others
Decision Date
5/18/20
Refile
N
Scheduled A Sheepherder
N
Employer Phone
312-648-0111
Employer Number of Employees
883
Employer Year of Commenced Business
1926
FW Ownership Interest
N
Employer Contact Name
Danielle Bartlett
Employer Contact Address 1
227 WEST MONROE STREET
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Postal Code
60606
Employer Contact Phone
(312) 2236679
Employer Contact Email
[email protected]
Agent Attorney Phone
9727296185
Agent Attorney Email
[email protected]
Prevailing Wage Tracking Number
P10019135477263
Prevailing Wage Determination Date
8/28/19
Prevailing Wage Expiration Date
6/30/20
Minimum Education
Master's
Major Field Of Study
Business Administration, Economics, Engineering, or related field
Required Training
N
Required Expirence Months
24
Required Expirence
Y
Acceptable Alternate Field Of Study
N
Acceptable Alternate Combination
Y
Acceptable Alternate Level of Education
Bachelor's
Acceptable Alternate Education Years
5
Foreign Education Acceptable
Y
Alternate Occupation Experience Acceptable
Y
Alternate Occupation Experience Months
24
Alternate Occupation Job Title
See H.14.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Masters degree in Business Administration, Economics, Engineering, or related field, and 2 years of industry experience, in the position offered or related capacityies. Alternatively, will accept a Bachelors degree in Business Administration, Economics, Engineering, or related field, followed by 5 years of related progressive experience in the position offered or related capacityies.br br Position requiresbr br 1. Two years of experience in developing multiterabyte, enterprise level Microsoft SQL databases in a team working environment.br 2. Two years of experience with developing stored procedures in SQL Server 2016 Database Engine SSMS, writing scripts in SQL Server R Service R Service, creating SQL jobs in SQL Server Agent Components, and building packages in SQL Server Integration Service SSIS.br 3. Two years of experience in database administration, maintenance, disaster recovery, and performance tuning;br 4. Two years of experience using Tableau to analyze data and build reports;br 5. Two years of experience in performing predictive analysis or forecasting with the machine learning algorithms;br 6. Two years of experience in the financialservice industry for example banking, insurance or mortgage companies;br 7. Two years of experience functioning as a liaison between business units and information technology department, with proven experience presenting to VP or higher level leadership audience.br br Headquarters of U.S. is in Chicago, IL with extensive travel andor possible relocation in unanticipated locations throughout the U.S.
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
9/6/19
SWA Job Order End Date
10/6/19
Sunday Edition News Paper
Y
First News Paper Name
The Chicago Tribune
First Advertisement Start Date
9/22/19
Second News Paper Ad Name
The Chicago Tribune
Second Advertisement Type
Newspaper
Second Ad Start Date
9/29/19
Professional Organization Ad From Date
12/11/19
Professional Organization Ad To Date
12/18/19
Job Search Website From Date
9/23/19
Job Search Webiste To Date
9/27/19
Local Ethnic Paper From Date
9/25/19
Local Ethnic Paper To Date
9/25/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
CHINA
Class Of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker INFO Major
BUSINESS ADMINISTRATION
Foreign Worker Education Completed
2018
Foreign Worker Educational Institution
THE UNIVERSITY OF MICHIGAN
Foreign Worker Educational Institution Address 1
500 S STATE STREET
Foreign Worker Educational Institution City
ANN ARBOR
Foreign Worker Educational Institution State
MI
Foreign Worker Educational Institution Country
UNITED STATES OF AMERICA
Foreign Worker Educational Institution Postal Code
48109
Foreign Worker Training Completed
N/A
Foreign Worker Has Required Work Experience
N
Foreign Worker Alternate Education/Experience
N
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
Bilal B Sultan
Preparer Email
[email protected]
Name Of Person Signing Employer Declaration
Danielle Bartlett
Title of Person Signing Employer Declaration
HR Operations and Immigration Specialist

Insurance