Fiscal Year

2021

Case Number

A-20356-35655

Case Status

Certified

Received Date

2021-01-22

Decision Date

2021-07-01

Refile

N

Original File Date

2021-01-01 09:45:00

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

MGM RESORTS INTERNATIONAL OPERATIONS, INC.

Employer Name Slug

mgm-resorts-international-operations-inc

Employer Address 1

3950 LAS VEGAS BLVD. S

Employer Address 2

Employer City

LAS VEGAS

Employer City Slug

las-vegas

Employer State

NEVADA

Employer State Slug

nevada

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

89119

Employer Phone

7026921935

Employer Number of Employees

4006

Employer Year Commenced Business

2000

NAICS Code

721120

FW Ownership Interest

N

Employer Contact Name

Dana L Howell

Employer Contact Address 1

6385 S. Rainbow Blvd

Employer Contact Address 2

Suite 500

Employer Contact City

Las Vegas

Employer Contact State/Province

NEVADA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

89118

Employer Contact Phone

702-692-1937

Employer Contact Email

dhowell@mgmresorts.com

Agent Attorney Name

Ann Cauble

Agent Attorney Firm Name

Olgetree, Deakins, Nash, Smoak Stewart P.C.

Agent Attorney Phone

8642405644

Agent Attorney Address 1

300 North Main Street

Agent Attorney Address 2

Suite 500

Agent Attorney City

Greenville

Agent Attorney State/Province

SOUTH CAROLINA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

29601

Agent Attorney Email

ann.cauble@ogletreedeakins.com

PW Track Number

10020101477985

PW SOC Code

15-1121

PW SOC Title

Computer System Analysts

PW Skill Level

Level IV

PW Wage

96325.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-07-24

PW Expiration Date

2021-06-30

Wage Offer From

96325.00

Wage Offer To

0.00

Average Salary

96325.00

Wage Unit of Pay

Year

Worksite Address 1

6770 Edmond Street

Worksite Address 2

Worksite City

Las Vegas

Worksite City Slug

las-vegas

Worksite State

NEVADA

Worksite Postal Code

89118

Job Title

Senior Business Intelligence Developer

Job Title Slug

senior-business-intelligence-developer

Minimum Education

Bachelor's

Major Field of Study

Computer Science or related field (Incl. Electronic, Electrical or Computer Engineering)

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer Science or related field Incl. Electronic, Electrical or Computer Engineering

Accept Alternative Combination

Y

Accept Alternative Combination Education

Other

Accept Alternative Combination Education Years

9

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

60

Accept Alternative Job Title

BI Dev.,Programmer Analyst,App. Dev.,Systems Analyst,Software Dev.,Software Eng. or rltd position

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Bachelors Degree or foreign equivalent degree in computer science or related field incl. electronic, electrical or computer engineering. Employer will accept one 1 year of related experience in lieu of one 1 year of education. Requires 5 years of experience as BI Developer, Programmer Analyst, Application Developer, Systems Analyst, Software Developer, Software Engineer or related position. Also requires the following experiencebr br 5 years in Relational star and snowflake schemas;br 5 years in Cognos BI Suite, Cognos BI Administration, Cognos TM1, Cognos Finance;br 1 year in Spotfire;br 5 years in Design and develop complex SQLPLSQL queries within Teradata, SQL server, Oracle DB2 database environments;br 1 year in Power BI, OBIEE and SAS BI;br 5 years Relational and multidimensional OLAP data modeling;br 5 years in Data warehousing and data mart architecting; andbr 5 years in MDX expressions.

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

SWA Job Order End Date

2020-12-09

Sunday Edition Newspaper

Y

First Newspaper Name

Las Vegas ReviewJournal

First Advertisement Start Date

2020-11-01

Second Newspaper Ad Name

Las Vegas ReviewJournal

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-11-08

Employer Website From Date

2021-01-01 09:45:00

Employer Website To Date

2021-01-01 09:45:00

Professional Organization Ad From Date

2021-01-01 09:45:00

Professional Organization Advertisement To Date

2021-01-01 09:45:00

Job Search Website From Date

2020-11-04

Job Search Website To Date

2020-11-10

Employee Referral Program From Date

2021-01-01 09:45:00

Employee Referral Program To Date

2021-01-01 09:45:00

Local Ethnic Paper From Date

2020-11-04

Local Ethnic Paper To Date

2020-11-04

Radio/TV Ad From Date

2020-11-17

Radio/TV Ad To Date

2020-11-17

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

BACHELOR OF ENGINEERING IN ELECTRICAL AND ELECTRONICS

Foreign Worker Years of Education Completed

2006

Foreign Worker Institution of Education

VISVESWARAYA TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Institution Address 1

JNANA SANGAMA, VTU MAIN RD, VISVESVARAYA TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

MACHHE, BELGAUM

Foreign Worker Education Institution State/Province

KARNATAKA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

590018

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Ann Louise Cauble

Preparer Title

Attorney

Preparer Email

ann.cauble@ogletree.com

Employer Information Declaration Name

Jacob Cherian

Employer Information Declaration Title

Digital Eng. Intel. Dir. IT Info Mgmt