Proactive and results-oriented professional with extensive experience in loan operations and credit management at Caspian Impact Investments and Sub-K IMPACT Solutions. Excelled in leveraging MS Office and Power BI to enhance reporting accuracy and efficiency. Demonstrated leadership by effectively managing teams and fostering strong relationships, achieving significant operational improvements.
10, 05/2021 to 10/2024, Analyst - Loan Operations, Caspian Impact Investments Private Limited, Handling projects Indifi (TL), FT cash (TL), EPAY (SCF) and DVARA KGFS (TL), KYC Document verification for Proprietorship, Partnership, LLP and PVT, Daily Disbursements for Term loan (TL) and Working capital loan (WCL), Maintain manual tracker for disbursement and Collections in excel and crosschecking with partner LMS, Repayment schedule Verification (System report vs Excel), Collection credit recon in Pool account (Bank statement reconciliation), Service fee, loan processing fee (LPF), Document charges and Insurance Charges reconciliation and Payment processing, Over Due Report dashboard to the party, Maintain Write off loans data (Technical/compromised), Collection mapping and tracker against Write off loans, RBI Weekly report information to RBI (Disbursements, Collection, POS and SMA status), CIBIL reporting (Consumer report in CIBIL, Equifax, Experian and CRIF MARK), Legal Notices to party (Event of Default Notice, Loan Recall Notice and Section 138 Cheque bounce notice), Issuing to party NDC (No Due certificate) NOC (No objection certificate) and COR (Certificate of Recognition), Management reports in excel dashboard and Power BI, Providing data at the time of data migration, Providing and clarifying data to internal and external auditor, 09/2014 to 04/2021, Senior Executive - Credit Operations Accounts, Sub-K IMPACT Solutions Limited, Handling 5 team members and tracking their performance, Handling RBL FSM nine states (Manual and Digital) recovery, Manual and Digital Cash book reconciliation of 164 branches on daily basis, Transferring Field collection deposit to Collection pool account (9 banks 160 Accounts), Handling cash management and supervising the team of finance and operations, Preparing daily collection report (collected by Field), Reporting daily collection details to RBL NOC Bank, Updated Excel Sheets are imported into the Ms Access for further validation, Preparing Demand vs collection MIS reports on daily basis, Prepared the Day/Branch wise collection report to Field and RBL team on daily basis, Incentive calculation report staff performance of PAN India employees, Passing collection related entries in tally ERP 9 (Receipts, Payments and contra entries), Monthly BRS and portfolio entries, Creating and updating Agent’s productivity report in Dashboard and Share MIS Dashboard to the seniors, Handling multiple reports, working with formula, pivot tables & pivot charts, Preparing the PPT slides for giving the information of the field performance area wise, Updating Data Tracker and MIS Dashboard on daily and weekly basis, Maintaining the accuracy data (daily, weekly and monthly), Future forecasting for data analysis and data providing to Management, Daily basis Reports analysis and publishing the report to stakeholders, Month end Dashboard Reports & Presentation for Management review meeting, Master Data Maintaining of Different Bank Partner like RBL Bank, RCFL & AXIS Bank, Handling the huge data working with MS Access, Responsible for ensuring the collection of the right data that supports business objectives, Lead in introducing concepts and ideas that generate the right kinds of analytics and trends