Divjot Pahwa
New Delhi
Summary
To excel as an IT expert by leveraging hands-on experience with RPA tools like Automation Anywhere, Python, and dashboard creation. As an Analyst with 1.5 + years of experience, I’ve successfully automated processes and developed impactful dashboards. Known for productivity, communication, and teamwork, I’m committed to continuous growth and contributing to organizational success.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Analyst
Ernst & Young LLP (EY)
Gurugram, Haryana
02.2023 - Current
- Automation & Robotic Process Automation (RPA): Designed and implemented automated solutions for complex data tasks using Python, Automation Anywhere, and basic UI Path. Developed a system to automatically read and extract invoice data, create purchase registers, and reconcile with GSTR 2B. This system ensures accurate GST calculations for employee air travel, helping clients claim the correct GST on monthly returns.
- Invoice Retrieval Automation: Created an automated system to retrieve invoices from airline portals and send email requests when portal access was unavailable. This solution reduced manual effort, minimized errors, and improved processing accuracy and timeliness.
- Excel & Python Integration: Integrated Python with Excel to automate tasks like data validation, reconciliation, and report generation. Developed macros and scripts that improved workflow efficiency, reduced manual effort, and enhanced data accuracy.
- Prompt Engineering: Experienced in prompt engineering with AI, including using GPTs and other AI tools. Proficient in writing effective prompts and applying them in various projects, demonstrating hands-on expertise in this area.
- Data Visualization & Dashboards: Created Excel and Power BI dashboards to visually represent complex data, helping clients make data-driven decisions with clear, actionable insights.
- Managed Services & Client Communication: Key player in managed services, delivering automated solutions that boosted client satisfaction and efficiency. Maintained strong client communication, providing tailored solutions and clear, actionable insights.
- Tools & Technologies: Proficient in RPA tools (Automation Anywhere, UI Path), Python, Excel automation (macros, VBA), Power BI, and data reconciliation techniques. Consistently leveraged these tools to drive process improvements, streamline operations, and deliver high-value outcomes for clients.
- GST Expertise: Possess extensive knowledge of GST, including hands-on experience with GSTR 2B reconciliations, integration with purchase registers, and familiarity with PAN details and the GST portal.
INTERNSHIP PROGRAM
INTERN AT ERNST & YOUNG
Gurugram
09.2022 - 11.2022
- Robotic process automation (RPA), Automation anywhere 360, IQ bot - During my internship in IT, I gained practical experience in Robotic Process Automation (RPA) using tools like Automation Anywhere 360 and IQ Bot. I worked on automating business processes to enhance operational efficiency. Additionally, I developed knowledge in GST processes, including monthly GSTR 2B, return filing, and reconciliation, further broadening my understanding of financial and compliance tasks within the industry.
SUMMER INTERNSHIP PROGRAM
ISN Electronic Tender Service Pvt.
Gurugram
07.2020 - 08.2020
- ISN Electronic Tender Services (ISN-ETS) is a eTendering/eProcurement/e-Auction Service Provider which has setup and manages the portal Bharat-Electronic Tender certified by STQC (MeitY, Govt
- Of India)
- Reputed Government & Public Sector organizations are using this portal for conducting their e-Tenders/eAuctions with unquestionable integrity.
Education
B.TECH (COMPUTER SCIENCE & ENGINEERING) -
PDM University
Bahadurgarh, Haryana07.2022
12TH CLASS (NON-MEDICAL SCIENCE) (CBSE) -
St. Cecilias Public School
Vikaspuri, New Delhi03.2018
10TH CLASS (CBSE) -
St. Cecilias Public School
Vikaspuri, New Delhi03.2016
Skills
- RPA (Robotic process automation)
- Python
- Prompt Engineering
- Automated testing
- MS Excel
- IQ Bot
- Macros
- Power BI
- SQL
- Object Oriented Programming
- Documentation And Reporting
- Project Management
- Business Intelligence
- Account Reconciliation
- Data Modeling
- Analytical Skills
- Active Listening
- Excellent Communication
- Multitasking
- Data Visualization
Projects
- Attendance Monitoring with Face Recognition in Python
- Flappy Bird Game In PyGame using Python
- Airlines Reservation System in C++ & SQL
Languages
- ENGLISH, Professional Working Proficiency
- HINDI, Native or Bilingual Proficiency
- FRENCH, Limited Working Proficiency
- PUNJABI, Full Professional Proficiency
Certification
- Data Integration Bronze Learning Badge
- Microsoft Excel: Advanced Excel Formulas & Functions - Udemy
- Microsoft Excel: Data Analysis with Excel Pivot Tables - Udemy
- Microsoft PowerPoint From Beginner to Advanced - Udemy
- How to ChatGPT: Master the Art of Prompt Engineering - Udemy
- SAP - ABAP
- Full Stack Web Development BootCamp, 05/2021, 08/2021, UC-7bd139ea-ba1b-40ef-96ac-1dde489455ce, ude.my/UC-7bd139ea-ba1b-40ef-96ac-1dde489455ce, 0004
- Python BootCamp, 05/2020, 09/2020, UC-d34765bO-3448-4fa4-b5aO-c26feOe1Oc8d, ude.my/UC-d34765bO-3448-4fa4-b5aO-c26feOe1Oc8d
Hobbies and Interests
- Surfing Internet
- Watching Cricket
- Listening Music
Extracurricular Activities
- Volunteering with Orphanage Children: Actively engage in educational and recreational activities with children in an orphanage. This role has developed my interpersonal skills, empathy, and organizational abilities while making a positive impact in the community.
- Participated in Robot Race competition.
Timeline
Analyst
Ernst & Young LLP (EY)
02.2023 - Current
INTERNSHIP PROGRAM
INTERN AT ERNST & YOUNG
09.2022 - 11.2022
SUMMER INTERNSHIP PROGRAM
ISN Electronic Tender Service Pvt.
07.2020 - 08.2020
B.TECH (COMPUTER SCIENCE & ENGINEERING) -
PDM University
12TH CLASS (NON-MEDICAL SCIENCE) (CBSE) -
St. Cecilias Public School
10TH CLASS (CBSE) -
St. Cecilias Public School
- Data Integration Bronze Learning Badge
- Microsoft Excel: Advanced Excel Formulas & Functions - Udemy
- Microsoft Excel: Data Analysis with Excel Pivot Tables - Udemy
- Microsoft PowerPoint From Beginner to Advanced - Udemy
- How to ChatGPT: Master the Art of Prompt Engineering - Udemy
- SAP - ABAP
- Full Stack Web Development BootCamp, 05/2021, 08/2021, UC-7bd139ea-ba1b-40ef-96ac-1dde489455ce, ude.my/UC-7bd139ea-ba1b-40ef-96ac-1dde489455ce, 0004
- Python BootCamp, 05/2020, 09/2020, UC-d34765bO-3448-4fa4-b5aO-c26feOe1Oc8d, ude.my/UC-d34765bO-3448-4fa4-b5aO-c26feOe1Oc8d
Similar Profiles
Sarath Chandra SrimankandadaiSarath Chandra Srimankandadai
Manager at Ernst & Young LLP, EYManager at Ernst & Young LLP, EY
Palak DesaiPalak Desai
Intern at Ernst & Young LLP (EY)Intern at Ernst & Young LLP (EY)
Mactar SarrMactar Sarr
Account Manager at Ernst & Young LLP (EY)Account Manager at Ernst & Young LLP (EY)