top of page
Here you’ll find selected projects and articles from my work in ERP, analytics, AI and business systems consulting.
Some are real client projects, others are student and research projects that show how I work.


SQL / ETL: Insurance Claims Analysis Project
Objective: To analyze insurance claim data to gain insights and improve database performance. CRISP-DM Process: Business Understanding: Objective: Analyze insurance claim data for insights. Goals: Create a database schema, populate with sample data, analyze claims, optimize performance, and manage database security. Data Understanding: Data Sources: Insurance data including customers, policies, claims, and policy types. Initial Exploration: Unders


Coffee Shop Data Mining Analysis Report
Abstract This report presents a comprehensive data mining analysis of Stargazers Coffee Shop's transaction data using the CRISP-DM (Cross-Industry Standard Process for Data Mining) methodology. The analysis examines 14,517 transactions spanning from April 2024 to March 2025, focusing on customer behavior patterns, product performance, and revenue optimization opportunities. Key findings reveal that beverages dominate sales (74.6% of transactions), with Cold Brew and Iced Latt


Business Analyst (Student Project): Titanic Survival Analysis
Used classification and clustering to analyze survival determinants Situation: Analyzed Titanic passenger data to identify survival factors and support risk assessment strategies for modern shipping. Task: Determine key attributes influencing survival outcomes and model risk based on class, gender, and age. Action: Cleaned and prepared nominal dataset; applied J48 decision tree (C4.5) and KMeans clustering in WEKA to uncover patterns; tuned decision tree parameters for mo


Business Analyst (Student Project): Bookstore Sales Optimization (market basket analysis)
Applied CRISP-DM and WEKA for market basket analysis Situation: A bookstore wanted to boost sales and improve customer satisfaction through better recommendations and store layout. The business needed insights into which book categories are often purchased together, to enable product bundling and more effective cross-selling. Task: As a business analyst student, my objective was to discover associations between book purchases using data mining techniques. The main question w


Big Data Analytics: Volvo Case Study
Situation: Volvo, aiming to improve its car sales strategy and market positioning, needed to understand how different customer segments behave, especially in relation to financing options and car model preferences. The task was to analyze the Volvo dataset using data mining techniques to support targeted marketing and decision-making. Task: As a business analyst student, my goal was to segment customers effectively, determine which financing options influenced car purchases,


Case Study: Amazon’s Sustainability & Web Sustainability Guidelines (WSG) Integration
Project Title Driving Sustainable Digital Practices at Amazon through Web Sustainability Guidelines Overview Company : Amazon Project Type : Sustainability Strategy & Web Optimization Role : Researcher & Strategy Developer Executive Summary Amazon, a global leader in technology and e-commerce, faces mounting pressure regarding its energy consumption, particularly in data centers. This project proposes the integration of Web Sustainability Guidelines (WSG) into Amazon’s digita
bottom of page