All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20037-16376
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-20037-16376
Case Status
Certified
Received Date
2020-03-09
Decision Date
2020-07-13
Refile
N
Original File Date
2020-01-01 08:36:51
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
259000
Employer Year Commenced Business
1852
NAICS Code
52399
FW Ownership Interest
N
Employer Contact Name
Rachael A 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
Matthew A Gorman
Agent Attorney Firm Name
Baker McKenzie LLP
Agent Attorney Phone
3128618666
Agent Attorney Address 1
300 East Randolph Street
Agent Attorney Address 2
Suite 5000
Agent Attorney City
Chicago
Agent Attorney State/Province
ILLINOIS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
60601
Agent Attorney Email
matthew.gorman@bakermckenzie.com
PW Track Number
P10019091557121
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level IV
PW Wage
114358.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-08-29
PW Expiration Date
2020-06-30
Wage Offer From
114358.00
Wage Offer To
162500.00
Average Salary
138429.00
Wage Unit of Pay
Year
Worksite Address 1
6200 Park Ave
Worksite Address 2
Worksite City
Des Moines
Worksite City Slug
des-moines
Worksite State
IOWA
Worksite Postal Code
50321
Job Title
Database Analyst 5
Job Title Slug
database-analyst-5
Minimum Education
Bachelor's
Major Field of Study
COMP. SCIENCE, ENGINEERING, OR REL.
Required Training
N
Required Experience
Y
Required Experience Months
84
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
84
Accept Alternative Job Title
See H.14 below
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
MUST HAVE BACHELORS DEGREE IN COMPUTER SCIENCE, ENGINEERING, OR A RELATED FIELD 7YRS OF PROGRESSIVELY RESPONSIBLE EXP. WDATABASE DESIGN ADMINISTRATION, INCLUDING 7 YRS EXP WSQL SERVER, TSQL, AND SSIS DATABASE MODELING TOOLS. MUST HAVE 4 YEARS OF EXP WITH EACH OF THE FOLLOWING CODING IN .NET, DEVELOPINGSUPPORTING DTS SSIS PACKAGES; DIAGNOSING RESOLVING PERFORMANCE ISSUES; DBA IN SQL, SQL SERVER ANALYSIS SERVER, MICROSOFT OFFICE BI; DATA WAREHOUSE DESIGN, IMPLEMENTATION, MINING, INCLUDING SETTING UP BACKUPS EMERGENCY FAILOVER RUNNING TOOLS TO DEBUG ANY DATABASERELATED ISSUES. EXP. MAY BE GAINED CONCURRENTLY.
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-12-20
SWA Job Order End Date
2020-01-24
Sunday Edition Newspaper
Y
First Newspaper Name
Des Moines Register
First Advertisement Start Date
2019-10-13
Second Newspaper Ad Name
Des Moines Register
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-10-20
Employer Website From Date
2019-09-13
Employer Website To Date
2019-10-13
Professional Organization Ad From Date
2020-01-01 08:36:51
Professional Organization Advertisement To Date
2020-01-01 08:36:51
Job Search Website From Date
2019-10-04
Job Search Website To Date
2019-10-13
Employee Referral Program From Date
2020-01-01 08:36:51
Employee Referral Program To Date
2020-01-01 08:36:51
Local Ethnic Paper From Date
2019-10-25
Local Ethnic Paper To Date
2019-10-25
Radio/TV Ad From Date
2020-01-01 08:36:51
Radio/TV Ad To Date
2020-01-01 08:36:51
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
Foreign Worker Education
Bachelor's
Foreign Worker Information: Major
ELECTRONICS AND TELECOMMUNICATION ENGINEERING
Foreign Worker Years of Education Completed
1999
Foreign Worker Institution of Education
DR. BABASAHEB AMBEDKAR TECHNOLOGICAL UNIVERSITY
Foreign Worker Education Institution Address 1
VIDYAVIHAR, LONERE, TALUKA MANGAON, RAIGAD
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
LONERE
Foreign Worker Education Institution State/Province
MAHARASHTRA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
402103
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
N
Employer Completed Application
N
Preparer Name
Matthew A Gorman
Preparer Title
Associate
Preparer Email
Baker & McKenzie LLP
Employer Information Declaration Name
Declan Mumford
Employer Information Declaration Title
Immigration Consultant