All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20168-66124
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20168-66124
Case Status
Certified-Expired
Received Date
2020-08-14
Decision Date
2021-03-25
Refile
N
Original File Date
2021-01-01 09:08:45
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
FLAGSTAR BANK, FSB
Employer Name Slug
flagstar-bank-fsb
Employer Address 1
5151 CORPORATE DRIVE
Employer Address 2
Employer City
TROY
Employer City Slug
troy
Employer State
MICHIGAN
Employer State Slug
michigan
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
48098
Employer Phone
248 312 2000
Employer Number of Employees
4728
Employer Year Commenced Business
1987
NAICS Code
522120
FW Ownership Interest
N
Employer Contact Name
Kim A Bostwick
Employer Contact Address 1
5151 Corporate Drive
Employer Contact Address 2
Employer Contact City
Troy
Employer Contact State/Province
MICHIGAN
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
48098
Employer Contact Phone
248-312-5605
Employer Contact Email
kim.bostwick@flagstar.com
Agent Attorney Name
Rona M Lum
Agent Attorney Firm Name
Law Offices of Rona M. Lum
Agent Attorney Phone
2483401854
Agent Attorney Address 1
691 N. Squirrel Road
Agent Attorney Address 2
Suite 185
Agent Attorney City
Auburn Hills
Agent Attorney State/Province
MICHIGAN
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
48326
Agent Attorney Email
rlum@corpimmigration.us
PW Track Number
P10020073405366
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level IV
PW Wage
105498.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-06-04
PW Expiration Date
2020-09-02
Wage Offer From
107000.00
Wage Offer To
0.00
Average Salary
107000.00
Wage Unit of Pay
Year
Worksite Address 1
5151 Corporate Drive
Worksite Address 2
Worksite City
Troy
Worksite City Slug
troy
Worksite State
MICHIGAN
Worksite Postal Code
48098
Job Title
Servicing Transfer Data Quality and Analytics Lead
Job Title Slug
servicing-transfer-data-quality-and-analytics-lead
Minimum Education
Bachelor's
Major Field of Study
Information Systems or related field
Required Training
N
Required Experience
Y
Required Experience Months
72
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
Y
Accept Alternative Combination Education
None
Accept Alternative Combination Education Years
8
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
96
Accept Alternative Job Title
any IT related occupation utilizing skill sets as described in Item H.14
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Bachelors degree or foreign educational equivalent in Information Systems or related field of study and minimum 6 years of experience in mortgage loan servicing systems, boarding loans, and servicing transfer. Of the required 6 years, a minimum of 2 years must include experience working with relational and dimensional databases. Alternatively, Bank will accept eight 8 years of experience in the required skill sets in lieu of the education and experience requirement.br br br EXPLANATION OF BUSINESS NECESSITY FOR EXPERIENCE REQUIREMENTbr br Flagstar Bank, FSB the Bank is a whollyowned subsidiary of Flagstar Bancorp, Inc., a Michiganbased savings and loan holding company. Flagstar Bank is a federally chartered stock savings bank founded in 1987.br br We offer a wide range of financial products and services for individuals and businesses, from consumer loans and credit cards to cash management and merchant services. We bring the full resources of a commercial bank to our customers. We are also a national leader in home lending with loan centers across the country.br br A Servicing Transfer Data Quality and Analytics Lead with Flagstar Bank is a position that requires an individual with an advanced level of knowledge and experience in mortgage loan servicing systems, boarding loans, and servicing transfer. The individual must have the ability to lead and implement data solutions for flow and bulk boarding transfer quality standards, and reporting on transfer data and quality metrics. It is also important that the individual have experience working with relational and dimensional databases in order to properly fulfill the duties of this position. The individual must possess sophistication in building out initial databases and SQL for each loan transfer that the Bank encounters to identify gaps, and to provide critical input and feedback to senior level managers, such as the Director of Loan Boarding, Senior Manager Servicing Transfer, and the QA Project Manager to achieve the desired results for the Bank.br br It is necessary that the qualified individual possess, at a minimum, a Bachelors Degree or foreign educational equivalent in Information Systems or a related field of study and a minimum of six 6 years of experience in mortgage loan servicing systems, boarding loans, and servicing transfer. Of the required 6 years, a minimum of 2 years must include experience working with relational and dimensional databases. Alternatively, the Bank will accept eight 8 years of experience in the required skill sets in lieu of the education and experience requirement.br br Through the required formal education and or experience, an individual acquires the skills essential to effectively fulfill the technical duties and responsibilities of a Servicing Transfer Data Quality and Analytics Lead with Flagstar Bank.
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-03-26
SWA Job Order End Date
2020-04-28
Sunday Edition Newspaper
Y
First Newspaper Name
Detroit News and Free Press
First Advertisement Start Date
2020-03-29
Second Newspaper Ad Name
Detroit News and Free Press
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-04-05
Employer Website From Date
2020-03-25
Employer Website To Date
2020-04-30
Professional Organization Ad From Date
2021-01-01 09:08:45
Professional Organization Advertisement To Date
2021-01-01 09:08:45
Job Search Website From Date
2020-03-29
Job Search Website To Date
2020-04-28
Employee Referral Program From Date
2021-01-01 09:08:45
Employee Referral Program To Date
2021-01-01 09:08:45
Local Ethnic Paper From Date
2021-01-01 09:08:45
Local Ethnic Paper To Date
2021-01-01 09:08:45
Radio/TV Ad From Date
2021-01-01 09:08:45
Radio/TV Ad To Date
2021-01-01 09:08:45
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
Bachelor's
Foreign Worker Information: Major
CHEMISTRY
Foreign Worker Years of Education Completed
2003
Foreign Worker Institution of Education
UNIVERSITY OF MUMBAI
Foreign Worker Education Institution Address 1
123 MAHATMA GANDHI ROAD, KALA GHODA, FORT
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
MUMBAI
Foreign Worker Education Institution State/Province
MAHARASHTRA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
400032
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Rona M Lum
Preparer Title
Attorney
Preparer Email
rlum@corpimmigration.us
Employer Information Declaration Name
Kimberly Bostwick
Employer Information Declaration Title
HR Executive Administrative Assistant