Headline

Data Analyst | Power BI | SQL | Advanced Excel | Dashboard Development | Data Visualization

About

Results-driven Data Analyst with 3+ 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.

Location

Pune District

Work experience

Data Analyst at Bajaj Finserv, May 2025 - Apr 2026 · 1 yr, Pune District, • 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.

Data Analyst at Imperative Business Ventures Limited, Oct 2024 - Apr 2025 · 7 mos, • 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%. +91 7620426774| chetan.dataanalyst01@gmail.com |Pune,India (OpenTo Relocate ) | Available Immediately • 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, Macros), improving reporting efficiency and reducing manual effort by 30%. • Collaborated with Operations and Finance teams to resolve transaction issues through ad-hoc SQL analysis and Power BI drill-through reports.

Management Information System Analyst at UAS IT Consultancy Services, Aug 2023 - Sep 2024 · 1 yr 2 mos, • Extracted and analyzed operational data using SQL queries (JOINs, Aggregate Functions, Subqueries) from multiple databases to support daily, weekly, and monthly MIS reporting for management decision-making. • Developed Excel-based dashboards (Pivot Tables, VLOOKUP, INDEX-MATCH, IF formulas) to visualize performance metrics, productivity trends, and business KPIs across departments. • Performed data cleaning and transformation (ETL) on raw operational data to generate structured, analysis-ready datasets for business reporting. • Monitored productivity metrics and identified performance trends through SQL-based data analysis, providing actionable insights to management for operational improvements. • Automated recurring MIS reports using Advanced Excel functions and Macros, reducing manual reporting effort and improving reporting cycle time by 25%.

Education

Bachelor's Degree, Electrical and Electronics Engineering, Savitribai Phule Pune University

Diploma In Engineering, Electrical and Electronics Engineering, Government Polytechnic, Murtijapur