Divya Gattani
Santa Clara,CA
Summary
Data Analytics professional with over 7 years of experience transforming raw data into actionable insights and performance metrics. Proven ability to automate reporting processes, develop analytical models, and enhance operational efficiency. Expertise in collaborating across functions and effectively communicating complex data to stakeholders for informed decision-making.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Analyst
United Airlines
Gurugram, India
09.2022 - 05.2025
- Streamlined injury and damage reporting workflows, reducing turnaround time by 20% and improving data accuracy by 40% by developing an automated dashboard that delivered daily metrics and root-cause insights for operational stakeholders.
- Led the 360 Audit system as a program manager, reducing user issues by 80% through end-to-end issue tracking, requirement gathering, and cross-department coordination with developers and regional leadership.
- Built a Spotfire dashboard to highlight station-level non-compliance trends, supporting leadership in decision-making, risk mitigation, and resource allocation.
- Leveraged user feedback and audit data to redesign compliance checks, resulting in a 30% reduction in non-compliant actions and 25% improvement in safety metrics across multiple airport stations.
- Created reports on aircraft damages that show the financial impact of the damage, and the man-hours needed to fix it.
- Partnered with cross-functional teams (Maintenance, Operations, BI) to close data gaps, standardize data inputs, and deliver accurate trend analysis to Station Managers and Directors for monthly compliance reviews.
- Created performance decks for executive forums (SRT & CASS), consolidating data visualizations, month-over-month performance trends, and actionable recommendations.
- Delivered training to supervisors on audit tools and dashboard interpretation, enabling data-driven decision-making and improving risk mitigation practices.
Benefit Analyst
AON
Gurugram, India
07.2021 - 08.2022
- Conducted end-to-end system testing of a benefits portal across development and production environments, identifying UX defects and platform inconsistencies to ensure release quality.
- Generated enrollment analytics reports, identifying year-over-year trends—such as plan adoption, demographic engagement, and usage patterns—to assist marketing and product teams in optimizing plan communication and design.
Lead Analyst
Mercer
Gurugram, India
05.2019 - 07.2021
- Built advanced Power BI dashboards (Power Query + DAX) that provided real-time insights into benefits performance, enabling operations and client teams to act on deviations proactively.
- Led the Carrier Analytics project, comparing budgeted vs. actual benefit premiums across vendors, recommending optimal plans, and streamlining client selection processes through documented frameworks (SIPOC, testing, automation).
- Conducted root-cause analysis using Six Sigma methodology, identifying drivers of system inefficiencies and implementing preventive actions to reduce operational risk and improve decision quality.
Analyst
AON
Gurugram, India
09.2016 - 07.2018
- Performed compensation and financial benchmarking analysis for Fortune 500 companies, providing insights to consulting teams for pricing and compensation redesign.
- Developed Tableau dashboards to automate benchmarking reports and accelerate insight generation for consultants.
- Collaborated with automation teams, digitizing manual reporting processes and driving 90% improvement in efficiency and accuracy.
Education
Bachelor of Business Administration -
Guru Gobind Singh Indraprastha University
Delhi, India05-2016
Skills
- Data visualization tools: Power BI, Spotfire, Tableau, Excel
- Data modeling and cleansing
- Automation and KPI development
- Compliance analytics and operational insights
- Stakeholder management and cross-functional coordination
Certification
- Master Certification in Business Analytics (Simplilearn-2021)
- Google Project Management Certification
- Generative AI Overview for Project Managers
Extracurricular Activities
- Volunteered and Coordinated blood donation camps, helping distribute goodies with a team of 2
- Volunteered with 5 team members to Old Age Home visits to spend time with the elderly and engage in activities to help them with their tasks
- Operated as a member of the Organizing Committee of the Annual Management Seminar and coordinated logistics, secured guest speakers, and facilitated panel discussions to foster knowledge exchange and networking opportunities
Accomplishments
1K Exceptional Performance Award Feb 2025
Timeline
Senior Analyst
United Airlines
09.2022 - 05.2025
Benefit Analyst
AON
07.2021 - 08.2022
Lead Analyst
Mercer
05.2019 - 07.2021
Analyst
AON
09.2016 - 07.2018
Bachelor of Business Administration -
Guru Gobind Singh Indraprastha University