AAKASH KUMAR GUPTA
Delhi NCR
Summary
Automation and analytics professional with over 8 years of experience in building end-to-end automation and business intelligence solutions. Skilled in VBA, Python, Power Automate, Power BI, Advanced Excel, SQL, SAP, and Web Automation. Experienced in simplifying complex manual processes, improving productivity, and delivering secure, reliable solutions. Known for strategic problem-solving and innovation, with a proven record of driving measurable business impact — earned the Top Performance Rating (Strategic Impact) for the last two years. Passionate about using AI and emerging technologies to enhance automation efficiency and deliver practical, high-quality results.
Overview
8
8
years of professional experience
Work History
Assistant Manager
EY Global Delivery Services India LLP
Gurugram
08.2022 - Current
- Leading the design and development of automation and reporting solutions using VBA, Python, Power Automate, and Power BI to make business processes faster, accurate, and more efficient.
- Creating Python-based tools and desktop apps to automate repeated and time-consuming tasks using Pandas, NumPy, OpenPyXL, and Tkinter. These tools are used for data cleaning, report generation, Excel automation, and backend processing, helping teams save time and reduce human errors. Also developed scripts for API integration, email automation, and file handling to connect different systems smoothly.
- Building Power Automate Cloud Flows for API integration, file automation, and approval workflows, connecting data across SharePoint, Dataverse, and other business systems.
- Designing interactive Power BI dashboards using data from APIs, Excel, and SharePoint, applying DAX formulas and setting up auto-refresh to keep reports always updated.
- Creating and managing SharePoint sites for different business teams to use as centralized reporting and document-sharing platforms, including site structure design, content organization, and access management to ensure security and smooth collaboration.
- Using Azure DevOps to plan and track tasks, manage version control, and maintain clear project documentation.
- Using AI fundamentals to improve automation logic, accuracy, and performance — and validating results with human intelligence and experience to make sure outputs are correct and practical.
- Working with business teams to understand needs, plan automation ideas, and deliver stable, easy-to-maintain solutions with proper training and support.
- Improving existing tools by fixing errors, increasing speed, and updating features as per business or compliance needs.
- Sharing knowledge and best practices with team members to help improve the overall quality and impact of automation work.
Senior Executive
KPMG Global Services Private Limited
Gurugram
04.2022 - 08.2022
- Prepared and automated HR Shared Services (HRSS) reports using VBA and Excel for daily, weekly, and monthly reporting requirements.
- Created dashboards and MIS reports for headcount, onboarding, background verification, and vendor payment tracking.
- Streamlined report generation through VBA macros, reducing manual effort and turnaround time significantly.
- Ensured accuracy and timeliness of HR analytics reports for leadership review.
Business Analyst
Genpact Limited
Noida
12.2020 - 04.2022
- Responsible for complete automation project lifecycle from opportunity identification to production deployment.
- Analyzed client processes, prepared feasibility studies, and developed VBA- and Python-based solutions to optimize repetitive workflows.
- Worked with SMEs during UAT to ensure successful testing, feedback resolution, and post-implementation stabilization.
- Performed documentation, version management, and user support for automation projects.
- Involved in developing AI understanding for optimization of automation validation and logic refinement.
Senior MIS Executive
Fincart Investment Planners
Noida
02.2020 - 12.2020
- Prepared daily, weekly, and monthly MIS and sales reports using Advanced Excel and VBA.
- Developed automation solutions for data processing and marketing reports as per business requirements.
- Automated performance evaluation processes and created reports for KRA and KPI assessments.
- Designed VBA macros and templates to streamline marketing analysis and improve reporting accuracy.
Data Analyst
Sargam India Electronics Private Limited
Delhi
07.2018 - 02.2020
- Prepared sales, inventory, and profit MIS reports and dashboards for business analysis and management insights.
- Created and modified reports in Excel and VBA to improve report presentation and accuracy.
- Extracted, organized, and analyzed operational data from multiple sources for store performance monitoring.
- Developed automation solutions to reduce manual data handling and enhance reporting speed and reliability.
Physical Inventory Auditor
NuFuture Digital (India) Ltd.
Gurugram
08.2017 - 07.2018
- Compiled scanning data from retail stores and uploaded it to the Inventory Management System (IMS).
- Monitored inventory levels, verified physical stock with SAP records, and reconciled discrepancies.
- Removed obsolete products from SAP and prepared detailed inventory reports for management.
- Ensured data accuracy and completeness for all audit and stock control reports.
Education
B.A. (Hons.) - Political Science
Sri Guru Nanak Dev Khalsa College, University of Delhi
Delhi01.2018
12th - Arts
Central Board of Secondary Education
Delhi01.2013
10th -
Central Board of Secondary Education
Delhi01.2011
Skills
- Microsoft Power Automate
- Power BI
- Python
- SharePoint
- VBA and advanced Excel
- API integration
- SQL
- SAP automation
- Web scraping
- Selenium
- VB script
- Java script
- HTML
- CSS
Personal Details
Date of Birth: 26th August 1996
Marital Status: Married
Current Location: Delhi NCR
Languages Known: English, Hindi
Nationality: Indian
Accomplishments
- Exceptional Client Service Award - EY - 2025
- Spot Award - EY -2025
- Spot Award - EY - 2025
Languages Known
Hindi
First Language
English
Proficient (C2)
C2
Timeline
Assistant Manager
EY Global Delivery Services India LLP
08.2022 - Current
Senior Executive
KPMG Global Services Private Limited
04.2022 - 08.2022
Business Analyst
Genpact Limited
12.2020 - 04.2022
Senior MIS Executive
Fincart Investment Planners
02.2020 - 12.2020
Data Analyst
Sargam India Electronics Private Limited
07.2018 - 02.2020
Physical Inventory Auditor
NuFuture Digital (India) Ltd.
08.2017 - 07.2018
B.A. (Hons.) - Political Science
Sri Guru Nanak Dev Khalsa College, University of Delhi
12th - Arts
Central Board of Secondary Education
10th -
Central Board of Secondary Education