Gaurav Dhama

Gaurav Dhama Email and Phone Number

Senior Consultant at GT | EX-KPMG | EX-EY GDS| Alteryx Designer Advanced Certified @ Grant Thornton INDUS
Gaurav Dhama's Location
Bengaluru, Karnataka, India, India
About Gaurav Dhama

Alteryx Designer Advanced CertifiedExperienced in Data Analysis and Data transformation with skills in Alteryx, SQL, Postman, Power Apps, Power Automate, Advance Excel, VBA and Power BI.Expert in Alteryx APIs.Working experience in Dash, Flask & APIs.

Gaurav Dhama's Current Company Details
Grant Thornton INDUS

Grant Thornton Indus

View
Senior Consultant at GT | EX-KPMG | EX-EY GDS| Alteryx Designer Advanced Certified
Gaurav Dhama Work Experience Details
  • Grant Thornton Indus
    Senior Consultant
    Grant Thornton Indus Aug 2023 - Present
    Bengaluru, Karnataka, India
    • Lead a project for audit automation, with potential savings of 700 hours.• Trainer for Power Apps, Power Automate, VBA, Advance Excel and Alteryx.• Enhanced the user experience for Alteryx users by developing a new UI in PowerApps. Users can run the Alteryx Workflow right from the teams chat.• Identified potential problem with accessing sub sites in SharePoint and developed a python code to take care of the same. It can seamlessly work with parent or child site.• Developing Dash app (python).
  • Grant Thornton Indus
    Consultant
    Grant Thornton Indus Oct 2022 - Aug 2023
    Karnataka, India
    • Leading projects from design to deployment.• Redesigning Alteryx Workflow/tools XML to make it dynamic. • Revolutionised the work papers creation process by cutting down processing time by 50% and load on Gallery considerably.• Developed Alteryx Macros that overcome the limitations of inbuilt alteryx tools. - sequential output - automated delimited data handler - excel formula handler - Automated Data stacker (horizontal or vertical) in excel.•Custom SharePoint Connectors•Python integration for dos tasks.• Building Alteryx API for integration with other technologies.• Built APIs in Python and hosted on Azure App services •Provide training on Excel and VBA.
  • Kpmg Resource Centre Private Limited
    Executive
    Kpmg Resource Centre Private Limited Dec 2021 - Oct 2022
    India
    • Testing Completeness of JE data with Trial Balance, perform specific criteria testing.• Revenue/Sales Analysis• Creating customised Alteryx workflows per client for JE completeness and specific criteria testing.• Revolutionised the process of workpaper creation, reducing the manual efforts by 70-80%.• Leading the initiative to standardise the other processes workflows and workpapers.• Conducting trainings within team to upskil and leverage new developments for further usage and developments
  • Ey
    Advance Analyst
    Ey Aug 2020 - Dec 2021
    India
    Collate, data analysis and data validation using different methods• Power Query, Power Pivot & Power Charts – creating a data link – perform changes/modifications indata model, create relationships and creating the report.• Alteryx – Creating the workflow to automate the manual process/ creating workflow for newclients. Debugging the Alteryx workflow if it fails due to some changes in data & modifying as perrequirement.• VBA – Creating macro workbooks to modify/generate/convert the data. Modifying the VBA codesto accommodate the changes or customizations.• Data Visualization after the above set processes in Power Bi reports. Publish to the Power Bi serverand share with the required resources and clients.• Modify the existing Power BI/Alteryx/VBA to customizations as per requirements.• Led a team of 13 people for testing the automation process being developed as a part of myinnovation idea.• Created Macro workbooks for xml & csv generation – potential time saving 6000 hours annuallyand quality by 99%.• 3 Bronze and 1 Learning EY Badges• Received annual High contributor tag for both the years.
  • Ey
    Tax Analyst
    Ey Jul 2019 - Aug 2020
    India
  • Cleartax India
    Business Development Associate
    Cleartax India Apr 2019 - Jun 2019
    Bengaluru, Karnataka, India
    I was working with the offline business development team and was responsible to setup help desks in various companies to help the employees in respective companies with Taxes and ITR filing along with branding of ClearTax. We discussed various strategies to increase the customer involvement in help desks. I was also working with sales support team to sort the prospective companies for carrying out promotions and helpdesk.
  • Starfing
    Intern
    Starfing Mar 2019 - Apr 2019
    Bangalore Urban, Karnataka, India
    Worked as an intern analyzing the FOREX market and learning the trading methods and various charts to perform the analysis.
  • Ey
    Tax Intern
    Ey Jan 2018 - Sep 2018
    Karnataka, India
    Worked as intern with PAS and Indirect tax team supporting with Analysis and preparation of client deliverables.I have been intern of the month during both my internship at EY.

Gaurav Dhama Skills

Microsoft Office Solid Edge Hypermesh Ansys Fluent Cnc Programming

Gaurav Dhama Education Details

Frequently Asked Questions about Gaurav Dhama

What company does Gaurav Dhama work for?

Gaurav Dhama works for Grant Thornton Indus

What is Gaurav Dhama's role at the current company?

Gaurav Dhama's current role is Senior Consultant at GT | EX-KPMG | EX-EY GDS| Alteryx Designer Advanced Certified.

What schools did Gaurav Dhama attend?

Gaurav Dhama attended Ramaiah Institute Of Technology, Bangalore Institute Of Technology, Kendriya Vidyalaya.

What skills is Gaurav Dhama known for?

Gaurav Dhama has skills like Microsoft Office, Solid Edge, Hypermesh, Ansys Fluent, Cnc Programming.

Not the Gaurav Dhama you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.