Shagufta T

Senior Analyst Total Rewards

Talabat • Full time

Jun 2025 - Nov 2025 • 5 mos

Designed a flexi-benefits framework by defining eligibility rules, building Excel based cost models, and developing a simulator to test multiple plan design scenarios Analyzed compensation structures of a newly acquired company, identifying outliers, overlaps, and leveling gaps, and modeling alignment scenarios to integrate with the parent salary framework Enhanced the Total Rewards dashboard in Tableau by optimizing data models, adding variance and equity tracking, and improving drill-downs for more actionable leadership insights Upgraded the Compensation Diagnostic Tool to Version 2, adding modules for internal-equity/compa-ratio analysis, outlier detection, band alignment reviews, and external market compensation benchmarking Developed an LTI budgeting simulator in Excel, projecting equity award costs under multiple vesting and performance conditions to support long-term incentive forecasting

HR Consultant

KPMG • Full time

Nov 2024 - May 2025 • 6 mos

Redesigned salary bands by merging legacy structures, compensation benchmarking across markets, and introducing tiered ranges with defined midpoints and spreads to ensure consistent progression and pay governance Developed a variable pay analytics suite that analyzed payout distributions against performance ratings, highlighted skew and misalignment, and recommended data driven adjustments to incentive design Developed Total Rewards dashboards for leadership, consolidating HRIS, payroll, and benefits data with automated variance tracking to monitor compensation spend, pay equity ratios, and incentive plan outcomes Modeled workforce D&I gaps by analyzing recruitment funnels, pay equity, and benefits utilization in Excel (regression, advanced formulas) and Power BI (custom DAX, visuals) to deliver data-backed insights Built an enterprise people analytics dashboard in Power BI, integrating Workday, Payroll, and Performance data to visualize attrition, recruitment yield, and demographic KPIs for leadership decision-making Optimized HR service delivery processes during a public sector migration to ServiceNow by designing Visio workflows, identifying automation levers, and converting optimized processes into agile user stories for implementation

Experienced Associate

PwC • Full time

Apr 2021 - Dec 2023 • 2 yrs 8 mos

Built an end-to-end HR Activity Analysis Tool for functional optimization, developing a Level 5 taxonomy in Microsoft Visio to map workflows, designing a Qualtrics survey to capture time allocation data, and using Alteryx and Power BI to analyze and visualize process inefficiencies and automation opportunities Implemented the HR Activity Analysis Tool for US-based clients, integrating predictive analytics to model future cost and FTE optimization scenarios, and uncover trends in role and job fragmentation Led a recruitment data reconciliation project by analyzing discrepancies between Workday data and external tracking systems, utilizing an Excel dashboard to identify misalignments, and optimize system reliance by eliminating redundant databases Identified and evaluated AI-based tools for recruitment optimization by analyzing detailed SOPs, conducting vendor analysis through product demos, and mapping integration points across recruitment lifecycle to achieve cost and time efficiency Optimized the onboarding process by analyzing workflows, addressing pain points, and implementing an external vendor solution to enhance candidate experience Analyzed compensation and benefits data using advanced analytics to evaluate pay equity, compa ratios, and benefits utilization trends, providing actionable insights to optimize reward structures and enhance employee satisfaction Led HR data migration across Payroll, Benefits, and Workday systems, ensuring TSA compliance and coordinating with stakeholders across EMEA, APAC, and US during a global workforce transition as part of a spin-off deal Developed an HR Governance Model with a RACI Matrix to oversee the implementation of the client's HR enhancement plan, designed KPIs to monitor HR function performance, and created a JIRA Kanban dashboard to track progress Developed Tableau-based Market Analysis Tool for US medical insurance sector, encompassing data collection, market potential assessment