HR Safe Space
Endpoints / load-j1yko-0039 / employees / EMP-0006668

Ivana Mercado

EMP-0006668 · Employee · projected from the master template

employee_id
EMP-0006668
seq
6,668
first_name
Ivana
last_name
Mercado
middle_initial
—
full_name
Ivana Mercado
work_email
ivana.mercado@vertexhaven.io
work_phone
+1-633-214-1471
home_address_line1
6129 Copper Beech Close
job_title
Sales Manager
job_code
SLS-04-0
job_family
Sales
flsa_status
exempt
job_level
4
job_level_name
Manager
job_level_code
M1
is_people_manager
yes
is_executive
no
department_code
SLS
department_name
Sales
department_function
Revenue
cost_center
CC-2000
location_code
CA-VAN
location_city
Vancouver
location_region
British Columbia
location_country
Canada
location_country_code
CA
location_timezone
America/Vancouver
manager_id
EMP-0001472
manager_seq
1,472
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2024-09-17
tenure_years
1.99
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1986-03-10
age
40
gender
Female
ethnicity
Asian
base_salary_cents
16,615,547
base_salary
$166,155
currency
CAD
bonus_target_pct
12%
bonus_target
$19,939
equity_units
600
compa_ratio
1.062
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
1
location_ordinal
11
employment_status_ordinal
0
performance_rating
2
engagement_score
73
flight_risk_score
23
tenure_days
639

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0006668-1EMP-0006668Ivana Mercado2026-03-25Market adjustmentBenchmark below market P508.71%
CMP-0006668-0EMP-0006668Ivana Mercado2025-07-22Market adjustmentRetention risk identified by manager10.52%
CMP-0006668-2EMP-0006668Ivana Mercado2024-09-26Annual bonusContractual step increase9.9%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0006668-0EMP-0006668Ivana MercadoPTOPaid time off14.10
BAL-0006668-1EMP-0006668Ivana MercadoSICKSick leave70
BAL-0006668-2EMP-0006668Ivana MercadoPARENTParental leave59.10
BAL-0006668-3EMP-0006668Ivana MercadoBEREAVBereavement leave3.50
BAL-0006668-4EMP-0006668Ivana MercadoJURYJury duty70
BAL-0006668-5EMP-0006668Ivana MercadoUNPAIDUnpaid leave of absence21.10
BAL-0006668-6EMP-0006668Ivana MercadoVOLVolunteer day1.40
BAL-0006668-7EMP-0006668Ivana MercadoSABSabbatical21.10

Benefit enrollments (3)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0006668-1EMP-0006668Ivana MercadoDEN-STDDental - StandardDentalactive
BEN-0006668-2EMP-0006668Ivana Mercado401K-STD401(k) - 4% matchRetirementactive
BEN-0006668-0EMP-0006668Ivana MercadoMED-HDHP-FAMHDHP + HSA - FamilyMedicalactive

Recent payslips (43)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0006668-0048EMP-0006668Ivana MercadoRUN-00482026-06-172026-06-21$11,908
PAY-0006668-0047EMP-0006668Ivana MercadoRUN-00472026-06-022026-06-06$6,923
PAY-0006668-0046EMP-0006668Ivana MercadoRUN-00462026-05-182026-05-22$6,923
PAY-0006668-0045EMP-0006668Ivana MercadoRUN-00452026-05-032026-05-07$6,923
PAY-0006668-0044EMP-0006668Ivana MercadoRUN-00442026-04-182026-04-22$6,923
PAY-0006668-0043EMP-0006668Ivana MercadoRUN-00432026-04-032026-04-07$6,923
PAY-0006668-0042EMP-0006668Ivana MercadoRUN-00422026-03-192026-03-23$11,908
PAY-0006668-0041EMP-0006668Ivana MercadoRUN-00412026-03-042026-03-08$6,923
PAY-0006668-0040EMP-0006668Ivana MercadoRUN-00402026-02-172026-02-21$6,923
PAY-0006668-0039EMP-0006668Ivana MercadoRUN-00392026-02-022026-02-06$6,923

See all 43 →

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0051764AmbroseStoltenbergAmbrose Stoltenbergambrose.stoltenberg@vertexhaven.ioSenior Account Executive2
EMP-0051765NicoleIglesiasNicole Iglesiasnicole.iglesias@vertexhaven.ioAssociate Account Executive0
EMP-0051766LeonardStanhopeLeonard Stanhopeleonard.stanhope@vertexhaven.ioAssociate Account Executive0
EMP-0051767TessaHoskinsTessa Hoskinstessa.hoskins@vertexhaven.ioAccount Executive1
EMP-0051768WillaSorensenWilla Sorensenwilla.sorensen@vertexhaven.ioAccount Executive1
EMP-0051769KwameHoffmanKwame Hoffmankwame.hoffman@vertexhaven.ioAccount Executive1
EMP-0051770MarisolSokolovMarisol Sokolovmarisol.sokolov@vertexhaven.ioAccount Executive1
EMP-0051771ErikaHendricksErika Hendrickserika.hendricks@vertexhaven.ioJunior Account Executive0
EMP-0051772MaliaSinghMalia Singhmalia.singh@vertexhaven.ioSenior Account Executive II2