Summary
Overview
Work History
Education
Skills
Accomplishments
Additional Information
Timeline
Generic
Nitin Jaggi

Nitin Jaggi

Assistant Vice President - Reporting
Gurugram

Summary

Results-driven professional with over 13 years of experience in Excel reporting, automation, Power BI reporting, Power Query, Power Automate, SQL, and Alteryx. Proven expertise in leveraging advanced reporting tools and automation technologies to drive process improvements, enhance operational efficiency, and reduce manual efforts. Committed to fostering strong stakeholder relationships and delivering data-driven insights to support strategic decision-making.

Overview

14
14
years of professional experience
2
2
Languages

Work History

Assistant Vice President - Reporting

Moody's Corporation
04.2022 - Current
  • Oversee a global team of three dedicated to reporting.
  • Led the design, development, and implementation of automated reporting solutions using tools such as Power BI, Excel, Power Query, SQL, and Alteryx to provide actionable insights and reduce manual efforts within the GBS area, which includes MA Billing, MIS Billing, Collections, Accounts Payable, and Cash Application.
  • Managed end-to-end reporting processes, including data collection, validation, transformation, and visualization, ensuring high data accuracy and reliability.
  • Collaborated with cross-functional teams and stakeholders to identify reporting requirements, streamline workflows, and improve decision-making processes.
  • Developed and maintained complex dashboards and dynamic reports to track KPIs, operational metrics, and business performance.
  • Spearheaded automation initiatives using Power Automate and scripting tools like excel macros to optimize repetitive tasks and improve process efficiency.
  • Trained and mentored team members on reporting best practices, advanced data tools, and fostering a culture of continuous learning and development.

Sr. Manager - Reporting

Moody's Corporation
01.2021 - 04.2022
  • Managed the reporting structure for the entire Collections team, ensuring streamlined data analysis and delivery.
  • Automated all manual reports using Excel VBA, significantly reducing processing time and manual effort.
  • Transitioned the existing suite of reports to Power BI, enhancing reporting efficiency and visualization quality for the Collections department.
  • Developed new Power BI reports based on senior leadership requirements, enabling data-driven decision-making.
  • Improved the existing reporting suite by integrating real-time data for more accurate and timely insights.
  • Collaborated with stakeholders to gather requirements, understand business needs, and deliver customized Power BI dashboards tailored to their objectives.

Assistant Manager

MetLife
01.2019 - 01.2021
  • Dashboards creation on excel and Power BI.
  • Collaborated with stakeholders to gather requirements, understand business needs, and deliver customized Power BI dashboards tailored to their objectives.
  • Cater Ad hoc Automation request for clients to reduce the manual efforts, and give the best solutions.

Sr. Lead Analyst

Mercer Pvt Ltd.
03.2016 - 01.2019
  • Assist the on shore consulting team in gathering, organizing, entering and analyzing data using Microsoft Excel to be used for various client projects.
  • Automated many reports using Excel VBA.
  • Proactively took the initiative to learn Power BI within the organization when presented with an opportunity, demonstrating adaptability and a commitment to upskilling.
  • Leveraged self-acquired knowledge of Power BI to successfully complete a key project of creating KPI's.

Lead Business Analyst

American Express
01.2012 - 03.2016
  • Worked as an MIS support for my director and the processes leadership team.
  • Create VBA programs to automatically update Excel workbooks, encompassing class and program modules, and external data queries.
  • Manage the maintenance of the American Express credit card by applying a guarantee on the card, processing credit balance refunds, waiving off the balance, canceling the card, and many more.
  • Acted as a Subject Matter Expert (SME) for the process, providing in-depth knowledge and guidance to team members to ensure accuracy and efficiency.
  • Supported team members by resolving process-related challenges and fostering a culture of continuous learning and collaboration.

Education

Bachelor of Business Administration -

Guru Gobind Singh Indraprastha University
New Delhi, India
01.2011

Senior Secondary Examination -

CBSE Board
New Delhi, India
01.2008

Secondary Examination -

CBSE Board
New Delhi, India
01.2006

Skills

  • MS-Excel
  • VBA
  • Power BI
  • Power Query
  • Power Automate
  • SQL
  • Alteryx

Accomplishments

  • Entrusted with Managing Reporting Team: After completing a year with Moodys as Senior Manager-Reporting, i was given this opportunity to take over an existing reporting team and leverage the same.
  • Recognized for Accounts Receivable Power BI: Designed and maintained a Power BI Dashboard for Collections team where in they can track all the open invoices on daily basis with respective USD amount and days overdue which eventually helped them to follow up with customer or sales to get the payment faster.
  • Account Reconciliation Power BI: Recognized and given the opportunity to present the dashboard to the CEO of company as i developed this dashboard from gathering the information and then connecting with respective team to get the data for developing the report. This project helped in reducing manual efforts by approximately 4,000 hours annually and 2 FTE save.
  • Implantation of Microsoft Fabric in Reporting Team: As technology is developing, i was able to have introduced new Microsoft Fabric in the team by guiding the team member with having new technology knowledge gain and having the same in their objectivities for year. Through this the data has been saved in a lake-house environment which helps in faster refresh of the reports.

Additional Information

Currently pursuing an Alteryx course on online platforms such as Udemy to enhance my data analytics and automation skills, with the goal of applying this knowledge to streamline business processes and drive efficiency.

Timeline

Assistant Vice President - Reporting

Moody's Corporation
04.2022 - Current

Sr. Manager - Reporting

Moody's Corporation
01.2021 - 04.2022

Assistant Manager

MetLife
01.2019 - 01.2021

Sr. Lead Analyst

Mercer Pvt Ltd.
03.2016 - 01.2019

Lead Business Analyst

American Express
01.2012 - 03.2016

Bachelor of Business Administration -

Guru Gobind Singh Indraprastha University

Senior Secondary Examination -

CBSE Board

Secondary Examination -

CBSE Board
Nitin JaggiAssistant Vice President - Reporting