Human Resource Analyst

I am an HR Analytics and Workforce Reporting Specialist focused on transforming raw HR data into structured insights that support strategic decision-making. I help organizations move beyond administrative HR reporting into data-driven workforce analysis using Excel-based dashboards, KPI tracking systems, and performance reporting tools.

My expertise covers end-to-end HR data analysis, including employee headcount reporting, attrition and turnover analysis, retention diagnostics, compensation and salary distribution analysis, workforce demographics (gender, age, education, department, job level), tenure analysis, performance rating evaluation, and promotion tracking. I build structured Excel solutions using advanced formulas, Pivot Tables, Pivot Charts, slicers, KPI summary cards, and dynamic reporting sheets that allow leadership teams to filter, interpret, and act on HR metrics in real time.

I have completed practical HR analytics projects including employee attrition analysis to identify drivers of turnover, performance analytics dashboards to evaluate rating distribution and promotion trends, and workforce KPI summaries to assess salary allocation, average tenure, workforce composition, and managerial impact. My analysis focuses on identifying root causes, testing business hypotheses, and translating findings into clear management recommendations such as restructuring compensation models, revising promotion pathways, strengthening training programs, or improving workforce planning.

Technical skills include Advanced Microsoft Excel (IF, VLOOKUP/XLOOKUP, INDEX-MATCH, logical formulas, Pivot Tables, dynamic dashboards, slicers, data validation), HR data cleaning and structuring, KPI development, workforce metrics analysis, dashboard design, reporting automation principles, and business insight presentation. I am also currently expanding into Power BI to enhance data visualization and interactive reporting capabilities.

With a background in Sociology and hands-on HR administration experience, I understand both the human behavior dynamics behind workforce trends and the quantitative metrics required for business evaluation. This combination allows me to analyze HR data not just technically, but contextually — connecting employee behavior, management practices, and organizational outcomes.

I approach every project with analytical discipline, attention to detail, and a strong focus on business impact. My goal is not just to build spreadsheets, but to create reporting systems that reduce uncertainty, improve decision speed, and strengthen HR strategy.

I am available for freelance projects involving HR analytics, Excel-based HR dashboards, workforce data analysis, KPI reporting systems, attrition diagnostics, performance reporting, compensation analysis, and HR data structuring support for growing organizations.