Skanda N N

Data Analyst

1+ yrs exp 83 · Excellent

About

Data Analyst with 1.6 years of experience delivering data-driven reporting solutions within the Banking and Financial Services domain at Scotiabank. Skilled in Advanced SQL, Power BI, Python, and Advanced Excel, with hands-on expertise in dashboard development, report automation, data modeling, and stored procedures. Proven ability to transform complex multi-source banking data into actionable KPI dashboards, automate recurring reporting (cutting manual effort by ~30%), and collaborate with stakeholders across risk, marketing, and collections. Strong grounding in Credit Risk Analytics, Account Origination, Account Performance, DataMart design, and loan acquisition/default-risk analysis.

Skills & Expertise (28)

Advanced SQL Intermediate

7.8/10

1.6

Years Exp

Data Modeling Intermediate

7.8/10

1.6

Years Exp

Power Query Intermediate

7.8/10

1.6

Years Exp

DAX Intermediate

7.8/10

1.6

Years Exp

Dashboard Development Intermediate

7.8/10

1.6

Years Exp

Joins Intermediate

7.5/10

1.6

Years Exp

SQL Server Intermediate

7.5/10

1.6

Years Exp

KPI Reporting Intermediate

7.5/10

1.6

Years Exp

RCA Intermediate

7.5/10

1.6

Years Exp

Data Validation Intermediate

7.5/10

1.6

Years Exp

Query Optimization Intermediate

7.5/10

1.6

Years Exp

Views Intermediate

7.5/10

1.6

Years Exp

Stored Procedures Intermediate

7.5/10

1.6

Years Exp

Window Functions Intermediate

7.5/10

1.6

Years Exp

CTEs Intermediate

7.5/10

1.6

Years Exp

DataMart Design Intermediate

7.0/10

1.6

Years Exp

MIS Intermediate

7.0/10

1.6

Years Exp

Loan Origination Intermediate

7.0/10

1.6

Years Exp

Credit Risk Analytics Intermediate

7.0/10

1.6

Years Exp

UAT Intermediate

7.0/10

1.6

Years Exp

Requirement gathering Intermediate

7.0/10

1.6

Years Exp

Stakeholder Management Intermediate

7.0/10

1.6

Years Exp

Snowflake Intermediate

7.0/10

1.6

Years Exp

Pandas Intermediate

7.0/10

1.6

Years Exp

Python Intermediate

7.0/10

1.6

Years Exp

Jira Intermediate

6.5/10

1.6

Years Exp

Oracle Intermediate

6.5/10

1.6

Years Exp

Alteryx Intermediate

6.0/10

1.6

Years Exp

Work Experience

Data Analyst

Scotiabank

Jan 2025 - Present

Work across the full credit risk lifecycle — account origination, account performance, and collections/recovery — for the retail lending portfolio, turning raw multi-source banking data into KPIs, dashboards, and risk segments that risk, marketing, and collections teams act on daily. Source and consolidate loan application and customer data from internal and external systems (bureau data, macroeconomic data, internal behavioral data); design relational data models for Origination, Performance, Collection, and Recovery Master files feeding BAU and MIS reporting. Automate daily, weekly, and monthly reporting workflows using SQL and Python — streamlining data integration from multi-source files into analytical DataMarts and cutting manual reporting effort by ~30%. Write optimized SQL using joins, CTEs, window functions, stored procedures, and views to support enterprise-scale reporting; support UAT for new and updated reports before production release. Build loan acquisition and default-risk analysis using SQL against historical loan performance, financial statement, and credit bureau data, supporting credit portfolio managers' lending decisions. Convert raw credit/debit card merchant transaction data into monthly customer usage summaries to track spending behavior and portfolio trends over time. Design Power BI dashboards using DAX measures and Power Query transformations for account origination reporting — tracking loan applications received, approved, booked, and cancelled by volume and percentage — replacing manual Excel-based reporting with interactive KPI dashboards. Build customer risk segmentation (high / mid / low risk) by scoring outstanding balance, credit score variance, and delinquency bucket (30 to 180+ days past due), and hand off flagged high-risk accounts to the collections and recovery teams. Publish production reports on a daily, weekly, monthly, and quarterly cadence — monitor scheduled data pipelines, catch discrepancies before stakeholder distribution, and run root cause analysis (RCA) by tracing issues from source tables through Snowflake to the final Power BI output. Run daily stand-ups and a weekly ticket-discussion session with business stakeholders to gather reporting requirements and translate asks into technical specs.