Andrew Chakraborty
EMP-0003663 · Employee · projected from the master template
- employee_id
- EMP-0003663
- seq
- 3,663
- first_name
- Andrew
- last_name
- Chakraborty
- middle_initial
- —
- full_name
- Andrew Chakraborty
- work_email
- andrew.chakraborty@vertexhaven.io
- work_phone
- +1-244-290-9030
- home_address_line1
- 6518 Riverside Walk
- job_title
- Manager, Design
- job_code
- DES-04-1
- job_family
- Design
- flsa_status
- exempt
- job_level
- 4
- job_level_name
- Manager
- job_level_code
- M1
- is_people_manager
- yes
- is_executive
- no
- department_code
- DES
- department_name
- Design
- department_function
- Technology
- cost_center
- CC-1800
- location_code
- SG-SIN
- location_city
- Singapore
- location_region
- Singapore
- location_country
- Singapore
- location_country_code
- SG
- location_timezone
- Asia/Singapore
- manager_id
- EMP-0000871
- manager_seq
- 871
- direct_report_count
- 9
- org_depth
- 7
- employment_type
- Full-time regular
- work_arrangement
- On-site
- employment_status
- terminated
- hire_date
- 2015-06-22
- tenure_years
- 11.23
- termination_date
- 2024-10-02
- termination_reason
- Resignation - better opportunity
- termination_voluntary
- yes
- leave_type
- —
- date_of_birth
- 1983-07-23
- age
- 43
- gender
- Male
- ethnicity
- White
- base_salary_cents
- 16,629,326
- base_salary
- $166,293
- currency
- SGD
- bonus_target_pct
- 12%
- bonus_target
- $19,955
- equity_units
- 600
- compa_ratio
- 0.934
- band_min_cents
- 12,136,000
- band_mid_cents
- 14,800,000
- band_max_cents
- 18,352,000
- department_ordinal
- 11
- location_ordinal
- 20
- employment_status_ordinal
- 2
- performance_rating
- 2
- engagement_score
- 91
- flight_risk_score
- 63
- tenure_days
- 3,390
Performance reviews (4)
| review_id | employee_id | employee_name | cycle_code | rating | rating_label | potential |
|---|---|---|---|---|---|---|
| REV-0003663-0 | EMP-0003663 | Andrew Chakraborty | FY-CUR-H1 | 1 | Unsatisfactory | High potential |
| REV-0003663-1 | EMP-0003663 | Andrew Chakraborty | FY-PRV-EOY | 1 | Unsatisfactory | High potential |
| REV-0003663-2 | EMP-0003663 | Andrew Chakraborty | FY-PRV-H1 | 3 | Meets expectations | Low potential |
| REV-0003663-3 | EMP-0003663 | Andrew Chakraborty | FY-P2-EOY | 3 | Meets expectations | Moderate potential |
Recent payslips (7)
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date | gross_pay |
|---|---|---|---|---|---|---|
| PAY-0003663-0007 | EMP-0003663 | Andrew Chakraborty | RUN-0007 | 2024-10-10 | 2024-10-14 | $6,929 |
| PAY-0003663-0006 | EMP-0003663 | Andrew Chakraborty | RUN-0006 | 2024-09-25 | 2024-09-29 | $11,918 |
| PAY-0003663-0005 | EMP-0003663 | Andrew Chakraborty | RUN-0005 | 2024-09-10 | 2024-09-14 | $6,929 |
| PAY-0003663-0004 | EMP-0003663 | Andrew Chakraborty | RUN-0004 | 2024-08-26 | 2024-08-30 | $6,929 |
| PAY-0003663-0003 | EMP-0003663 | Andrew Chakraborty | RUN-0003 | 2024-08-11 | 2024-08-15 | $6,929 |
| PAY-0003663-0002 | EMP-0003663 | Andrew Chakraborty | RUN-0002 | 2024-07-27 | 2024-07-31 | $6,929 |
| PAY-0003663-0001 | EMP-0003663 | Andrew Chakraborty | RUN-0001 | 2024-07-12 | 2024-07-16 | $6,929 |
Direct reports (9)
| employee_id | first_name | last_name | full_name | work_email | job_title | job_level |
|---|---|---|---|---|---|---|
| EMP-0024716 | Felicity | Singh | Felicity Singh | felicity.singh@vertexhaven.io | Product Designer | 1 |
| EMP-0024717 | Harriet | Hassan | Harriet Hassan | harriet.hassan@vertexhaven.io | Product Designer II | 1 |
| EMP-0024718 | Jolene | Siddiqui | Jolene Siddiqui | jolene.siddiqui@vertexhaven.io | Principal Product Designer | 3 |
| EMP-0024719 | Nadia | Harrington | Nadia Harrington | nadia.harrington@vertexhaven.io | Associate Product Designer | 0 |
| EMP-0024720 | Imran | Sharma | Imran Sharma | imran.sharma@vertexhaven.io | Junior Product Designer | 0 |
| EMP-0024721 | Jonas | Hagen | Jonas Hagen | jonas.hagen@vertexhaven.io | Senior Product Designer | 2 |
| EMP-0024722 | Isabelle | Sepulveda | Isabelle Sepulveda | isabelle.sepulveda@vertexhaven.io | Senior Product Designer | 2 |
| EMP-0024723 | Gerald | Guerrero | Gerald Guerrero | gerald.guerrero@vertexhaven.io | Associate Product Designer | 0 |
| EMP-0024724 | Fabian | Schulz | Fabian Schulz | fabian.schulz@vertexhaven.io | Associate Product Designer | 0 |