THIRUMURUGAN RAJASEKARAN
Jacksonville
Summary
Regulatory, Compliance,Financial Reporting and Data analytics professional with 14 years experience seeking senior/lead position in the field of banking and finance.
Skilled business data analyst with experience in financial modelling, acquiring data, integrating, organizing, cleaning, validating and making sense of it by applying statistical techniques. Experienced at GRC, AML KYC, regulatory reporting, financial analysis ,BASEL & compliance in banking and finance. Expertise in identifying patterns in data to solve real-world problems. Employs tools and business intelligence software including Ab Inito, IBM Datastage, SAS EG, Cognos, Tableau and Power-BI to analyze, model and visualize data, to build a coherent story to communicate organizational insights to stakeholders. Excels at writing and editing technical materials designed for varied audiences. Proficient with SQL and extensive knowledge of Python.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Business Data Analyst
Tata Consultancy Services
Jacksonville, FL
08.2023 - Current
- Company Overview: Citibank NA
- Designing solutions for Credit Card related issues reported as part of the GRC Consent Order - DOM for the regulatory reports FR Y 14M (Capital Assessments and Stress Testing) and FR Y- 9C (Consolidated Financial Statements for Holding Companies) regulatory reports post FRB, OCC and FDIC regulatory audits
- Focus areas includes BASEL, customer statements, payments, loss mitigation and settlements, BASEL, Balances, rewards, Acquisition etc
- Trace the mapping logic and ETL transformations using AbInitio, SAS etc to understand the data mapping in multiple upstream and downstream systems end to end
- Perform data profiling, data validation and end to end analysis using complex SQLs by joining multiple tables, databases to identify trends, patterns, and insights
- Present the observations, RCA, solutions along with simulations to all stakeholders
- Create visualizations – dashboards and reports using Cognos /power BI to display improvements and trends
- Partnering with the risk and treasury report owners, risk/finance business and data owners to provide strategic advice and guidance and ensure the end to end solution is as per regulatory compliance, ALM principles, liquidity risk management, and banking regulations
- Collaborate with cross-functional teams in creating JIRAs, mapping documents, BRDs, FRDs, RTMs etc
- Ensure data quality assurance by reviewing and approving the SIT,UAT test cases, defects, validation results and track the implementation process
- Developed comprehensive financial models to forecast revenue and expenses, resulting in a $500M savings in financial planning accuracy by improved data quality, reduced the operational losses in 2023 and 2024
- Leading a team of 4 (2 offshore and 2 onshore)
- Citibank NA
Business Analyst
Tata Consultancy Services
Jacksonville, FL
06.2019 - 08.2023
- Company Overview: Citibank NA
- Partnered with data governance and CDO (Chief Data Officers) team to trace end to end lineage, build mapping for the audit attributes, extract the data/screenshots for the audit samples, document, create business requirements, build cover letters for the Audit Report
- Contributed in multiple audits – for FRB,OCC,FDIC regulators, 3rd party audits like EY Audit, Internal Audits and Citibank’s BAU audit cycles
- Worked across multiple regulatory - risk and finance/treasury reports like FR Y 14M (Capital Assessments and Stress Testing) and FR Y- 9C (Consolidated Financial Statements for Holding Companies), FR 2052a (Complex Institution Liquidity Monitoring Report), FRY 14Q (Capital Assessments and Stress Testing), FRY 15(System Risk Report), FFIEC 031/041/051 (Call Report), FFIEC 009/002, BASEL and management reports
- Used Abinitio and SAS to trace the mapping logic in multiple upstream and downstream systems
- Use SQL in extracting the sample level data and screenshots for the Audit Samples
- Build the end to end data mapping and lineage at product level, report level, attribute level
- Upload the mapping and lineage documents in Collibra and confluence sharepoints
- Build cover letters for the Auditors, as auditing support documents
- Traced the data across multiple banking products – Credit Cards, Deposits, Mortgages, Personal Loans, Corporate Loans, etc
- Citibank NA
AML KYC Data Staging Lead
Tata Consultancy Services
Jacksonville, FL
01.2017 - 06.2019
- Company Overview: Citibank NA
- Designed, built and managed the AML KYC Data staging Team of 12 (3 onshore and 9 offshore – multiple vendors) for the Citibank’s AML KYC Compliance Program
- Partnered with the AML business teams to build test cases related for the AML KYC compliance requirements for KYC screening, transaction monitoring, financial crimes, etc
- Managed the ‘Pre-release test data creation process’, ‘Data Conditioning process’, ETL, ‘Data Lineage validation’, Reporting and delivery of all business test case scenarios/requests and delivered data for DIT, SIT and UAT validation phases
- Automated the Data Conditioning process in UFT, Data Lineage validation in Teradata, Abinitio, Reporting in Cognos
- Provided proposals and supported SOW related activities during the tenure
- Citibank NA
Quality Assurance Tester & Lead
Tata Consultancy Services
Jacksonville, FL
12.2010 - 01.2017
- Company Overview: Citibank NA
- Started as a functional tester of the Lending/Payments/Cards Customer Service web-application (Sawgrass)
- Moved to the Account Receivables testing team
- Went on to lead the Lending/Payments/Cards testing team of 26 resources, across core banking system applications for credit cards: Acquisition, Account Receivables, statements, Payments (Fintech- swift/ACH), Authorizations, Letters, Plastics, Rewards, Loss Mitigation, PEGA FWS etc
- Worked as a tester and grew up to oversee the SIT deliverables in waterfall methodologies for each of the cards system
- Used ALM, UFT, PEGA, SQL, IVR, mainframe, etc as part the various quality assurance processes
- Citibank NA
Education
Bachelor of Technology - Information Technology
Pondicherry University
01.2010
Skills
- Banking
- Lending
- Payments
- Cards
- Mortgage
- Personal Loans
- Deposits
- Regulatory Reporting
- Risk & Finance
- FRY 14M
- FRY 9C
- FR2052a
- FRY 14Q
- FRY 15
- FFIEC 009
- FFIEC 031
- Consent Order projects
- Audits
- Federal Reserve Board
- EY
- Internal Audits
- Anti-Money Laundering
- AML
- Know Your Customer
- KYC
- Agile
- Waterfall
- SQL
- Python
- Ab Initio
- Data Stage
- SAS EG
- Alteryx
- Generative AI
- Cognos
- Google Analytics
- Power-BI
- Tableau
- MS Access
- Advanced Excel
- Word
Certification
- IBM Certified Data Analyst
- Collibra Certified Solution Architect
- PMI_PMP
Credly
https://www.credly.com/users/thirumurugan-rajasekaran.117edbfc
Technical And Analytical Skills
- SQL
- Python
- Ab Initio
- Data Stage
- SAS EG
- Alteryx (Generative AI)
- Cognos
- Google Analytics
- Power-BI
- Tableau
- MS Access
- Advanced Excel
- Word
Timeline
Business Data Analyst
Tata Consultancy Services
08.2023 - Current
Business Analyst
Tata Consultancy Services
06.2019 - 08.2023
AML KYC Data Staging Lead
Tata Consultancy Services
01.2017 - 06.2019
Quality Assurance Tester & Lead
Tata Consultancy Services
12.2010 - 01.2017
Bachelor of Technology - Information Technology
Pondicherry University