Andrew Lai Email & Phone Number

Sierra Madre, Ca, Us

Sierra Madre, Ca, Us

Pasadena, California, United States

- Perform 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

- 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… Show more - 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 Show less

Pasadena, California, United States

- 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… Show more - 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 Show less

Pasadena, California, United States

- 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… Show more - 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 Show less

- 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… Show more - 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 Show less

Los Angeles Metropolitan Area

- 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… Show more - 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 Show less

Pasadena, California, United States

- 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

Associate Of Arts - Aa, Engineering And Technology

Activities and Societies: Engineering Competition Society, Essay Tutor and Proofreader

High School Diploma

Activities and Societies: Academic Decathlon, Varsity Track and Field Co-Captain, Varsity Speech Co-Captain, Mu Alpha Theta, National.