Ansab Shah Khan
New Delhi
Summary
Results-driven professional with over 5 years of experience in reporting, dashboard creation, and data analysis. Expertise in generating actionable insights from diverse data sets and streamlining reporting processes for multinational clients. Proven track record in managing client portfolios, ensuring compliance, and delivering high-quality reports within tight deadlines. Committed to achieving team objectives and enhancing operational efficiency.
Overview
6
6
years of professional experience
Work History
Lead Analyst
Mercer India
Noida
09.2022 - Current
- Spearheaded generation of customized ad hoc reports for multinational clients, enhancing data accuracy by 25% through automation.
- Designed dynamic reports using Excel features like PivotTables, LOOKUP, Macros, and Conditional Formatting.
- Created BI dashboards and PowerPoint presentations to deliver insights to stakeholders, improving decision-making effectiveness.
- Collaborated with over five international clients to consolidate and analyze specific data for contractual compliance.
- Redesigned reporting templates and workflows, reducing turnaround time by 20% while boosting cross-team efficiency.
- Managed end-to-end project lifecycles, ensuring all client reports delivered on schedule and in compliance with standards.
Benefits Analyst
Aon Consulting
Gurgaon
09.2019 - 09.2022
- Data Analysis: Developed and presented monthly ad-hoc reports for clients to reduce error rates and increase efficiency.
- Client Advisory: Conducted quarterly reviews with multinational clients, translating complex data into actionable insights to support strategic decision-making.
- Compliance & Audits: Executed regular audits of benefit programs, reducing discrepancies by 15%, and strengthening client trust.
- Team Development: Trained 10+ analysts on process knowledge and improvement techniques, elevating team productivity.
Education
PG Certification - Data Analytics & Gen AI
Indian Institute Of Technology
Guwahati11-2025
MBA - Finance And Marketing
Abdul Kalam Technical University (AKTU)
Lucknow06.2021
Bachelor Of Commerce - Commerce
Shyam Lal College (University of Delhi)
Delhi04.2019
Skills
- Advance Excel
- MS PowerPoint
- SQL
- Power BI
- Client communication
- Critical thinking
- Planning and coordination
- Stakeholder management
- Data quality management
Timeline
Lead Analyst
Mercer India
09.2022 - Current
Benefits Analyst
Aon Consulting
09.2019 - 09.2022
PG Certification - Data Analytics & Gen AI
Indian Institute Of Technology
MBA - Finance And Marketing
Abdul Kalam Technical University (AKTU)
Bachelor Of Commerce - Commerce
Shyam Lal College (University of Delhi)
Similar Profiles
Atul GargAtul Garg
Associate Director at Mercer India Pvt. LtdAssociate Director at Mercer India Pvt. Ltd
Subhodip RoySubhodip Roy
Assistant Manager – Lead Specialist at Mercer India Consulting LimitedAssistant Manager – Lead Specialist at Mercer India Consulting Limited
Robin SinghalRobin Singhal
Project Manager at Mercer India Consulting Private LimitedProject Manager at Mercer India Consulting Private Limited
Nitin DhamijaNitin Dhamija
Chief Finance Officer (CFO) at Expo Stand Services Pvt. Ltd.Chief Finance Officer (CFO) at Expo Stand Services Pvt. Ltd.
NIRMALENDU BARDOLOINIRMALENDU BARDOLOI
Product Release Manager at Sapiens TechnologiesProduct Release Manager at Sapiens Technologies