AIData Systems & AI LabProduct Analytics · Data Systems · AI Workflows · Decision InfrastructureContact
Open OS launcher

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.

jarvis-ai-personal-assistant.working-project

Local AI agent workspace

Jarvis — AI Personal Assistant

Under Active Development

A macOS desktop assistant that combines realtime voice, visual artifacts, local workspace context, image tools, notes, web search, and confirmation-gated computer actions.

Business question

How can one AI interface move naturally between conversation, local files, visual output, and tool execution without giving up user control?

Turns a chat interface into an operator workspace: selected files and folders become grounded context, tool results become reviewable artifacts, and risky actions stop for explicit confirmation before execution.

ElectronReactTypeScriptOpenAI RealtimeTool CallingAI Safety
View working project
Jarvis — AI Personal Assistant preview

ghost-ai.working-project

AI-native systems platform

Ghost AI — Collaborative AI Architecture Workspace

Under Active Development

Production-grade AI-powered architecture and workflow builder with realtime collaboration, AI-assisted systems design, and interactive canvas orchestration.

Business question

How can product, analytics, and engineering teams design AI systems collaboratively while keeping architecture, workflow orchestration, and implementation context in one place?

Positions Ghost AI as an AI-native product, analytics, and systems orchestration platform for collaborative system design, product/spec generation, background AI workflows, and production debugging.

Next.jsTypeScriptLiveblocksTrigger.devPrismaPostgreSQLOpenRouterReact Flow
View working project
Ghost AI — Collaborative AI Architecture Workspace preview

budgetdb.working-project

Flagship system

BudgetDB Operations Analytics Warehouse

Flagship

A Postgres-backed operations analytics system that turns budget, vendor, software spend, and headcount data into trusted executive views.

Business question

Where is operational spend concentrated, and how should leadership prioritize the next planning cycle?

Creates a reusable decision layer: cleaned tables, composable views, spend allocation, QA checks, and executive-ready outputs.

PostgreSQLBudget AnalysisOperations AnalyticsExecutive Reporting
View working project
BudgetDB Operations Analytics Warehouse preview

woo-identity-resolution.working-project

Data / systems usability research

Diagnosing and Fixing a Broken Employee-Commission Match

Live

A WOO warehouse case study diagnosing why commission rows failed to match payroll employees, then fixing the workflow with deterministic SQL keys, governed overrides, and visible match confidence.

Business question

Can the commission-to-employee join be trusted for executive reporting without a human manually double-checking free-text names every cycle?

Turns an error-prone reconciliation workflow into auditable data infrastructure: normalized name keys, MAP_OVERRIDE governance, NAME_KEY_EXACT and NAME_KEY_FIRSTLAST matching, explicit UNMATCHED flags, and queryable match_method diagnostics.

PostgreSQLData QAIdentity ResolutionREGEXPReconciliationWOO
View working project

woo-scenario-ab-testing.working-project

Scenario / what-if experimentation

Scenario A/B Testing: Isolating Which Cost Lever Actually Moves the Budget

Live

A WOO warehouse case study applying control/treatment/delta discipline to financial planning scenarios, using a reconciled monthly cost baseline and an isolated vendor-spend treatment.

Business question

Can leadership see exactly which cost lever caused a budget change, without relying on fragile spreadsheet scenarios or mixed assumptions?

Productizes what-if analysis: the reconciled fact_cost_monthly_2025 baseline is the control, each analytics.scenario row is a named treatment, and delta_monthly gives a queryable effect for budget decisions.

PostgreSQLScenario ModelingA/B Testing LogicFinancial PlanningData ModelingWOO
View working project

chat-with-data.working-project

AI + warehouse interface

Chat With Your Data

Under Active Development

A natural-language interface to the BudgetDB warehouse: ask a plain-English question, Claude runs read-only SQL through tool calling, and the answer is grounded in queried rows.

Business question

How can non-technical leaders ask trusted warehouse questions without opening SQL, while keeping the AI read-only and auditable?

Extends BudgetDB from warehouse to conversational decision layer: schema-grounded tool use, read-only execution, strict query allowlisting, and visible SQL audit trails.

PythonAnthropic APITool CallingSQLite DemoPostgres PathRead-only Safety
View working project

pricing-experimentation.working-project

Product experimentation

Reducing Churn Through Pricing & Feature Experimentation

Live

A quantitative product case study showing how KPI instrumentation, A/B testing, and dashboard baselines supported pricing and feature decisions for a subscription product.

Business question

How can a subscription product separate pricing, feature usage, and noise before committing product and engineering time to churn reduction work?

Frames churn as a set of testable product levers: dashboard-tracked KPI baselines, scoped pricing and feature variants, A/B test readouts, UAT checkpoints, and roadmap decisions backed by measured outcomes.

A/B TestingProduct AnalyticsChurnKPI InstrumentationTableauExcel
View working project

vendor-roi.working-project

Operations analytics

Vendor Spend & Ops ROI Analytics

Live

A vendor spend and ROI analytics model: staffing-weighted budget rollup, vendor cost-per-active-employee ranking, and renewal review flags for low-adoption, high-cost tools.

Business question

Which vendor costs should operations review before renewal, especially when spend is high and adoption is narrow?

Connects budget rollups, staffing assumptions, vendor utilization, and renewal review logic into an auditable operations decision model.

PostgreSQLSQLWindow FunctionsSUMPRODUCTExcel
View working project

remittance-revenue.working-project

Payments model

Revenue Modeling - Remittances

Live

A payments/remittance fee-schedule and tiered revenue-projection model: NRC/MRC fee structures, transaction-tier volume assumptions, and projected monthly fee revenue by tier.

Business question

How do transaction tiers, fee schedules, and volume assumptions translate into projected monthly revenue?

Turns remittance pricing assumptions into a repeatable revenue model with SQL rollups and Excel financial modeling artifacts.

SQLPostgreSQLExcel Financial ModelingPaymentsRevenue Projection
View working project

executive-dashboards.working-project

Dashboards

Executive KPI Dashboards

Live

Dashboard views for contact center performance, revenue mix, product trends, and executive operating reviews.

Business question

What does leadership need to see quickly to understand performance, variance, and where to investigate?

Makes KPI patterns easier to scan and turns analysis into a review-ready operating surface.

TableauKPIsRevenueSupport Operations
View working project
Executive KPI Dashboards preview

sql-qa.working-project

Analytics engineering

Cost Model QA Checks

Live

SQL validation checks comparing source totals to modeled fact totals by cost category, with variance and pass/fail status.

Business question

How can messy operational data become reliable product and business reporting we can trust?

Adds confidence gates before dashboards and executive summaries are used for decisions.

SQLPostgreSQLData QAReconciliation
View working project
Cost Model QA Checks preview

churn-analysis.working-project

Python modeling

Customer Churn Predictive Analysis

Live

A reproducible Python workflow for churn analysis: loading, target conversion, missing-value handling, encoding, baseline modeling, and reporting.

Business question

Which customers are most likely to churn, and how can we monitor the pattern repeatedly?

Frames predictive analysis as a repeatable business workflow instead of a one-off notebook.

PythonPandasScikit-learnPredictive Modeling
View working project
Customer Churn Predictive Analysis preview

chorus.working-project

Prototype in development

Chorus Agent Learning App

Live

An iPhone app and web landing-page concept for learning AI agent fundamentals, comparing platforms, and saving reusable skills.

Business question

How can people learn agent workflows, compare the right platforms, and reuse practical skills in one place?

Shows product thinking beyond portfolio work: mobile UX, content model, Supabase schema, launch plan, web page, and launch video assets.

AI ProductiPhone PrototypeAgent EducationSupabase
View working project
Chorus Agent Learning App preview

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

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

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)