![Indranil Chakraborty](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/07/avatar_73299_1785416842.jpg)
Indranil Chakraborty

# HR Data Analyst | People Analytics & HRIS | Payroll Analytics | Excel Automation & VBA | WFH Kolkata

Actively looking · Member since 30 Jul 2026 [Message](https://jobicy.com/dashboard-page.md)

ShareLocationSerampore, IndiaDesired salaryConfidentialWork preferenceRemote Only / Full Time, Part Time, ContractExperience levelMid
* [Overview](#overview)
* [Portfolio 0](#portfolio)
* [Services 0](#services)

## About

Professional summaryI am an HR Data Analyst with more than five years of experience in workforce analytics, payroll automation, HRIS reporting, and data accuracy management.

I have delivered workforce reporting and payroll-related analytics for more than 100 employees across 15 departments, maintaining 99.9% payroll accuracy over 24 consecutive months with zero missed service-level agreements.

I specialize in automating HR processes using Excel VBA, Macros, Power Query, Pivot Tables, and advanced formulas. My automation work reduced a six-hour manual reporting cycle to 40 minutes and recovered more than 10 staff-hours per week.

My experience includes attendance ingestion, leave reconciliation, payroll variance analysis, cost allocation audits, workforce reporting, attrition analysis, and compliance documentation.

I am actively developing my SQL and Power BI capabilities to deliver end-to-end People Analytics solutions and interactive HR dashboards.

I am targeting HR Analytics, People Analytics, and HRIS Reporting roles in GCC, multinational, and global technology environments.

Notice period: 60 days

## Skills

13 capabilities[Cost Allocation](https://jobicy.com/talent/cost-allocation.md)[Data Analysis](https://jobicy.com/talent/data-analysis.md)[Data Auditing](https://jobicy.com/talent/data-auditing.md)[Excel](https://jobicy.com/talent/excel.md)[HR Analytics](https://jobicy.com/talent/hr-analytics.md)[Leave Reconciliation](https://jobicy.com/talent/leave-reconciliation.md)[MIS](https://jobicy.com/talent/mis.md)[Payroll Analysis](https://jobicy.com/talent/payroll-analysis.md)[People Analytics](https://jobicy.com/talent/people-analytics.md)[Process Improvement](https://jobicy.com/talent/process-improvement.md)[Report Automation](https://jobicy.com/talent/report-automation.md)[SQL](https://jobicy.com/talent/sql.md)[Trend Analysis](https://jobicy.com/talent/trend-analysis.md)

## Tech stack & tools

Working toolkit

### Development

[![Image](https://cdn.jsdelivr.net/gh/devicons/devicon@master/icons/github/github-original.svg) GitHub](https://jobicy.com/talent?tool=github.md)

## Experience

Career history

### HR MIS & Data Analytics Analyst · Healthcare Informatics Pvt. Ltd.

Apr 2023 – PresentServe as the sole analyst for more than 100 employees across 15 departments, managing attendance ingestion, leave reconciliation, payroll variance analysis, workforce reporting, and cost allocation audits.

Built Excel automation using VBA, Macros, Power Query, and Pivot Tables, reducing a six-hour weekly manual cycle to a 40-minute systematized run. Engineered biometric-to-payroll validation processes, audited more than 200 monthly leave transactions, produced workforce analytics across 500+ records, and maintained 99.9% data accuracy with 100% SLA compliance over 24 consecutive months.

### Data & Records Management Coordinator · Mother Mary Day School / Dream India Educational Trust

Jan 2021 – Dec 2023Built the institution's first digital records infrastructure and migrated more than 270 paper records into a structured digital system.

Analyzed more than 150 monthly student evaluations and created trend reports used in academic planning. Achieved 98% data accuracy during the first external audit and passed two consecutive annual compliance audits with 100% documentation accuracy.

## Education

Learning history

### MAKAUT, West Bengal

2020B.Tech, Civil Engineering

Graduated with a DGPA of 8.33/10.

### WBSCT, West Bengal

2016Diploma, Civil Engineering

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.