All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21197-18710
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21197-18710
Case Status
Certified-Expired
Received Date
2021-07-28
Decision Date
2021-12-27
Refile
N
Original File Date
2022-01-01 10:40:50
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
MCKINSEY COMPANY, INC UNITED STATES
Employer Name Slug
mckinsey-company-inc-united-states
Employer Address 1
711 3RD AVENUE
Employer Address 2
4TH FLOOR
Employer City
NEW YORK
Employer City Slug
new-york
Employer State
NEW YORK
Employer State Slug
new-york
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
10017
Employer Phone
212-446-7000
Employer Number of Employees
9000
Employer Year Commenced Business
1926
NAICS Code
54161
FW Ownership Interest
N
Employer Contact Name
Michael Scherban
Employer Contact Address 1
711 3rd Avenue
Employer Contact Address 2
4th Floor
Employer Contact City
New York
Employer Contact State/Province
NEW YORK
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
10017
Employer Contact Phone
212-415-1439
Employer Contact Email
michael_scherban@mckinsey.com
Agent Attorney Name
Nishita S Desai
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Agent Attorney Phone
6468616942
Agent Attorney Address 1
1400 Broadway
Agent Attorney Address 2
9th FL
Agent Attorney City
New York
Agent Attorney State/Province
NEW YORK
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
10018
Agent Attorney Email
McKinseyIV@Fragomen.com
PW Track Number
P10020216748640
PW SOC Code
15-1199
PW SOC Title
Data Warehousing Specialists
PW Skill Level
Level III
PW Wage
94453.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-03-04
PW Expiration Date
2021-06-30
Wage Offer From
118200.00
Wage Offer To
0.00
Average Salary
118200.00
Wage Unit of Pay
Year
Worksite Address 1
McKinsey Company, Inc. US
Worksite Address 2
3111 Clairmont Road, Suite A
Worksite City
Atlanta
Worksite City Slug
atlanta
Worksite State
GEORGIA
Worksite Postal Code
30329
Job Title
Senior Engineer
Job Title Slug
senior-engineer
Minimum Education
Master's
Major Field of Study
See H.14 below
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
See H.14 below
Accept Alternative Combination
N
Accept Alternative Combination Education
Accept Alternative Combination Education Years
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
24
Accept Alternative Job Title
See H.14 below
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
MASTERS DEGREE IN MANAGEMENT INFORMATION SYSTEMS, INFORMATION TECHNOLOGY, COMPUTER SYSTEMS, OR RELATED QUANTITATIVE DISCIPLINE.br br MINIMUM OF TWO 2 YEARS OF PROGRESSIVE EXPERIENCE AS SYSTEMS ENGINEER, OR RELATED OCCUPATION. EXPERIENCE MUST HAVE INCLUDED DATA WAREHOUSING; DECISION SUPPORT SYSTEMS; BUSINESS SYSTEMS ANALYSIS; BUSINESS INTELLIGENCE ANALYSIS; WAREHOUSE DATAMART DESIGN AND DEPLOYMENT; ETL TOOLS INFORMATICA, ALTERYX; SQL AND PLSQL; ORACLE; ETL SCHEDULING TOOL AUTOSYS; CREATING AND CUSTOMIZING REPORTS AS WELL AS DASHBOARDS USING TOOLS LIKE BUSINESS OBJECTS, TIBCO SPOTFIRE; UNIX SCRIPTING.
Combination Occupation
N
Offered to Applicant Foreign Worker
Y
Foreign Worker Live on Premises
N
Foreign Worker Live in Domestic Service
N
Foreign Worker Live in Domestic Service Count
Professional Occupation
Y
Application for College/University Teacher
N
SWA Job Order Start Date
2021-04-20
SWA Job Order End Date
2021-05-25
Sunday Edition Newspaper
Y
First Newspaper Name
The Atlanta JournalConstitution
First Advertisement Start Date
2021-05-02
Second Newspaper Ad Name
The Atlanta JournalConstitution
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-05-09
Employer Website From Date
2022-01-01 10:40:50
Employer Website To Date
2022-01-01 10:40:50
Professional Organization Ad From Date
2022-01-01 10:40:50
Professional Organization Advertisement To Date
2022-01-01 10:40:50
Job Search Website From Date
2021-05-03
Job Search Website To Date
2021-05-17
Employee Referral Program From Date
2021-04-29
Employee Referral Program To Date
2021-05-13
Local Ethnic Paper From Date
2021-05-07
Local Ethnic Paper To Date
2021-05-13
Radio/TV Ad From Date
2022-01-01 10:40:50
Radio/TV Ad To Date
2022-01-01 10:40:50
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker Information: Major
MANAGEMENT INFORMATION SYSTEMS
Foreign Worker Years of Education Completed
2016
Foreign Worker Institution of Education
UNIVERSITY OF ILLINOIS AT CHICAGO
Foreign Worker Education Institution Address 1
1200 W HARRISON ST
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
CHICAGO
Foreign Worker Education Institution State/Province
IL
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
60607
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Nishita S Desai
Preparer Title
Attorney
Preparer Email
McKinseyIV@fragomen.com
Employer Information Declaration Name
Michael A Scherban
Employer Information Declaration Title
Managing Counsel, ImmigrationUS