Open to opportunities

Riya Gambhir

@riyagambhir

Message

Data Analyst with 3+ years in HR operations, building SQL and Power BI insights that drive hiring decisions.

India

Message

What I'm looking for

I’m looking for a Data Analyst role where I can build KPI dashboards, run cohort and trend analysis, and translate SQL/Power BI insights into stakeholder-ready decisions that improve hiring, retention, and operations.

I’m a Data Analyst with 3+ years of experience in HR and business operations, where I’ve built SQL and Power BI dashboards, Excel analytics tools, and data-driven reports that directly influenced hiring strategy and workforce decisions. I pivoted into a dedicated Data Analyst role by applying KPI tracking, cohort analysis, data modeling, and stakeholder reporting with a strong focus on actionable outcomes.

In my recent role, I built Power BI dashboards tracking 10+ hiring KPIs (Time-to-Hire, Offer-to-Join, Pipeline Velocity), cutting the reporting cycle time by 20% and enabling real-time leadership decisions. I consolidated HRMS and Excel datasets using Power Query, reduced drop-off by 15%, and automated recurring monthly KPI reporting—saving ~8 hours per cycle—while presenting weekly insights decks to senior HR leadership.

Experience

Work history, roles, and key accomplishments

Current

Talent Acquisition Specialist

Current

MSBC Group

Aug 2025 - Present (10 months)

Built Power BI dashboards tracking 10+ hiring KPIs (time-to-hire, offer-to-join, pipeline velocity), cutting reporting cycle time by 20% and enabling real-time leadership decisions. Consolidated HRMS and Excel datasets using Power Query, mapping funnel stages to identify drop-offs and reducing them by 15% while automating monthly KPI reporting to save ~8 hours per cycle.

Power BI DAX KPIs Power Query HR Analytics SQL Data Automation

HR Executive

Solvex Solutions LLP

Jun 2024 - Jul 2025 (1 year 1 month)

Designed Excel dashboards using Power Query and Pivot Tables for employee engagement and attrition analysis, informing 2 retention policy changes. Performed root-cause analysis on operational workflow data, identifying 5 bottlenecks and improving process timelines by 15%, while automating structured workforce planning reports for HR business partners.

Excel Power Query Pivot Tables Attrition Data KPI Tracking Root Cause Analysis Workforce Planning Stakeholder Management

HR Recruiter

Hirekey Consultancy

Jan 2023 - May 2024 (1 year 4 months)

Led a team of 4 and built Excel-based hiring funnel trackers to monitor stage-wise conversion ratios, improving successful placement outcomes by 64%. Created visual funnel reports to surface sourcing and screening bottlenecks, improving client delivery timelines by ~20% and standardizing team data templates.

Recruitment Analytics Excel Data Visualization Team Leadership Process Improvement Stakeholder Management

Education

Degrees, certifications, and relevant coursework

Prestige Institute of Management and Research

Bachelor and Master of Business Administration, Business Administration

2018 - 2023

Grade: 75%

Completed a combined Bachelor and Master of Business Administration program at Prestige Institute of Management and Research from 2018 to 2023, achieving 75%.