Shubham Chaudhari

Data Analyst | MIS Executive | Business Analyst

Pune, Maharashtra 2+ yrs exp 85 · Excellent

About

Data-driven professional with 2 Years’ experience in Banking MIS Reporting, Data Analysis, Power BI Dashboard Development, SQL, Microsoft Excel, DSA Payment Processing, GST Invoice Billing, and Business Reporting. Skilled in transforming raw data into meaningful insights through dashboards, reports, and analysis. Experienced in preparing management MIS reports, analysing business performance, handling payment reconciliation, and supporting data-driven decision-making through Power BI, Excel, and SQL.

Skills & Expertise (33)

Microsoft Power BI Advanced

8.2/10

Years Exp

Problem Solving Advanced

8.0/10

Years Exp

Analytical Thinking Advanced

8.0/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

Power Query Intermediate

7.5/10

Years Exp

Time management Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Data Modeling Intermediate

7.0/10

Years Exp

Basic DAX Intermediate

6.5/10

Years Exp

WHERE Team Collaboration Process Improvement Attention to Detail Interactive Dashboards Management reporting KPI Reporting Data Extraction ORDER BY GROUP BY JOIN Business Performance Analysis Select Report Automation Data Validation Graphs Charts Conditional Formatting Countifs SUMIFS If VLOOKUP XLOOKUP Pivot Tables

Work Experience

Data Analyst | MIS Executive | Business Analyst (Power BI & SQL)

Aadifidelis Solution Pvt. Ltd.

Mar 2024 - Present

Prepared Daily, Weekly, and Monthly MIS reports for multiple banking partners to track business performance. Designed and developed interactive Power BI dashboards for sales, login, sanction, disbursement, DSA productivity, and KPI monitoring. Connected Excel and SQL data sources with Power BI for reporting and visualization. Performed data extraction, cleaning, transformation, and validation using Power Query and Basic SQL. Created data models, relationships, and basic DAX measures for business reporting. Developed dashboards using KPI Cards, Charts, Tables, Matrix, Slicers, and Filters. Analysed business data to identify trends, performance gaps, and improvement opportunities. Collected, validated, and reconciled data from multiple sources to ensure accuracy and consistency. Managed DSA incentive and commission payment processing with proper verification and reconciliation. Generated GST-compliant invoices and handled invoice billing processes for DSA payments and business transactions. Verified invoice details, GST calculations, supporting documents, and payment records before processing. Coordinated with Finance, Operations, Sales, and Banking teams for data validation and payment-related issues. Used advanced Excel functions including Pivot Tables, XLOOKUP/VLOOKUP, IF, SUMIFS, COUNTIFS, and Charts for reporting. Used SQL queries for data extraction, filtering, joining, and validation. Automated repetitive reporting activities using Excel and Power BI dashboards, reducing manual effort. Ensured timely submission of accurate reports while maintaining data confidentiality.