Rahul R R

Data Analyst

1+ yrs exp 83 · Excellent

About

Results-driven Data Analyst with 1.5+ years of experience in Banking & Financial Services, specializing in Credit Risk Analytics, Business Intelligence, and Data Visualization. Experienced in Advanced SQL, Power BI, DAX, Power Query, Python, Snowflake, and Advanced Excel for building enterprise dashboards, automating MIS reports, optimizing SQL queries, and delivering actionable business insights. Strong knowledge of Account Origination, Account Performance, Portfolio Analytics, Data Modeling, Stakeholder Management, and KPI Reporting, with a focus on transforming complex banking data into meaningful business decisions.

Skills & Expertise (31)

Index-match Intermediate

7.8/10

1.5

Years Exp

Dashboard Development Intermediate

7.8/10

1.5

Years Exp

DAX Intermediate

7.8/10

1.5

Years Exp

Power Query Intermediate

7.8/10

1.5

Years Exp

Data Modeling Intermediate

7.8/10

1.5

Years Exp

KPI Reporting Intermediate

7.8/10

1.5

Years Exp

Data Visualization Intermediate

7.8/10

1.5

Years Exp

XLOOKUP Intermediate

7.8/10

1.5

Years Exp

Pivot Tables Intermediate

7.8/10

1.5

Years Exp

Advanced Excel Intermediate

7.8/10

1.5

Years Exp

Advanced SQL Intermediate

7.4/10

1.5

Years Exp

Joins Intermediate

7.0/10

1.5

Years Exp

Data Analysis Intermediate

7.0/10

1.5

Years Exp

Data Validation Intermediate

7.0/10

1.5

Years Exp

Report Automation Intermediate

7.0/10

1.5

Years Exp

SQL Server Intermediate

7.0/10

1.5

Years Exp

Data Cleaning Intermediate

7.0/10

1.5

Years Exp

Query Optimization Intermediate

7.0/10

1.5

Years Exp

Views Intermediate

7.0/10

1.5

Years Exp

Stored Procedures Intermediate

7.0/10

1.5

Years Exp

Window Functions Intermediate

7.0/10

1.5

Years Exp

CTEs Intermediate

7.0/10

1.5

Years Exp

EDA Intermediate

6.8/10

1.5

Years Exp

NumPy Intermediate

6.8/10

1.5

Years Exp

Pandas Intermediate

6.8/10

1.5

Years Exp

Snowflake Intermediate

6.0/10

1.5

Years Exp

ETL Intermediate

6.0/10

1.5

Years Exp

Credit Risk Analytics Intermediate

6.0/10

1.5

Years Exp

Stakeholder Management Intermediate

6.0/10

1.5

Years Exp

UAT Intermediate

6.0/10

1.5

Years Exp

Requirement gathering Intermediate

6.0/10

1.5

Years Exp

Work Experience

Data Analyst

Tesco Bank

Jan 2025 - Present

Developed enterprise Power BI dashboards to monitor loan applications, customer acquisition, account performance, portfolio health, delinquency trends, repayment behavior, and executive KPIs. Automated recurring Daily, Weekly, Monthly, and Quarterly MIS reports using SQL and Power BI, improving reporting efficiency and reducing manual effort. Designed optimized Advanced SQL queries using Joins, CTEs, Window Functions, Stored Procedures, Views, and Temporary Tables for large-scale data extraction and reporting. Built scalable Star Schema data models and developed advanced DAX measures for dynamic KPI reporting, trend analysis, and executive dashboards. Performed end-to-end data extraction, validation, cleansing, reconciliation, transformation, and quality assurance across multiple enterprise data sources. Analyzed Account Origination by evaluating customer demographics, bureau data, CIBIL score, income, DTI ratio, employment details, and loan approval trends to support credit decisions. Monitored Account Performance by analyzing repayment behavior, delinquency, roll rates, outstanding balances, collections, portfolio growth, and customer payment patterns. Collaborated with Business, Risk, Operations, and Technology teams to gather reporting requirements and deliver scalable analytical solutions. Supported UAT, production deployment, report validation, documentation, and continuous reporting enhancements. Conducted ad hoc analysis to identify business trends, improve operational efficiency, and support strategic decision-making.