root@tekcan:~# ./portfolio.sh
[PIPELINE: ACTIVE // QUERY_ENGINE: READY]

Hi, I'm Buğra Enes Tekcan

> Junior Data Analyst

Launch Shell View Projects
● ● ● tekcan@analyst-node:~$
bash

tekcan@node:~$ whoami

Junior Data Analyst

tekcan@node:~$ uptime

24/7 learning, querying datasets & building Python scripts

tekcan@node:~$ status

Ready to crunch data, write clean code & collaborate.

guest@visitor:~$
/* SECTION 01 */

# About Me

I am a Junior Data Analyst driven by a passion for problem-solving and extracting strategic insights from complex datasets.

Through my projects focusing on business intelligence and customer behavior, I transform raw data into actionable reports that accelerate decision-making processes. I actively utilize SQL, BigQuery, and Python (Pandas) for data cleaning, manipulation, and advanced querying, translating this data into dynamic dashboards using Tableau and Power BI.

My goal is to contribute to data-driven projects that enhance operational efficiency and drive company growth.

03+ Completed Data Projects
100% Passion for Data & Learning
system_specs.json ACTIVE 
{
  "operator": "Bugra Enes Tekcan",
  "location": "Turkiye / Remote",
  "primary_languages": [
    "Python", "SQL" 
  ],
  "data_stack": [
    "PostgreSQL", "BigQuery", 
    "Pandas", "Seaborn"
  ],
  "bi_tools": [
    "Tableau", "Power BI",
    "Google Sheets", "Amplitude"
  ],
  "focus": [
    "Data Analysis",
    "Business Intelligence",
    "Financial & RFM Modeling"
  ],
  "status": "Ready for Junior Roles"
}
/* SECTION 02: INTERACTIVE SHELL */

Terminal Simulation

Type commands below like a real unix environment. Try help, about, skills, projects, contact, or clear.

● ● ● visitor@tekcan-terminal:~
bash 3.2.57
Welcome to TekcanOS v2.4.1 (x86_64-pc-terminal)
Type help to list available commands.
visitor@tekcan-terminal:~$ cat welcome_msg.txt

System initialized securely. Explore portfolio modules via prompt or navigation.

visitor@tekcan-terminal:~$
/* SECTION 03 */

# Technical Arsenal

Advanced

SQL / PostgreSQL

Complex queries, multi-table joins, schema design & dataset extraction.

Proficient

Python (Pandas)

Data cleaning, transformation, exploratory data analysis and automation.

Proficient

BigQuery

Large-scale cloud database querying, cost optimization and aggregations.

Advanced

Google Sheets

Advanced formulas, pivot tables, modeling, and data structuring.

/* SECTION 04 */

# Featured Projects

BIST Analysis
Preview Screenshot
finance

BIST Market Analysis

Extracted and cleaned financial data from Borsa Istanbul, executing periodic return computations and performance evaluations via Pandas.

Python Pandas Finance
Repository Inspect
RFM Segmentation
Preview Screenshot
analytics

Superstore RFM Analysis

Evaluated consumer behavior and loyalty across retail datasets by formulating SQL queries for RFM segmentation and cohort insights.

SQL BigQuery RFM
Repository Inspect
BI Dashboards
Preview Screenshot
bi

Interactive BI Dashboards

Transformed raw operational metrics into interactive decision-support dashboards using Tableau Public and Power BI environments.

Tableau Power BI Data Viz
Repository Inspect
/* SECTION 05 */

# Milestones & Changelog

Data Analytics & BI Portfolio

2026 — PRESENT // v2.0
GitHub / Open Source (Remote)

Developed and published financial market analysis repositories (BIST 30) and customer RFM segmentation projects utilizing Python, SQL, and Tableau.

Intensive Data Analytics Training

2025 — 2026 // v1.5
Professional Program & Certifications

Completed an extensive data analytics training program, gaining hands-on proficiency in data manipulation, visualization, relational databases, and querying datasets.

Data Exploration & Tooling Foundations

2024 — 2025 // v1.0
Analytical Foundations

Built strong fundamentals in data querying, spreadsheet modeling, and version control protocols. Focused on mastering SQL databases and exploratory data analysis techniques.

/* SECTION 06: TRANSMISSION */

Establish Data Connection

Send a data query dispatch or connect directly via professional nodes.

EMAIL_ADDRESS:

bugraenes@tekcan.me

PYTHON_ANALYTICAL_SIGNATURE:
import pandas as pd
# Data Pipeline Active
df = pd.read_sql("SELECT * FROM junior_analyst")
status = "READY_FOR_HIRE"
SOCIAL_NODES: