Jan 2024 – Present 

Actuarial Data Analyst – Mithras Consultants, Gurugram 

• Played a key role in aligning actuarial valuation outcomes with corporate financial strategy, ensuring accurate reflection of long-term employee liabilities in financial statements.
• Utilized Excel and SQL to extract, clean, and validate large employee and financial datasets, ensuring accuracy and consistency for actuarial valuation processes.
• Designed and developed interactive Power BI MIS dashboards integrating HR, and financial data to visualize employee benefit obligations, valuation trends, and financial impacts, enabling senior management to make data-driven strategic and budgeting decisions.
• Conducted in-depth data analysis and modeling in Excel (including pivot tables, Power Query, and advanced formulas) to support employee benefit valuations in compliance with AS 15, Ind AS 19, and IAS 19 standards.
• Partnered with Finance and cross-functional teams to seamlessly integrate actuarial results into financial statements, management reports, and budget forecasts.
• Developed and automated MIS dashboards and analytical reports in Excel, summarizing key valuation results, trends, and KPIs for senior management.
• Built discounted cash flow (DCF) models to estimate present values of employee benefit obligations and assess the financial impact of changing actuarial assumptions.
• Performed comprehensive data validation and checks to ensure accuracy and consistency of employee and financial data used in actuarial valuations.
• Performed scenario and sensitivity analyses to evaluate financial exposure and support strategic decision-making.
• Used SQL queries to perform data extraction, transformation, and aggregation from HR and financial databases for actuarial and financial modeling.
• Analyzed historical HR and financial data to identify patterns in employee turnover, salary escalation, and benefit utilization impacting long-term obligations.
• Automated reporting and modeling workflows in Excel, significantly reducing manual effort and enhancing accuracy.
• Supported variance analysis, forecasting, and performance reviews, providing actionable insights for executive leadership
• Collaborated with auditors and finance teams to explain valuation methodologies, and movements in actuarial liabilities.

Nov 2023 – Dec 2023

Data Analyst Intern – AtliQ Technologies 

• Developed an interactive Power BI dashboard for 'Shield Insurance,' automating data transformations and analyzing trends from 2000+ records using Power Query. [Presentation] [Live Dashboard] [Github]
• Cleaned and standardized a 5,000+ record HR dataset, calculated work-from-home percentages, and analyzed attendance trends for 200+ employees using Excel and Power BI.
• Normalized datasets by creating 10+ fact and dimension tables, and debugged 15+ SQL queries to ensure data integrity and optimize performance. 
• Leveraged Excel pivot tables and advanced formulas to perform detailed ad hoc analysis, streamlining monthly reporting by 20%.
• Identified key business insights such as sales trends and customer behavior patterns, contributing to a 10% improvement in campaign targeting.