Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:INGRAM MICRO
Employer Address_Line 1:3351 MICHELSON DRIVE, SUITE 100
Employer Address_Line 2:
Employer City :IRVINE
State:
Employer State/ Province:CALIFORNIA
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:92612
Employer Phone No.:714/566-1000
Employer Phone Extent No.:22817
Total Number of Employees:33000
Employer Year of Commenced :
NAICS Code:541511
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Lisa Chan
Employer Contact Address Line1:3351 Michelson Drive, Suite 100
Employer Contact Address Line2:
Employer Contact City:Irvine
Employer Contact State/ Provice:CALIFORNIA
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:92612
Employer Contact Phone:714-382-1377
Employer Contact Email:lisa.chan@ingrammicro.com
Attorney
Agent/ Attorney Name:Blake G Miller
Agent/ Attorney Firm Name:FRAGOMEN, DEL REY, BERNSEN LOEWY, LLP
Agent/ Attorney Phone:9492610209
Agent/ Attorney Phone Ext.:59492
Agent/ Attorney Address Line 1:18401 Von Karman Ave.
Agent/ Attorney Address Line 2:Ste. 255
Agent/ Attorney City:Irvine
Agent/ Attorney State/ Province:CALIFORNIA
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:92612
Agent/ Attorney Email:BMiller@fragomen.com
Position Info
Prevailing Wage Track Number:P10020157630759
Prevailing Wage SOC Code :15-1132
Prevailing Wage SOC Title :Software Developers, Applications
Prevailing Wage Skill Level:Level II
Prevailing Wage:99632
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2020-11-04
Prevailing Wage Expiration Date :2021-06-30
Wage Offer From:99632
Wage Offer To:120700
Wage Offer Unit of Pay:Year
Workstie Address Line 1:3351 Michelson Drive
Worksite Address Line 2:Suite 100
Worksite City :Irvine
Worksite State:CALIFORNIA
Worksite Postal Code:92612
Job Title:BI DEVELOPER II
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:COMPUTER SCIENCE
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :Y
Required Expreience Months :24
Accept Alternate Field of Study:Y
Accept Alternate Major:See H.14 for complete list
Alternate Combination of Education/ Experience:Y
Required Alternate Level of Education :Master's
Other Alternate Level of Education:
Acceptable Years of Experience:1
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:24
Accept Alternate Job Title:See H.14 for complete list
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:THIS POSITION REQUIRES A BACHELORS DEGREE IN COMPUTER SCIENCE, MANAGEMENT INFORMATION SYSTEMS, ENGINEERING OR RELATED FIELD AND 2 YEARS OF WORK EXPERIENCE IN BUSINESS INTELLIGENCE SOFTWARE DEVELOPMENT.br IN LIEU OF THE REQUIREMENTS LISTED ABOVE, EMPLOYER WILL ACCEPT MASTERS DEGREE IN COMPUTER SCIENCE, MANAGEMENT INFORMATION SYSTEMS,br ENGINEERING AND 1 YEAR OF WORK EXPERIENCE IN BUSINESS INTELLIGENCE SOFTWARE DEVELOPMENT.br br SPECIAL SKILLS OR OTHER REQUIREMENTSbr br ALSO, MUST HAVE 1 YEAR OF WORK EXPERIENCE WITHbr 1. SQL SKILLS TSQL, STORED PROCEDURE PROGRAMING, FUNCTIONS, TRIGGERSbr 2. EXPERIENCE IN MICROSOFT VISUAL STUDIO BIDSbr 3. .NET C#, VB .NET OR JAVA OR ANY OTHER OBJECT ORIENTED PROGRAMMING LANGUAGE DEVELOPMENT EXPERIENCEbr 4. EXPERIENCE WITH REPORTDASHBOARD BUILDING USING ANY MAJOR BI PLATFORMS MICROSTRATEGY OR SSRS, OR BUSINESS OBJECTS ETC. AND PRESENTINGbr IT IN A USERFRIENDLY MANNER TO THE ANALYST OR BUSINESS USER.br 5. EXPERIENCE WITH SCRIPTING LANGUAGES LIKE PYTHON AND CLOUDBASED COMPUTATION SERVICESPLATFORMS AS OFFERED IN AWS AS WELL AS SOME DATAbr ANALYSIS AND CLUSTERING ALGORITHMS.br br MUST POSSESS EXPERTISE KNOWLEDGE SUFFICIENT TO ADEQUATELY PERFORM THE DUTIES OF THE JOB BEING OFFERED. EXPERTISE KNOWLEDGE MAY BE GAINEDbr THROUGH EMPLOYMENT EXPERIENCE OR EDUCATION. SUCH EXPERTISE KNOWLEDGE CANNOT BE quot;QUANTIFIEDquot; BY quot;TIME.quot; ANY SUITABLE COMBINATION OFbr EDUCATION, TRAINING OR EXPERIENCE IS ACCEPTABLE. REQUIRED EXPERTISE KNOWLEDGE INCLUDESbr 6. ABILITY TO NETWORK AND UNDERSTAND DIFFERENT ASPECTS OF INTERNAL BUSINESSES TO IDENTIFY OPPORTUNITIES.br 7. ABILITY TO TRANSLATE BUSINESS PROBLEMS INTO TECHNICAL REQUIREMENTS AND DEVISING SOLUTIONS.br 8. MANAGING DATA PLATFORMS AND OVERALL MAINTENANCE OF DATA QUALITY, DESIGN, USABILITY AS WELL AS USER ENGAGEMENT.br 9. WORKING WITH AND TRAINING VARIOUS TEAMS TO ADOPT DEVISED TECHNICAL SOLUTIONS.br 10. WORKING WITH EXTERNAL PARTNERS AND DELIVERING KEY SOLUTIONS WHICH ENHANCE THE BUSINESS, WITH VIGILANCE TOWARDS PROCESS AND DATAbr SECURITY COMPLIANCE.
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:2021-01-15
Job Oder End Date:2021-02-17
Sunday Edition Newspaper:Y
First Newspaper Name:Los Angeles Times
First Advertisement Start Date:2021-01-24
Second Newspaper Name:Los Angeles Times
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-01-31
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:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-01-26
Job Search Website to Date:2021-02-01
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2021-01-21
Employee Referral Program to Date:2021-02-04
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:2021-02-01
Local Ethnic Newspaper to Date:2021-02-01
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
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:COMPUTER SCIENCE AND ENGINEERING
Year of Compelted Education:2014
Foreign Worker Istitution of Eduation:STATE UNIVERSITY OF NEW YORK AT BUFFALO,
Foreign Worker Education Instution Address Line 1:210 TALBERT HALL
Foreign Worker Education Institution Address Line 2:
Foreign Worker Education Institution City:BUFFALO
Foreign Worker Educatution Institution State:NY
Foreign Worker Education Institution Country :UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code:14260
Foreign Worker Training Completion :N/A
Foreign Worker Required Experience :Y
Foreign Worker Alternate Education and Experience :Y
