Web Development Portfolio | Case Studies & Projects

Candeo Counseling Center

Custom Web Page Build

Visit Website

Project Overview

Candeo Counseling Center wanted to expand its reach beyond Iowa while maintaining a strong local presence. Their existing website was largely static, with limited engagement, difficult navigation for clients, and a contact process that lacked efficiency and compliance considerations.

The Challenge

The primary challenges were improving user engagement, making it easier for clients to find critical resources such as the client portal login, and restructuring the site to support multi-state growth. Additionally, the contact and intake process needed to be streamlined while ensuring protection of patient health information (PHI).

The Solution

Key areas of the website were redesigned to improve usability, scalability, and compliance. The Our Team page was rebuilt to provide each clinician with a concise summary and a dedicated profile page, allowing clients to quickly find the right provider. The Locations section was enhanced with individual location tabs featuring maps, facility photos, and the clinicians available at each location, with direct links back to clinician profiles. The Contact page was upgraded with a PHI-compliant Google Form to securely collect patient information and streamline the intake workflow.

Measurable Outcomes

Improved navigation: Reduced the number of clicks required to access clinician profiles and the client portal to 1–2 steps.
Increased engagement: Replaced static bios with dynamic clinician profiles, encouraging longer site visits and deeper exploration.
Scalable growth: Implemented a site structure that allows new locations and providers to be added without redesign.
Streamlined intake: Secure, PHI-compliant form submissions reduced manual data handling and follow-up for clinic leadership.
Improved trust and compliance: Enhanced data protection increased client confidence when submitting sensitive information online.

JavaScript Squarespace UI/UX Design Google Workspace Integration

Pharmacy Application Support – Internal Data Query Tool

Internal Tooling & Data Enablement

Project Overview

While working on a Specialty Pharmacy Support team, I identified an opportunity to improve how analysts triage and resolve customer issues by making enterprise data more accessible. The goal was to reduce friction when querying large databases while empowering analysts to confidently extract the insights they need.

The Challenge

Analysts regularly rely on SQL queries to investigate customer-reported issues, but enterprise-scale databases contain hundreds of tables, making it difficult to know where to start. This challenge was especially impactful for newer team members who were still learning the system architecture, resulting in slower triage and inconsistent investigation workflows.

The Solution

I designed and built an internal querying application using Python with a Tkinter-based graphical interface. The tool connects to pre-configured databases and provides a curated library of predefined SQL queries, including contributions from experienced internal analysts and engineers. Each dataset includes a clear description of the insights it provides, and the application dynamically displays only the relevant input fields based on the selected dataset. This enables analysts to retrieve targeted data quickly without needing to understand or navigate the underlying database structure.

Measurable Outcomes

Faster issue triage: Reduced time spent identifying relevant tables and queries during investigations.
Improved analyst confidence: Enabled newer team members to work effectively with enterprise data without deep schema knowledge.
Standardized insights: Centralized and reused vetted SQL queries to ensure consistent results across analysts.
Scalable internal tooling: Designed the application to support additional datasets, queries, and teams.
Knowledge sharing: Created a platform for experienced analysts to contribute and document high-value queries.

Python Tkinter SQL Internal Tools Data Enablement Enterprise Systems

Government Agency Data Processing & Analysis Tool

Process Automation

Project Overview

This project focused on building a purpose-driven automation tool to support government disaster recovery operations. The application streamlines how large volumes of spreadsheets, PDFs, and invoices are processed, reconciled, and transformed into standardized, audit-ready reports for field teams and analysts.

The Challenge

Disaster recovery projects generate extensive documentation, including load ticket spreadsheets, debris tracking records, waterway assessment PDFs, and multi-sheet invoices. Analysts were required to manually reconcile data across files, extract critical information from unstructured documents, and standardize outputs—often taking days per project and introducing risk of human error.

The Solution

I designed and built a standalone automation application that performs intelligent Excel reconciliation, PDF data extraction, and invoice aggregation. The tool automatically detects duplicate records across files, parses structured data from complex PDF reports, and consolidates transactional invoice data while maintaining full traceability. Delivered as a single Windows executable, the application requires no installation or technical expertise and provides a guided, user-friendly interface.

Measurable Outcomes

90%+ reduction in reconciliation time: Automated duplicate detection replaced manual spreadsheet comparisons.
Significant accuracy improvements: Eliminated transcription and comparison errors.
Expanded accessibility: Enabled non-technical users to perform advanced data processing.
Reduced end-to-end processing cycles: Typical document processing workflows were reduced from multi-week efforts to same-day completion.

Python Data Automation Excel Processing PDF Parsing Government Operations

Isles of Hope International

Web Development & Mission-Driven Content

Visit Website

Project Overview

Isles of Hope International is a Christian nonprofit organization dedicated to supporting women in need across multiple countries. The new website was built from the ground up to provide clear navigation of ministries, enhance storytelling of global outreach, and facilitate supporter engagement and donations. It highlights partner ministries in Zimbabwe, Uganda, Nepal, and the Democratic Republic of the Congo.

The Challenge

The organization needed a modern, mobile-friendly website that could effectively communicate its mission, showcase international partnerships, and provide an intuitive way for supporters to learn more and give. The site had to support multifaceted content—region pages, mission statements, faith commitments, and donation calls to action—while remaining clear and navigable for diverse audiences.

The Solution

A fully custom website was developed featuring a clear top-level content structure highlighting: ministry efforts by country, the organization's mission and statement of faith, and multiple supporter touchpoints. Each country page presents background on local leadership, the scope of services offered, and opportunities for support or partnership. The design emphasizes readability, mobile responsiveness, and ease of updates for ongoing storytelling.

Measurable Outcomes

Improved engagement: Clear country-by-country calls to action make it easy for visitors to explore regional ministry work.
Enhanced donation visibility: Prominent "Send Support" and "Give" links guide visitors toward giving.
Structured content: Mission, faith, and leadership information organized for clarity and storytelling depth.
Mobile accessibility: A responsive layout improves user experience across devices.
Scalable architecture: Added flexibility for future updates—events, newsletters, and international expansion stories.

Web Development Squarespace Nonprofit International Outreach

AI Blog Platform

Full-Stack Web Application

Visit Website

Project Overview

AI Blog Daily is a full-stack web application that aggregates and compares AI-generated content from multiple leading AI models (ChatGPT, Claude, Gemini, Grok, and Llama) in a single, unified platform. The application automatically generates fresh blog posts daily across 15+ categories and features a blind head-to-head voting system, allowing users to evaluate how different AI models approach identical topics — without bias.

The Challenge

With the rapid proliferation of AI language models, users face several key challenges: content from different AI models is scattered across multiple platforms, there's no easy way to compare outputs from different models on the same topic, separate subscriptions are required to access multiple AI services, and it's difficult to systematically explore diverse AI-generated content. The goal was to create a centralized platform with meaningful comparison tools and a sustainable monetization strategy.

The Solution

Built a comprehensive platform using Python and Flask with a PostgreSQL database, integrating 5 AI APIs (OpenAI, Anthropic, Google, xAI, Together AI). The core feature is a blind voting system — users read paired posts without knowing which AI wrote them, vote across 5 categories (Writing Quality, Accuracy, Creativity, Usefulness, Overall), and only then are the authors revealed. Position randomization prevents positional bias, and a 5-minute edit window locks votes permanently. Free users receive 3 votes per week to seed community data.

Additional features include a premium analytics dashboard with leaderboards and head-to-head matrices, a follow system for AI tool notifications, Stripe-powered tiered subscriptions, bookmarking, threaded comments, in-app notifications, dark/light theming, and a comprehensive admin panel — spanning ~64 distinct routes across the platform.

Measurable Outcomes

100% Automated: Zero manual intervention for daily content generation across 5 AI providers with modular, fault-tolerant architecture.
Bias-Free Comparisons: Blind voting with position randomization eliminates brand and positional bias, producing authentic crowdsourced insights into AI model strengths.
Sustainable Monetization: Freemium model with bootstrap free voting (3/week), 5 posts/month free tier, and premium subscriptions ($4.99/month, $49.99/year).
Data-Driven Analytics: Premium leaderboards with confidence badges, head-to-head matrices, personal vote history, and 7-day trend tracking.
Production-Grade Security: CSRF protection, rate limiting with IP whitelisting, parameterized queries, webhook signature verification, and secure session management.
Rich Engagement: Follow system with email notifications, threaded comments, bookmarks, in-app notifications with badge counts, and dark/light theme toggle.

Python Flask PostgreSQL OpenAI API Anthropic API Google AI API Stripe Payments Full-Stack Development

Our Portfolio

AI Blog Platform

Candeo Counseling Center

Internal Database Querying Tool

Government Agency Data Processing

Isles of Hope International

Ready to Start Your Project?