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 organizations 

  • Job 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

Connect
if you are a job seeker click here