Ayush Ranjan Lenka

Data Analyst

Data Analyst with hands-on experience in SQL, Python, and data visualization through internships at CTTC and TATA Virtual Experience. Skilled in Tableau, Power BI, and Excel for extracting actionable insights from complex datasets. Passionate about leveraging analytical skills to drive data-driven decision-making and business growth.

Dhenkanal,Odisha 6a87e42ee4a9524f6395d7b7--ayushranjanlenkaportfolio.netlify.app

Projects

Languages

Skills

Work Experience

Data Analyst Intern

Central Tool Room and Training Centre

May 2026 — Jun 2026Bhubaneswar, Odisha

Analysed 50,000+ records using SQL and Python, extracting actionable insights that improved operational efficiency by 15%.
Developed 5+ interactive dashboards in Tableau, providing real-time visualizations for key performance indicators (KPIs) to stakeholders.
Performed data cleaning and preprocessing on raw datasets, reducing data errors by 20% and improving data quality.
Collaborated with cross-functional teams to identify trends and present data-driven recommendations for strategic decisions.

Virtual Internship - Data Analytics Job Simulation

TATA

Dec 2025 — Jan 2026

Completed a virtual internship simulating real-world data analytics challenges at TATA Group.
Performed data cleaning, manipulation, and exploratory data analysis (EDA) on 10,000+ rows using Python (Pandas, NumPy).
Created data visualizations and presented insights to virtual stakeholders, strengthening communication and storytelling skills.
Identified key business metrics and trends to support decision-making for business growth.

Projects

HR Analytics Dashboard

Power BIMicrosoft Excel

AI powered Voice Assistant

PythonMachine Learning

Capture The Flag Competiton(CTF)

CyberSecurity Fundamentals

Rock Paper Scissors Game

Python Fundamentals

Skills

programming Languages

Python , SQL

Data Visualization

Tableau, Power BI, Microsoft Excel

Data Analysis Libraries

Pandas, Numpy , Matplotlib, Scikit Learn

Databases

MySQL , PostgreSQL

Tools & Platforms

Jupyter Notebook , VsCode, Git , Github

Core Competencies

Data Cleaning ,Exploratory Data Analysis(EDA),Dashboard Management, Data Storytelling, Statistical Analysis,Cyber Security Fundamentals

Education

Bachelor Of Technology (B Tech), Computer Science & Engineering (CSE)

Synergy Institute of Engineering and Technology,Dhenkanal

2023 — Present8.5/10

Relevant Coursework: Data Structures & Algorithms, Database Management Systems (DBMS), Machine Learning, Data Analytics, Python Programming, Statistics

Certificates

Get Started With Microsoft Data Analysis

Microsoft

Data Analysis Using Python

Coursera

Rock Paper Scissors Game Project Completion

Great Learning Academy

Languages

Hindi

Intermediate

English

Intermediate

Odia

Native