Summary
Overview
Work History
Education
Skills
Timeline
Generic

Arun Aggarwal

Delhi

Summary

Seasoned Reporting Analyst with over 8 years of dedicated expertise in collecting and interpreting data, while continuously exploring new frontiers in automation and data analytics.
Proficient in leveraging advanced tools such as Power BI, VBA, Excel, Alteryx, and Power Automate/Apps to craft insightful reports and dynamic dashboards.
I am a passionate learner and committed to staying at the cutting edge of data analytics, constantly expanding skill set to harness the full potential of emerging technologies.

Overview

8
8
years of professional experience
3
3
years of post-secondary education

Work History

Team Leader (Previous Post- SA: Oct'21-Sep'23)

KPMG
10.2023 - Current
  • Led a team 5 Analysts in the preparation of insightful dashboards and reports using learning and development data, enhancing decision-making processes.
  • Implemented automation solutions resulting in a significant time-saving of 7000 hours over 2.5 years, leading to increased efficiency and productivity.
  • Demonstrated proficiency in utilizing various technical tools including Advanced Excel, VBA, Power BI, and basic Alteryx and SQL for data analysis and visualization.
  • Utilized Power Apps and Power Automate to streamline processes and enhance workflow automation.
  • Actively participated in requirement gathering sessions, ensuring alignment between stakeholders' needs and project objectives.
  • Played a key role in driving automation initiatives, optimizing workflows, and reducing manual efforts in my department
  • Excelled in report and dashboarding, leveraging visualization techniques to present data-driven insights effectively.
  • Collaborated effectively within a team environment, fostering a culture of innovation, continuous improvement, and knowledge sharing.

Senior Associate

EY
10.2018 - 10.2021
  • Manage and orchestrate the end-to-end reporting process, from conceptualization to delivery, ensuring stakeholder engagement and maximizing value derived from insights.
  • Proficiently publish reports using Excel, PowerPoint, and Power BI, utilizing advanced features and visualization techniques to effectively communicate key findings and recommendations.
  • Drive automation initiatives leveraging Power BI, Excel, and VBA, streamlining repetitive tasks and enhancing reporting efficiency while maintaining accuracy and consistency.
  • Develop comprehensive training plans for the Regional ASQ team, Account Managers, Partners, and new team members, equipping them with the necessary skills to effectively contribute to the program's success.
  • Engage stakeholders in discussions on service delivery results, providing actionable insights and recommendations to Account teams, and ensuring prompt follow-up on action plans to address client feedback.

Associate

IHS Markit
02.2017 - 09.2017
  • Spearheaded the creation of syndicated loans in ClearPar, meticulously following client instructions and documentation to ensure accurate and efficient processing.
  • Implemented a quality assurance process by reviewing peers' work and providing constructive feedback, fostering a culture of continuous improvement and excellence within the team.
  • Managed accounts and user IDs for buyers, sellers, and agent banks, maintaining data integrity and security to uphold operational efficiency.
  • Utilized advanced Excel skills to develop comprehensive reports and dynamic dashboards, providing stakeholders with actionable insights and facilitating data-driven decision-making.
  • Continuously explored and implemented innovative VBA solutions to address evolving business needs, staying at the forefront of automation technologies and best practices.

Data Analyst

Aon
01.2016 - 01.2017
  • Developed comprehensive plan designs for various health insurance plans using Aon's internal tool, Greater Insight, ensuring alignment with client needs and industry standards.
  • Contributed to the enhancement of RFP response templates, incorporating strategic insights and innovative solutions to effectively showcase Aon's capabilities and offerings.
  • Collaborated closely with underwriters and account executives to gather and synthesize responses, facilitating seamless communication and information flow throughout the RFP process.
  • Managed the release of RFPs to insurance carriers, ensuring accuracy and timeliness in delivery, while also providing timely updates and insights to the client team to support informed decision-making.
  • Produced insightful monthly production reports and dynamic dashboards, utilizing data visualization techniques to present key metrics and trends, enabling stakeholders to track progress and make informed strategic decisions.

Education

BBA - Business Administration and Management

IP University- Maharaja Surajmal Institute
07.2012 - 05.2015

Skills

Power BI Desktop & Serviceundefined

Timeline

Team Leader (Previous Post- SA: Oct'21-Sep'23)

KPMG
10.2023 - Current

Senior Associate

EY
10.2018 - 10.2021

Associate

IHS Markit
02.2017 - 09.2017

Data Analyst

Aon
01.2016 - 01.2017

BBA - Business Administration and Management

IP University- Maharaja Surajmal Institute
07.2012 - 05.2015

Similar Profiles

CREATE PROFILE
Arun Aggarwal