All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-23065-08826
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-23065-08826
Case Status
Certified-Expired
Received Date
2023-03-13
Decision Date
2024-04-01
Refile
N
Original File Date
2024-01-01 00:56:49
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
ESSILOR OF AMERICA, INC
Employer Name Slug
essilor-of-america-inc
Employer Address 1
13555 N. STEMMONS FRWY
Employer Address 2
Employer City
DALLAS
Employer City Slug
dallas
Employer State
TEXAS
Employer State Slug
texas
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
75234
Employer Phone
2142074880
Employer Number of Employees
10000
Employer Year Commenced Business
1985
NAICS Code
333314
FW Ownership Interest
N
Employer Contact Name
Sharon Martin
Employer Contact Address 1
13555 N. Stemmons Frwy
Employer Contact Address 2
Employer Contact City
Dallas
Employer Contact State/Province
TEXAS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
75234
Employer Contact Phone
2142074880
Employer Contact Email
sharon.martin@essilorusa.com
Agent Attorney Name
Anjali Nanda
Agent Attorney Firm Name
Berry Appleman Leiden LLP
Agent Attorney Phone
7209190806
Agent Attorney Address 1
1900 Wazee St
Agent Attorney Address 2
Suite 303
Agent Attorney City
Denver
Agent Attorney State/Province
COLORADO
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
80202
Agent Attorney Email
anjali.nanda@bal.com
PW Track Number
P10022153238145
PW SOC Code
15-1243.00
PW SOC Title
Database Architects
PW Skill Level
Level IV
PW Wage
148512.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-12-17
PW Expiration Date
2023-06-30
Wage Offer From
148512.00
Wage Offer To
0.00
Average Salary
148512.00
Wage Unit of Pay
Year
Worksite Address 1
13555 N Stemmons Freeway
Worksite Address 2
Worksite City
Dallas
Worksite City Slug
dallas
Worksite State
TEXAS
Worksite Postal Code
75234
Job Title
Sr. Data Visualization Analyst
Job Title Slug
sr-data-visualization-analyst
Minimum Education
Bachelor's
Major Field of Study
Information Systems
Required Training
N
Required Experience
Y
Required Experience Months
60
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Computer Science, Data Analytics, 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
60
Accept Alternative Job Title
Related occupation
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Employer will accept a Bachelors degree in Computer Science, Information Systems, Data Analytics or related field and five years of progressive, postbaccalaureate work experience in job offered or five years of progressive, postbaccalaureate work experience in a related occupation. Experience must includebr 1. 3 years of scripting and data modeling experience using Qlik Sense Enterprise Solution building scalable reporting solutions;br 2. Utilizing Qlik Sense Platform to create and maintain multisource Data Lake and set up ETL tasks to consume this data.br 3. Scheduling tasks, setting up security rules, debugging errors and going through the task logs from the Qlik management console on a platform serving over 500 users.br 4. 5 years of experience with database scripting and querying tools Oracle SQL or Microsoft SQL Server;br 5. Analyzing large and complex data sets to solve business problems and create data models, visualizations, metrics, and dashboards that drive strategic direction;br 6. IT Project Management;br 7. Applying Agile software development methodology and utilizing scrum framework.br br Essilor requires background checks and drug testing.br br Beneficiary meets the petitioners requirements for the petition.
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-01-06
SWA Job Order End Date
2023-02-10
Sunday Edition Newspaper
Y
First Newspaper Name
The Dallas Morning News
First Advertisement Start Date
2022-12-18
Second Newspaper Ad Name
The Dallas Morning News
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-12-25
Employer Website From Date
2024-01-01 00:56:49
Employer Website To Date
2024-01-01 00:56:49
Professional Organization Ad From Date
2022-12-16
Professional Organization Advertisement To Date
2022-12-23
Job Search Website From Date
2022-12-15
Job Search Website To Date
2022-12-22
Employee Referral Program From Date
2024-01-01 00:56:49
Employee Referral Program To Date
2024-01-01 00:56:49
Local Ethnic Paper From Date
2022-12-30
Local Ethnic Paper To Date
2023-01-05
Radio/TV Ad From Date
2024-01-01 00:56:49
Radio/TV Ad To Date
2024-01-01 00:56:49
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 SYSTEMS
Foreign Worker Years of Education Completed
2016
Foreign Worker Institution of Education
GEORGIA STATE UNIVERSITY
Foreign Worker Education Institution Address 1
35 BROAD ST NW
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
ATLANTA
Foreign Worker Education Institution State/Province
GA
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
30303
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Anjali Nanda
Preparer Title
Associate Attorney
Preparer Email
anjali.nanda@bal.com
Employer Information Declaration Name
Sharon Martin
Employer Information Declaration Title
Immigration and Mobility Analyst