Available for opportunities

Ayush Ranjan Lenka
turns raw data into decisions.

Data Analyst & final-year B.Tech CSE student, specialized in extracting actionable insights from data — with hands-on experience across SQL, Python, Power BI and Tableau from internships at CTTC and TATA.

8.5
CGPA / 10
2
Internships
3+
Data Projects
4
Core Tools
Ayush Ranjan Lenka
About

Bridging analytics with real business impact

I'm a Data Analyst with hands-on experience gained through internships, specialized in extracting actionable insights from data. I recently completed a Data Analyst Internship at CTTC and a Virtual Experience in Data Analytics with TATA, honing my skills in data manipulation and analysis.

I'm eager to leverage these analytical skills to contribute to impactful, data-driven decision-making — combining a strong CSE foundation with practical fluency in dashboards, queries and visual storytelling.

8.5/ 10.0
Cumulative GPA
Synergy Institute of Engineering & Technology B.Tech, Computer Science & Engineering
Experience

Where the data work happened

DEC 2025 — JAN 2026
Data Analytics Job Simulation
TATA · Virtual Experience Program
  • Analyzed large datasets using SQL and Python, extracting valuable insights to support strategic decision-making
  • Developed and maintained dashboards in Tableau, providing real-time data visualizations for key performance indicators
MAY 2026 — JUN 2026
Data Analyst Intern
CTTC · Bhubaneswar, Odisha
  • Worked on real-world data analytics projects across industrial datasets
  • Performed data cleaning, preprocessing, and visualization to prepare datasets for analysis
  • Collaborated with team members to derive and present actionable insights
Projects

A few dashboards & builds worth a look

📊
HR Analytics Dashboard
Interactive Power BI dashboard tracking workforce composition and attrition to support HR decision-making.
1.4K
Employees Tracked
16%
Attrition Rate
Power BIDAXExcel
View on GitHub →
🎙️
AI-Powered Voice Assistant
A virtual assistant that understands human speech and performs actions accordingly — from answering questions to executing voice commands.
PythonSpeech Recognitionpyttsx3NLP
Source available on request
🧠
The Rise of Artificial Intelligence
A comprehensive presentation covering AI's evolution and future impact — from machine learning and deep learning to NLP, computer vision, and ethics.
ResearchPresentation
Slides available on request
Skills

Tools I use to get from data to decision

MS ExcelAdvanced
TableauAdvanced
Power BIAdvanced
Dashboard ManagementAdvanced
PythonIntermediate
SQLIntermediate
Communication Public Speaking
Certificates

Formal training behind the work

🏅
Get Started With Microsoft Data Analysis
MICROSOFT
🎓
Data Analysis Using Python
COURSERA
Languages

Communicating across the table

🇬🇧
English
Intermediate
🇮🇳
Hindi
Intermediate
🇮🇳
Odia
Native

Let's talk data.

Open to Data Analyst roles, internships and collaborations. Reach out — I usually reply within a day.