Suraj Kambale Gurav

Lead Data Analyst @Accenture

Pune, IN

Built and optimized Power BI dashboards on card transactions with ISO 20022 payment messaging, merchant categories, and payment lifecycle metrics (authorization, clearing, settlement).• Automated email notification on chargebacks, payment disputes, CASA ratio.• Spearheaded the development of Power BI dashboards and reports, integrating banking data from multiple sources to provide actionable insights on customer behavior, customer segmentation, CASA balance, and loan performance.• Reduced dashboard load time by 20% using optimized SQL queries on large transaction datasets (cards, payments, lending).• Designed RLS/OLS-based reporting models to ensure secure payment and customer-level access.• Automated ELT pipelines for transaction, loan, and CASA data using SQL, SAS EG, and Azure.• Collaborates with business stakeholders to define KPIs on payment success rates, transaction declines, and merchant risk exposure.• Partnered with cross-functional teams to ensure compliance with AML, PCI DSS, and regulatory guidelines in payment reporting.

North Maharashtra University

Bachelor of Science - BS