Francis Cao
Co-Founder at umami
Sacramento, California, United States
Summary
🤩
Rockstar🎓
Top SchoolFrancis Cao is a Co-Founder and seasoned full stack and business intelligence developer with a decade of experience building data-driven applications for healthcare and pharmaceuticals. He blends deep database architecture and ETL expertise with front-end and .NET development, having led projects like a medical code and claims workflow tool and enterprise reporting platforms. At Blue Shield he introduced Power BI portfolio reporting and CI/CD practices in Azure Pipelines, and earlier he architected SQL Server/SSIS solutions and SSRS reporting for cross-functional stakeholders. As a contributor to the popular privacy-focused analytics project Umami, he focused on database schema design, migrations, and producer-consumer testing for session handling, highlighting his practical experience with MySQL and Kafka patterns. Based in Sacramento, Francis pairs entrepreneurial initiative with hands-on engineering, frequently turning complex healthcare data requirements into auditable, production-ready systems. His background in biology gives him an uncommon domain lens for solving clinical and regulatory data challenges.
8 years of coding experience
10 years of employment as a software developer
California State University, Sacramento
Github Skills (11)
schema-design10
schema10
sql10
database-design10
db-schema10
mysql10
database-schema10
kafka9
database-migration9
database-migrations9
test-automation8
Programming languages (3)
Github contributions (5)
umami-software/umami
Jun 2022 - Jan 2023
Umami is a simple, fast, privacy-focused alternative to Google Analytics.
Role in this project:
Back-end Developer & Database Engineer
Back-end Developer & Database EngineerContributions:14 reviews, 62 commits, 47 PRs in 7 months
Contributions summary:Francis primarily contributed to database schema updates and the initialization of migration files for a MySQL database, demonstrating knowledge of database design and version control. They implemented and modified database tables related to user accounts, events, pageviews, and sessions. Furthermore, the user's code introduced test logic, particularly within the context of a session producer, showcasing their familiarity with building or testing producer-consumer systems using Kafka.
chartsanalyticsstatisticsprivacyprivacy-focused
franciscao633/umami
Apr 2023 - Feb 2024
Umami is a simple, fast, privacy-focused alternative to Google Analytics.
Contributions:14 pushes, 1 issue in 9 months
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.