All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21008-40319
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21008-40319
Case Status
Certified-Expired
Received Date
2021-02-19
Decision Date
2022-01-10
Refile
N
Original File Date
2022-01-01 10:44:34
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
Blue Cross and Blue Shield of Kansas City
Employer Name Slug
blue-cross-and-blue-shield-of-kansas-city
Employer Address 1
2301 Main St.
Employer Address 2
Employer City
Kansas City
Employer City Slug
kansas-city
Employer State
MISSOURI
Employer State Slug
missouri
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
64108
Employer Phone
816-395-2222
Employer Number of Employees
1411
Employer Year Commenced Business
1938
NAICS Code
524114
FW Ownership Interest
N
Employer Contact Name
Mikala Allen
Employer Contact Address 1
2301 Main St.
Employer Contact Address 2
Employer Contact City
Kansas City
Employer Contact State/Province
MISSOURI Blue Cross and Blue Shield of Kansas City
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
64108
Employer Contact Phone
8163952560
Employer Contact Email
mikala.allen@bluekc.com
Agent Attorney Name
Samantha Wolfe
Agent Attorney Firm Name
Ogletree Deakins
Agent Attorney Phone
303-764-6831
Agent Attorney Address 1
2000 South Colorado Blvd
Agent Attorney Address 2
Tower 3, Suite 900
Agent Attorney City
Denver
Agent Attorney State/Province
COLORADO
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
80222
Agent Attorney Email
samantha.wolfe@ogletree.com
PW Track Number
P10020108497582
PW SOC Code
15-1199
PW SOC Title
Business Intelligence Analysts
PW Skill Level
Level III
PW Wage
85966.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-08-04
PW Expiration Date
2021-06-30
Wage Offer From
85966.00
Wage Offer To
114016.00
Average Salary
99991.00
Wage Unit of Pay
Year
Worksite Address 1
2301 Main Street
Worksite Address 2
5th Floor
Worksite City
Kansas City
Worksite City Slug
kansas-city
Worksite State
MISSOURI
Worksite Postal Code
64108
Job Title
Business Intelligence Solution Engineer
Job Title Slug
business-intelligence-solution-engineer
Minimum Education
Master's
Major Field of Study
Computer Science
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Computer Engineering, Information Technology Management, or related field
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
Business Intelligence Developer, SAP BO Developer, or related occupation in the health care industry
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Position requires 3 years of postbachelors experience which must include some experience in each of the following skills Delivering Business Intelligence Solutions; OLTP and OLAP database models; SAP Business Object; Tableau or Power BI; Designing multidimensional data models using Star and Snowflake schemas for analytical use; Using SQL to write complex queries, query optimization, error and event handling, and stored procedures; and DB2 and Microsoft SQL Server.
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-27
SWA Job Order End Date
2020-09-25
Sunday Edition Newspaper
Y
First Newspaper Name
Kansas City Star
First Advertisement Start Date
2020-08-30
Second Newspaper Ad Name
Kansas City Star
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-09-06
Employer Website From Date
2020-09-11
Employer Website To Date
2020-09-24
Professional Organization Ad From Date
2022-01-01 10:44:34
Professional Organization Advertisement To Date
2022-01-01 10:44:34
Job Search Website From Date
2022-01-01 10:44:34
Job Search Website To Date
2022-01-01 10:44:34
Employee Referral Program From Date
2022-01-01 10:44:34
Employee Referral Program To Date
2022-01-01 10:44:34
Local Ethnic Paper From Date
2020-09-02
Local Ethnic Paper To Date
2020-09-02
Radio/TV Ad From Date
2020-08-31
Radio/TV Ad To Date
2020-08-31
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
INFORMATION TECHNOLOGY MANAGEMENT
Foreign Worker Years of Education Completed
2017
Foreign Worker Institution of Education
CAMPBELLSVILLE UNIVERSITY
Foreign Worker Education Institution Address 1
1 UNIVERSITY DR
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
CAMPBELLSVILLE
Foreign Worker Education Institution State/Province
KY
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
42718
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Samantha Wolfe
Preparer Title
Attorney
Preparer Email
samantha.wolfe@ogletree.com
Employer Information Declaration Name
Mikala Allen
Employer Information Declaration Title
HR Recruiter Lead