About
Data Analyst and MIS Professional with 1.5+ years of banking experience in collection portfolio reporting, process automation, and data reconciliation. Proficient in Advanced Excel, VBA, SQL, Power Query, and Power BI. Proven track record of automating repetitive reporting pipelines, ensuring 100% data integrity, and building actionable dashboards for management decisions.
Skills & Expertise (15)
Work Experience
MIS Executive (Collection & Portfolio Operations)
AU Small Finance Bank
Feb 2025 - Jun 2026
Managed daily collection portfolio MIS and maintained master datasets, tracking loan delinquency and DPD movements across business divisions. Engineered custom VBA macros to automate multi-sheet compilation into master files, slashing daily report turnaround time by 30%. Instituted automated validation checks against core CBS ledger totals, reducing reporting discrepancies by 25%. Monitored team real-time queue allocations, operational productivity, and schedule adherence to improve workforce efficiency. Collaborated with cross-functional teams to modernize legacy reporting templates and fulfill urgent ad-hoc business data requests.
Education
B.Tech in Electrical Engineering - Rajasthan Technical University
2016 - 2020 ยท Afghanistan
Certifications
Certificate in Data Analytics & MIS Training
SLA Consultants India ยท 2024
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Depends on Offer
Skills (15)
Click a skill to find developers with the same skill