HR Safe Space
Endpoints / ember-pier-3541 / employees / EMP-0003356

Andrew Mercado

EMP-0003356 · Employee · projected from the master template

employee_id
EMP-0003356
seq
3,356
first_name
Andrew
last_name
Mercado
middle_initial
—
full_name
Andrew Mercado
work_email
andrew.mercado@northline.com
work_phone
+1-338-293-9301
home_address_line1
5728 Marlborough Street
job_title
Senior People Manager
job_code
HR-05-1
job_family
People & Culture
flsa_status
exempt
job_level
5
job_level_name
Senior Manager
job_level_code
M2
is_people_manager
yes
is_executive
no
department_code
HR
department_name
People & Culture
department_function
Corporate
cost_center
CC-4200
location_code
JP-TYO
location_city
Tokyo
location_region
Tokyo
location_country
Japan
location_country_code
JP
location_timezone
Asia/Tokyo
manager_id
EMP-0000985
manager_seq
985
direct_report_count
5
org_depth
6
employment_type
Full-time regular
work_arrangement
Hybrid
employment_status
active
hire_date
2024-12-04
tenure_years
1.78
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1971-09-07
age
55
gender
Male
ethnicity
White
base_salary_cents
17,091,744
base_salary
$170,917
currency
JPY
bonus_target_pct
15%
bonus_target
$25,638
equity_units
1,100
compa_ratio
1.048
band_min_cents
14,432,000
band_mid_cents
17,600,000
band_max_cents
21,824,000
department_ordinal
8
location_ordinal
21
employment_status_ordinal
0
performance_rating
3
engagement_score
29
flight_risk_score
73
tenure_days
214

Compensation history (2)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0003356-1EMP-0003356Andrew Mercado2025-06-09Merit increasePerformance calibration outcome6.31%
CMP-0003356-0EMP-0003356Andrew Mercado2025-01-11Cost-of-living adjustmentAnnual merit cycle7.4%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0003356-0EMP-0003356Andrew MercadoPTOPaid time off11.70
BAL-0003356-1EMP-0003356Andrew MercadoSICKSick leave5.90
BAL-0003356-2EMP-0003356Andrew MercadoPARENTParental leave49.20
BAL-0003356-3EMP-0003356Andrew MercadoBEREAVBereavement leave2.90
BAL-0003356-4EMP-0003356Andrew MercadoJURYJury duty5.90
BAL-0003356-5EMP-0003356Andrew MercadoUNPAIDUnpaid leave of absence17.60
BAL-0003356-6EMP-0003356Andrew MercadoVOLVolunteer day1.20
BAL-0003356-7EMP-0003356Andrew MercadoSABSabbatical17.60

Benefit enrollments (5)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0003356-0EMP-0003356Andrew MercadoMED-HDHP-FAMHDHP + HSA - FamilyMedicalactive
BEN-0003356-1EMP-0003356Andrew MercadoVIS-STDVisionVisionactive
BEN-0003356-3EMP-0003356Andrew MercadoSTDShort-term disabilityDisabilityactive
BEN-0003356-4EMP-0003356Andrew MercadoCOMMUTECommuter benefitsWellbeingactive
BEN-0003356-2EMP-0003356Andrew Mercado401K-ROTHRoth 401(k) - 4% matchRetirementactive

Recent payslips (15)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0003356-0048EMP-0003356Andrew MercadoRUN-00482025-07-052025-07-09$13,531
PAY-0003356-0047EMP-0003356Andrew MercadoRUN-00472025-06-202025-06-24$7,122
PAY-0003356-0046EMP-0003356Andrew MercadoRUN-00462025-06-052025-06-09$7,122
PAY-0003356-0045EMP-0003356Andrew MercadoRUN-00452025-05-212025-05-25$7,122
PAY-0003356-0044EMP-0003356Andrew MercadoRUN-00442025-05-062025-05-10$7,122
PAY-0003356-0043EMP-0003356Andrew MercadoRUN-00432025-04-212025-04-25$7,122
PAY-0003356-0042EMP-0003356Andrew MercadoRUN-00422025-04-062025-04-10$13,531
PAY-0003356-0041EMP-0003356Andrew MercadoRUN-00412025-03-222025-03-26$7,122
PAY-0003356-0040EMP-0003356Andrew MercadoRUN-00402025-03-072025-03-11$7,122
PAY-0003356-0039EMP-0003356Andrew MercadoRUN-00392025-02-202025-02-24$7,122

See all 15 →

Direct reports (5)

employee_idfirst_namelast_namefull_namework_emailjob_titlejob_level
EMP-0014213IkennaGuerreroIkenna Guerreroikenna.guerrero@northline.comManager, People & Culture4
EMP-0014214IngeborgSchulzIngeborg Schulzingeborg.schulz@northline.comPeople Manager4
EMP-0014215SamanthaGreenwoodSamantha Greenwoodsamantha.greenwood@northline.comManager, People & Culture4
EMP-0014216OwenSavageOwen Savageowen.savage@northline.comPeople Manager4
EMP-0014217NormanGoldschmidtNorman Goldschmidtnorman.goldschmidt@northline.comPeople Manager4