Fiscal Year

2023

Case Number

A-22045-11247

Case Status

Certified

Received Date

2022-06-21

Decision Date

2023-02-13

Refile

N

Original File Date

2023-01-01 08:07:35

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

THE PNC FINANCIAL SERVICES GROUP

Employer Name Slug

the-pnc-financial-services-group

Employer Address 1

249 5TH AVENUE, ONE PNC PLAZA

Employer Address 2

22ND FLOOR

Employer City

PITTSBURGH

Employer City Slug

pittsburgh

Employer State

PENNSYLVANIA

Employer State Slug

pennsylvania

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

15222

Employer Phone

(412) 768-5133

Employer Number of Employees

59000

Employer Year Commenced Business

1983

NAICS Code

52211

FW Ownership Interest

N

Employer Contact Name

Alexandra Flemming

Employer Contact Address 1

THE PNC FINANCIAL SERVICES GROUP

Employer Contact Address 2

200 Lake Drive East

Employer Contact City

Cherry Hill

Employer Contact State/Province

NEW JERSEY

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

8002

Employer Contact Phone

856-489-2971

Employer Contact Email

alexandra.flemming@pnc.com

Agent Attorney Name

Matthew T Phillips

Agent Attorney Firm Name

Dentons Cohen Grigsby P.C.

Agent Attorney Phone

4122974860

Agent Attorney Address 1

625 Liberty Avenue

Agent Attorney Address 2

Floor 5

Agent Attorney City

Pittsburgh

Agent Attorney State/Province

PENNSYLVANIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

15222

Agent Attorney Email

matthew.t.phillips@dentons.com

PW Track Number

P10021190452843

PW SOC Code

15-2041

PW SOC Title

Statisticians

PW Skill Level

Level I

PW Wage

60861.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-12-09

PW Expiration Date

2022-06-30

Wage Offer From

134000.00

Wage Offer To

0.00

Average Salary

134000.00

Wage Unit of Pay

Year

Worksite Address 1

300 Delaware Ave

Worksite Address 2

Worksite City

Wilmington

Worksite City Slug

wilmington

Worksite State

DELAWARE

Worksite Postal Code

19801

Job Title

Portfolio Analytics & Strategy Specialist

Job Title Slug

portfolio-analytics-strategy-specialist

Minimum Education

Master's

Major Field of Study

Statistics, Economics, Business Administration, Mathematical Finance, or Finance

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

36

Accept Alternative Job Title

Experience conducting data analysis in financial services industry

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Experience required with the following i advanced tools and software including SAS, Teradata SQL, Tableau, advanced MS Excel and PowerPoint; ii handling and transforming Big datasets and performing statistical analytics on such large datasets using Teradata, SAS; Hadoop, or Python; iii statistical modeling using Decision Trees and Data analysis to identify and refine high risk segments and synthesize and lead results with presentations in front of business partners; iv retail lending credit risk management, specific to acquisition and portfolio management risk analysis; v utilizing data query tools including SQL and SAS to mine, analyze and interpret information from credit bureau databases; vi conducting PL profitability and loss analysis on revenue and risk metrics in financial industry; vii writing and implementing SASSQL programs and macros for generating and automating reports to monitor origination and business portfolio performance; viii sourcing and synthesizing data using advanced database management writing complex SQL queries, advanced tools and software including Knowledge Studio, SAS Enterprise Miner, and PowerPoint; and ix preparation of dashboards from analytical data in a server environment using Tableau.br br Note Because there is no primary experience requirement in H.6, the Kellogg language is not required.

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

2022-01-13

SWA Job Order End Date

2022-02-23

Sunday Edition Newspaper

Y

First Newspaper Name

The Philadelphia Inquirer

First Advertisement Start Date

2022-03-06

Second Newspaper Ad Name

The Philadelphia Inquirer

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-03-13

Employer Website From Date

2021-12-29

Employer Website To Date

2022-05-23

Professional Organization Ad From Date

2023-01-01 08:07:35

Professional Organization Advertisement To Date

2023-01-01 08:07:35

Job Search Website From Date

2022-04-07

Job Search Website To Date

2022-04-15

Employee Referral Program From Date

2023-01-01 08:07:35

Employee Referral Program To Date

2023-01-01 08:07:35

Local Ethnic Paper From Date

2022-02-17

Local Ethnic Paper To Date

2022-02-17

Radio/TV Ad From Date

2023-01-01 08:07:35

Radio/TV Ad To Date

2023-01-01 08:07:35

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

CHINA

Foreign Worker Birth Country

CHINA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

STATISTICS

Foreign Worker Years of Education Completed

2010

Foreign Worker Institution of Education

LEHIGH UNIVERSITY

Foreign Worker Education Institution Address 1

27 MEMORIAL DR W

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

BETHLEHEM

Foreign Worker Education Institution State/Province

PA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

18015

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Matthew T Phillips

Preparer Title

Attorney

Preparer Email

matthew.t.phillips@dentons.com

Employer Information Declaration Name

Rachel ODriscoll

Employer Information Declaration Title

Senior Counsel, Employment