Fiscal Year

2020

Case Number

A-20023-10656

Case Status

Certified

Received Date

2020-02-04

Decision Date

2020-06-04

Refile

N

Original File Date

2020-01-01 08:33:22

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

ABBVIE INC.

Employer Name Slug

abbvie-inc

Employer Address 1

1 NORTH WAUKEGAN ROAD

Employer Address 2

Employer City

NORTH CHICAGO

Employer City Slug

north-chicago

Employer State

ILLINOIS

Employer State Slug

illinois

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

60064

Employer Phone

847-937-2778

Employer Number of Employees

12700

Employer Year Commenced Business

2013

NAICS Code

325412

FW Ownership Interest

N

Employer Contact Name

Polacek Jeanna

Employer Contact Address 1

1 North Waukegan Road

Employer Contact Address 2

AP342

Employer Contact City

North Chicago

Employer Contact State/Province

ILLINOIS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

60064

Employer Contact Phone

847-937-0609

Employer Contact Email

jeanna.polacek@abbvie.com

Agent Attorney Name

Keith P Liston

Agent Attorney Firm Name

Hussain, Bendersky Liston, LLC

Agent Attorney Phone

3124649330

Agent Attorney Address 1

350 N. Clark Street

Agent Attorney Address 2

Suite 600

Agent Attorney City

Chicago

Agent Attorney State/Province

ILLINOIS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

60654

Agent Attorney Email

kliston@hebf.com

PW Track Number

P10019190017665

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level II

PW Wage

81931.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

110000.00

Wage Offer To

120000.00

Average Salary

115000.00

Wage Unit of Pay

Year

Worksite Address 1

1 N. Waukegan Rd

Worksite Address 2

Worksite City

North Chicago

Worksite City Slug

north-chicago

Worksite State

ILLINOIS

Worksite Postal Code

60064

Job Title

Database Engineer II

Job Title Slug

database-engineer-ii

Minimum Education

Master's

Major Field of Study

Biological Sciences

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Mathematics, Physics, Statistics, Engineering, Computer Science, or related

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

5

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

24

Accept Alternative Job Title

Software Developer, IT Analyst. Emp will accept any suit comb of edu, training or exp rel to job opp

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Masters degree, or foreign academic equivalent, in Biological Sciences, Mathematics, Physics, Statistics, Engineering, Computer Science, or related concentration Will accept a Bachelors degree plus five years of related progressive experience in lieu of a Masters degree each alternative educational requirement with at least 2 years of experience in i gathering requirements from business users, designing, developing, testing and deploying data warehouse applications that extract data from multiple sources, transforming according to business rules and loading into Oracle; ii creating detailed design plans, process flow, data model, test plan, implementation plan and run documentation and review with project stakeholders while building warehouse applications in development environment; iii modifying existing software to correct errors andor improve performance; and iv utilizing skills in Oracle SQL, PLSQL, SQL performance tuning, UNIX shell scripting, Datastage, Microsoft SQL Server, Postgres, XML, python, ERWin data modeler, TOAD and Microsoft Office. Employer will accept any suitable combination of education, training or experience related to the job opportunity as stated in H.11.

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-11-19

SWA Job Order End Date

2019-12-19

Sunday Edition Newspaper

Y

First Newspaper Name

Chicago Sun Times

First Advertisement Start Date

2019-11-24

Second Newspaper Ad Name

Chicago Sun Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-12-01

Employer Website From Date

2020-01-01 08:33:22

Employer Website To Date

2020-01-01 08:33:22

Professional Organization Ad From Date

2020-01-01 08:33:22

Professional Organization Advertisement To Date

2020-01-01 08:33:22

Job Search Website From Date

2019-11-20

Job Search Website To Date

2019-12-05

Employee Referral Program From Date

2019-11-21

Employee Referral Program To Date

2019-12-09

Local Ethnic Paper From Date

2019-12-05

Local Ethnic Paper To Date

2019-12-06

Radio/TV Ad From Date

2020-01-01 08:33:22

Radio/TV Ad To Date

2020-01-01 08:33:22

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

CIVIL ENGINEERING

Foreign Worker Years of Education Completed

2006

Foreign Worker Institution of Education

THIAGARAJAR COLLEGE OF ENGINEERING

Foreign Worker Education Institution Address 1

THIRUPARANKUNDRAM

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

MADURAI

Foreign Worker Education Institution State/Province

TAMIL NADU

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

625015

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Keith P Liston

Preparer Title

Attorney

Preparer Email

kliston@hebf.com

Employer Information Declaration Name

Jeanna Polacek

Employer Information Declaration Title

Paralegal, Immigration and Employment