All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-19169-20109
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-19169-20109
Case Status
Certified-Expired
Received Date
2019-08-02
Decision Date
2019-10-11
Refile
N
Original File Date
2020-01-01 07:26:00
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
THE RUBICON PROJECT
Employer Name Slug
the-rubicon-project
Employer Address 1
12181 BLUFF CREEK DRIVE, 4THFLOOR
Employer Address 2
Employer City
PLAYA VISTA
Employer City Slug
playa-vista
Employer State
CALIFORNIA
Employer State Slug
california
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
90094
Employer Phone
(310) 207-0272
Employer Number of Employees
530
Employer Year Commenced Business
2007
NAICS Code
541810
FW Ownership Interest
N
Employer Contact Name
Shawna Hughes
Employer Contact Address 1
12181 BLUFF CREEK DRIVE, 4TH FLOOR
Employer Contact Address 2
Employer Contact City
PLAYA VISTA
Employer Contact State/Province
CALIFORNIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
90094
Employer Contact Phone
(424) 293-7322
Employer Contact Email
shughes@rubiconproject.com
Agent Attorney Name
Shelly Song
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Agent Attorney Phone
3108203322
Agent Attorney Address 1
444 South Flower Street
Agent Attorney Address 2
Suite 500
Agent Attorney City
Los Angeles
Agent Attorney State/Province
CALIFORNIA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
90071
Agent Attorney Email
ssong@fragomen.com
PW Track Number
P10018316600056
PW SOC Code
13-2031
PW SOC Title
Budget Analysts
PW Skill Level
Level IV
PW Wage
92019.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-03-22
PW Expiration Date
2019-06-30
Wage Offer From
118450.00
Wage Offer To
0.00
Average Salary
118450.00
Wage Unit of Pay
Year
Worksite Address 1
180 Madison Avenue
Worksite Address 2
14th Floor
Worksite City
New York
Worksite City Slug
new-york
Worksite State
NEW YORK
Worksite Postal Code
10016
Job Title
Global Revenue, Financial Planning and Analysis Manager
Job Title Slug
global-revenue-financial-planning-and-analysis-manager
Minimum Education
Bachelor's
Major Field of Study
Mathematics, Economics, Fianance, Engineering Any, or rltd quantitative field of study
Required Training
N
Required Experience
Y
Required Experience Months
72
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
72
Accept Alternative Job Title
Budget Analyst, Senior Associate, Manager, or related occupation
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Experience with analyzing a large amount of financial and operational data using advanced Excel functions i.e. pivot tables, lookup, text, and reference functions; Experience with centralized planningreporting tools; Experience with Advanced financial modeling skills including 3 statement models schedules, pivot tables, advanced formulas, and VBA; Experience with Advanced PowerPoint creation, ability to link visualizations data to other software for an executive audience; Experience with working in databases, querying a large amount of data for input into visualization software and Advanced visualization techniques; Experience benchmarking companies and compiling valuation multiplesKPIs using Industrymarket data and public company financial information; CFA Chartered Financial Analyst.br br Experience in H.6A and H.10A must be post baccalaureate and progressive. Any suitable combination of education, training, or experience is acceptable. The years of experience listed in H.6A and H.10A do not apply to the required skills listed in this section. The employer will accept any level of experience or proficiency in the specific skills listed in this section.
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-03-27
SWA Job Order End Date
2019-04-30
Sunday Edition Newspaper
Y
First Newspaper Name
New York Times
First Advertisement Start Date
2019-04-14
Second Newspaper Ad Name
New York Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-04-21
Employer Website From Date
2020-01-01 07:26:00
Employer Website To Date
2020-01-01 07:26:00
Professional Organization Ad From Date
2019-04-11
Professional Organization Advertisement To Date
2019-04-18
Job Search Website From Date
2019-04-15
Job Search Website To Date
2019-04-22
Employee Referral Program From Date
2020-01-01 07:26:00
Employee Referral Program To Date
2020-01-01 07:26:00
Local Ethnic Paper From Date
2019-04-17
Local Ethnic Paper To Date
2019-04-17
Radio/TV Ad From Date
2020-01-01 07:26:00
Radio/TV Ad To Date
2020-01-01 07:26:00
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
CANADA
Foreign Worker Birth Country
CANADA
Class of Admission
L-1
Foreign Worker Education
Bachelor's
Foreign Worker Information: Major
ENGINEERING CHEMICAL
Foreign Worker Years of Education Completed
2008
Foreign Worker Institution of Education
UNIVERSITY OF COLORADO
Foreign Worker Education Institution Address 1
OFFICE OF THE REGISTRAR
Foreign Worker Education Institution Address 2
UNIVERSITY OF COLORADO BOULDER, 20 UCB
Foreign Worker Education Institution City
BOULDER
Foreign Worker Education Institution State/Province
CO
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
80309
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Shelly Song
Preparer Title
Associate Attorney
Preparer Email
ssong@fragomen.com
Employer Information Declaration Name
Nihal Shawna F Solomon Hughes
Employer Information Declaration Title
Senior Technical Recruiter Head of HR