Summary
Overview
Work History
Education
Skills
Internship
Certification
Languages
Timeline
Generic

Somdatta Mitra

Kolkata

Summary

Results-driven finance professional with 5+ years of experience in data analysis, data mining, data validation and quality checking, creating and monitoring of cash flow models for CMBS deals. Committed to apply my analytical and problem-solving abilities, financial acumen, communication skills to achieve organizational goals.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Lead Analyst

ICRA Analytics Ltd.
07.2021 - Current
  • In addition to the responsibilities as Senior Associate, creating cash flow models for US CMBS Agency deals basis reference data given in offering documents and checking the quality of the models using decrement tables, bond level WAM and projected cash-flow distribution under various prepayment and default scenarios.
  • Supporting in-process training and documentation.
  • Investigated system issues, implemented resolutions to reduce downtime and help in automation of certain redundant processes.


Senior Associate Analyst

ICRA Analytics Ltd.
07.2018 - 06.2021
  • Data validation and quality checking of monthly performance data of over 1800 CMBS deals on multiple applications using multiple QA checks.
  • Sourcing, extracting and populating financial data from entity reports, data mappings as per requirement.
  • Work requires ability to do secondary research from trustee reports, analysis & interpretation of such data.
  • Suggesting improvements to address production bottlenecks and to ensure timely and error-free delivery of output.
  • Improved customer satisfaction by quickly and effectively addressing inquiries and complaints.



Education

M.COM - Accounting & Finance

St. Xavier's College(Autonomous)
Kolkata
05.2018

B.COM(Hons.) - Accounting & Finance

Sivanath Sastri College(Calcutta University)
Kolkata
06.2016

Skills

  • Proficient in Ms Excel, Word & Power Point
  • Good understanding of SQL
  • Strong analytical, problem-solving, quantitative abilities
  • Good interpersonal communication skills
  • Highly organized and efficient, with an ability to multitask and meet deadlines

Internship

Indian Oil Corporation, Finance Department, Pipelines division, Kolkata(2017)

  • Functional overview of pipelines division
  • Exposure to SAP-FICO module

Certification

  • Mortgage -Backed securities(MBS): Basic to Advanced, Udemy
  • Fixed Income Securities, Udemy
  • Bonds and Stocks, Coursera
  • Excel Skills for Business : Intermediate I, Coursera
  • A complete course in SQL with SQL server, Udemy
  • Agile with Atlassian JIRA, Coursera
  • Foundation of Data Governance Learning Path, Collibra University
  • Collibra Business Analyst/ Data Scientist Learning Path, Collibra University

Languages

English
Hindi
Bengali

Timeline

Lead Analyst

ICRA Analytics Ltd.
07.2021 - Current

Senior Associate Analyst

ICRA Analytics Ltd.
07.2018 - 06.2021

M.COM - Accounting & Finance

St. Xavier's College(Autonomous)

B.COM(Hons.) - Accounting & Finance

Sivanath Sastri College(Calcutta University)

Similar Profiles

CREATE PROFILE
Somdatta Mitra