All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-19064-79089
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-19064-79089
Case Status
Certified-Expired
Received Date
2019-03-19
Decision Date
2019-11-14
Refile
N
Original File Date
2020-01-01 07:09:33
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
IL10043
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
239000
Employer Year Commenced Business
1838
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
Jenny Nieves
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Agent Attorney Phone
2122302877
Agent Attorney Address 1
7 Hanover Square
Agent Attorney Address 2
Agent Attorney City
New York
Agent Attorney State/Province
NEW YORK
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
100042756
Agent Attorney Email
jnieves@fragomen.com
PW Track Number
P10018248983005
PW SOC Code
15-1132
PW SOC Title
Software Developers, Applications
PW Skill Level
Level II
PW Wage
87693.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-02-15
PW Expiration Date
2019-06-30
Wage Offer From
87693.00
Wage Offer To
0.00
Average Salary
87693.00
Wage Unit of Pay
Year
Worksite Address 1
1111 Polaris Parkway
Worksite Address 2
Worksite City
Columbus
Worksite City Slug
columbus
Worksite State
OHIO
Worksite Postal Code
43240
Job Title
Associate, Software Engineer
Job Title Slug
associate-software-engineer
Minimum Education
Master's
Major Field of Study
Please see section H.14, specific skills or other requirements
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
Y
Accept Alternative Combination Education
Bachelor's
Accept Alternative Combination Education Years
5
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
24
Accept Alternative Job Title
Please see H.14.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Skills required Must have knowledge of SQL using various tools such as Toad, SQL Developer; collating from various data sources data warehouses, different database environments and analyzing large amounts of data and summarizing findings; working with largescalecomplex issues and working effectively across functional and organizational lines; translating business requirements into technical requirements documentation; full development lifecycle from inception through implementation, Data Warehousing environment, Database Development work experience and design experience in OracleMSSQL database platform; PLSQL, Perl, UNIX, and Java; ETL tool Informatica or Pentaho; ControlM job, Autosys, experience on the AIM Application infrastructure Model; designing database models, including star, snowflake schema, and cubing technology; designing database feeds from various systems; scripting automation solutions; data modeling, analytics and reporting; version and revision control practices and procedures; managing the issue resolution process for any application production problems; and prioritizing and managing development and implementation of enhancementschanges to multiple applications.br br br Continued from Sections H.4B, H.8 and H.10B.br Minimum education and experience required Masters degree or equivalent in Computer Science or a related field plus 2 years of experience in data analysis, operations research, computer science, mathematics, statistics, engineering, or related experience OR Bachelors degree or equivalent in Computer Science, or related field plus 5 years of experience in data analysis, operations research, computer science, mathematics, statistics, engineering, or related experience.
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
2018-11-14
SWA Job Order End Date
2018-12-17
Sunday Edition Newspaper
Y
First Newspaper Name
The Columbus Dispatch
First Advertisement Start Date
2018-12-02
Second Newspaper Ad Name
The Columbus Dispatch
Second Advertisement Type
Newspaper
Second Ad Start Date
2018-12-09
Employer Website From Date
2018-11-30
Employer Website To Date
2018-12-14
Professional Organization Ad From Date
2020-01-01 07:09:33
Professional Organization Advertisement To Date
2020-01-01 07:09:33
Job Search Website From Date
2018-12-03
Job Search Website To Date
2018-12-10
Employee Referral Program From Date
2020-01-01 07:09:33
Employee Referral Program To Date
2020-01-01 07:09:33
Local Ethnic Paper From Date
2018-12-07
Local Ethnic Paper To Date
2018-12-07
Radio/TV Ad From Date
2020-01-01 07:09:33
Radio/TV Ad To Date
2020-01-01 07:09:33
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
COMPUTER SCIENCE
Foreign Worker Years of Education Completed
2012
Foreign Worker Institution of Education
UNIVERSITY OF MASSACHUSETTS
Foreign Worker Education Institution Address 1
220 PAWTUCKET ST
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
LOWELL
Foreign Worker Education Institution State/Province
MA
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
1854
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Jenny Nieves
Preparer Title
Partner
Preparer Email
JNieves@Fragomen.com
Employer Information Declaration Name
Jennifer R Shapiro
Employer Information Declaration Title
Executive Director Assistant General Counsel