Fiscal Year

2023

Case Number

A-22144-60380

Case Status

Certified

Received Date

2022-05-27

Decision Date

2023-02-23

Refile

N

Original File Date

2023-01-01 08:05:36

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

ACER AMERICA CORPORATION

Employer Name Slug

acer-america-corporation

Employer Address 1

1730 NORTH FIRST STREET

Employer Address 2

SUITE 400

Employer City

SAN JOSE

Employer City Slug

san-jose

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

95112

Employer Phone

408-533-7700

Employer Number of Employees

416

Employer Year Commenced Business

1976

NAICS Code

334111

FW Ownership Interest

N

Employer Contact Name

Lenny Pollak

Employer Contact Address 1

1730 North First Street

Employer Contact Address 2

Suite 400

Employer Contact City

San Jose

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

95112

Employer Contact Phone

408-533-7700

Employer Contact Email

lenny.pollak@acer.com

Agent Attorney Name

David M Palmer

Agent Attorney Firm Name

Minami Tamaki LLP

Agent Attorney Phone

(415) 788-9000

Agent Attorney Address 1

360 Post Street

Agent Attorney Address 2

Flr. 8

Agent Attorney City

San Francisco

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

94108

Agent Attorney Email

dpalmer@minamitamaki.com

PW Track Number

P10021224518078

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level II

PW Wage

116043.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-04-07

PW Expiration Date

2022-07-06

Wage Offer From

116043.00

Wage Offer To

0.00

Average Salary

116043.00

Wage Unit of Pay

Year

Worksite Address 1

1730 North First Street

Worksite Address 2

Suite 400

Worksite City

San Jose

Worksite City Slug

san-jose

Worksite State

CALIFORNIA

Worksite Postal Code

95112

Job Title

Business Intelligence Analyst (Data Warehouse)

Job Title Slug

business-intelligence-analyst-data-warehouse

Minimum Education

Master's

Major Field of Study

Comp Sci, Tech Mgmt, Bus Admin, Eng (any) or a rel fld

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

24

Accept Alternative Job Title

Business Intelligence Analyst, Business Intelligence Developer, or a related occupation.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Masters degree or foreign equivalent degree in Computer Science, Technology Management, Business Administration, Engineering any or a related field, plus 2 years of work of experience as a Business Intelligence Analyst, Business Intelligence Developer, or a related occupation.br br Experience must include 1. Relational Database, including planning, defining designing database and policies; 2. Business Intelligence Tools, including SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, defining KPIs using Data Analysis Expressions DAX, and SQL Server Reporting Services SSRS; 3. Building reports using data visualization tools, including Power BI, visual reports, dashboards and KPI scorecards; 4. TSQL Programming and SQL optimization, including DDL, DML, DCL commands, Stored Procedures, Functions, and Views; and 5. Debugging and troubleshooting, including production issues, data quality issues, root cause analysis.

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

SWA Job Order End Date

2022-04-26

Sunday Edition Newspaper

Y

First Newspaper Name

Mercury News

First Advertisement Start Date

2021-11-28

Second Newspaper Ad Name

Mercury News

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-12-05

Employer Website From Date

2023-01-01 08:05:36

Employer Website To Date

2023-01-01 08:05:36

Professional Organization Ad From Date

2023-01-01 08:05:36

Professional Organization Advertisement To Date

2023-01-01 08:05:36

Job Search Website From Date

2022-05-24

Job Search Website To Date

2022-05-25

Employee Referral Program From Date

2023-01-01 08:05:36

Employee Referral Program To Date

2023-01-01 08:05:36

Local Ethnic Paper From Date

2021-12-03

Local Ethnic Paper To Date

2021-12-03

Radio/TV Ad From Date

2021-11-30

Radio/TV Ad To Date

2021-11-30

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

TECHNOLOGY MANAGEMENT

Foreign Worker Years of Education Completed

2013

Foreign Worker Institution of Education

SOUTHEAST MISSOURI STATE UNIVERSITY

Foreign Worker Education Institution Address 1

1 UNIVERSITY PLAZA

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

CAPE GIRARDEAU

Foreign Worker Education Institution State/Province

MO

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

63701

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

David M Palmer

Preparer Title

Attorney at Law

Preparer Email

dpalmer@minamitamaki.com

Employer Information Declaration Name

Lenny Pollak

Employer Information Declaration Title

VP of Human Resources Administration