Summary
Overview
Work History
Education
Skills
Projects
Certification
Timeline
Generic
Vicky Rathee

Vicky Rathee

Gurgaon

Summary

Credit Risk and Data Analytics professional with 4+ years of experience in SAS, SQL, Python, Power BI, and Excel, supporting credit risk assessment, IFRS-9 ECL analysis, PD modeling, and financial modeling. Experienced in data preparation, model support activities and skilled in translating complex financial and risk data into actionable business insights.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Associate

Acuity Analytics
Gurugram
06.2022 - Current
  • Delivered credit risk analytics for banking clients on retail loan products using SQL, SAS, Python, Excel, and Power BI.
  • Conducted creditworthiness and loan eligibility assessment for corporate borrowers by analyzing financial statements, transaction history, and repayment capacity.
  • Contributed to IFRS-9 ECL analysis by supporting PD calculations and credit performance monitoring.
  • Performed data preparation, quality checks, and missing value treatment on large-scale retail loan datasets to ensure modeling and reporting accuracy.
  • Developed financial risk models in Excel incorporating key ratios such as debt-to-equity, interest coverage, liquidity, and leverage metrics.
  • Built interactive Power BI dashboards and management reports to monitor portfolio health, credit performance, and risk exposure for senior stakeholders and credit committees.

Senior Analyst

Daloopa Private ltd
Noida
05.2021 - 05.2022
  • Extract data from 10k, 10Q and 8K reports into structured formats using SQL
  • Create and maintained Power Bi Dashboards to visualize key financial metrics, enhancing insights for client decision making
  • Designed and implemented SQL -driven data models for financial analysis, improve efficiency in data processing and reporting
  • Built the model from scratch in Ms-Excel, incorporating historical data and forecasting future financial performance of the company

Education

MBA - Finance

ICFAI Business School
Bangalore
01.2020

Skills

  • SAS
  • Credit risk modelling
  • Python
  • SQL
  • PD Analysis
  • Logistic Regression
  • POWER BI
  • Advance Excel
  • Investment banking operations
  • Financial modeling
  • DAX
  • Predictive Modelling

Projects

IFRS-9 ECL & Credit Risk Analytics Project

  • Supported IFRS-9 Expected Credit Loss (ECL) analysis by assisting in PD estimation, staging logic, and portfolio-level loss calculation using SAS and SQL.
  • Performed WOE-based variable analysis, fine and coarse classing, and logistic regression to support Probability of Default (PD) modeling.
  • Conducted vintage and roll-rate analysis to assess delinquency migration and monitor credit portfolio performance.
  • Applied macro-economic overlays to convert TTC PD to PIT PD in line with IFRS-9 requirements.
  • Built Power BI dashboards and management reports to track ECL trends, delinquency buckets, and portfolio risk metrics.

Python Data Preparation & Modeling Project

  • Performed data cleaning and preprocessing using Python (pandas, NumPy), including missing value treatment, data validation, and consistency checks on financial datasets.
  • Conducted outlier detection and treatment using statistical techniques such as IQR and percentile capping to improve data stability.
  • Applied dummy variable encoding for categorical features and performed correlation analysis to identify multicollinearity and reduce redundant variables.
  • Executed feature engineering by creating derived risk indicators and normalized variables to enhance model interpretability and performance.
  • Split data into training and testing sets and developed baseline predictive models using scikit-learn.

Certification

• Certification in Data Science (Power BI, Python, Tableau, SAS) from TrainingYA Institute, Gurgaon.
• Certification in Credit Risk Modelling using SAS.
• Certification in Algotrading and API data extraction using Python from Tradehull.
• Certification in Modelling and Valuation using Excel from IB Institute, New Delhi.
• Certification in Investment Banking operation Program from Imarticus, Gurgaon.

Timeline

Senior Associate

Acuity Analytics
06.2022 - Current

Senior Analyst

Daloopa Private ltd
05.2021 - 05.2022

MBA - Finance

ICFAI Business School
Vicky Rathee