Giovanni Marcondes

portfolio

See the work
Giovanni Marcondes

About me

I graduated from Colorado State with a degree in Computer Information Systems and Business. I like building things where data, design, and code overlap. These are some projects from my time there.

Projects

Financial Analysis & Web Dev

I built an interactive dashboard analyzing Costco's financial performance from FY2019 through FY2025. The central question: 81 million loyal members, but only 7% of revenue comes from e-commerce. I pulled apart the DuPont analysis, peer comparisons, and segment data to figure out where that gap is.

HTML CSS JavaScript Chart.js
$0B
FY2019 Revenue
Grew to $275.2B by FY2025
~0%
Merchandise Gross Margin
Tight by design
0%
US/Canada Renewal Rate
Above 90% for 6 straight years
0M
Paid Cardholders
Up from 53.9M in FY2019

Covers DuPont decomposition, revenue and operating margin trends, e-commerce growth curves, competitive benchmarking against Sam's Club and Walmart, and a phased strategic recommendation.

Interactive Dashboard Open full page ↗
AI Prototyping & Desktop App — BUS 479

I built a desktop app that sits alongside a recruiter during live interviews. It transcribes in real time, researches the candidate's claims on the fly, and generates a scored debrief when the session ends. Everything runs locally on macOS.

Tauri v2 Rust React TypeScript OpenAI API macOS Keychain

Session Flow

1
Setup
Upload job files, edit scoring rubric
2
Consent
Mic/privacy warning, legal reminder
3
Live Session
Two-pane: summary + research
4
Debrief / Export
Score out of 100, PDF/DOCX

Capabilities

Live Transcription +

Captures mic and system audio into a single mixed transcript, updated in real time as the conversation happens.

Real-Time Research +

Looks up companies and claims mentioned during the interview. Everything is labeled by evidence type: transcript fact, inference, or external research.

Scoring & Debrief +

Weighted rubric with subscores for skills match, experience depth, communication clarity. Final score out of 100 with PDF/DOCX export.

Privacy-First Architecture +

No raw audio saved. Nothing leaves the machine unless the recruiter explicitly exports. API keys stored in macOS Keychain.

App Screenshots

Managing an AI agent turned out to be way harder than just writing a good prompt. You're not getting a single answer anymore, you're working with it constantly, redirecting, stress-testing, finding new problems every time you think you're done.

UX & Systems Analysis — CIS 360

Group project where six of us surveyed actual Rec Center employees and redesigned the whole app. We found that 70% of staff dealt with sign-in complaints and 60% reported barcode display problems, so we built the redesign around fixing those issues first.

React Native Node.js CSU SSO Duo Firebase/FCM APNS Canva
0%
Sign-in complaints
From employee survey
0%
Barcode display issues
Reported by staff
0%
Want "stay signed in"
Most requested feature
0
Use cases defined
Login, booking, events, more
System Data Model (7 classes)
Class
Facility
Member
Reservation
Schedule
Staff
TimeSlot

App Mockups

Data Analytics & Cloud — CIS 355

I built a Snowflake pipeline to find people whose stress levels significantly outpace their wellness. The system scores individuals on a stress-minus-wellness gap, segments them into priority tiers, and uses Snowflake's AI to generate personalized outreach notes for teletherapy and coaching programs.

Snowflake SQL Streamlit Snowflake AI_COMPLETE Python
0%
High-priority pool
229 of 1,000 (stress gap ≥ 2)
0
Individuals analyzed
AnalyticsIQ SDoH sample
0
HIGH priority (AI triage)
Out of 200 at-risk notes
0
SQL worksheets
EDA through artifacts index

Pipeline

1
EDA
Missingness checks, correlations
2
Metrics
Wellness scaling, gap score
3
Insights
Structured + household JSON
4
AI Outreach
AI_COMPLETE triage notes

The business question: how do you identify and prioritize people with high stress and low wellness who would actually benefit from targeted mental-health outreach? I built a stress-minus-wellness gap metric (rescaled to 1-7), tiered the population by gap severity, then used Snowflake's AI_COMPLETE to generate outreach notes with priority labels. The Streamlit app lets you filter by priority, gap range, exercise habits, and job satisfaction to drill into specific segments.