Post Job Free
Sign in

Finance Data Analyst - Loan Recovery Analytics

Location:
New Delhi, Delhi, India
Posted:
November 02, 2026

Contact this candidate

Resume:

Rinki Kumari Pramanik

Data Analyst *+ years Finance

859-***-**** ****************@*****.*** Noida

SUMMARY

Data Analyst with 6+ years of experience in the financial services and lending domain, specializing in loan recovery analytics, EMI repayment monitoring, delinquency tracking, and MIS reporting. Proficient in SQL Server, Python

(Pandas), Power BI and Advanced Excel for data extraction, cleaning, reconciliation, trend analysis, and operational reporting. Experienced in monitoring NPA and overdue accounts, analyzing collection performance, maintaining data accuracy, and delivering actionable insights to support business operations and management decision-making. SKILLS

• Languages: SQL, SQL Server, Python, Pandas

• Cloud: Databricks

• Data Visualization: Power BI, Matplotlib, Seaborn

• Advanced Excel: Pivot Tables, VLOOKUP, INDEX-MATCH, data validation, MIS reporting

• Financial Operations: Loan recovery, EMI repayment, overdue and delinquency analysis

• Credit & Risk: NPA tracking, portfolio analysis, dispute management

• Data Quality: Data cleaning, reconciliation, validation, duplicate and missing-record checks PROFESSIONAL EXPERIENCE

DIGITIDE SOLUTIONS PVT. LTD. Jan 2024 – Jul 2026

Data Analyst Finance & Loan Operations

• Wrote and optimized SQL Server queries to extract, filter, join, and validate large volumes of loan, EMI repayment, and delinquency data for reporting and analysis.

• Extracted data from cloud platforms (Databricks) and processed it using Python and Pandas for cleaning, reconciliation, and identification of missing, duplicate, and inconsistent records.

• Designed and maintained interactive Power BI dashboards tracking collection performance, NPA and overdue accounts, and recovery metrics for management review.

• Analyzed repayment trends and high-priority delinquent cases to deliver actionable insights that supported collection strategy and decision-making.

TATA CAPITAL LIMITED Dec 2019 – Jan 2024

MIS Analyst

• Prepared and maintained daily MIS reports and operational trackers using SQL and Excel, including Pivot Tables, VLOOKUP, INDEX-MATCH, and data validation.

• Monitored NPA and overdue accounts and recovery metrics, providing regular management reports for collection performance and high-priority case tracking.

• Used SQL queries to extract, filter, and validate customer and loan data, and performed data cleaning and reconciliation to identify missing, duplicate, and inconsistent records in operational datasets. WNS GLOBAL SERVICES PVT. LTD. Jun 2018 – Nov 2019

Sr. Associate – Credit Operations

• Prepared and maintained MIS reports using customer, credit, and operational data to support daily business operations and management reporting.

• Analyzed customer and credit-related data to identify trends, exceptions, and discrepancies, supporting risk assessment and operational decision-making.

LUMINOUS WATER TECHNOLOGY PVT. LTD. Jan 2017 – Jun 2018 Associate

• Analyzed customer and business data to generate insights for business operations.

• Prepared and organized data for business use and decision-making. EDUCATION

Durgapur Institute of Advanced Technology and Management (DIATM) May 2014 B. Tech (Information Technology)



Contact this candidate