All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-23044-00959
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-23044-00959
Case Status
Certified
Received Date
2023-03-24
Decision Date
2024-04-04
Refile
N
Original File Date
2024-01-01 00:59:07
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
ENCORE
Employer Name Slug
encore
Employer Address 1
5100 N. RIVER ROAD
Employer Address 2
300
Employer City
SCHILLER PARK
Employer City Slug
schiller-park
Employer State
ILLINOIS
Employer State Slug
illinois
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
60176
Employer Phone
6308869821
Employer Number of Employees
8200
Employer Year Commenced Business
1937
NAICS Code
532210
FW Ownership Interest
N
Employer Contact Name
Robert Caldrone
Employer Contact Address 1
5100 N. River Road
Employer Contact Address 2
300
Employer Contact City
Schiller Park
Employer Contact State/Province
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
60176
Employer Contact Phone
6308869821
Employer Contact Email
robert.caldrone@encoreglobal.com
Agent Attorney Name
Jennifer Cofer
Agent Attorney Firm Name
Ogletree, Deakins, Nash, Smoak Stewart, P.C.
Agent Attorney Phone
9197603000
Agent Attorney Address 1
8529 Six Forks Road
Agent Attorney Address 2
Forum IV, Suite 600
Agent Attorney City
Raleigh
Agent Attorney State/Province
NORTH CAROLINA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
27615
Agent Attorney Email
Jennifer.cofer@ogletreedeakins.com
PW Track Number
P10022166282665
PW SOC Code
15-1242.00
PW SOC Title
Database Administrators
PW Skill Level
Level II
PW Wage
78187.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-12-28
PW Expiration Date
2023-06-30
Wage Offer From
120000.00
Wage Offer To
0.00
Average Salary
120000.00
Wage Unit of Pay
Year
Worksite Address 1
5100 North River Rd
Worksite Address 2
Suite 300
Worksite City
Schiller Park
Worksite City Slug
schiller-park
Worksite State
ILLINOIS
Worksite Postal Code
60176
Job Title
Database Admin SQL
Job Title Slug
database-admin-sql
Minimum Education
Bachelor's
Major Field of Study
Computer Science
Required Training
N
Required Experience
Y
Required Experience Months
36
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Computer Engineering or related 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
36
Accept Alternative Job Title
in the job offered or related occupation
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Applicants must have demonstrated experience withbr br TSQL Development and Tuning Skills;br InstallingAdministering Clustered MSSQL;br Migrating to Newer Versions of SQL Server;br Replication Technologies Transactional, Merge in a Production Environment;br Dimensional and Relational Modeling;br SAN Concepts and Physical Array Design;br Microsoft SecurityAuthentication Concepts Active Directory, IIS, Windows OS;br MSSQL Technologies outside relational engine SSIS, SSRS, and SSAS;br Data Mart ETL Dimensions and Facts; andbr MOF and MSF Process Frameworks.
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
2022-12-14
SWA Job Order End Date
2023-01-19
Sunday Edition Newspaper
Y
First Newspaper Name
Chicago SunTimes
First Advertisement Start Date
2023-01-08
Second Newspaper Ad Name
Chicago SunTimes
Second Advertisement Type
Newspaper
Second Ad Start Date
2023-01-15
Employer Website From Date
2024-01-01 00:59:07
Employer Website To Date
2024-01-01 00:59:07
Professional Organization Ad From Date
2024-01-01 00:59:07
Professional Organization Advertisement To Date
2024-01-01 00:59:07
Job Search Website From Date
2023-01-08
Job Search Website To Date
2023-01-22
Employee Referral Program From Date
2024-01-01 00:59:07
Employee Referral Program To Date
2024-01-01 00:59:07
Local Ethnic Paper From Date
2023-01-12
Local Ethnic Paper To Date
2023-01-12
Radio/TV Ad From Date
2023-01-12
Radio/TV Ad To Date
2023-01-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
COMPUTER SCIENCE
Foreign Worker Years of Education Completed
2017
Foreign Worker Institution of Education
LOYOLA UNIVERSITY CHICAGO
Foreign Worker Education Institution Address 1
1032 W SHERIDAN RD
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
CHICAGO
Foreign Worker Education Institution State/Province
IL
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
60660
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Jennifer Cofer
Preparer Title
Attorney
Preparer Email
jennifer.cofer@ogletreedeakins.com
Employer Information Declaration Name
Robert Caldrone
Employer Information Declaration Title
Vice President, Talent Acquistion