HR & People Analytics

Harsh
Dhiman

MBA Candidate turning workforce data into decisions. Where HR strategy meets Business Analytics โ€” payroll systems, Power BI dashboards, and people-first thinking.

6+
Analytics Projects
10+
Certifications
8.81
SGPA MBA
3
Internships
๐Ÿ“
Una, Himachal Pradesh

Driven by people. Powered by data.

I'm an MBA candidate in HR & Business Analytics at Chandigarh Group of Colleges, with a background that began in pharmaceutical sciences โ€” where I developed a sharp eye for data accuracy, compliance, and process discipline.

My unique cross-domain background lets me bridge a gap most HR professionals can't: I bring genuine analytical depth to people operations. Whether it's building an automated payroll system in Excel or developing Power BI dashboards that surface workforce insights in real time, I turn raw HR data into decisions leadership can act on.

Outside work, I'm a National-level Handball player โ€” which has shaped my team-first mindset, discipline under pressure, and the belief that the best outcomes come from coordinated effort.

๐Ÿ“Š
Data-Driven HR
Power BI, DAX, Excel automation โ€” converting attendance, payroll, and headcount data into dashboards leadership actually uses.
๐Ÿญ
Manufacturing HR Exposure
FMCG to Pharma: recruitment, onboarding, PF/ESI compliance, shop-floor coordination, and SOP-driven training.
๐Ÿ“„
Bexagliflogin โ€” A New Approach for Type 2 Diabetes Mellitus
International Journal of Pharmaceutical Research and Applications ยท May 2023 ยท DOI: 10.35629/7781-080216681671

Where I've
Made an Impact

HR intern
THE SCI SOLCIELO INNOVACION Pvt. Ltd.
IT Services and IT Consulting
Oct - Dec 2025
House No :73, New Area Morabadi, Near Jogo Pahar,Ranchi
Delivered data-driven HR insights in a remote, small-team IT consulting environment
Built and maintained interactive Power BI dashboards for tracking key HR metrics
Optimized HR datasets using Excel (data cleaning, transformation, Pivot Tables)
HR Intern
Mrs. Bector Food Specialities Ltd
FMCG ยท Manufacturing
Jun โ€“ Jul 2025
๐Ÿ“ Tahliwal
End-to-end recruitment: screening & interview scheduling
Onboarding documentation & employee file management
Attendance & leave records managed via Excel
Employee engagement and training coordination
HR policy coordination with employees
Maintained confidentiality of all employee records
Quality Assurance Trainee Officer
Curetech Skincare
Pharma ยท QA
Jan โ€“ May 2024
๐Ÿ“ Baddi
Documentation compliance supporting regulatory standards
Cross-functional coordination & stakeholder management
Structured documentation for HR compliance & policy
Shop-floor workforce discipline and coordination
Apprentice
Torrent Pharmaceuticals Limited
Pharma ยท Operations
Aug โ€“ Dec 2023
๐Ÿ“ Baddi
Manufacturing environment โ€” workforce coordination
Trained new team members on SOPs (L&D support)
Operational records with high data accuracy
Performance tracking & productivity metrics

Skills & Tools

Analytics Tools
MS Excel (Advanced)Expert
Power BIAdvanced
TableauIntermediate
HR Functional
Recruitment & TAStrong
Payroll & Attendance MgmtStrong
Onboarding & DocumentationStrong
Interpersonal
Analytical ThinkingExpert
Stakeholder ManagementStrong
DAX MeasuresPower QueryPivotTablesINDEX-MATCHData ModellingMS PowerPoint

Projects &
Analytics

Power BI ยท HR & Finance
Hospital Management Dashboard
Interactive Power BI solution monitoring patient demographics, medicine stock, doctor KPIs, room utilisation, and billing trends. Integrated HR metrics like doctor availability and commission rates for process improvement insights.
Power BIDAXHR AnalyticsKPI Design
Excel ยท Workforce Analytics
Excel HR Analytics Dashboard
Interactive dashboard tracking headcount, attrition, absenteeism, and performance trends. Used PivotTables, Power Query, and advanced formulas to fully automate data cleaning and reporting.
ExcelPivotTablesPower QueryINDEX-MATCH
Power BI ยท Business Analytics
Torrent Pharma Operational Dashboard
Analysed sales, plant-wise productivity, and workforce distribution across global operations. Supported strategic workforce planning with headcount, regional deployment, and production capacity analytics.
Power BIWorkforce PlanningDAX
Power BI ยท Market Research
Google Trends Analytics Dashboard
Built a Power BI dashboard integrating keyword data to analyse search patterns, top/rising topics, and geographical distribution. Applied DAX and dynamic visualisations to present 23K+ search queries for market and career trend tracking.
23K+Queries analysed
Power BIDAXData Modelling
Power BI ยท Sales Analytics
TATA Motors Sales Dashboard
Sales performance dashboard tracking sales, budget, growth, and regional performance across passenger, commercial, and EV segments. Implemented drilldown visualisations for year-over-year comparisons and strategic decision-making.
Power BIDAXDrilldownYoY Analysis

Education

2024 โ€“ 2026
MBA โ€” HR & Business Analytics
Chandigarh Group of Colleges, Landran
Specialisation: Human Resource Management + Business Analytics
2019 โ€“ 2023 ยท Completed
B.Pharmacy (Allopathy)
DDM College of Pharmacy
SGPA: 8.47 / 10.0 โ€” First Division with Distinction
๐Ÿ“
Bexagliflogin โ€” A New Approach for Type 2 Diabetes Mellitus

Certifications

Career Essentials in Business Analytics
Microsoft & LinkedIn
Data Analyst Job Simulation
Deloitte
Explore Human Resource Job Simulation
GE Aerospace
Microsoft Power BI Desktop for Business Intelligence
Udemy
Data Visualisation: Empowering Business with Insights
TATA
Crisis-Proof HR
Udemy
Talent Acquisition โ€” Human-centered Responsibility
Coursera
SAP SuccessFactors & SAP HCM for S/4HANA Integration
SAP Learning
Power BI Workshop (2 Days)
Sensation Software Solutions
Introduction to Data Science
Cisco

Extra-Curricular

๐Ÿคพ
National Handball Player
Competed at national level โ€” teamwork, discipline & high-pressure performance
โ›บ
National Adventure Camp
Panchmarhi, Madhya Pradesh โ€” leadership and resilience in outdoor challenge
๐Ÿพ
NGO Volunteer
Volunteered with local NGO for animal welfare โ€” community and people-first values
Let's Talk

Open to great HR opportunities.

Looking for HR roles, People Analytics positions, and collaborations where data meets human strategy.