All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-19221-42579

Fiscal year: 2020

Fiscal Year

2020

Case Number

A-19221-42579

Case Status

Certified

Received Date

2020-03-16

Decision Date

2020-07-14

Refile

N

Original File Date

2020-01-01 07:48:43

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

OUTLOOK AMUSEMENTS, INC.

Employer Name Slug

outlook-amusements-inc

Employer Address 1

2900 W. ALAMEDA AVE.

Employer Address 2

SUITE 400

Employer City

BURBANK

Employer City Slug

burbank

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

91505

Employer Phone

818-433-3800

Employer Number of Employees

157

Employer Year Commenced Business

2003

NAICS Code

713990

FW Ownership Interest

N

Employer Contact Name

Kim Hamer

Employer Contact Address 1

2900 W. Alameda Ave.

Employer Contact Address 2

Suite 400

Employer Contact City

Burbank

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

91505

Employer Contact Phone

818-433-3817

Employer Contact Email

khamer@outlookamusements.com

Agent Attorney Name

Maryanne Kline

Agent Attorney Firm Name

Mintz Levin Cohn Ferris Glovsky Popeo PC

Agent Attorney Phone

617-239-8498

Agent Attorney Address 1

One Financial Center

Agent Attorney Address 2

Agent Attorney City

Boston

Agent Attorney State/Province

MASSACHUSETTS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

2111

Agent Attorney Email

mkline@mintz.com

PW Track Number

P10019303116963

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level IV

PW Wage

135886.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-02-25

PW Expiration Date

2020-06-30

Wage Offer From

135900.00

Wage Offer To

0.00

Average Salary

135900.00

Wage Unit of Pay

Year

Worksite Address 1

2900 W. Alameda Avenue, Ste.400

Worksite Address 2

Worksite City

Burbank

Worksite City Slug

burbank

Worksite State

CALIFORNIA

Worksite Postal Code

91505

Job Title

Senior SQL Developer

Job Title Slug

senior-sql-developer

Minimum Education

Bachelor's

Major Field of Study

Science or Engineering 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

Y

Accept Alternative Occupation Months

60

Accept Alternative Job Title

Any occupation meeting requirements of Box H.14

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

All Requirements Bachelors degree or foreign equivalent in a Science or Engineering field, plus 5 years of postdegree experience in SQL development andor SQL Server administration. Experience, which may be gained concurrently, must includebr 1 5 years experience with TSQL SQL 2012 and up developing stored procedures, triggers, views, functionsbr 2 3 years experience with MS SSRS and MS SSISbr 3 5 years experience with SQL Server Data Toolsbr 4 5 years experience in database stored procedure development and maintenancebr 5 5 years experience isolating and resolving typical problems with the SQL Server application and the databases Loss or lack of connectivity, inability to leverage services provided by database, SQL Server specific errors, timeouts and severe loss of performancebr 6 5 years experience using 2005 BI Studio for SSRS and SSISbr 7 Requires participation in 24X7 on call support rotation for SQL Server databases.

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

SWA Job Order End Date

2020-02-05

Sunday Edition Newspaper

Y

First Newspaper Name

Los Angeles Times

First Advertisement Start Date

2020-01-12

Second Newspaper Ad Name

Los Angeles Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-01-19

Employer Website From Date

2019-12-31

Employer Website To Date

2020-01-31

Professional Organization Ad From Date

2020-01-01 07:48:43

Professional Organization Advertisement To Date

2020-01-01 07:48:43

Job Search Website From Date

2020-01-02

Job Search Website To Date

2020-01-22

Employee Referral Program From Date

2019-12-31

Employee Referral Program To Date

2020-01-31

Local Ethnic Paper From Date

2020-01-01 07:48:43

Local Ethnic Paper To Date

2020-01-01 07:48:43

Radio/TV Ad From Date

2020-01-01 07:48:43

Radio/TV Ad To Date

2020-01-01 07:48:43

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

BIOTECHNOLOGY

Foreign Worker Years of Education Completed

2007

Foreign Worker Institution of Education

STEPHEN F. AUSTIN STATE UNIVERSITY, COLLLEGE OF SCIENCE MATHEMATICS

Foreign Worker Education Institution Address 1

1936 NORTH STREET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

NACOGDOCHES

Foreign Worker Education Institution State/Province

TX

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

75962

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Maryanne Kline

Preparer Title

Attorney

Preparer Email

mkline@mintz.com

Employer Information Declaration Name

Kim Hamer

Employer Information Declaration Title

Human Resources Manager