Fiscal Year

2020

Case Number

A-19284-69907

Case Status

Certified-Expired

Received Date

2019-10-23

Decision Date

2020-03-13

Refile

N

Original File Date

2020-01-01 08:08:02

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

CONSULTADD INCORPORATION

Employer Name Slug

consultadd-incorporation

Employer Address 1

5215 NORTH OCONNOR BLVD.

Employer Address 2

12TH FLOOR

Employer City

IRVING

Employer City Slug

irving

Employer State

TEXAS

Employer State Slug

texas

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

75039

Employer Phone

8889585233

Employer Number of Employees

153

Employer Year Commenced Business

2011

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

Bharat Bhate

Employer Contact Address 1

2300 Valley View Lane, Suite 410

Employer Contact Address 2

Employer Contact City

Irving

Employer Contact State/Province

TEXAS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

75062

Employer Contact Phone

7142536558

Employer Contact Email

bharat.b@consultadd.com

Agent Attorney Name

Matthew P Hellrung

Agent Attorney Firm Name

Meltzer Hellrung LLC

Agent Attorney Phone

3123409619

Agent Attorney Address 1

211 S Clark St

Agent Attorney Address 2

# 735

Agent Attorney City

Chicago

Agent Attorney State/Province

ILLINOIS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

60603

Agent Attorney Email

gov@meltzerhellrung.com

PW Track Number

P10019176010160

PW SOC Code

15-1121

PW SOC Title

Computer Systems Analysts

PW Skill Level

Level II

PW Wage

78998.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-10-08

PW Expiration Date

2020-06-30

Wage Offer From

104000.00

Wage Offer To

0.00

Average Salary

104000.00

Wage Unit of Pay

Year

Worksite Address 1

2300 Valley View Lane

Worksite Address 2

Suite 410

Worksite City

Irving

Worksite City Slug

irving

Worksite State

TEXAS

Worksite Postal Code

75062

Job Title

Systems Analyst

Job Title Slug

systems-analyst

Minimum Education

Master's

Major Field of Study

Software Engineering or related

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

Associate Consultant, System Analyst or related

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

REQUIRES MASTERS DEGREE IN SOFTWARE ENGINEERING OR RELATED AND 2 YEARS OF EXPERIENCE. ALSO REQUIRES ANY AMOUNT OF EXPERIENCE IN THE FOLLOWING MIGRATION AND DATABASE ADMINISTRATION; DATABASE UPGRADE FROM MSSQL 2008 TO 2012; IMPLEMENTATION OF SYBASE DATABASE; IMPLEMENTATION IN ORACLE DB; RESTORE, ARCHIVING AND RECOVERY OF MSSQL DATABASE; ADMINISTRATION OF SAP ERP 6.0, EHP5, EHP6 AND EHP7 SYSTEMS; PROVIDING CODES FOR DIFFERENT MODULES LIKE FI, CO,SD ,MM AND HR; CREATING USERS, ROLES AND PROFILES; ENTIRE SECURITY AUDIT FOR THE SYSTEM; SAP NETWEAVER 7.01 TO 7.4 MIGRATION, INCLUDING SAP PORTAL VIEW AND CODE; EHS IMPLEMENTATION ENVIRONMENT HEALTH AND SAFETY AND RUNNING EHS SCRIPT IN SAP SYSTEM; KRONOS TOOL MODULES INCLUDING WORKFORCE TIMEKEEPER, ACCRUALS, ACTIVITIES, ADVANCED SCHEDULER, FORECASTING, ATTENDANCE AND KRONOS WORKFORCE CENTRAL UPGRADE AND BI ANALYTICS; CREATING INBOUND AND OUTBOUND CUSTOM INTERFACES THROUGH SQL SCRIPTS IN WIM; UTILIZING SQL CODE FOR WRITING CUSTOM BUILD REPORT THROUGH REPORT BUILDER TOOL; TROUBLESHOOTING OF KRONOS APPLICATION SERVICES, DATABASE API, VIRTUAL SYSTEM CONFIGURATION AND INSTANCE RECOVERY; WORKING WITH THIRD PARTY INTEGRATION WITH TOOLS INCLUDING SAP, PEOPLESOFT, ADP, SALESFORCE, SERVICENOW AND JIRA. TRAVEL TO UNANTICIPATED CLIENT LOCATIONS THROUGHOUT THE U.S.

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-06-19

SWA Job Order End Date

2019-07-19

Sunday Edition Newspaper

Y

First Newspaper Name

The Dallas Morning News

First Advertisement Start Date

2019-08-18

Second Newspaper Ad Name

The Dallas Morning News

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-08-25

Employer Website From Date

2019-09-05

Employer Website To Date

2019-09-18

Professional Organization Ad From Date

2020-01-01 08:08:02

Professional Organization Advertisement To Date

2020-01-01 08:08:02

Job Search Website From Date

2020-01-01 08:08:02

Job Search Website To Date

2020-01-01 08:08:02

Employee Referral Program From Date

2020-01-01 08:08:02

Employee Referral Program To Date

2020-01-01 08:08:02

Local Ethnic Paper From Date

2019-08-22

Local Ethnic Paper To Date

2019-08-28

Radio/TV Ad From Date

2019-08-24

Radio/TV Ad To Date

2019-08-24

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

SOFTWARE ENGINEERING

Foreign Worker Years of Education Completed

2016

Foreign Worker Institution of Education

NEW JERSEY INSTITUTE OF TECHNOLOGY

Foreign Worker Education Institution Address 1

323 DR M.L.K. JR. BLVD

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

NEWARK

Foreign Worker Education Institution State/Province

NJ

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

7102

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Matthew P Hellrung

Preparer Title

Partner

Preparer Email

gov@meltzerhellrung.com

Employer Information Declaration Name

Bharat Bhate

Employer Information Declaration Title

Information Systems Manager