About Me
Hi there! I'm Aaditya Singh, and I am an Analyst👋Recent Data Science graduate with hands-on experience in analytics, dashboard development, workflow automation, and data-driven problem solving.I’ve worked on academic and real-world projects across education, product, cloud platforms, and machine learning.I’m passionate about building solutions that improve efficiency and create meaningful business impact.
Skills
Data Cleaning | Querying | Automation | Dashboarding
PowerBI | Tableau | Excel
UiPath | Power Automate
Python | SQL | Java
Git | Docker | GCP | AWS
Featured Projects
Ecommerce Analytics Pipeline
BigQuery | Cloud Run | Looker Studio
End-to-end serverless data pipeline on Google Cloud Platform using BigQuery, Cloud Run, Vertex AI, and Looker Studio.
Machine Learning
Python | sklearn
Implemented end-to-end regression and classification models using Scikit-learn, including preprocessing, model training and evaluation.
Token Classification
Python | NLP
Token classification for abbreviation and long-form detection using RoBERTa.
Zomato Dashboard
POWER BI | Excel | SQL
Created a Power BI dashboard to help understand and visualize restaurant data, orders, revenue, ratings, and trends.
Excel automation bot
Excel | Python
Interactive tool for selecting Excel sheets and columns, enabling customizable data export with ease.
IMDB analysis
Excel | Powerpoint
Using Excel for data cleaning, pivot tables, and analysis of IMDB data to identify trends.
Internship Experiences
IT Admin, Lees Buckley and Co.
01-05-2025 - Present
Product Intern, Rubix Data Sciences
16-09-2024 To 16-12-2024
Business Analyst Intern, Vibgyor Vertex
14-06-2024 To 13-09-2024
Summer Intern, NHITM
01-06-2023 To 07-07-2023
Python | Excel
excel automation bot
This is my first project at Rubix Data Sciences, where I created an application to traverse large Excel files and simplify the process for users to easily select multiple sheets and columns, then save them into a new file.Technologies used:
1) Python Libraries-
Pandas, Customtkinter, Tkinter, pyinstaller
2) ExcelFeatures:
1) File Selection: It prompts the user to select an Excel file (with .xlsx or .xls extension).
2) Sheet Listing: After the file is selected, it loads the sheet names and displays them in a Listbox. The sheet names are grouped alphabetically by their starting letter (A, B, C, etc.) to make it easier for the user to browse.
3) Multiple Sheet Selection: The user can select multiple sheets from the list.
4) Column Selection: Once sheets are selected, the program opens a new window where the user can choose specific columns from the selected sheets. It shows the columns of each sheet for easy selection.
5) Download Selected Data: After selecting the desired columns, the user can click a "Download" button to save the selected columns into a new Excel file, with each sheet containing only the selected columns.
Certificate Received
RPA | Power bi | EXCEL
Robo Cura |
Sales and marketing dashboard
During my internship at Vibgyor, I worked on two key projects focused on automation, data management, and business intelligence. These projects aimed to enhance operational efficiency through data automation, organization, and visualization.Project 1: Sales and Marketing Power BI DashboardTechnologies used:
1) Power BIFeatures:
This project focused on leveraging Power BI to create a comprehensive dashboard for sales and marketing insights.1) Sales Data Integration – Consolidated sales data from multiple sources for a unified view.
2) Visual Analytics – Developed interactive dashboards to track sales performance.
3) Marketing Campaign Analysis – Conducted a detailed analysis of marketing campaigns to measure effectiveness.
4) Real-time Reporting – Implemented real-time data updates for timely decision-making.Project 2: Robo Cura | Automation of Data Collection and DistributionTechnologies used:
1) UiPath (RPA)
2) Windows Task SchedulerFeatures:
1) Automated Data Collection
Built a web scraping system to extract data from multiple specified portals daily.
2) Data Renaming & Organization
Automated logic to rename files consistently and organize them into proper folders.
3) Data Transfer
Designed workflows to seamlessly move files to the designated data lake.
4) Email Distribution
Set up auto-email dispatch with attachments and context-aware messaging to stakeholders.Outcomes & Impact:
Once implemented across teams, ROBO CURA delivered:
🕒 2000+ hours saved per year
💸 £55,000 in cost savings
🧠 Zero manual errors
📧 Emails and dashboards with clear, automated summaries
⏱️ Reports delivered before 7 AM — every day
Certificates Received
Appreciation from CEO
Python
AI in advertisement
I worked on a Deep Learning-based Audience Analysis Model for advertising hoardings as part of my five-week Summer Internship at NHITM.Project: Audience Analysis for Advertising Hoardings using Deep LearningTechnologies Used:
1) Deep Learning Framework - YOLO from Darknet
2) Programming Language - PythonFeatures:
1) Real-time Audience Detection – Identifies viewers in front of the hoarding using YOLO.
2) Gender Classification – Detects and classifies the gender of viewers with 80% accuracy.
3) Engagement Duration Tracking – Measures how long a person looks at the advertisement.
4) Custom Deep Learning Model – Designed a 314-layer model for accurate detection and analysis.
5) Optimized for Advertising Analytics – Helps advertisers understand audience demographics and engagement patterns.
Certificates Received
LOR
LOR from Head of Department: AI
