Java + SQL · 2025
Employee Management & Attrition Analysis
Employee data system with attrition analysis, built on a Java/MVC core with SQL doing the heavy lifting.
What it does
Core business logic rebuilt in Java using OOP principles — encapsulation and inheritance — with a Factory pattern to model employee entities, and MVC separation to keep data access decoupled from reporting. On top of that sits SQL analysis of 1,000+ employee records, aimed at understanding attrition trends.
Engineering details
- Factory pattern for employee entity creation, MVC separation between data access and reporting layers
- Multi-table JOINs, GROUP BY, and aggregates across 1,000+ records
- 20% query performance improvement through schema normalization and strategic indexing
- Structured attrition trend reports, presented to faculty evaluators in a format simulating stakeholder reporting
Stack
- Java
- SQL
- Factory Pattern
- MVC
- Query Optimization