Fiscal Year

2023

Case Number

A-22025-02666

Case Status

Certified

Received Date

2022-06-29

Decision Date

2023-02-09

Refile

N

Original File Date

2023-01-01 08:08:05

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

PALO ALTO MEDICAL FOUNDATION

Employer Name Slug

palo-alto-medical-foundation

Employer Address 1

795 EL CAMINO REAL

Employer Address 2

Employer City

PALO ALTO

Employer City Slug

palo-alto

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

94301

Employer Phone

650-691-6147

Employer Number of Employees

53000

Employer Year Commenced Business

1981

NAICS Code

622110

FW Ownership Interest

N

Employer Contact Name

Yolanda Agredano

Employer Contact Address 1

795 El Camino Real

Employer Contact Address 2

Employer Contact City

Palo Alto

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

94301

Employer Contact Phone

650-691-6147

Employer Contact Email

agreday@pamf.org

Agent Attorney Name

Julienne Maribao

Agent Attorney Firm Name

EM Mayock

Agent Attorney Phone

4157655111

Agent Attorney Address 1

PO BOX #191710

Agent Attorney Address 2

Agent Attorney City

San Francisco

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

94119

Agent Attorney Email

jmaribao@emvisa.com

PW Track Number

P10021239550023

PW SOC Code

15-1052

PW SOC Title

Computer Systems Analysts, Non RD

PW Skill Level

Level IV

PW Wage

96616.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-03-01

PW Expiration Date

2022-06-30

Wage Offer From

101129.60

Wage Offer To

0.00

Average Salary

101129.60

Wage Unit of Pay

Year

Worksite Address 1

2300 River Plaza Drive

Worksite Address 2

Worksite City

Sacramento

Worksite City Slug

sacramento

Worksite State

CALIFORNIA

Worksite Postal Code

95833

Job Title

Senior Data Analyst

Job Title Slug

senior-data-analyst

Minimum Education

Master's

Major Field of Study

Computer Science, Technology, Engineering, IS, MIS or a closely-related field of concentration.

Required Training

N

Required Experience

Y

Required Experience Months

48

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer Science, Technology, Engineering, IS, MIS or a closelyrelated field of concentration.

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

48

Accept Alternative Job Title

Software Developer, Program Analyst and Software Engineer related occupation.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Employer will accept a Masters degree in Computer Science, Technology, Engineering, Information Systems, IT, Management Information Systems or a closelyrelated field of concentration plus 4 years of experience in job offered or Software Developer, Program Analyst and Software Engineer related occupation.br br Education or Experience must include the followingbr 1 SQL Server.br 2 Data integration to integrate data from various data sources.br 3 SQL Server database management system.br 4 OLTP and OLAP databases in Health Care domain. Developed DataMarts, Reportsbr 5 Transactional processing applications using SQL Server database.br 6 Validated SSRS, Crystal Reports accuracy against the SQL Server database.br 7 Develop dashboards and reports on the performance of IS processes.br 8 Design, development, deployment, maintenance of Report applications and SQL Objects.br 9 Run, modify and provide support to existing reports and developed new reports.br 10 SQL Server database. Develop the database objects and complex joins in SQL Server. Transform the data and present data in appropriate manner.br 11 Design, develop and deploy Crosstab Crystal Reports. Schedule Crystal reports to be delivered to email in InLineHtml, PDF, Excel.br 12 Data Cleanup, rebuilding the SSRS reports with SQL Server as the backend database.br 13 Troubleshooting the issue, finding the root cause and fixing the issue.br 14 Software development life cycle in Requirement Gathering, Conceptual Design, Analysis, Detail Design, Development, System and User Acceptance Testing.br 15 Identifying risks ambiguous requirements, availability of data, and providing supporting evidences.br 16 Analyzing and identifying the issue, risks and provide technical solution to resolve the issue.br 17 Testing the application for unit testing, integration testing, system testing, and user acceptance testingbr 18 Create Subscriptions to ensure accurate and timely automated reporting.br 19 Followed HIPAA standards to keep the PHI data safe.br 20 IT and support services to Organization applications.br 21 Health Care domain that involves Electronic Health Records EHR data.br br Foreign educational equivalent is acceptable. External hires must pass a background checkdrug screen. May telecommute.

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-03-01

SWA Job Order End Date

2022-04-05

Sunday Edition Newspaper

Y

First Newspaper Name

The Sacramento Bee

First Advertisement Start Date

2022-04-03

Second Newspaper Ad Name

The Sacramento Bee

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-04-10

Employer Website From Date

2022-03-15

Employer Website To Date

2022-03-22

Professional Organization Ad From Date

2023-01-01 08:08:05

Professional Organization Advertisement To Date

2023-01-01 08:08:05

Job Search Website From Date

2022-03-01

Job Search Website To Date

2022-03-15

Employee Referral Program From Date

2023-01-01 08:08:05

Employee Referral Program To Date

2023-01-01 08:08:05

Local Ethnic Paper From Date

2022-04-08

Local Ethnic Paper To Date

2022-04-08

Radio/TV Ad From Date

2023-01-01 08:08:05

Radio/TV Ad To Date

2023-01-01 08:08:05

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 SCIENCE

Foreign Worker Years of Education Completed

2008

Foreign Worker Institution of Education

NORTHWESTERN POLYTECHNIC UNIVERSITY

Foreign Worker Education Institution Address 1

47671 WESTINGHOUSE DRIVE

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

FREMONT

Foreign Worker Education Institution State/Province

CA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

94539

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Julienne Maribao

Preparer Title

Associate Attorney

Preparer Email

jmaribao@emvisa.com

Employer Information Declaration Name

Emma Moreno

Employer Information Declaration Title

HR Representative