Andrew Lai

- Managed a 3-person cross-functional analytics team to align a BI data analysis product’s capabilities with market demand, analyzing 80+ pages of qualitative/quantitative data to identify high-impact customer segments/adoption opportunities - Drove cross-team coordination and stakeholder communication, converting complex datasets into a concise executive-level deliverable that clarified product positioning and reduced ambiguity around launch strategy

- Led end‑to‑end design and deployment of scalable backend systems using Docker (containerization), MySQL, Linux VMs, and RESTful APIs to improve data usage monitoring between LibreNMS and Sonar, cutting customer data‑request calls by 35% - Installed, configured, optimized, and conducted hands-on testing for Cisco and Ubiquiti network infrastructure, including fiber (Cat6/fiber) and wireless backhaul (Wave Pro/Siklu), ensuring high-availability and low-latency connectivity for enterprise clients - Applied debugging, testing, and root-cause analysis, Linux administration, TCP/IP, OSPF, ARP, and BGP knowledge to configure and optimize multi-vendor network environments (Cisco, Ubiquiti), ensuring security, high availability, and low latency - Led a company-wide data audit, remediating $30,000+ in billing errors through clear cross-departmental verbal communication skills and building strong working relationships with stakeholders - Led cloud platform migration (SharePoint/Entra ID) migration for 20+ employees at Phlur, covering SharePoint, OneDrive, and security integrations, balanced technical execution with cybersecurity planning and end-user training to ensure smooth adoption - Built and implemented a streamlined cloud-based IT documentation system, integrating ConnectWise Automate RMM for patching, alerting, and maintenance; reduced average ticket resolution time by 30% through well‑structured documentation - Scripted DevOps infrastructure tasks via PowerShell and Python, integrated DNS lookup capabilities into phpIPAM and Graylog, leading to improved application system integration and DevOps workflows - Diagnosed and solved problems involving SFPs, radios, UPS systems, and misconfigured equipment under tight deadlines, demonstrating time management skills, resourcefulness, and multi-platform problem-solving skills - Assisted with planning network expansion into new data centers, contributing to capacity forecasts and vendor evaluation

- Performing data analytics through the combination of various data sources such as Sonar, ROE Agreements, and various other sources (such as utilizing Python with GraphQL APIs), improving how the company views data - Data modeling through the use of Google Sheets and G-Suite products, working to increase revenue and decrease inefficiencies - Automated Sheets workflows by deploying custom JavaScript (Google Apps Script), streamlining data processing - Began Cisco Certified Network Associate training, learning network security, IP connectivity, routing, and other curriculum, allowing me to expand my role in the company

- Cleaned living spaces by mopping, vacuuming, sweeping, doing dishes, and general cleaning of restrooms and kitchen areas, creating a safer and sanitary living environment - Assisted with pet care including feeding and excrement removal and maintenance of care facilities, reducing stress on the elderly and increasing customer satisfaction - Managed medicine dosages and scheduling, resulting in healthier clients (weight loss, lower blood pressure, etc) - Cleaned outdoor areas of leaves and assisted with general gardening and trimming, reducing physical burdens on the client while maintaining strong aesthetic - Helped to ensure mail flowed as intended, resulting in financial savings and increased organization

- Assisted with center upgrades such as furniture building and document organization, resulting in a more efficient, aesthetic, and organized workplace - Cleaned center equipment before closing, which ensured a clean, optimal, and safe environment for students - Tutored students in various math and reading skills through the use of patient and clear explanations and ensuring student understanding, resulting in significant academic improvements -Logged, graded, and organized student assignments to calculate and prepare future student workload intensity and quantity, increasing efficiency using new record-keeping methods - Designed instructional math reference sheets in Microsoft Word, quantitatively boosting student mastery scores

- Designed intricate mission proposal presentation based on existing technologies alongside a team - Developed a detailed budget breakdown and resource management log - Presented and designed a detailed slideshow regarding the technical descriptions of various space exploration technologies such as the Advanced Resistive Exercise Device - Completed Capstone Project at Langley Research Center by developing a solution to power issues in Advanced Air Mobility - Managed team deadlines and tasks to ensure a quality presentation, demonstrating leadership and organizational skills - Researched betavoltaic power generation devices and their applications to automated drone technology - Presented and designed a detailed presentation for NASA Subject Matter Experts showcasing advanced knowledge and understanding of Advanced Air Mobility

- Learned about OS and networking basics such as the OSI model, process scheduling, and memory management. - Completed reading "High Performance MySQL: Optimization, Backups, and Replication" 3rd Edition. - Completed various labs, including automating data report emails with Python and Batch scripts and starting up Percona clusters using MySQL Docker images. - Learned basic AWS services such as EC2 and Aurora. - Completed other MySQL-related labs, including backing up and restoring from other Percona cluster nodes, data dumping with tools such as mysqldump, and benchmarking with tools such as mysqlslap

- Developed CFO policies: Procurement and Non-Employee Travel & Entertainment, enhancing financial governance - Resolved bank account draw amount errors for a $15M laboratory facility, preventing future errors and increasing work-flow efficiency - Assisted in comprehensive document collection, analysis, and management for diverse financial initiatives, including investor reporting for a biotech start-up, contributing to a successful $39M Series A equity raise - Fulfilled document requests for a $12M capital equipment leasing program (Excedr), advancing financial planning - Structured a venture debt transaction (Silicon Valley Bank), helping secure $7.5M in funding - Generated drafts for the 2023 Annual Budget using Microsoft Excel and leveraging previous financial data - Provided effective schedule organization and email management support to the CFO, saving time and increasing organization

- Delivered exceptional customer service to students’ families by performing quality property maintenance, enhancing school safety and aesthetic - Enhanced aesthetics and functionality of structures through ceiling, door, wall, and paint repairs, resulting in increased parent, student, and teacher satisfaction - Contributed to a safe and productive learning environment for students and staff, improving learning experiences for students and faculty

Attended this high school for four years and graduated with a weighted cumulative GPA of 4.5.