Deepanjan Bhaduri
Kolkata
Summary
- Experienced professional in Financial Statement Modelling with over 5 years of expertise using VBA and Python.
- Analytical and problem-solving professional with a strong background in team management and planning. Demonstrated expertise in leveraging skills to drive effective solutions. Seeking new opportunities to apply knowledge and contribute to organizational success.
- Results-driven professional with a proven track record of successfully managing and executing challenging projects within strict timelines. Strong communication and negotiation skills coupled with effective leadership abilities. Exceptional talent for building and maintaining relationships.
- Experienced professional adept at implementing innovative ideas within teams, consistently achieving goals with an unwavering commitment to ethical work practices.
- Experienced professional in CLO deal modelling with expertise in Indenture for payment and effective date. Skilled in both waterfall and report analysis. Big4 firm background.
- Experienced professional well-versed in ESG products including EU Taxonomy, SFDR, and Climate. Demonstrated expertise in implementing these frameworks to drive sustainable outcomes. Skilled in leveraging key competencies to deliver impactful results.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Assistant Manager and Team Lead
ICRA Analytics Limited (ICRA)
Kolkata
03.2023 - Current
- Working in modeling various company products for automation purposes using NLP programming in Python.
- Worked in European Union Taxonomy ESG product, enrichment of data with regards to particular KPI.
- Working directly in various financial statement extraction automation using various tools and platforms.
- Managed a team of approximately 25 members and closely worked with the client to meet their day-to-day business needs.
- Working in process re-engineering of various Financial Processes by automating and designing using various Python libraries.
- Managed team of approximately 25 members and closely worked with the client to meet their day-to-day business needs.
- Worked directly with client planning team to create several tracking models for other ESG products.
- Created various VBA macros and automated models for ensuring timeliness and quality of the deliverables to the client.
- End-to-end process automation ensures a smooth workflow among team members.
Consultant
Ernst and Young Global Delivery Service LLP (E&Y)
Bengaluru
09.2022 - 03.2023
- Creating collateral models (With Excel and VBA) for various tests like due diligence and quality, concentration verification of ongoing payment dates and effective dates
- Performing cash flow modelling on deals to tie out client’s loan amortization tables.
- Preparing workpapers to supports final Agreed Upon Procedure (AUP) to clients.
- Coordinate with EY onshore team for smooth flow of work and meet timeline of the engagements.
- Perform a detailed review of the trustee reports for the CLO asset class.
- Additionally, created various models for the weekly tracking of progress with VBA and excel formulas.
Assistant Manager
ICRA Analytics Limited (ICRA)
Kolkata
03.2022 - 09.2022
- Co-ordinate with HR for issues related to reporting members
- Worked with top management for process strategies and execution.
- Assisted in the development of operational strategies to ensure efficient and productive operations.
- Provided guidance and support to junior staff members on daily tasks, projects, and objectives.
- Coordinated with other departments to ensure smooth flow of operations.
- Supervised daily operations including scheduling shifts, assigning duties.
- Served as a liaison between staff members and senior management personnel.
Principal Analyst
ICRA Analytics Limited (ICRA)
Kolkata
04.2020 - 03.2022
- Co-ordinate with client to meet their requirement
- Worked with top management for process strategies and execution.
- Developed and implemented strategic plans for a team of analysts.
- Provided guidance on data analysis techniques to support project objectives.
- Reviewed analyst performance and provided feedback as needed.
- Assisted in developing strategies for improving data quality standards.
- Collaborated with internal teams to define KPIs and develop metrics tracking systems.
- Identified needs of customers promptly and efficiently.
Financial Lead Analyst
ICRA Analytics Limited (ICRA)
Kolkata
04.2018 - 03.2020
- Proper allotment of work to all the members to achieve daily workflow
- Various Automations regards to Advance Excel and Macros to meet the needs of the client.
- Mail communication within the group, and sometimes at the client level as well.
- Admin related works and Monthly Information report (MIS) which gives the overview of the monthly work to the Company top management and Client Management.
Associate Financial Analyst
ICRA Analytics Limited (ICRA)
Kolkata
04.2015 - 03.2018
- Preparation of an Excel-based, systematized workbook of information, which further helps another team in giving ratings to the client.
- Preparation of tabs related to various domains (Financials, Debt Statement, Tax, Pension, Payroll, etc.) which needs to be populated and pass adjustments, keeping in mind the quality, consistency, and the deadline of the project.
- Reporting data of Governmental funds from the balance sheet.
- Reporting data from different data sources into the current database.
- Systematically reviewed documents and assembled financial statements.
- Calculating short- and long-term debt and capital assets from the long-term and capital asset schedule and working on the employee pension scheme, filling in different values like net share, gross share, etc.
Intern
Indian Overseas Bank
Kolkata
06.2014 - 07.2014
- Project on: Credit Appraisal Process of MSME sector
- Analyzing various loan supporting document and creating a report of their Monthly, Quarterly and Annual performance.
Education
Senior Secondary Examination -
DAV Public School, Motihari, Bihar
01.2009
Secondary Examination -
DAV Public School, Motihari, Bihar
01.2007
MBA (Finance) -
University College of Arts and Commerce, Calcutta University
B.Tech (ECE) -
Asansol Engineering College, WBUT, Asansol
Skills
- Financial Analysis
- Modelling
- Python
- Visual Basic (Macro)
- CLO Modelling
- Securitization
- Data Visualization in Excel
- Team Management
- Task Delegation
- Product and service knowledge
Certification
- SQL
- Power BI
- Python
- Diploma in Computer Application
- Advance Visual Basic (VBA Macros)
- Data Analysis
Internship
Indian Overseas Bank, Kolkata, West Bengal, 06/01/14, 07/31/14, Credit Appraisal Process of MSME sector., Analyzing various loan supporting document and creating a report of their Monthly, Quarterly and Annual performance.
Personal Information
- Total Experience: 9 years 5 months
- Date of Birth: 12/13/92
- Nationality: Indian
Personality Traits
- Ability to work independently and deliver on targets.
- Works efficiently under pressure and in teams.
- Detail oriented attitude with extensive analytical skills.
Languages
- English
- Hindi
Disclaimer
I, Deepanjan Bhaduri solemnly declare that the information is truly stated and correct and I am competent to furnish as well as verify it with adequate details whenever requested., Kolkata, West Bengal, 08/30/24
Timeline
Assistant Manager and Team Lead
ICRA Analytics Limited (ICRA)
03.2023 - Current
Consultant
Ernst and Young Global Delivery Service LLP (E&Y)
09.2022 - 03.2023
Assistant Manager
ICRA Analytics Limited (ICRA)
03.2022 - 09.2022
Principal Analyst
ICRA Analytics Limited (ICRA)
04.2020 - 03.2022
Financial Lead Analyst
ICRA Analytics Limited (ICRA)
04.2018 - 03.2020
Associate Financial Analyst
ICRA Analytics Limited (ICRA)
04.2015 - 03.2018
Intern
Indian Overseas Bank
06.2014 - 07.2014
Senior Secondary Examination -
DAV Public School, Motihari, Bihar
Secondary Examination -
DAV Public School, Motihari, Bihar
MBA (Finance) -
University College of Arts and Commerce, Calcutta University
B.Tech (ECE) -
Asansol Engineering College, WBUT, Asansol
- SQL
- Power BI
- Python
- Diploma in Computer Application
- Advance Visual Basic (VBA Macros)
- Data Analysis
Similar Profiles
Palash BanikPalash Banik
Deputy Manager and Team Lead at ICRA Analytics Limited (A Group ICRA Company)Deputy Manager and Team Lead at ICRA Analytics Limited (A Group ICRA Company)
RITUPARNA ADHIKARYRITUPARNA ADHIKARY
Lead Analyst at ICRA Analytics LimitedLead Analyst at ICRA Analytics Limited
ANURAG DASTIDARANURAG DASTIDAR
Senior Associate Analyst at ICRA Analytics LimitedSenior Associate Analyst at ICRA Analytics Limited