# Pradnya Hirave

Pradnya Hirave is a remote worker on Himalayas, Executive – Data Analysis & Reporting at Credence Resource Management, based in India.

Source: https://himalayas.app/@pradnyahirave

```text
MIS and Data Analyst delivering KPI reporting, SQL insights, and Power BI dashboards.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Job categories | Data Analyst, MIS Analyst, Business Intelligence Analyst, Reporting Analyst, Power BI Developer, Analytics Analyst, Data Science Analyst, Financial Data Analyst, IT Data Analyst, Data Analytics Specialist |
| Skills | SQL Server, SQL Joins, Subqueries, Aggregation Queries, Pivot Tables, XLOOKUP, Index Match, Power Query, Excel Macros, Power BI, DAX, Data Modeling, Dashboarding, Data Visualization, Data Analysis, MIS Reporting, ETL Processes, Data Cleaning, data transformation, Report Automation, KPI Reporting, Process Improvement, Microsoft SQL Server, SQL |

## What I'm looking for

```text
I’m looking for a role where I can own KPI reporting and dashboard development using SQL, Power BI, and Excel—automate recurring work, strengthen data quality, and partner with stakeholders to drive faster, better business decisions.
```

## About

```text
I’m an MIS & Data Analyst who turns operational data into actionable business insights. With 5 years of experience, I focus on MIS reporting, KPI dashboards, and interactive Power BI views that help teams make data-driven decisions.

I’ve built and improved reporting pipelines end to end—extracting and analyzing data with SQL and Advanced Excel, cleaning and validating datasets for accuracy, and automating recurring MIS reports with Pivot Tables, formulas, and Macros. In my roles, I designed KPI dashboards for daily, weekly, and monthly performance and supported stakeholders with timely, accurate reporting.

I also enjoy continuous improvement through process automation and better data quality. One of my projects automated reporting significantly (about 80% reduction in manual effort) using SQL, Power Query, and Power BI with DAX-driven KPIs and interactive visuals.
```

## Experience

### Executive – Data Analysis & Reporting

Credence Resource Management. Jan 2024 - Jan 2026

```text
Used SQL to extract and analyze business data for operational and management reporting. Automated MIS reporting with Advanced Excel (Pivot Tables, formulas, macros) and built KPI dashboards with ongoing data cleaning and validation to ensure accuracy.
```

Skills: SQL, Power-BI, KPIs, MIS-Reporting, Report-Automation, Data-Cleaning, Data-Validation, Pivot-Tables, Macros, data-transformation, Dashboarding, Data-Visualization, DAX

### MIS Analyst

Stark Technology and Staffing Solution. Jun 2022 - Jan 2024

```text
Collected, cleaned, and analyzed datasets using Excel and SQL to support reporting and analysis. Developed SQL queries and created Power BI/Excel dashboards and automated recurring reports for improved reporting efficiency and accuracy.
```

Skills: SQL, Power-BI, MIS-Reporting, Data-Cleaning, Data-Analysis, Dashboard-Development, Report-Automation, Data-Extraction, Data-Validation, Pivot-Tables

### MIS Analyst

Unity Facilities Pvt. Ltd.. Dec 2020 - Jun 2022

```text
Prepared daily, weekly, and monthly MIS reports for management and built Excel dashboards to monitor operational KPIs. Performed regular data audits and quality checks and provided analytical reports to support business decision-making.
```

Skills: MIS-Reporting, KPI-Reporting, Data-Validation, Data-Quality, Audit-Reporting, Data-Analysis, Data-Reporting, Pivot-Tables

## Education

### Shivaji University

Bachelor of Engineering (Electronics), Electronics

```text
Earned a Bachelor of Engineering (Electronics) from Shivaji University in Kolhapur, Maharashtra.
```

## Tech stack

- Microsoft SQL Server
- SQL

To contact Pradnya, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Pratyush Tiwari](https://himalayas.app/@pratyushtiwari): MIS Analyst, Yes Securities
- [Warish Khan](https://himalayas.app/@warishkhan): Media Analyst, Kanalytics
- [Pranshul Joshi](https://himalayas.app/@pranshuljoshi): MIS Analyst, Communication Solutions
- [Mit Modi](https://himalayas.app/@mitmodi): Junior Data Analyst, Aurita Diamond Pvt. Ltd.
- [Sumit Garg](https://himalayas.app/@sumitgarg): Data Analyst, Ummeed Housing Finance
- [Rahul Giradkar Rahul Giradkar](https://himalayas.app/@rahulgiradkarrahulgi): Data Analyst, Unknown
- [Reya Sinha](https://himalayas.app/@reyasinha): Data Analyst MIS & Business Analytics, EXL
- [Sudhanshu singh User](https://himalayas.app/@sudhanshusinghuser): Data Analyst, Global Consulting & Professional Services Environment
- [Laraib Khan](https://himalayas.app/@laraibkhan1): MIS Analyst, Discovery Data Center Solutions
- [Subhan Shaikh](https://himalayas.app/@subhanshaikh): Senior Data Analyst, TrueLoyal
