Selected Work
Showing 5 projects
Mind Map Web App
Mind Map Web App
A comprehensive mind mapping web application focused on simple, performant visual organization. The app uses FastAPI for the backend (PostgreSQL for local persistence via SQLAlchemy) and a D3.js-driven frontend (vanilla JavaScript + Jinja2 templates). Features include drag-and-drop node management, customizable node styling, auto-save/export, sanitized rich-text node descriptions, and an intuitive editor UI. (Development in progress.)
- Intuitive editor for creating and organizing idea graphs
- D3.js-powered rendering of hierarchical node structures
- Export/import(In Progress) and auto-save to persistent PostgreSQL storage
Audio Transcription Application - Powered by Faster Whisper
Audio Transcription Application - Powered by Faster Whisper
A comprehensive audio transcription desktop application that simplifies the process of converting speech to text. Built with PyQt5 for the graphical interface and powered by Faster Whisper, this application offers robust features including multi-language transcription with automatic language detection, flexible model selection for accuracy/speed balance, hardware acceleration (CPU/GPU with CUDA support), result persistence, and real-time progress monitoring. The application provides an intuitive and user-friendly interface suitable for both beginners and advanced users.
- Intuitive GUI enabling non-technical users to transcribe audio without command-line expertise
- Support for 7 model sizes (tiny, base, small, medium, large-v2, large-v3) with configurable accuracy/speed balance
- Multi-language transcription supporting 50+ languages including English, Japanese, Chinese, German, Spanish, Russian, Korean, French, and more
Group Management Data Migration
Group Management Data Migration
Led the development and execution of a comprehensive data migration framework for an enterprise client, migrating millions of group records with nested ownership and membership relationships from Microsoft SQL Server to PostgreSQL. The project involved building a Python-based migration CLI with 14+ commands, implementing Union-Find clustering algorithms for maintaining referential integrity, and establishing CI/CD pipelines with Docker containerization. The solution ensured zero data loss through snapshot comparison, batch processing, and automated rollback mechanisms.
- Successfully migrated 100,000+ group records with zero data loss
- Reduced migration time by 60% through optimized batch processing and parallel operations
- Achieved 99.9% data integrity through automated snapshot comparison and validation
RAG API Support AI Chatbot
RAG API Support AI Chatbot
A conversational AI system that helps developers and support teams answer questions about APIs by retrieving relevant documentation and generating contextual, grounded responses with source citations. Users can ask natural language questions like "How do I authenticate?" or "Why am I getting a 401 error?" and receive accurate answers pulled directly from ingested API docs. Built with Django REST Framework, PostgreSQL with pgvector for vector similarity search, and Ollama for local LLM inference — no cloud API keys required.
- RAG-based question-answering over custom API documentation with source citations
- Vector-based semantic search across document chunks using pgvector
- Conversation tracking with message history for multi-turn interactions
Home Automation: Siri to Windows PC
Home Automation: Siri to Windows PC
A creative automation solution that bridges Apple's Siri ecosystem with Windows PC control. Using a combination of iOS Shortcuts, cloud services, and local Python scripts, this system enables voice-activated control of your Windows computer from anywhere.
- Seamless voice control of Windows PC via Siri
- Support for custom commands and workflows
- Secure command execution with authentication