Summary
Overview
Work History
Education
Skills
Languages
Accomplishments
Personal Information
Summary
Timeline
Generic
C.A Kaushik

C.A Kaushik

Hyderabad

Summary

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.

Overview

10
10
years of professional experience

Work History

Analyst- Loan Operations

Caspian Impact Investements Private Limited
Hyderabad
05.2021 - 10.2024
  • 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 a manual tracker for disbursement and collections in Excel, and crosscheck with partner LMS.
  • Repayment schedule verification (System report vs Excel).
  • Collection credit reconciliation in Pool account (Bank statement reconciliation)
  • Service fee, loan processing fee (LPF), document charges, and insurance charges reconciliation and payment processing.
  • Overdue 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 PI.
  • Providing data at the time of data migration.
  • Providing and clarifying data to internal and external auditors.

Senior Executive- Credit Operations Accounts

Sub-K IMPACT Solutions Limited
09.2014 - 04.2021
  • Handling 5 team members and tracking their performance as and when
  • 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, where further Validation will be done using the Ms Access Macro’s as per filed name mentioned in the Xls file
  • 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 entry’s)
  • 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, and various other excel sheet components for accurate data
  • 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 Deferent 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 that allow for optimization and efficiency throughout the organization
  • To support the channel by assisting them with timely reverts on their MIS related queries

Education

B.Com -

Osmania University, G. Ram Reddy Centre for Distance Education

CEC -

Goutham Junior College

SSC -

New little Lilly High School

Skills

  • MS Office (Excel, Advanced Excel)
  • Tally ERP 9
  • SQL Server Management Studio 2018
  • Power BI Desktop version
  • AI in Excel dashboards
  • Initiative and being proactive
  • Planning and organizing
  • Relationship Building
  • Teamwork

Languages

  • Tamil
  • Hindi
  • Telugu
  • English

Accomplishments

  • 3rd Promotions FY 23-24 (Analyst)
  • 2nd Promotions FY 19-20 (Sr Executive)
  • 1st Promotions FY 16-17 (Executive)

Personal Information

  • Date of Birth: 06/26/93
  • Nationality: Indian
  • Marital Status: Married

Summary

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

Timeline

Analyst- Loan Operations

Caspian Impact Investements Private Limited
05.2021 - 10.2024

Senior Executive- Credit Operations Accounts

Sub-K IMPACT Solutions Limited
09.2014 - 04.2021

B.Com -

Osmania University, G. Ram Reddy Centre for Distance Education

CEC -

Goutham Junior College

SSC -

New little Lilly High School
C.A Kaushik