Manaswini Lenka

Analytical and insightful Data Analyst known for productivity and efficiency in task completion. Specialize in data visualization, statistical analysis, and predictive modeling. Excel in problem-solving, critical thinking, and communication, ensuring successful project outcomes and team collaboration.

Banking Credit Risk and Usage Analytics

• Analyzed credit card transaction data using SAS, SQL, and Excel to understand customer behavior and usage patterns.
• Designed and implemented automation tasks using SAS, SQL, and Excel to streamline data processing from a database server to an analytical DataMart.
• Utilized SAS and SQL for data cleaning and preparation, ensuring data quality for analysis.
• Conducted exploratory data analysis in Excel and SQL to uncover insights and trends from the data.
• Created interactive dashboards and visualizations in Power BI to present findings effectively.
• Prepared portfolio monitoring reports based on credit performance, categorizing customers into default and non-default groups and segmenting them by risk.
• Collaborated with hypothetical business units to gather requirements and provided ad-hoc reporting and analysis.
• Continuously evaluated credit portfolio performance , Identified priority accounts for potential recovery and devised appropriate collection strategies.
• Developed strategies for managing delinquent customers, leveraging internal and external data sources to improve recovery rates based on historical analysis.

· SAS

· SQL

· Excel

· Power BI