Fiscal Year

2023

Case Number

A-22020-00289

Case Status

Certified

Received Date

2022-02-17

Decision Date

2023-01-20

Refile

N

Original File Date

2023-01-01 08:13:00

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

255351

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

IL10043

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

Jeffrey R Thomas

Agent Attorney Firm Name

Ogletree Deakins

Agent Attorney Phone

9197879700

Agent Attorney Address 1

P.O. Box 31608

Agent Attorney Address 2

Agent Attorney City

Raleigh

Agent Attorney State/Province

NORTH CAROLINA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

27622

Agent Attorney Email

Jeffrey.Thomas@ogletree.com

PW Track Number

P10021174421725

PW SOC Code

15-1121

PW SOC Title

Computer Systems Analysts

PW Skill Level

Level IV

PW Wage

104915.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-11-29

PW Expiration Date

2022-06-30

Wage Offer From

154500.00

Wage Offer To

0.00

Average Salary

154500.00

Wage Unit of Pay

Year

Worksite Address 1

1111 Polaris Pkwy.

Worksite Address 2

Worksite City

Columbus

Worksite City Slug

columbus

Worksite State

OHIO

Worksite Postal Code

43240

Job Title

Software Engineering

Job Title Slug

software-engineering

Minimum Education

Bachelor's

Major Field of Study

Information Systems

Required Training

N

Required Experience

Y

Required Experience Months

84

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Comp. Science, Comp. Engineering, Information Technology, Project Mgmt, or related field of study

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

Technology Associate, IT Consultant, Software Engineer, or related occupation

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

This position requires a Bachelors degree in Information Systems, Computer Science, Computer Engineering, Information Technology, Project Management, or related field of study plus seven 7 years of experience in the position offered or seven 7 years of experience as a Technology Associate, IT Consultant, Software Engineer, or related occupation. This position requires seven 7 years of experience with the following financial assets including Mutual Funds, ETFs, and SubAdvised; project and backlog management, including financial control and budget management; business analysis including understanding and documenting business processes, coordinating user testing, and gathering and prioritizing defects; coordinating, planning, and executing Disaster Recovery and Sustained Resiliency testing including documentation and development of script for test automation; monitoring and managing infrastructure costs for the application; cyber security including managing risk and controls, security access, and data management using CyberArk Privileged Access Vaulting Tool; management and planning of deployment, including business notification using Service Now; serving as a business application owner or Subject Matter Expert; supporting internal audit exercises for the application owned; working in DevOps model; data modeling, application security, and data architecture in the Relational Database Management System environment; optimizing queries and code across large data sets using SQL; ETL extract, transform, load and ELT extract, load, transform technologies and implementation with tools including Pentaho and Informatica; scheduling tools including ControlM and Autosys; Open Source Scanning and code coverage using BlackDuck and Radix; and collaborative tools including Confluence and SharePoint. This position requires five 5 years of experience with the following Agile and Scrum frameworks implementation, facilitation of Scrum ceremonies, and creation of dashboards using JET Jira; and specialized programming languages such as Java or JavaScript. This position requires three 3 years of experience with the following using response escalation alerting communication tool REACT; scripting development using Unix Shell Scripts; and Jenkins Jules, JET BitBucket, and GIT for continuous integration and security reviews. This position requires one 1 year of experience with the following AWS; Python; and PySpark.

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-08-26

SWA Job Order End Date

2021-09-28

Sunday Edition Newspaper

Y

First Newspaper Name

The Columbus Dispatch

First Advertisement Start Date

2021-09-12

Second Newspaper Ad Name

The Columbus Dispatch

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-09-19

Employer Website From Date

2021-09-08

Employer Website To Date

2021-09-24

Professional Organization Ad From Date

2023-01-01 08:13:00

Professional Organization Advertisement To Date

2023-01-01 08:13:00

Job Search Website From Date

2021-09-13

Job Search Website To Date

2021-09-20

Employee Referral Program From Date

2023-01-01 08:13:00

Employee Referral Program To Date

2023-01-01 08:13:00

Local Ethnic Paper From Date

2021-09-17

Local Ethnic Paper To Date

2021-09-23

Radio/TV Ad From Date

2023-01-01 08:13:00

Radio/TV Ad To Date

2023-01-01 08:13:00

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

Y

Country of Citizenship

BRAZIL

Foreign Worker Birth Country

BRAZIL

Class of Admission

L-1

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2003

Foreign Worker Institution of Education

UNIVERSIDADE GUARULHOS

Foreign Worker Education Institution Address 1

PRAA TEREZA CRISTINA 1

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

GUARULHOS

Foreign Worker Education Institution State/Province

SO PAULO

Foreign Worker Education Institution Country

BRAZIL

Foreign Worker Education Institution Postal Code

07023-070

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Jeffrey R Thomas

Preparer Title

Attorney

Preparer Email

Jeffrey.Thomas@ogletree.com

Employer Information Declaration Name

Jennifer R Shapiro

Employer Information Declaration Title

Attorney in FactExec. Dir., Asst. Gen. Counsel