Project systems

Working projects built around business questions, data systems, AI workflows, and decision outputs.

Explore functioning tools, active prototypes, source code, SQL, Python, dashboards, documents, and the design decisions behind each build.

Loading projects…

Code evidence

Reusable code blocks support project proof.

Screenshots are used only as supporting visuals. The primary project evidence is SQL/Python logic, notes, and linked source files.

code-proof.workspace

BudgetDB snippets

Open BudgetDB

1CREATE VIEW analytics.v_software_cost_per_employee_company_2025 AS2WITH employee_count AS (3  SELECT COUNT(*)::int AS total_employees_20254  FROM analytics.dim_employee5  WHERE (start_date IS NULL OR start_date <= '2025-12-31'::date)6    AND (end_date IS NULL OR end_date >= '2025-01-01'::date)7),8company_spend AS (9  SELECT SUM(COALESCE(total_spend_2025, 0))::numeric AS total_software_spend_202510  FROM analytics.vendors_2025_clean11)12SELECT13  c.total_software_spend_2025,14  e.total_employees_2025,15  ROUND(c.total_software_spend_2025 / NULLIF(e.total_employees_2025, 0), 2)16    AS software_cost_per_employee_202517FROM company_spend c18CROSS JOIN employee_count e;

code-proof.workspace

Churn workflow snippets

Python file

1def build_model(data: pd.DataFrame) -> None:2    data = data.copy()3    data["Churn"] = data["Churn"].replace({"No": 0, "Yes": 1})45    X = data.drop(columns=["customerID", "Churn"])6    y = data["Churn"]78    preprocess = ColumnTransformer(9        transformers=[10            ("cat", OneHotEncoder(handle_unknown="ignore"), cat_cols),11            ("num", "passthrough", numeric_cols),12        ]13    )1415    pipe = Pipeline(steps=[("prep", preprocess), ("model", LinearRegression())])16    pipe.fit(X_train, y_train)17    pred = np.clip(pipe.predict(X_test), 0, 1)