Hello, my name is Aditya Pandey
I'm a Data Analyst & Software Developer
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 Policy
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.
Project
Cross-Platform-Film-Analytics: Analysis of IMDb, Amazon, and Netflix film datasets to uncover trends in ratings, sales, and genre distribution.
This project uses SQL to analyze restaurant customer data, answering key business questions and uncovering insights on ordering behavior.
The project built a data pipeline with Python, Snowflake, and AWS S3 to analyze Yelp’s business dataset and perform sentiment analysis.
This project demonstrates how I leveraged various Amazon Web Services (AWS) to build a pipeline for storing, querying, and visualizing order data.
Contact Me
Have You Any Questions?
Call On
+353 894111495
Location
Dublin, Ireland
adityashubhampandey@gmail.com