# Sumit Garg

Sumit Garg is a remote worker on Himalayas, Data Analyst at Ummeed Housing Finance, based in India.

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

```text
I am a data analyst building BI dashboards and automated MIS reporting.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Job categories | Data Analyst, Business Intelligence Analyst, Power BI Developer, Database Analyst, MIS Analyst, Analytics Analyst, Data Analytics Specialist |
| Skills | SQL, Python, Pandas, NumPy, DAX, Power BI, Power Query, Excel Dashboard, Index Match, Pivot Tables, Excel Macros, PowerPoint, MS SQL Server, MySQL, Stored Procedures, Views, Query Optimization, Data Cleaning, Data Validation, Reconciliations, ETL, Data Modeling, Quality Assurance, KPI Tracking, Process Automation, Ad hoc Analysis, Forecasting, Trend Analysis, Statistical Analysis, Excel, Wise |

## What I'm looking for

```text
I’m looking to build executive-ready dashboards and automated MIS reporting that improves data accuracy and turnaround time, while collaborating cross-functionally to deliver actionable KPI insights for better business decisions.
```

## About

```text
I am a Data Analyst with 4+ years of experience in Business Intelligence, MIS reporting, data analytics, dashboard development, and process automation across Financial Services (NBFC/Housing Finance), Healthcare, and E-commerce. I focus on turning complex datasets into reliable executive insights.

I work across the full reporting lifecycle: data extraction, transformation, and analysis using SQL, Python, and Excel, followed by dashboarding in Power BI. I have automated daily, weekly, and monthly MIS reports and improved reporting accuracy and turnaround time.

I also prioritize quality and performance—optimizing SQL queries, stored procedures, and underlying data models while applying data validation, reconciliation, and quality checks. I enjoy partnering with Operations, Credit, Sales, and Finance teams to translate reporting needs into actionable decision support.
```

## Experience

### Data Analyst (current)

Ummeed Housing Finance. Jul 2025 - Present

```text
Developed and maintained interactive Power BI dashboards to track business KPIs and branch performance across PAN India. Automated recurring daily/weekly/monthly MIS reports using Python and optimized SQL queries, stored procedures, and data models to improve refresh speed and reporting accuracy.
```

Skills: Power-BI, Power-Query, SQL, Python, Pandas, NumPy, Excel, Stored-Procedures, Views, Query-Optimization, Data-Validation, MIS-Reporting, Dashboarding, Process-Automation, Data-Modeling

### Data Analyst

[Pristyn Care](https://himalayas.app/companies/pristyn-care). Jun 2024 - Jun 2025

```text
Automated recurring MIS reports and data pipelines using Python to improve reporting efficiency. Built and optimized SQL queries, views, and stored procedures for multi-database reporting, and performed exploratory analysis to identify trends and operational improvement opportunities.
```

Skills: Python, SQL, Stored-Procedures, Views, MIS-Reporting, Data-Pipelines, Dashboarding, Forecasting, KPI-Tracking

### Data Analyst

Healthkart. Mar 2022 - Sep 2023

```text
Developed and automated daily, weekly, and monthly MIS reporting using SQL, Python, Excel, and Power BI. Created interactive Power BI dashboards for sales, operations, inventory, customer acquisition, and key KPIs, and supported leadership with ad hoc analysis and executive reporting.
```

Skills: SQL, Python, Excel, Power-BI, Dashboarding, MIS-Reporting, Data-Visualization, Data-Extraction, data-transformation, Ad-hoc-Analysis, Executive-Reporting

## Education

### Rajasthan Technical University

Bachelor of Engineering, Mechanical Engineering

```text
Earned a Bachelor of Engineering in Mechanical Engineering from Rajasthan Technical University (Jul 2018).
```

## Tech stack

- NumPy
- Pandas
- MySQL
- Microsoft Excel
- SQL
- Wise

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

## People also viewed

- [Nikita Chaudhari](https://himalayas.app/@nikitachaudhari): Freelance Data Analyst, Independent
- [Darshan Acharya](https://himalayas.app/@darshanacharya1): Business Analyst (Power BI), MNK GCS
- [Mithil Gundeti](https://himalayas.app/@mithilgundeti): Customer Data Quality Validation, Personal Project
- [Vivek K](https://himalayas.app/@vivekk3): MIS Analyst, Calibehr Business Support & Services
- [Kishor Kornule](https://himalayas.app/@kishorkornule): Project Associate I, CSIR – National Aerospace Laboratories (CSIR NAL)
- [Bansi Hadiyal](https://himalayas.app/@bansihadiyal): MIS Executive | Data Analyst, Kotak Mahindra Bank Ltd.
- [Suraj Bera](https://himalayas.app/@surajbera1): Senior Process Associate, Tata Consultancy Services
- [Rahul Giradkar Rahul Giradkar](https://himalayas.app/@rahulgiradkarrahulgi): Data Analyst, Unknown
- [Shivanjan Gajjela](https://himalayas.app/@shivanjangajjela): Data Analyst, Self Employed
- [Abhi M](https://himalayas.app/@abhim1): Data Analyst Intern, Rows and Columns
