Fiscal Year

2021

Case Number

A-20139-55620

Case Status

Certified-Expired

Received Date

2020-05-18

Decision Date

2020-11-12

Refile

N

Original File Date

2021-01-01 08:50:29

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

PINION SERVICES, INC.

Employer Name Slug

pinion-services-inc

Employer Address 1

6601 N LINCOLN AVE.

Employer Address 2

Employer City

LINCOLNWOOD

Employer City Slug

lincolnwood

Employer State

ILLINOIS

Employer State Slug

illinois

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

60712

Employer Phone

3122850286

Employer Number of Employees

11

Employer Year Commenced Business

2001

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

Durga Daparti

Employer Contact Address 1

6601 N Lincoln Ave.

Employer Contact Address 2

Employer Contact City

Lincolnwood

Employer Contact State/Province

ILLINOIS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

60712

Employer Contact Phone

3125398509

Employer Contact Email

durga.daparti@pinion.services

Agent Attorney Name

Rabindra K Singh

Agent Attorney Firm Name

HSD Immigration, LLC

Agent Attorney Phone

312.291.1234

Agent Attorney Address 1

1755 Park Street

Agent Attorney Address 2

Suite 200

Agent Attorney City

Naperville

Agent Attorney State/Province

ILLINOIS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

60563

Agent Attorney Email

rsingh@HSDimmigration.com

PW Track Number

P10019301111246

PW SOC Code

15-1121

PW SOC Title

Computer Systems Analyst

PW Skill Level

Level II

PW Wage

73944.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-02-24

PW Expiration Date

2020-06-30

Wage Offer From

80912.00

Wage Offer To

0.00

Average Salary

80912.00

Wage Unit of Pay

Year

Worksite Address 1

6601 N Lincoln Ave

Worksite Address 2

Worksite City

Lincolnwood

Worksite City Slug

lincolnwood

Worksite State

ILLINOIS

Worksite Postal Code

60712

Job Title

MSBI Developer

Job Title Slug

msbi-developer

Minimum Education

Bachelor's

Major Field of Study

Computer Engineering, Computer Science, or Information Technology

Required Training

N

Required Experience

Y

Required Experience Months

22

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

N

Accept Alternative Occupation Months

Accept Alternative Job Title

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Must have Bachelors degree or foreign equivalent degree in Computer Engineering, Computer Science, or Information Technology.br br Position requires 22 months of work experience performing following gathering requirement and reviewing architecture; performing code design and code review; analyzing workflow process and the flow of data across various Business Intelligence Applications; understanding the requirements for designing data structures and designing data flow diagrams and mappings; converting business requirements into detailed design documents designing and developing ETL Solutions using SQL Server Integration Services SSIS; developing mappings using XML Sources and flat files; designing, developing and supporting SQL Server Analysis Services SSAS Cubes in OLAP applications; designing dashboards and scorecards using SQL Server Reporting Services SSRS; analyzing data using SQL Server Management Studio SSMS; performing Query Analysis and Performance Tuning using SQL Server Profiler; performing Data Modelling, Data Cleansing and Data Profiling; Creating ER diagrams, database tables, data dictionaries, and scripts to support application development; performing risk identification and mitigation; automating routine database maintenance tasks andbr production reports; and coordinating with onsiteoffshore teams working on IT projects.br br Position also requires 22 months of work experience using following technologies and toolsbr br DBMS Microsoft Sql Server 2008 20122016; Oracle 9i; Bl Data Model Tools Sql Server Integration Services 20082012, Sql Server Reporting Services 200820122016, Sql Server Analysis Services 200820122016, Toad, ERWIN; Programmable Languages TSQL Primary, C#.net and Asp.net; Database Tools Sql Server Management Studio Sql server Business Intelligence Studio, Sql Server Data Tools, Sql server Profiler, Database Engine Tuning Advisor, SQL Server DMVS,TOAD and SQL Plus; and Additional Tools Microsoft Visio, Visual Studio, Team Foundation Server and Visual Source Safe as Source Control and MS Office.br br Position also demands knowledge of executing IT projects in Banking and Retail domain. Additionally, position requires knowledge of following C Data Structures; Data Processing; Data Communications; Database Management System; Software Engineering; Computer Programming; Object Oriented Programming; Computer Network; and Java Programming.br br Possible longterm relocation to various unanticipated U.S. client site locations.

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

2020-03-01

SWA Job Order End Date

2020-04-03

Sunday Edition Newspaper

Y

First Newspaper Name

Chicago Sun Times

First Advertisement Start Date

2020-01-19

Second Newspaper Ad Name

Chicago Sun Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-01-26

Employer Website From Date

2020-03-18

Employer Website To Date

2020-04-08

Professional Organization Ad From Date

2021-01-01 08:50:29

Professional Organization Advertisement To Date

2021-01-01 08:50:29

Job Search Website From Date

2020-01-21

Job Search Website To Date

2020-02-03

Employee Referral Program From Date

2021-01-01 08:50:29

Employee Referral Program To Date

2021-01-01 08:50:29

Local Ethnic Paper From Date

2020-01-23

Local Ethnic Paper To Date

2020-01-23

Radio/TV Ad From Date

2021-01-01 08:50:29

Radio/TV Ad To Date

2021-01-01 08:50:29

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

COMPUTER SCIENCE INFORMATION TECHNOLOGY

Foreign Worker Years of Education Completed

2005

Foreign Worker Institution of Education

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Institution Address 1

ASHOK NAGAR

Foreign Worker Education Institution Address 2

KUKATPALLY HOUSING BOARD COLONY, KUKATPALLY

Foreign Worker Education Institution City

HYDERABAD

Foreign Worker Education Institution State/Province

TELANGANA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

500085

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Rabindra K Singh

Preparer Title

Founding Partner

Preparer Email

rsingh@HSDimmigration.com

Employer Information Declaration Name

Suresh Myneni

Employer Information Declaration Title

Director