Senior Manager specializing in automating reporting workflows to enhance efficiency and accuracy. Expert in SQL and Python, with a strong focus on data visualization and analytics. Proven ability to improve KPI tracking and audit readiness. Committed to delivering impactful insights and strategic solutions through effective collaboration.
Overview
7
7
years of professional experience
4
4
Certificate
Skills
MySQL and SQL Server
Python
SAS
Tableau
Power BI
Excel (advanced)
Spectrum Miner
KPI tracking and risk metrics
User acceptance testing (UAT)
Automation and data cleansing
Fraud and risk analysis
Data pipeline development
Dashboard design
Credit risk analysis
Audit readiness
Cross-functional collaboration
Work History
Senior Manager/Officer
Citicorp Services India Pvt. Ltd.
Mumbai
06.2024 - Current
Delivered critical metrics on loan booking performance, optimizing data analysis across global regions (NAM, EMEA, APAC, and LATAM).
Improved loan booking performance, reporting efficiency by 15% through automated workflows using Python.
Enhanced reporting accuracy by 10% through automation workflows using SQL and Tableau.
Developed dashboards for performance tracking, improving audit readiness, and decision-making, leading to a significant reduction in auditing time.
Coordinated loan closing activities, ensuring compliance with regulations and controls.
Participated in UAT for transaction systems, supporting seamless deployment and user adoption.
Senior Research Analyst
CRISIL Limited
Mumbai
01.2023 - 05.2024
Project: Loan Remediation and Syndication of Deals.
Supported "Citicorp Services India Pvt. Ltd." client in loan remediation and syndication data reporting.
Created loan remediation MI, SNC, and escalation reports using SQL, Excel, and Tableau.
Investigated errors in Credit Agreement IDs and GFRNs for audit rectification.
Built Tableau dashboards and governance structures for remediation tracking.
SQL Analyst
SBI Card
Gurgaon
01.2023 - 12.2023
Project: Recon validation and cashback fulfillment
Managed cashback and merchant discount reports using SAS, SQL, and Excel to support partner-driven customer offers.
Built Tableau dashboards to track card performance trends and customer engagement.
Conducted competitor benchmarking using RBI data for strategic positioning and performance insights.
Analyzed pre- and post-offer responder activity to evaluate campaign effectiveness and customer reactivation.
Performed ad hoc analyses on fraud, risk, and add-on cards, while supporting cross-functional testing and deployment initiatives.
Data Analyst
DV Analytics Pvt. Ltd.
Bangalore
01.2019 - 01.2023
Project: Retail Banking and Risk Management.
Built end-to-end data pipelines for credit risk analytics using SQL, SAS, and Python, covering data from origination to account performance.
Achieved a 25% increase in dashboard accessibility by migrating Excel-based reports into Tableau and Power BI dashboards.
Designed data models and reports for delinquency analysis, application funnel tracking, and collection performance insights.
Developed dashboards that improved KPI tracking by 30%, enabling better decision-making.
Built data models for delinquency, charge-offs, and fraud risk management.
Designed collections recovery reports and strategies using risk segmentation.
Supported fraud detection and risk mitigation by identifying patterns and building rule-based/ML models across payment channels.
Education
Semi-Qualified Chartered Accountant - Inter/IPCC
ICAI
Indore, India
01-2019
Bachelor of Commerce -
DAVV University
Indore, India
01.2017
Certification
Introduction to Business Analytics – LinkedIn Learning / PMI / NASBA (2023-12)
MySQL for Data Scientists – LinkedIn Learning (2023-08)
Tableau for Data Scientists – LinkedIn Learning (2023-05)
Operations Personnel at Adecco India Private Limited ( A Project in Citicorp Services India Pvt Ltd)Operations Personnel at Adecco India Private Limited ( A Project in Citicorp Services India Pvt Ltd)