Fiscal Year

2024

Case Number

A-23039-99040

Case Status

Certified-Expired

Received Date

2023-02-27

Decision Date

2024-03-25

Refile

N

Original File Date

2024-01-01 01:02:08

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

The Maclellan Foundation

Employer Name Slug

the-maclellan-foundation

Employer Address 1

820 Broad Street, Ste 300

Employer Address 2

Employer City

Chattanooga

Employer City Slug

chattanooga

Employer State

TENNESSEE

Employer State Slug

tennessee

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

37402

Employer Phone

4237551366

Employer Number of Employees

24

Employer Year Commenced Business

1945

NAICS Code

813211

FW Ownership Interest

N

Employer Contact Name

Cathy Cates

Employer Contact Address 1

820 Broad Street, Ste 300

Employer Contact Address 2

Employer Contact City

Chattanooga

Employer Contact State/Province

TENNESSEE

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

37402

Employer Contact Phone

4237551366

Employer Contact Email

ccates@maclellan.net

Agent Attorney Name

Melanie C Walker

Agent Attorney Firm Name

Baker Donelson Bearman Caldwell Berkowitz PC

Agent Attorney Phone

4237562010

Agent Attorney Address 1

633 Chestnut Street, Suite 1900

Agent Attorney Address 2

Agent Attorney City

Chattanooga

Agent Attorney State/Province

TENNESSEE

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

37450

Agent Attorney Email

mwalker@bakerdonelson.com

PW Track Number

P10022096042527

PW SOC Code

13-2051

PW SOC Title

Financial and Investment Analyst

PW Skill Level

Level I

PW Wage

52562.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-10-19

PW Expiration Date

2023-06-30

Wage Offer From

52562.00

Wage Offer To

0.00

Average Salary

52562.00

Wage Unit of Pay

Year

Worksite Address 1

820 Broad Street

Worksite Address 2

Ste 300

Worksite City

Chattanooga

Worksite City Slug

chattanooga

Worksite State

TENNESSEE

Worksite Postal Code

37402

Job Title

Financial Analyst

Job Title Slug

financial-analyst

Minimum Education

Bachelor's

Major Field of Study

Business

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Accounting

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

12

Accept Alternative Job Title

Financial Analyst, Accountant or related occupation

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Bachelors degree in Business or Accounting or its foreign equivalency plus 12 months of experience in the job or related field. Experience should include 12 months of experience with 1 private foundations tax law; 2 grant coding; 3 Salesforce and Bill.com software; 4 QuickBooks reconciliation.

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-12-03

SWA Job Order End Date

2023-01-09

Sunday Edition Newspaper

Y

First Newspaper Name

Chattanooga Times Free Press

First Advertisement Start Date

2022-11-27

Second Newspaper Ad Name

Chattanooga Times Free Press

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-12-04

Employer Website From Date

2024-01-01 01:02:08

Employer Website To Date

2024-01-01 01:02:08

Professional Organization Ad From Date

2024-01-01 01:02:08

Professional Organization Advertisement To Date

2024-01-01 01:02:08

Job Search Website From Date

2022-11-18

Job Search Website To Date

2022-12-01

Employee Referral Program From Date

2024-01-01 01:02:08

Employee Referral Program To Date

2024-01-01 01:02:08

Local Ethnic Paper From Date

2022-11-26

Local Ethnic Paper To Date

2022-11-26

Radio/TV Ad From Date

2022-12-05

Radio/TV Ad To Date

2022-12-05

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

NIGERIA

Foreign Worker Birth Country

NIGERIA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

BUSINESS ADMINISTRATION

Foreign Worker Years of Education Completed

2015

Foreign Worker Institution of Education

LEE UNIVERSITY

Foreign Worker Education Institution Address 1

1120 NORTH OCOEE STREET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

CLEVELAND

Foreign Worker Education Institution State/Province

TN

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

37320

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Melanie C Walker

Preparer Title

Attorney

Preparer Email

mwalker@bakerdonelson.com

Employer Information Declaration Name

Cathy Cates

Employer Information Declaration Title

Director of Operations