Looking for a job

Anand Choudhary

@anandchoudhary1

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

India

Message

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

Work history, roles, and key accomplishments

Associate Manager

Ernst & Young

Oct 2022 - May 2024 (1 year 7 months)

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.

Azure Databricks Power BI DAX SQL Server ADF Alteryx VBA Python

Assistant Manager

Ernst & Young

Feb 2020 - Sep 2022 (2 years 7 months)

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

Power BI DAX SQL Server Alteryx VBA

Assistant Manager – Data Analytics

Mercer Consulting India Pvt. Ltd.

Jun 2016 - Jan 2020 (3 years 7 months)

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.

MS SQL Server SSRS SSIS Power BI Excel VBA MS Access

Lead Developer – VBA SQL

WNS Global Services

Apr 2014 - Jun 2016 (2 years 2 months)

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

Excel VBA MS Access SQL Server

SQL Developer

Fidelity Investments

Aug 2013 - Mar 2014 (7 months)

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.

Excel PowerPoint VBA Oracle Hyperion SQL Server 2008 SSIS

VBA Developer

Tata Consultancy Services

Feb 2011 - Aug 2013 (2 years 6 months)

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

VBA