All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20265-01970
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-20265-01970
Case Status
Denied
Received Date
2021-01-15
Decision Date
2021-11-29
Refile
N
Original File Date
2022-01-01 10:30:32
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
JP MORGAN CHASE CO
Employer Name Slug
jp-morgan-chase-co
Employer Address 1
10 SOUTH DEARBORN STREET
Employer Address 2
Employer City
CHICAGO
Employer City Slug
chicago
Employer State
ILLINOIS
Employer State Slug
illinois
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
60603
Employer Phone
312-732-2655
Employer Number of Employees
167269
Employer Year Commenced Business
1799
NAICS Code
551112
FW Ownership Interest
N
Employer Contact Name
Jennifer R Shapiro
Employer Contact Address 1
10 South Dearborn Street
Employer Contact Address 2
IL10801
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
60603
Employer Contact Phone
312-732-2655
Employer Contact Email
jennifer.r.shapiro@jpmchase.com
Agent Attorney Name
Peter B Bade
Agent Attorney Firm Name
Berry Appleman Leiden LLP
Agent Attorney Phone
469-290-9302
Agent Attorney Address 1
100 Pringle Avenue
Agent Attorney Address 2
Suite 300
Agent Attorney City
Walnut Creek
Agent Attorney State/Province
CALIFORNIA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
94596
Agent Attorney Email
pbade@balglobal.com
PW Track Number
P10020204728067
PW SOC Code
15-2041
PW SOC Title
Statisticians
PW Skill Level
Level II
PW Wage
84698.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-12-23
PW Expiration Date
2021-06-30
Wage Offer From
134000.00
Wage Offer To
0.00
Average Salary
134000.00
Wage Unit of Pay
Year
Worksite Address 1
8181 Communications Pkwy.
Worksite Address 2
Worksite City
Plano
Worksite City Slug
plano
Worksite State
TEXAS
Worksite Postal Code
75024
Job Title
Vice President, Business Management
Job Title Slug
vice-president-business-management
Minimum Education
Master's
Major Field of Study
See H.14
Required Training
N
Required Experience
Y
Required Experience Months
84
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
See H.14
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
84
Accept Alternative Job Title
Business analysisrelated occupation
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Employer will accept Masters degree in Computer Science, Statistics, Mathematics, Engineering, Management Information Systems, or related technical field, and 7 years of work experience in job offered or in a business analysisrelated occupation.br br Position requiresbr br 1. Relational databases and concepts, including Primaryforeign keys, domainsconstraints, indicies, and stored procedures;br 2. Utilizing SQL queries, SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services;br 3. Utilizing SQLlike queries for Hadoop environmentsbr 4. Creating and maintaining executivelevel dashboards and reports using Tableau and Qlikview software;br 5. Designing, developing, testingQA, and implementing software applications and systems;br 6. Managing database objects, schemas, tables, stored procedures, and ETL scripts, including analyzing and optimizing query performance, performing periodic health checks on database servers and data appliances, and proactively tuning systems for performance and stability;br 7. Agile project management methodologies;br 8. Utilizing data mining, data modeling, and data analysis to develop complex business analysis models and deliver senior managerlevel reporting;br 9. Loan accounting, creditcollateral systems; and,br 10. Objectoriented technologies, as well as algorithm development and implementation.
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
2020-08-05
SWA Job Order End Date
2020-09-06
Sunday Edition Newspaper
Y
First Newspaper Name
The Dallas Morning News
First Advertisement Start Date
2020-07-26
Second Newspaper Ad Name
The Dallas Morning News
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-08-02
Employer Website From Date
2020-07-20
Employer Website To Date
2020-07-28
Professional Organization Ad From Date
2022-01-01 10:30:32
Professional Organization Advertisement To Date
2022-01-01 10:30:32
Job Search Website From Date
2020-07-22
Job Search Website To Date
2020-08-05
Employee Referral Program From Date
2022-01-01 10:30:32
Employee Referral Program To Date
2022-01-01 10:30:32
Local Ethnic Paper From Date
2020-07-31
Local Ethnic Paper To Date
2020-07-31
Radio/TV Ad From Date
2022-01-01 10:30:32
Radio/TV Ad To Date
2022-01-01 10:30:32
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
Y
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker Information: Major
APPLIED COMPUTER SCIENCE
Foreign Worker Years of Education Completed
2006
Foreign Worker Institution of Education
UNIVERSITY OF MADRAS
Foreign Worker Education Institution Address 1
NAVALAR NAGAR, CHEPAUK, TRIPLICANE
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
CHENNAI
Foreign Worker Education Institution State/Province
TN
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
600005
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Peter B Bade
Preparer Title
Senior Associate
Preparer Email
pbade@balglobal.com
Employer Information Declaration Name
Jennifer R Shapiro
Employer Information Declaration Title
Immigration Senior Specialist