Prakash Mishra – Data Analyst Profile | Credit Risk & Data Analytics

This presentation would show my career growth as a Data Analyst with 3+ years of Bank Credit Risk experience. It highlights my skills in SQL, SAS, Python, Alteryx, and Snowflake for ETL and data modeling and in Power BI and Tableau for data visualization. I have worked throughout the credit risk life cycle of loan origination, account performance, collections, and recovery with the building of risk models (PD, LGD, and EAD) and automating reporting processes. It showcases my technical skills in addition to key projects and impact on business, especially kept in mind for recruiters and organizations searching for analytics professionals with a strong background.”

1. Prakash Kumar Mishra Data Analyst | Banking Credit Risk SQL • SAS • Python • Alteryx • Power BI • Snowflake

2. Professional Summary 3+ years of experience as a Data Analyst in Banking Credit Risk domain Hands-on experience in SQL, SAS, Python, Alteryx, Snowflake, Power BI, Tableau Expertise in Credit Risk Lifecycle – Origination, Performance, Collections, Recovery Strong in ETL, Data Modeling, Automation, and Dashboard Development Collaborated with cross-functional teams to deliver insights for decision-making

3. Technical Skills SQL Server (9/10): Complex queries, stored procedures, performance optimization SAS (8/10): Data manipulation, ETL, reporting automation using macros Python (7/10): Data cleansing, pandas/numpy for ad-hoc analysis & automation Alteryx (8/10): Workflow automation, ETL pipelines, blending multi-source data Snowflake (8/10): DataMart creation, schema design, query optimization Power BI / Tableau (8/10): KPI dashboards, story-telling insights, stakeholder reporting Advanced Excel (9/10): VBA automation, pivot tables, MIS reporting

4. Work Experience Data Analyst | UniCredit SPA | Sep 2022 - Present • Built ETL pipelines using SQL, SAS, Python, Alteryx for risk data processing • Designed DataMarts in Snowflake to support credit risk analysis & dashboards • Automated reporting processes (30% man-hour reduction) using SAS Macros & Excel VBA • Developed risk models – PD, LGD, EAD, credit scoring, risk segmentation • Delivered interactive dashboards in Power BI/Tableau for business KPIs

5. Key Projects Loan Acquisition Model: Predicted default risk using PD, LGD, EAD (Tools: SAS, SQL, Python) Account Origination Reporting: Automated approval, booking, cancellation insights (SQL, Alteryx, Power BI) Account Performance Monitoring: Delinquency segmentation, recovery strategy (Snowflake, SAS, Tableau) Credit Portfolio Analysis: Monthly transaction behavior, customer spend insights (Python, SQL, Power BI) Channel Lift Analysis: Market impact, YOY growth vs channel partner performance (SQL, Excel, Power BI)

6. Education & Certifications B.Tech in Computer Science, ITER, SOA University (2019–2023) Alteryx Designer Core Certified SQL HackerRank Intermediate Java SE 8 Programmer Certified