All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-23103-26904
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-23103-26904
Case Status
Certified
Received Date
2023-04-28
Decision Date
2024-05-10
Refile
N
Original File Date
2024-01-01 01:20:16
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
OSISOFT, LLC
Employer Name Slug
osisoft-llc
Employer Address 1
1600 ALVARADO STREET
Employer Address 2
Employer City
SAN LEANDRO
Employer City Slug
san-leandro
Employer State
CALIFORNIA
Employer State Slug
california
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
94577
Employer Phone
510-347-2600
Employer Number of Employees
905
Employer Year Commenced Business
1980
NAICS Code
511210
FW Ownership Interest
N
Employer Contact Name
Bob / Mark / Bob LaRue / Burns / Guilbault
Employer Contact Address 1
1600 Alvarado Street
Employer Contact Address 2
Employer Contact City
San Leandro
Employer Contact State/Province
CALIFORNIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
94577
Employer Contact Phone
510-877-9429
Employer Contact Email
lgarcia@osisoft.com
Agent Attorney Name
DANY PIKMAN
Agent Attorney Firm Name
Corporate Immigration Partners LLP
Agent Attorney Phone
415-771-7500
Agent Attorney Address 1
465 CALIFORNIA STREET
Agent Attorney Address 2
SUITE 700
Agent Attorney City
SAN FRANCISCO
Agent Attorney State/Province
CALIFORNIA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
94104
Agent Attorney Email
osisoft@cipllp.com
PW Track Number
P10022089021865
PW SOC Code
11-3021
PW SOC Title
Computer and Information Systems Managers
PW Skill Level
Level IV
PW Wage
248768.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-10-05
PW Expiration Date
2023-06-30
Wage Offer From
248768.00
Wage Offer To
268768.00
Average Salary
258768.00
Wage Unit of Pay
Year
Worksite Address 1
1600 Alvarado Street
Worksite Address 2
Worksite City
San Leandro
Worksite City Slug
san-leandro
Worksite State
CALIFORNIA
Worksite Postal Code
94577
Job Title
Director, Sales Data Management
Job Title Slug
director-sales-data-management
Minimum Education
Bachelor's
Major Field of Study
Computer Engineering, Computer Science, or related field
Required Training
N
Required Experience
Y
Required Experience Months
84
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Computer Engineering, Computer Science, or related field
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
in job offered, in Software Data Management, Software Development, or in a related occupation.
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Position requires a Bachelor of Science or foreign degree equivalent in Computer Engineering, Computer Science, or related field, plus seven 7 years of experience in job offered, in Software Data Management, Software Development, or in a related occupation.br br Education or experience must includebr br 1. Microsoft MS SQL Server;br 2. Relational database concepts and database operation best practices;br 3. SQL Scripting;br 4. Data Warehouse DataMart;br 5. Data Quality and Metadata Management;br 6. Data Modeling;br 7. Azure Synapse;br 8. Power BI developmentmaintenance;br 9. Tableau CRM dashboard developmentmaintenance;br 10. SQL Server Integration Services SSIS development;br 11. SQL Server Analysis Services SSAS development; andbr 12. Advanced Analytics using R and Python.
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
2023-02-10
SWA Job Order End Date
2023-03-15
Sunday Edition Newspaper
Y
First Newspaper Name
San Francisco Chronicle
First Advertisement Start Date
2023-03-19
Second Newspaper Ad Name
San Francisco Chronicle
Second Advertisement Type
Newspaper
Second Ad Start Date
2023-03-26
Employer Website From Date
2024-01-01 01:20:16
Employer Website To Date
2024-01-01 01:20:16
Professional Organization Ad From Date
2024-01-01 01:20:16
Professional Organization Advertisement To Date
2024-01-01 01:20:16
Job Search Website From Date
2023-03-14
Job Search Website To Date
2023-03-27
Employee Referral Program From Date
2024-01-01 01:20:16
Employee Referral Program To Date
2024-01-01 01:20:16
Local Ethnic Paper From Date
2023-03-22
Local Ethnic Paper To Date
2023-03-28
Radio/TV Ad From Date
2023-03-22
Radio/TV Ad To Date
2023-03-23
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
COMPUTER ENGINEERING
Foreign Worker Years of Education Completed
2010
Foreign Worker Institution of Education
UNIVERSITY OF RAJASTHAN, JAIPUR
Foreign Worker Education Institution Address 1
JAWAHAR LAL NEHRU MARG, RAJASTHAN UNIVERSITY CAMPUS
Foreign Worker Education Institution Address 2
TALVANDI
Foreign Worker Education Institution City
JAIPUR
Foreign Worker Education Institution State/Province
RAJASTHAN
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
302004
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Dany Pikman
Preparer Title
Supervising Attorney
Preparer Email
osisoft@cipllp.com
Employer Information Declaration Name
Leticia Garcia
Employer Information Declaration Title
Immigration Global Mobility Specialist