Astro Yan

Product Designer

Astro Yan

Product Designer

Astro Yan

Product Designer

VulcanSQL | Jul 2023 – Nov 2023

VulcanSQL | Jul 2023 – Nov 2023

Data API framework: Build dynamic API directly from database/data warehouse without code

Data API framework: Build dynamic API directly from database/data warehouse without code

I worked on interviewing with global data engineers/analysts and creating product marketing materials and UI for enterprise product and open-source projects. Got 600+ GitHub stars and generated 50+ qualified leads.

I worked on interviewing with global data engineers/analysts and creating product marketing materials and UI for enterprise product and open-source projects. Got 600+ GitHub stars and generated 50+ qualified leads.

Background

Background

About VulcanSQL

About VulcanSQL

VulcanSQL is one of Canner's open-source project. It serve as an analytics API builder, allowing data teams to create scalable analytics APIs from data warehouse using only SQL, without writing any backend code.

VulcanSQL is one of Canner's open-source project. It serve as an analytics API builder, allowing data teams to create scalable analytics APIs from data warehouse using only SQL, without writing any backend code.

Responsibilities

Responsibilities

  • Research data market trends.

  • Conduct user interviews with data engineers and analysts.

  • Craft UI and product marketing materials.

  • Research data market trends.

  • Conduct user interviews with data engineers and analysts.

  • Craft UI and product marketing materials.

Problems

Problems

01

01

Custom API development is time-consuming because developers must manually code the APIs.

Custom API development is time-consuming because developers must manually code the APIs.

02

02

Integrating multiple data sources with different formats and protocols requires significant effort.

Integrating multiple data sources with different formats and protocols requires significant effort.

03

03

Ensuring that APIs are secure and that data access complies with regulations (e.g., GDPR, HIPAA) requires additional layers of work, including authentication, authorization, and data encryption.

Ensuring that APIs are secure and that data access complies with regulations (e.g., GDPR, HIPAA) requires additional layers of work, including authentication, authorization, and data encryption.

Design DeliverableS

Design DeliverableS

Core Experience

Core Experience

Select a dataset and setup the API basic information.

Select a dataset and setup the API basic information.

Define the parameters and response columns.

Define the parameters and response columns.

Preview data.

Preview data.

Simulate API query parameters to get data.

Simulate API query parameters to get data.

Get response data.

Get response data.

API lists.

API lists.

Add business metadata to the API.

Add business metadata to the API.

Search API by metadata.

Search API by metadata.

Product Marketing Materials

Product Marketing Materials

Impacts

Impacts

50+

50+

Qualified leads

Qualified leads

600+

600+

GitHub stars

GitHub stars

Feel free to reach out, I’d love to chat with you!

I'm all about meaningful connections and exciting products.
Ready to team up? Contact me!

Feel free to reach out, I’d love to chat with you!

I'm all about meaningful connections and exciting products.
Ready to team up? Contact me!

Feel free to reach out, I’d love to chat with you!

I'm all about meaningful connections and exciting products. Ready to team up? Contact me!

Create a free website with Framer, the website builder loved by startups, designers and agencies.