Fiscal Year

2020

Case Number

A-19302-76746

Case Status

Certified

Received Date

2019-11-19

Decision Date

2020-04-10

Refile

N

Original File Date

2020-01-01 08:13:12

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

DELOITTE TOUCHE TOHMATSU SERVICES INC.

Employer Name Slug

deloitte-touche-tohmatsu-services-inc

Employer Address 1

1221 AVENUE OF AMERICAS

Employer Address 2

39TH FLOOR

Employer City

NEW YORK

Employer City Slug

new-york

Employer State

NEW YORK

Employer State Slug

new-york

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

10020

Employer Phone

610-479-3255

Employer Number of Employees

41000

Employer Year Commenced Business

1981

NAICS Code

54121

FW Ownership Interest

N

Employer Contact Name

Maryanne Page

Employer Contact Address 1

1700 Market Street

Employer Contact Address 2

Employer Contact City

Philadelphia

Employer Contact State/Province

PENNSYLVANIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

19103

Employer Contact Phone

610-479-3255

Employer Contact Email

mapage@deloitte.com

Agent Attorney Name

Rebecca F Michaels

Agent Attorney Firm Name

GARSON LLP

Agent Attorney Phone

4165507495

Agent Attorney Address 1

22 Adelaide Street West

Agent Attorney Address 2

9th Floor

Agent Attorney City

TORONTO

Agent Attorney State/Province

ONTARIO

Agent Attorney Country

CANADA

Agent Attorney Postal Code

M5H 4E3

Agent Attorney Email

rmichaels@ggilaw.com

PW Track Number

P10019028738646

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level III

PW Wage

111696.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-09-17

PW Expiration Date

2020-06-30

Wage Offer From

141773.00

Wage Offer To

0.00

Average Salary

141773.00

Wage Unit of Pay

Year

Worksite Address 1

695 E. Main Street

Worksite Address 2

Worksite City

STAMFORD

Worksite City Slug

stamford

Worksite State

CONNECTICUT

Worksite Postal Code

6901

Job Title

Senior Database Analyst, Data Quality Programming

Job Title Slug

senior-database-analyst-data-quality-programming

Minimum Education

Master's

Major Field of Study

Computer Science, Engineering any, CIS, or related field

Required Training

N

Required Experience

Y

Required Experience Months

36

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer Science, Engineering any, CIS, or related field

Accept Alternative Combination

N

Accept Alternative Combination Education

Accept Alternative Combination Education Years

Accept Foreign Education

N

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

36

Accept Alternative Job Title

Database Analyst, Software Developer or related

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Masters degree in Computer Science, Engineering any, CIS, or related field.br Three years of experience in delivering information technology solutions.br Must have three years of experience inbr o Designing and developing database using SQL server business intelligence development and SQL data tools to extract and transform data into structured forms for querying and analysis;br o Implementing SQL Server stored procedures, triggers, indexes, views, and functions utilizing Transact SQL in Microsoft SQL Server Management Studio;br o Using PowerShell scripting to automate and improve storage capability;br o Designing User Interface using Win Forms, Web Forms, and programming C#.NET, ASP.NET and Microsoft Access;br o Scheduling SQL jobs and setting up subscriptions for SQL server Reporting services report using Microsoft SQL Server Management Studio and Microsoft SQL Server Data;br o Extracting, Transforming and Loading ETL data from Microsoft Excel, flat file and Microsoft Access to SQL Server using BCP utility and SSISDTS packages;br o Creating Tableau dashboards and preparing user stories to deliver actionable insights from SQL, Access and Excel data sources;br o Processing data from complex data sources using Python; andbr o Performing SQL migration from SQL server 2008 R2 to SQL servers 201220142016.

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

SWA Job Order End Date

2019-08-19

Sunday Edition Newspaper

Y

First Newspaper Name

STAMFORD ADVOCATE

First Advertisement Start Date

2019-07-21

Second Newspaper Ad Name

STAMFORD ADVOCATE

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-07-28

Employer Website From Date

2019-07-12

Employer Website To Date

2019-09-20

Professional Organization Ad From Date

2020-01-01 08:13:12

Professional Organization Advertisement To Date

2020-01-01 08:13:12

Job Search Website From Date

2019-07-19

Job Search Website To Date

2019-07-26

Employee Referral Program From Date

2019-07-12

Employee Referral Program To Date

2019-08-02

Local Ethnic Paper From Date

2020-01-01 08:13:12

Local Ethnic Paper To Date

2020-01-01 08:13:12

Radio/TV Ad From Date

2020-01-01 08:13:12

Radio/TV Ad To Date

2020-01-01 08:13:12

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

ELECTRICAL AND COMPUTER ENGINEERING

Foreign Worker Years of Education Completed

2012

Foreign Worker Institution of Education

THE UNIVERSITY OF FLORIDA

Foreign Worker Education Institution Address 1

222 CRISER HALL, BOX 114000

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

GAINESVILLE

Foreign Worker Education Institution State/Province

FL

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

32611

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

REBECCA F MICHAELS

Preparer Title

SENIOR ATTORNEY

Preparer Email

RMICHAELS@GGILAW.COM

Employer Information Declaration Name

MARYANNE PAGE

Employer Information Declaration Title

COMPENSATION MANAGER