Summary
Overview
Work History
Education
Skills
Hobbies and Interests
Accomplishments
Timeline
Generic

Nihar Mehta

Mumbai

Summary

Data Analyst with proven expertise in Power BI, achieving an 8% increase in team productivity by optimizing workflows and mentoring colleagues. Demonstrates strong analytical skills through proficiency in SQL and a keen ability to conduct debt research, translating complex data into actionable insights. Committed to leveraging technical skills to drive data-driven decision-making and enhance team performance.

Overview

8
8
years of professional experience

Work History

Capital Structure Data Analyst

ION GROUP
01.2017 - Current

-- Analytics (SQL & Power BI):

  • Analyzed debt data using SQL joins to create a comprehensive view and sorted the data for efficient use in Power BI.
  • Create interactive visualizations in Power BI with charts, slicers, and RLS for insightful debt exploration.
  • Leverage this data-driven approach for informed decision-making and debt management optimization.

-- Debt Research :

  • Analyzed stressed, distressed, high-yield, and leveraged companies across multiple regions proficiently.
  • Performed detailed analysis of bond indentures, covenants, leveraged loans, and credit agreements for credit events like debt refinancing and restructuring.
  • Performed comprehensive reviews of financial documents and corporate communications to construct precise representations of capital structures.
  • Engaged with clients in meetings, efficiently understanding their problem statements and challenges.
  • Led a team of highly skilled professionals, mentoring new hires and interns during the onboarding process.

Education

MBA - Finance

MANAGEMENT COLLEGE AND RESEARCH CENTRE
MUMBAI
01.2017

B.com - T.Y.B.COM, HSC

MITHIBAI COLLEGE
01.2014

Skills

  • Power BI
  • SQL
  • Python
  • Web scraping
  • Debt Research

Hobbies and Interests

  • Writing
  • Playing cricket
  • Watching Movies

Accomplishments

Awarded recognition for developing KPI metric dashboard for Back-Stop Team.

Result achieved through Dashboard :

  • Enhanced the productivity of the team by 8% through identifying and optimizing time-consuming processes.
  • It streamlined workflow to reallocate resources to critical tasks, enhancing team efficiency.

Timeline

Capital Structure Data Analyst

ION GROUP
01.2017 - Current

MBA - Finance

MANAGEMENT COLLEGE AND RESEARCH CENTRE

B.com - T.Y.B.COM, HSC

MITHIBAI COLLEGE
Nihar Mehta