Andy Lau Email & Phone Number

Philadelphia, Pa, Us

Philadelphia, Pennsylvania, United States

Developing a web application using Python's microframework Flask, specifically designed to streamline the process of filling out Group Insurance Summary Excel Reports for employers.The app simplifies data entry by requesting only essential information, using it to retrieve JSON data through REST API calls. It then parses the JSON data to generate a comprehensive and visually appealing spreadsheet. Finally, it ensures a clean and efficient experience with Bootstrap integration.Upon completion, employers can expect a significant boost in their report completion by 3000%, delivering monthly time savings of over 60 hours for the company. This would result in a remarkable improvement in productivity and convenience.

Lehigh, Pennsylvania, United States

Writing Python scripts to enhance the download and formatting of over 5,000 high-quality Lehigh University-related YouTube videos using multi-threading, Pytube, youtube-dl, and FFmpeg APIs to optimize the process and improve overall performance.Utilizing OpenAI's Whisper API to script the transcription of videos and podcasts, ensuring accurate and accessible archives. Developed Python scripts to facilitate the downloading and conversion of podcasts from RSS feeds, utilizing the Internet Archive's API. Streamlined the metadata transformation process, aligning it with the schema used by Lehigh's Islandora Digital Collections Repository. Designed a user-friendly Python GUI using Tkinter and PySimpleGUI. This interface resulted in a significant 200% increase in efficiency for accessing and downloading podcast metadata in CSV format.Played a pivotal role in managing and transforming data archives by writing Python scripts for data conversion and enhancing efficiency through the use of various libraries and APIs.

Bethlehem, Pennsylvania, United States

Weekly, grade assignments and provide targeted feedback to 20 students on Java and Object-Oriented Programming (OOP).Enhance understanding and mastery of Java and OOP through personalized feedback.Offer two hours of dedicated office hours each week for individual support in Java programming.

Lehigh, Pennsylvania, United States

Weekly, assess assignments and provide constructive feedback to 15-20 students on Data Structures and Algorithms.Ensure thorough comprehension and mastery of the material through detailed feedback.Conduct two hours of office hours each week for personalized assistance in Data Structures and Algorithms.

Bethlehem, Pennsylvania, United States

Lehigh, Pennsylvania, United States

Secured over $18,000 in club funding through successful grant applications and creative fundraising approaches, ensuring the club has the financial support needed to thrive and expand. Allocated a budget to facilitate the attendance of more than 10 students at the SASE Professional National Conference, resulting in a remarkable 1000% surge in student participation from previous years.Expertly managed budgets and spending, maintained financial records, carefully analyzed budgets, and allocated funds wisely to ensure the club's financial stability and growth.

Lehigh, Pennsylvania, United States

Planned professional development and cultural events for a student body of over 60 members. This involved organizing engaging activities that aligned with the goals and missions of SASE.Served as a mentor for 4 interns, providing guidance and support for their projects and events related to SASE missions. Gained valuable leadership, networking, and communication skills, by fostering their growth and development, Hosted monthly Mentor-Mentee events, which not only facilitated bonding and relationship-building among students but also contributed to their professional development. These events provided a platform for meaningful interactions and knowledge exchange, further promoting the SASE community.

Lehigh, Pennsylvania, United States

Developed and gained valuable leadership, communication, and professional skills through active involvement in the club and with external university organizations. Leveraged these skills to successfully manage fundraising efforts, increase the budget for future events, and effectively handle funding and cost logistics using spreadsheets and Excel.

Philadelphia, Pennsylvania, United States

Mentored over 80 middle-grade students, fostering their critical thinking and leadership abilities in the areas of robotics, science, and basic programming. Emphasize hands-on activities and real-world applications of STEM concepts, cultivating a growth mindset and self-efficacy among the students.Collaborated with fellow educators to create an inclusive learning environment that celebrated diversity, encouraged curiosity, and promoted mutual respect and understanding.Received positive feedback from students, parents, and colleagues, acknowledging the significant improvements in students' academic performance, social skills, and confidence.

Philadelphia, Pennsylvania, United States

Helped enhance asthma surveillance in Pennsylvania by identifying data sources and refining collection methods using R. This required data cleaning and preprocessing tasks to prepare large datasets for analysis and modeling.Successfully uncovered valuable patterns and trends in asthma-related variables by building impactful statistical models and visualizations in R.Actively participated in daily stand-up meetings, providing regular progress updates and effectively addressing any challenges or obstacles during the project.

Philadelphia, Pennsylvania, United States

Bachelor'S Degree, Computer Science, Senior

Activities and Societies: Society of Asian Scientists and Engineers (SASE), Lehigh Library Special Collections, Lehigh University Student.

High School Diploma, 3.98

Activities and Societies: Mobile Developer for Student Start-Up, Track & Field, 2nd Trumpet in Orchestra, Eco Club Rep, Woodworking