Fiscal Year

2022

Case Number

A-21161-99104

Case Status

Certified-Expired

Received Date

2021-06-21

Decision Date

2021-11-29

Refile

N

Original File Date

2022-01-01 10:30:24

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

TRUIST BANK

Employer Name Slug

truist-bank

Employer Address 1

214 NORTH 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

28202

Employer Phone

919-716-9044

Employer Number of Employees

56000

Employer Year Commenced Business

1872

NAICS Code

522110

FW Ownership Interest

N

Employer Contact Name

Cheryl B Williams

Employer Contact Address 1

Truist Bank Nashville Operations Center

Employer Contact Address 2

41 Rachel Drive

Employer Contact City

Nashville

Employer Contact State/Province

TENNESSEE

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

37214

Employer Contact Phone

615-391-8416

Employer Contact Email

PRImmigration@BBandT.com

Agent Attorney Name

Eileen M Scofield

Agent Attorney Firm Name

Alston Bird LLP

Agent Attorney Phone

404-881-7375

Agent Attorney Address 1

Alston Bird, LLP

Agent Attorney Address 2

One Atlantic Center, 1201 West Peachtree Street, NE

Agent Attorney City

Atlanta

Agent Attorney State/Province

GEORGIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

303093424

Agent Attorney Email

eileen.scofield@alston.com

PW Track Number

P10020264834890

PW SOC Code

15-1132

PW SOC Title

Software Developer, Applications

PW Skill Level

Level II

PW Wage

87984.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-02-23

PW Expiration Date

2021-06-30

Wage Offer From

120000.00

Wage Offer To

135000.00

Average Salary

127500.00

Wage Unit of Pay

Year

Worksite Address 1

11011 West Broad Street

Worksite Address 2

Worksite City

Glen Allen

Worksite City Slug

glen-allen

Worksite State

VIRGINIA

Worksite Postal Code

23060

Job Title

Senior Software Engineer

Job Title Slug

senior-software-engineer

Minimum Education

Bachelor's

Major Field of Study

Computer Science

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Information Systems, Computer Engineering, or related field

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

as a developerprogrammer

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Must have 2 years of experience as a developerprogrammer performing the following understanding the Requirements and specifications for Data warehouse ETL process; interacting with others for information requirements; developing metadata mapping and detail design documents; preparing methodology for analyzing the data from various datasets; designing and developing ETL processes using Ab Initio ETL software; extracting and reformatting data from heterogeneous data sources using Ab Initio; developing UNIX wrapper scripts for invoking the Ab Initio graphs and SQL execution scripts for data loading processes; unit testing, system testing and production support for various data warehouse ETL applications; preparing project documentation processes and project reports; and utilizing experience with COBOL, J2EE, CSS3, Javascript, JSON, TransactSQL, Ab Initio, Oracle, Taradata, and SQL Server. Must have 1 year experience leading complex projects; using Ab Initio to extract, transform and load data from multiple input sources like flat files, EBCIDIC, XML, MVS files and various databases; developing Oracle PLSQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules; developing subject area graphs based on business requirements using various Ab Initio Components like Filter by Expression, Partition by Expression, reformat, join, gather, merge rollup, normalize, scan, replicate etc.; applying Agile andor Waterfall methodologies; and utilizing experience with jQWidgets, Bootstrap, Angular.js, ASP.NET, AJAX, Windows Communication Foundation, Entity Framework 4.3 and Enterprise Library 5.0.

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

SWA Job Order End Date

2021-04-23

Sunday Edition Newspaper

Y

First Newspaper Name

The Richmond TimesDispatch

First Advertisement Start Date

2021-03-28

Second Newspaper Ad Name

The Richmond TimesDispatch

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-04-04

Employer Website From Date

2021-03-24

Employer Website To Date

2021-04-07

Professional Organization Ad From Date

2022-01-01 10:30:24

Professional Organization Advertisement To Date

2022-01-01 10:30:24

Job Search Website From Date

2021-03-23

Job Search Website To Date

2021-04-13

Employee Referral Program From Date

2022-01-01 10:30:24

Employee Referral Program To Date

2022-01-01 10:30:24

Local Ethnic Paper From Date

2021-03-31

Local Ethnic Paper To Date

2021-03-31

Radio/TV Ad From Date

2022-01-01 10:30:24

Radio/TV Ad To Date

2022-01-01 10:30:24

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

COMPUTER SCIENCE

Foreign Worker Years of Education Completed

2008

Foreign Worker Institution of Education

TEXAS AM UNIVERSITY COMMERCE

Foreign Worker Education Institution Address 1

2200 CAMPBELL ST

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

COMMERCE

Foreign Worker Education Institution State/Province

TX

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

75428

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Eileen Scofield

Preparer Title

Attorney

Preparer Email

eileen.scofield@alston.com

Employer Information Declaration Name

Cheryl B Williams

Employer Information Declaration Title

Asst General Counsel, Legal Regulatory Affairs