Gaurav Dhama Email and Phone Number
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.
Grant Thornton Indus
View-
Senior ConsultantGrant Thornton Indus Aug 2023 - PresentBengaluru, 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). -
ConsultantGrant Thornton Indus Oct 2022 - Aug 2023Karnataka, 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. -
ExecutiveKpmg Resource Centre Private Limited Dec 2021 - Oct 2022India• 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 -
Advance AnalystEy Aug 2020 - Dec 2021IndiaCollate, 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. -
Tax AnalystEy Jul 2019 - Aug 2020India -
Business Development AssociateCleartax India Apr 2019 - Jun 2019Bengaluru, Karnataka, IndiaI 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. -
InternStarfing Mar 2019 - Apr 2019Bangalore Urban, Karnataka, IndiaWorked as an intern analyzing the FOREX market and learning the trading methods and various charts to perform the analysis.
-
Tax InternEy Jan 2018 - Sep 2018Karnataka, IndiaWorked 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
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial