Fiscal Year

2021

Case Number

A-20141-56411

Case Status

Certified-Expired

Received Date

2020-06-30

Decision Date

2021-02-03

Refile

N

Original File Date

2021-01-01 08:59:50

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

BANK OF AMERICA

Employer Name Slug

bank-of-america

Employer Address 1

100 N. TRYON STREET

Employer Address 2

Employer City

CHARLOTTE

Employer City Slug

charlotte

Employer State

NORTH CAROLINA

Employer State Slug

north-carolina

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

28255

Employer Phone

646-855-1847

Employer Number of Employees

208000

Employer Year Commenced Business

1904

NAICS Code

522110

FW Ownership Interest

N

Employer Contact Name

Rachel Goldin

Employer Contact Address 1

50 Rockefeller Plaza

Employer Contact Address 2

Employer Contact City

New York

Employer Contact State/Province

NEW YORK

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

10020

Employer Contact Phone

646-855-1847

Employer Contact Email

rachel.goldin@bofa.com

Agent Attorney Name

Isha Atassi

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

2126888555

Agent Attorney Address 1

1400 Broadway

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

10018

Agent Attorney Email

ktracey@fragomen.com

PW Track Number

P10019282077769

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

N/A

PW Wage

97410.00

PW Unit of Pay

Year

PW Wage Source

Other

PW Determination Date

2020-02-03

PW Expiration Date

2020-06-30

Wage Offer From

107625.00

Wage Offer To

0.00

Average Salary

107625.00

Wage Unit of Pay

Year

Worksite Address 1

800 W Trade Street

Worksite Address 2

Worksite City

Charlotte

Worksite City Slug

charlotte

Worksite State

NORTH CAROLINA

Worksite Postal Code

28255

Job Title

Vice President; Cnslt - Apps Prog

Job Title Slug

vice-president-cnslt-apps-prog

Minimum Education

Bachelor's

Major Field of Study

CompSci, Engg (any), CIS, MIS, or rel

Required Training

N

Required Experience

Y

Required Experience Months

60

Accept Alternative Field of Study

N

Accept Alternative Major 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

60

Accept Alternative Job Title

Job offered or related IT occupation

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Must have 5 years of progressively responsible experience in the job offered or related IT occupation. Must include 5 years of experience in the following Managing the design, configuration and implementation for several mediumlarge software systems that include specialized largescale transaction repositories in the financial services domain, and application of this knowledge to research, design and operationalize the world of commerce into discrete, meaningful data categories; Leading the Development, Testing, and Production Support operational and administrative of applications in large datawarehouse environments; Designing and programming complex Extract, Transform and Load ETL mechanisms and governing endtoend data architecture; Developing and maintaining programs that extract data from different data marts across various databases and platforms, apply the appropriate business logic and rules to transform the data and then load it to the repository model via a staging layer; Optimization of the data model and load programs for managing huge multiterabytes amounts of data on a daily basis and assessing performance of queries and identify opportunities for reducing CPUs, and spool space by tuning of the SQL queries and other database optimization techniques; Providing oncallbeeper support for applications including monitoring of scheduled application jobs, researching and fixing job failures and researching and fixing data issues and identify and eliminate the root cause of those issues; and, Coordination of work requests and project initiatives across multiple time zones in the US and offshore.

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-03-02

SWA Job Order End Date

2020-04-03

Sunday Edition Newspaper

Y

First Newspaper Name

The Charlotte Observer

First Advertisement Start Date

2020-03-08

Second Newspaper Ad Name

The Charlotte Observer

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-03-15

Employer Website From Date

2021-01-01 08:59:50

Employer Website To Date

2021-01-01 08:59:50

Professional Organization Ad From Date

2020-03-09

Professional Organization Advertisement To Date

2020-04-07

Job Search Website From Date

2020-03-13

Job Search Website To Date

2020-03-23

Employee Referral Program From Date

2021-01-01 08:59:50

Employee Referral Program To Date

2021-01-01 08:59:50

Local Ethnic Paper From Date

2020-03-12

Local Ethnic Paper To Date

2020-03-12

Radio/TV Ad From Date

2021-01-01 08:59:50

Radio/TV Ad To Date

2021-01-01 08:59: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

Bachelor's

Foreign Worker Information: Major

COMPUTER ENGINEERING

Foreign Worker Years of Education Completed

2008

Foreign Worker Institution of Education

SRM INSTITUTE OF SCIENCE AND TECHNOLOGY

Foreign Worker Education Institution Address 1

MAHATMA GANDHI ROAD, SRM NAGAR,

Foreign Worker Education Institution Address 2

POTHERI, KATTANKULATHUR, KANCHIPURAM DISTRICT

Foreign Worker Education Institution City

CHENNAI

Foreign Worker Education Institution State/Province

TAMIL NADU

Foreign Worker Education Institution Country

Foreign Worker Education Institution Postal Code

603203

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Isha Atassi

Preparer Title

Partner

Preparer Email

ktracey@fragomen.com

Employer Information Declaration Name

Rachel Vito Goldin Logudic

Employer Information Declaration Title

Senior Vice President