
Lucas J
Website Design, Ghost cms Expert and Data Analyst
Skills

See my services


Portfolio
Work experience
E-commerce Sales & Customer Analytics Dashboard
Business Directory for business listing
Feb 2026 - Apr 2026 • 2 mos
This project focuses on analyzing e-commerce business data to uncover sales trends, customer behavior, and revenue growth opportunities. The goal was to help an online store scale profitably using data-driven strategies. 🎯 Client Problem The e-commerce business faced several challenges: Inconsistent sales performance Poor understanding of customer behavior High cart abandonment rate No visibility into top-selling products 🛠️ Tools Used Microsoft Excel / Google Sheets Power BI / Tableau SQL Google Analytics (E-commerce tracking) 📈 Data Analyzed Product sales data Customer purchase history Website traffic Cart abandonment rates Revenue by channel ⚙️ Process & Workflow 1. Data Cleaning & Preparation Structured raw sales data Removed duplicates Standardized product categories 2. Data Modeling Built relationships between customers, products, and transactions Created calculated Major Achievements 1. Revenue Growth Optimization I helped an e-commerce brand identify its most profitable products and customer segments. By focusing marketing efforts on these areas, the business achieved a 28% increase in revenue within a short period. 2. Cart Abandonment Reduction Through funnel analysis, I identified key friction points in the checkout process. After implementing improvements, the business reduced cart abandonment by 22%, leading to more completed purchases. 3. Customer Retention Improvement By analyzing repeat purchase behavior, I developed strategies to target returning customers more effectively. This resulted in a 15% increase in customer retention. 4. Product Performance Insights I identified top-performing products and underperforming ones, helping businesses focus on high-demand items and eliminate inefficiencies in inventory and marketing. Approach to Analytics My approach is centered on: Turning raw data into clear insights Focusing on business impact, not just numbers Simplifying complex data for decision-making Delivering actionable recommendations
Modern Ghost CMS Blog & Membership
Web Design Carnival • Freelance
Feb 2026 - Feb 2026 • 0 mos
TechPulse – A Fast, SEO-Optimized Ghost CMS Publication & Membership Website Project Overview TechPulse is a modern content-driven publication built using Ghost CMS for a tech startup focused on publishing articles, newsletters, and premium content for subscribers. The goal of this project was to create a high-performance, SEO-optimized.