Hello, my name is Aditya Pandey
I'm a
Data Analytics MSc student at NCI with 3+ years at Accenture, crafting ETL pipelines, Power BI dashboards, and SQL solutions. Skilled in Python, Snowflake and AWS, I’m driven to transform data into actionable insights.
Contact Me
About Me
I'm Aditya Pandey, Data Analyst & Software Developer
Currently pursuing an MSc in Data Analytics at NCI, I bring over 3 years of experience from Accenture, specializing in .NET, SSIS, and SQL development. My expertise spans ETL processes, data visualization with Power BI, and Python-based analytics, with a passion for AI and Explainable AI (XAI) to drive business efficiency in pharmaceuticals and insurance.
Email: adityashubhampandey@gmail.com
Phone: +353 894111495
Location: Dublin, Ireland
LinkedIn: linkedin.com/in/aditya-pa
GitHub: github.com/aditya-pa
Visa: Stamp 2, Eligible for 1G Visa Oct 2025
Experience
Data Analyst, Accenture - Pharmaceutical Client
Aug 2023 - Aug 2024
- Developed SSIS ETL pipelines processing 15,000+ records daily, enabling real-time analytics for pharma clients.
- Built Power BI dashboards, improving management decisions by 25% through enhanced metric visibility.
- Optimized SQL queries, reducing execution time by 30% for enterprise applications.
- Automated data workflows with Python, cutting manual effort by 40% and saving 12 hours weekly.
- Led data transfers with vendors, ensuring compliance for 10+ critical datasets.
- Collaborated with cross-functional teams to deliver data solutions, reducing ServiceNow tickets by 90%.
Associate Software Engineer, Accenture - Insurance Client
Aug 2017 - Aug 2023
- Built SQL queries to process insurance data, improving retrieval speed by 35% across 20+ systems.
- Configured ETL workflows to handle 7,000+ daily transactions, supporting efficient reporting.
- Utilized AWS S3 and Athena to store and query datasets for stakeholder analytics.
- Developed Python scripts to automate data preprocessing, reducing manual effort by 15%.
- Performed technical reviews, resolving 60+ defects to ensure data accuracy.
Skills
Python
Pandas
NumPy
SQL Server
Power BI
Excel
.NET
Visual Studio
AWS
Snowflake
Docker
Duck Creek
Education
MSc in Data Analytics
Sep 2024 - Sep 2025
National College of Ireland
Modules: Statistics, Data Governance, Business Intelligence, Machine Learning, Deep Learning, Generative AI
Research: Hybrid AI for Airbnb pricing; SLM-based customer support automation; ML model comparison.
B.Tech in Computer Science & Technology
Aug 2017 - Aug 2021
Noida Institute of Engineering and Technology
First Class Honors (1:1)
Modules: Data Structures, Operating Systems, Software Engineering, Database Management, AI
Services
Data Analytics
Providing insights through data mining, machine learning, and visualization using Python and Power BI.
Software Development
Building robust applications with C#, .NET, and Duck Creek for insurance and pharmaceutical industries.
ETL & Automation
Designing and optimizing ETL pipelines with SSIS and automating workflows to enhance efficiency.
Business Intelligence
Creating interactive dashboards and reports to support data-driven decision-making.
Featured Projects
Comprehensive analysis of IMDb, Amazon, and Netflix film datasets to uncover trends in ratings, sales, and genre distribution across multiple streaming platforms.
Comprehensive analysis of Walmart Brazil's sales decline using advanced analytics, machine learning for delay prediction, and interactive dashboards.
Automated banking complaint classifier using DistilBERT transformer model, achieving 87% accuracy on CFPB data with production deployment.
Advanced SQL analysis of restaurant customer data to answer key business questions and uncover insights on ordering behavior and customer preferences.
Built comprehensive data pipeline with Python, Snowflake, and AWS S3 to analyze Yelp's business dataset and perform sentiment analysis.
Leveraged various Amazon Web Services to build a comprehensive pipeline for storing, querying, and visualizing order data in real-time.
Get In Touch
Let's Connect
I'm always excited to discuss new opportunities, innovative projects, or simply have a chat about technology and data analytics.
adityashubhampandey@gmail.com
Phone
+353 894111495
Location
Dublin, Ireland