Markov Chain Attribution for Marketing Channels
Discover how Markov Chain models go beyond last-click attribution to measure true marketing impact.
Data Engineer & Backend Developer (Supply Chain Systems)
I build data-driven systems that transform raw business data into actionable insights, with experience in ERP systems, KPI design, and backend development.
My Skills
Data
SQL (MSSQL, BigQuery), Python (pandas), Tableau
Backend
Java, Spring Boot, REST APIs, MySQL
Tools
Docker, AWS, Git, CI/CD
Featured Systems:
Production-Ready Blogging Platform (Spring Boot, AWS, Docker)
A Java Spring Boot blog with secure login, role-based access, and rich text editing, hosted on AWS EC2 via Docker.
Data Cleaning & KPI Engineering
Transforming raw eCommerce data into reliable business KPIs using SQL and BigQuery.
Supply Chain Analytics Platform (TheLook eCommerce)
End-to-end analytics system to measure and optimize supply chain performance, KPIs, SQL, Python, and Tableau dashboards.
Featured Posts:
Part 3: User Registration & Default Role
Learn how to implement secure user registration with default role in Spring Boot. Full code walkthrough for production-r...
![Part 2: Why I Chose char[] for Passwords — And What I Learned](/_astro/P0nVCOqI.DZ_RjyqK_Z7DLIi.jpg "Part 2: Why I Chose char[] for Passwords — And What I Learned")
Part 2: Why I Chose char[] for Passwords — And What I Learned
I used char[] for passwords in my Spring app. Here’s why it’s not a magic bullet — and what actually matters for securit...
Part 1: Spring Security Setup in Spring Boot MVC with Thymeleaf
Learn how to set up Spring Security in a Spring Boot MVC app using Thymeleaf. SecurityFilterChain, form login, CSRF prot...
Real Experience
Built and maintained ERP reporting systems, KPI dashboards, and financial analytics tools using SQL and PHP, including migration to SAP B1 and HANA.
Last Posts:
Chapter 4.2 Clustering in Action: Product & Customer from TheLook
How K-Means, DBSCAN & Hierarchical clustering reveal hidden patterns in customer behavior and product performance. Full analysis w...
Chapter 4.1: How Demographics Influence Customer Behavior
The analysis demonstrates a robust statistical methodology using z-tests and GLM modeling to evaluate cancellation rates across de...
Part 3: User Registration & Default Role
Learn how to implement secure user registration with default role in Spring Boot. Full code walkthrough for production-ready apps.
Part 2: Why I Chose char[] for Passwords — And What I Learned
I used char[] for passwords in my Spring app. Here’s why it’s not a magic bullet — and what actually matters for security.
Part 1: Spring Security Setup in Spring Boot MVC with Thymeleaf
Learn how to set up Spring Security in a Spring Boot MVC app using Thymeleaf. SecurityFilterChain, form login, CSRF protection, an...
Chapter 3.5: Measuring Inventory & Supply Chain Efficiency
Discover how to calculate key supply chain metrics like Inventory Turnover, Fill Rate, and Service Level using SQL. Turn data into...
Building Marketing KPIs from Raw Event Data Using SQL
Learn how to engineer core marketing KPIs using SQL from raw event data in BigQuery.
Chapter 3.3: Calculating Customer Experience KPIs
Analyze key metrics like delivery time, return rate, and OTIF to assess customer satisfaction and logistics performance.
Chapter 3.2: Sales & Profitability — Beyond Revenue
Learn how to calculate total sales and gross profit from eCommerce data using SQL.
Chapter 3.1: Data Cleaning & Prep for Reliable Insights
How I cleaned and prepared the TheLook dataset—handling missing values, duplicates, and ensuring data integrity for accurate KPIs.
Secure Docker Secrets on AWS: Real-World Guide
Secure Spring Boot + MySQL on AWS using Docker Secrets. No hardcoded passwords. Real-world config for secure, production-ready dep...
Mastering MySQL Backups & Restores in Docker: A Real-World Guide
When you're running a Spring Boot app with Docker, your data is everything. Here’s how I handle MySQL backups and restores — the r...
Chapter 2: Exploring the theLook eCommerce Database
A data analyst's hands-on exploration of the theLook eCommerce dataset in BigQuery, revealing how to understand an unfamiliar data...
The AI Accountability Gap: When Hype Outpaces Reality
Despite bold claims of revolution, AI is failing to deliver real economic value—replacing accountability more than jobs.