Andrew Qian, Full-stack Developer in Washington, DC, United States
Andrew Qian

Full-stack Developer in Washington, DC, United States

Member since September 7, 2022
Andrew is a skilled full-stack web developer with four years of professional experience working with clients across several industries and tech stacks. He loves coding, enjoys building solutions, and solving complex problems. Andrew can adapt effectively to all aspects of a project or work within a team.
Andrew is now available for hire

Portfolio

Experience

Location

Washington, DC, United States

Availability

Full-time

Preferred Environment

Windows, Node.js, Vue, React, TypeScript

The most amazing...

...things I've built are a content management tool and framework for a client's client-facing website that saved our and the client's team thousands of hours.

Employment

  • Full-stack Developer

    2022 - PRESENT
    Affinity Web Development
    • Architected and implemented a new version control strategy for a longstanding client.
    • Oversaw a codebase overhaul to a client's email services, touching over 20 code repositories and several thousand files.
    • Built automated tools for code deployment and validation.
    Technologies: JavaScript, Node.js, ColdFusion, SQL, HTML5, CSS, React, Vue, HTML, Bootstrap, jQuery, APIs, Web Development, Front-end, Back-end, DevOps, TypeScript, Adobe ColdFusion, Web Accessibility, Responsive, Gulp, Git, Windows PowerShell
  • Full-stack (Front-end) Engineer

    2022 - 2023
    Coupang - Rocket on Demand
    • Developed a new dashboard for an eCommerce giant for handling fulfillment outsourcing in one of their fastest-growing business divisions.
    • Integrated services and APIs using a distributed microservices architecture.
    • Built a discrepancy handling worker process to detect hundreds of thousands of discrepancies daily.
    Technologies: JavaScript, Front-end, Java, Back-end, Vue, Python, Spring Boot, Handlebars, TypeScript, Spring, Git, Java 8, Gradle, Amazon Web Services (AWS)
  • Full-stack Developer

    2018 - 2022
    Systems Alliance
    • Architected, developed, and delivered a custom content management system for a client.
    • Tasked with learning and understanding a new client's tech stacks and codebases, as well as any new platforms or APIs.
    • Led initiatives to improve developer team practices, such as introducing pair programming, unit testing, and CI/CD.
    Technologies: HTML5, CSS, JavaScript, PHP, WordPress, WordPress VIP, C#, ColdFusion, Node.js, Sass, React, Vue, Git, GitLab, Windows PowerShell, Java, Spring, Bootstrap, Web Accessibility, Responsive, Gulp, Webpack, HTML, jQuery, APIs, Amazon Web Services (AWS), Web Development, TypeScript, Front-end, Back-end, Handlebars, Webhook, Adobe ColdFusion, Java 8
  • Realtor

    2015 - 2018
    Weichert Realtors
    • Successfully closed the largest single real estate transaction in the DC market in 2016.
    • Developed and maintained relationships with clients, including following up on leads, maintaining a database of clients, and providing excellent customer service throughout the buying or selling process.
    • Helped clients buy, sell, or rent properties by providing them with information on market conditions, pricing, mortgages, legal requirements, and other relevant information.
    Technologies: Sales, Real Estate, Residential Real Estate, Commercial Real Estate
  • Freelance Web Developer

    2015 - 2018
    Self-Employed
    • Built and deployed fully functional websites for various clients on a freelance basis.
    • Assisted with deployment, SEO, malware removal, and other extra features upon client request.
    • Helped draft and envision designs and UX for planned redesigns.
    Technologies: PHP, WordPress, HTML, CSS, JavaScript, Python, Web Development, Front-end, Back-end

Experience

  • Custom Content Management System

    I built out a custom content management system with Java and Coldfusion for a large University, which served as their primary method of building out content for thousands of pages. This system seamlessly integrated with their existing systems and significantly improved the editing experience, saving thousands of man-hours on planned content updates.

    Additionally, I built a plugin system where the client could build out their content modules using a JSON-like structure.

  • React Static Sheet Generator for Roll20 Platform
    https://github.com/Tojikan/znz-roll20

    A full-stack system for Roll20, an online tabletop platform, to generate custom character sheets and game systems. I have created a React-based template system for building a front end and a Node.js-based back-end to communicate with a Roll20 API and sheet workers.

  • Bound Unity Game
    https://github.com/Tojikan/Bound

    A PC and mobile video game built with the Unity Engine and C#. I was a primary developer and team leader. Initially, it was a project for learning how to code and build games in Unity. The game included a map editor, downloadable map packs, and downloadable tile sets.

  • Healthcare App

    I acted as the lead developer of a healthcare app built on a custom Java framework with a PostgresSQL and Mongo database. The app connected with multiple third-party APIs and AWS. I took over the development and deployment of this app. Subsequently, I quickly learned and understood the codebase and the DevOps side. Within a few months, I oversaw a complete front-end overhaul of the app, a server migration, and the implementation of numerous features.

Skills

  • Languages

    HTML5, CSS, JavaScript, HTML, SQL, Java, PHP, Sass, TypeScript, Java 8, Python, C#
  • Libraries/APIs

    jQuery, Node.js, React, Vue, Handlebars
  • Tools

    Git, Adobe ColdFusion, GitLab, Gulp, Webpack, Apache Maven, Gradle
  • Other

    ColdFusion, APIs, Web Development, Front-end, Back-end, Game Development, Web Accessibility, 2D, 2D Games, Styled-components, Webhook, Sales, Real Estate, Residential Real Estate, Commercial Real Estate
  • Frameworks

    Unity, Windows PowerShell, Bootstrap, Spring, Spring Boot
  • Platforms

    Windows, WordPress, Amazon Web Services (AWS), WordPress VIP
  • Paradigms

    Responsive, DevOps
  • Storage

    MongoDB, PostgreSQL

Education

  • Bachelor's Degree in Economics
    2010 - 2014
    The George Washington University - Washington, DC, United States

To view more profiles

Join Toptal
Share it with others