Fiscal Year

2022

Case Number

A-21314-71238

Case Status

Certified

Received Date

2021-11-18

Decision Date

2022-06-03

Refile

N

Original File Date

2022-01-01 11:34:48

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

MIZUHO SECURITIES USA LLC

Employer Name Slug

mizuho-securities-usa-llc

Employer Address 1

1271 AVENUE OF THE AMERICAS

Employer Address 2

Employer City

NEW YORK

Employer City Slug

new-york

Employer State

NEW YORK

Employer State Slug

new-york

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

10020

Employer Phone

(212) 209-9300

Employer Number of Employees

1048

Employer Year Commenced Business

2000

NAICS Code

523110

FW Ownership Interest

N

Employer Contact Name

Elizabeth Ceisler

Employer Contact Address 1

1271 Avenue of the Americas

Employer Contact Address 2

Employer Contact City

New York

Employer Contact State/Province

NEW YORK

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

10020

Employer Contact Phone

212-209-9465

Employer Contact Email

liz.ceisler@mizuhogroup.com

Agent Attorney Name

Jang H Im

Agent Attorney Firm Name

Fisher Phillips LLP

Agent Attorney Phone

4154909051

Agent Attorney Address 1

One Embarcadero Center

Agent Attorney Address 2

Suite 2050

Agent Attorney City

San Francisco

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

94111

Agent Attorney Email

sfo-immigration@fisherphillips.com

PW Track Number

P10021084175082

PW SOC Code

11-3021

PW SOC Title

Computer and Information Systems Managers

PW Skill Level

Level IV

PW Wage

237016.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-08-26

PW Expiration Date

2022-06-30

Wage Offer From

237016.00

Wage Offer To

0.00

Average Salary

237016.00

Wage Unit of Pay

Year

Worksite Address 1

101 S. Wood Ave S

Worksite Address 2

Worksite City

Iselin

Worksite City Slug

iselin

Worksite State

NEW JERSEY

Worksite Postal Code

8830

Job Title

Financial Systems Manager

Job Title Slug

financial-systems-manager

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Management Information Systems, Engineering, Mathematics or a related field

Required Training

N

Required Experience

Y

Required Experience Months

120

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer Science, Management Information Systems, Engineering, Mathematics or a related field

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

in the job offered or related occupation

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

This position requires a Bachelors or foreign equivalent degree in Computer Science, Management Information Systems, Engineering, Mathematics, or a related field and Ten 10 years of experience in the job offered or related occupation. Special Requirements Experience must include Ten 10 years of experience with 1 Oversight and assist in data mining and analysis using deep SQL and Python expertise to extract customer data from data warehouse. 2 Support the development of data models using various modeling technics such as conceptual, logical, and physical models to support the financial system requirements. 3 Manage database, servers and systems sizing and recommendation for computing power including CPU, RAM, Memory, Operating Systems, and hard disk space. 4 Develop prototype algorithms for future systems enhancements such as robotic process automation, mobile systems integration, artificial intelligence, and predictive analytics. 5 Lead database design solution including data integration, ETLs, schema definition, stored procedures creation, tables structures, indexes, and reporting views. 6 Manage infrastructure project for data center migrations including Linux RedHat7, Microsoft Window Servers, Oracle Solaris. 7 Leverage various tools for data extraction, data mining, analysis, prototype development, system Integration, and reporting including SAS, C,C, PERL scripting, SWIFT, used structure query language such as MySQL and PLSQL, MS Access, MS Power Pivot, MS Excel, Qlikview Reporting, MS Power BI, MS SQL Server, Oracle DBMS, GitLab, MS Visio, ADP workforce, CRM, Salesforce, SVN, PeopleSoft ERP, Oracle ERP, SAP ERP, Hyperion, OneSumX, SAP Crystal Reports. 8 Coordinate and participate in systems integration assessment to install financial systems either on premise andor cloud infrastructure such as AMS and Azure. 9 Leverage various tools to perform systems installation assessments including MS Word, MS Excel, Monte Carlo Price Simulation in Excel, MS Visio and MS PowerPoint.

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

SWA Job Order End Date

2021-08-26

Sunday Edition Newspaper

Y

First Newspaper Name

The StartLedger, Affiliated with NJ.COM

First Advertisement Start Date

2021-07-25

Second Newspaper Ad Name

The StartLedger, Affiliated with NJ.COM

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-08-01

Employer Website From Date

2021-09-28

Employer Website To Date

2021-10-08

Professional Organization Ad From Date

2022-01-01 11:34:48

Professional Organization Advertisement To Date

2022-01-01 11:34:48

Job Search Website From Date

2021-07-22

Job Search Website To Date

2021-08-05

Employee Referral Program From Date

2022-01-01 11:34:48

Employee Referral Program To Date

2022-01-01 11:34:48

Local Ethnic Paper From Date

2021-07-28

Local Ethnic Paper To Date

2021-07-28

Radio/TV Ad From Date

2022-01-01 11:34:48

Radio/TV Ad To Date

2022-01-01 11:34:48

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

AGRICULTURAL ECONOMICS

Foreign Worker Years of Education Completed

2006

Foreign Worker Institution of Education

THE UNIVERSITY OF ARKANSAS

Foreign Worker Education Institution Address 1

217 AGRICULTURE BUILDING

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

FAYETTEVILLE

Foreign Worker Education Institution State/Province

AR

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

72701

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Arit Butani

Preparer Title

Attorney

Preparer Email

abutani@fisherphillips.com

Employer Information Declaration Name

Charo Astrosky

Employer Information Declaration Title

Director, Human Resources