Summary
Overview
Work History
Education
Skills
Accomplishments
Affiliations
Additional Information
Certification
Hi, I’m

Atul Aggarwal

ETL Developer
New Delhi
Atul Aggarwal

Summary

Currently working at KPMG, with an objective to transform audit by bringing in intelligent analytics in audit methodologies. In my current expertise, I have worked closely with 100+ clients from sectors belonging to Technology, E-Commerce, Consumer Product & Retail, Mining & Metals etc working independently to understand their data & businesses and linking it back to audit teams problem statement. My part of the job is to explore, analyze the data and provide visual business insights to our partners which will allow us to provide better-quality, deeper insights, and more client-relevant audits, as well as exercise a higher level of professional scepticism.

Overview

4
years of professional experience
5
years of post-secondary education
8
Certifications

Work History

KPMG India
Gurugram

Consultant
07.2021 - Current

Job overview

  • Working with audit innovation team, in order to implement Alteryx model to replace their current technology in order to speed up the process with no technical glitches
  • Develop and maintain data workflows using Alteryx
  • Interpreted data models for conversion into ETL diagrams and code.
  • Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
  • Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
  • Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
  • Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.

EY Global Delivery Service LLP
Gurugram

Lead Associate
10.2019 - 07.2021

Job overview

  • Mentored and guided employees to foster proper completion of assigned duties.
  • Developed an Alteryx app to automate the work to ensure high efficiency within a team
  • Built strong relationships with customers through positive attitude and attentive response.
  • Preparing Financial Data for the Audit Team by using Alteryx Tool which includes Data Cleansing, Data Sanitization, Data modelling, Data Validation.
  • Preparing Dashboard for Audit Team for better understanding of the data.
  • Prepared Custom Reports by using Alteryx and develop the workflow to automate the work if needed again and again.
  • Analyse large dataset for Premium Clients and reviewed the work of colleagues to ensure zero delivery error.
  • Identification of pattern and trend to solve complex data query for audit team.

EY
Gurugram

Contractual
09.2018 - 06.2019

Job overview

  • Worked with customers to understand needs and provide excellent service.
  • Constantly involved with auditors to automate their audit workbooks by designing Alteryx model to reduce manual efforts.
  • Clean and Modify Complex Data Sets
  • Analyse large volume of data and find hidden patterns.
  • Transformation of the data to extract the meaningful information for business use.
  • Extracting the data from PDF by using Monarch tool.

Education

Birla Institute of Technology And Science
Pilani,Rajasthan

Post Graduation Diploma from Business Analytics
10.2021 - Current

Laxmi Devi Institute of Engineering & Technology, Rajasthan Technical University
Alwar, Rajasthan

B.Tech from Computer Science
07.2014 - 07.2018

Skills

    Alteryx

undefined

Accomplishments


  • Developed an Alteryx app to automate the work to ensure high efficiency within a team
  • Analyze large dataset for Premium Clients and reviewed the work of colleagues to ensure zero delivery error
  • Redesigned project plan and strategy after encountered problems; recognized forability to turn it around and finalize it on time
  • Development of Alteryx app to fetch the logged in user details in the multiple remote server to enhance the functionality of the Remote desktop.
  • Received recognition from premium clients

Affiliations

  • Core Member of Data Analytics team of premium clients.
  • L1 Reviewer for exotic clients Core Member of the Development Team.
  • Core Member of the Automation Team.
  • Part of Alteryx for Good Co-Lab.

Additional Information

  • Developed an Alteryx app to automate the data extraction through SQL queries which was highly appreciated by the onshore team.
  • SPOT Award
  • Extra Miler Award
  • Kudos Award

Certification

Alteryx Core Certification

Similar Profiles

CREATE PROFILE
Atul AggarwalETL Developer