Bian Lee
I am a 2nd year undergraduate student at University of California, Davis, pursuing B.S. in Computer Science and B.A. in Economics. My interests range from software engineering, data analytics, venture capital, cybersecurity, fintech and Web3/DeFi. I also compose and produce music. Please reach me via email at bianlee2004@gmail.com.
Work Experience
Data Analyst Intern
-
California Air Resources Board
Jun 2023 - Present • Sacramento, California
- Thoroughly performed QA/QC procedures on 6 datasets (10K+ records) and compiled reports on aggregate air pollution emissions during the annual CAP reporting cycle, under Carl Moyer Memorial Air Quality Standards Attainment program
- Reduced manual data entry by ∼80% by streamlining an automated importing system from database to front-end interface
- Queried/parsed CSV data from backend using SQL and wrote Python scripts to develop data pipelines
- Conducted software testing on 10+ features of CARL database management system and communicated critical findings
- Completed cost-effectiveness analysis on Excel to calculate emissions and grants values for State-funded projects
Software Engineer Intern
-
Optimizing.com
Nov 2023 - Feb 2024 • Austin, Texas
- Led backend development of CRM dashboard for 10+ SMB business clients with Stripe integrations for financing payments
- Reduced code redundancy by ∼20% through refactoring reusable components and employing nested routes in Remix
- Designed 6 relational (one-to-many) schemas in Prisma for customers/checkouts and implemented API endpoints with Action/LoaderFunctions to listen to HTTP requests and allow CRUD operations
Analyst Intern
-
Vestr
Nov 2022 - Jun 2023 • Clemson, South Carolina
- Conducted sell-side stock equity research through Discounted Cash Flow model and market sentiment/industry analysis
- Edited and published weekly company newsletter and delivered +73% subscriber count growth
- Worked directly alongside Founder/CEO & Engineer in the Series A startup
Club & Extracurricular Experience
Software Engineer
-
AggieWorks
Oct 2022 - Jun 2023 • Davis, California
- Established backend infrastructure of Clubly.org by designing schemas, writing queries in GORM, and building API routes
- Implemented front-end UI components (modal, cards, navbar, search) with conditional rendering using Svelte
- Wrote internal scripts in Golang, to track and query number of API calls made at every REST API endpoint
Technical Mentor
-
SoCal Community College Consortium on Cybersecurity
Oct 2021 - Mar 2022 • Irvine, California
- Collaborated with professors from Irvine Valley College’s Computer Information Management (CIM) department to
create prepatory CyberPatriot (security competition) materials, as a national semifinalist in the previous season
- Wrote 15 CTF problems & solutions for org-wide contests, on topics of cryptography and Linux OS
- Developed training VM images for Ubuntu OS using Ansible and Shell Script
Education & Relevant Coursework
University of California, Davis
-
B.S. Computer Science, B.A. Economics
'22 - 26 • Davis, California
Object-Oriented Programming in C++, Programming & Problem Solving, Data Structures & Algorithms, Computer Architecture, Machine-Dependent Programming in x86 Assembly, Discrete Mathematics, Human-Computer Interaction, Probability Theory, Linear Algebra
Irvine Valley College
-
Dual Enrollment, GPA: 4.0
'20-22 • Irvine, California
CIM 160: Computer Network Fundamentals
CIM 161: Systems Administrator (Linux)
CIM 110: Information and Technology Essentials
CIM 115: Databases
ENTR 200: Entrepreneurship
BIO 1: The Life Sciences
BIO 3: Humans and the Biological World
ASTR 20: General Astronomy
Fullerton College
-
Dual Enrollment, GPA: 3.8
'20-22 • Fullerton, California
MATH 151: Calculus I
MATH 152: Calculus II
ARCH 111: Introduction to Architecture
BUS 186: Business Economics
CIS 111: Introduction to Information Systems
BUS 186: Funding Projects and New Ventures
Saddleback College
-
Dual Enrollment, GPA: 4.0
'21 • Mission Viejo, California
PSYC 1: Introduction to Psychology
Northwood High School
-
GPA: 3.9UW/4.2W
'22 • Irvine, California
Philharmonic Orchestra, Choir, Engineering Club (VP), Cybersecurity Club (VP), Musicians United for Service and Entertainment (Events Coordinator), Model UN (Treasurer), Startup Club (Treasurer)
Technical Projects
Yoga Form Detection/Correction Model with Real-Time Video Feed
Used TensorFlow’s PoseNet model to build a live webcam feed that tracks body points in relative coordinates, comparing them against a ML model trained on images of correct yoga forms to give generative feedback through Gemini API + ElevenLab's text-to-speech model.
TensorFlow, Gemini API, ElevenLabs, Flask, Next.js, Supabase
DavisRideShare.com
Built a full-stack application that allows UC Davis students to find ridesharing on campus and save on transportation cost.
Next.js, Supabase
Mentor/Mentee Real-Time Communication App
Developed and launched a full-stack social application designed to pair mentees with mentors (students with alumni), integrating authentication, real-time 1:1 messaging, profile creation/editing, searching, and filtering capabilities. Submission for ECS164 term project.
Next.js, Supabase
DSM-5 Diagnostic Chatbot with Semantic Search
Leveraged LLM to parse through DSM-5 with semantic search, storing data as vector embeddings in Pinecone database. Fine-tuned OpenAI’s GPT-3.5 turbo and used React in Next.js to create an interactive diagnostic chatbot. Executed Python scripts in Beautiful Soup to scrape web data of nearby physicians & clinics, storing them as key-value documents in MongoDB. Built and Served NodeJS API and used Axios library to fetch & render data on screen.
GPT-3.5 Turbo, Pinecone, Langchain, MongoDB
Decentralized Exchange and ERC-20 Token/Tokenomics
Wrote smart contracts in Solidity to create a custom ERC-20 token & tokenomics and a decentralized exchange. Implemented Constant Product Market formula used in Automated Market Making (AMM) systems, and deployed on Ethereum blockchain (mainnet) to allow users to trade custom token for ETH using Metamask wallet.
Solidity, Web3.js, React, Truffle Suite
EdTech App (opensourcecollage.com)
Independently built a full-stack EdTech app that allows browsing & sharing extracurricular and volunteer opportunities. Onboarded 18 non-profits and received 22k+ total visitors on the platform, after launching on Product Hunt. Received monetary prize & mentorship from business consultant, Silicon Valley SVSCORE (Mentor: Chuck Scifers).
MongoDB, Express.js, React.js, Node.js (MERN), Firebase
D3.JS SVG-map
An interactive map on the front-end that plots city coordinates upon user input, and renders a SVG map (with pan & zoom functionality) using D3.js library and svg-pan-zoom.
Next.js, D3.js
EmpireWebSpace (empireweb.space)
Founded 7-member web agency currently doing pro bono work for local non-profits.
Next.js
InterSTEM 501(c)(3) website (interstem.us)
Led the development of organization website and managed a tech team of 6. Published 148 articles and received 200k+ views.
Jekyll, Markdown, and SCSS
NHS Cybersecurity Club website (nhscyber.club)
HTML, CSS, JavaScript, Bootstrap
This portfolio site (bianlee.me)
Jekyll, SCSS, Markdown
Awards & Certifications
- UC Davis Dean’s Honors List (College of Engineering)
- UC Davis Little Bang! Pitch + Poster Competition Winner at Graduate School of Management (Awarded $1K)
- Cyber Skyline SoCal Cyber Cup 3rd Place (Awarded $2.5K)
- CyberPatriot National Semifinalist
- CompTIA IT Fundamentals+ Certification
- Jira Software Fundamentals Certification
- AP Scholar with Distinction
Skills
- Languages: Python, Java, C, C++, JavaScript, TypeScript, Golang, Solidity, SQL, HTML, CSS
- Framework: React.js, Next.js, Remix, Node.js, Express.js, Web3.js, D3.js, Git, GitHub, MongoDB, Tailwind, Drupal, Jupyter Notebook, PostgreSQL, Svelte, BeautifulSoup, Postman, Clerk, Supabase, Docker, Zustand, Linux, Microsoft Excel
- Native Fluency in English and Korean