Summary
Overview
Work History
Education
Skills
Certification
Languages
Affiliations
Accomplishments
Timeline
Generic

Ajay Prabakaran - HR Data Analysts

Chennai

Summary

Experienced HR Data Analyst with over 5 years of expertise in Leave solutions, data preparation, advanced data modeling, and visualization using Power BI and Excel. Skilled in HR management systems, leave solutions, PTO tracking, and complex payroll calculations. Proven ability to optimize data models and provide actionable insights to drive business growth. Strong analytical and problem-solving skills with a focus on improving organizational efficiency.

Overview

5
5
years of professional experience
1
1
Certification

Work History

HR Data Analyst

Alight Solutions
Chennai
12.2023 - 06.2024
  • Designed and managed HR management systems, including leave solutions and PTO tracking, enhancing operational efficiency and employee satisfaction.
  • Streamlined leave management processes, reducing approval time by 40% and ensuring accurate tracking of leave balances.
  • Conducted comprehensive data analysis and created interactive dashboards and reports using Microsoft Power BI and Excel. Enabled data-driven decision-making and provided actionable insights.
  • Ensured data quality through rigorous cleaning, validation, and maintenance, enhancing reliability and accuracy.
  • Performed complex calculations for overtime, vacation, and sick hours, ensuring accurate payroll processing and compliance with company policies.
  • Drafting and updating job descriptions, and performing calculations for overtime, vacation, and sick hours to support payroll accuracy.
  • Provided training on Power BI and Excel to team members, fostering a data-driven culture and enhancing team capabilities.

Associate Analyst

Guardian Life
Chennai
10.2019 - 11.2023

Education

Bachelor of Science - Computer And Information Sciences

Vels University
Chennai
04-2020

Skills

  • Leave Solutions and HR Management Systems
  • ETL Process
  • Data Visualization and Presentations
  • Advanced Excel
  • Case Management
  • PTO (Paid Time Off) Management
  • DAX Expressions and Time Intelligence Calculations
  • Dashboard Creation
  • Pivot Tables

Certification

  • Microsoft Power BI Data Analyst Professional Certificate
  • Cricket Analytics - Rajasthan Royals

Languages

Tamil
First Language
English
Advanced (C1)
C1

Affiliations

  • Recognized for designing and deploying a leave management system that reduced processing time by 40% and improved accuracy.
  • Awarded for outstanding support across multiple clients and excellence in conducting internal audits.
  • Contributed to process improvement by creating Standard Operating Procedures (SOPs) and generating innovative automation ideas.

Accomplishments

  • SAPPHIRE Award - For dedication and high-quality work, including leave management solutions.
  • PEAK BOOSTER Award - For outstanding support during busy seasons.
  • HIGH-FIVE Award - For maintaining 100% quality in data management and reporting.

Timeline

HR Data Analyst

Alight Solutions
12.2023 - 06.2024

Associate Analyst

Guardian Life
10.2019 - 11.2023

Bachelor of Science - Computer And Information Sciences

Vels University

Similar Profiles

CREATE PROFILE
Ajay Prabakaran - HR Data Analysts