Executive - Central Operations - Thane

Role Purpose

The candidate will be responsible for end-to-end credit bureau reporting and data quality management for CIBIL, CRIF, Equifax and Experian. The role involves preparation, validation, submission, reconciliation and correction of bureau data, ensuring accurate and timely reporting in line with RBI and bureau guidelines.

Key Responsibilities

1. Credit Bureau Reporting

• Manage periodic credit bureau reporting for CIBIL, CRIF, Equifax and Experian.
• Prepare and validate bureau reporting files as per the respective bureau's reporting format and guidelines.
• Ensure timely submission of bureau files within defined TAT.
• Handle weekly/monthly reporting cycles and revised/re-submission files.
• Coordinate with internal teams for data availability and reporting requirements.

2. Data Validation & Quality Checks

• Perform pre-upload validation of bureau files and identify data discrepancies.
• Validate key fields such as:
• Loan Account Number
• Customer ID
• PAN
• Mobile Number
• Date of Birth
• Address and PIN Code
• Ownership Indicator
• Account Status
• Asset Classification
• DPD
• Overdue Amount
• Current Balance
• Write-off / Settlement details
• Date of Closure
• Reconcile bureau data with LOS/Core System/MIS before submission.
• Identify missing, incorrect or inconsistent records and coordinate for rectification.

3. Bureau Error & Rejection Management

• Download and analyze bureau validation/error reports.
• Identify rejection reasons and coordinate with IT, Business, Credit and Operations teams for resolution.
• Prepare correction files and re-upload rejected records.
• Maintain rejection/error trackers and monitor closure of observations.
• Ensure recurring errors are identified and permanently resolved.

4. Regulatory & Compliance

• Ensure bureau reporting is aligned with RBI guidelines, Credit Information Companies requirements and applicable reporting standards.
• Monitor changes in bureau reporting formats, file structures, reporting frequency and regulatory requirements.
• Support internal, compliance and audit requirements related to bureau reporting.
• Maintain proper records and evidence of bureau submissions and corrections.

5. Reconciliation & MIS

• Perform reconciliation between:
• System/LOS data
• Bureau reporting files
• Bureau acceptance/rejection reports
• Loan closure data
• DPD/overdue data
• Prepare periodic MIS covering:
• Total records reported
• Accepted records
• Rejected records
• Pending records
• Corrected records
• Resubmitted records
• Bureau-wise status
• Highlight major data quality issues to management.

6. Coordination

• Coordinate with IT/Application teams for system-generated bureau files and data issues.
• Coordinate with Finance, Credit, Collections, Branches and Operations for data corrections.
• Liaise with bureau support teams for reporting-related issues.
• Coordinate with vendors/technology partners wherever bureau reporting is outsourced or system-driven.

Technical Skills

Mandatory / Preferred:

• Strong knowledge of MS Excel.
• Good knowledge of:
• VLOOKUP/XLOOKUP
• Pivot Tables
• COUNTIF/SUMIF
• IF formulas
• Data filtering and reconciliation
• Duplicate/missing data identification
• Ability to handle large datasets and CSV/TXT files.
• Knowledge of bureau reporting formats, validation rules and error codes will be preferred.
• Experience with LOS/Core Lending systems is an advantage.