Sahil Gupta

Apr'24 - Present

• Orchestrated HR transformation initiatives by supporting the integration and implementation of platforms like Darwinbox and Compport; ensured smooth adoption through query resolution and user training.
• Partnered with C&B and HR Tech teams to enhance compensation design and streamline annual appraisal cycles.
• Transformed analytics by migrating 20+ Excel dashboards to Looker Studio, improving report delivery speed by 75%.
• Delivered engagement insights by analyzing Amber and Glassdoor data, and presented findings to leadership for EX improvement plans.
• Developed AI-driven micro-apps using Gemini Studio and HTML, streamlining repetitive HR tasks, and reducing manual workload by 30%.
• Reduced data turnaround time by 50% through real-time reporting solutions across onboarding, attrition, and workforce productivity.

Until Mar 2024

• Analyzed workforce trends across attrition, onboarding, and performance to deliver real-time People Analytics insights.
• Built and deployed multidimensional dashboards and scenario-based simulators to strengthen performance management strategies.
• Applied statistical models (correlation, regression) to extract actionable insights for workforce planning, attrition risk, and talent pipeline decisions.
• Leveraged Amber for employee engagement analytics, derived sentiment insights, and reported monthly trends to HR leadership.
• Partnered with C&B teams on appraisals, job mapping, and pay range design using internal and external benchmarking data.
• Led comprehensive productivity studies as a key component of organizational effectiveness initiatives, identifying areas for improvement and optimization.
• Provided analytical support and strategic guidance to HR leadership, leveraging data-driven insights to align HR initiatives with organizational goals.

• Spearheaded reporting and analytics for pan-India employee data across the Consumer Banking division, covering performance, attrition, and engagement.
• Led analytics initiatives for the Branch Banking and Assets verticals, delivering insights on operational efficiency, headcount trends, and business performance.
• Successfully managed three annual appraisal cycles impacting 20,000+ employees across India; owned end-to-end processes including modeling, budget distribution, data validation, leadership dashboards, and closure.
• Oversaw manpower budgeting processes, ensuring optimal resource deployment, aligned with business growth objectives.
• Designed and maintained monthly dashboards tracking KPIs, appraisal metrics, and workforce health indicators using Excel and visualization tools.
• Created tools and frameworks such as simulators, surveys, sentiment trackers, and attrition risk models to support HR and business planning.
• Acted as a strategic analytics partner to HR and business leaders, aligning insights with talent management, organizational development, and engagement priorities.

• Conducted organization-wide Diversity Survey analysis, identifying gender-based retention challenges and providing insights to guide inclusive policy interventions.
• Built a multi-dimensional deck, translating qualitative feedback into quantified drivers of promotions, supporting leadership in DEI strategy refinement.
• Created a 'What-If' scenario simulator to forecast revenue and margin impact per FTE by adjusting workforce levers (utilization, salary mix, etc.).
• Partnered with the C&B team to analyze the correlation between post-maternity leave duration and attrition, influencing return-to-work policies.
• Evaluated the effectiveness of CSR activities by linking participation data with employee retention, providing insights into engagement, and social impact.

• Conducted a comprehensive analysis of attrition trends among entry-level employees using descriptive and inferential statistical techniques.
• Built interactive dashboards and visualizations to highlight attrition patterns, enabling data-driven conversations with HR leadership.
• Collaborated cross-functionally to gather and validate data, ensuring accuracy in reporting and insights
• Assisted in formulating actionable strategies to mitigate early attrition and strengthen onboarding effectiveness.
• Presented key findings to stakeholders, contributing to the decision to offer a full-time role based on performance.