Abhinav Shandilya
(--abhinavshandilya13/portfilio | linkedin.com/in/abhinavshandilya03 | github.com/AbhinavShandilya13
Education
SRM University
Bachelor of Technology | CGPA: 8.2/10
Montfort Senior Secondary School
Secondary High School | Percentage: 86
Chennai, India
Sep. 2021 – Aug 2025
Roorkee, India
2021
Experience
Python Developer Intern
Jul 2023 - Aug 2023
Code Clause
India
• Implemented a Flappy Bird clone:
Engineered core functionalities of a Flappy Bird-style video game within six weeks, focusing on unique aspects like
realistic physics simulations for bird movements and precision-based collision detection to achieve smoother
gameplay flow.
Research Intern
Jun 2023 - Jul 2023
National Institute of Hydrology
Roorkee, India
• Geospatial Data Manipulation Expertise:
Focused on Geotiff file processing, leveraging GDAL for geospatial data extraction, transformation, and analysis.
Mastered techniques for handling spatial referencing, projections, and raster data manipulation, enhancing
geospatial data science skills.
• Proficient in Geospatial Analysis Tools:
Utilized GDAL, Matplotlib, Python, and NumPy for comprehensive geospatial data analysis and visualization.
Analyzed and executed scripts for automated geospatial data processing, ensuring accurate and efficient data
handling.
AI/ML Intern
Aug. 2024 – Oct. 2024
Central Building Research Institute
India
• Created and integrated an energy prediction model into a Flask web application, allowing users to input dates and
predict energy consumption using machine learning algorithms and real-time data processing.
• Troubleshoot data issues, optimized the CSV input process and ensured accurate predictions by refining the
machine learning model, enhancing the application’s efficiency and reliability.
Projects
COVID DATA ANALYSIS AND VISUALIZATION | SQL,Tableau,Git
Jul 2024 – Aug 2024
• Conducted an in-depth analysis of COVID-19 data using SQLto explore infection rates, death percentages, and
vaccination coverage globally. Utilized advanced SQL techniques and created are usable SQL view for population
vaccination analysis and visualized the results using Tableau for comprehensive insights.
Data Analysis Project: Bike Dashboard | SQL, Power Bi, Git
May 2024 – July 2024
• Implemented a SQL database from Excel files, connected it to Power BI, and created a dynamic dashboard
displaying key metrics such as hourly revenue, trends, and demographics. Delivered actionable insights and
recommendations for pricing strategies. Tools: SQL Server, SSMS, Power BI, Excel.
Airbnb Listings 2016 Data Analysis | SQL, Tableau, Kaggle, Git
Aug 2024 – Oct 2024
• Analyzed over 3,000 Airbnb listings from the 2016 dataset using Tableau to create a dynamic dashboard visualizing
key insights such as average prices per bedroom, pricing variations by zip code, and yearly revenue trends.
• Improved expertise in data cleaning, analysis, and visualization using real-world datasets, published the project on
Tableau Public.
Technical Skills
Languages: Python, C, HTML/CSS,
Frameworks: Flask, Django, Tkinter, Keras, Scikit-learn, Pygame
Developer Tools: SQL, Git, Jupyter Notebook, Tableau, VS Code, Visual Studio, PyCharm
Libraries: pandas, NumPy, Matplotlib
Soft Skills
•
•
•
•
•
Problem-Solving
Communication
Team Collaboration
Adaptability
Time Management
Certifications
•
Accenture North America Data Analytics and Visualization Job Simulation on Forage
∗ Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture
∗ Cleaned, modeled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions
∗ Prepared a PowerPoint deck and video presentation to communicate key insights for the client and internal
stakeholders
•
J.P. Morgan Software Engineering Virtual Experience on Forage
∗ Set up a local dev environment by downloading the necessary files, tools and dependencies.
∗ Fixed broken files in the repository to make web application output correctly.
∗ Used JPMorgan Chase’s open source library called Perspective to generate a live graph that displays a data
feed in a clear and visually appealing way for traders to monitor.
•
Harvard CS50 Python Programming Certification
∗ Completed CS50’s Introduction to Programming with Python – Gained proficiency in Python through nine
problem sets and a final project, awarded by Harvard University.
∗ Developed Strong Problem-Solving Skills – Tackled complex programming challenges involving algorithms,
data structures, and Python best practices.
∗ Earned Recognition for Technical Expertise – Demonstrated a high level of commitment and programming
ability by earning certification from Harvard’s esteemed CS50 program.
•
IBM SQL for Data Science Certification
∗ Completed IBM’s SQL for Data Science Course – Gained expertise in database querying, data manipulation,
and analytical problem-solving using SQL.
∗ Mastered Practical Data Science Applications – Applied SQL to analyze datasets, generate reports, and derive
actionable insights for data-driven decision-making.
∗ Recognized for Excellence in SQL and Data Science – Earned certification from IBM’s AI and Data Science
Program, validating strong skills in database management.
Leadership
•
Admin HackTheBox SRMIST - In my capacity as SRM University’s HackTheBox club administrator, I
planned cybersecurity competitions, led ethical hacking seminars, and promoted a cooperative atmosphere for
students with an interest in cybersecurity. I built a strong cybersecurity community on campus by organizing
events, overseeing team resources, and helping club members gain practical experience in network security and
penetration testing.
•
Assistant Lead TedxSRMIST - As the assistant lead of the creatives domain for TEDxSRMIST, I
contributed to event branding, designed promotional materials, and supported the visual storytelling of TEDx
talks. I collaborated with the team to create cohesive and impactful designs that aligned with the event theme,
enhancing audience engagement and the overall TEDx experience.
