Bandana Mohanty

Loan Performance Data Analysis

(Application: Excel, SǪL, SAS, Python and Power BI)

• Designed and implemented automation tasks to improve design process, sourcing data from Database Server into analytical Data Marts using Excel, SOL, SAS and Python Programming.
• Executed comprehensive data integration, cleansing, manipulation, aggregation, and data model designing within credit risk and marketing analytics platform using SǪL, SAS, and Python.
• Prepared portfolio monitoring reports based on credit performance of customer bases, categorizing them into default vs non-default groups.
• Segmented customers based on risk association and tracked their performance for continuous improvement.
• Contributed to improving overall efficiency and effectiveness in credit risk and marketing analytics through application of analytical tools and strategic insights.

Collection & Recovery Insight Analysis and Reporting

• Create effective reporting and visualization in loan performance and recovery analysis to communicate insights to stakeholders.
• Utilize tools like Power BI to design interactive dashboards offering holistic view of loan performance and recovery metrics.
• Focus on critical metrics such as default rates, recovery rates, and effectiveness of recovery strategies for quick and clear interpretation.

• Use SQL to integrate diverse ecommerce datasets, ensuring clean and accurate data. Merge customer transaction history, website interactions, and purchasing patterns to build comprehensive understanding of ecommerce trends.
• Gather insights of customer buying pattern and segment them into loyal, Premium and casual groups and make strategy to encourage customers to promoters.
• Prepare dashboards, monthly, daily reports on online sales performance and monthly story to optimize marketing strategy to increase revenue by using Excel and Power BI.
•