Managing Reconciliation and Payment Automation Platform. Development / Production support and managing projects related to Reconciliation, break investigation and charge collection platform. The role ensures optimal performance, match quality, and user experience by leveraging the Reconciliations platform (TLM, Cypher), aiming to reduce operational risk, improve STP rates, and support exception management.
- Works within a financial services technology environment, adhering to internal IT governance and regulatory frameworks.
- Interfaces with internal stakeholders including Operations, Compliance, Risk, and IT Infrastructure teams.
- Coordinates with external vendors such as SmartStream for TLM-related issues and upgrades.
- Operates within defined SLAs, change management policies, and security protocols.
- Diagnoses and resolves complex reconciliation issues such as data mismatches caused by incorrect data mappings, late file arrivals, inconsistent reference data, or failed data transformations in upstream systems.
- Performs detailed analysis using TLMs
Match Rule Management
, Data Viewer
, and Exception Management
modules to trace the lifecycle of transactions and pinpoint reconciliation breaks. - Investigates broken workflows involving issues with
Automatch configuration
, feed processing errors
, and static data misalignment
between TLM and external systems (e.g., core banking, custody, or trading platforms). - Uses SQL queries and scripting tools to extract, validate, and compare data across source systems and TLM database tables for diagnostic and audit purposes.
- Analyzes recurring exceptions and breaks to identify patterns and systemic causes such as incorrect reconciliation logic, unconfigured matching rules, or missing enrichment data, and recommends process or configuration enhancements.
- Troubleshoots performance bottlenecks by examining
server logs
, job queues
, database performance metrics
, and TLM Scheduler
configuration to identify inefficiencies or resource constraints. - Collaborates with SmartStream support teams and internal infrastructure teams to resolve escalated issues including system downtime, database locking, or integration failures with upstream/downstream systems via APIs, SFTP, or message queues.
- Conducts impact assessments for problem resolutions and ensures root cause fixes are tested, documented, and implemented via formal change control processes.
-
Educational Background:
Bachelor s degree in Computer Science, Information Technology, Finance, or a related discipline. Advanced certifications in Financial Technology or IT Service Management (e.g., ITIL) are advantageous. -
Industry Experience:
Minimum 12 15 years of experience in financial services technology with a strong focus on transaction lifecycle management, reconciliations, and operational risk mitigation in banking, asset management, or custodial environments.
Technical Expertise:
- Deep knowledge of
SmartStream TLM Reconciliations Premium
, including configuration, match rule design, exception management, workflow automation, and user interface customization. - Proficient in
SQL querying
and data extraction from relational databases (e.g., Oracle, MS SQL Server) for troubleshooting, reporting, and data validation purposes. - Familiarity with
ETL (Extract, Transform, Load)
processes, data feeds (flat files, XML, JSON), and integration technologies such as APIs, message queues, and SFTP workflows. - Experience with
scripting languages
(e.g., Python, Shell scripting) to automate routine tasks, monitor batch jobs, and support platform maintenance activities. - Understanding of core financial instruments (cash, equities, fixed income, derivatives) and their settlement lifecycle, trade processing flows, and reconciliation challenges.
- Knowledge of system monitoring tools, job schedulers, and performance tuning techniques relevant to middleware and database layers supporting TLM platforms.
Process and Methodology Skills:
- Expertise in applying
ITIL best practices
for incident, problem, and change management within a regulated financial environment. - Strong capability in
root cause analysis
, process re-engineering, and continuous improvement to optimize reconciliation workflows and reduce operational risk.
Soft Skills:
- Excellent analytical thinking and problem-solving skills to translate business requirements into technical solutions.
- Strong communication skills, with the ability to articulate technical concepts to non-technical stakeholders and lead cross-functional collaboration.
- Proven ability to manage competing priorities under pressure, delivering results within tight SLAs and compliance deadlines.
Tools & Platforms:
- Hands-on experience with ticketing systems (e.g., ServiceNow, JIRA) for incident and change tracking.
Familiarity with version control systems and documentation tools for maintaining system configurations and operational procedures
-
Platform Management and Optimization:
Ensure the stable, secure, and efficient operation of the TLM Reconciliations Premium platform, including overseeing system availability, job scheduling, exception management, and data feed processing. Continuously monitor system performance and proactively identify and implement enhancements to improve match rates, processing speed, and user experience. -
Reconciliation Quality and Exception Handling:
Drive improvements in reconciliation accuracy by fine-tuning match rules, investigating and resolving transaction breaks, and reducing the volume and complexity of exceptions. Lead root cause analysis initiatives to address recurring reconciliation failures and implement permanent fixes through system configuration or upstream process changes.
-
Stakeholder Collaboration and Support:
Act as the primary liaison between business users (Operations, Finance, Risk) and IT teams, ensuring timely resolution of issues, clear communication of system capabilities, and alignment of platform enhancements with business needs. Provide expert guidance and training to end-users and support teams on best practices for using TLM Reconciliations Premium. -
Change and Release Management:
Oversee the planning, testing, and deployment of system changes, patches, and upgrades in line with IT governance and regulatory standards. Coordinate with vendors, internal change management teams, and QA to minimize disruption and ensure compliance with service level agreements (SLAs). -
Process Improvement and Automation:
Identify opportunities to streamline reconciliation workflows through automation, data enrichment, and integration with upstream and downstream systems. Champion continuous improvement initiatives that reduce manual intervention, enhance straight-through processing (STP), and lower operational risk and costs. -
Compliance and Audit Readiness:
Ensure all reconciliation processes and system changes comply with internal controls, regulatory requirements, and audit standards. Prepare documentation and reports for audit reviews, and implement remediation actions as necessary. -
Team Leadership and Knowledge Management:
Provide leadership, mentoring, and knowledge sharing within the TLM support team. Maintain comprehensive documentation including SOPs, user guides, and technical manuals to support operational continuity and staff development.
