-- =============================================================
-- Eki's Career Database (The Human-Readable Edition)
-- Database: eki_awesome_career
-- Purpose: 18+ years of impact, stored for your convenience
-- =============================================================
CREATE DATABASE eki_awesome_career;
USE eki_awesome_career;
-- The main character table
CREATE TABLE eki_profile (
id INT PRIMARY KEY DEFAULT 1,
name VARCHAR(100) DEFAULT 'Eki (Eqbal Quran)',
current_role VARCHAR(150) DEFAULT 'Chief Technology Officer',
experience_years DECIMAL(3,1) DEFAULT 18.5,
superpower_level ENUM('Good', 'Great', 'Epic', 'Legendary') DEFAULT 'Legendary',
location VARCHAR(100) DEFAULT 'Amman, Riyadh, Remote Worldwide',
email VARCHAR(100) DEFAULT 'info@eqbalq.com',
website VARCHAR(255) DEFAULT 'https://eqbalq.com',
availability ENUM('Busy', 'Open to Great Opportunities') DEFAULT 'Open to Great Opportunities'
);
-- Where the magic happened
CREATE TABLE career_adventures (
id INT PRIMARY KEY AUTO_INCREMENT,
company VARCHAR(100) NOT NULL,
role VARCHAR(150) NOT NULL,
start_date DATE NOT NULL,
end_date DATE,
location VARCHAR(100),
industry ENUM('Gaming', 'Fintech', 'On-Demand', 'Consulting'),
team_size_start INT,
team_size_end INT,
favorite_tech VARCHAR(500),
fun_fact TEXT
);
-- The impressive numbers
CREATE TABLE awesome_achievements (
id INT PRIMARY KEY AUTO_INCREMENT,
company_id INT,
achievement VARCHAR(100) NOT NULL,
impact VARCHAR(50) NOT NULL,
coolness_factor ENUM('Nice', 'Impressive', 'Mind-blowing') DEFAULT 'Mind-blowing',
story_behind_it TEXT,
FOREIGN KEY (company_id) REFERENCES career_adventures(id)
);
-- Let's fill it with some real data
INSERT INTO eki_profile VALUES (1);
INSERT INTO career_adventures VALUES
(1, 'Playhera', 'Chief Technology Officer', '2021-02-01', '2025-02-01', 'Riyadh, KSA', 'Gaming', 10, 50,
'Ruby on Rails, Python AI, React, Blockchain', 'Built AI that predicts what gamers want to play next'),
(2, 'Mrsool', 'Chief Technology Officer', '2019-05-01', '2024-02-01', 'Riyadh, KSA', 'On-Demand', 30, 100,
'AWS, Kubernetes, Machine Learning, PostgreSQL', 'Scaled delivery platform to serve millions across MENA region'),
(3, 'Floos.me', 'Chief Technology Officer', '2017-01-01', '2019-04-30', 'Dubai, UAE', 'Fintech', 5, 20,
'React.js, Machine Learning, Node.js', 'Made fintech so smart it reads user minds (almost)'),
(4, 'Toptal', 'Senior Solution Architect', '2014-01-01', '2019-12-31', 'New York, USA', 'Consulting', 1, 5,
'Ruby on Rails, JavaScript, System Architecture', 'Solved complex problems for world-class clients');
INSERT INTO awesome_achievements VALUES
(1, 1, 'Monthly Active Users', '500K+', 'Mind-blowing', 'Built gaming platform that users actually love and keep coming back to'),
(2, 1, 'User Retention Boost', '+50%', 'Mind-blowing', 'AI recommendations so good, they feel like magic'),
(3, 2, 'Platform Scale', '10x', 'Mind-blowing', 'Grew infrastructure 10x while keeping costs reasonable and users happy'),
(4, 2, 'Team Productivity', '+40%', 'Impressive', 'Transformed development culture with smart DevOps and happy engineers'),
(5, 3, 'ML Implementation', '+25% engagement', 'Impressive', 'Built machine learning that actually improves user experience');
-- The money question: What can Eki do for you?
SELECT
CONCAT('Hi! I am ', ep.name) AS introduction,
CONCAT(ep.experience_years, ' years of making technology work beautifully') AS experience,
COUNT(DISTINCT ca.company) AS companies_transformed,
MAX(ca.team_size_end) AS largest_team_led,
COUNT(aa.id) AS impressive_achievements,
'Ready for the next big challenge!' AS status
FROM eki_profile ep
LEFT JOIN career_adventures ca ON ep.id = 1
LEFT JOIN awesome_achievements aa ON ca.id = aa.company_id
GROUP BY ep.id;
-- Recent highlights (the fun stuff)
SELECT
ca.company AS where_the_magic_happened,
CONCAT(ca.team_size_start, ' → ', ca.team_size_end, ' people') AS team_growth,
ca.fun_fact,
GROUP_CONCAT(CONCAT(aa.achievement, ': ', aa.impact) SEPARATOR ' | ') AS impact_summary
FROM career_adventures ca
LEFT JOIN awesome_achievements aa ON ca.id = aa.company_id
WHERE ca.start_date > '2017-01-01'
GROUP BY ca.id
ORDER BY ca.start_date DESC;