Fiscal Year

2024

Case Number

A-22216-99898

Case Status

Certified-Expired

Received Date

2022-12-01

Decision Date

2023-12-08

Refile

N

Original File Date

2024-01-01 00:23:37

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

TOSHIBA AMERICA BUSINESS SOLUTIONS

Employer Name Slug

toshiba-america-business-solutions

Employer Address 1

25530 COMMERCENTRE DRIVE

Employer Address 2

Employer City

LAKE FOREST

Employer City Slug

lake-forest

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

92630

Employer Phone

949-462-6115

Employer Number of Employees

269

Employer Year Commenced Business

1999

NAICS Code

33411

FW Ownership Interest

N

Employer Contact Name

Kim Jones

Employer Contact Address 1

25530 Commercentre Drive

Employer Contact Address 2

Employer Contact City

Lake Forest

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

92630

Employer Contact Phone

949-462-6115

Employer Contact Email

Kim.Jones@tabs.toshiba.com

Agent Attorney Name

James Y Pack

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

9492610209

Agent Attorney Address 1

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Address 2

18401 Von Karman Avenue, Suite 255

Agent Attorney City

Irvine

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

92612

Agent Attorney Email

kha@fragomen.com

PW Track Number

P10021189451084

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level IV

PW Wage

139818.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-12-09

PW Expiration Date

2022-06-30

Wage Offer From

139818.00

Wage Offer To

0.00

Average Salary

139818.00

Wage Unit of Pay

Year

Worksite Address 1

25530 COMMERCENTRE DRIVE

Worksite Address 2

Worksite City

LAKE FOREST

Worksite City Slug

lake-forest

Worksite State

CALIFORNIA

Worksite Postal Code

92630

Job Title

OBIEE REPORT DEVELOPER

Job Title Slug

obiee-report-developer

Minimum Education

Bachelor's

Major Field of Study

ENGINEERING (ANY), COMPUTER SCIENCE*

Required Training

N

Required Experience

Y

Required Experience Months

60

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

See H.14 for complete list

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

In job offered or closely related occupation

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

THIS POSITION REQUIRES A BACHELORS DEGREE OR FOREIGN EQUIVALENT IN ENGINEERING ANY, COMPUTER SCIENCE, INFORMATION STYSTEMS, OR IN A CLOSELY RELATED FIELD, PLUS 5 YEARS OF PROGRESSIVELY RESPONSIBLE WORK EXPERIENCE IN THE JOB OFFERED OR IN A CLOSELY RELATED OCCUPATION. REQUIRED EXPERTISEKNOWLEDGE 1. Developing, configuring, and publishing realtime and data analytics reports using OBIEE, BIACM, BI, OBIA, Data Warehousing, Enterprise Reporting, and Visualization tools. 2. Using Oracle EBusiness Suite EBS, SQL, Java, XML, and PLSQL to write business events and logic used for reporting and dashboards. 3. Integrating with Oracle EBusiness Suite EBS and multiple cloud systems including Salesforce, Cognos, Tableau, and internal systems to develop and publish reports in OBIEE dashboards using WebLogic, Web Gateway, and ODI. 4. Using Oracle modules including, RecordtoReport, OrdertoCash, ProcuretoPay, and DemandtoDeliver functionalities, along with Oracle R12 EBusiness Suite EBS database table structures to build reports based on ebusiness suite business functionality. 5. Writing programming logic using Oracle, TOAD, and SQL Developer. 6. Building oracle reports for EBusiness using Oracle Reports and BI publisher. 7. Working with Oracle Support to resolve product bugs, including troubleshooting. MUST POSSESS EXPERTISE KNOWLEDGE SUFFICIENT TO ADEQUATELY PERFORM THE DUTIES OF THE JOB BEING OFFERED. EXPERTISE KNOWLEDGE MAY BE GAINED THROUGH EMPLOYMENT EXPERIENCE OR EDUCATION. SUCH EXPERTISE KNOWLEDGE CANNOT BE quot;QUANTIFIEDquot; BY quot;TIME.quot;

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-08-22

SWA Job Order End Date

2022-09-23

Sunday Edition Newspaper

Y

First Newspaper Name

Los Angeles Times

First Advertisement Start Date

2022-07-17

Second Newspaper Ad Name

Los Angeles Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-07-24

Employer Website From Date

2024-01-01 00:23:37

Employer Website To Date

2024-01-01 00:23:37

Professional Organization Ad From Date

2024-01-01 00:23:37

Professional Organization Advertisement To Date

2024-01-01 00:23:37

Job Search Website From Date

2024-01-01 00:23:37

Job Search Website To Date

2024-01-01 00:23:37

Employee Referral Program From Date

2022-06-30

Employee Referral Program To Date

2022-08-02

Local Ethnic Paper From Date

2022-07-20

Local Ethnic Paper To Date

2022-07-20

Radio/TV Ad From Date

2022-07-30

Radio/TV Ad To Date

2022-07-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

COMPUTER INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2021

Foreign Worker Institution of Education

BIRLA INSTITUTE OF TECHNOLOGY AND SCIENCE

Foreign Worker Education Institution Address 1

VIDYA VIHAR

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

PILANI

Foreign Worker Education Institution State/Province

RAJASTHAN

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

333031

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

James Y Pack

Preparer Title

Partner

Preparer Email

JPack@Fragomen.com

Employer Information Declaration Name

Kim Jones

Employer Information Declaration Title

HR Director