Hi, I'm Adam Harith
Data Analyst & Developer passionate about transforming data into actionable insights and building efficient web applications.
I'm a diploma student specializing in data analysis and full-stack development. I recently built "REKEK" - a complete e-commerce platform with PHP and MySQL. Currently seeking a Data Analyst internship where I can apply my skills in data visualization, database management, and problem-solving.
Technical Focus
- E-commerce systems: cart → checkout → shipment → returns
- Database design: schemas, constraints, and optimized queries
- Data analysis: cleaning datasets, EDA, and visualizing trends
- Responsive web design and user experience optimization
-- Example: Customer segmentation query
SELECT
c.id,
c.name,
COUNT(o.id) AS order_count,
SUM(o.total) AS total_spent,
CASE
WHEN SUM(o.total) > 500 THEN 'VIP'
WHEN SUM(o.total) > 200 THEN 'Regular'
ELSE 'New'
END AS customer_segment
FROM customers c
LEFT JOIN orders o ON c.id = o.customer_id
GROUP BY c.id, c.name
ORDER BY total_spent DESC;
Technical Skills
Here are the technologies and tools I work with:
Featured Projects
Here are some of my key projects that demonstrate my technical abilities:
REKEK E-commerce
A complete badminton e-commerce platform with product catalog, shopping cart, checkout, order management, and admin dashboard.
Sales Dashboard
Interactive Power BI dashboard analyzing sales data, customer behavior, and product performance with actionable insights.
Inventory Management
Java Swing application for tracking inventory, managing stock levels, and generating reports with a user-friendly interface.
REKEK – E-commerce Platform (Final Year Project)
A comprehensive badminton e-commerce website built with PHP + MySQL that implements complete e-commerce workflows from product browsing to returns management.
Key Features
Technical Implementation
- Responsive design with Bootstrap for mobile compatibility
- User authentication and session management
- Database design with proper relationships and constraints
- Admin panel for product and order management
- Dynamic product filtering and search functionality
Sales Analytics Demo
Interactive chart showing sample sales data with monthly trends and performance metrics.
-- Product performance analysis SELECT p.name, p.category, SUM(oi.quantity) as units_sold, SUM(oi.quantity * oi.unit_price) as revenue, ROUND(SUM(oi.quantity * oi.unit_price) / SUM(SUM(oi.quantity * oi.unit_price)) OVER() * 100, 2) as revenue_percentage FROM order_items oi JOIN products p ON p.id = oi.product_id GROUP BY p.id, p.name, p.category ORDER BY revenue DESC LIMIT 10;
Get In Touch
I'm currently seeking internship opportunities in Malaysia. Feel free to reach out if you'd like to discuss potential collaborations or opportunities.
Always open to discussing data analysis projects and web development opportunities.