Fiscal Year

2024

Case Number

A-22326-62089

Case Status

Certified-Expired

Received Date

2022-12-20

Decision Date

2023-11-20

Refile

N

Original File Date

2024-01-01 00:19:24

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

MIKAN ASSOCIATES LLC

Employer Name Slug

mikan-associates-llc

Employer Address 1

1 OVERLOOK POINT

Employer Address 2

STE 526

Employer City

LINCOLNSHIRE

Employer City Slug

lincolnshire

Employer State

ILLINOIS

Employer State Slug

illinois

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

60069

Employer Phone

8889021970

Employer Number of Employees

15

Employer Year Commenced Business

2020

NAICS Code

541512

FW Ownership Interest

N

Employer Contact Name

Michael Odongo

Employer Contact Address 1

1 Overlook Point

Employer Contact Address 2

Ste. 252

Employer Contact City

Lincolnshire

Employer Contact State/Province

ILLINOIS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

60069

Employer Contact Phone

(888) 902-1970 701

Employer Contact Email

modongo@mikan.tech

Agent Attorney Name

Christopher A Esmits

Agent Attorney Firm Name

J. Aponte Associates, LLC

Agent Attorney Phone

(312) 762-5966

Agent Attorney Address 1

550 Warrenville Rd.

Agent Attorney Address 2

Ste 240

Agent Attorney City

Lisle

Agent Attorney State/Province

ILLINOIS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

60532

Agent Attorney Email

immigration@japontelaw.com

PW Track Number

P10021127297558

PW SOC Code

15-1199

PW SOC Title

Business Intelligence Analysts

PW Skill Level

Level IV

PW Wage

114899.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-01-19

PW Expiration Date

2022-06-30

Wage Offer From

114899.00

Wage Offer To

0.00

Average Salary

114899.00

Wage Unit of Pay

Year

Worksite Address 1

141 W. Jackson Blvd.

Worksite Address 2

Suite 1520

Worksite City

Chicago

Worksite City Slug

chicago

Worksite State

ILLINOIS

Worksite Postal Code

60604

Job Title

Senior Business Intelligence Developer

Job Title Slug

senior-business-intelligence-developer

Minimum Education

Master's

Major Field of Study

SEE SECTION H.14

Required Training

N

Required Experience

N

Required Experience Months

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

48

Accept Alternative Job Title

SEE SECTION H.14

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Requires a Masters degree in Business or Information and 4 years of experience in Data and Analytics, Data Management. Requires 4 plus years of experience in implementing data and analytics solutions using mainstream data management technologies oracle, sql server, db2, terradata, snowflake, netezza, hadoop, or similar. 4 plus years of experience on design, and data integration etl development. Experience in implementing data warehousing using mainstream data integration technologies ssis, python, qlik, snowflake, fivetran. 4 plus years of experience with data visualization tools such as sap business objects, tableau, qlikview, power bi or similar. 4 plus year of experience adherence to data management development and deployment best practice. Mastery of tools strong technical experience in one or more of the following data management technologies snowflake, informatica, sql server, sap hana, hadoop, and cassandra, spark, alooma. Strong technical experience in one or more of the following analytics technologies tableau, power bi. Excellent organizational skills to work in a fastpaced environment and manage and prioritize multiple tasks simultaneously. Demonstrated success collaborating with teams to achieve stakeholder expectations. Clientcentric mentality reliable, professional, exceeds expectations. Track record for independently learning new technologies quickly, and passion for personal professional development. Strong troubleshooting and diagnostic skills to determine and resolve root issues. Strong written, and verbal communication, as well as presentation skills. Requires valid US drivers license and reliable transportation with the ability to travel within Chicago region to client sites as needed.

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

2022-06-29

SWA Job Order End Date

2022-08-03

Sunday Edition Newspaper

Y

First Newspaper Name

Chicago Tribune

First Advertisement Start Date

2022-08-21

Second Newspaper Ad Name

Chicago Tribune

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-08-28

Employer Website From Date

2022-10-27

Employer Website To Date

2022-11-14

Professional Organization Ad From Date

2024-01-01 00:19:24

Professional Organization Advertisement To Date

2024-01-01 00:19:24

Job Search Website From Date

2022-08-21

Job Search Website To Date

2022-09-07

Employee Referral Program From Date

2024-01-01 00:19:24

Employee Referral Program To Date

2024-01-01 00:19:24

Local Ethnic Paper From Date

2022-08-22

Local Ethnic Paper To Date

2022-08-22

Radio/TV Ad From Date

2024-01-01 00:19:24

Radio/TV Ad To Date

2024-01-01 00:19: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-4

Foreign Worker Education

Master's

Foreign Worker Information: Major

MANAGEMENT INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2014

Foreign Worker Institution of Education

UNIVERSITY OF ILLINOIS CHICAGO

Foreign Worker Education Institution Address 1

1200 W HARRISON ST.

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

CHICAGO

Foreign Worker Education Institution State/Province

IL

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

60607

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

CHRISTOPHER A ESMITS

Preparer Title

SR. ASSOCIATE ATTORNEY

Preparer Email

immigration@japontelaw.com

Employer Information Declaration Name

MICHAEL ODONGO

Employer Information Declaration Title

CHIEF INNOVATION OFFICER