Fiscal Year

2023

Case Number

A-21343-83902

Case Status

Certified

Received Date

2022-02-14

Decision Date

2023-02-07

Refile

N

Original File Date

2023-01-01 08:09:03

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

JOHNSON JOHNSON CONSUMER INC.

Employer Name Slug

johnson-johnson-consumer-inc

Employer Address 1

199 GRANDVIEW ROAD

Employer Address 2

Employer City

SKILLMAN

Employer City Slug

skillman

Employer State

NEW JERSEY

Employer State Slug

new-jersey

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

8558

Employer Phone

7325245931

Employer Number of Employees

132000

Employer Year Commenced Business

1970

NAICS Code

3256

FW Ownership Interest

N

Employer Contact Name

James Kim

Employer Contact Address 1

501 George Street

Employer Contact Address 2

Employer Contact City

New Brunswick

Employer Contact State/Province

NEW JERSEY

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

8933

Employer Contact Phone

7325245931

Employer Contact Email

jkim43@its.jnj.com

Agent Attorney Name

Kane Vongsavanh

Agent Attorney Firm Name

Berry Appleman Leiden LLP

Agent Attorney Phone

469 505 2272

Agent Attorney Address 1

8300 Greensboro Drive

Agent Attorney Address 2

Suite 550

Agent Attorney City

McLean

Agent Attorney State/Province

VIRGINIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

22102

Agent Attorney Email

kvongsavanh@bal.com

PW Track Number

P10021048082736

PW SOC Code

15-1199

PW SOC Title

Database Architects

PW Skill Level

Level IV

PW Wage

119122.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-07-29

PW Expiration Date

2022-06-30

Wage Offer From

119122.00

Wage Offer To

129122.00

Average Salary

124122.00

Wage Unit of Pay

Year

Worksite Address 1

7050 Camp Hill Road

Worksite Address 2

Worksite City

Fort Washington

Worksite City Slug

fort-washington

Worksite State

PENNSYLVANIA

Worksite Postal Code

19034

Job Title

Sr. Database Analyst Programmer

Job Title Slug

sr-database-analyst-programmer

Minimum Education

Bachelor's

Major Field of Study

See H.14

Required Training

N

Required Experience

Y

Required Experience Months

120

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

120

Accept Alternative Job Title

See H.14

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Employer will accept Bachelors degree in Electronics Engineering, Computer Science, Statistics or related technical field, followed by ten years of progressive, postbaccalaureate work experience in job offered or ten years of progressive, postbaccalaureate work experience in a positionrelated occupation. Position requiresbr br 1. Handson experience in Oracle; knowledge of relational databases; knowledge with PLSQL, particularly packages, procedures, functions, triggers, jobs and tuning experiences 10 years;br 2. Handson experience on data visualization tools such as Qlik;br 3. Experience in design models, diagrams, layouts, definitions andor specifications to show process, systems design, andor integration complexity in a clear and precise manner; 5 yearsbr 4. Proficient in analyzing information thoroughly and effectively to determine the impact of technical platform changes, customer requirement changes andor software defects will have on supported systems; 5 yearsbr 5. Experience with full software development lifecycle process, software versioning and revision control system; Experience with data migration and data mapping; 5 yearsbr 6. Proficient in troubleshooting, selfmotivated and driven professional, able to work with minimal supervision, and able to exercise good judgment to keep critical systems operational; 5 yearsbr 7. Experience with working closely with various upstream and downstream systemsdatabases of various functional groups, including consumer call center, case processing, IT and QA teams to ensure better safety data integrity; 5 yearsbr 8. Understanding of adverse event and MedDRA, and working knowledge of safety surveillance; 4 yearsbr 9. Experience with compliance requirement related to GxP, provide required documentation as necessary and participate in compliancevalidation activates; 4 yearsbr 10. Ability to complete tasks at a project level; Ability to collaborate with key stakeholders; 5 yearsbr 11. Ability to quickly and effectively learn new program techniques and data structures; capacity to seamlessly assimilate to new projects; 5 yearsbr 12. Efficiently manipulates large databases including complex data preprocessing, filtering and manipulation; experience with sample strategies for large databases; 4 years andbr 13. Experience in responding to health authority inspection 4 years.

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-10-28

SWA Job Order End Date

2021-12-08

Sunday Edition Newspaper

Y

First Newspaper Name

Philadelphia Inquirer

First Advertisement Start Date

2021-10-10

Second Newspaper Ad Name

Philadelphia Inquirer

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-10-17

Employer Website From Date

2021-11-05

Employer Website To Date

2021-11-12

Professional Organization Ad From Date

2023-01-01 08:09:03

Professional Organization Advertisement To Date

2023-01-01 08:09:03

Job Search Website From Date

2021-09-30

Job Search Website To Date

2021-10-19

Employee Referral Program From Date

2023-01-01 08:09:03

Employee Referral Program To Date

2023-01-01 08:09:03

Local Ethnic Paper From Date

2021-10-15

Local Ethnic Paper To Date

2021-10-21

Radio/TV Ad From Date

2023-01-01 08:09:03

Radio/TV Ad To Date

2023-01-01 08:09:03

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

ELECTRONICS AND TELECOMMUNICATION

Foreign Worker Years of Education Completed

2007

Foreign Worker Institution of Education

PUNE INSTITUTE OF COMPUTER TECHNOLOGY, UNIVERSITY OF PUNE

Foreign Worker Education Institution Address 1

SURVEY NO. 27, NEAR, TRIMURTI CHOWK

Foreign Worker Education Institution Address 2

BHARATI VIDYAPEETH CAMPUS, DHANKAWADI

Foreign Worker Education Institution City

PUNE

Foreign Worker Education Institution State/Province

MAHARASTHRA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

411043

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Kane Vongsavanh

Preparer Title

Sr. Associate

Preparer Email

kvongsavanh@balglobal.com

Employer Information Declaration Name

James Kim

Employer Information Declaration Title

Senior Manager, Global Immigration