Andrew

Lam

Rosemead, CA 91770 · (626) 856-9689 · andrewlam2193@gmail.com

Hello! I'm Andrew Lam, currently studying Computer Science at Cal Poly Pomona, with a focus on software engineering, web development, and data engineering. I enjoy working with code and creating applications using languages like Python and JavaScript.

I am experienced in developing dynamic web applications and automation scripts. Proficient in HTML, CSS, JavaScript, Python Flask, ReactJS, and MySQL. Skilled in enhancing operational efficiency through workflow automation. Adept at collaborative problem-solving and agile methodologies. Ready to contribute skills to drive impactful results in challenging environments.

Experience

Software Engineering and Automation Intern

Southern California Edison

Developed full-stack web applications (HTML, CSS, JavaScript, Python Flask, ReactJS, MySQL) for seamless database interaction and streamlined workflows. Designed data pipelines using Apache Airflow, saving 180 hours annually. Engineered efficient Python scripts, reducing colleague workload by 25%. Automated tasks with Power Automate, Excel, Office Scripts, and VBA Macros, improving operational speed by 80% and accuracy by 90%.

May 2023 - Present

Coding Instructor

Code Ninjas

Delivered interactive instruction in Javascript and C#, emphasizing key game development concepts. Additionally, I offered personalized support to small groups (1-5 students), ensuring close monitoring of progress and delivering detailed feedback to parents. Collaboration was a cornerstone of my role, as I effectively worked with 2-3 colleagues to establish a positive and safe learning environment. During this experience, I honed proficiency in the Unity Game Engine, showcasing scripting skills and integrating diverse assets such as 3D models, textures, and audio files for comprehensive game development.

January 2022 - May 2023

AT&T Summer Learning Academy Externship

AT&T

Engaged in a comprehensive 4-week program focused on enhancing professional development and exploring diverse career fields. Throughout this experience, I actively participated in online workshops and attended live seminars, immersing myself in valuable insights related to career and self-development. This initiative equipped me with a well-rounded understanding of various professional pathways and honed essential skills for personal growth in the ever-evolving landscape of career development.

June 2020 - July 2020

Projects

Secure Chat Application

Real-time Communication, Security, Web Development

Developed a secure, real-time chat application enabling users to communicate in chat rooms. Implemented using React (TypeScript) for the frontend and Python Flask for the backend. Features secure WebSocket connections and user authentication via Gmail. Utilizes Heroku Postgres for data persistence, ensuring secure and efficient storage of messages and user profiles. Deployed on Heroku, facilitating easy management and access.

Heroku, Python, ReactTSX, WebSockets

Job Application Status Tracker

Web Development, Database Management, API Integration

Engineered a web application for tracking job application statuses, simplifying the job search process. The frontend is built with React, providing a user-friendly interface, while the backend API, developed in Python Flask, handles interactions with the database and external services. Features include comprehensive job application management and integration with OpenAI services. Utilizes PostgreSQL for database management, deployed with a focus on enhancing user experience in job tracking.

React, Flask, PostgreSQL, OpenAI API

Spotify API Application - In Progress

Web Development - API Integration

A React TypeScript application that integrates with the Spotify API to offer music recommendations. It utilizes Tailwind CSS for styling and serverless functions hosted on Vercel for backend operations, including OAuth authentication and search functionality. This setup enables a seamless and responsive user experience for exploring Spotify's vast music library.

Fullstack, Spotify API, Serverless Functions

Music Recommender System

Software Engineering, Cloud Services, Machine Learning

Led a team of four in creating a collaborative music recommender app. Utilized Azure Web Services, Functions, and CosmosDB for scalable, serverless computing, and efficient database access. Engineered a recommendation system with advanced algorithms and content-based filtering for personalized song suggestions based on user input tags. Integrated Spotify API to enhance user interaction and improve recommendation accuracy.

Azure, Python, ReactJS

Feed Me - Mobile Application

Mobile Application Development

Created and launched the mobile app "Feed Me" using Dart and the Flutter framework, allowing users to explore restaurants through a swipe-based interface. Implemented user authentication features with Flutter and Dart for privacy and data security. Integrated seamlessly with a backend database for storing and retrieving user profiles, preferences, and restaurant information.

Flutter, Dart, Firebase

React TSX - Calculator

UI Development with React TypeScript

Created and launched a simple ReactTSX calculator application

React, Typescript

Education

California State Polytechnic University Pomona

Bachelor of Science
Computer Science - Software Enginering Track
Honors - President's List | Dean's list

GPA: 3.91

August 2020 - May 2024

San Gabriel High School

High School Diploma

GPA: 3.8

August 2016 - May 2020

Skills

Programming Languages & Tools
Workflow
  • Mobile-First, Responsive Design
  • Cross Browser Testing & Debugging
  • Cross Functional Teams
  • Agile Development & Scrum

Interests

Beyond coding, I play tennis, badminton, and go rock climbing. My hobbies also include tinkering, building, crafting, and staying up to date on the latest technology. This blend of physical and creative pursuits fuels my curiosity and keeps me energized. I'm eager to connect with individuals who share an interest in software and technology.

In the constantly evolving world of technology, I thrive on staying at the forefront. Exploring the latest tech trends isn't just a hobby; it's my passion. Let's dive into conversations about our tech experiences and the fascinating developments shaping the field. I'm eager to connect with like-minded individuals who share a genuine enthusiasm for software and technology. Together, we can navigate this exciting journey of innovation and discovery.