Andrew Qian, Developer in Washington, DC, United States
Andrew is available for hire
Hire Andrew

Andrew Qian

Verified Expert  in Engineering

Full-stack Developer

Location
Washington, DC, United States
Toptal 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 and enjoys building solutions and solving complex problems. Andrew can adapt effectively to all aspects of a project or work within a team.

Portfolio

Affinity Web Development
JavaScript, Node.js, ColdFusion, SQL, HTML5, CSS, React, Vue, HTML, Bootstrap...
Coupang - Rocket on Demand
JavaScript, Front-end, Java, Back-end, Vue, Python, Spring Boot, Handlebars...
Systems Alliance
HTML5, CSS, JavaScript, PHP, WordPress, WordPress VIP, C#, ColdFusion, Node.js...

Experience

Availability

Part-time

Preferred Environment

Windows, Node.js, Vue, React, TypeScript, ColdFusion

The most amazing...

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

Work Experience

Full-stack Developer

2022 - PRESENT
Affinity Web Development
  • Architected and implemented a new version control strategy for a long-standing 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.
  • Architected and built new systems for a long-standing client, including application performance tracking across 27 websites, a certification tracking system, an OCR check scanner, and more.
  • Introduced and integrated new technologies into a legacy codebase, such as Vue 3, TypeScript, Vite, Git, Azure, and more. Built integrations with 3rd-party APIs and systems.
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, CFML

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, Webhooks, Adobe ColdFusion, Java 8, CFML

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

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 person-hours on planned content updates. I also 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
I built a custom character sheet builder on Roll20, an online role-playing tabletop platform. The builder-generated custom character sheets use React as a static site generator and other build tools to facilitate other Roll20 features and functionalities. I used this system to design and build my own tabletop game system.

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.

Languages

HTML5, CSS, JavaScript, HTML, CFML, 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, AWS CLI, AWS ELB, AWS IAM

Other

ColdFusion, APIs, Web Development, Front-end, Back-end, Full-stack Development, Game Development, Web Accessibility, 2D, 2D Games, Styled-components, Webhooks, 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, AWS ALB

Paradigms

Responsive, DevOps

Storage

MongoDB, PostgreSQL

2010 - 2014

Bachelor's Degree in Economics

The George Washington University - Washington, DC, United States

FEBRUARY 2023 - FEBRUARY 2025

AWS Certified Developer - Associate

Amazon

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring