About Me

Hi, I'm David Chan—a versatile professional bridging finance and software development. As a results-driven Software Engineer with expertise in Ruby on Rails, JavaScript, React, Python, and PostgreSQL, I have successfully launched new features, enhanced functionality, and optimized performance. Coupled a background in accounting and having a strong passion for innovative projects, I bring a collaborative mindset and analytical prowess to every opportunity.

Skills


Work Experience

Corporate Accountant / Payroll Manager | Masterworks (04/2024 - Present)

Alteryx - Workflow Automations

Created custom Alteryx worfklows to automate tedious accounting tasks, including account reconciliations, flux analysis, and creating journal entry files to upload into NetSuite.

Python Scripts - Automations

Developed Python scripts to connect to Goldman Sachs and JP Morgan's APIs to fetch daily transactions for reconciliations and update cash dashboard for key stakeholders in real time.

Rippling - Payroll Implementation

Led Rippling implementation as the new payroll software for Masterworks, with an emphasis on automation to increase efficiency and accuracy.

Junior Software Engineer | Workforce.com (07/2022 - 07/2023)

Points Based Attendance

Implemented new feature in Rails for attendance tracking and behavior monitoring. Integrated Stimulus into the desktop codebase, resulting in a remarkable 30% increase in organic search traffic and heightened interest from potential clients.

Workday Integration

Led the enhancement of a Workday Integration, ensuring data precision, orchestrating weekly client engagements, and achieving a substantial 70% reduction in data export times.

Payroll

Secured sensitive client data through encryption and crafted an intuitive UI for seamless integration with the payroll system using Hotwire and Ruby on Rails.

Accountant | Zumper (09/2019 - 09/2021)

Stripe Integration

Led the integration of Stripe for digital payment collections, resulting in increased cash application efficiency and a significant reduction in Days Payable Outstanding (DPO).

Account Reconciliations

Performed monthly reconciliations using Excel and implemented corrective measures through the creation of journal entries and credit memos in NetSuite.

Invoice Management

Produced monthly financial invoices, utilizing functionalities within Excel and NetSuite.

Personal Projects

ShowSeeker

 Flask, Python, React, Redux, JavaScript, PostgreSQL, Ticketmaster API

A full-stack application inspiried by Ticketmaster.

Pawzon

 Ruby on Rails, React, Redux, JavaScript, PostgreSQL

A full-stack application inspired by Amazon.

NextGlass

 MongoDB, Express.js, React, Node.js

A full-stack application that suggests wines based on your preferences & past favorites.

Education

B.A. Economics & Accounting - Universtiy of California, Santa Barbara
Full-Stack Software Development - App Academy

Interests

When I have some free time, you can find me running, at the gym, snowboarding in the winter, or just enjoying the nice weather outside!