All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20100-41452
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20100-41452
Case Status
Certified-Expired
Received Date
2020-05-05
Decision Date
2020-10-13
Refile
N
Original File Date
2021-01-01 08:45:45
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
CHRISTUS HEALTH
Employer Name Slug
christus-health
Employer Address 1
919 HIDDEN RIDGE
Employer Address 2
Employer City
IRVING
Employer City Slug
irving
Employer State
TEXAS
Employer State Slug
texas
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
75038
Employer Phone
469-282-2001
Employer Number of Employees
30000
Employer Year Commenced Business
1999
NAICS Code
6221
FW Ownership Interest
N
Employer Contact Name
Amelia Litterio
Employer Contact Address 1
919 Hidden Ridge
Employer Contact Address 2
Employer Contact City
Irving
Employer Contact State/Province
TEXAS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
75038
Employer Contact Phone
469-282-2408
Employer Contact Email
amelia.litterio@christushealth.org
Agent Attorney Name
Karen H Courreges
Agent Attorney Firm Name
Ogletree Deakins
Agent Attorney Phone
7136555777
Agent Attorney Address 1
One Allen Center, 500 Dallas Street
Agent Attorney Address 2
Suite 3000
Agent Attorney City
Houston
Agent Attorney State/Province
TEXAS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
77002
Agent Attorney Email
Karen.Courreges@ogletreedeakins.com
PW Track Number
P10019212031483
PW SOC Code
15-1132
PW SOC Title
Software Developer Applications
PW Skill Level
Level IV
PW Wage
127712.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-11-25
PW Expiration Date
2020-06-30
Wage Offer From
129001.60
Wage Offer To
0.00
Average Salary
129001.60
Wage Unit of Pay
Year
Worksite Address 1
919 Hidden Ridge
Worksite Address 2
Worksite City
Irving
Worksite City Slug
irving
Worksite State
TEXAS
Worksite Postal Code
75038
Job Title
Health Plan Data Architect
Job Title Slug
health-plan-data-architect
Minimum Education
Bachelor's
Major Field of Study
Inf tech, comp sc, eng 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
N
Accept Alternative Combination Education
Accept Alternative Combination Education Years
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
pos in job offered or rltd pos w lg corp systems envirments wrkg w lg and complex data warehouse sys
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Work experience must includebr 1. Five 5 years of Health Plan carrier or Health Insurance data experience and working knowledge of Health Plan standard data typesclaims.br 2. Five 5 years of experience working with relational databases RDBMS like MS SQL ServerMy SQL in large data environment.br 3. Five 5 years of experience in writing complex ETL packages and data flows in SSIS andor other ETL tools.br 4. Five 5 years of handson experience in database and SQL performance tuning.br 5. Three 3 years of experience in designing developing logical physical data model using Kimballs methodology of Star Schema.
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-18
SWA Job Order End Date
2020-01-22
Sunday Edition Newspaper
Y
First Newspaper Name
Dallas Morning News
First Advertisement Start Date
2019-12-15
Second Newspaper Ad Name
Dallas Morning News
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-12-22
Employer Website From Date
2021-01-01 08:45:45
Employer Website To Date
2021-01-01 08:45:45
Professional Organization Ad From Date
2021-01-01 08:45:45
Professional Organization Advertisement To Date
2021-01-01 08:45:45
Job Search Website From Date
2019-12-19
Job Search Website To Date
2020-01-02
Employee Referral Program From Date
2021-01-01 08:45:45
Employee Referral Program To Date
2021-01-01 08:45:45
Local Ethnic Paper From Date
2020-01-03
Local Ethnic Paper To Date
2020-01-09
Radio/TV Ad From Date
2019-12-27
Radio/TV Ad To Date
2019-12-27
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
MECHANICAL ENGINEERING
Foreign Worker Years of Education Completed
2006
Foreign Worker Institution of Education
NORTHERN ILLINOIS UNIVERSITY
Foreign Worker Education Institution Address 1
1425 LINCOLN HWY
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
DEKALB
Foreign Worker Education Institution State/Province
IL
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
60115
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Karen Courreges
Preparer Title
Attorney
Preparer Email
karen.courreges@ogletreedeakins.com
Employer Information Declaration Name
Amelia Litterio
Employer Information Declaration Title
HR Compliance Analyst