Fiscal Year

2021

Case Number

A-21047-52632

Case Status

Certified

Received Date

2021-02-19

Decision Date

2021-07-21

Refile

N

Original File Date

2021-01-01 09:51:55

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

WELLS FARGO BANK, N.A.

Employer Name Slug

wells-fargo-bank-na

Employer Address 1

101 NORTH PHILLIPS AVENUE

Employer Address 2

Employer City

SIOUX FALLS

Employer City Slug

sioux-falls

Employer State

SOUTH DAKOTA

Employer State Slug

south-dakota

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

57104

Employer Phone

704-374-4920

Employer Number of Employees

260000

Employer Year Commenced Business

1852

NAICS Code

52399

FW Ownership Interest

N

Employer Contact Name

Rachael Kerpan

Employer Contact Address 1

350 W. Colorado Blvd.

Employer Contact Address 2

4th Floor

Employer Contact City

Pasadena

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

91105

Employer Contact Phone

626-590-0725

Employer Contact Email

rae.kerpan@wellsfargo.com

Agent Attorney Name

Jacob A Kanyusik

Agent Attorney Firm Name

Ogletree, Deakins, Nash, Smoak Stewart, P.C.

Agent Attorney Phone

9197879700

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

jake.kanyusik@ogletree.com

PW Track Number

P10020147601555

PW SOC Code

15-2041

PW SOC Title

Statisticians

PW Skill Level

Level I

PW Wage

92768.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-10-22

PW Expiration Date

2021-06-30

Wage Offer From

118483.00

Wage Offer To

156100.00

Average Salary

137291.50

Wage Unit of Pay

Year

Worksite Address 1

2030 Main St.

Worksite Address 2

Worksite City

Irvine

Worksite City Slug

irvine

Worksite State

CALIFORNIA

Worksite Postal Code

92614

Job Title

Analytic Consultant 4

Job Title Slug

analytic-consultant-4

Minimum Education

Master's

Major Field of Study

Computer Science

Required Training

N

Required Experience

Y

Required Experience Months

48

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer Applications, or a related field.

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

6

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

48

Accept Alternative Job Title

Analytic Cons, Data Engn, Bus Analyst, or related in database mgmt, reporting, analytics or modeling

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Position requires a Masters degree in Computer Science, Computer Applications, or a related field, and four 4 years of experience in the job offered or as an Analytic Consultant, Data Engineer, Business Analyst, or a related field in database management, reporting, analytics, or modeling. Alternately, will accept a Bachelors degree in Computer Science, Computer Applications, or a related field, and six 6 years in the job offered or as an Analytic Consultant, Data Engineer, Business Analyst, or a related field in database management, reporting, analytics, or modeling.br br Position also requires extensive knowledge and understanding of research and analysis. Requires experience with the integration of large data sets from multiple sources. Requires experience explaining highly complex technical work to business leaders. Requires extensive knowledge and indepth understanding of reporting in the finance, banking, and lending industries. Requires experience with relational databases, data analytics, SAS, and SQL function. Requires 4 years of SQL or SAS and other data management, reporting tool such as SSRS or Tableau. Requires 4 years of data warehouse experience. Requires 3 years of ETL Extract, Transform, Load programming experience. Requires 4 years of experience analyzing business requirements and transforming those into technical design.br br Requires experience with the systems and tools used in the team to support customer remediations, such as AFS Auto Finance System; Auto Data Warehouse; Brickyard; Teradata, System2 and Supreme legacy systems; CARS, ECAR, EXS, iTop, SHAW System of record for packages and loan products; SAS Enterprise Guide; and Toad for Oracle, SQL Server.br br Requires indepth knowledge of and understanding of consumer related remediation policy, process, and procedures. Requires indepth knowledge of Auto loans including origination, servicing, payment processing, repossessions, guaranteed asset protection GAP, addon products, charge off accounts, and bankruptcy. Requires ability to reverse engineer and recreate complex payment and recovery transactions by querying data using SAS Enterprise Guide 7.1. Requires extensive knowledge of daily simple interest loans, rule of 78 loans, banking and financial products that cross multiple lines of business such as deposits and personal lines of credit. Requires knowledge of the collections, recovery process and related business processes such as the assessment of fees, delinquency timeframes, negative credit reporting guidelines, and repossession statutes. Requires experience working with third party data to understand and apply large datasets to the overall business and remediation strategy.br br Requires ability and experience creating business requirements and translating those into technical design and coding those requirements such as waterfall logic, financial methodology, and explaining business justification. Requires experience working on customer remediation projects with deadline commitments to government agencies and regulators that cannot change. Requires experience acting as a project lead and liaison between nontechnical resources and data quality control analysts. Requires experience using pass through queries, IP switch, data modeling tool ERwin or Visio, SSIS, SRSS, Tableau, C#, Oracle TOAD, SQL Server, and Microsoft Office Suite. Requires expertise in Microsoft Excel. Requires extensive experience creating files for execution to send mass mailings to customers. Requires experience creating text files for making system updates.br br Requires extensive public speaking and ability to present complex data queries and make them easily understandable for audiences of Executive Leadership. Presentation experience must include explaining the data approach, data findings, and the final data populations.

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

2020-10-28

SWA Job Order End Date

2020-12-21

Sunday Edition Newspaper

Y

First Newspaper Name

The Orange County Register

First Advertisement Start Date

2020-11-29

Second Newspaper Ad Name

The Orange County Register

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-12-06

Employer Website From Date

2021-01-01 09:51:55

Employer Website To Date

2021-01-01 09:51:55

Professional Organization Ad From Date

2020-11-23

Professional Organization Advertisement To Date

2020-12-13

Job Search Website From Date

2021-01-01 09:51:55

Job Search Website To Date

2021-01-01 09:51:55

Employee Referral Program From Date

2021-01-01 09:51:55

Employee Referral Program To Date

2021-01-01 09:51:55

Local Ethnic Paper From Date

2020-12-03

Local Ethnic Paper To Date

2020-12-03

Radio/TV Ad From Date

2020-12-03

Radio/TV Ad To Date

2020-12-03

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

ENGINEERING MANAGEMENT

Foreign Worker Years of Education Completed

2016

Foreign Worker Institution of Education

INTERNATIONAL TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Institution Address 1

2010 EL CAMINO REAL #852

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

SANTA CLARA

Foreign Worker Education Institution State/Province

CA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

95050

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Jacob A Kanyusik

Preparer Title

Attorney

Preparer Email

jake.kanyusik@ogletree.com

Employer Information Declaration Name

Rachael A Kerpan

Employer Information Declaration Title

Immigration Consultant