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

Simon Mercado

EMP-0002448 · Employee · projected from the master template

employee_id
EMP-0002448
seq
2,448
first_name
Simon
last_name
Mercado
middle_initial
—
full_name
Simon Mercado
work_email
simon.mercado@vertexhaven.io
work_phone
+1-247-287-8744
home_address_line1
1787 Elmwood Place
job_title
Manager, Product
job_code
PRD-04-1
job_family
Product
flsa_status
exempt
job_level
4
job_level_name
Manager
job_level_code
M1
is_people_manager
yes
is_executive
no
department_code
PRD
department_name
Product
department_function
Technology
cost_center
CC-1200
location_code
CA-TOR
location_city
Toronto
location_region
Ontario
location_country
Canada
location_country_code
CA
location_timezone
America/Toronto
manager_id
EMP-0000628
manager_seq
628
direct_report_count
9
org_depth
7
employment_type
Full-time regular
work_arrangement
On-site
employment_status
active
hire_date
2023-03-10
tenure_years
3.52
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1983-01-09
age
43
gender
Male
ethnicity
Hispanic or Latino
base_salary_cents
17,676,490
base_salary
$176,765
currency
CAD
bonus_target_pct
12%
bonus_target
$21,212
equity_units
600
compa_ratio
1.031
band_min_cents
12,136,000
band_mid_cents
14,800,000
band_max_cents
18,352,000
department_ordinal
9
location_ordinal
10
employment_status_ordinal
0
performance_rating
3
engagement_score
90
flight_risk_score
14
tenure_days
1,197

Compensation history (1)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0002448-0EMP-0002448Simon Mercado2025-12-28Retention awardRetention risk identified by manager12.41%

Performance reviews (4)

review_idemployee_idemployee_namecycle_coderatingrating_labelpotential
REV-0002448-0EMP-0002448Simon MercadoFY-CUR-H14Exceeds expectationsLow potential
REV-0002448-1EMP-0002448Simon MercadoFY-PRV-EOY4Exceeds expectationsLow potential
REV-0002448-2EMP-0002448Simon MercadoFY-PRV-H13Meets expectationsHigh potential
REV-0002448-3EMP-0002448Simon MercadoFY-P2-EOY2Needs improvementHigh potential

Goals (3)

goal_idemployee_idemployee_nametitlecategoryprogress_pctstatus
GOL-0002448-0EMP-0002448Simon MercadoReduce cycle time for the core workflow by 20%Business results17%off track
GOL-0002448-2EMP-0002448Simon MercadoAchieve 95% on-time delivery for the quarterOperational excellence97%on track
GOL-0002448-1EMP-0002448Simon MercadoImprove team engagement score by 8 pointsCustomer65%at risk

Time off requests (3)

request_idemployee_idemployee_nameleave_typestart_dateend_datebusiness_days
TOR-0002448-2EMP-0002448Simon MercadoParental leave2026-08-022026-08-054
TOR-0002448-1EMP-0002448Simon MercadoPaid time off2026-07-222026-07-265
TOR-0002448-0EMP-0002448Simon MercadoPaid time off2026-01-272026-01-282

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0002448-0EMP-0002448Simon MercadoPTOPaid time off14.12
BAL-0002448-1EMP-0002448Simon MercadoSICKSick leave7.10
BAL-0002448-2EMP-0002448Simon MercadoPARENTParental leave59.40
BAL-0002448-3EMP-0002448Simon MercadoBEREAVBereavement leave3.50
BAL-0002448-4EMP-0002448Simon MercadoJURYJury duty7.10
BAL-0002448-5EMP-0002448Simon MercadoUNPAIDUnpaid leave of absence21.20
BAL-0002448-6EMP-0002448Simon MercadoVOLVolunteer day1.40
BAL-0002448-7EMP-0002448Simon MercadoSABSabbatical21.20

Benefit enrollments (4)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0002448-2EMP-0002448Simon Mercado401K-STD401(k) - 4% matchRetirementactive
BEN-0002448-1EMP-0002448Simon MercadoDEN-STDDental - StandardDentalactive
BEN-0002448-0EMP-0002448Simon MercadoMED-PPO-EEPPO Medical - Employee onlyMedicalactive
BEN-0002448-3EMP-0002448Simon MercadoLIFE-1XBasic life insurance (1x salary)Lifeactive

Recent payslips (48)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0002448-0048EMP-0002448Simon MercadoRUN-00482026-06-182026-06-22$12,668
PAY-0002448-0047EMP-0002448Simon MercadoRUN-00472026-06-032026-06-07$7,365
PAY-0002448-0046EMP-0002448Simon MercadoRUN-00462026-05-192026-05-23$7,365
PAY-0002448-0045EMP-0002448Simon MercadoRUN-00452026-05-042026-05-08$7,365
PAY-0002448-0044EMP-0002448Simon MercadoRUN-00442026-04-192026-04-23$7,365
PAY-0002448-0043EMP-0002448Simon MercadoRUN-00432026-04-042026-04-08$7,365
PAY-0002448-0042EMP-0002448Simon MercadoRUN-00422026-03-202026-03-24$12,668
PAY-0002448-0041EMP-0002448Simon MercadoRUN-00412026-03-052026-03-09$7,365
PAY-0002448-0040EMP-0002448Simon MercadoRUN-00402026-02-182026-02-22$7,365
PAY-0002448-0039EMP-0002448Simon MercadoRUN-00392026-02-032026-02-07$7,365

See all 48 →

Direct reports (9)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0013780EleanorTanakaEleanor Tanakaeleanor.tanaka@vertexhaven.ioProduct Manager II1
EMP-0013781VictorJoshiVictor Joshivictor.joshi@vertexhaven.ioJunior Product Manager0
EMP-0013782VaughnSzaboVaughn Szabovaughn.szabo@vertexhaven.ioAssociate Product Manager0
EMP-0013783InesJayaramanInes Jayaramanines.jayaraman@vertexhaven.ioJunior Product Manager0
EMP-0013784CamilaSuzukiCamila Suzukicamila.suzuki@vertexhaven.ioAssociate Product Manager0
EMP-0013785PalomaJablonskiPaloma Jablonskipaloma.jablonski@vertexhaven.ioStaff Product Manager3
EMP-0013786KarimStrandKarim Strandkarim.strand@vertexhaven.ioJunior Product Manager0
EMP-0013787EdwardIkedaEdward Ikedaedward.ikeda@vertexhaven.ioPrincipal Product Manager3
EMP-0013788FranklinSteinbergFranklin Steinbergfranklin.steinberg@vertexhaven.ioProduct Manager II1