Senior Consultant_ Reconciliation Design & Implementation

Novel Financial Solutions; Maharashtra; Hybrid; INR 1,200,000 - 1,800,000; Part time

Job summary

Novel Financial Solutions seeks an experienced Senior Consultant Reconciliation Design & Implementation to drive a loan-level reconciliation solution within the Finance Controllers / CPSO function. You will design, configure, test and stabilize processes across Finance, Technology and Operations.

The role requires hands-on expertise with TLM or similar platforms, strong matching logic, exception management and large-volume data analysis for a complex transformation.

Qualifications

• 10+ years of Banking/FS/Reconciliation experience.
• Hands-on experience with TLM / SmartStream TLM or equivalent reconciliation platforms.
• Experience designing and implementing reconciliation for new builds.
• Strong matching logic, tolerance rules and exception routing.
• SQL and Advanced Excel for high-volume data analysis.
• Experience with SIT, UAT, parallel testing and production implementation.
• Excellent documentation skills.
• Experience working with cross-functional stakeholders across Finance, Technology and Operations.

Responsibilities

• Analyse source and target data structures to translate business requirements into reconciliation specifications.
• Define and document reconciliation logic, matching rules, tolerance levels and break classification.
• Identify data quality issues, field-level mismatches and reference-data dependencies.
• Coordinate with Finance, Operations and Technology to resolve data/process gaps.
• Prepare functional requirements, process documentation and supporting artefacts.
• Support configuration and implementation of reconciliation using TLM or equivalent platforms.
• Configure data ingestion, matching rules, exception queues and workflow requirements.
• Coordinate with Technology on interfaces and data feeds; manage defects.
• Maintain configuration and implementation documentation with version control.
• Develop test strategies for SIT/UAT/production validation.
• Perform data validation between source and target systems and investigate breaks.
• Manage defect logs and coordinate resolution with Technology, Business and Operations.
• Support parallel runs and validation before production go-live.
• Define break classification, exception routing, ownership, ageing and escalation rules.
• Establish operating procedures for daily reconciliation and controls.
• Develop control documentation and evidence templates for audit.
• Support alignment with Finance Controls and governance.

Skills

Banking domain experience

Reconciliation platforms

SQL

Advanced Excel

Stakeholder management

Documentation skills

Data analysis

Cross-functional collaboration

Testing & validation

Attention to detail

Education

Bachelor's Degree

MBA / Finance qualification

PMP / Agile certification

Tools

TLM / SmartStream TLM

IRECS

Intellimatch

CORONA

SQL tooling

Job description

Role : Senior Consultant Reconciliation Design & Implementation

Location: Goregaon, Mumbai
Experience: 10 -15 Years
Function: Finance / Controllers / Reconciliation

Employment Type: Contract/ RTH

Job Summary

We are looking for an experienced Senior Consultant Reconciliation Design & Implementation to support a strategic Residential Loan Programme within the Finance Controllers / Controller Platform Solutions & Operations (CPSO) function.

The role will be responsible for designing and implementing a new loan-level reconciliation solution between source loan platforms and the target accounting platform. The candidate will work across Finance, Technology, Operations and Business teams to define reconciliation requirements, configure reconciliation rules, execute testing, establish exception management processes and support go-live and stabilization.

The ideal candidate should have strong hands-on experience with TLM or similar reconciliation platforms, reconciliation design, matching logic, exception management, finance/accounting processes and large-volume data analysis.

Key Responsibilities

Reconciliation Design & Requirements

• Analyse source and target data structures and translate business requirements into detailed reconciliation specifications.
• Define and document reconciliation logic, matching rules, tolerance levels and break classification.
• Identify data quality issues, field-level mismatches and reference-data dependencies.
• Work with Finance, Operations and Technology teams to agree requirements and resolve data/process gaps.
• Prepare functional requirements, process documentation and supporting design artefacts.

TLM / Reconciliation Implementation

• Support configuration and implementation of the reconciliation solution using TLM or equivalent reconciliation platforms.
• Configure and validate data ingestion, matching rules, exception queues and workflow requirements.
• Coordinate with Technology teams on interfaces, data feeds, file delivery and system defects.
• Maintain configuration and implementation documentation with appropriate version control.

Testing & Validation

• Develop test strategies, test scenarios, test cases and expected results for SIT, UAT and production validation.
• Perform data validation between source and target systems and investigate reconciliation breaks.
• Manage defect logs and coordinate issue resolution with Technology, Business and Operations teams.
• Support parallel runs and validation activities before production go-live.

Exception Management & Controls

• Define break categorisation, exception routing, ownership, ageing and escalation rules.
• Establish operating procedures for daily reconciliation and break investigation.
• Develop control documentation, evidence templates and process procedures to support audit and control requirements.
• Support alignment with existing Finance Controls and Exception Monitoring governance.

Programme & Stakeholder Management

• Manage reconciliation workstream activities, dependencies, risks and issues.
• Coordinate across Finance Controllers, Technology, Operations, Business Integration and other stakeholders.
• Prepare status reports and updates for senior management and programme governance forums.
• Drive open issues and dependencies through to resolution within agreed timelines.

Go-Live & Stabilization

• Support reconciliation parallel runs, cutover and production implementation.
• Monitor daily reconciliation results and support break analysis during stabilization.
• Prepare BAU handover documentation, procedures, configuration documents and known-issue logs.
• Support knowledge transfer to the operations team.

Required Skills

• 10+ years of experience in Banking, Financial Services, Finance, Controllership or Reconciliation.
• Strong hands-on experience with TLM / SmartStream TLM or equivalent reconciliation platforms.
• Proven experience in reconciliation design and implementation, preferably involving a new build.
• Strong understanding of matching logic, tolerance rules, break management and exception routing.
• Experience with reconciliation configuration, workflows and exception queues.
• Strong SQL and Advanced Excel skills for high-volume data analysis.
• Good understanding of financial products, accounting flows and General Ledger processes.
• Experience in data mapping, data quality analysis and reference-data management.
• Experience with SIT, UAT, parallel testing and production implementation.
• Strong documentation skills, including requirements, procedures, controls and audit evidence.
• Experience working with cross-functional stakeholders across Finance, Technology and Operations.

Preferred Experience

• Exposure to Loans / Mortgage / Residential Lending products.
• Experience with Finance platform migration or ledger implementation.
• Experience with TLM, IRECS, Intellimatch, CORONA or similar reconciliation platforms.
• Experience in large-scale banking transformation or reconciliation programmes.
• Exposure to Agile / project delivery methodologies.
• PMP, Agile or other project delivery certification is an advantage.

Qualifications

Essential: Bachelor's Degree

Preferred: Postgraduate qualification / MBA / Finance qualification / PMP / Agile certification

Key Competencies

• Strong control mindset
• Analytical and problem-solving ability
• Strong stakeholder management
• Excellent written and verbal communication
• Ability to work independently in a complex, multi-location environment
• Strong ownership and ability to drive issues to closure
• Structured approach to documentation and process management