Alistair Ramirez
EMP-0014345 · Employee · projected from the master template
- employee_id
- EMP-0014345
- seq
- 14,345
- first_name
- Alistair
- last_name
- Ramirez
- middle_initial
- —
- full_name
- Alistair Ramirez
- work_email
- alistair.ramirez@tesseracourt.com
- work_phone
- +1-522-277-7767
- home_address_line1
- 2650 Kingsway
- job_title
- Supply Chain Manager
- job_code
- SCM-04-0
- job_family
- Supply Chain
- flsa_status
- exempt
- job_level
- 4
- job_level_name
- Manager
- job_level_code
- M1
- is_people_manager
- yes
- is_executive
- no
- department_code
- SCM
- department_name
- Supply Chain
- department_function
- Operations
- cost_center
- CC-3400
- location_code
- US-NYC
- location_city
- New York
- location_region
- New York
- location_country
- United States
- location_country_code
- US
- location_timezone
- America/New_York
- manager_id
- EMP-0003593
- manager_seq
- 3,593
- direct_report_count
- 9
- org_depth
- 7
- employment_type
- Full-time regular
- work_arrangement
- On-site
- employment_status
- active
- hire_date
- 2026-06-30
- tenure_years
- 0.21
- termination_date
- —
- termination_reason
- —
- termination_voluntary
- —
- leave_type
- —
- date_of_birth
- 1987-10-10
- age
- 39
- gender
- Male
- ethnicity
- White
- base_salary_cents
- 17,947,405
- base_salary
- $179,474
- currency
- USD
- bonus_target_pct
- 12%
- bonus_target
- $21,537
- equity_units
- 600
- compa_ratio
- 0.994
- band_min_cents
- 12,136,000
- band_mid_cents
- 14,800,000
- band_max_cents
- 18,352,000
- department_ordinal
- 12
- location_ordinal
- 1
- employment_status_ordinal
- 0
- performance_rating
- 3
- engagement_score
- 42
- flight_risk_score
- 90
- tenure_days
- 15
Leave balances (8)
| balance_id | employee_id | employee_name | leave_type_code | leave_type | accrued_days | taken_days |
|---|---|---|---|---|---|---|
| BAL-0014345-0 | EMP-0014345 | Alistair Ramirez | PTO | Paid time off | 0.8 | 0 |
| BAL-0014345-1 | EMP-0014345 | Alistair Ramirez | SICK | Sick leave | 0.4 | 0 |
| BAL-0014345-2 | EMP-0014345 | Alistair Ramirez | PARENT | Parental leave | 3.5 | 0 |
| BAL-0014345-3 | EMP-0014345 | Alistair Ramirez | BEREAV | Bereavement leave | 0.2 | 0 |
| BAL-0014345-4 | EMP-0014345 | Alistair Ramirez | JURY | Jury duty | 0.4 | 0 |
| BAL-0014345-5 | EMP-0014345 | Alistair Ramirez | UNPAID | Unpaid leave of absence | 1.2 | 0 |
| BAL-0014345-6 | EMP-0014345 | Alistair Ramirez | VOL | Volunteer day | 0.1 | 0 |
| BAL-0014345-7 | EMP-0014345 | Alistair Ramirez | SAB | Sabbatical | 1.2 | 0 |
Training (3)
| training_record_id | employee_id | employee_name | course_code | course_title | category | is_mandatory |
|---|---|---|---|---|---|---|
| TRN-0014345-2 | EMP-0014345 | Alistair Ramirez | PRO-401 | Structured Problem Solving | Professional | no |
| TRN-0014345-0 | EMP-0014345 | Alistair Ramirez | CMP-120 | Data Privacy & GDPR Essentials | Compliance | yes |
| TRN-0014345-1 | EMP-0014345 | Alistair Ramirez | LDR-220 | Leading Through Change | Leadership | no |
Recent payslips (1)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0014345-0048 | EMP-0014345 | Alistair Ramirez | RUN-0048 | 2026-07-14 | 2026-07-18 | $12,862 |
Direct reports (9)
| employee_id | first_name | last_name | full_name | work_email | job_title | job_level |
|---|---|---|---|---|---|---|
| EMP-0084152 | Ayesha | Wanjala | Ayesha A. Wanjala | ayesha.a.wanjala@tesseracourt.com | Supply Chain Planner II | 1 |
| EMP-0084153 | Petra | Lombardi | Petra A. Lombardi | petra.a.lombardi@tesseracourt.com | Junior Supply Chain Planner | 0 |
| EMP-0084154 | Isabelle | Wainwright | Isabelle A. Wainwright | isabelle.a.wainwright@tesseracourt.com | Senior Supply Chain Planner | 2 |
| EMP-0084155 | Gerald | Leonard | Gerald A. Leonard | gerald.a.leonard@tesseracourt.com | Supply Chain Planner | 1 |
| EMP-0084156 | Nadine | Vogel | Nadine A. Vogel | nadine.a.vogel@tesseracourt.com | Junior Supply Chain Planner | 0 |
| EMP-0084157 | Garrett | Leblanc | Garrett A. Leblanc | garrett.a.leblanc@tesseracourt.com | Staff Supply Chain Planner | 3 |
| EMP-0084158 | Rohan | Vidal | Rohan A. Vidal | rohan.a.vidal@tesseracourt.com | Junior Supply Chain Planner | 0 |
| EMP-0084159 | Takeshi | Langford | Takeshi A. Langford | takeshi.a.langford@tesseracourt.com | Junior Supply Chain Planner | 0 |
| EMP-0084160 | Ikenna | Velasquez | Ikenna A. Velasquez | ikenna.a.velasquez@tesseracourt.com | Associate Supply Chain Planner | 0 |