All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22097-37066
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22097-37066
Case Status
Certified-Expired
Received Date
2022-12-29
Decision Date
2023-12-20
Refile
N
Original File Date
2024-01-01 00:26:08
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
522110
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
P10022089021332
PW SOC Code
13-2099.01
PW SOC Title
Financial Quantitative Analysts
PW Skill Level
Level II
PW Wage
64147.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-10-14
PW Expiration Date
2023-06-30
Wage Offer From
82400.00
Wage Offer To
0.00
Average Salary
82400.00
Wage Unit of Pay
Year
Worksite Address 1
300 Fifth Avenue
Worksite Address 2
Worksite City
Pittsburgh
Worksite City Slug
pittsburgh
Worksite State
PENNSYLVANIA
Worksite Postal Code
15222
Job Title
Business Analytics Consultant Senior
Job Title Slug
business-analytics-consultant-senior
Minimum Education
Master's
Major Field of Study
Finance, Financial Engineering, Applied Mathematics, Business Analytics or Economics
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 in a finance or corporate treasury position in the financial services industry
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Experience must include i financial and quantitative modeling experience, including experience with SQL queries using techniques to include RANKROW functions and sub queries; ii experience developing financial data analytics and management reporting. Experience must also include MS Excel functions specific to pivot tables, VLOOKUPHLOOKUPS, and conditional formatting; iii experience with analyzing large data sets involving millions of records of Financial data, including financial time series data cleanup, advanced time series regression analysis, back testing, sensitivity analysis and scenario testing; and iv experience to convert programming coding, involving SQL, into documentation that an outsider can understand.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-07-15
SWA Job Order End Date
2022-08-19
Sunday Edition Newspaper
Y
First Newspaper Name
Pittsburgh PostGazette
First Advertisement Start Date
2022-09-11
Second Newspaper Ad Name
Pittsburgh PostGazette
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-09-18
Employer Website From Date
2022-07-08
Employer Website To Date
2022-10-31
Professional Organization Ad From Date
2024-01-01 00:26:08
Professional Organization Advertisement To Date
2024-01-01 00:26:08
Job Search Website From Date
2022-09-12
Job Search Website To Date
2022-09-30
Employee Referral Program From Date
2024-01-01 00:26:08
Employee Referral Program To Date
2024-01-01 00:26:08
Local Ethnic Paper From Date
2022-09-14
Local Ethnic Paper To Date
2022-09-20
Radio/TV Ad From Date
2024-01-01 00:26:08
Radio/TV Ad To Date
2024-01-01 00:26:08
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
BUSINESS ANALYTICS
Foreign Worker Years of Education Completed
2016
Foreign Worker Institution of Education
TEXAS AM UNIVERSITYCOMMERCE
Foreign Worker Education Institution Address 1
2200 CAMPBELL ST.
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
COMMERCE
Foreign Worker Education Institution State/Province
TX
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
75428
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