Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic
Prateem Chakraborty

Prateem Chakraborty

Credit Risk Analyst
Kolkata

Summary

Credit Risk Analyst with over 3.5+ years of experience in Information Technology and Financial Risk management

Overview

7
7
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
2
2
Languages

Work History

Credit Risk Analyst

Morgan Stanley
06.2023 - Current
  • Identified potential risks by analyzing trends and writing commentaries in ISG Lending data and market fluctuations.
  • Developed and Monitored daily, weekly and monthly Analytical Risk Reports to provide key insights to stakeholders , improving decision-making for credit risk management
  • Automated different reporting processes using PyCharm Python and its different libraries like Pandas, NumPy, PivotTables, reducing time spent by 60% on report generation and enhancing operational efficiency
  • Extracting data using SQL Query, preparing data charts using advanced MS Excel formulas , Providing insights to different Risk committees using MS PowerPoint for Risk mitigation measurements
  • Calculating expected credit losses for Asia Wealth Management portfolio from general market stress and idiosyncratic collateral issuer defaults, computing stress loss summary and top credit loss contributors using Advanced Excel formulas like Pivot Table, VLOOKUP, INDEX-MATCH to analyze larger datasets efficiently
  • Providing data analysis report for Latin America Senior management team for regional credit exposure overview, ISG loan portfolio to help committee members understanding the reason of portfolio change over the period
  • Collaborated with IT and global teams to drive across functional initiatives aimed at improving data accuracy and completeness

System Engineer

Tata Consultancy Services
12.2017 - 02.2020
  • Developed custom software solutions for various business needs, resulting in improved productivity.
  • As part of the Underwriting and Solution Recommendation back-end coding team, coordinated with clients in TCS OMSA Project in BFSI (Banking, Financial Services and Insurance) Domain
  • Developed software and integration using SQL
  • Operated 3 sprints and 10 user stories as a part of Quality Assurance team using HPQC tool in TCS OMSA Project
  • Monitored a team of 8 Manuel Testers for New India Assurance (NIA) Project

Education

MBA - Finance

Institute of Finance And Management Research
Chennai, India
07.2021 - 06.2023

Bachelor of Technology - Electrical Engineering

Academy of Technology
Bandel, India
08.2013 - 07.2017

Skills

Advanced Excel

SQL

Python

Java

Tableau

Accomplishments

  • Volunteered at Morgan Stanley Give Back campaign by providing essential amenities to rural kids
  • Supervised team of 8 manual testers in the development of TCS New India Assurance(NIA) Project.
  • Performed TCS Road Safety campaign to create awareness among citizens

Certification

Python for Data Science Bootcamp- Libraries, machine learning algorithims, regression models

Timeline

Advanced SQL Bootcamp

11-2024

Python for Data Science Bootcamp- Libraries, machine learning algorithims, regression models

06-2024

Credit Risk Analyst

Morgan Stanley
06.2023 - Current

Microsoft Advanced Excel- Macros, Pivot, Advanced Lookups, Choose function, Index/Match function etc.

10-2022

MBA - Finance

Institute of Finance And Management Research
07.2021 - 06.2023

System Engineer

Tata Consultancy Services
12.2017 - 02.2020

Bachelor of Technology - Electrical Engineering

Academy of Technology
08.2013 - 07.2017

Similar Profiles

CREATE PROFILE
Prateem ChakrabortyCredit Risk Analyst