Fiscal Year

2021

Case Number

A-20282-08962

Case Status

Certified

Received Date

2020-10-16

Decision Date

2021-05-06

Refile

N

Original File Date

2021-01-01 09:20:48

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Boehringer Ingelheim Animal Health USA Inc.

Employer Name Slug

boehringer-ingelheim-animal-health-usa-inc

Employer Address 1

900 Ridgebury Road

Employer Address 2

Employer City

Ridgefield

Employer City Slug

ridgefield

Employer State

CONNECTICUT

Employer State Slug

connecticut

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

6877

Employer Phone

203-798-5243

Employer Number of Employees

50000

Employer Year Commenced Business

1971

NAICS Code

325412

FW Ownership Interest

N

Employer Contact Name

Carmen Dubuc-Valerio

Employer Contact Address 1

900 Ridgebury Road

Employer Contact Address 2

Employer Contact City

Ridgefield

Employer Contact State/Province

CONNECTICUT

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

6877

Employer Contact Phone

203-798-5243

Employer Contact Email

carmen.dubuc-valerio@boehringer-ingelheim.com

Agent Attorney Name

Derek M Sewall

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

2126888555

Agent Attorney Address 1

1400 Broadway

Agent Attorney Address 2

Agent Attorney City

New York

Agent Attorney State/Province

NEW YORK

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

10018

Agent Attorney Email

dsewall@Fragomen.com

PW Track Number

P10019338179061

PW SOC Code

15-1121

PW SOC Title

Computer Systems Analysts

PW Skill Level

Level IV

PW Wage

109034.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-03-23

PW Expiration Date

2020-06-30

Wage Offer From

115360.00

Wage Offer To

132613.00

Average Salary

123986.50

Wage Unit of Pay

Year

Worksite Address 1

3239 Satellite Boulevard, Bldg 500

Worksite Address 2

Worksite City

Duluth

Worksite City Slug

duluth

Worksite State

GEORGIA

Worksite Postal Code

30096

Job Title

Senior Technical Analyst

Job Title Slug

senior-technical-analyst

Minimum Education

Master's

Major Field of Study

Information Systems, Statistics, Mathematics, Market Research, or a related field

Required Training

N

Required Experience

Y

Required Experience Months

120

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

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

120

Accept Alternative Job Title

job offered or related role

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Prior experience must include experience with analyzing and manipulating unstructured data using Alteryx, Tableau, R, SAS Visual Analytics; Exasol, Alteryx, IBM Cognos Analytics, IBM Cognos TM1, QlikView, Tableau, Excel, PowerPoint, SSAS, SSMS, SQL and DWODL environments; using complex SQL queries to extract data from databases, and conduct basic statistical analyses using tools such as SPSS, Stata, SAS, and Excel; leading ETL tools, such as SAP Data Services, MS SSIS, Informatica; statistical modeling methodologies and tools R, Python, SAS, and SPSS; extracting and manipulating data from multiple data sources i.e. delimited text files, Excel, RDBMS, Access and integrating them into a single source viewreportdataset; database technologies and SQL language for querying and manipulating datasets; data warehousing concepts including data integration and data warehouse objects; using programming languages such as Python, SQL, and Java; major big data solutions like Hadoop, Map Reduce, Hive, Pig and other tools in the Hadoop ecosystem; working with Predictive Analytics tools including IBM Watson Analytics, IBM SPSS Modeler, and R; PLSQL Scripting and working on Oracle Stored Procedures and Functions; leading OLAPROLAP tools Business Objects, Microsoft, Microstrategy Hyperion Essbase or Cognos; modern visualization frameworks, such as Gephi, Processing, R andor D3.js; NoSQL platforms; and dimensional modeling techniques and creation of logical and physical data models entity relationship modeling, Erwin diagrams. Position requires travel up to 25 of the time.

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

SWA Job Order End Date

2020-06-15

Sunday Edition Newspaper

Y

First Newspaper Name

The Atlanta JournalConstitution

First Advertisement Start Date

2020-06-07

Second Newspaper Ad Name

The Atlanta JournalConstitution

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-06-14

Employer Website From Date

2020-04-21

Employer Website To Date

2020-09-16

Professional Organization Ad From Date

2021-01-01 09:20:48

Professional Organization Advertisement To Date

2021-01-01 09:20:48

Job Search Website From Date

2020-06-07

Job Search Website To Date

2020-06-22

Employee Referral Program From Date

2020-04-21

Employee Referral Program To Date

2020-04-30

Local Ethnic Paper From Date

2021-01-01 09:20:48

Local Ethnic Paper To Date

2021-01-01 09:20:48

Radio/TV Ad From Date

2021-01-01 09:20:48

Radio/TV Ad To Date

2021-01-01 09:20:48

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

2007

Foreign Worker Institution of Education

UNIVERSITY OF WALES

Foreign Worker Education Institution Address 1

HEALTH CENTRE, CAERLEON CAMPUS, RATHMELL BUILDING, LODGE ROAD

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

NEWPORT

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

UNITED KINGDOM

Foreign Worker Education Institution Postal Code

NP18 3QT

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

DEREK SEWALL

Preparer Title

ASSOCIATE ATTORNEY

Preparer Email

DSewall@fragomen.com

Employer Information Declaration Name

Carmen DubucValerio

Employer Information Declaration Title

International Expatriate Manager