Kshitija A Magadum profile photo 1 on Tal

Kshitija A Magadum

Data Analytics Consultant | BI & SQL Specialist | Driving Business Insights & Automation

Bengaluru

8+ years of work experience

Aon
Oct 20241 yr 7 mosPresent

I lead the design and deployment of Power BI dashboards used by global business leaders to drive financial benchmarking and strategic decision-making. I streamline reporting through SQL- and MDX-based automation, reducing manual effort by 60% while improving speed, accuracy, and scalability. I architect and manage robust ETL pipelines and stored procedure, ensuring data integrity across multiple firms. I establish strong data governance through validation frameworks and KPI tracking, enabling clear visibility into year-on-year trends and business performance. I partner with senior stakeholders to identify growth opportunities, enhance profitability, and explore new revenue streams. I oversee end-to-end delivery of complex compensation and rewards initiatives, ensuring SLA adherence, proactive risk mitigation, and seamless execution. By aligning cross-functional teams, I drive operational efficiency, measurable business impact, and long-term sustainability through structured documentation and standardized processes.
Aon
Feb 20222 yrs 9 mosOct 2024

I conducted in-depth financial and operational analyses to support expense optimization, headcount strategy, and performance-to-rewards alignment. I managed complex financial datasets—including compensation, general ledger, capital RWA, revenue, expenses, and headcount—for leading bulge-bracket investment banks, ensuring high data quality through rigorous cleaning, transformation, and loading processes. I introduced automation scripts that reduced reporting effort by 50% per report, significantly improving efficiency and turnaround time. I developed interactive dashboards and performance metrics to deliver insights on revenue benchmarking, people analytics, and pay-for-performance alignment. Through detailed root cause analysis, I identified operational risks and improvement opportunities, implementing process enhancements that reduced manual effort by 15% and improved system efficiency using advanced Excel (Power Query) and SQL. I collaborated closely with the QA team to create clear documentation, resulting in a 30% improvement in team productivity and timely delivery. I maintained transparent communication with stakeholders through regular updates and ad-hoc reporting, ensuring smooth project execution.
GENPACT
Apr 20183 yrs 11 mosFeb 2022

Greater Bengaluru Area

I designed and implemented Engine Health Monitoring (EHM) setups for airlines operating GE and CFM-LEAP engines, enabling accurate Engine Condition Trend Monitoring (ECTM) and proactive maintenance decision-making. I developed and configured data transmission and alert systems, performed data correction and troubleshooting, and conducted detailed trend and performance analyses across climb, takeoff, and cruise phases using GE-issued delta parameter limits. I processed raw DFDR inputs into GE systems to support powerplant condition monitoring visualizations and actionable insights. I managed work orders, coordinated with cross-functional teams, and facilitated weekly customer discussions to resolve technical issues. Partnering closely with GE Field Service Engineering teams, I supported maintenance recommendations through Customer Notification Reports. As a Quality & Research Analyst at Spirit AeroSystems, I analyzed large-scale operational data to drive process improvements, authored high-quality technical documentation, collaborated with SMEs, resolved client escalations through root-cause analysis, and implemented best practices in data visualization—contributing to operational excellence and business growth.
Hindustan Aeronautics Limited
Jan 20161 moJan 2016

Bengaluru, Karnataka, India

Education

MVJ College of Engineering, Bangalore, India

Bachelor of Engineering - BE, Aeronautical/Aerospace Engineering Technology/Technician

MVJ College of Engineering, Bangalore, India

20134 yrs2017

Jawahar Navodaya Vidyalaya, Belagavi

20067 yrs2013

Join Kshitija and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Kshitija A Magadum on Tal

Headline

Data Analytics Consultant | BI & SQL Specialist | Driving Business Insights & Automation

About

I’m a Senior Data Analyst with over 8 years of experience in transforming raw data into business insights across Finance, Consulting, and Aviation. Skilled in SQL, Tableau, Power BI and Advance Excel, I’ve led initiatives that automated 65% of reporting tasks. I’m now focused on building scalable BI systems and exploring AI-powered analytics

Location

Bengaluru

Work experience

Associate Consultant at Aon, Oct 2024 - Present · 1 yr 7 mos, I lead the design and deployment of Power BI dashboards used by global business leaders to drive financial benchmarking and strategic decision-making. I streamline reporting through SQL- and MDX-based automation, reducing manual effort by 60% while improving speed, accuracy, and scalability. I architect and manage robust ETL pipelines and stored procedure, ensuring data integrity across multiple firms. I establish strong data governance through validation frameworks and KPI tracking, enabling clear visibility into year-on-year trends and business performance. I partner with senior stakeholders to identify growth opportunities, enhance profitability, and explore new revenue streams. I oversee end-to-end delivery of complex compensation and rewards initiatives, ensuring SLA adherence, proactive risk mitigation, and seamless execution. By aligning cross-functional teams, I drive operational efficiency, measurable business impact, and long-term sustainability through structured documentation and standardized processes.

Senior Data Analyst at Aon, Feb 2022 - Oct 2024 · 2 yrs 9 mos, I conducted in-depth financial and operational analyses to support expense optimization, headcount strategy, and performance-to-rewards alignment. I managed complex financial datasets—including compensation, general ledger, capital RWA, revenue, expenses, and headcount—for leading bulge-bracket investment banks, ensuring high data quality through rigorous cleaning, transformation, and loading processes. I introduced automation scripts that reduced reporting effort by 50% per report, significantly improving efficiency and turnaround time. I developed interactive dashboards and performance metrics to deliver insights on revenue benchmarking, people analytics, and pay-for-performance alignment. Through detailed root cause analysis, I identified operational risks and improvement opportunities, implementing process enhancements that reduced manual effort by 15% and improved system efficiency using advanced Excel (Power Query) and SQL. I collaborated closely with the QA team to create clear documentation, resulting in a 30% improvement in team productivity and timely delivery. I maintained transparent communication with stakeholders through regular updates and ad-hoc reporting, ensuring smooth project execution.

Analyst and Research at GENPACT, Apr 2018 - Feb 2022 · 3 yrs 11 mos, Greater Bengaluru Area, I designed and implemented Engine Health Monitoring (EHM) setups for airlines operating GE and CFM-LEAP engines, enabling accurate Engine Condition Trend Monitoring (ECTM) and proactive maintenance decision-making. I developed and configured data transmission and alert systems, performed data correction and troubleshooting, and conducted detailed trend and performance analyses across climb, takeoff, and cruise phases using GE-issued delta parameter limits. I processed raw DFDR inputs into GE systems to support powerplant condition monitoring visualizations and actionable insights. I managed work orders, coordinated with cross-functional teams, and facilitated weekly customer discussions to resolve technical issues. Partnering closely with GE Field Service Engineering teams, I supported maintenance recommendations through Customer Notification Reports. As a Quality & Research Analyst at Spirit AeroSystems, I analyzed large-scale operational data to drive process improvements, authored high-quality technical documentation, collaborated with SMEs, resolved client escalations through root-cause analysis, and implemented best practices in data visualization—contributing to operational excellence and business growth.

Student Intern at Hindustan Aeronautics Limited, Jan 2016 - Jan 2016 · 1 mo, Bengaluru, Karnataka, India

Education

Bachelor of Engineering - BE, Aeronautical/Aerospace Engineering Technology/Technician, MVJ College of Engineering, Bangalore, India

Jawahar Navodaya Vidyalaya, Belagavi