Fiscal Year

2020

Case Number

A-19311-80217

Case Status

Certified

Received Date

2019-11-27

Decision Date

2020-04-20

Refile

N

Original File Date

2020-01-01 08:15:36

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

WAYFAIR LLC

Employer Name Slug

wayfair-llc

Employer Address 1

100 HUNTINGTON AVENUE

Employer Address 2

4 COPLEY PLACE

Employer City

BOSTON

Employer City Slug

boston

Employer State

MASSACHUSETTS

Employer State Slug

massachusetts

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

2116

Employer Phone

617-502-7273

Employer Number of Employees

13111

Employer Year Commenced Business

2002

NAICS Code

453998

FW Ownership Interest

N

Employer Contact Name

Rebecca Ruehlman

Employer Contact Address 1

100 Huntington Avenue

Employer Contact Address 2

4 Copley Place

Employer Contact City

Boston

Employer Contact State/Province

MASSACHUSETTS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

2116

Employer Contact Phone

617-502-7273

Employer Contact Email

usimmigration@wayfair.com

Agent Attorney Name

Mariah G Wilson

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

617-574-0400

Agent Attorney Address 1

100 High Street

Agent Attorney Address 2

3rd Floor

Agent Attorney City

Boston

Agent Attorney State/Province

MASSACHUSETTS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

2110

Agent Attorney Email

packardteam@fragomen.com

PW Track Number

P10019028987690

PW SOC Code

15-1133

PW SOC Title

Software Developers, Systems Software

PW Skill Level

Level II

PW Wage

100027.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-07-15

PW Expiration Date

2020-06-30

Wage Offer From

125000.00

Wage Offer To

0.00

Average Salary

125000.00

Wage Unit of Pay

Year

Worksite Address 1

100 Huntington Avenue

Worksite Address 2

4 Copley Place

Worksite City

Boston

Worksite City Slug

boston

Worksite State

MASSACHUSETTS

Worksite Postal Code

2116

Job Title

Software Engineer 3

Job Title Slug

software-engineer-3

Minimum Education

Master'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 a directly related field

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

2

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

12

Accept Alternative Job Title

Experience in web programming using PHP, JavaScript, or SQL.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Experience must include one 1 year in each of the following experience may be gained concurrentlybr Full stack software development using HTML, CSS, JavaScript, or Object Oriented languages including Java, PHP, Lua, or Cbr Scripting using Transact SQL, PowerShell, Python, or Shell, and version control using GIT, SVN, or Perforcebr Defining test plans and unit and regression testingbr SQL database development including designing queries, designing RDBMS, triggers and stored procedures, or performing data ETL in MSSQL or MySQL environmentsbr Analyzing, troubleshooting, and tuning SQL Server replication in MSSQL or MySQL environmentsbr Jenkins and Puppet to deploy application code into server environmentsbr Interfacing with business product leaders and engineers to gather requirements and translate requirements into system and database designbr Performing all phases of the fullstack software development lifecycle from requirement gathering, tech specifications, design, programming, testing, and deploymentbr Advanced Excel, including manipulating data sets and performing regression functions for data analysisbr Reviewing and documenting newly developed Software applications and software modules to meet the design requirements and industry standards.

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

2019-08-02

SWA Job Order End Date

2019-09-03

Sunday Edition Newspaper

Y

First Newspaper Name

The Boston Globe

First Advertisement Start Date

2019-08-18

Second Newspaper Ad Name

The Boston Globe

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-08-25

Employer Website From Date

2019-07-31

Employer Website To Date

2019-08-14

Professional Organization Ad From Date

2020-01-01 08:15:36

Professional Organization Advertisement To Date

2020-01-01 08:15:36

Job Search Website From Date

2019-08-14

Job Search Website To Date

2019-08-28

Employee Referral Program From Date

2019-07-31

Employee Referral Program To Date

2019-08-15

Local Ethnic Paper From Date

2020-01-01 08:15:36

Local Ethnic Paper To Date

2020-01-01 08:15:36

Radio/TV Ad From Date

2020-01-01 08:15:36

Radio/TV Ad To Date

2020-01-01 08:15:36

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

INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2012

Foreign Worker Institution of Education

NORTHEASTERN UNIVERSITY

Foreign Worker Education Institution Address 1

360 HUNTINGTON AVENUE

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

BOSTON

Foreign Worker Education Institution State/Province

MA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

2115

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Mariah G Wilson

Preparer Title

Associate Attorney

Preparer Email

packardteam@fragomen.com

Employer Information Declaration Name

Rebecca Ruehlman

Employer Information Declaration Title

Senior Associate, Immigration