RAHUL PANDIT

Data Analyst

Thane 0+ yrs exp 82 · Excellent

About

Data Analyst with hands-on experience in SQL, Python, Excel, Altair Panopticon, and Tableau, specializing in dashboard development, data analysis, reporting, automation, and data validation. Experienced in banking analytics, loan portfolio analysis, and Treasury Finance reporting, including ALM liability cashflow automation and GL/Non-GL cashflow analysis. Skilled in data extraction, transformation, validation, reconciliation, visualization, and translating business requirements into analytical reporting solutions.

Skills & Expertise (23)

Data Analysis Advanced

8.5/10

Years Exp

Pandas Advanced

8.5/10

Years Exp

SQL Advanced

8.3/10

Years Exp

Python Advanced

8.0/10

Years Exp

Data Reconciliation Advanced

8.0/10

Years Exp

Data Validation Advanced

8.0/10

Years Exp

Data Transformation Advanced

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

MySql Advanced

8.0/10

Years Exp

Tableau Intermediate

7.5/10

Years Exp

Advanced Excel Intermediate

7.5/10

Years Exp

NumPy Intermediate

7.5/10

Years Exp

Jupyter Notebook Intermediate

7.5/10

Years Exp

SQL Server Intermediate

7.0/10

Years Exp

Postgresql Intermediate

7.0/10

Years Exp

Matplotlib Intermediate

7.0/10

Years Exp

ETL Fundamentals Intermediate

7.0/10

Years Exp

KPI Reporting Intermediate

7.0/10

Years Exp

MySQL WorkBench Intermediate

7.0/10

Years Exp

SciPy Intermediate

6.5/10

Years Exp

Data Modeling Basics Intermediate

6.5/10

Years Exp

Loan Portfolio Analysis Intermediate

6.5/10

Years Exp

Banking Analytics Intermediate

6.0/10

Years Exp

Work Experience

Data Analyst – Apprenticeship

FedBank Financial Services Ltd.

Nov 2025 - Present

Developed interactive Altair Panopticon dashboards for loan disbursement, principal outstanding, portfolio performance, and business monitoring. Built MSELAP, SAKSHAM, and SBL dashboards to support business and operational performance tracking. Developed a Cross Sell MSE LAP dashboard using SQL and Altair Panopticon to track lead generation, staff activation, lead disposition, and branch-level performance. Developed GL and Non-GL Cashflow dashboards in Tableau to support Treasury Finance and ALM due-date analysis. Developed LOD (List of Documents) reports that cover the full document lifecycle. Automated liability-side ALM cashflow processing, data transformation, validation, reconciliation, and residual maturity-based bucketing using Python, Pandas, SQL, and Excel. Collaborated with Treasury Finance and business stakeholders to understand requirements, validate data, and deliver reporting solutions.