Fiscal Year

2021

Case Number

A-20189-73737

Case Status

Certified-Expired

Received Date

2020-07-07

Decision Date

2021-02-12

Refile

N

Original File Date

2021-01-01 09:01:49

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Columbia Brands USA, LLC

Employer Name Slug

columbia-brands-usa-llc

Employer Address 1

14375 NW Science Park Dr.

Employer Address 2

Employer City

Portland

Employer City Slug

portland

Employer State

OREGON

Employer State Slug

oregon

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

97229

Employer Phone

5039854839

Employer Number of Employees

4034

Employer Year Commenced Business

1938

NAICS Code

31599

FW Ownership Interest

N

Employer Contact Name

Jodi Alfano

Employer Contact Address 1

14375 NW Science Park Dr.

Employer Contact Address 2

Employer Contact City

Portland

Employer Contact State/Province

OREGON

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

97229

Employer Contact Phone

5039854839

Employer Contact Email

jalfano@columbia.com

Agent Attorney Name

Melany I Savitt

Agent Attorney Firm Name

Tonkon Torp LLP

Agent Attorney Phone

5038022179

Agent Attorney Address 1

1600 Pioneer Tower

Agent Attorney Address 2

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

melany.savitt@tonkon.com

PW Track Number

P10019190017739

PW SOC Code

15-1199

PW SOC Title

Information Technology Project Managers

PW Skill Level

Level IV

PW Wage

101629.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-10-24

PW Expiration Date

2020-06-30

Wage Offer From

101629.00

Wage Offer To

0.00

Average Salary

101629.00

Wage Unit of Pay

Year

Worksite Address 1

700 N. Leadbetter

Worksite Address 2

Worksite City

Portland

Worksite City Slug

portland

Worksite State

OREGON

Worksite Postal Code

97203

Job Title

Business Analyst III, Distribution Information Systems

Job Title Slug

business-analyst-iii-distribution-information-systems

Minimum Education

Bachelor's

Major Field of Study

See H.14

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

See H.14

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

See H.14

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

5 years experiencebr br 1. Working with Warehouse Management Systems;br 2. Working with IBM System i AS400, iSeries platform, OS400 operating system, and DB2 database;br 3. Programing with IBM System i language RPGRPGLE;br br 3 years experiencebr 4. Using SQL to support technical analysis and on demand data analytics;br 5. Working in highly automated distribution center using material handling equipment;br 6. Working with system design, developing technical specifications, and debugging testing;br 7. Using Waterfall, Agile, or similar methodology;br 8. Implementing 13 full Lifecyle Warehouse Management System implementations upgrades; andbr 9. Supporting distribution applications production to include incident triage, incident severity management of a Level 1 outages, and escalation.br br br All experience, skills and requirements may be gained concurrently. Employer will conduct background check prior to hire.br br br H.4B and H.7A MAJOR FIELD OF STUDY Supply Chain Management, Computer Science, Management Information Systems, Engineering, or closely related field.br br H.10B ALT. OCCUPATIONS Business Analyst, Business Systems Analyst, Programmer Analyst, Senior Developer, or similar position.br br THE 60 MONTHS EXPERIENCE LISTED IN H.10A MUST BE PROGRESSIVE AND GAINED POST BACHELORS DEGREE.br br H.12 BUSINESS NECESSITY DOCUMENTATION CAN BE PROVIDED TO ESTABLISH THAT THE JOB DUTIES AND REQUIREMENTS BEAR A REASONABLE RELATIONSHIP TO THE OCCUPATION IN THE CONTEXT OF THE EMPLOYERS BUSINESS AND ARE ESSENTIAL TO PERFORM THE JOB IN A REASONABLE MANNER.

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-01-10

SWA Job Order End Date

2020-02-11

Sunday Edition Newspaper

Y

First Newspaper Name

Oregonian

First Advertisement Start Date

2020-01-12

Second Newspaper Ad Name

Oregonian

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-01-19

Employer Website From Date

2020-01-10

Employer Website To Date

2020-03-20

Professional Organization Ad From Date

2021-01-01 09:01:49

Professional Organization Advertisement To Date

2021-01-01 09:01:49

Job Search Website From Date

2020-01-12

Job Search Website To Date

2020-01-25

Employee Referral Program From Date

2021-01-01 09:01:49

Employee Referral Program To Date

2021-01-01 09:01:49

Local Ethnic Paper From Date

2020-01-16

Local Ethnic Paper To Date

2020-01-22

Radio/TV Ad From Date

2021-01-01 09:01:49

Radio/TV Ad To Date

2021-01-01 09:01:49

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

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

BACHELOR OF ENGINERING

Foreign Worker Years of Education Completed

2007

Foreign Worker Institution of Education

BENGAL ENGINEERING AND SCIENCE UNIVERSITY, SHIBPUR

Foreign Worker Education Institution Address 1

P.O. BOTANIC GARDEN

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HOWRAH

Foreign Worker Education Institution State/Province

WEST BENGALA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

711103

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Melany I Savitt

Preparer Title

Attorney

Preparer Email

melany.savitt@tonkon.com

Employer Information Declaration Name

Jodi Alfano

Employer Information Declaration Title

Senior Human Resources Business Partner