Fiscal Year

2021

Case Number

A-20302-14137

Case Status

Certified

Received Date

2021-01-25

Decision Date

2021-06-29

Refile

N

Original File Date

2021-01-01 09:43:42

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

FAMCe

Employer Name Slug

famce

Employer Address 1

1000 Armstrong St

Employer Address 2

Employer City

Morris

Employer City Slug

morris

Employer State

ILLINOIS

Employer State Slug

illinois

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

60450

Employer Phone

815-941-9888

Employer Number of Employees

62

Employer Year Commenced Business

2010

NAICS Code

423930

FW Ownership Interest

N

Employer Contact Name

Barbara Kudirka

Employer Contact Address 1

1000 Armstrong St

Employer Contact Address 2

Employer Contact City

Morris

Employer Contact State/Province

ILLINOIS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

60450

Employer Contact Phone

815-941-9888

Employer Contact Email

[email protected]

Agent Attorney Name

Min Ren

Agent Attorney Firm Name

MT LAW PC

Agent Attorney Phone

6502413760

Agent Attorney Address 1

2901 Tasman Drive

Agent Attorney Address 2

Suite 218

Agent Attorney City

Santa Clara

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

95054

Agent Attorney Email

[email protected]

PW Track Number

PW SOC Code

15-1141

PW SOC Title

Sr. Database AdministratorAnalyst

PW Skill Level

Level II

PW Wage

78853.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-09-08

PW Expiration Date

2021-06-30

Wage Offer From

98000.00

Wage Offer To

0.00

Average Salary

98000.00

Wage Unit of Pay

Year

Worksite Address 1

1000 Armstrong Street

Worksite Address 2

Worksite City

Morris

Worksite City Slug

morris

Worksite State

ILLINOIS

Worksite Postal Code

60450

Job Title

Sr. Database Administrator/Analyst

Job Title Slug

sr-database-administratoranalyst

Minimum Education

Master's

Major Field of Study

Computer Science, Informatics or closely related field

Required Training

N

Required Experience

N

Required Experience Months

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

N

Accept Alternative Occupation Months

Accept Alternative Job Title

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Proficiency in ETL process, developing ETL solutions, building ETL packages, troubleshooting ETL workflows, tuning performance.br Proficiency in relational and dimensional data modeling ER diagrams.br Proficiency in database management techniques, including designing and tuning complex queries using SQL and TSQL.br Demonstrated strong data analysis skills using business intelligence and data analysis software including Tableau, Power BI, Python libraries Matplotlib, Plotly, Seaborn and SSRS.br Demonstrated ability developing machine learning models to work on regression and classification predictions using Python;br Demonstrated data mining ability, including detecting outliers, applying unsupervised machine learning techniques using Python;br Proficiency in system data backup, recovery and security.br Demonstrated strong knowledge of enterprisewide computing architectures and infrastructure practices spanning multiple operations systems and hardware platforms.br Demonstrated ability to work and communicate effectively in English in a team environment as well as interface with all levels of staffmanagement within the organization

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-08-06

SWA Job Order End Date

2020-09-07

Sunday Edition Newspaper

Y

First Newspaper Name

Herald News Juliet Weekend

First Advertisement Start Date

2020-08-02

Second Newspaper Ad Name

Herald News Juliet Weekend

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-08-09

Employer Website From Date

2020-07-31

Employer Website To Date

2020-09-01

Professional Organization Ad From Date

2021-01-01 09:43:42

Professional Organization Advertisement To Date

2021-01-01 09:43:42

Job Search Website From Date

2020-08-05

Job Search Website To Date

2020-09-01

Employee Referral Program From Date

2021-01-01 09:43:42

Employee Referral Program To Date

2021-01-01 09:43:42

Local Ethnic Paper From Date

2020-08-04

Local Ethnic Paper To Date

2020-08-13

Radio/TV Ad From Date

2021-01-01 09:43:42

Radio/TV Ad To Date

2021-01-01 09:43:42

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

CHINA

Foreign Worker Birth Country

CHINA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

INFORMATICS

Foreign Worker Years of Education Completed

2018

Foreign Worker Institution of Education

NORTHEASTERN UNIVERSITY

Foreign Worker Education Institution Address 1

360 HUNTINGTON AVE

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/A

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Min Ren

Preparer Title

Attorney

Preparer Email

[email protected]

Employer Information Declaration Name

Barbara Kudirka

Employer Information Declaration Title

Office ManagerHR