Open to opportunities

Ayush Dhakad

@ayushdhakad

Message

Data analyst transforming complex data into actionable insights using SQL, Python, and Tableau.

India

Message

What I'm looking for

I’m looking for a Data Analyst role where I can use SQL, Python, and Tableau to build reliable dashboards and automated reporting, uncover trends with statistical modeling, and help teams make faster, data-driven decisions.

I’m a Data Analyst who turns complex data into actionable insights. I’ve worked across SQL and Python automation, data cleaning/validation, and visualization to support faster business decisions and improve operational efficiency.

In recent roles, I cleaned and validated 40k+ records, reducing missing or inconsistent values by 10–12%, and updated Tableau dashboards that reduced manual reporting effort by 15%. I’ve also analyzed 50k+ sales records to cut stockouts by 15%, automated SQL/Python pipelines to reduce manual reporting time by 25%, and used statistical modeling to improve operational forecasts by 25%.

Experience

Work history, roles, and key accomplishments

Data Analyst

Innodata

Dec 2025 - May 2026 (5 months)

Assisted in cleaning and validating datasets of 40k+ records, reducing missing or inconsistent values before analysis. Wrote SQL queries for weekly reporting and supported updates to Tableau dashboards used by multiple stakeholders.

Data Cleaning Data Validation SQL Data Aggregation Tableau Dashboard Updates Data Visualization

Data Analyst Intern

Innobyte Services

May 2025 - Jul 2025 (2 months)

Conducted analysis on 50k+ sales records to identify trends and improve inventory management by reducing stockouts. Built SQL and Power BI-based recommendations and delivered executive dashboards and KPI reports.

Data Analysis SQL Power BI Inventory Management Customer Segmentation KPI Reporting Data Visualization

Data Analyst

Bank of Scotland

Sep 2023 - Mar 2024 (6 months)

Automated data pipelines with SQL and Python, reducing manual reporting time. Developed interactive Tableau dashboards and improved operational forecasts using statistical modeling.

SQL Python Data Pipelines Tableau Statistical Modeling Forecasting Process Optimization

Data Analyst

Outlier AI

Dec 2022 - Jun 2023 (6 months)

Created and tested basic prompts for large language model tasks including summarisation, classification, and data extraction. Wrote Python scripts and SQL queries to prepare datasets, generate prompt variations, and document testing steps to improve reliability.

LLM Prompt Engineering Prompt Testing Summarization Classification Data Extraction Python SQL

Python Developer Intern

Orinova Innovation Technology

May 2021 - Sep 2021 (4 months)

Automated Python workflows to improve data processing efficiency and contributed to client applications. Implemented unit testing and validation scripts to lower defects.

Python Workflow Automation Data Processing Unit Testing Software Development

Education

Degrees, certifications, and relevant coursework

University of Strathclyde

Master of Science, Advanced Computer Science with Data Science

Activities and societies: Member of the Indian Student Association (SISA).

Completed an M.Sc. in Advanced Computer Science with Data Science at the University of Strathclyde, with coursework covering machine learning, big data analytics, statistics, deep learning, and distributed systems.

Jaypee University of Engineering and Technology

Bachelor of Technology, Computer Science and Engineering

Activities and societies: Member of the University Basketball Club (inter-year tournament runner-up).

Completed a B.Tech in Computer Science and Engineering at Jaypee University of Engineering and Technology, including projects such as a Home Automation System (Arduino & Firebase) and Python applications (Tic-Tac-Toe, phone directory).