Josue Abrego

Business Intelligence

Sales Performance & Regional Analytics Dashboard January 2026-May 2026

• Developed Tableau dashboards analyzing $24k+ in sales data, enabling performance tracking across customer segments,geographic regions, and seasonal trends.
• Created KPI- driven visualization to identify top-performing regions, uncover sales trends, and support business decision-making.
• Developed data-driven insights through dashboards and reports, improving the communication of key business metrics and performance indicators.

System and Design

Cowboy Hotel Project Jan 2026-May2026

• Developed a complete Systems Development Life Cycle project including requirements gathering,feasibility analysis,project planning, and system documentation.
• Created use cases, Data Flow Diagrams,process models, and system specification to document business requirements and workflows.
• Designed hardware/software specification and user interface prototypes to support system implementation and improve operational efficiency.

Information Systems

Hearth & Home Custom Furniture Jan 2026-May 2026

• Analyzed organizational workflows and identified technology solutions to improve business processes, operational performance, and information flow.
• Developed project schedule and implementation plans using Gantt charts to manage project tasks,timelines,dependencies,and resource allocation.
• Designed hardware and software requirements to improve reservation system efficiency and scalability.

Data Mining For Managers

Credit Risk Modeling & Machine Learning Analysis Project German Credit Sep 2025-Dec 2025

• Built and evaluated Logistic Regression, Decision Tree,& K-Nearest Neighbors models using XLMiner and Excel in the German Credit dataset to predict borrower credit risk.
• Achieved 89.7% specificity, 91.0% Precision, and 56.5% Overall Accuracy in identifying high-risk borrowers.
• Evaluated model performance using ROC Curves, Accuracy, Precision, Sensitivity, and specificity metrics to optimize classification performance.

Database Management System

Database Management & Relationship Modeling Project Grand Canyon Flights Sep 2025-Dec 2025

• Designed relational databases by defining entities,attributes,primary keys,foreign keys, and entity relationships to support business operations and data requirements.
• Applied normalization techniques to improve data integrity and reduce redundancy.
• Developed SQL queries for reporting. data retrieval, and database management.

Business Analytics II

Workforce Forecasting & Business Analytics Project Karrie Restaurant Jan 2025-May 2025

• Developed 5 forecasting models using 3 years of restaurant sales data to analyze trends and seasonality.
• Identified the Naive Forecasting Model as the most accurate method with a MAD of 28.2%.
• Conducted seasonality analysis and forecasted 339 January sales using a 1.44 seasonal index supporting inventory and operational planning.

Business Analytics I

Gas Price & Consumer Behavior Analysis Sep 2024-Oct 2024

• Analyzed gasoline pricing across 3 fuel brands and 11 metropolitan evaluating average prices ranging from $3.79-$3.85 per gallon.
• Performed variability analysis, identifying Marathon prices were 43% more stable than BP prices from 0.04-0.07 variation.

• Phi Theta Kappa Honor Society Active Member

• 2025 Cal State Fullerton-Hands on Banking 04/16/2025
• 2024 Cross Fit Day-Fullerton Union High School 10/22/2024