Koukuntla Shiva Darshan — Aspiring Data Engineer & Data Analyst

// ABOUT_ME PLAYER PROFILE

👨‍💻

shiva@portfolio ~ $ cat about.txt

$ whoami

$ cat location.txt

📍 Hyderabad, India

$ cat status.txt

🟢 Open to opportunities | Immediate availability | Ready to learn & grow

$ cat interests.txt

📊 Data Analytics · 🛠️ Data Engineering · 💻 Web Development · ☁️ Cloud Technologies · 🏏 Kabaddi

// SKILL_TREE STATS

🗄️ CORE DATA SKILLS

SQL (Joins, Subqueries, Group By, CTEs) XP 750/1000

Python (Pandas, NumPy, Basics) XP 700/1000

Excel (VLOOKUP, Pivot Tables, Charts) XP 800/1000

Data Cleaning & Preprocessing XP 650/1000

ETL Concepts & Data Pipelines XP 550/1000

💻 PROGRAMMING

Python (Core, OOP, Scripting) XP 720/1000

SQL (MySQL, PostgreSQL) XP 750/1000

JavaScript (ES6 Basics, DOM) XP 550/1000

HTML & CSS XP 650/1000

Git & GitHub XP 600/1000

📊 VISUALISATION & REPORTING

Power BI (Dashboards, Basic DAX) XP 650/1000

Tableau (Basic Visualisations) XP 500/1000

Matplotlib & Seaborn XP 600/1000

Excel Charts & Reporting XP 700/1000

🌱 LEARNING & GROWING

AWS (Cloud Fundamentals) XP 400/1000

Azure (AZ-900 Studying) XP 350/1000

Apache Spark (Exploring) XP 300/1000

Docker (Basics) XP 300/1000

Databricks (Awareness) XP 250/1000

// QUEST_LOG EXPERIENCE

⬢ LEVEL 2 — CURRENT QUEST

Data Analyst (Intern)

Labmentix

📍 Bengaluru, Karnataka | Jul 2025 – Present

Built Power BI dashboards to monitor airline operational data quality and delay patterns, improving compliance team visibility.
Validated and cleaned datasets using Python (Pandas) and SQL, ensuring accuracy and consistency across multiple data sources.
Wrote SQL queries to extract and analyze data, supporting audit-ready reporting pipelines.
Assisted in establishing data documentation practices including data lineage tracking.
Collaborated with team members to translate business requirements into structured data quality rules.

⬢ LEVEL 1 — COMPLETED

Data Science & Analytics Intern

Zidio Developers

📍 Bengaluru, Karnataka | May 2024 – Aug 2025

Designed SQL queries for demand-supply reporting and trend visualisation across multi-city ride-request datasets.
Cleaned and standardised raw data using Python (Pandas), implementing basic data quality checks.
Built simple ETL workflows using Python and SQL to transform raw data into structured reports.
Created data visualisations using Matplotlib and Seaborn to present findings to stakeholders.
Gained hands-on experience with the complete data lifecycle — from ingestion to reporting.

// ACHIEVEMENTS PROJECTS

★ ACHIEVEMENT CARD ★

E-Commerce SQL Analytics Project 🔗

Built a MySQL database with 15+ tables, wrote analytical queries using joins, subqueries, and CTEs. Created stored procedures for customer segmentation and sales reporting.

SQL MySQL Python JavaScript

[ HOVER TO FLIP ]

QUEST DETAILS

Designed a normalised database schema with 15+ tables for an e-commerce platform.
Wrote 30+ SQL queries using CTEs, subqueries, and aggregate functions for sales analysis.
Created stored procedures for RFM customer segmentation and automated reporting.
Built a JavaScript-based ER diagram visualiser for documentation.
Tools: MySQL, Python, JavaScript, Git

★ ACHIEVEMENT CARD ★

Banking Risk Analytics Dashboard

Conducted exploratory data analysis on loan portfolio datasets using Python (Pandas). Built Power BI dashboards to visualise credit risk KPIs and default trends.

Python Pandas SQL Power BI

[ HOVER TO FLIP ]

QUEST DETAILS

Cleaned and preprocessed loan data using Python (Pandas, NumPy).
Performed EDA to identify risk patterns and default drivers.
Created Power BI dashboards showing credit risk KPIs and portfolio health metrics.
Tools: Python, Pandas, SQL, Power BI, Excel

★ ACHIEVEMENT CARD ★

Python Data Automation Scripts

Developed Python scripts to automate repetitive data tasks — file processing, data cleaning, report generation — and used scheduling for daily execution.

Python Pandas SQL Excel

[ HOVER TO FLIP ]

QUEST DETAILS

Built Python scripts to read CSV/Excel files, clean data, and generate summary reports.
Used Pandas for data transformation and SQLAlchemy for database interactions.
Automated daily report generation, reducing manual effort.
Tools: Python, Pandas, SQLAlchemy, Excel

// ORIGIN_STORY EDUCATION

◆ CHARACTER ORIGIN ◆

B.Tech — Computer Science & Engineering (Data Science)

KG Reddy College of Engineering & Technology, JNTUH — Hyderabad

2020 – 2024

Specialised in data science, database systems, and software engineering with a focus on practical data skills.
Completed coursework in SQL, Python, Data Structures & Algorithms, Machine Learning, and Statistics.
Led Kabaddi team to championship victory as Captain, demonstrating leadership and teamwork under pressure.
Self-learning: Microsoft Azure Data Fundamentals (AZ-900), Power BI, and advanced SQL techniques.
Eager to learn: Apache Spark, Airflow, and cloud data engineering tools through projects and certifications.