All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20052-22032
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20052-22032
Case Status
Certified-Expired
Received Date
2020-02-28
Decision Date
2021-01-20
Refile
N
Original File Date
2021-01-01 08:58:04
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
TRANSUNION, LLC
Employer Name Slug
transunion-llc
Employer Address 1
555 W. ADAMS STREET
Employer Address 2
10TH FLOOR
Employer City
CHICAGO
Employer City Slug
chicago
Employer State
ILLINOIS
Employer State Slug
illinois
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
60661
Employer Phone
312.985.3856
Employer Number of Employees
4000
Employer Year Commenced Business
1969
NAICS Code
561450
FW Ownership Interest
N
Employer Contact Name
Rebecca Harvey
Employer Contact Address 1
555 W. Adams Street
Employer Contact Address 2
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
60661
Employer Contact Phone
312.985.2551
Employer Contact Email
rebecca.harvey@transunion.com
Agent Attorney Name
Theresa A Corcoran
Agent Attorney Firm Name
Kempster, Corcoran, Quiceno LenzCalvo, LTD
Agent Attorney Phone
3123419730
Agent Attorney Address 1
332 S. Michigan Ave
Agent Attorney Address 2
Suite 1428
Agent Attorney City
Chicago
Agent Attorney State/Province
ILLINOIS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
60604
Agent Attorney Email
theresac@klc-ltd.com
PW Track Number
P10019136661912
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level IV
PW Wage
114483.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-08-29
PW Expiration Date
2020-06-30
Wage Offer From
114483.00
Wage Offer To
0.00
Average Salary
114483.00
Wage Unit of Pay
Year
Worksite Address 1
555 W Adams Street
Worksite Address 2
Worksite City
Chicago
Worksite City Slug
chicago
Worksite State
ILLINOIS
Worksite Postal Code
60661
Job Title
Sr. Consultant
Job Title Slug
sr-consultant
Minimum Education
Master's
Major Field of Study
Computer Science or Information Technology or related field
Required Training
N
Required Experience
Y
Required Experience Months
60
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
7
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
database administration
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Required Skills SQL database administration, installation, configuration, capacity management, troubleshooting, design, performance tuning, analysis, query optimization on standalone and server clustered DBs; with Managed Infrastructure services Platform; implementing SQL Server Availability groups and very large 20TB for OLTP and OLAP; experience in database migration from lower version to higher version of SQL Server; Design, implement comprehensive backup plan and disaster recovery strategies, SQL Server replication models Peer to Peer, Transactional and Merge; installation and configuration of ActiveActive and ActivePassive clusters; SQL Serverdatabase Mirroring and Security Administration Policy and Authentication; version control. Willing to be on 247 rotation call. 60 telecommuting permitted. Masters degree in Computer Science or Information Technology or related field plus 5 years of experience in the job offered or in database administration OR Bachelors degree Computer Science or Information Technology or related field plus 7 years of progressive experience in the job offered or in database administration required.
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-11
SWA Job Order End Date
2020-01-12
Sunday Edition Newspaper
Y
First Newspaper Name
The Chicago SunTimes
First Advertisement Start Date
2019-12-22
Second Newspaper Ad Name
The Chicago SunTimes
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-12-29
Employer Website From Date
2021-01-01 08:58:04
Employer Website To Date
2021-01-01 08:58:04
Professional Organization Ad From Date
2021-01-01 08:58:04
Professional Organization Advertisement To Date
2021-01-01 08:58:04
Job Search Website From Date
2019-12-23
Job Search Website To Date
2020-01-06
Employee Referral Program From Date
2021-01-01 08:58:04
Employee Referral Program To Date
2021-01-01 08:58:04
Local Ethnic Paper From Date
2019-12-26
Local Ethnic Paper To Date
2019-12-26
Radio/TV Ad From Date
2021-01-01 08:58:04
Radio/TV Ad To Date
2021-01-01 08:58:04
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
BUSINESS ADMINISTRATION INFORMATION TECHNOLOGY
Foreign Worker Years of Education Completed
2011
Foreign Worker Institution of Education
PUNJAB TECHNICAL UNIVERSITY
Foreign Worker Education Institution Address 1
CO I.K. GUJRAL PUNJAB TECHNICAL UNIVERSITY
Foreign Worker Education Institution Address 2
JALANDHAR KAPURTHALA HIGHWAY,VPO IBBAN
Foreign Worker Education Institution City
KAPURTHALA
Foreign Worker Education Institution State/Province
PUNJAB
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
144603
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Theresa A Corcoran
Preparer Title
Attorney at Law
Preparer Email
theresac@klc-ltd.com
Employer Information Declaration Name
Rebecca Harvey
Employer Information Declaration Title
Sr. Analyst, Benefits