Kumar Abhisek

Kumar Abhisek

Data Analyst
India

About Me

Data Analyst with 2.5 years of experience in Data Analytics, Business Intelligence, and Banking Credit Risk Analytics. Skilled in SQL, Python, Microsoft Excel, and Power BI for data extraction, data cleaning, data valida…

Experience

Data Analyst

KeyBank
Apr 2024 - Present · 2 years 6 months

<p>Extracted, transformed, and analyzed millions of customer and transactional records using SQL and Python to support credit risk analysis, portfolio monitoring, and business decision-making.<br>
Monitored key portfolio risk indicators including 30+, 60+, and 90+ Days Past Due (DPD), Roll Rates, First Payment Default (FPD), charge-offs, recoveries, payment rates, utilization, and portfolio growth to identify emerging credit risks.<br>
Conducted Vintage Analysis, Roll Rate Analysis, Cohort Analysis, Portfolio Analysis, and Customer Segmentation across customer segments, credit score bands, geographies, and acquisition channels to support credit strategy, collections optimization, and portfolio performance.<br>
Developed and automated recurring portfolio reports using SQL, Python, Excel, and Power BI, replacing manual reporting processes with automated data workflows, KPI reporting, and interactive dashboards; reduced reporting turnaround time by 50%.<br>
Optimized complex SQL queries by restructuring joins, improving filtering logic, and refining query execution processes, resulting in a 35% reduction in report execution time.</p>

Certifications

SQL

Cloudyml · Bhubaneswar , Odisha , India · 2025

Skills

Python SQL Microsoft Excel Power BI Data Analysis Data Extraction Data Cleaning Data Preprocessing Data Validation Data Reconciliation EDA Data Quality KPI Reporting MIS Reporting Dashboard Development Data Visualization Reporting Automation Descriptive Statistics Probability Hypothesis Testing Correlation Analysis Regression Analysis Machine Learning Logistic Regression Linear Regression Classification Feature Engineering Credit Risk Analysis Probability of Default (PD) DPD Analysis Delinquency Monitoring Roll Rate Analysis Vintage Analysis Cohort Analysis Portfolio Analysis Customer Segmentation Portfolio Segmentation Credit Score Analysis Customer Behavior Analysis Pandas NumPy Matplotlib Scikit-learn Stakeholder Management Cross-Functional Collaboration Business Communication
Report this Profile?