Back to Developers
mahendran S

mahendran S

Data Analyst

Chennai, Tamil Nadu 14+ yrs exp 90 · Outstanding

About

Data Analyst and Banking professional with 14+ years of experience in banking operations, business analysis, UAT, reporting, data validation, and financial services. Hands-on experience with SQL, Python, Excel, Power BI, MySQL, Pandas, NumPy, and machine learning, backed by a Master's program in Data Science (IIT-M GUVI). Skilled in data extraction, cleaning, transformation, exploratory data analysis, MIS reporting, dashboard development, reconciliation, requirements gathering, UAT testing, defect analysis, and business reporting. Strong banking domain knowledge across CASA, KYC, deposits, payments, NEFT, RTGS, IMPS, UPI, cheque clearing, account servicing, TDS, and regulatory processes. Experienced in collaborating with business and technology teams to convert requirements into accurate, actionable analytical and data science solutions.

Skills & Expertise (46)

Python Expert
9.0/10
14
Years Exp
SQL Expert
9.0/10
14
Years Exp
Pandas Advanced
8.5/10
10
Years Exp
Power BI Advanced
8.5/10
10
Years Exp
Data Cleaning Advanced
8.5/10
10
Years Exp
NumPy Advanced
8.0/10
10
Years Exp
Advanced Excel Advanced
8.0/10
14
Years Exp
Data Validation Advanced
8.0/10
10
Years Exp
Statistical Analysis Advanced
8.0/10
10
Years Exp
scikit-learn Advanced
7.5/10
5
Years Exp
Jira Advanced
7.0/10
5
Years Exp
Keras Advanced
7.0/10
5
Years Exp
TensorFlow Advanced
7.0/10
5
Years Exp
IMPS UPI Reconciliation RTGS NEFT Deposits KYC TDS CASA Digital Banking GitHub Git Google Colab Jupyter Notebook Defect Tracking Regulatory Compliance NLP Matplotlib Seaborn MySql SQLite EDA Trend Analysis Feature Engineering Model Evaluation Requirement Analysis Predictive Analytics MIS Reporting Pivot Tables Lookups Streamlit UAT Functional Testing

Work Experience

Deputy Manager

Equitas Small Finance Bank

Apr 2025 - Present

Analyze banking and operational data using SQL, Python, Excel, and Power BI to identify trends, exceptions, and actionable business insights. Perform data extraction, cleaning, transformation, validation, and reconciliation to ensure accuracy of business reports. Develop and maintain Power BI dashboards, MIS reports, and analytical reports for business and operational monitoring. Gather business requirements from stakeholders and translate them into reporting and analytical solutions. Perform data validation and functional testing for banking applications, reports, and system enhancements. Collaborate with business, technology, and vendor teams throughout requirements, testing, implementation, and issue resolution. Develop proof-of-concepts (PoCs) to validate reporting and analytical approaches. Support retail banking processes including customer onboarding, KYC, account servicing, transactions, and loan-related operations.

Deputy Manager

HDFC Bank

Nov 2023 - Mar 2025

Performed UAT and functional testing for banking application enhancements and change requests. Gathered business requirements and coordinated with technology teams for implementation and testing. Identified, documented, and tracked defects using JIRA and coordinated with relevant teams for resolution. Worked on banking processes covering CASA, account opening, deposits, NEFT, RTGS, IMPS, UPI, and digital banking. Supported operational reporting, process monitoring, and business-user coordination.

Deputy Manager

Kotak Mahindra Bank

Feb 2019 - Oct 2023

Managed day-to-day branch operations and monitored transaction processing, service quality, and operational controls. Handled NEFT, RTGS, fund transfers, TDS/custom payments, inward and outward clearing, and cheque returns. Performed reconciliation of clearing accounts and investigated transaction discrepancies and exceptions. Prepared and monitored MIS reports, TAT, quality objectives, Key Risk Indicators (KRIs), and operational metrics. Supported corporate current-account activities and business development through customer and transaction analysis.

Senior Officer – Centralized Operations

Standard Chartered Global Business Services Pvt. Ltd.

Feb 2012 - Nov 2018

Performed centralized banking operations for retail and corporate customers. Conducted KYC verification, customer data validation, account opening, and risk-rating activities. Prepared daily EOD reports and coordinated reporting with regional and middle-office teams. Maintained operational accuracy while meeting quality, turnaround-time, and control requirements.

Education

Master Data Science Program - IIT-M GUVI

- 2026 · Afghanistan

MBA – Finance & Marketing - FX Engineering College, Anna University

- 2013 · Afghanistan

B.Sc – Computer Science - Mano College, Manonmaniam Sundaranar University

- 2008 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 90/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation