Rohit Mishra
PUNE
Summary
Enthusiastic professional offering more than four years of experience in the field of Data Analytics, Research, Financial Spreading and Credit Services. Desire to secure a responsible career opportunity to fully utilize my training and skills, while making a significant contribution to the success of the company.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Risk Manager
Bajaj Finserv
Pune
12.2022 - Current
- Analysis the credit risk from various factors and taking necessary mitigation actions
- Define functional/non-functional requirements with the stakeholders
- Responsible for data extraction, collation, and cleaning, visualizing
- Extracting the data from Data Lake and Analyzing the performance of the portfolio using financial metrics like FEMI CBB, CE and GFR
- Data storage with all required and probable / important variables
- Analyzing data and reviewing supporting documentation provided by the business
- Creating Dashboard and critical visuals on Power BI to demonstrate insights
- Undertaking regular exposure analysis and monitoring, including investigation of any credit limit excesses
- Responsible for monthly Swap in / Swap out and delinquency segment identification
- Doing Predictive Analysis using chaid
- Working closely with RM and Senior management
- Creating smart and impactful power point presentations
- Maintaining the Product programs (Policy document) and keeping it up to date with all the changes
- Carry out Impact Assessment and create user stories
- Provide Business Analysis and business area of assessment
- Learn company underwriting guidelines and procedures to assess risk
Data Analyst
Laurel IT
Indore
04.2021 - 11.2022
- Writing SQL to interact with Big data, doing ETL, data preparation
- Support team with monthly reporting using Power BI for various reviews
- Making large and/or complex data more accessible and usable
- Extracting, Transforming, loading, and integrating data, depending on the business requirements
- Writing Dax in Power BI for data to create necessary variables
- Helping business to achieve Sales target by generating insights through data
- Responded to client inquiries and resolved issues in a professional and timely manner
- Collaborated with other departments to streamline lending procedures and enhance customer experience.
MIS Executive
Devine Placements
Indore
02.2019 - 03.2021
- Analyzing Data in Excel and Power query and Sharing daily Candidate Reports
- Working with multiple stakeholders within HR to assist them with data management, process adherence and documentation
- Prepare and maintain employee headcount data on a regular basis
- Collaborate with external vendors and internal stakeholders to ensure seamless integration of recruitment technologies
- Developing and executing an employer branding strategy to attract and retain top talent
- Leverage technology, data, and analytics to optimize talent acquisition processes and drive organizational success.
Education
Bachelor of Commerce -
DAVV University
06.2019
HSC -
MP Board
Indore, MP06.2016
SSC -
MP Board
Indore, MP01.2014
Skills
- SQL
- Power BI
- Excel
- Python
- Pandas
- Data Bricks
- SQL Server
- Data Modelling
- Power Point
Certification
Nominated for Bajaj - Train the Trainer Workshop
Awarded for outstanding performance – 2023
Certification of Career Essentials in Data Analysis by Microsoft &LinkedIn
Projects
Max Loan Capping Tracker:
Created Loan Capping Tracker to efficiently track loan capping breaches for both secured and unsecured products. The goal was to adhere to the business-specific loan capping policies in order to highlight cases where loan disbursements exceeded the set limits on a day-to-day basis. I utilized my analytical skills and knowledge of financial models to develop a comprehensive system that would monitor loan disbursements and quickly identify instances where the capping was breached. By implementing this model, we were able to proactively manage and mitigate potential risks associated with loan disbursement breaches, ultimately improving the overall efficiency and compliance of the business. Through this project, I gained valuable experience in data analysis and policy amendment.
EMI Card PL :
Identified lacs of Customer base having EMI Card with quality credit reputation for PLCS and RPL business, and after consultation with required product owner and business COE proposed that customer base to business which helped business to generate 1-2% extra disbursement for each Product(PLCS, RPL)
Through this project, I gained valuable experience in data analysis, credit modeling, and risk management within the banking and financial services sector. I successfully delivered a solution, Used below tools for the project -
SQL : Data Extraction
Excel : Segment identification
Power BI : Visualization
Timeline
Risk Manager
Bajaj Finserv
12.2022 - Current
Data Analyst
Laurel IT
04.2021 - 11.2022
MIS Executive
Devine Placements
02.2019 - 03.2021
Bachelor of Commerce -
DAVV University
HSC -
MP Board
SSC -
MP Board