# Anand Choudhary

Anand Choudhary is a remote worker on Himalayas, Associate Manager at Ernst & Young, based in India.

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

```text
Associate Manager in data analytics at Ernst & Young, delivering global Power BI dashboards and migrating on-premises projects to Azure.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 70k+ INR |
| Job categories | Data Analyst, Business Intelligence Developer, Data Engineer, SQL Developer |
| Skills | Data Analysis, Business Intelligence, Data Architecture, Data Warehouse, Data Modeling, ETL, Power BI, SQL Server, DAX, VBA, Alteryx, Azure Data Factory, Databricks, SSIS, SSRS |

## About

```text
At Ernst & Young, I led the design and development of data architecture solutions and delivered end-to-end BI reporting, from data ingestion and transformation to modeling and visualization.

I managed global Power BI dashboards and supported migration of on-premises projects to Azure using ADF, Databricks, Azure SQL Server, and Premium Power BI.

Earlier at Ernst & Young, I delivered a VBA and Power BI automation tool used by multiple teams to automate financial data books and reporting. I also designed SQL queries and Power BI data models, including star and snowflake schemas.

At Mercer Consulting India Pvt. Ltd., I designed compensation databases and data warehousing solutions, created SSIS packages, and generated compensation reports. My earlier work included VBA applications and retail analytics projects at WNS Global Services and Tata Consultancy Services.
```

## Experience

### Associate Manager

[Ernst & Young](https://himalayas.app/companies/ey). Oct 2022 - May 2024

```text
Led design and development of scalable data architecture solutions and managed team performance. Provided end-to-end BI reporting solutions including data ingestion, transformation, and visualization.
```

Skills: Azure-Databricks, Power-BI, DAX, SQL-Server, ADF, Alteryx, VBA, Python

### Assistant Manager

[Ernst & Young](https://himalayas.app/companies/ey). Feb 2020 - Sep 2022

```text
Managed data modeling in Power BI and SQL Server, created automation tools using VBA, and led team task allocation and training.
```

Skills: Power-BI, DAX, SQL-Server, Alteryx, VBA

### Assistant Manager – Data Analytics

Mercer Consulting India Pvt. Ltd.. Jun 2016 - Jan 2020

```text
Designed compensation databases with end-to-end data warehousing solutions and created SSIS packages for data import/export. Generated scheduled and ad-hoc compensation reports using Power BI and SSRS.
```

Skills: MS-SQL-Server, SSRS, SSIS, Power-BI, Excel, VBA, MS-Access

### Lead Developer – VBA SQL

[WNS Global Services](https://himalayas.app/companies/wns-global-services). Apr 2014 - Jun 2016

```text
Developed complex applications using MS Access and Excel, designed complex queries for data handling, and supported team in bug fixing on VBA projects.
```

Skills: Excel, VBA, MS-Access, SQL-Server

### SQL Developer

[Fidelity Investments](https://himalayas.app/companies/fidelity-investments). Aug 2013 - Mar 2014

```text
Developed complex applications using MS Access, VBA, and SQL Server, and modified stored procedures and workflows in SSIS. Interacted with clients to collect requirements and discuss project phases.
```

Skills: Excel, PowerPoint, VBA, Oracle-Hyperion, SQL-Server-2008, SSIS

### VBA Developer

[Tata Consultancy Services](https://himalayas.app/companies/tata-consultancy-services). Feb 2011 - Aug 2013

```text
Handled Retail Analytics projects on VBA and provided expertise in Marketing Analytics including category and brand dynamics, pricing, and promotion efficiency.
```

Skills: VBA

## Education

### Bangalore University

PGPM, Marketing & Finance. 2008 - 2010

```text
Pursued a Post Graduate Program in Management with a focus on Marketing and Finance.
```

### Government Engineering College, HNGU

BE, Information Technology. 2004 - 2007

```text
Completed a Bachelor of Engineering in Information Technology.
```

### Databricks

Databricks Lakehouse Fundamentals, Data Engineering

```text
Earned the Databricks Lakehouse Fundamentals certification.
```

## Tech stack

- Databricks
- Python
- Microsoft Excel
- Power BI
- Microsoft PowerPoint

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

## People also viewed

- [Vikrant Patil](https://himalayas.app/@vikrantpatil): Senior Analyst, Supply Chain Analytics, Ecolab
- [Rajesh kumar](https://himalayas.app/@rajeshkumar5): Data Consultant, UHG
- [Maha Lakshmi](https://himalayas.app/@mahalakshmi8): Senior Business Intelligence Analyst, Cloudmatic Technologies Pvt Ltd
- [Balram Prajapati](https://himalayas.app/@balramprajapati): Manager, BI & Data Solutions, Teleperformance
- [Prashant Phulera](https://himalayas.app/@prashantphulera): Associate Consultant, Capgemini Technology Services
- [Nishtha Raturi](https://himalayas.app/@nishtharaturi): Systems Engineer, Infosys Limited
- [Mohit Dhanotiya](https://himalayas.app/@mohitdhanotiya): Senior Consultant – Data Science and Analytics, Ernst & Young LLP
- [Purnaditya Suvvari](https://himalayas.app/@purnadityasuvvari): Power BI Senior Developer, Enterprise Analytics
- [Jomol Sathish](https://himalayas.app/@jomolsathish): Power BI Developer, Accenture Solutions Private Limited
- [Omkar Hiremath User](https://himalayas.app/@omkarhiremathuser): Power BI Developer & BI Analyst, Accenture
