# Mohit Dhanotiya

Mohit Dhanotiya is a remote worker on Himalayas, Senior Consultant – Data Science and Analytics at Ernst & Young LLP, based in India.

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

```text
Data Analyst at Ernst & Young LLP who automates Alteryx workflows and builds Power BI dashboards for financial and insurance analytics.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 2453k+ INR |
| Job categories | Data Analyst, Data Scientist, Business Intelligence Analyst |
| Skills | Data Analysis, Business Reporting, Data Visualization, ETL, Workflow Automation, Data Quality Management, Data Modeling, KPI Reporting, Data Cleaning, Data Storytelling, Power BI, DAX, Power Query (M), Alteryx, SQL |

## About

```text
At Ernst & Young LLP, I design and automate Alteryx ETL workflows for data extraction, cleansing, validation, and reporting. I also integrate data sources into Power BI models and dashboards that track business performance and operational KPIs.

I use SQL to query and optimize data across multiple databases, and Power Automate to automate business processes, synchronization, and alerts. My work includes data-quality checks and validation to support accurate reporting.

At eClerx, I developed interactive Power BI dashboards and data models, wrote DAX measures, and published reports to Power BI Service. I also maintained weekly SQL reports and used Excel to analyze datasets for client requests.

Across these roles, I’ve worked in business reporting, data analytics, and process automation, with a background in financial and insurance analytics. I hold a Post Graduate Certification Program in Data Science and certifications including Alteryx Designer Core and HackerRank Certified SQL Basics.
```

## Experience

### Senior Consultant – Data Science and Analytics (current)

[Ernst & Young LLP](https://himalayas.app/companies/ey). Jan 2024 - Present

```text
Designed and automated end-to-end ETL workflows using Alteryx, developed Power BI dashboards with DAX and Power Query, and wrote complex SQL queries to support business reporting and analytics.
```

Skills: Alteryx, Power-BI, DAX, Power-Query, SQL, Power-Automate, Excel, VBA, Python, Data-Modeling, ETL, Data-Quality, KPI-Reporting

### Senior Analyst – Data Analytics

[eClerx](https://himalayas.app/companies/eclerx). Mar 2022 - Jan 2024

```text
Developed interactive Power BI dashboards with advanced features, created DAX expressions, and used SQL and Excel to analyze data and support decision-making.
```

Skills: Power-BI, DAX, SQL, Excel, Data-Modeling, Data-Visualization, Data-Analysis

## Education

### Post Graduate Certification Program in Data Science

Post Graduate Certification, Data Science. 2021 - 2022

```text
Completed a Post Graduate Certification Program in Data Science from 2021 to 2022.
```

### Bachelor of Engineering (Automobile)

Bachelor of Engineering, Automobile Engineering. 2015 - 2019

```text
Completed a Bachelor of Engineering in Automobile from 2015 to 2019.
```

### Higher Secondary Education

Higher Secondary, General. 2013 - 2015

```text
Completed Higher Secondary Education from 2013 to 2015.
```

## Tech stack

- Tableau
- MySQL
- PostgreSQL
- Python
- Microsoft Excel
- SQL
- Power BI

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

## People also viewed

- [Anjana Theeyarath](https://himalayas.app/@anjanatheeyarath): Senior Data Analyst, Beinex
- [Rishob Ghosh](https://himalayas.app/@rishobghosh): Software Development Engineer, Wissen Technology Pvt Ltd
- [PRASHANT SINGH](https://himalayas.app/@prashantsingh12): Senior Data Analytics Specialist, Pearson
- [Livin Shaji](https://himalayas.app/@livinshaji): Data Analyst, Ernst and Young
- [Karthik Shanker M](https://himalayas.app/@karthikshankerm): Data Analyst, Ernst & Young (EY)
- [Nishtha Raturi](https://himalayas.app/@nishtharaturi): Systems Engineer, Infosys Limited
- [Anand Choudhary](https://himalayas.app/@anandchoudhary1): Associate Manager, Ernst & Young
- [Sinchana G R](https://himalayas.app/@sinchanagr): Associate Consultant (Data Analyst), KPMG Global Services
- [Rushabh Kawadkar](https://himalayas.app/@rushabhkawadkar): Senior Data Analyst, Eclerx Services Pvt Ltd.
- [ROHIT PODDAR](https://himalayas.app/@rohitpoddar1): Senior Associate, Goldman Sachs
