This repository showcases projects focused on relational database design, SQL analytics, query optimization, and application-level database integration. The projects demonstrate how structured data systems support reporting, business intelligence, and data-driven decision making.
The work in this repository highlights both foundational database theory and applied analytics workflows, including schema development, performance tuning, reporting pipelines, and integration with external applications.
This project demonstrates a fully renamed and sanitized recreation of SQL workflows inspired by internship experience working with insurance and reinsurance product reporting.
- Designed and refined relational database structures
- Optimized SQL queries to significantly improve runtime performance
- Developed reporting queries supporting multi-page analytical reporting
- Created SQL pipelines used to feed Power BI dashboards
- Demonstrated business-focused analytics and performance improvement techniques
This project emphasizes real-world data engineering and analytics practices used in enterprise reporting environments.
This project demonstrates core relational database design principles through the development of a healthcare treatment scheduling system.
- Five-table relational database including doctors, patients, hospitals, treatments, and treatment schedules
- Schema design using normalization and referential integrity
- Synthetic data generation using Mocaroo
- Indexing strategies to improve query efficiency
- SQL view creation for reporting and simplified querying
- Entity Relationship Diagram documenting system design
- Java programs connecting to SQL databases using JDBC
- Programmatic data insertion and retrieval
- Automated table querying and result display
Java integration using JDBC to demonstrate application-level database interaction
This project highlights full database lifecycle development from conceptual modeling through implementation and system integration.
- Relational schema development
- Data modeling and normalization
- ER diagram creation
- Referential integrity enforcement
- SQL Analytics and Optimization
- Advanced query writing
- Join optimization and filtering strategies
- Common Table Expressions (CTEs)
- Window functions
- Index creation and performance tuning
- View construction for reporting
- Database connectivity using Java and JDBC
- Automated data insertion and retrieval
- Reporting pipeline development
- Backend database workflow design
- SQL queries supporting Power BI dashboards
- Multi-query reporting systems
- Translating business questions into data solutions
- SQL
- Relational Database Systems
- Java
- JDBC
- Power BI
- Mocaroo
- ER Modeling
Author
Olivia Rueschhoff Master of Science in Mathematics Bachelor of Science in Mathematics with an Emphasis in Data Science and Statistics Minor in Computer Science – Algorithms and Data Structures