All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21272-51444
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21272-51444
Case Status
Certified
Received Date
2021-10-25
Decision Date
2022-05-02
Refile
N
Original File Date
2022-01-01 11:23:12
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
SONY INTERACTIVE ENTERTAINMENT LLC
Employer Name Slug
sony-interactive-entertainment-llc
Employer Address 1
2207 BRIDGEPOINTE PARKWAY
Employer Address 2
Employer City
SAN MATEO
Employer City Slug
san-mateo
Employer State
CALIFORNIA
Employer State Slug
california
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
94404
Employer Phone
650-655-1633
Employer Number of Employees
110000
Employer Year Commenced Business
2010
NAICS Code
541511
FW Ownership Interest
N
Employer Contact Name
Anthony Cordner
Employer Contact Address 1
2207 Bridgepointe Parkway
Employer Contact Address 2
Employer Contact City
San Mateo
Employer Contact State/Province
CALIFORNIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
94404
Employer Contact Phone
650-655-1633
Employer Contact Email
Anthony.Cordner@sony.com
Agent Attorney Name
Raquel Liberman
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Agent Attorney Phone
2126888555
Agent Attorney Address 1
1400 Broadway
Agent Attorney Address 2
Agent Attorney City
New York
Agent Attorney State/Province
NEW YORK
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
10018
Agent Attorney Email
rliberman@fragomen.com
PW Track Number
P10020343941069
PW SOC Code
15-2041
PW SOC Title
Statisticians
PW Skill Level
Level I
PW Wage
80018.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-04-16
PW Expiration Date
2021-07-15
Wage Offer From
110000.00
Wage Offer To
0.00
Average Salary
110000.00
Wage Unit of Pay
Year
Worksite Address 1
2207 Bridgepointe Parkway
Worksite Address 2
Worksite City
San Mateo
Worksite City Slug
san-mateo
Worksite State
CALIFORNIA
Worksite Postal Code
94404
Job Title
Business Analyst
Job Title Slug
business-analyst
Minimum Education
Master's
Major Field of Study
Marketing Analytics, Business Operations Research, or related field or equivalent
Required Training
N
Required Experience
Y
Required Experience Months
24
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
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
24
Accept Alternative Job Title
Senior Analyst or related
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Two 2 year of experience providing integrated marketing analytical solutions to improve client decisionmaking. Prior experience must include two 2 years of experience leveraging advanced mathematical methods regression analysis, hypothesis testing, and incrementality testing to make recommendations; generating reports and applying statistical analysis to provide insights on advertising campaign performance and optimization; conducting primary and secondary research on best practices and market trends; analyzing quantitative and qualitative data to understand industry benchmarks for KPIs, leveraging data from Google Trends and Adobe Analytics; synthesizing recommendations using SQL, Python, ETL tools embedded in BI Platforms, and Excel VBA macros to map and join data from different platforms; visualizing data into charts and graphs through DOMO and Tableau to interpret data into insights and stories; preparing analysis and tracking of marketplace, technology and consumer demographic trends within and across industries; owning acceptance criteria for data and reporting to ensure the criteria meets team requirements; performing datarecaps and writing recommendation reports for future business initiatives; developing and maintaining reporting infrastructure utilizing DOMO, Tableau, and Datorama.; and utilizing SQL to query and extract valuable data sets for analysis.br br Any suitable combination of education, experience and training 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-05-18
SWA Job Order End Date
2021-06-18
Sunday Edition Newspaper
Y
First Newspaper Name
San Francisco Chronicle
First Advertisement Start Date
2021-08-15
Second Newspaper Ad Name
San Francisco Chronicle
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-08-22
Employer Website From Date
2021-05-20
Employer Website To Date
2021-06-04
Professional Organization Ad From Date
2022-01-01 11:23:12
Professional Organization Advertisement To Date
2022-01-01 11:23:12
Job Search Website From Date
2021-08-16
Job Search Website To Date
2021-08-30
Employee Referral Program From Date
2021-05-20
Employee Referral Program To Date
2021-06-04
Local Ethnic Paper From Date
2022-01-01 11:23:12
Local Ethnic Paper To Date
2022-01-01 11:23:12
Radio/TV Ad From Date
2022-01-01 11:23:12
Radio/TV Ad To Date
2022-01-01 11:23:12
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
CHINA
Foreign Worker Birth Country
CHINA
Class of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker Information: Major
INTEGRATED MARKETING MARKETING ANALYTICS
Foreign Worker Years of Education Completed
2016
Foreign Worker Institution of Education
NEW YORK UNIVERSITY
Foreign Worker Education Institution Address 1
7 E 12TH ST.
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
NEW YORK
Foreign Worker Education Institution State/Province
NY
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
10003
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Raquel Liberman
Preparer Title
Partner
Preparer Email
RLiberman@fragomen.com
Employer Information Declaration Name
ANTHONY CORDNER
Employer Information Declaration Title
Senior Manager, Global Mobility and Immigration