All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-19252-54892
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-19252-54892
Case Status
Certified-Expired
Received Date
2019-09-20
Decision Date
2020-02-07
Refile
N
Original File Date
2020-01-01 07:57:10
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
DELOITTE CONSULTING LLP
Employer Name Slug
deloitte-consulting-llp
Employer Address 1
1700 MARKET STREET
Employer Address 2
Employer City
PHILADELPHIA
Employer City Slug
philadelphia
Employer State
PENNSYLVANIA
Employer State Slug
pennsylvania
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
19103
Employer Phone
214-840-1464
Employer Number of Employees
21000
Employer Year Commenced Business
1996
NAICS Code
54161
FW Ownership Interest
N
Employer Contact Name
Zarina Godhrawala
Employer Contact Address 1
1700 Market Street
Employer Contact Address 2
Employer Contact City
Philadelphia
Employer Contact State/Province
PENNSYLVANIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
19103
Employer Contact Phone
3124863928
Employer Contact Email
zgodhrawala@deloitte.com
Agent Attorney Name
Gabriel Castillo
Agent Attorney Firm Name
Garson LLP
Agent Attorney Phone
416-363-1234
Agent Attorney Address 1
22 Adelaide Street W
Agent Attorney Address 2
9th Floor
Agent Attorney City
Toronto
Agent Attorney State/Province
Ontario
Agent Attorney Country
CANADA
Agent Attorney Postal Code
M5H4E3
Agent Attorney Email
dcperm@ggsilaw.com
PW Track Number
P10019067611771
PW SOC Code
15-1132
PW SOC Title
Software Developers, Applications
PW Skill Level
Level I
PW Wage
61922.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-06-25
PW Expiration Date
2019-09-23
Wage Offer From
69000.00
Wage Offer To
104000.00
Average Salary
86500.00
Wage Unit of Pay
Year
Worksite Address 1
Deloitte Consulting LLP, 901 International Parkway
Worksite Address 2
Various unanticipated Deloitte office locations and client sites nationally
Worksite City
Lake Mary
Worksite City Slug
lake-mary
Worksite State
FLORIDA
Worksite Postal Code
32746
Job Title
Solution Specialist, Costumer & Marketing, Digital Customer
Job Title Slug
solution-specialist-costumer-marketing-digital-customer
Minimum Education
Bachelor's
Major Field of Study
See H.14
Required Training
N
Required Experience
Y
Required Experience Months
12
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
See H.14
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
12
Accept Alternative Job Title
See H.14
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Bachelors degree or foreign equivalent degree in Business Administration, any STEM degree or a related field. One year of experience in the offered position or a position in a related occupation. Must have one year of experience with Implementing Security and Sharing Rules at objectlevel, fieldlevel and recordlevel for different users; Expediting and automating the Extraction, Transformation, Load ETL process using Mule; Extracting source data by writing complex SQL queries in SQL Server Management Studio; Validating sources and target data using SQL validation scripts and SQL queries; Developing complex declarative solutions using Workflows, Approval Processes, Flows, Assignment Rules, Process Builders, Validation Rules to implement business logic; Debugging Apex code and front end JavaScript to resolve critical incidents reported in the Production environment; Conducting Data Migration from the legacy system to Salesforce; Developing exception handling mechanism to catch defects for Mulesoft Integrations with Salesforce. 15 travel required.
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
2019-07-03
SWA Job Order End Date
2019-08-07
Sunday Edition Newspaper
Y
First Newspaper Name
Orlando Sentinel
First Advertisement Start Date
2019-07-07
Second Newspaper Ad Name
Orlando Sentinel
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-07-14
Employer Website From Date
2019-07-03
Employer Website To Date
2019-09-11
Professional Organization Ad From Date
2020-01-01 07:57:10
Professional Organization Advertisement To Date
2020-01-01 07:57:10
Job Search Website From Date
2019-07-04
Job Search Website To Date
2019-07-10
Employee Referral Program From Date
2019-07-03
Employee Referral Program To Date
2019-07-24
Local Ethnic Paper From Date
2020-01-01 07:57:10
Local Ethnic Paper To Date
2020-01-01 07:57:10
Radio/TV Ad From Date
2020-01-01 07:57:10
Radio/TV Ad To Date
2020-01-01 07:57:10
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
INFORMATION SYSTEMS AND OPERATIONS MANAGEMENT
Foreign Worker Years of Education Completed
2016
Foreign Worker Institution of Education
THE UNIVERSITY OF FLORIDA
Foreign Worker Education Institution Address 1
HUB, 1765, STADIUM ROAD
Foreign Worker Education Institution Address 2
PO BOX 113225
Foreign Worker Education Institution City
GAINESVILLE
Foreign Worker Education Institution State/Province
FL
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
32611
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Gabriel Castillo
Preparer Title
Attorney
Preparer Email
dcperm@ggsilaw.com
Employer Information Declaration Name
Zarina Godhrawala
Employer Information Declaration Title
Manager, Immigration