Mohnish Pathak

Data Analyst | Power BI Developer

Chandrapur, Maharashtra 4+ yrs exp 89 · Excellent

About

Data Analyst and Power BI Developer with 5+ years of combined IT and internship experience, including 4+ years in data analytics, business intelligence, reporting, and dashboard development. Skilled in SQL, Power BI, DAX, Excel, Power Query, data modeling, data visualization, and KPI reporting. Experienced in developing interactive dashboards, analytical reports, optimized SQL queries, and data models to deliver actionable business insights. Knowledgeable in data validation, reporting automation, requirements analysis, and stakeholder collaboration.

Skills & Expertise (35)

Power BI Service Advanced

8.5/10

Years Exp

Power BI Desktop Advanced

8.5/10

Years Exp

DAX Advanced

8.0/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

Microsoft SQL Server Advanced

8.0/10

Years Exp

Data Analysis Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Data Transformation Advanced

7.5/10

Years Exp

Data Cleaning Advanced

7.5/10

Years Exp

Scrum Advanced

7.0/10

Years Exp

Agile Advanced

7.0/10

Years Exp

Pivot Tables Stakeholder Collaboration Requirements Analysis Jira Azure DevOps Postman DataBase Testing API Testing Manual Testing KPI Analysis VLOOKUP Business Intelligence Advanced Excel Dimensional Modeling Star Schema Data Preparation Dashboard Development KPI Reporting Power Query Data Validation Query Optimization Stored Procedures Joins MySql

Work Experience

Senior Analyst / Senior Test Engineer – Data Analytics & Testing

Techsthouse

Aug 2024 - Jul 2026

Developed and supported Power BI dashboards and KPI reports to monitor business and operational performance. Used SQL to extract, validate, and analyze data for reporting, reconciliation, and issue investigation. Applied data modeling and DAX measures to present business metrics in clear, actionable dashboards. Performed data validation and testing to improve reporting accuracy and identify discrepancies. Collaborated with business and technical stakeholders to clarify requirements and deliver reliable reporting solutions.

Test Analyst

Coforge (Client: Knight Frank)

Sep 2023 - Mar 2024

Performed manual testing of web-based real estate applications, including functional, UI, regression, smoke, system, and integration testing. Analyzed requirements and user stories to create test scenarios and detailed test cases. Performed API testing using Postman and database validation using SQL queries. Logged, tracked, and retested defects in Azure DevOps; prepared test execution and release documentation. Collaborated with developers, business analysts, and product teams in an Agile/Scrum environment.

Analyst

Cenit Technologies Pvt. Ltd.

Jun 2021 - Sep 2023

Designed and deployed 5+ Power BI dashboards for operational reporting and KPI monitoring. Extracted, cleaned, and transformed datasets using SQL Server and Power Query, achieving approximately 99% data accuracy. Developed optimized SQL queries and stored procedures, improving query performance by approximately 40%. Automated Power BI Service data-refresh schedules, reducing manual reporting effort by 10+ hours per week. Improved visibility of 10+ key business metrics to support data-driven decision-making. Collaborated with cross-functional teams to improve order tracking and operational reporting through the AIMS platform.