Somya Roy

HR Analyst with hands-on experience in recruitment analytics, dashboard development, and HR data reporting. Proficient in Power BI, Advanced Excel, and SQL — with proven ability to translate raw HR data into actionable insights. Experienced in building recruitment pipeline dashboards, tracking KPIs, and generating MIS reports in high-volume hiring environments. Pursuing PGDM in HR & Data Analytics (2026) with a focus on people analytics and workforce insights.

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)