All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21224-30853
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21224-30853
Case Status
Certified-Expired
Received Date
2021-09-22
Decision Date
2022-03-23
Refile
N
Original File Date
2022-01-01 11:08:46
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
JOHN HANCOCK LIFE INSURANCE COMPANY U.S.A.
Employer Name Slug
john-hancock-life-insurance-company-usa
Employer Address 1
JOHN HANCOCK PLACE
Employer Address 2
P.O. BOX 111
Employer City
BOSTON
Employer City Slug
boston
Employer State
MASSACHUSETTS
Employer State Slug
massachusetts
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
2117
Employer Phone
617-572-6000
Employer Number of Employees
5070
Employer Year Commenced Business
1887
NAICS Code
524130
FW Ownership Interest
N
Employer Contact Name
Corrine L Weber
Employer Contact Address 1
John Hancock Place
Employer Contact Address 2
P.O. Box 111
Employer Contact City
Boston
Employer Contact State/Province
MASSACHUSETTS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
2117
Employer Contact Phone
617-572-7665
Employer Contact Email
clweber@jhancock.com
Agent Attorney Name
William L Coffman
Agent Attorney Firm Name
Mintz Levin Cohn Ferris Glovsky Popeo
Agent Attorney Phone
6175426000
Agent Attorney Address 1
One Financial Center
Agent Attorney Address 2
Floor 41
Agent Attorney City
Boston
Agent Attorney State/Province
MASSACHUSETTS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
2111
Agent Attorney Email
wlcoffman@mintz.com
PW Track Number
P10020223759853
PW SOC Code
15-1199
PW SOC Title
Business Intelligence Analysts
PW Skill Level
Level IV
PW Wage
108597.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-03-09
PW Expiration Date
2021-06-30
Wage Offer From
122343.00
Wage Offer To
0.00
Average Salary
122343.00
Wage Unit of Pay
Year
Worksite Address 1
200 Berkeley Street
Worksite Address 2
Worksite City
Boston
Worksite City Slug
boston
Worksite State
MASSACHUSETTS
Worksite Postal Code
2116
Job Title
NAIC Reporting Data Steward
Job Title Slug
naic-reporting-data-steward
Minimum Education
Bachelor's
Major Field of Study
Computer Engineering, Computer Science, Management Information Systems or 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
Any position that meets the requirments listed in H.14
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
All Requirementsbr br Bachelors Degree or foreign equivalent in Computer Engineering, Computer Science, Management Information Systems or related field and 5 years of experience in an information technology position.br br Experience must includebr br 5 years of experience using SQL or MS SQL;br 5 years of data warehouse and dimensional data model implementation experience;br 5 years of experience writing and optimizing SQL codes and stored procedures for relational databases;br 4 years of experience in business intelligence, data modeling, ETL, data warehousing and transformation of largescale data sources using SQL, Python or other big data technologies;br 3 years of experience gathering requirements in the financial services industry;br 3 years of experience developing data models and maintaining data dictionary for tracible and auditable purposes using any BI tool;br 3 years of experience developing scripts, data models and ETL architecture using QlikView;br 3 years of experience developing and implementing analytical and visualization dashboards using QlikView;br 3 years of experience managing direct clients and working on adhoc basis to deliver reports on tight deadlines;br 3 years of experience in the insurance and finance industry including implementing legacy application into new digital technologies;br 2 years of experience with reporting and ETL tools such as Python, Tableau and PowerBI;br 2 years of experience implementing process improvement PI techniques;br 1 year of experience publishing dashboards and maintaining applications built on QlikView;br 1 year of experience implementing machine learning algorithms using Python;br 1 year of experience with largescale BI platformsbr br Experience may be gained concurrently.
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-19
SWA Job Order End Date
2021-05-24
Sunday Edition Newspaper
Y
First Newspaper Name
The Boston Globe
First Advertisement Start Date
2021-04-25
Second Newspaper Ad Name
The Boston Globe
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-05-02
Employer Website From Date
2021-04-19
Employer Website To Date
2021-05-24
Professional Organization Ad From Date
2022-01-01 11:08:46
Professional Organization Advertisement To Date
2022-01-01 11:08:46
Job Search Website From Date
2021-04-19
Job Search Website To Date
2021-05-10
Employee Referral Program From Date
2022-01-01 11:08:46
Employee Referral Program To Date
2022-01-01 11:08:46
Local Ethnic Paper From Date
2021-04-30
Local Ethnic Paper To Date
2021-04-30
Radio/TV Ad From Date
2022-01-01 11:08:46
Radio/TV Ad To Date
2022-01-01 11:08:46
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
COMPUTER ENGINEERING
Foreign Worker Years of Education Completed
2011
Foreign Worker Institution of Education
SHANMUGHA ARTS, SCIENCE, TECHNOLOGY RESEARCH ACADEMY
Foreign Worker Education Institution Address 1
TRICHYTANJORE ROAD, THIRUMALAISAMUDRAM
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
THANJAVUR
Foreign Worker Education Institution State/Province
TAMIL NADU
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
613401
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
William L Coffman
Preparer Title
Attorney
Preparer Email
wlcoffman@mintz.com
Employer Information Declaration Name
Catherine Murphy
Employer Information Declaration Title
VP Deputy Actuary