CIGNA HEALTH AND LIFE INSURANCE COMPANY

Application Developer Advisor

A-22304-49141 H-1B 2023 Certified

Salary

$127,400

Visa Type

H-1B

Job Title

Application Developer Advisor

Employee's Citizenship

INDIA

Graduate School

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

Case info Company Info HR Info Attorney Position Info Employee Info

Case info

9 fields

Data Publish Year 2023

Case Number A-22304-49141

Case Status Certified

Received Date 2022-11-07

Decision Date 2023-09-22

Refile N

Original File Date -

Previous State Work Force Agency (SWA) Case Number Stete -

Schedule A or a Sheepherder Occupation N

Company Info

14 fields

Employer Name CIGNA HEALTH AND LIFE INSURANCE COMPANY

Employer Address_Line 1 900 COTTAGE GROVE ROAD

Employer Address_Line 2 -

Employer City BLOOMFIELD

State -

Employer State/ Province CONNECTICUT

Employer Country UNITED STATES OF AMERICA

Employer Postal Code 6002

Employer Phone No. 8602262300

Employer Phone Extent No. -

Total Number of Employees 74000

Employer Year of Commenced 1982

NAICS Code 5241

Foreign Worker Ownership & Interest N

HR Info

9 fields

Employer Contact Name Michael Doerfler

Employer Contact Address Line1 900 Cottage Grove Road

Employer Contact Address Line2 -

Employer Contact City Bloomfield

Employer Contact State/ Provice CONNECTICUT

Employer Contact Country UNITED STATES OF AMERICA

Employer Contact Post Code 6002

Employer Contact Phone (804) 904-3581

Employer Contact Email Michael.Doerfler@Cigna.com

Attorney

11 fields

Agent/ Attorney Name Nicole A Simon

Agent/ Attorney Firm Name Landau, Hess, Simon, Choi Doebley

Agent/ Attorney Phone 2159250705

Agent/ Attorney Phone Ext. -

Agent/ Attorney Address Line 1 190 N. Independence Mall West

Agent/ Attorney Address Line 2 Suite 501

Agent/ Attorney City Philadelphia

Agent/ Attorney State/ Province PENNSYLVANIA

Agent/ Attorney Country UNITED STATES OF AMERICA

Agent/ Attorney Postal Code 19106

Agent/ Attorney Email nsimon@lhscimmigration.com

Position Info

89 fields

Prevailing Wage Track Number P10022042896048

Prevailing Wage SOC Code 15-1252.00

Prevailing Wage SOC Title Software Developers

Prevailing Wage Skill Level Level IV

Prevailing Wage 127400

Prevailing Wage Unit of Pay Year

Prevailing Wage Source OES

Prevailing Wage Other Source -

Prevailing Wage Determination Date 2022-08-12

Prevailing Wage Expiration Date 2023-06-30

Wage Offer From 127400

Wage Offer To -

Wage Offer Unit of Pay Year

Workstie Address Line 1 900 Cottage Grove Road

Worksite Address Line 2 -

Worksite City Bloomfield

Worksite State CONNECTICUT

Worksite Postal Code 6002

Job Title Application Developer Advisor

Minimum Education Bachelor's

Other Degree/ Diploma -

Major Field of Study Computer Science, Computer Engineering, or a related field

Required Training N

Required Training Month -

Required Field of Training -

Required Experience Y

Required Expreience Months 60

Accept Alternate Field of Study N

Accept Alternate Major -

Alternate Combination of Education/ Experience Y

Required Alternate Level of Education Master's

Other Alternate Level of Education -

Acceptable Years of Experience 3

Accept Foreign Educationa Y

Acceptable Alternate Occupation Y

Acceptable Alternate Occupation Month 60

Accept Alternate Job Title Any IT role

Normal Requirements of Job Opportunity Y

Required Foreign Language N

Specific Skills Requires a Bachelors degree in Computer Science, Computer Engineering, or a related field as well as at least 5 years of IT experience or a Masters degree in Computer Science, Computer Engineering, or a related field and 3 years of IT experience. All qualifying experience must include developing and supporting SQL Server solutions in a production environment using SQL 2012 or above; using TSQL, including writing complex stored procedures, views, and triggers; developing ETL routines utilizing SSIS; experience with OLAP and OLTP environments; reverse engineering complex code; and using C#, VB.net, and GIT.

Combination Occupation N

Offered to Applied Foreign Worker Y

ForeignWorker Live on Premises N

Live in Domestic Service Worker N

Employment Contract -

Professional Occupation Y

College/ University Teacher N

Competitive Process -

Basic Recruitment Process -

Teacher Select Date -

Teacher Publish Journal Name -

Additional Recruitment Information -

Job Oder Start Date 2022-08-30

Job Oder End Date 2022-09-30

Sunday Edition Newspaper Y

First Newspaper Name Hartford Courant

First Advertisement Start Date 2022-09-04

Second Newspaper Name Hartford Courant

Second Advertisement Type Newspaper

Second Ad Start Date 2022-09-11

Job Fair From Date -

Job Fair to Date -

On Campus Recruiting from Date -

On Campus Recruiting to Date -

Employer Website from Date -

Employer Website to Date -

Pro. Org. Ad from Date 2022-08-30

Pro.Org. Ad to Date 2022-09-30

Job Search Website from Date 2022-09-08

Job Search Website to Date 2022-10-05

Private Employment Firm from Date 2022-08-31

Pricate Employment Firm to Date 2022-09-30

Employee Referral Program from Date -

Employee Referral Program to Date -

Campus Placement from Date -

Campus Placement to Date -

Local Ethnic Newspaper from Date -

Local Ethnic Newspaper to Date -

Radio/TV Ad from Date -

Radio/TV Ad to Date -

Employer Received the Payment N

Payment Details -

Bargaining Representative Notified N/A

Posted Notice at Worksite Y

Layoff in Past Six Months N

US Worker Considered -

Country of Citizenship INDIA

Foreign Worker Birth Country INDIA

Class of Admission H-1B

Employee Info

24 fields

Foreign Worker Education Bachelor's

Foreign Worker Education Other -

Foreign Worker Major COMPUTER SCIENCE AND ENGINEERING

Year of Compelted Education 2006

Foreign Worker Istitution of Eduation JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

Foreign Worker Education Instution Address Line 1 JNTU KUKATPALLY

Foreign Worker Education Institution Address Line 2 -

Foreign Worker Education Institution City HYDERABAD

Foreign Worker Educatution Institution State TELANGANA

Foreign Worker Education Institution Country INDIA

Foreign Worker Education Training Post Code 500085

Foreign Worker Training Completion N/A

Foreign Worker Required Experience Y

Foreign Worker Alternate Education and Experience N

Foreign Worker Alternate Occupation Experience Y

Foreign Worker Experience with Employer N

Foreign Worker Employer Pay for Education N

Foreign Worker Currently Employed Y

Employer Completed Application N

Preparer Name Nicole A Simon

Preparer Title Attorney

Preparer Email nsimon@lhscimmigration.com

Employer Information Declaration Name Michael Doerfler

Employer Declaration Title IT Managing Director