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

Ivan A. Malhotra

EMP-0149070 · Employee · projected from the master template

employee_id
EMP-0149070
seq
149,070
first_name
Ivan
last_name
Malhotra
middle_initial
A
full_name
Ivan A. Malhotra
work_email
ivan.a.malhotra@northline.com
work_phone
+1-661-271-7136
home_address_line1
426 Stonebridge Avenue
job_title
Junior Marketing Specialist
job_code
MKT-00-1
job_family
Marketing
flsa_status
exempt
job_level
0
job_level_name
Associate
job_level_code
IC1
is_people_manager
no
is_executive
no
department_code
MKT
department_name
Marketing
department_function
Revenue
cost_center
CC-2200
location_code
IN-HYD
location_city
Hyderabad
location_region
Telangana
location_country
India
location_country_code
IN
location_timezone
Asia/Kolkata
manager_id
EMP-0020111
manager_seq
20,111
direct_report_count
0
org_depth
8
employment_type
Intern
work_arrangement
On-site
employment_status
active
hire_date
2024-10-07
tenure_years
1.94
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1986-01-22
age
40
gender
Male
ethnicity
Asian
base_salary_cents
2,071,858
base_salary
$20,719
currency
INR
bonus_target_pct
3%
bonus_target
$622
equity_units
0
compa_ratio
1.041
band_min_cents
4,756,000
band_mid_cents
5,800,000
band_max_cents
7,192,000
department_ordinal
5
location_ordinal
19
employment_status_ordinal
0
performance_rating
3
engagement_score
34
flight_risk_score
87
tenure_days
272

Performance reviews (1)

review_idemployee_idemployee_namecycle_coderatingrating_labelpotential
REV-0149070-0EMP-0149070Ivan A. MalhotraFY-CUR-H14Exceeds expectationsLow potential

Goals (1)

goal_idemployee_idemployee_nametitlecategoryprogress_pctstatus
GOL-0149070-0EMP-0149070Ivan A. MalhotraPublish the operating handbook for the functionInnovation68%at risk

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0149070-0EMP-0149070Ivan A. MalhotraPTOPaid time off14.10
BAL-0149070-1EMP-0149070Ivan A. MalhotraSICKSick leave7.10
BAL-0149070-2EMP-0149070Ivan A. MalhotraPARENTParental leave59.40
BAL-0149070-3EMP-0149070Ivan A. MalhotraBEREAVBereavement leave3.50
BAL-0149070-4EMP-0149070Ivan A. MalhotraJURYJury duty7.10
BAL-0149070-5EMP-0149070Ivan A. MalhotraUNPAIDUnpaid leave of absence21.20
BAL-0149070-6EMP-0149070Ivan A. MalhotraVOLVolunteer day1.40
BAL-0149070-7EMP-0149070Ivan A. MalhotraSABSabbatical21.20

Training (4)

training_record_idemployee_idemployee_namecourse_codecourse_titlecategoryis_mandatory
TRN-0149070-2EMP-0149070Ivan A. MalhotraLDR-210Coaching for PerformanceLeadershipno
TRN-0149070-3EMP-0149070Ivan A. MalhotraTEC-330Applied AI for Business TeamsTechnicalno
TRN-0149070-0EMP-0149070Ivan A. MalhotraPRO-430Presentation SkillsProfessionalno
TRN-0149070-1EMP-0149070Ivan A. MalhotraCMP-110Anti-Harassment & Respectful WorkplaceComplianceyes

Recent payslips (19)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0149070-0048EMP-0149070Ivan A. MalhotraRUN-00482025-07-052025-07-09$1,019
PAY-0149070-0047EMP-0149070Ivan A. MalhotraRUN-00472025-06-202025-06-24$863
PAY-0149070-0046EMP-0149070Ivan A. MalhotraRUN-00462025-06-052025-06-09$863
PAY-0149070-0045EMP-0149070Ivan A. MalhotraRUN-00452025-05-212025-05-25$863
PAY-0149070-0044EMP-0149070Ivan A. MalhotraRUN-00442025-05-062025-05-10$863
PAY-0149070-0043EMP-0149070Ivan A. MalhotraRUN-00432025-04-212025-04-25$863
PAY-0149070-0042EMP-0149070Ivan A. MalhotraRUN-00422025-04-062025-04-10$1,019
PAY-0149070-0041EMP-0149070Ivan A. MalhotraRUN-00412025-03-222025-03-26$863
PAY-0149070-0040EMP-0149070Ivan A. MalhotraRUN-00402025-03-072025-03-11$863
PAY-0149070-0039EMP-0149070Ivan A. MalhotraRUN-00392025-02-202025-02-24$863

See all 19 →