All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20220-86104
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20220-86104
Case Status
Certified
Received Date
2020-08-31
Decision Date
2021-04-08
Refile
N
Original File Date
2021-01-01 09:11:39
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
SPECTRUM HEALTH SYSTEM
Employer Name Slug
spectrum-health-system
Employer Address 1
100 MICHIGAN ST NE
Employer Address 2
Employer City
GRAND RAPIDS
Employer City Slug
grand-rapids
Employer State
MICHIGAN
Employer State Slug
michigan
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
49501
Employer Phone
616 486-4032
Employer Number of Employees
31000
Employer Year Commenced Business
1997
NAICS Code
62111
FW Ownership Interest
N
Employer Contact Name
Jill K Soubel Walsh
Employer Contact Address 1
444 Michigan St. NE
Employer Contact Address 2
MC050
Employer Contact City
Grand Rapids
Employer Contact State/Province
MICHIGAN
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
49503
Employer Contact Phone
616-391-3963
Employer Contact Email
jill.soubelwalsh@spectrumhealth.org
Agent Attorney Name
Agent Attorney Firm Name
Agent Attorney Phone
Agent Attorney Address 1
Agent Attorney Address 2
Agent Attorney City
Agent Attorney State/Province
Agent Attorney Country
Agent Attorney Postal Code
Agent Attorney Email
PW Track Number
P10020072401778
PW SOC Code
15-1199
PW SOC Title
Business Intelligence Analyst
PW Skill Level
Level II
PW Wage
57803.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-07-24
PW Expiration Date
2021-06-30
Wage Offer From
80537.60
Wage Offer To
0.00
Average Salary
80537.60
Wage Unit of Pay
Year
Worksite Address 1
1239 East Beltline Ave NE
Worksite Address 2
Worksite City
Grand Rapids
Worksite City Slug
grand-rapids
Worksite State
MICHIGAN
Worksite Postal Code
49525
Job Title
Analyst, Business Intelligence Senior
Job Title Slug
analyst-business-intelligence-senior
Minimum Education
Bachelor's
Major Field of Study
MIS, Engineering, Mathematics
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
Master's
Accept Alternative Combination Education Years
0
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
See H.14.
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Cont H.10B ETL Analyst or similar with experience in data analysis, critical problem solving, relational database methodologies and SQL queries, visualization principles, and database architecture principles.br br Required skills EDI 837 format and resolving 999, 277CA MA02 issues; EDI X12 transaction sets EDI 850, 810, 856, transaction envelopingaddressing; Highly skilled in working with CMS systems RAPSEDPS; Demonstrated success in identifying gaps, developing solutions, root cause analysisresolution, build process automation; Application IntegratorAI tool C# coding to resolve EDI issue; Proficiency with XML, XSD and general schema development concepts traditional EDI structures ANSI X12, EDIFECS; Ability to write complex PL SQL queries to validate data for UAT Smoke, regression; Experience in defining requirements, evaluate functional requirement document, review and sign off on change orders, and post production validation testing. High proficiency in Informatica Power Center 10.2, Informatica B2B dx 10.2, Informatica Analyst 10.2 SQL Server 2014, Oracle 11g, TOAD 12.6, SQL Server management Studio 2014, Erwin 8, MS Visio, Power Shell Scripting, Windows 7XP, Unix, Oracle Apex, Tortoise SVN, RPX Reports, Tableau 10.4, CoPilot, CA Change Management, MS Access, MS Excel, Shell, JAVA scripting, SQLPL SQL, Oracle, SQL Server, TOADSQL Developer, Oracle Apex, Oracle RPX reports, and ETL process design, develop highlow level design document, develop STM, ETL mapping development using Informatica power center, developing full and incremental extracts, developing audit frame work, defining file transfer rules and developing DX profiles using B2B. Any suitable combination of education, training, and experience is acceptable.
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-03-25
SWA Job Order End Date
2020-04-29
Sunday Edition Newspaper
Y
First Newspaper Name
The Grand Rapids Press
First Advertisement Start Date
2020-03-29
Second Newspaper Ad Name
The Grand Rapids Press
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-04-05
Employer Website From Date
2020-03-26
Employer Website To Date
2020-04-06
Professional Organization Ad From Date
2021-01-01 09:11:39
Professional Organization Advertisement To Date
2021-01-01 09:11:39
Job Search Website From Date
2020-03-25
Job Search Website To Date
2020-04-08
Employee Referral Program From Date
2021-01-01 09:11:39
Employee Referral Program To Date
2021-01-01 09:11:39
Local Ethnic Paper From Date
2020-03-26
Local Ethnic Paper To Date
2020-03-26
Radio/TV Ad From Date
2021-01-01 09:11:39
Radio/TV Ad To Date
2021-01-01 09:11:39
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
MANAGEMENT INFORMATION SCIENCE
Foreign Worker Years of Education Completed
2014
Foreign Worker Institution of Education
FAIRLEIGH DICKENSON UNIVERSITY
Foreign Worker Education Institution Address 1
1000 RIVER RD.
Foreign Worker Education Institution Address 2
HAT101
Foreign Worker Education Institution City
TEANECK
Foreign Worker Education Institution State/Province
NJ
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
7666
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
Y
Preparer Name
Preparer Title
Preparer Email
Employer Information Declaration Name
JILL K SOUBEL WALSH
Employer Information Declaration Title
SENIOR COUNSEL