Skip to main content
Chetan Korde

Chetan Korde

Data Analyst | Power BI | SQL | KYC & Fraud Analytics | RBI Compliance | BFSI Domain

Talent
PuneMember since August 2, 2026
Power BIDAXPower QueryDashboard DevelopmentBusiness IntelligenceSQLJoinsCTEsWindow FunctionsAggregate FunctionsETLAdvanced ExcelPivot TablesINDEX-MATCHVLOOKUPData AnalysisKPI Reporting
·

Hire this person

Send a job offer directly to this candidate

Power BIDAXPower QueryDashboard DevelopmentBusiness Intelligence

About

Results-driven Data Analyst with 1.7 years of experience in Business Intelligence, Dashboard reporting, and payment operations analytics. Expertise in FASTag Video KYC operations, RBI compliance reporting, fraud detection analytics, and dashboard development at Bajaj FinServ. Skilled in Power BI (DAX, Power Query), SQL, and Advanced Excel.

Proven track record of automating compliance reports, building KPI dashboards, reconciling 10,000+ monthly transactions, and delivering data-driven insights for audit and risk teams. Currently available immediately for new opportunities.

Experience

Data Analyst (Reporting) – Payment Operations at Bajaj FinServ (2025-05 – Present)

  • Designed and deployed 10+ Power BI dashboards to monitor FASTag Video KYC operations — tracking daily approval rates, rejection trends, fraud patterns, and agent performance across RBI-mandated compliance workflows.
  • Wrote complex SQL queries (JOINs, CTEs, Window Functions) to extract and analyze 10,000+ monthly KYC transaction records, identifying FASTag abuse cases, duplicate applications, and fraudulent customer behavior with 98% data accuracy.
  • Built automated Power Query (M language) pipelines connecting SQL databases to Power BI, enabling real-time refresh of hourly KYC dashboards — reducing report generation time from 4 hours to 30 minutes.
  • Analyzed and validated 80+ Video KYC cases daily, flagging non-compliant applications and potential FASTag fraud instances as per RBI KYC guidelines and internal compliance standards.
  • Developed RBI compliance tracking reports to monitor KYC approval/rejection ratios, escalation trends, and audit-ready MIS summaries — shared directly with Operations and Compliance teams.
  • Built Excel-based performance dashboards (Pivot Tables, INDEX-MATCH, Macros) to track agent-wise KYC productivity, rejection reasons, and SLA adherence — adopted by management for daily operational reviews.

Reporting Analyst at Imperative Business Ventures (2024-10 – 2025-04)

  • Developed Power BI dashboards using DAX measures and Power Query to track payment transaction volumes, approval/rejection KPIs, and operational performance — enabling real-time management reporting.
  • Wrote SQL queries (JOINs, CTEs, Aggregate Functions) to extract and analyze transaction data from payment databases, identifying discrepancies, exceptions, and potential fraud patterns — reducing risk exposure.
  • Performed SQL-based data reconciliation between internal systems and payment gateways, validating daily transaction records to ensure 100% data accuracy and integrity.
  • Built Power Query (M language) ETL pipelines to clean, validate, and transform raw transaction data for operational analysis — reducing manual data preparation effort by 30%.
  • Designed DAX-based KPI measures in Power BI to monitor transaction trends and operational insights — replacing manual Excel processes with automated dashboard reporting.
  • Automated 5+ recurring MIS reports using Advanced Excel (Pivot Tables, VLOOKUP, INDEX-MATCH, Macros), reducing manual effort by 30% and improving reporting turnaround time.
  • Monitored operational productivity and business KPIs through dashboard analysis, providing actionable insights that supported process improvements and management decision-making.
  • Collaborated with Operations, Finance, and Business teams to resolve transaction issues, perform ad-hoc analysis, and deliver data-driven recommendations through Power BI drill-through reports and SQL analysis.

Education

B.E. in Electrical Engineering – Savitribai Phule Pune University (2020-06 – 2023-07)

Diploma in Electrical Engineering – Govt. Polytechnic Murtizapur (2017-06 – 2020-07)

SSC in Secondary School Certificate – Matoshri Sushilabai Deshmukh (2017)

Skills

Data AnalystPower BISQLKYC & Fraud AnalyticsRBI ComplianceBFSI Domain

Reviews

Related