Nishtha Goel

About Nishtha Goel

Experienced Data Analytics, Business Intelligence, and Business Analysis professional with 5 years of experience working with international clients across actuarial, tax, accounting, and transport domains. Proficient in Power BI, SQL, VBA, Python, Advanced Excel, and Agile methodologies. Skilled in requirement gathering, stakeholder management, BRDs/FRDs, and UAT. Adept at translating business needs into data-driven solutions, optimizing processes, and delivering insightful visualizations. Strong track record in data analysis, reporting, and performance improvement to support strategic and operational decision-making.

Experience

1. Senior Analyst

   AXA XL

   Nov 2024 — Present · Gurugram, IN

   Collaborated cross-functionally with the Actuarial Data Function, Oasis and Stargate to integrate policy-wise and claims data, actuals, bookings, and exchange rates for end-to-end IBNR reserve calculations across 25 years of historical data.Acted as liaison between actuarial users and data engineering teams—eliciting requirements, documenting BRDs/FRDs, validating UAT outputs, and aligning deliverables with risk modeling objectives. Strengthened data governance and reporting standards across actuarial data systems.Automated complex ETL workflows for the cashflow and discounting project using SQL (T-SQL), VBA and python scripts, cutting manual intervention by 70% and ensuring data consistency across source systems.Collaborated on proof-of-concept initiatives leveraging GenAI technologies, LangGraph, RAG and LLM frameworks to streamline stakeholder communication workflows and enhance data-driven insights.Built and maintained interactive Power BI reports and dashboards with KPIs using DAX, Power Query (M language), and data gateways to deliver real-time insights into premiums, losses, reserves, and IBNR metrics, enhancing strategic decision-making for actuarial teams and senior leadership by 35%.Conducted gap analysis, root cause analysis, and process improvement on reporting discrepancies, driving actionable solutions that enhanced data reliability by 25% and stakeholder trust.

Education

• Dewan Public School

  X

• Amity University

  Master of Business Administration - MBA, Business Analytics

  2023 — 2025

• Dewan public School

  XII

• ABES Engineering College

  Bachelor's degree, Computer Science

  2017 — 2021