Fiscal Year

2020

Case Number

A-19304-77866

Case Status

Certified

Received Date

2019-11-20

Decision Date

2020-04-15

Refile

N

Original File Date

2020-01-01 08:13:55

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

COLE HAAN LLC

Employer Name Slug

cole-haan-llc

Employer Address 1

150 OCEAN ROAD

Employer Address 2

Employer City

GREENLAND

Employer City Slug

greenland

Employer State

NEW HAMPSHIRE

Employer State Slug

new-hampshire

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

3840

Employer Phone

6034307800

Employer Number of Employees

2000

Employer Year Commenced Business

1928

NAICS Code

316219

FW Ownership Interest

N

Employer Contact Name

Laurie Waniak

Employer Contact Address 1

150 Ocean Road

Employer Contact Address 2

Employer Contact City

Greenland

Employer Contact State/Province

NEW HAMPSHIRE

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

3840

Employer Contact Phone

6034307800 4118

Employer Contact Email

laurie.waniak@colehaan.com

Agent Attorney Name

Alan C Perkins

Agent Attorney Firm Name

Tonkon Torp LLP

Agent Attorney Phone

5038022127

Agent Attorney Address 1

Tonkon Torp LLP

Agent Attorney Address 2

1600 Pioneer Tower, 888 SW Fifth Avenue

Agent Attorney City

Portland

Agent Attorney State/Province

OREGON

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

97204

Agent Attorney Email

alan.perkins@tonkon.com

PW Track Number

P10018325684377

PW SOC Code

15-1133

PW SOC Title

Software Developers, Systems Software

PW Skill Level

Level IV

PW Wage

128877.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-05-10

PW Expiration Date

2019-08-08

Wage Offer From

130000.00

Wage Offer To

0.00

Average Salary

130000.00

Wage Unit of Pay

Year

Worksite Address 1

150 Ocean Road

Worksite Address 2

Worksite City

Greenland

Worksite City Slug

greenland

Worksite State

NEW HAMPSHIRE

Worksite Postal Code

3840

Job Title

Engineer Manager - Data (Online, Digital)

Job Title Slug

engineer-manager-data-online-digital

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

PLEASE SEE H.11

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

96

Accept Alternative Job Title

PLEASE SEE H.11

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

br br br 1. 1 year experience with data wrangling and integration tools, Alteryx and Dell Boomi.br br br br 2. 1 year experience working in an Agile team including Scrum or Kanban.br br br br 3. 1 year experience working with Snowflake cloudbased relational database.br br br br 4. 1 year experience developing reports and dashboards with Tableau.br br br br 5. 3 years experience in SAP AFS ETL, modeling and reporting.br br br br 6. 3 years experience with extracting data from Aptos platforms POS, Sales Audit, Loss Prevention and CRM.br br br br 7. 3 years experience developing complex SQL.br br br br 8. 5 years experience in data warehouse migrations involving traditional technologies and cloudbased platforms.br br br br 9. 5 years experience working in SAP Order to Cash OTC, demand planning, FICOPA, SD and Material Management ETL, and modeling and reporting.br br br br 10. 5 years experience providing architectural guidance on the development of end to end BI solutions, specifically data integration, ELT, and Business Intelligence.br br br br 11. 5 years experience leading technical data project teams of 510 programmers and technicians, and the full software development life cycle requirements, design, implementation, testing, review, deployment, and support.br br br br 12. 7 years experience providing technical management of data projects related to one or more of the following data qualitydata governance assessments, Master data management, integration scoping requirements design mapping, or data warehouse architecturedesignimplementation.br br br br 13. 8 years experience estimating the implementation effort for ETL, databasedata warehouse, and data architecture components of solutions from requirements through deployment; 8 years development experience in Data Warehouse, Data Analytics and BI technologies; and 8 years experience performing rootcause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.br br br br 14. Must have coordinated at least 7 projects across functional teams, including engineering, IT, product management, finance, and operations.br br br br Background check required.br br br br br All experience, skills and requirements may be gained concurrently.br br br br

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-12

SWA Job Order End Date

2019-09-18

Sunday Edition Newspaper

Y

First Newspaper Name

NEW HAMPSHIRE SUNDAY NEWS

First Advertisement Start Date

2019-08-25

Second Newspaper Ad Name

NEW HAMPSHIRE SUNDAY NEWS

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-09-01

Employer Website From Date

2019-08-05

Employer Website To Date

2019-11-19

Professional Organization Ad From Date

2020-01-01 08:13:55

Professional Organization Advertisement To Date

2020-01-01 08:13:55

Job Search Website From Date

2019-08-26

Job Search Website To Date

2019-09-06

Employee Referral Program From Date

2020-01-01 08:13:55

Employee Referral Program To Date

2020-01-01 08:13:55

Local Ethnic Paper From Date

2019-08-22

Local Ethnic Paper To Date

2019-08-23

Radio/TV Ad From Date

2020-01-01 08:13:55

Radio/TV Ad To Date

2020-01-01 08:13:55

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 SCIENCE AND ENGINEERING

Foreign Worker Years of Education Completed

2006

Foreign Worker Institution of Education

BARKATULLAH VISHWAVIDYALAYA BHOPAL UNIVERSITY

Foreign Worker Education Institution Address 1

BARKATULLAH UNIVERSITY, HABIBGANJ

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

BHOPAL

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

462026

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

ALAN C PERKINS

Preparer Title

ATTORNEY

Preparer Email

alan.perkins@tonkon.com

Employer Information Declaration Name

LAURIE WANIAK

Employer Information Declaration Title

MANAGER, HUMAN RESOURCES