Fiscal Year

2020

Case Number

A-19260-59274

Case Status

Denied

Received Date

2019-12-03

Decision Date

2020-04-28

Refile

N

Original File Date

2020-01-01 07:59:58

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

COLORESCIENCE

Employer Name Slug

colorescience

Employer Address 1

2141 PALOMAR AIRPORT RD

Employer Address 2

SUITE 200

Employer City

CARLSBAD

Employer City Slug

carlsbad

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

92011

Employer Phone

760-610-0249

Employer Number of Employees

99

Employer Year Commenced Business

1999

NAICS Code

32562

FW Ownership Interest

N

Employer Contact Name

Christine Weiler

Employer Contact Address 1

2141 Palomar Airport Rd

Employer Contact Address 2

Suite 200

Employer Contact City

Carlsbad

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

92011

Employer Contact Phone

760-610-0249

Employer Contact Email

[email protected]

Agent Attorney Name

Agent Attorney Firm Name

Agent Attorney Phone

Agent Attorney Address 1

Agent Attorney Address 2

Agent Attorney City

Agent Attorney State/Province

Agent Attorney Country

Agent Attorney Postal Code

Agent Attorney Email

PW Track Number

PW SOC Code

15-1121

PW SOC Title

Business Systems Analyst

PW Skill Level

Level I

PW Wage

65666.00

PW Unit of Pay

Year

PW Wage Source

Employer Conducted

PW Determination Date

2019-09-17

PW Expiration Date

2020-12-31

Wage Offer From

71500.00

Wage Offer To

0.00

Average Salary

71500.00

Wage Unit of Pay

Year

Worksite Address 1

2141 Palomar Airport

Worksite Address 2

Worksite City

Carlsbad

Worksite City Slug

carlsbad

Worksite State

CALIFORNIA

Worksite Postal Code

92011

Job Title

Business Systems Analyst

Job Title Slug

business-systems-analyst

Minimum Education

Bachelor's

Major Field of Study

Business Management, Finance

Required Training

Y

Required Experience

Y

Required Experience Months

24

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer Science

Accept Alternative Combination

N

Accept Alternative Combination Education

Accept Alternative Combination Education Years

Accept Foreign Education

N

Accept Alternative Occupation

N

Accept Alternative Occupation Months

Accept Alternative Job Title

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Custom sales portal development and ongoing maintenance. MANAGE ELECTRONIC DATA INTERCHANGE WITH THE COMPANYS PRIMARY ERP SYSTEM AND OUR SUPPORT SYSTEMS, INCLUDING CRM, MRP, LOOKER ANDbr CONCUR.br ADMINISTER CUSTOM FIELD SALES PORTAL DEVELOPMENT AND MAINTENANCE TO ENSURE A SEAMLESS USER EXPERIENCE.br ADMINISTER ECOMMERCE CUSTOMER LOYALTY PROGRAMS AND ENSURE PROPER INTEGRATION ACROSS CHANNELSbr PERFORM CONFIGURATION AND MAINTENANCE OF OUR ERP DATABASE AND SALES PORTAL. RESOLVE TROUBLE ORDERS, SETTING UP PROMOTIONS AND PARTbr NUMBER MAINTENANCE.br PRIMARY ADMINISTRATOR OF SALESFORCE AS A KEY DRIVER OF SUCCESS FOR THE FIELD SALES TEAM BY MANAGING ROLLOUT OF NEW MODULES AND FEATURES,br PROVIDING BEST PRACTICE WORKFLOWS TO SALES TEAM MEMBERS, RESOLVING DATA QUALITY ISSUES, AND PREPARING DATA LOADS.br DEVELOP AND BUILD NEW SALESFORCE AND LOOKER BUSINESS INTELLIGENCE REPORTS FOR FIELD SALES TEAM PROVIDE VISIBILITY INTO KEY SALESbr OPPORTUNITIES.br DEVELOP AND MAINTAIN COMPREHENSIVE PROCESS DOCUMENTATION SOP.br PROFICIENT UNDERSTANDING OF SKU BASE

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-10-01

SWA Job Order End Date

2019-10-31

Sunday Edition Newspaper

Y

First Newspaper Name

The San Diego UnionTribune

First Advertisement Start Date

2019-10-06

Second Newspaper Ad Name

The San Diego UnionTribune

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-10-13

Employer Website From Date

2019-02-27

Employer Website To Date

2019-11-30

Professional Organization Ad From Date

2020-01-01 07:59:58

Professional Organization Advertisement To Date

2020-01-01 07:59:58

Job Search Website From Date

2019-03-06

Job Search Website To Date

2019-11-30

Employee Referral Program From Date

2019-03-01

Employee Referral Program To Date

2019-11-30

Local Ethnic Paper From Date

2019-10-04

Local Ethnic Paper To Date

2019-11-01

Radio/TV Ad From Date

2020-01-01 07:59:58

Radio/TV Ad To Date

2020-01-01 07:59:58

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

INDONESIA

Foreign Worker Birth Country

INDONESIA

Class of Admission

F-1

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

B.S. MANAGEMENT SCIENCE, MINOR BUSINESS FINANCE

Foreign Worker Years of Education Completed

2017

Foreign Worker Institution of Education

UNIVERSITY OF CALIFORNIA, SAN DIEGO

Foreign Worker Education Institution Address 1

9500 GILMAN DRIVE

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

LA JOLLA

Foreign Worker Education Institution State/Province

CA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

92093

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

Y

Preparer Name

Preparer Title

Preparer Email

Employer Information Declaration Name

Christine Weiler

Employer Information Declaration Title

HR Coordinator