All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20035-15168
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-20035-15168
Case Status
Certified
Received Date
2020-02-05
Decision Date
2020-06-05
Refile
N
Original File Date
2020-01-01 08:36:12
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
JOHNS HOPKINS HEALTH SYSTEM CORPORATION
Employer Name Slug
johns-hopkins-health-system-corporation
Employer Address 1
1101 E. 33RD STREET
Employer Address 2
SUITE E200
Employer City
BALTIMORE
Employer City Slug
baltimore
Employer State
MARYLAND
Employer State Slug
maryland
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
21218
Employer Phone
4439971966
Employer Number of Employees
29000
Employer Year Commenced Business
1986
NAICS Code
923120
FW Ownership Interest
N
Employer Contact Name
Jannell Pellicio
Employer Contact Address 1
1101 E. 33rd Street
Employer Contact Address 2
Suite C210
Employer Contact City
Baltimore
Employer Contact State/Province
MARYLAND
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
21218
Employer Contact Phone
4439971966
Employer Contact Email
jpellic4@jhmi.edu
Agent Attorney Name
Frances O Taylor
Agent Attorney Firm Name
Taylor Ryan, LLC
Agent Attorney Phone
410-486-5800
Agent Attorney Address 1
1777 Reisterstown Road
Agent Attorney Address 2
Suite 265
Agent Attorney City
Baltimore
Agent Attorney State/Province
MARYLAND
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
21208
Agent Attorney Email
ftaylor@taylor-ryan.com
PW Track Number
P10019017494235
PW SOC Code
15-1034
PW SOC Title
Software Developers, Applications, Non R D
PW Skill Level
Level IV
PW Wage
104936.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-05-14
PW Expiration Date
2019-08-12
Wage Offer From
104936.00
Wage Offer To
143874.00
Average Salary
124405.00
Wage Unit of Pay
Year
Worksite Address 1
1300 Thames Street
Worksite Address 2
Suite 200
Worksite City
Baltimore
Worksite City Slug
baltimore
Worksite State
MARYLAND
Worksite Postal Code
21231
Job Title
Clinical Analytics Systems Architect
Job Title Slug
clinical-analytics-systems-architect
Minimum Education
Bachelor's
Major Field of Study
See H.14.
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
See H.14.
Accept Alternative Combination
Y
Accept Alternative Combination Education
Master's
Accept Alternative Combination Education Years
3
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
See H.14.
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
This form has been completed in an effort to show the following minimum requirementsbr br Bachelors degree or foreign equivalent in Information Systems, Information Technology, Computer Science, or a related field, and five 5 years of project management experience, which must include the followingbr br Five 5 years of experience in data integration using Extract, Transform and Load ETL methods with Microsoft Business Intelligence BI and Informatica PowerCenter tools;br br Three 3 years of experience in SQL programming;br br Three 3 years of experience in performance tuning SQL queries with MS SQL Server database;br br Two 2 years of experience using Tableau desktop and SAP Business Objects for predictive analytics, volume forecasting, trending analysis, and creating dashboards; andbr br One 1 year of experience with big data framework and programming in Python.br br All experience may be concurrent.br br In lieu of a Bachelors degree and five 5 years of experience, employer will accept a Masters degree or foreign equivalent in Information Systems, Information Technology, Computer Science, or a related field, and three 3 years of project management experience, which must include the followingbr br Three 3 years of experience in data integration using Extract, Transform and Load ETL methods with Microsoft Business Intelligence BI and Informatica PowerCenter tools;br br Three 3 years of experience in SQL programming;br br Three 3 years of experience in performance tuning SQL queries with MS SQL Server database;br br Two 2 years of experience using Tableau desktop and SAP Business Objects for predictive analytics, volume forecasting, trending analysis, and creating dashboards; andbr br One 1 year of experience with big data framework and programming in Python.br br All experience may be concurrent.br br Any suitable combination of education, training or experience is acceptable.
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
2019-08-09
SWA Job Order End Date
2019-09-09
Sunday Edition Newspaper
Y
First Newspaper Name
The Baltimore Sun
First Advertisement Start Date
2019-08-11
Second Newspaper Ad Name
The Baltimore Sun
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-08-18
Employer Website From Date
2019-08-09
Employer Website To Date
2019-12-22
Professional Organization Ad From Date
2020-01-01 08:36:12
Professional Organization Advertisement To Date
2020-01-01 08:36:12
Job Search Website From Date
2019-08-09
Job Search Website To Date
2019-12-22
Employee Referral Program From Date
2020-01-01 08:36:12
Employee Referral Program To Date
2020-01-01 08:36:12
Local Ethnic Paper From Date
2019-08-14
Local Ethnic Paper To Date
2019-08-14
Radio/TV Ad From Date
2020-01-01 08:36:12
Radio/TV Ad To Date
2020-01-01 08:36:12
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
COMPUTER APPLICATIONS
Foreign Worker Years of Education Completed
2006
Foreign Worker Institution of Education
INDIRA GANDHI NATIONAL OPEN UNIVERSITY
Foreign Worker Education Institution Address 1
93, MAIDAN GARHI RD
Foreign Worker Education Institution Address 2
MAIDAN GARHI
Foreign Worker Education Institution City
NEW DELHI
Foreign Worker Education Institution State/Province
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
110068
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Frances O Taylor
Preparer Title
Attorney
Preparer Email
ftaylor@taylor-ryan.com
Employer Information Declaration Name
Jannell Pellicio
Employer Information Declaration Title
HR Immigration Specialist