Abhishek Ranjan

HR Analyst with hands-on experience in HRIS data management, employee records auditing, workforce reporting, and dashboard creation using SQL, Advanced Excel, Python, and Power BI. Skilled at transforming employee and operational data into actionable people insights through data validation, automation, and visualization. Proven track record of managing and auditing 500+ employee records with 100% accuracy, automating HR/MIS reports, and building interactive dashboards that support workforce decision-making.

Certified in Data Analytics, with practical project experience across the full data pipeline.

HR Analyst - Credgenics - New Delhi

(2025-06)

• Managed and maintained 1200+ employee records in ZingHR (HRIS), conducting regular data audits and ensuring 100% data accuracy and integrity.
• Built and automated HR MIS reports and executive dashboards using Advanced Excel, SQL, and Python, enabling data-driven HR decision-making.
• Compiled, cleaned, and analyzed HR data from ZingHR, payroll, and recruitment sources to generate workforce reports and actionable insights.
• Tracked key HR and recruitment metrics including headcount, time-to-fill, hiring pipeline, attrition, and workforce trends to support workforce planning.
• Performed HR data validation, standardization, and reconciliation using SQL queries and Python (Pandas) to improve reporting accuracy and data quality.
• Supported compensation and workforce planning by preparing HR reports, analyzing employee data, and assisting in budget and headcount forecasting.
• Analyzed employee lifecycle data, including engagement surveys and exit trends, to identify retention patterns and recommend process improvements.
• Identified reporting and workflow bottlenecks, automating recurring HR reports through Excel, SQL, and Python, reducing manual effort and improving operational efficiency.
• Ensured HR data governance, confidentiality, and compliance while maintaining employee records and supporting HR audits.
• Collaborated with HR, Talent Acquisition, Finance, and business stakeholders to deliver timely workforce analytics and strategic HR insights.

Bachelor of Arts - English Honours - University of Delhi — School of Open Learning (2024)