Fiscal Year

2020

Case Number

A-19197-31269

Case Status

Certified-Expired

Received Date

2019-08-28

Decision Date

2019-12-05

Refile

N

Original File Date

2020-01-01 07:36:52

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

MORGAN STANLEY BANK NA

Employer Name Slug

morgan-stanley-bank-na

Employer Address 1

201 SOUTH MAIN STREET

Employer Address 2

5TH FLOOR

Employer City

SALT LAKE CITY

Employer City Slug

salt-lake-city

Employer State

UTAH

Employer State Slug

utah

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

84111

Employer Phone

212-761-4000

Employer Number of Employees

58063

Employer Year Commenced Business

1935

NAICS Code

523110

FW Ownership Interest

N

Employer Contact Name

Joanna Lau

Employer Contact Address 1

1585 Broadway

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

10036

Employer Contact Phone

212-761-9436

Employer Contact Email

joanna.lau@morganstanley.com

Agent Attorney Name

Katherine C MacIlwaine

Agent Attorney Firm Name

Ogletree Deakins

Agent Attorney Phone

(919) 787-9700

Agent Attorney Address 1

P.O. Box 31608

Agent Attorney Address 2

Agent Attorney City

Raleigh

Agent Attorney State/Province

NORTH CAROLINA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

27622

Agent Attorney Email

Katherine.MacIlwaine@ogletreedeakins.com

PW Track Number

P10018263154221

PW SOC Code

11-3031

PW SOC Title

Treasures and Controllers

PW Skill Level

N/A

PW Wage

112237.00

PW Unit of Pay

Year

PW Wage Source

Other

PW Determination Date

2019-02-19

PW Expiration Date

2019-06-30

Wage Offer From

112237.00

Wage Offer To

112237.00

Average Salary

112237.00

Wage Unit of Pay

Year

Worksite Address 1

1585 Broadway

Worksite Address 2

Worksite City

New York

Worksite City Slug

new-york

Worksite State

NEW YORK

Worksite Postal Code

10036

Job Title

Capital Planning Analyst (Sr. Manager)

Job Title Slug

capital-planning-analyst-sr-manager

Minimum Education

Master's

Major Field of Study

Public Administration

Required Training

N

Required Experience

Y

Required Experience Months

36

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Business Administration, Finance, Economics, or related 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

36

Accept Alternative Job Title

Financial Controller, Trade Support Analyst, Financial Planning and Analyst, Data Analyst, or relate

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Requires three 3 years of experience at a Globally Systemically Important Bank GSIB within banking and accounting functions.br br Requires three years of experience with calculation of GAAP for financial reporting; process automation; technologybased enhancements and user acceptance testing; project management; quality control, reconciliation and variance analysis; managing multiple, simultaneous projects and processes, and presenting to management; Visual Basic coding; PowerPoint; Excel; Word; with SharePoint; and Bloomberg.br br Requires two 2 years with application of Basel III regulatory capital regime; strategic analysis; balance sheet analytics, allocation and optimization; managing deliverables across gt;10 business units and corporate functions; financial analysis including product valuation adjustment and product profitability; and calculations for booking intercompany transactions.br br Requires any amount of experience with database tools including Microsoft Access.br br Requires passing Levels I, II and III of the CFA Chartered Financial Analyst exam

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

2019-04-12

SWA Job Order End Date

2019-05-13

Sunday Edition Newspaper

Y

First Newspaper Name

The New York Times

First Advertisement Start Date

2019-05-05

Second Newspaper Ad Name

The New York Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-05-12

Employer Website From Date

2019-04-12

Employer Website To Date

2019-05-16

Professional Organization Ad From Date

2020-01-01 07:36:52

Professional Organization Advertisement To Date

2020-01-01 07:36:52

Job Search Website From Date

2020-01-01 07:36:52

Job Search Website To Date

2020-01-01 07:36:52

Employee Referral Program From Date

2019-04-12

Employee Referral Program To Date

2019-04-29

Local Ethnic Paper From Date

2019-05-08

Local Ethnic Paper To Date

2019-05-08

Radio/TV Ad From Date

2020-01-01 07:36:52

Radio/TV Ad To Date

2020-01-01 07:36:52

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

CHINA

Foreign Worker Birth Country

CHINA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

PUBLIC ADMINISTRATION

Foreign Worker Years of Education Completed

2013

Foreign Worker Institution of Education

CORNELL UNIVERSITY

Foreign Worker Education Institution Address 1

294 CALDWELL HALL

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

ITHACA

Foreign Worker Education Institution State/Province

NY

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

14853

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Katherine MacIlwaine

Preparer Title

Associate

Preparer Email

Katherine.MacIlwaine@ogletreedeakins.com

Employer Information Declaration Name

Joanna Lau

Employer Information Declaration Title

Principal Resource Specialist