Somya Roy

Dissertation Project Topper (10/10 | Outstanding Grade) and PGDM graduate in HR & Data Analytics with a combined 7.81 CGPA. High-potential professional with hands-on proficiency in translating complex workforce data into actionable business insights. Skilled in designing People Analytics dashboards, defining critical HR metrics, and delivering data-driven recommendations to stakeholders.

Proven ability to clean talent datasets, identify workforce trends, and present findings in highly digestible, executive-ready formats using Power BI and Advanced Excel.

HR Associate — Recruitment Analytics - Knowcraft Analytics - Noida

(2025-11 - 2026-02)

• Designed and owned a Recruitment Analytics Dashboard (MS Excel) tracking 200+ applicants across multiple US finance roles — Valuation Analyst, Accounts Analyst, Investment Banking Analyst, and Financial Accounts Analyst — using pivot tables, slicers, conditional formatting, and dynamic filters for real-time pipeline visibility.
• Generated actionable hiring insights from dashboard data — identifying open vs. closed positions, stage-wise candidate counts, selection/rejection trends, and pipeline health — enabling proactive backup pipeline creation before positions went critical.
• Presented data-driven recruitment insights directly to managers, translating dashboard metrics into decisions such as when to activate backup sourcing pipelines and how to reallocate candidates across open positions under different hiring managers.
• Managed end-to-end recruitment lifecycle for US finance analyst roles: sourcing, screening, HR rounds, coordinating technical rounds and final rounds with Senior Managers, AVPs, and VPs.
• Directly coordinated with VPs and senior stakeholders on hiring priorities, ensuring candidate pipelines were aligned with business headcount targets across multiple simultaneous requisitions.
• Tracked offer conversions, drop-outs, and stage-wise funnel metrics across 200+ applicants — enabling the team to identify bottlenecks and maintain healthy hiring velocity for US market roles.

HR Trainee — Talent Acquisition - Tech Mahindra - Noida

(2025-05 - 2025-07)

• Coordinated 100+ telephonic, walk-in, and client interviews, maintaining structured tracking in Excel for real-time pipeline visibility.
• Assisted Confidential Assessment Team in administering psychometric tools: PMAP, SHL, Versant Typing & Voice — ensuring assessment data integrity.
• Supported talent acquisition reporting and employee relations data management for senior HR managers.
• Recognised by supervisors for maintaining high professionalism and structured communication throughout hiring cycles.

Data Management Executive Intern - Gimmick Marketers - Remote

(2024-12 - 2025-01)

• Maintained 100% data accuracy across HR and marketing outreach datasets in Google Sheets, supporting lead conversion analytics.
• Delivered weekly data quality reports to managers, directly improving outreach team efficiency.

PGDM - HR & Data Analytics - GL Bajaj Institute of Management & Research (2024 - 2026)

BBA - Retail Management - Indira Gandhi National Open University (2020 - 2023)