Back to Developers
Priyambada Rout

Priyambada Rout

Data Analyst

Bhubaneswar, INDIA 7+ yrs exp 80 · Excellent

About

No bio added yet

Skills & Expertise (31)

SQL Advanced
8.1/10
4
Years Exp
Python Advanced
8.1/10
4
Years Exp
Power BI Advanced
8.0/10
4
Years Exp
SAS Advanced
7.5/10
4
Years Exp
Data Modelling Advanced
7.5/10
4
Years Exp
Data Cleaning Advanced
7.5/10
4
Years Exp
Reporting Advanced
7.5/10
4
Years Exp
Data Preparation Advanced
7.5/10
4
Years Exp
Data Extraction Advanced
7.5/10
4
Years Exp
DAX Intermediate
7.0/10
4
Years Exp
Report Automation Variance Analysis Drill-through KPI Dashboards Pandas AI-Assisted Analysis Dashboards Charts Power Query PivotTables Advanced Formulas CTEs Reconciliation NumPy Joins PROC SQL Base SAS Data Validation Stored Procedures Window Functions Subqueries

Work Experience

Data Analyst – Banking Credit Risk Analytics

D-BALK Protech Pvt. Ltd.

Jan 2019 - Present

Prepared daily, weekly and monthly loan portfolio reports covering disbursement, outstanding balance, portfolio growth, repayment performance and delinquency. Monitored DPD buckets, roll rates, vintage performance, cure rates, slippages, write-offs, settlements, gross NPA and net NPA. Developed portfolio dashboards by product, branch, geography, customer segment, bureau score and risk category. Tracked collection efficiency, recovery rate, overdue balance, promise-to-pay, contactability, collector productivity and agency performance. Prepared IFRS 9 reports covering Stage 1, Stage 2 and Stage 3, SICR, stage migration, PD, LGD, EAD, 12-month ECL and lifetime ECL. Conducted ECL movement, provision variance and account-level reconciliation for finance, risk, audit and management teams. Automated recurring MIS reports and data-validation processes using SQL, SAS and Python. Built interactive Power BI dashboards for portfolio risk, collections, recovery and IFRS 9 reporting.

Data Analyst – Retail Supply Chain Analytics

Retail/E-commerce/FMCG Company

Present - Present

Prepared supply chain reports covering inventory, procurement, warehouses, logistics, order fulfilment and store operations. Analysed stock availability, inventory ageing, slow-moving products, excess inventory, stock-outs and replenishment requirements. Monitored supplier lead time, delivery adherence, rejection rate, purchase-order status and vendor fill rate. Tracked warehouse productivity, order cycle time, fulfilment rate, OTIF, shipment delays, transportation cost and returns.

Education

B.Sc. (Mathematics) - Utkal University

- 2018 · Afghanistan

Intermediate (Science) - CHSE Odisha

- 2015 · Afghanistan

SSC - BSE Odisha

- 2013 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 0/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceSep 2026