John Yao
Biography:
Work Experience: 1.1 years
Work history:
Job Title: Mobile Developer Intern
Company: Ocean Floor
Period: December 2022 - March 2023
Role Description:Developed a mobile application using React Native that effectively fetched data from MySQL database and AWS
Amplify, providing real-time data visualization and analysis for users.
• Utilized ExpressJS to build a reliable and secure backend that ensured the smooth functioning of the application and
optimized its performance.
• Implemented intuitive user interfaces and interactive features, enhancing the overall user experience and usability of the
mobile application.Job Title: Full Stack Developer Intern
Company: Ocean Floor
Period: September 2022 - December 2022
Role Description:Built a responsive website using React using Firebase API to create and manage user accounts and enhance user
engagement and retention.
• Utilized Firebase Authentication for user login and registration, ensuring a secure and user-friendly experience.
• Implemented custom pages for users that allowed for easy access to features such as social media icon links and profile
pictures, stored and retrieved from the Firestore database and Firebase storage.
Job Title: Teaching Assistant
Company: University of Texas at Dallas
Period: August 2022 - December 2022
Role Description:Effectively graded student assignments and maintained accurate attendance records from attendance project.
• Leveraged strong communication skills to deliver engaging and informative presentations to a diverse classroom size of
approximately 30 students.
• Assisted in setting up learning environments and provided technical support to students and faculty during different
learning periods.Job Title: EPICS Mentor
Company: University of Texas at Dallas
Period: August 2024 - present
Role Description:• Mentored 3 student teams, guiding them through project development in database design, web app
technologies, and other tech stacks, ensuring successful progress toward their semester goals.
• Led workshops focused on essential development practices, offering guidance on project architecture, best
coding practices, and workflow optimization to support team projects.
• Collaborated with sponsors to review team project plans, design milestones, and progress reports, providing
feedback to improve technical solutions for non-profit organizationsJob Title: Product Analyst Intern
Company: Tyler Technologies
Period: May 2024 - August 2024
Role Description:• Developed API integrations for Jira, GitHub, and SonarQube to automate the fetching of metrics data,
reducing manual intervention and ensuring real-time updates.
• Designed and implemented a comprehensive data warehouse using SQL to create a centralized repository to
efficiently store and manage the fetched data, supporting large-scale data analysis and reporting.
• Leveraged Power BI to conduct in-depth data analysis, generating accurate and actionable insights to help facilitate
data-driven decision-making for stakeholders.
Education:
University of Texas at Dallas
Bachelor's Degree – Computer Science
Period: August 2019 - May 2023
University of Texas at Dallas
Master's Degree – Computer Science
Period: August 2023 - present
if you are a job seeker click here