Fiscal Year

2021

Case Number

A-20357-35994

Case Status

Certified

Received Date

2021-01-26

Decision Date

2021-07-06

Refile

N

Original File Date

2021-01-01 09:46:12

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

VIZIENT, INC.

Employer Name Slug

vizient-inc

Employer Address 1

290 E. JOHN CARPENTER FREEWAY

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

75062

Employer Phone

9728307861

Employer Number of Employees

1604

Employer Year Commenced Business

1977

NAICS Code

55111

FW Ownership Interest

N

Employer Contact Name

Emily Brewer

Employer Contact Address 1

290 E. John Carpenter Freeway

Employer Contact Address 2

Employer Contact City

Irving

Employer Contact State/Province

TEXAS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

75062

Employer Contact Phone

9728307861

Employer Contact Email

emily.brewer@vizientinc.com

Agent Attorney Name

Cindy K Ansbach

Agent Attorney Firm Name

JMA Firm, PLLC

Agent Attorney Phone

9725216650

Agent Attorney Address 1

12655 North Central Expressway, Suite 275

Agent Attorney Address 2

Agent Attorney City

Dallas

Agent Attorney State/Province

TEXAS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

75243

Agent Attorney Email

cindy@agfirm.net

PW Track Number

P10020119525382

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level II

PW Wage

93558.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-08-13

PW Expiration Date

2021-06-30

Wage Offer From

107887.50

Wage Offer To

0.00

Average Salary

107887.50

Wage Unit of Pay

Year

Worksite Address 1

290 E. John Carpenter Freeway

Worksite Address 2

Worksite City

Irving

Worksite City Slug

irving

Worksite State

TEXAS

Worksite Postal Code

75062

Job Title

Senior Software Engineer

Job Title Slug

senior-software-engineer

Minimum Education

Master's

Major Field of Study

Computer Science or Engineering

Required Training

N

Required Experience

Y

Required Experience Months

24

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer or Management Information Systems, Software Engineering, Electrical Engineering, or related

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

5

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

24

Accept Alternative Job Title

Engineer or related

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Requires Masters degree in Computer Science or Engineering, Computer or Management Information Systems, Software Engineering, Electrical Engineering, or related field plus 2 years experience in job offered or 2 years experience in related occupation utilizing experience in identifying and analyzing user requirements and performing research and analysis; creating databases; creating ETL using SSIS solutions to load databases; designing, developing and debugging unit test programs for commercial release of development applications; and designing and developing reporting using SSRS solutions; developing ETL SSIS packages to load data warehouse from different data sources; performance tuning; query optimization and execution plan of longrunning TSQL queries; fine tuning SQL Server Databases; dynamic data validation methods during stage load; implementing error handling, logging and rolling back process in ETL Load; and creating stored procedures, triggers, indexes, user defined function and constraints on various database objects to obtain required results. Also requires 2 years experience in the following designing and developing multidimensional and Tabular model SSAS cubes.; overall architecture for building data reporting structure; reporting tools including PowerBI, Tableau, Micro Strategy; data modeling tools ERWIN and Power Designer; building cognitive models including data warehouse, data mart and data lake designs for analytical solutions and realtime data based on enterprise data strategy; and developing and implementing tactical and strategic data warehousing solution. In lieu of Masters degree, employer will accept Bachelors degree in above listed fields plus 5 years of progressive work experience in related occupation. Experience may be gained concurrently. Employer will accept any suitable combination of education, training or experience.br br BUSINESS NECESSITY The position requires the above listed academic qualifications and work experience in order for the Senior Software Engineer to be capable of performing the subject job duties detailed above in a normally accepted manner. The nature of the position requires providing advanced capabilities in solving complex business problems and creating solutions for the companys core areas including healthcare, pharmaceutical, medical and integrated health delivery networks. Understanding the process and problemsolving techniques for business processes as well as using the latest information technology are key to the offered position. The subject position is not a runofthe mill or even entry level position. Rather, this position requires multifaceted and complex job duties that involve coordinating projects, taking responsibility for projects, and communicating with senior management and other departments both formally and informally to ensure that their needs and requirements are met. Such position requires the above preparation and related skills which cannot be obtained during a reasonable period of onthejob training.br br NO FAMILIAL RELATIONSHIPS Please note that there are no familial relationships between parties with ownership interests in the sponsoring organization and the foreign worker, and there is no investment in the sponsoring employer by the foreign worker. Accordingly, the foreign worker does not have an ownership interest in the sponsoring organization, and there is no familial relationship between the stockholders, officers, incorporators or board members and the foreign worker. Further, the foreign worker is not one of a small number of employees. As such, the subject position is a bona fide job opportunity available to all U.S. workers.

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-09-04

SWA Job Order End Date

2020-10-04

Sunday Edition Newspaper

Y

First Newspaper Name

The Dallas Morning News

First Advertisement Start Date

2020-09-27

Second Newspaper Ad Name

The Dallas Morning News

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-10-04

Employer Website From Date

2020-09-03

Employer Website To Date

2020-09-18

Professional Organization Ad From Date

2021-01-01 09:46:12

Professional Organization Advertisement To Date

2021-01-01 09:46:12

Job Search Website From Date

2021-01-01 09:46:12

Job Search Website To Date

2021-01-01 09:46:12

Employee Referral Program From Date

2020-09-03

Employee Referral Program To Date

2020-09-18

Local Ethnic Paper From Date

2021-01-01 09:46:12

Local Ethnic Paper To Date

2021-01-01 09:46:12

Radio/TV Ad From Date

2020-09-29

Radio/TV Ad To Date

2020-09-30

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

2009

Foreign Worker Institution of Education

HERGUAN UNIVERSITY

Foreign Worker Education Institution Address 1

595 LAWRENCE EXPRESSWAY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

SUNNYVALE

Foreign Worker Education Institution State/Province

CA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

94085

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Cindy K Ansbach

Preparer Title

Attorney

Preparer Email

cindy@agfirm.net

Employer Information Declaration Name

Alec Scroggins

Employer Information Declaration Title

Senior Vice President, Human Resources