Fiscal Year

2024

Case Number

A-23123-37353

Case Status

Certified

Received Date

2023-05-12

Decision Date

2024-05-30

Refile

N

Original File Date

2024-01-01 01:30:39

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

CHANNEL VANTAGE, INC.

Employer Name Slug

channel-vantage-inc

Employer Address 1

400 RENAISSANCE CENTER

Employer Address 2

SUITE 3000

Employer City

DETROIT

Employer City Slug

detroit

Employer State

MICHIGAN

Employer State Slug

michigan

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

48243

Employer Phone

313-262-3000

Employer Number of Employees

100

Employer Year Commenced Business

2001

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

Gail Spillard

Employer Contact Address 1

400 Renaissance Center

Employer Contact Address 2

Suite 3000

Employer Contact City

Detroit

Employer Contact State/Province

MICHIGAN

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

48243

Employer Contact Phone

313-262-3000

Employer Contact Email

gdspillard@urbanscience.com

Agent Attorney Name

Linda J Armstrong

Agent Attorney Firm Name

Butzel Long

Agent Attorney Phone

313 983-7476

Agent Attorney Address 1

150 West Jefferson

Agent Attorney Address 2

Suite 100

Agent Attorney City

Detroit

Agent Attorney State/Province

MICHIGAN

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

48226

Agent Attorney Email

Armstrong@butzel.com

PW Track Number

P10022174307939

PW SOC Code

13-1082.00

PW SOC Title

Project Management Specialists

PW Skill Level

Level II

PW Wage

77522.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2023-01-05

PW Expiration Date

2023-06-30

Wage Offer From

96412.00

Wage Offer To

0.00

Average Salary

96412.00

Wage Unit of Pay

Year

Worksite Address 1

400 Renaissance Center

Worksite Address 2

Suite 3000

Worksite City

Detroit

Worksite City Slug

detroit

Worksite State

MICHIGAN

Worksite Postal Code

48243

Job Title

Manager - V4 Practice

Job Title Slug

manager-v4-practice

Minimum Education

Bachelor's

Major Field of Study

Computer Engineering

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

IS, CS, IT, Applied Math, Computer Systems or Electrical and Electronics Engineering

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

36

Accept Alternative Job Title

3 years exp. in a software consultant or development or data analysis position

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

To avoid any confusion created by this form, the requirements for the Manager V4 Practice position arebr br Bachelors Degree in Computer Engineering, Information Systems, Computer Science, Information Technology, Applied Mathematics, Computer Systems or Electrical and Electronics Engineering or foreign equivalent education and 3 years experience in a software consultant or development or data analysis position 3 years of experience is required in all the followingbr br 1. Software development lifecycle including design, development, testing, implementation, and support.br 2. Relational database design and implementation including SQL, ETL, and writing, modifying, and optimizing complex stored procedures and SQL queries.br 3. Data analysis using MS Excel, including advanced text manipulation and mathematics, linear regression and statistical modeling, graphing, charting, and pivot tables.br 4. Create dashboards for clients using data visualization tools.br 5. Liaise between client and technical teams for business analysis, project requirements gathering and project coordination, building and executing test plans.br br Experience can be acquired concurrently.br br This is a key position with ChannelVantage Applications, Inc., responsible in part for using dealer sales, leads, market share and operational processes, liaise between client and internal technical staff to define clients software requirements for new features, enhancements and bug fixes of the Sales and Market Analysis solutions; supporting the delivery of client services on an account team for contracted and adhoc projects adhering to client requested specifications; tracking, processing, analyzing, reporting, visualizing the data using OBIEE or IBM Rational Team Concert to improve accuracy and quality of the product; responding to client inquiries on sales and lead performance, market share; and handling adhoc requests, such as manual reports using relational databases which includes SQL, extracting, transforming, and loading ETL data using MS Excel, PowerPoint, and other tools included in the MS Suite. Because this is a key and critical position, requiring extensive knowledge of, as well as experience with, applicable concepts and issues, a Bachelors Degree in Computer Engineering, Information Systems, Computer Science, Information Technology, Applied Mathematics, Computer Systems or Electrical and Electronics Engineering or foreign equivalent education and 3 years experience in a software consultant or development or data analysis position, is required, as the position involves providing insight to create estimates and proposals for clients; providing project status updates to clients; and being responsible for project outcomes, including project delivery, project timelines, planning, tracking, executing and taking corrective action.

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-03-08

SWA Job Order End Date

2023-04-07

Sunday Edition Newspaper

Y

First Newspaper Name

The Detroit Free Press

First Advertisement Start Date

2023-03-12

Second Newspaper Ad Name

The Detroit Free Press

Second Advertisement Type

Newspaper

Second Ad Start Date

2023-03-19

Employer Website From Date

2023-03-01

Employer Website To Date

2023-04-07

Professional Organization Ad From Date

2024-01-01 01:30:39

Professional Organization Advertisement To Date

2024-01-01 01:30:39

Job Search Website From Date

2024-01-01 01:30:39

Job Search Website To Date

2024-01-01 01:30:39

Employee Referral Program From Date

2023-03-14

Employee Referral Program To Date

2023-03-28

Local Ethnic Paper From Date

2023-03-15

Local Ethnic Paper To Date

2023-03-15

Radio/TV Ad From Date

2024-01-01 01:30:39

Radio/TV Ad To Date

2024-01-01 01:30:39

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

Bachelor's

Foreign Worker Information: Major

ELECTRICAL AND ELECTRONICS ENGINEERING

Foreign Worker Years of Education Completed

2014

Foreign Worker Institution of Education

VISVESVARAYA TECHNOLOGICAL UNIVERSITY, BELGAUM

Foreign Worker Education Institution Address 1

JNANA SANGAMA, VTU MAIN RD.

Foreign Worker Education Institution Address 2

MACHHE

Foreign Worker Education Institution City

BELGAUM

Foreign Worker Education Institution State/Province

KARNATAKA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

590018

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Linda J Armstrong

Preparer Title

Attorney

Preparer Email

Armstrong@butzel.com

Employer Information Declaration Name

Gail D Spillard

Employer Information Declaration Title

Total Rewards Manager