E Email : itarvind0911@gmail.
com
ARVIND KUMAR Phone No. : +91-8960199585
Linkedin.com/in/arvind-kumar-gupta-217061244
GUPTA
Experience | Internships
PwC Switzerland [Link] Sep/2023- April/2024
PowerBI Virtual Internship
● Visualized HR Data: Created visualizations to effectively represent HR data, with a specific emphasis on gender-related Key
Performance Indicators (KPIs).
● Root Cause Analysis for Gender Balance: Identified and analyzed potential root causes contributing to the slow progress in
achieving gender balance, particularly at the executive management level.
● Learnings: Gained insights into the complexities surrounding gender balance in the workplace, including factors influencing
representation at senior management levels and potential strategies for improvement.
Geekster | Geekster Data Analytics Bootcamp
● Solved 20+ case studies using Excel, PowerBI and SQL
● Worked on various projects like Zomato Sales Analysis, Credit Card Default Analysis
● Technical Stack Learned :Excel, PowerBI and SQL
Projects
Zomato Sales Analysis [Github Link ]
● Process: Implemented a robust data collection methodology using API integration and web scraping, followed by meticulous data
cleaning and preprocessing to ensure accuracy. Utilized a structured analysis workflow to generate insights effectively.
● Insights: Uncovered peak ordering times and popular cuisines through comprehensive data analysis. Conducted segmentation
analysis to discern customer preferences and extracted actionable insights to optimize sales strategies.
● Tools Used: Leveraged Excel for initial data processing, PowerBI for visualization, and SQL for advanced data querying and
manipulation
Swiggy Food Price Analysis [Github Link]
● Process: Implemented robust data collection via API integration and web scraping. Ensured accuracy through meticulous data
cleaning and preprocessing. Employed a structured analysis workflow.
● Insights: Uncovered peak ordering times and popular cuisines. Conducted segmentation analysis for customer preferences.
Extracted actionable insights for sales optimization.
● Tools Used: Utilized Excel for initial data processing, PowerBI for visualization, and SQL for advanced data querying and
manipulation.
Skills
● Computer Language : Python , SQL
● Frameworks / Libraries : Pandas, numpy, matplotlib etc
● Tools & Technologies : Google sheet, Power BI, SQL workbench google colab
● NIELT : O LEVEL COMPLETED (2022)
● NIELT: COURSE OF COMPUTER CONCEPT (2023)
Education
Year Degree/Examination Institution/ Board CGPA/Percentage
2019 Bachelor of Art MGKVP 50%
2016 12th UP 83.00%
2014 10th CBSE 6.8 CGPA
Achievements and Co-Curricular Activities
● Scored rank _ in geekster hackathon conducted
● Secured 13 rank in Geekster’s coding challenge May 2024
● Coordinated tech event logistics at the Institute of Science & Technology, ensuring seamless execution.
Add Ons [Must be on Top] –
** can add multiple Virtual Internships
- https://www.theforage.com/simulations/accenture-nam/data-analytics-mmlb
- https://www.theforage.com/simulations/tata/data-visualisation-p5xo
- https://www.theforage.com/simulations/pwc-ch/power-bi-cqxg
- https://www.theforage.com/simulations/excel skills for bussiness-goldmanSachs
- https://www.theforage.com/simulations/Data Science job-BCGX
- https://www.theforage.com/simulation/introduction to data science job-commanwealth Bank
Projects Format
Project [Link]
● Process :
● Insights :
● Tools Used :
Achievements and Co-Curricular Activities
● For awards/achievement
○ Hackerrank track - Solve questions, get stars mention it in resume
○ Kaggle - Appear for contests and gain rating on kaggle
○ Participate in virtual Internship/ Hackathon
● Mention participation and involvement in any society/activity.
● Example: Volunteered for fests/ Dance competition/Organised an event etc.
