All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22113-45255
Fiscal year: 2023
Fiscal Year
2023
Case Number
A-22113-45255
Case Status
Certified
Received Date
2022-05-05
Decision Date
2023-01-23
Refile
N
Original File Date
2023-01-01 08:12:14
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
MOELIS COMPANY GROUP LP
Employer Name Slug
moelis-company-group-lp
Employer Address 1
399 PARK AVENUE
Employer Address 2
4TH FLOOR
Employer City
NEW YORK
Employer City Slug
new-york
Employer State
NEW YORK
Employer State Slug
new-york
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
10022
Employer Phone
212 883 3800
Employer Number of Employees
700
Employer Year Commenced Business
2007
NAICS Code
5239
FW Ownership Interest
N
Employer Contact Name
Katherine Pimentel
Employer Contact Address 1
399 Park Avenue
Employer Contact Address 2
4th Floor
Employer Contact City
New York
Employer Contact State/Province
NEW YORK
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
10022
Employer Contact Phone
212-883-6742
Employer Contact Email
Katherine.Pimentel@moelis.com
Agent Attorney Name
TienLi Loke Walsh
Agent Attorney Firm Name
Loke Walsh Immigration Law, PC
Agent Attorney Phone
310-454-7920
Agent Attorney Address 1
10555 Jefferson Blvd.
Agent Attorney Address 2
Suite A
Agent Attorney City
Culver City
Agent Attorney State/Province
CALIFORNIA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
90232
Agent Attorney Email
tl@lokewalsh.com
PW Track Number
P10021209488688
PW SOC Code
11-3021
PW SOC Title
Computer and Information Systems Managers
PW Skill Level
Level II
PW Wage
165610.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-01-18
PW Expiration Date
2022-06-30
Wage Offer From
165610.00
Wage Offer To
0.00
Average Salary
165610.00
Wage Unit of Pay
Year
Worksite Address 1
399 Park Ave
Worksite Address 2
4th Floor
Worksite City
New York
Worksite City Slug
new-york
Worksite State
NEW YORK
Worksite Postal Code
10022
Job Title
Vice President – Information Technology
Job Title Slug
vice-president-information-technology
Minimum Education
Master's
Major Field of Study
Comp Sci, Comp Engrg, Info Systems, Engrg or related
Required Training
N
Required Experience
Y
Required Experience Months
24
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Comp Sci, Comp Engrg, Info Systems, Engrg or related
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
24
Accept Alternative Job Title
Database administration or rel occups See H.14
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Requires a Masters degree in Computer Science, Computer Engineering, Information Systems, Engineering or related field, plus two 2 years of database administration or related experience in database server management, database design and application development lifecycle, including experience in database architecture; systems analysis; data modeling; backups, restores and recovery models; implementing operational automation using scripts; translating business needs into technical solutions; and troubleshooting and resolving database problems.br br Specific skills Also requires experience or knowledge in 1 Experience with onpremise and cloudbased enterprise systems, including Microsoft SQL Azure and Amazon Web Services; 2 Experience working with Windows server and Active Directory; 3 Knowledge of client and server connectivity and database consistency checks using DBCC utilities; 4 Knowledge of Stored Procedures, Functions, Views and Triggers; 5 Experience in Performance Tuning and Optimization PTO using native monitoring and troubleshooting tools; and 6 Knowledge of Windows PowerShell Scripts, Salesforce, Tableau and Collibrabr br Any level of experience or knowledge in the specific skills is acceptable.
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-11-29
SWA Job Order End Date
2021-12-30
Sunday Edition Newspaper
Y
First Newspaper Name
New York Times
First Advertisement Start Date
2021-12-05
Second Newspaper Ad Name
New York Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-12-12
Employer Website From Date
2021-11-29
Employer Website To Date
2021-12-31
Professional Organization Ad From Date
2023-01-01 08:12:14
Professional Organization Advertisement To Date
2023-01-01 08:12:14
Job Search Website From Date
2021-11-29
Job Search Website To Date
2021-12-31
Employee Referral Program From Date
2023-01-01 08:12:14
Employee Referral Program To Date
2023-01-01 08:12:14
Local Ethnic Paper From Date
2021-12-01
Local Ethnic Paper To Date
2021-12-01
Radio/TV Ad From Date
2023-01-01 08:12:14
Radio/TV Ad To Date
2023-01-01 08:12:14
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
ELECTRICAL AND COMPUTER ENGINEERING
Foreign Worker Years of Education Completed
2007
Foreign Worker Institution of Education
NEW YORK INSTITUTE OF TECHNOLOGY
Foreign Worker Education Institution Address 1
NORTHERN BLVD., VALENTINES LN.
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
OLD WESTBURY
Foreign Worker Education Institution State/Province
NY
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
11568
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
TienLi Loke Walsh
Preparer Title
Attorney
Preparer Email
tl@lokewalsh.com
Employer Information Declaration Name
Shelby Tillett
Employer Information Declaration Title
Executive Director, Human Capital Management