All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21159-97688
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21159-97688
Case Status
Certified-Expired
Received Date
2021-06-15
Decision Date
2021-11-30
Refile
N
Original File Date
2022-01-01 10:30:43
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
2753
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
Law Offices of Roan M. Lum, P.C.
Agent Attorney Address 2
691 N. Squirrel Road, Ste. 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
P10021026033369
PW SOC Code
15-1121
PW SOC Title
Computer Systems Analyst
PW Skill Level
Level IV
PW Wage
103397.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-06-08
PW Expiration Date
2021-09-06
Wage Offer From
107888.00
Wage Offer To
0.00
Average Salary
107888.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
Senior Financial Systems Administrator
Job Title Slug
senior-financial-systems-administrator
Minimum Education
Bachelor's
Major Field of Study
Computer Science, Information Technology, MIS, or Engineering (Electronics or Electrical)
Required Training
N
Required Experience
N
Required Experience Months
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
N
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
84
Accept Alternative Job Title
any suitable IT position working with skill sets as set forth in item H.14
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Bachelors degree in Computer Science, Information Technology, MIS, or Engineering Electronics or Electrical and minimum 7 years of financial reporting management experience, including entire EPM architecture and data flow between DRM, Essbase, Shared Services, Workspace, Planning, HSF, and MaxL scripts, including experience with Oracle EPM Cloud and onpremise applications.br br Remote work from residence in Michigan permitted with requirement to work at Corporate HQ in Troy, Michigan, as required.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 Due to the technical nature of the services we provide and the myriad of regulatory requirements that our Bank must adhere to, Flagstar maintains its own inhouse IT department, which is responsible for designing software programs and maintaining our IT infrastructure specifically tailored to meet the needs of our Bank and to continually increase the efficiency of our services while protecting and maintaining the confidentiality of the financial and banking records of our customers.br br The position of Senior Financial Systems Administrator is an essential position within the Bank. The Senior Financial Systems Administrator acts as a liaison between Finance and the IT department to facilitate the support of the Finance Reporting environment, including problem analysis and solution development. The person must interpret business requirements and develop additional processes to support Financial Planning Analysis FP A, Financial Accounting, and General Accounting, including Essbase cubes, additional mappings from the Finance Reporting environment to Hyperion Planning and Essbase databases. The Senior Financial Systems Administrator is also responsible for developing calculation scripts, business rules, load rules, partitions, SmartView templates, planning forms, data load processes and data reconciliations to support new or revised processes for Finance.br br To adequately perform the duties, it is necessary that the Senior Financial Systems Administrator, possess, at a minimum, a Bachelors Degree in Computer Science, Information Technology, MIS, or Engineering Electrical, or Electronics and a minimum of seven 7 years of financial reporting management experience, including entire EPM architecture and data flow between DRM, Essbase, Shared Services, Workspace, Planning, HSF, and MaxL scripts, including experience with Oracle EPM Cloud and onpremise applications.br br A person who fills the proffered position within the Bank cannot properly carry out the duties and responsibilities of a Senior Financial Systems Administrator without the required experience in the stated skill sets and formal education.
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-03-17
SWA Job Order End Date
2021-04-16
Sunday Edition Newspaper
Y
First Newspaper Name
Detroit News and Free Press
First Advertisement Start Date
2021-03-14
Second Newspaper Ad Name
Detroit News and Free Press
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-03-21
Employer Website From Date
2021-03-26
Employer Website To Date
2021-04-27
Professional Organization Ad From Date
2022-01-01 10:30:43
Professional Organization Advertisement To Date
2022-01-01 10:30:43
Job Search Website From Date
2021-03-14
Job Search Website To Date
2021-04-13
Employee Referral Program From Date
2022-01-01 10:30:43
Employee Referral Program To Date
2022-01-01 10:30:43
Local Ethnic Paper From Date
2022-01-01 10:30:43
Local Ethnic Paper To Date
2022-01-01 10:30:43
Radio/TV Ad From Date
2022-01-01 10:30:43
Radio/TV Ad To Date
2022-01-01 10:30:43
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
COMPUTER INFORMATION SCIENCE
Foreign Worker Years of Education Completed
2010
Foreign Worker Institution of Education
GANNON UNIVERSITY
Foreign Worker Education Institution Address 1
109 UNIVERSITY SQUARE
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
ERIE
Foreign Worker Education Institution State/Province
PA
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
16541
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