Software Engineer

Bian Lee

949-***-**** ***********@*****.*** bianlee.me linkedin.com/in/bianlee github.com/bianlee Education

University of California, Davis Davis, CA

Bachelor of Science in Computer Science and Engineering, Minor in Economics June 2025

• Object-Oriented Programming, Data Structures & Algorithms, x86 Assembly, Discrete Math, Computer Network Fundamentals, System Administration (Linux), Databases, Calculus III, Linear Algebra, Probability Theory Experience

Data Analyst Intern June 2023 – Present

California Air Resources Board Sacramento, CA

• Performed QA/QC on datasets (10K+ records), and assisted system migration to .NET infrastructure from PHP

• Queried CSV data using SQL statements and generated analytical reports using Excel and Python scripts

• Developed a calculator to compute emission reduction values for projects, reducing manual tasks by 90%

• Updated 3 organization webpages with Drupal CMS and drafted 11 internal documentations on Community Air Protection (CAP) reporting processes, and on Executive Orders, in compliance with State regulations Software Engineer Oct 2022 – June 2023

AggieWorks Davis, CA

• Engineered an end-to-end CRUD web application, as the founding engineer within the Clubly team

• Implemented backend infrastructure, database schema and API using GORM with CRUD functionality

• Implemented front-end modal UI with conditional rendering using ReactJS (legacy) then Svelte

• Wrote internal scripts in Golang, to query number of API calls made at each REST endpoint Analyst Intern Nov. 2022 – June 2023

Vestr Clemson, SC

• Led sell-side stock equity research through DCF model, market sentiment & industry analysis

• Published weekly company newsletters & daily market summaries in the Web3/DeFi/Crypto sector

• Worked directly alongside Founder/CEO and the lead developer in this Seed Series A startup Technical Mentor Oct 2021 – Mar 2022

Southern California Community College Consortium on Cybersecurity Irvine, CA

• 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 Projects

DSM-5 Diagnostic Chatbot GPT-3.5 Turbo, Pinecone, Langchain, MongoDB Jun 2023

• Used LLM to parse through DSM-5 with semantic search, with data stored as vector embeddings. Used OpenAI’s engines to create an interactive chatbot with diagnostic ability. Built front-end with Next.js

• Wrote Python scripts using Beautiful Soup, to scrape web data on Yelp. Stored this data on MongoDB Atlas, and implemented API endpoint using NodeJS. Used Jupyter Notebook + Matplotlib for analysis & visualizations. Decentralized Exchange & ERC-20 Token Solidity, Web3.js, React, Truffle Suite Dec 2022

• 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 token for ETH using Metamask wallet EdTech App ReactJS, MongoDB, NodeJS, Firebase Auth Jan 2022

• Independently developed an EdTech CRUD application on MERN stack with Firebase authentication

• Launched on Product Hunt, and onboarded 18 non-profits on the platform. Received 22k+ total visitors

• Won monetary prize & mentorship from business consultant, Silicon Valley SVSCORE (Mentor: Chuck Scifers) Skills & Awards

Languages: Java, C, C++, Python, JavaScript, Golang, Shell Script, Solidity, SQL, HTML, CSS Frameworks: React.js, Next.js, Node.js, Express.js, Web3.js, D3.js, Git, MongoDB, TailwindCSS, Drupal, Jupyter Notebook, PostgreSQL, Svelte, BeautifulSoup, Postman, Pinecone, Langchain, .NET, Docker, Microsoft Excel Awards: UC Davis Dean’s Honors List (College of Engineering), UC Davis Little Bang! Pitch + Poster Competition Winner (Awarded $1K) at Graduate School of Management, Socal Cyber Cup 3rd Place (Awarded $2.5K) Certification: CompTIA IT Fundamentals+, Jira Software Fundamentals

Contact this candidate