Fiscal Year

2021

Case Number

A-20363-36974

Case Status

Certified

Received Date

2021-01-26

Decision Date

2021-06-30

Refile

N

Original File Date

2021-01-01 09:44:33

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

TRANSFORM SEARS HOME SERVICES LLC

Employer Name Slug

transform-sears-home-services-llc

Employer Address 1

3333 BEVERLY ROAD

Employer Address 2

Employer City

HOFFMAN ESTATES

Employer City Slug

hoffman-estates

Employer State

ILLINOIS

Employer State Slug

illinois

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

60179

Employer Phone

(847) 286-5921

Employer Number of Employees

45000

Employer Year Commenced Business

2019

NAICS Code

45211

FW Ownership Interest

N

Employer Contact Name

Raymond G Covarrubias

Employer Contact Address 1

3333 Beverly Road

Employer Contact Address 2

Employer Contact City

Hoffman Estates

Employer Contact State/Province

ILLINOIS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

60179

Employer Contact Phone

(847) 286-2500

Employer Contact Email

Raymond.Covarrubias@transformco.com

Agent Attorney Name

Michelle Gergerian

Agent Attorney Firm Name

Seyfarth Shaw LLP

Agent Attorney Phone

(617) 946-4983

Agent Attorney Address 1

2 Seaport Lane Seaport East

Agent Attorney Address 2

Suite 300

Agent Attorney City

Boston

Agent Attorney State/Province

MASSACHUSETTS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

2210

Agent Attorney Email

mgergerian@seyfarth.com

PW Track Number

P10020147601696

PW SOC Code

11-9121

PW SOC Title

Natural Sciences Managers

PW Skill Level

Level II

PW Wage

101421.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-09-15

PW Expiration Date

2021-06-30

Wage Offer From

115378.00

Wage Offer To

0.00

Average Salary

115378.00

Wage Unit of Pay

Year

Worksite Address 1

3333 Beverly Road

Worksite Address 2

Worksite City

Hoffman Estates

Worksite City Slug

hoffman-estates

Worksite State

ILLINOIS

Worksite Postal Code

60179

Job Title

Senior Manager, Planning and Analytics

Job Title Slug

senior-manager-planning-and-analytics

Minimum Education

Master's

Major Field of Study

Ops. Management, Industrial Admin., Business Admin., Data Analytics, Finance or related

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

5

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

36

Accept Alternative Job Title

Please see H.11.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

1 Demonstrated Expertise quot;DEquot; performing business analytics and data management within the home services industry using SQL Teradata, Snowflake, and BigQuery to produce concise conclusions from raw data and drive solutions according to business requirements;br br 2 DE performing sales and operations planning, including demand forecasting using time series modelling R and SAS and capacity planning to meet forecasted demand and desired service levels;br br 3 DE performing regression analysis MATLAB, optimization techniques Gurobi and simulation models to run business scenarios Monte Carlo and analyze different outcomes to enable decision making;br br 4 DE performing data modelling, analytics and reporting Tableau, Sigma, and Excel that assist in operational improvement of key business KPIs; andbr br 5 DE performing field service management, including scheduling, routing and dispatch to assist in effectively managing a national field workforce with cost minimization techniques.

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-25

SWA Job Order End Date

2020-09-25

Sunday Edition Newspaper

Y

First Newspaper Name

Chicago Tribune

First Advertisement Start Date

2020-08-30

Second Newspaper Ad Name

Chicago Tribune

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-09-13

Employer Website From Date

2020-08-11

Employer Website To Date

2020-09-25

Professional Organization Ad From Date

2021-01-01 09:44:33

Professional Organization Advertisement To Date

2021-01-01 09:44:33

Job Search Website From Date

2020-08-24

Job Search Website To Date

2020-08-31

Employee Referral Program From Date

2020-08-11

Employee Referral Program To Date

2020-08-27

Local Ethnic Paper From Date

2021-01-01 09:44:33

Local Ethnic Paper To Date

2021-01-01 09:44:33

Radio/TV Ad From Date

2021-01-01 09:44:33

Radio/TV Ad To Date

2021-01-01 09:44:33

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

INDUSTRIAL ADMINISTRATION

Foreign Worker Years of Education Completed

2013

Foreign Worker Institution of Education

PURDUE UNIVERSITY

Foreign Worker Education Institution Address 1

610 PURDUE MALL

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

WEST LAFAYETTE

Foreign Worker Education Institution State/Province

IN

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

47907

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Michelle Gergerian

Preparer Title

Attorney

Preparer Email

mgergerian@seyfarth.com

Employer Information Declaration Name

Raymond Covarrubias

Employer Information Declaration Title

Manager, Human Resources