Fiscal Year

2022

Case Number

A-22010-95799

Case Status

Withdrawn

Received Date

2022-02-25

Decision Date

2022-03-24

Refile

N

Original File Date

2022-01-01 11:09:18

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

West Penn Allegheny Health System, Inc.

Employer Name Slug

west-penn-allegheny-health-system-inc

Employer Address 1

30 Isabella Street, 2nd Floor

Employer Address 2

Legal Department

Employer City

Pittsburgh

Employer City Slug

pittsburgh

Employer State

PENNSYLVANIA

Employer State Slug

pennsylvania

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

15212

Employer Phone

4123302523

Employer Number of Employees

17000

Employer Year Commenced Business

1999

NAICS Code

62211

FW Ownership Interest

N

Employer Contact Name

Paranjpe Preeti

Employer Contact Address 1

501 Penn Ave

Employer Contact Address 2

Employer Contact City

Pittsburgh

Employer Contact State/Province

PENNSYLVANIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

15222

Employer Contact Phone

412-544-3676

Employer Contact Email

preeti.paranjpe@highmarkhealth.org

Agent Attorney Name

Alexander R Castrodale

Agent Attorney Firm Name

Dentons Cohen Grigsby, P.C.

Agent Attorney Phone

4122974712

Agent Attorney Address 1

625 LIBERTY AVENUE

Agent Attorney Address 2

5TH FLOOR

Agent Attorney City

PITTSBURGH

Agent Attorney State/Province

PENNSYLVANIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

15222

Agent Attorney Email

alex.castrodale@dentons.com

PW Track Number

P10021060107906

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level IV

PW Wage

112611.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-07-22

PW Expiration Date

2022-06-30

Wage Offer From

112611.00

Wage Offer To

112611.00

Average Salary

112611.00

Wage Unit of Pay

Year

Worksite Address 1

501 Penn Avenue Place

Worksite Address 2

Worksite City

Pittsburgh

Worksite City Slug

pittsburgh

Worksite State

PENNSYLVANIA

Worksite Postal Code

15222

Job Title

Developer Business Intelligence, Data Warehousing

Job Title Slug

developer-business-intelligence-data-warehousing

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Information Technology, or a related field

Required Training

N

Required Experience

N

Required Experience Months

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

Postbaccalaureate and progressively responsible experience in a related position

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Must have any experience with or knowledge of i gathering business requirements and system specifications from business operational owners; ii SQL Query Writing and tuning to maximize query performance and efficiency; iii SSIS, SSAS, SSRS, and BIDS; iv troubleshooting and resolving processing issues related to software, hardware, and data andor communication problems; v designing and developingcoding Business Intelligence BI Data Extraction, Transformation and Load ETL packages andor other SQL objects to build robust architecture to organize Data flow from heterogeneoushomogeneous source systems clinical, revenue and others into the Enterprise Data Warehouse andor the Epic Caboodle Data Warehouse; vi designing Star, Snowflake, and more complex data warehouse data models using ER studio or similar tools; vii database optimization and tuning, normalization and data importingexporting; viii peer code review to test functionality before production releases; and ix creating design and troubleshooting documents on a consistent basis. Must be able to work shifts between 630am and 700pm MF as well as 8am430pm SatSun. Must also be able to work 24hour coverage on a rotating shift basis.

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

2021-11-17

SWA Job Order End Date

2021-12-22

Sunday Edition Newspaper

Y

First Newspaper Name

Pittsburgh PostGazette

First Advertisement Start Date

2021-12-05

Second Newspaper Ad Name

Pittsburgh PostGazette

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-12-12

Employer Website From Date

2021-11-17

Employer Website To Date

2022-01-24

Professional Organization Ad From Date

2022-01-01 11:09:18

Professional Organization Advertisement To Date

2022-01-01 11:09:18

Job Search Website From Date

2021-12-06

Job Search Website To Date

2021-12-17

Employee Referral Program From Date

2022-01-01 11:09:18

Employee Referral Program To Date

2022-01-01 11:09:18

Local Ethnic Paper From Date

2021-12-15

Local Ethnic Paper To Date

2021-12-22

Radio/TV Ad From Date

2022-01-01 11:09:18

Radio/TV Ad To Date

2022-01-01 11:09:18

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

ELECTRONICS ENGINEERING

Foreign Worker Years of Education Completed

2006

Foreign Worker Institution of Education

UNIVERSITY OF PUNE

Foreign Worker Education Institution Address 1

GANESHKHIND ROAD

Foreign Worker Education Institution Address 2

GANESHKHIND

Foreign Worker Education Institution City

PUNE

Foreign Worker Education Institution State/Province

MAHARASHTRA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

411007

Foreign Worker Experience with Employer

N/A

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Alex Castrodale

Preparer Title

Attorney

Preparer Email

alex.castrodale@dentons.com

Employer Information Declaration Name

Preeti Paranjpe

Employer Information Declaration Title

Program ManagerImmigration