About VentureFlow

VentureFlow is a custom-built Customer Relationship Management (CRM) system designed specifically for Pack Ventures to handle its deal flow pipeline efficiently.

The platform provides a comprehensive suite of tools including:

Kanban-style pipeline visualization for tracking companies through investment stages
Integrated email management with Microsoft Outlook synchronization
Contact and relationship management
Team collaboration features
Automated email syncing and company matching

Built for Pack Ventures

VentureFlow was custom-developed for Pack Ventures, a Seattle-based pre-seed and seed venture fund investing in founders associated with the University of Washington (UW) network.

Pack Ventures makes the venture asset class available to the more than 400,000 global UW alumni.

Credits

VentureFlow was made possible by the following individuals:

Ken Horenstein

Founder & General Partner

Pack Ventures

LinkedIn Profile

Ti Zhao

Partner

Pack Ventures

Expert on product, strategy, and growth

LinkedIn Profile

Shak Ragoler

CRM Developer

Full-stack development and system architecture

LinkedIn Profile

Technology Stack

VentureFlow is built with modern, reliable technologies:

Backend

Python & FastAPI
PostgreSQL Database
SQLAlchemy ORM

Frontend

HTML5, CSS3, JavaScript
Responsive Design
RESTful API Integration

Cloud & Integration

Microsoft Azure
Azure Web Apps
Azure Functions
Microsoft Graph API
Azure Blob Storage

Authentication

Microsoft OAuth 2.0
Session Management
Secure Cookie Handling

System Architecture

VentureFlow follows a modern three-tier architecture with cloud integration:

The architecture consists of:

Frontend Layer: Responsive web interface built with HTML5, CSS3, and JavaScript
Backend Layer: FastAPI server with RESTful endpoints and business logic
Data Layer: PostgreSQL database with ORM pattern for data persistence
Integration Layer: Microsoft Graph API for email synchronization and Azure services for cloud storage
Background Services: Azure Functions for automated email syncing and database backups

Quality Assurance

VentureFlow is backed by a comprehensive test suite ensuring reliability and correctness:

Test Coverage

Test Category	Test Count
Schema Tests	10
ORM Tests	39
API Tests	101
Email API Tests	15
Email Sync Tests	46
Domain Utils Tests	5
Column Ordering Tests	20
Backup/Restore Tests	6
Performance Optimization Tests	13
Authentication Security Tests	27
Teams Integration Tests	24
Total Tests	306

All tests are run automatically to ensure code quality, data integrity, and system reliability across schema validation, ORM operations, API endpoints, email synchronization, and backup/restore procedures.