All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21243-38349
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21243-38349
Case Status
Certified-Expired
Received Date
2021-09-27
Decision Date
2022-03-24
Refile
N
Original File Date
2022-01-01 11:09:23
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
ACE INSURANCE COMPANY
Employer Name Slug
ace-insurance-company
Employer Address 1
CO CHUBB CORPORATION
Employer Address 2
436 WALNUT STREET
Employer City
PHILADELPHIA
Employer City Slug
philadelphia
Employer State
PENNSYLVANIA
Employer State Slug
pennsylvania
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
19106
Employer Phone
908-572-2650
Employer Number of Employees
7000
Employer Year Commenced Business
1985
NAICS Code
524126
FW Ownership Interest
N
Employer Contact Name
Virgil Macon
Employer Contact Address 1
510 Walnut Street
Employer Contact Address 2
Employer Contact City
Philadelphia
Employer Contact State/Province
PENNSYLVANIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
19106
Employer Contact Phone
215-578-8449
Employer Contact Email
Virgil.Macon@Chubb.com
Agent Attorney Name
Hyla K Rosenberg
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy LLP
Agent Attorney Phone
2126888555
Agent Attorney Address 1
1400 Broadway
Agent Attorney Address 2
Agent Attorney City
New York
Agent Attorney State/Province
NEW YORK
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
10018
Agent Attorney Email
ebrettschneider@fragomen.com
PW Track Number
P10020190700814
PW SOC Code
15-1199
PW SOC Title
Business Intelligence Analysts
PW Skill Level
Level II
PW Wage
73486.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-02-08
PW Expiration Date
2021-06-30
Wage Offer From
99300.00
Wage Offer To
118000.00
Average Salary
108650.00
Wage Unit of Pay
Year
Worksite Address 1
11525 N. Community House Road
Worksite Address 2
Suite 650
Worksite City
Charlotte
Worksite City Slug
charlotte
Worksite State
NORTH CAROLINA
Worksite Postal Code
28277
Job Title
Claims Business Intelligence Solutions Senior Specialist
Job Title Slug
claims-business-intelligence-solutions-senior-specialist
Minimum Education
Bachelor's
Major Field of Study
Mathematics, Statistics, Actuarial Sci, Computer Sci, Engg. (any), or a related
Required Training
N
Required Experience
Y
Required Experience Months
36
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
Business Intelligence Developer, Qlik AdminDeveloper, Senior Qlik Consultant, or related
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Must have a Bachelors degree or foreign equivalent in Mathematics, Statistics, Actuarial Science, Computer Science, Engineering any, or a related field plus three 3 years of experience in the job offered or as a Business Intelligence Developer, Qlik AdminDeveloper, Senior Qlik Consultant, or related. Must have three 3 years of experience with Designing and developing BI solutions with capability in data visualization and data discovery with technologies, including Qlik Sense; Qlik Data Modeling; Qlik security through section access; Set Analysis; Qlik extensions and building custom solutions; Data warehouse and database concepts; Dimensional modeling using star and snow flake schemas; App and data connections; Tasks and Publishing; Basic SQL code to develop queries; SDLC from inception for delivery of project including requirements gathering, design, implementation, documentation, production release and production support; and Agile methodology.
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-04-16
SWA Job Order End Date
2021-05-22
Sunday Edition Newspaper
Y
First Newspaper Name
The Charlotte Observer
First Advertisement Start Date
2021-04-25
Second Newspaper Ad Name
The Charlotte Observer
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-05-02
Employer Website From Date
2021-04-06
Employer Website To Date
2021-06-21
Professional Organization Ad From Date
2022-01-01 11:09:23
Professional Organization Advertisement To Date
2022-01-01 11:09:23
Job Search Website From Date
2021-04-26
Job Search Website To Date
2021-05-05
Employee Referral Program From Date
2022-01-01 11:09:23
Employee Referral Program To Date
2022-01-01 11:09:23
Local Ethnic Paper From Date
2021-04-29
Local Ethnic Paper To Date
2021-04-29
Radio/TV Ad From Date
2022-01-01 11:09:23
Radio/TV Ad To Date
2022-01-01 11:09:23
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
ENGINEERING MANAGEMENT
Foreign Worker Years of Education Completed
2015
Foreign Worker Institution of Education
CALIFORNIA STATE UNIVERSITY, NORTHRIDGE
Foreign Worker Education Institution Address 1
18111 NORDHOFF STREET
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
NORTHRIDGE
Foreign Worker Education Institution State/Province
CA
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
91330
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Hyla K Rosenberg
Preparer Title
Partner
Preparer Email
ebrettschneider@fragomen.com
Employer Information Declaration Name
Virgil Macon
Employer Information Declaration Title
Assistant vice President, Talent Acquisition