All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22252-19231
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22252-19231
Case Status
Certified-Expired
Received Date
2022-12-15
Decision Date
2024-01-26
Refile
N
Original File Date
2024-01-01 00:37:46
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
152223152
Agent Attorney Email
matthew.t.phillips@dentons.com
PW Track Number
P10022136175839
PW SOC Code
13-2051.00
PW SOC Title
Financial and Investment Analysts
PW Skill Level
Level II
PW Wage
75629.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-12-07
PW Expiration Date
2023-06-30
Wage Offer From
88000.00
Wage Offer To
0.00
Average Salary
88000.00
Wage Unit of Pay
Year
Worksite Address 1
2200 Post Oak Blvd.
Worksite Address 2
Worksite City
Houston
Worksite City Slug
houston
Worksite State
TEXAS
Worksite Postal Code
77056
Job Title
Portfolio Analytics & Strategy Analyst Senior
Job Title Slug
portfolio-analytics-strategy-analyst-senior
Minimum Education
Bachelor's
Major Field of Study
Econ, Applied Math, Engrg, Bus Admin, Stats, Math, Comp Sci, Mech Engrg, Indust Engrg&Mgmnt, or Fin.
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 the Retail Lending financial services industry
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Experience required with the following i handling, manipulating, analyzing and interpreting Retail lending customer datasets utilizing advanced tools and software including SAS, SQL, Tableau, Python, advanced MS Excel and PowerPoint; ii handling and transforming Big datasets and performing statistical analytics on such large datasets using Teradata, SAS, Hadoop, and 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 less technical senior audience; iv retail lending credit risk management, specific to acquisition and portfolio management risk analysis; v handling, manipulating, mining, analyzing and interpreting credit bureau databases and Experian Sandbox database utilizing advanced tools and software including SAS, SQL, Tableau, and Python; vi conducting PL profitability and loss analysis on revenue and risk metrics in financial industry; vii writing and implementing SASSQLPython 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 SQLSASPython queries, advanced tools and software including Knowledge Studio, SAS Enterprise Miner, and advanced Excel pivot tables and PowerPoint; ix preparation of dashboards from analytical data in a server environment using Tableau; and x delivering data analytics in multimedia presentations to senior leadership.br br From H.4B Economics, Applied Mathematics, Engineering, Business Administration, Statistics, Mathematics, Computer Science, Mechanical Engineering, Industrial Engineering and Management, or Financebr 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-09-09
SWA Job Order End Date
2022-10-14
Sunday Edition Newspaper
Y
First Newspaper Name
Houston Chronicle
First Advertisement Start Date
2022-08-21
Second Newspaper Ad Name
Houston Chronicle
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-08-28
Employer Website From Date
2022-07-25
Employer Website To Date
2022-11-15
Professional Organization Ad From Date
2024-01-01 00:37:46
Professional Organization Advertisement To Date
2024-01-01 00:37:46
Job Search Website From Date
2022-08-26
Job Search Website To Date
2022-09-16
Employee Referral Program From Date
2024-01-01 00:37:46
Employee Referral Program To Date
2024-01-01 00:37:46
Local Ethnic Paper From Date
2022-08-26
Local Ethnic Paper To Date
2022-09-01
Radio/TV Ad From Date
2024-01-01 00:37:46
Radio/TV Ad To Date
2024-01-01 00:37:46
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
MEXICO
Foreign Worker Birth Country
MEXICO
Class of Admission
L-1
Foreign Worker Education
Master's
Foreign Worker Information: Major
APPLIED INDUSTRIAL MATHEMATICS EQUIV TO US MASTERS IN APPLIED MATHEMATICS
Foreign Worker Years of Education Completed
2015
Foreign Worker Institution of Education
UNIVERSIDAD AUTONOMA METROPOLITANA
Foreign Worker Education Institution Address 1
AV. SAN RAFAEL ATLIXCO 186
Foreign Worker Education Institution Address 2
LEYES DE REFORMA 1RA SECC
Foreign Worker Education Institution City
IZTAPALAPA, MEXICO CITY
Foreign Worker Education Institution State/Province
Foreign Worker Education Institution Country
MEXICO
Foreign Worker Education Institution Postal Code
9340
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 A ODriscoll
Employer Information Declaration Title
Senior Counsel, Employment