Dylan Kai Lau Email & Phone Number

Norco, California, United States

Proposal Processing System DevelopmentLed the development of a robust proposal processing system instrumental in facilitating the allocation of over $40 million towards expediting DoD additive manufacturing research. Engineered a comprehensive solution utilizing PowerApps for seamless proposal creation, a Dataverse relational database for secure and organized proposal storage, and a PowerBI dashboard for in-depth proposal analysis. Implemented a Canvas app for streamlined proposal approval, enhancing efficiency and accuracy in dispersing research funds.Agile Collaboration and Full-Stack Software DesignCollaborated closely with Naval Postgraduate School researchers in an agile environment to conceptualize and design a cutting-edge, full-stack research proposal software. Engaged in weekly demo presentations and actively collected critical feedback to ensure alignment with researchers' evolving needs. Seamlessly integrated feedback into the development cycle, ensuring the software met stringent standards while maintaining adaptability to the dynamic research landscape.

Riverside, California, United States

ETL Process Development and Database IntegrationEngineered a sophisticated Python-based ETL (Extract, Transform, Load) process to meticulously extract, cleanse, and organize data from PDF forms into Excel sheets. Seamlessly integrated this structured data into the college database via a Microsoft Access form, ensuring a smooth and error-free data flow. This innovative process offered an instant flow of data from PDFs to the college database.Database Design and OptimizationLeveraged Access and SQL expertise to craft intuitive forms, generate insightful reports, and execute efficient CRUD (Create, Read, Update, Delete) queries for an existing database comprising approximately 20 tables. Facilitated seamless data retrieval and manipulation while meeting diverse operational needs.

Riverside, California, United States

Comprehensive Group Tutoring and Code AnalysisDelivered in-depth tutoring sessions twice weekly, mentoring groups of up to 10 students per session in Java programming. Employed a hands-on approach, offering comprehensive code analysis and elucidating complex concepts through interactive whiteboarding sessions. Focused on fostering a deep understanding of Java principles and problem-solving strategies, enabling students to tackle challenging coding tasks with confidence.Collaborative Partnership and Student Progress AssessmentEngaged in regular collaboration with the course professor, actively participating in weekly meetings to assess current assignments and identify areas where students required additional support or improvement. Leveraged insights gained from these discussions to tailor tutoring sessions effectively, ensuring alignment with the course curriculum and student learning objectives. Employed a proactive approach to address challenges and enhance the overall learning experience for students.

Riverside, California, United States

USPTO Dataset Transformation and Spatial-Temporal AnalysisEmployed advanced Python programming skills, particularly leveraging Pandas, to streamline and condense the vast USPTO Dataset for Researchers. Processed an extensive repository of over 13 million patents spanning 52 years, curating a focused spatial-temporal dataset comprising 17 thousand patents specifically tailored to the Inland Empire region. This transformation facilitated precise and localized analysis for targeted research endeavors.Visualization and Geographic InsightsUtilized ArcGIS proficiency to generate insightful visualizations, notably creating a heatmap representation of patent data. This visualization method effectively showcased aggregate patent counts per location within the Inland Empire, offering a clear and comprehensive overview of patent distribution and concentration. The heatmap visualization served as a valuable tool for researchers, providing geographic insights critical for strategic analysis and decision-making processes within the research lab.

Temecula, California, United States

Dasher Delivery in Temecula/Murrieta RegionSuccessfully fulfilled 448 orders within the Temecula/Murrieta, California region, demonstrating a commitment to prompt and reliable service. Maintained an exceptional customer rating of 4.93, indicative of consistently high-quality deliveries and exceptional customer satisfaction.Efficient Operations and Professional CommunicationDeveloped adeptness in efficiently managing deliveries while upholding professional communication standards. Maintained clear and courteous interactions with Dasher Support, restaurants, and customers, ensuring smooth coordination and timely completion of tasks.