Data Quality Financial Services

Mr. RATNESH KUMAR PUROHIT

Mob: +91-992******* Email: **************@*****.***

LinkedIn: https://www.linkedin.com/in/ratnesh-purohit-0a601b19/

Current Location – Noida/Delhi-NCR

Executive Summary

IT Professional with 19 years of progressive experience specializing in Mainframe technologies and FICO Debt Manager applications within the Banking and Financial Services industry. Expertise in Credit Cards, Collections, and Recoveries with strong international exposure, including 5 years at onshore with Lloyds Banking Group in London, United Kingdom. Proven track record in Service Management, Data Quality, Incident/Problem/Change Management, and Application Maintenance. Adept at leading cross-functional teams, managing large-scale service operations and delivering high-impact solutions across global client engagements.

Core Competencies

Mainframe Technologies

COBOL, JCL, VSAM, DB2, CICS, Connect Direct, Endevor Changeman, Fileaid, TWS, OPCA, Selcopy, Rexx, Easytrive

FICO Debt Manager

Application versions 4/6.2/9/11

ETL Tools

Kettle, Pentaho Data Integration

Databases

MS SQL Server, Oracle, DB2

DevOps & Agile Tools

JIRA, Confluence, GitHub, Jenkins, Nexus, Urban Code Deployment, Agile, Kanban

Data Quality Tools

PowerBI, Ataccama

Domain Expertise

Banking and Financial Services, Credit Cards, Collection & Recoveries

Production Support

Incident, Problem and Change Management, Service Improvements

Additional Skills

Hands On in Fiserv’s VisionPLUS applications, Google Certified Associate Cloud Engineer

Professional Experience

Tata Consultancy Services Limited – Assistant Consultant

Jul 2016 – Present Currently in Noida (India) and previously at London (United Kingdom)

•Working as SME for Mainframes and Debt Manager Applications, managing team of 10.

•Current Responsibilities include incident/problem/change management, on call support, batch monitoring and fixing bugs, deploying service Improvements into Live.

•Led Data Quality initiatives for Lloyds Banking Group, reducing ~900k inconsistencies.

•Designed automated dashboards using ataccama to monitor Critical Data Elements (CDEs) data quality.

•Designed completely new batch flow diagram for Debt Manager Application which includes Night batch, Intraday and weekends batch jobs and dependencies across the products.

•Designed new dashboard in PowerBI for team to track batch milestones and generated automated trigger for business on batch progress updates.

Capgemini India Pvt Ltd – Consultant

Dec 2012 – Jul 2016 Pune, India

•Worked as Technical Lead for Mainframe projects, focusing on data remediation and Cobol-DB2 programming.

•Directed offshore delivery, including technical reviews, implementation, and incident management.

•Coordinated with onshore SMEs for requirement analysis and production fixes.

Polaris Financial Technology – Consultant

Jul 2010 – Dec 2012 Pune, India

• Debt Manager Analyst for Barclays, supporting migration from CACS to Debt Manager.

• Designed and developed inbound/outbound interfaces, COBOL-DB2 programs, and JCL scheduling.

• Supported SIT, UAT, and production deployments.

Cognizant Technology Solutions – Associate Projects

Nov 2009 – Jul 2010 Pune, India

•VisionPLUS System Analyst in Cards & ATM team.

•Prepared technical specs, coded enhancements, and performed defect management using SM7 tool.

Capgemini India Pvt Ltd – Associate Consultant

Apr 2006 – Nov 2009 Pune, India

•VisionPLUS Developer for CMS and FAS modules.

•Delivered Discover Card debit functionality improvements and automated credit limit updates.

• Developed BMS Maps, COBOL programs, and reports for new functionalities.

Key Achievements & Awards

•Certification in Google Cloud Associate Cloud Engineer.

•Certificate of Completion from IIT Kharagpur on “Hands on Approach to Artificial Intelligence and real world applications”.

•Appreciation from Lloyds Bank Director for excellent delivery of Data Quality for fixing 900k discrepancies across the debt manager application.

•Outstanding Performance Award from client HSBC.

•Appreciation Trophy from Client Barclays for Debt Manager Western Europe Release.

•Recognized for delivering zero-defect enhancements by Client First Data.

•Multiple awards and appreciations from TCS for excellent Delivery.

Education

•Completed Master of Computer Application (MCA) from Rajiv Gandhi Technical University, Bhopal in 2005 with an aggregate of 73.76%.

•Completed Bachelor of Science (B.Sc.) in Mathematics from Bundelkhand University, Jhansi in 2002 with an aggregate of 66.37%.

Personal Details

Marital Status: Married Languages: English, Hindi Passport Valid up to 18/06/2027

Contact this candidate