Summary
Overview
Work History
Education
Skills
Hobbies and Interests
Accomplishments
Contact
Key Skills
Education
Work Preference
Timeline
AdministrativeAssistant

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
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.

Contact

Mumbai, India 401303

Key Skills

  • WACC
  • Debt Research
  • YTM
  • Duration

Education

MUMBAI

Work Preference

Work Type

Full Time

Work Location

HybridOn-SiteRemote

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